Re: show data on the text input box

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I got it works now,
I just put a curly bracket in the end of the line,

Thanks a million again for helping,


Regards,


Iccsi,

"Ken Robinson"  wrote in message news:08.2A.46741.2196D635@xxxxxxxxxxxx...

Here's my re-work of your code. I moved the PHP section to the start
of the file & stored the output needed in a temporary array, which is
output in the correct place.

The reason that this line:
<input name="mytext" type="text" value="<?php echo ($row['invdate']); ?>" />
doesn't show anything is that there is no data in $row at that point.

<?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();
}
$tmp = array();
$stmt = $dbh->query('SELECT invid, invdate, client_id, amount from invheader');
while($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
        $tmp[] = "<td>";
        $tmp[] = "<input name='mytext' type='text'
value='{$row['invdate']}' />";
        $tmp[] = "</td>";
        $tmp[] =  "{$row['invid']} {$row['invdate']}
{$row['client_id']} {$row['amount']"; //etc...
}
?>
<!DOCTYPE html>
<head>
    <title>Search data</title>
</head>
<body>
    <table>
        <tr>
            <td align="center">EMPLOYEES DATA</td>
        </tr>
        <tr>
            <td>
                <table border="1">
                    <tr>
                        <?php echo implode("\n",$tmp) . "\n"; ?>
                     </tr>
                </table>
            </td>
        </tr>
     </table>
</body>
</html>


Ken

At 07:25 PM 5/9/2014, iccsi wrote:
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@xxxxxxxxx...

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@xxxxxxxxxxxx...

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@xxxxxxxxxxxxx...

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/

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php





[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux