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@xxxxxxxxx...
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@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/
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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
