Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4

Thread: Php to Ajax

  1. #1
    Regular Coder
    Join Date
    Oct 2011
    Posts
    116
    Thanks
    19
    Thanked 1 Time in 1 Post

    Php to Ajax

    Dear Sir,

    I have following codes. These code wok fine. Is it possible to get table data with ajax. If yes then please help me to modify my code.

    Yes, I want to enter product code in txtsno then want to show product_name in txtpro.
    It must call a AJAX function from onkeydown event of textsno.

    Please help more

    PHP Code:
    <?php
        
    require_once("connect.php");
        
    $productCode "";
        
    $productValue="";
        if(isset(
    $_POST['button1']))
        {
            
    // Get values from form 
            
    $sno =$_POST['txtsno']; 
            
            
    $record_check ="SELECT * FROM test WHERE sno = '$sno' ";
            
    $result=mysqli_query($con$record_check);
            
    $row mysqli_fetch_array($result); 
            
    //conditional statement starts
            
    if(!$row)
                die (
    'No record Found');
            else 
            {
                
    $productValue $row['packing'];
                
    $productCode $sno;
            }                    
            
    // Conditional statement ends
        
    }
    ?>
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml">
        <head>
            <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
            <title>Display data in textboxes</title>
    <!-- Style Sheet part start -->
    <style type="text/css">
    html {
        overflow:auto;
    }
    body {
        background-color:#FFFFFF;
        margin:0 auto;
    }
    #mypopup
    {
        float: left;
        width: 250px; height: 350px;
        background-color:#d5eef4 ;
        border: 1px solid #069;
        text-align:center;
        padding:2px;
        margin-top:150px;
        margin-left:100px;
        overflow:auto;
    }
    #header
    {
        background-color:#3399FF;
        background-position:left center;
        line-height:25px;
        font-size:22px;
        color:#FFFF33;
        font-weight:600;
        border-bottom:1px solid #6699CC;
        padding:10px;
    }
    </style>
    <!-- Style Sheet part end -->
    </head>
    <body>
        <center>
            <div id="mypopup">
                <div id="header">Search Data</div>
                    <div style="margin-top:80px;">
                        <form name="form1" action="#" method="post">
                            <table border=0; cellpadding="1" cellspacing="1" bgcolor="#CCFFFF" align="center" >
                                <tr>
                                    <th>Code</th>
                                    <th width="50px"><input type="text" name="txtsno" id="txtsno" value="<?php  echo $productCode ?>" title="Enter product code" onkeypress="validate(event)" ;  onfocus="this.select()" /></th>
                                </tr>
                                <tr>
                                    <td>Product</td>
                                    <td><input type="text" name="txtpro" value="<?php echo $productValue?>" title="Enter product name" ></td>
                                </tr>
                                
                            </table>
                   <div style="text-align:center;margin-top:20px;">
                            <input type="submit" name="button1" value="Display">
                            <input type="reset" name="button2" value="Clear" >
                        </form>
                    </div>
                </div>
            </div>
        </center>
    <?php 
        $close_connection 
    mysqli_close($con);
        if(!
    $close_connection)
            echo 
    "Connection is not closing. <br />" mysqli_connect_errno();
    ?>
    </body>
    </html>
    Last edited by tqmd1; 11-26-2013 at 08:26 AM.

  • #2
    Senior Coder
    Join Date
    Jan 2011
    Location
    Missouri
    Posts
    4,085
    Thanks
    23
    Thanked 593 Times in 592 Posts
    You will find ajax info here http://www.w3schools.com/ajax/ajax_x...quest_send.asp
    This is your new HTML, not exactly how I would do it, but close to the way you do so you can understand a little better:
    Code:
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml">
        <head>
            <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
            <title>Display data in textboxes</title>
    <!-- Style Sheet part start -->
    <style type="text/css">
    html {
        overflow:auto;
    }
    body {
        background-color:#FFFFFF;
        margin:0 auto;
    }
    #mypopup
    {
        float: left;
        width: 250px; height: 350px;
        background-color:#d5eef4 ;
        border: 1px solid #069;
        text-align:center;
        padding:2px;
        margin-top:150px;
        margin-left:100px;
        overflow:auto;
    }
    #header
    {
        background-color:#3399FF;
        background-position:left center;
        line-height:25px;
        font-size:22px;
        color:#FFFF33;
        font-weight:600;
        border-bottom:1px solid #6699CC;
        padding:10px;
    }
    </style>
    <!-- Style Sheet part end -->
    </head>
    <body>
    <center>
    <div id="mypopup">
    <div id="header">Search Data</div>
    <div style="margin-top:80px;">
    <form name="form1" action="#" method="post">
    	<table border=0; cellpadding="1" cellspacing="1" bgcolor="#CCFFFF" align="center" >
    	<tr>
    	<th>Code</th>
    	<th width="50px">
    	<input type="text" name="txtsno" id="txtsno" title="Enter product code" />
    	</th>
    	</tr>
    
    	<tr>
    	<td>Product</td>
    	<td><input id="txtpro" type="text" value="" /></td>
    	</tr>
    	</table>
    	<div style="text-align:center;margin-top:20px;">
    	<input type="button" name="button1" value="Display" onclick="send();">
    	<input type="reset" name="button2" value="Clear" >
    	</div>
    </form>
    </div>
    </div>
    </center>
    
    
    <script type="text/javascript">
    var xmlhttp = new XMLHttpRequest();
    
    function send(){
    	var Pcode = document.getElementById("txtsno").value;
    	xmlhttp.onreadystatechange=function(){
    		if (xmlhttp.readyState==4 && xmlhttp.status==200){
    			document.getElementById("txtpro").value = xmlhttp.responseText;
    		}
    	}
    xmlhttp.open("POST","test_2.php",true);
    xmlhttp.setRequestHeader("Content-type","application/x-www-form-urlencoded");
    xmlhttp.send("data="+Pcode);
    }
    </script>
    </body>
    </html>
    The php file that ajax calls is this:
    PHP Code:
    <?php
    require_once("connect.php");

    $code $_POST['data'];

    $record_check "SELECT packing FROM test WHERE sno = '$code' ";
    $result=mysqli_query($con$record_check);
    $row mysqli_fetch_array($result);

    if(!
    $row)
    die (
    'No record Found');
    else {
        
    $productValue $row['packing'];
    }

    echo 
    $productValue;
    ?>
    Please note I did not use SELECT *
    There is no reason to get everything, just get the field you need.
    Evolution - The non-random survival of random variants.

    "If you leave hydrogen alone, for long enough, it begins to think about itself."

  • #3
    Regular Coder
    Join Date
    Oct 2011
    Posts
    116
    Thanks
    19
    Thanked 1 Time in 1 Post
    Thanks for helping sir,
    While using your codes when I press Display button then txtpro shows this value

    PHP Code:
    <br /><font size='1'><table class='xdebug-error xe-parse-error' dir='ltr' border='1' cellspacing='0' cellpadding='1'><tr><th align='left' bgcolor='#f57900' colspan="5"><span style='background-color: #cc0000; color: #fce94f; font-size: x-large;'>( ! )</spanParse errorsyntax errorunexpected '$code' (T_VARIABLE), expecting ',' or ';' in C:wampwwwdbtest2.php on line <i>5</i></th></tr></table></font

    What is wrong sir, please help me again
    Last edited by tqmd1; 11-26-2013 at 06:34 PM. Reason: edit

  • #4
    Senior Coder
    Join Date
    Jan 2011
    Location
    Missouri
    Posts
    4,085
    Thanks
    23
    Thanked 593 Times in 592 Posts
    It kinda says you have an error here "Parse error: syntax error, unexpected '$code' (T_VARIABLE), expecting ',' or ';' in C:wampwwwdbtest2.php on line " Makes no sense to me. I gave you your code back and called it test_2.php

    To check rewrite test_2.php to just have:
    PHP Code:
    <?php
    echo "This works";
    ?>
    works you should re-write your

    If it works you should re-write your DB connection.
    Evolution - The non-random survival of random variants.

    "If you leave hydrogen alone, for long enough, it begins to think about itself."


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •