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

[newphpcoder]

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.

if(isset($_POST['Retrieve']))
$plt_no = $_POST['plt_no'];

And I have search code for retrieving data:

<?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

[kiLLeR-eyEd_14]

is this what u mean?

$cou = mysql_query(mysql_fetch_array("SELECT COUNT(*) FROM your_table WHERE plt_no='$plt_no'"));
if($cou>0) echo "plt_no already exists!";
else echo "ok!";

[newphpcoder]

Is it automatically the echo will appear after i insert plt_no then i click the retrieve button?

Thank you

Added after 37 minutes:

I have the code I want to add for retrieving data:

$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($result, MYSQL_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.

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($result, MYSQL_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