
December 21st, 2012, 02:05 AM
|
|
Registered User
|
|
Join Date: Dec 2012
Posts: 13
Time spent in forums: 4 h 27 m 9 sec
Reputation Power: 0
|
|
|
PHP-DB - How to show link in table in php for mysqli data?
I am working on mysqli database.
I am trying to create a link to update the data through php. I am hitting minor mistake by not knowing exactly how to write in mysqli. In mySQL it is
Code:
<a href="update.php?id=<? echo $rows['id']; ?>">
but i need to write in mysqli.
Thank you in advance!
Below is my table where i got error:
PHP Code:
echo <<<EOM
<table border='1'>
<tr>
<td>Last Name</td>
<td>First Name</td>
<td>Phone No</td>
<td>Email</td>
<td>Address</td>
<td>City</td>
<td>Update</td>
</tr>
EOM;
while (($row = $result->fetch_assoc()) !== NULL)
{
echo <<<EOM
<tr>
<td>{$row["lName"]}</td>
<td>{$row["fName"]}</td>
<td>{$row["phoneNo"]}</td>
<td>{$row["email"]}</td>
<td>{$row["address"]}</td>
<td>{$row["city"]}</td>
<td><a href="update.php?id={$rows['customerNo']}">update</a></td>
</tr>
EOM;
}
|