Re: show data on the text input box

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/