Re: show data on the text input box

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