1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Retrieving data from database and displaying in textbox when the button click

Discussion in 'PHP' started by newphpcoder, Jan 4, 2011.

  1. newphpcoder

    newphpcoder New Member

    Joined:
    Sep 24, 2010
    Messages:
    101
    Likes Received:
    0
    Trophy Points:
    0
    Occupation:
    Web Programmer
    Location:
    Philippines
    I search about the code for retrieving data from database when the retrieve button was click. But I can’t find any codes that similar in my situation.

    Here is the flow of my system. I have plt_no and a retrieve button. The retrieve button is to check if the plt_no is already exist or not if it is already exist the data from the database will appear in the text area/textbox and if the plt_no did not exist there’s a message that the id number did not exist and I can input data in the textboxes.


    I have an idea of using this code:
    This code is to check if the Retrieve button is click and the plt_no is the data which the retrieve depend on. Like for example the user put plt_no 111 and when the user click the Retrieve button, if the 111 is already exist the data will appear in the textboxes but if not there’s a message appear saying the plt no did not exist.

    Code:
    [/FONT][/COLOR]
    [COLOR=black][FONT=Arial]if(isset($_POST['Retrieve']))[/FONT][/COLOR]
    [COLOR=black][FONT=Arial]$plt_no = $_POST['plt_no'];[/FONT][/COLOR]
    [COLOR=black][FONT=Arial]



    And I have search code for retrieving data:

    PHP:
     
    <?php 
     
    // Connects to your Database 
     
    mysql_connect("your.hostaddress.com""username""password") or die(mysql_error()); 
     
    mysql_select_db("Database_Name") or die(mysql_error()); 
     
    $data mysql_query("SELECT * FROM friends WHERE pet='Cat'"
     or die(
    mysql_error()); 
     Print 
    "<table border cellpadding=3>"
     while(
    $info mysql_fetch_array$data )) 
     { 
     Print 
    "<tr>"
     Print 
    "<th>Name:</th> <td>".$info['name'] . "</td> "
     Print 
    "<th>Color:</th> <td>".$info['fav_color'] . "</td> "
     Print 
    "<th>Food:</th> <td>".$info['fav_food'] . "</td> "
     Print 
    "<th>Pet:</th> <td>".$info['pet'] . " </td></tr>"
     } 
     Print 
    "</table>"
     
    ?> 


    I attach my full code.

    My problem is how can I used that code and if that code is the code I need to used for retrieving data.



    I have an idea but i am luck of knowledge in coding

    Any help is highly appreciated I ma willing to learn and share

    Thank you
     

    Attached Files:

  2. newphpcoder

    newphpcoder New Member

    Joined:
    Sep 24, 2010
    Messages:
    101
    Likes Received:
    0
    Trophy Points:
    0
    Occupation:
    Web Programmer
    Location:
    Philippines
    I have the code I want to add for retrieving data:
    PHP:
    $query "SELECT plt_no FROM plt_transact WHERE plt_no= '" $_POST["plt_no"] . "'";
            
    $result mysql_query($query) or die ("Error in query: $query " mysql_error());
            
    $row mysql_fetch_array($result);
            
    $num_results mysql_num_rows($result);
            if (
    $num_results 0) {
                while(
    $row mysql_fetch_array($resultMYSQL_ASSOC)) {
    Is it that code is right?for retrieving data?
    My question is it automatically that when I insert plt_no then i click retrieve button it plt_no is exist the data will appear in the textboxes but I don't know how can I appear it and if the plt_no did not exist the textboxes is blank and theres a message that saying plt no did not exist.
    PHP:
    if($_POST["enum_plt"] && $_POST["plt_typeno"])
        {
        
    $query "SELECT * FROM plt_type WHERE plt_typeno = '" $_POST["plt_typeno"] . "'";
        
    $result mysql_query($query);
        if(
    $result)
            {
            
    $rexist 1;

     
    $query "SELECT plt_no FROM plt_transact WHERE plt_no= '" $_POST["plt_no"] . "'";
            
    $result mysql_query($query) or die ("Error in query: $query " mysql_error());
            
    $row mysql_fetch_array($result);
            
    $num_results mysql_num_rows($result);
            if (
    $num_results 0) {
                while(
    $row mysql_fetch_array($resultMYSQL_ASSOC)) {
            echo 
    "<p>PLT No:<input type='text' name='plt_no' onkeypress='return handleEnter(event,\"plt_date\");' /></br />";
            echo 
    "PLT Date:<input type='text' name='plt_date' onkeypress='return handleEnter(event,\"bom0\");' /></p>";
            echo 
    "<p><input type='Button' value='Retrieve' id='Retrieve' name='Retrieve' /></p>";
            echo 
    "<table>";
            
    $totalrows mysql_num_rows($result);
            
    $trows $totalrows 1;
            for(
    $ctr 0$ctr $trows$ctr++)
                {
                
    $tctr $ctr 1;
                
    $row mysql_fetch_array($result);
                echo 
    "\n\t<tr>";
                echo 
    "\n\t\t<td><input type='text' name='bom[]' id='bom" $ctr "' onkeypress='return handleEnter(event,\"qty" $ctr "\");' /></td>";
                echo 
    "\n\t\t<td>" $row["plt_chemicals"];
                echo 
    "<input type='hidden' name='chem[]' value='" $row["plt_chemicals"] . "' /></td>";
                echo 
    "\n\t\t<td><input type='text' name='qty[]' id='qty" $ctr "' onkeypress='return handleEnter(event,\"part" $ctr "\");' /></td>";
                echo 
    "\n\t\t<td><input type='text' name='part[]' id='part" $ctr "' onkeypress='return handleEnter(event,\"lot" $ctr "\");' /></td>";
                echo 
    "\n\t\t<td><input type='text' name='lot[]' id='lot" $ctr "' onkeypress='return handleEnter(event,\"bom" $tctr "\");' /></td>";
                echo 
    "\n\t</tr>";
                }
            if(
    $totalrows 1);
                {
                
    $row mysql_fetch_array($result);
                echo 
    "\n\t<tr>";
                echo 
    "\n\t\t<td><input type='text' name='bom[]' id='bom" $ctr "' onkeypress='return handleEnter(event,\"qty" $ctr "\");' /></td>";
                echo 
    "\n\t\t<td>" $row["plt_chemicals"];
                echo 
    "<input type='hidden' name='chem[]' value='" $row["plt_chemicals"] . "' /></td>";
                echo 
    "\n\t\t<td><input type='text' name='qty[]' id='qty" $ctr "' onkeypress='return handleEnter(event,\"part" $ctr "\");' /></td>";
                echo 
    "\n\t\t<td><input type='text' name='part[]' id='part" $ctr "' onkeypress='return handleEnter(event,\"lot" $ctr "\");' /></td>";
                echo 
    "\n\t\t<td><input type='text' name='lot[]' id='lot" $ctr "' onkeypress='return handleEnter(event,\"b1\");' /></td>";
                echo 
    "\n\t</tr>";
                }
            echo 
    "</table>";
            
            echo 
    "<p>&nbsp;</p>";
            echo 
    "<table>";
            echo 
    "<tr><td>B1</td><td><input type='text' name='b1' id='b1' onkeypress='return handleEnter(event,\"sc2\");' /></td></tr>";
            echo 
    "<tr><td>SC2</td><td><input type='text' name='sc2' id='sc2' onkeypress='return handleEnter(event,\"timein0\");' /></td></tr>";
            echo 
    "</table>";
            echo 
    "<p>&nbsp;</p>";
            
            
    $query "SELECT * FROM trace_operations WHERE plt_typeno = '" $_POST["plt_typeno"] . "'  AND operation_name IN ('Operation1' , 'Operation2' , 'Operation3')ORDER BY operation_name";
            
    $last_operation_name "";
            
    $result mysql_query($query);
            if(
    $result)
                {
                
    $rexist 1;
                echo 
    "<table>";
                
    $totalrows mysql_num_rows($result);
                
    $trows $totalrows 1;
                for(
    $ctr 0$ctr $trows$ctr++)
                    {
                    
    $row mysql_fetch_array($result);
                    
    $tctr $ctr 1;
                    echo 
    "\n\t<tr>";
                    echo 
    "\n\t\t<td>";
                    if (
    $last_operation_name != $row["operation_name"]) echo $row["operation_name"];
                    
    $last_operation_name $row["operation_name"];
                    echo 
    "<input type='hidden'  name='opname[]' value='" $row["operation_name"] . "' /></td>";   
                    echo 
    "\n\t\t<td><input  type='text' name='timein[]' id='timein" $ctr "' onkeypress='return handleEnter(event,\"timeout" $ctr "\");' /></td>";
                    echo 
    "\n\t\t<td><input  type='text' name='timeout[]' id='timeout" $ctr "' onkeypress='return handleEnter(event,\"inqty" $ctr "\");' /></td>";
                    echo 
    "\n\t\t<td><input  type='text' name='inqty[]' id='inqty" $ctr "' onkeypress='return handleEnter(event,\"outqty" $ctr "\");' /></td>";
                    echo 
    "\n\t\t<td>" $row["input_unit"];
                    echo 
    "<input type='hidden' name='iun[]' value='" $row["input_unit"] . "' /></td>";
                    echo 
    "\n\t\t<td><input  type='text' name='outqty[]' id='outqty" $ctr "' onkeypress='return handleEnter(event,\"idno" $ctr "\");' /></td>";
                    echo 
    "\n\t\t<td>" $row["output_unit"];
                    echo 
    "<input type='hidden' name='oun[]' value='" $row["output_unit"] . "'></td>";
                    echo 
    "\n\t\t<td><input  type='text' name='idno[]' id='idno" $ctr "' onkeypress='return handleEnter(event,\"mcno" $ctr "\");' /></td>";
                    echo 
    "\n\t\t<td><input  type='text' name='mcno[]' id='mcno" $ctr "' onkeypress='return handleEnter(event,\"varqty" $ctr "\");' /></td>";
                    echo 
    "\n\t\t<td><input  type='text' name='varqty[]' id='varqty" $ctr "' onkeypress='return handleEnter(event,\"varplt" $ctr "\");' /></td>";
                    echo 
    "\n\t\t<td><input  type='text' name='varplt[]' id='varplt" $ctr "' onkeypress='return handleEnter(event,\"dateshift" $ctr "\");' /></td>";
                    echo 
    "\n\t\t<td><input type='text' name='dateshift[]' id='dateshift" $ctr "' onkeypress='return handleEnter(event,\"shift" $ctr "\");' /></td>";
                   echo 
    "\n\t\t<td><input  type='text' name='shift[]' id='shift" $ctr "' onkeypress='return handleEnter(event,\"timein" $tctr "\");' /></td>";
                    echo 
    "\n\t</tr>";
                    }
                if(
    $totalrows 1);
                    {
                    
    $row mysql_fetch_array($result);
                    echo 
    "\n\t<tr>";
                    echo 
    "\n\t\t<td>";
                    if (
    $last_operation_name != $row["operation_name"]) echo $row["operation_name"];
                    
    $last_operation_name $row["operation_name"];
                    echo 
    "<input type='hidden'  name='opname[]' value='" $row["operation_name"] . "' /></td>";   
                    echo 
    "<input type='hidden' name='opname[]' value='" $row["operation_name"] . "' /></td>";
                    echo 
    "\n\t\t<td><input  type='text' name='timein[]' id='timein" $ctr "' onkeypress='return handleEnter(event,\"timeout" $ctr "\");' /></td>";
                    echo 
    "\n\t\t<td><input  type='text' name='timeout[]' id='timeout" $ctr "' onkeypress='return handleEnter(event,\"inqty" $ctr "\");' /></td>";
                    echo 
    "\n\t\t<td><input  type='text' name='inqty[]' id='inqty" $ctr "' onkeypress='return handleEnter(event,\"outqty" $ctr "\");' /></td>";
                    echo 
    "\n\t\t<td>" $row["input_unit"];
                    echo 
    "<input type='hidden' name='iun[]' value='" $row["input_unit"] . "' /></td>";
                    echo 
    "\n\t\t<td><input  type='text' name='outqty[]' id='outqty" $ctr "' onkeypress='return handleEnter(event,\"idno" $ctr "\");' /></td>";
                    echo 
    "\n\t\t<td>" $row["output_unit"];
                    echo 
    "<input type='hidden' name='oun[]' value='" $row["output_unit"] . "'></td>";
                    echo 
    "\n\t\t<td><input  type='text' name='idno[]' id='idno" $ctr "' onkeypress='return handleEnter(event,\"mcno" $ctr "\");' /></td>";
                    echo 
    "\n\t\t<td><input  type='text' name='mcno[]' id='mcno" $ctr "' onkeypress='return handleEnter(event,\"varqty" $ctr "\");' /></td>";
                    echo 
    "\n\t\t<td><input  type='text' name='varqty[]' id='varqty" $ctr "' onkeypress='return handleEnter(event,\"varplt" $ctr "\");' /></td>";
                    echo 
    "\n\t\t<td><input  type='text' name='varplt[]' id='varplt" $ctr "' onkeypress='return handleEnter(event,\"dateshift" $ctr "\");' /></td>";
                    echo 
    "\n\t\t<td><input  type='text' name='dateshift[]' id='dateshift" $ctr "' onkeypress='return handleEnter(event,\"shift\");' /></td>";
                    echo 
    "\n\t\t<td><input  type='text' name='shift[]' id='shift" $ctr "' onkeypress='return handleEnter(event,\"saveform\");' /></td>";
                    echo 
    "\n\t</tr>";
                    }
                echo 
    "</table>";
                }
            }
        }
      }
    }
    this code is incomplete, can someone told me what is the missing code to view the retrieve data?and how does the retrieve works.
    Thank you
     

Share This Page