Re: show data on the text input box

Thanks for the information and help, do you mean that I need to do something like following in the loop? $result = $sth->fetchAll(PDO::FETCH_CLASS, "fruit"); var_dump($result); thanks again, I am pretty new to PHP. Regards, Iccsi, "Domain nikha . org" wrote in message news:B7FA1B4E995A0452B306081E752B09B4mail@nikha.org... iccsi am Samstag, 10. Mai 2014 - 01:25:

Here is full code, Thanks again for helping, Regards, Iccsi, <!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> <title>Search data</title> </head> <body> <table> <tr>

    <td align="center">EMPLOYEES DATA</td>

</tr> <tr>

    <td>
      <table border="1">
      <tr>
         <td>
         <input name="mytext" type="text" value="<?php echo

($row['invdate']); ?>" />

       </td>

      </tr>

<?php $hostname = "localhost"; $username = "root"; $password = "password"; try { $dbh = new PDO("mysql:host=localhost;dbname=mydb;charset=utf8", $username, $password);

       $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
       $dbh->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
       echo "Connected to database";
     }

catch(PDOException $e)

    {
    echo $e->getMessage();
     }

$stmt = $dbh->query('SELECT invid, invdate, client_id, amount from invheader'); while($row = $stmt->fetch(PDO::FETCH_ASSOC)) {

    echo $row['invid'].' '.$row['invdate'].' '.$row['client_id'].'

'.$row['amount']; //etc... } ?>

    </table>

</td> </tr> </table> </body> </html> "Jim Lucas" wrote in message news:536D5FF8.3050404@cmsws.com... On 05/09/2014 03:54 PM, iccsi wrote: I tried both with '' or without '', but I do not see the data on the text box on both situation. Do I need fetch records using php or how do I know that it is not end of file? What does your full code look like now? Thanks again, Regard, Iccsi, "Jim Giner" wrote in message news:AE.B6.46741.8745D635@pb1.pair.com... On 5/9/2014 6:12 PM, iccsi wrote:

Thanks for the information and help, I use the following code to show data, but it shows '/', but not data. <td><input name="mytext" type="text" value=<?php echo ($row['invdate']); ?> /></td> Are there any way to access from mySQL result data? Thanks again for helping, Regards, Iccsi, "Robert Cummings" wrote in message news:536C7208.6050201@interjinn.com... On 14-05-09 12:37 AM, iccsi wrote:

I have following code to connect MySQL and database. I see 'connected to database', I would like to know that which code do I need to show my data on the text box? Your help and information is great appreciated,

Do you mean like the following? <input name="mytext" type="text" value="<?php echo htmlspecialchars( $value ); ?>" /> Cheers, Rob.

You have no quotes on your value clause. Plus this might be easier to type and read: <? echo "<td><input name='mytext' type='text' value='{$row['invdate']}'>"; ?> (Not sure you need the inside the [] on the $row reference, but I put them there.) -- Jim Lucas http://www.cmsws.com/ http://www.cmsws.com/examples/

My dear, your while-loop stops with an empty value - that's the terminating condition! And exactly this is shown in your input tag: nothing! You must fetch the values while the loop is running! Greatings, Niklaus