How To Edit A Database Record

bloomoon

i have successfully connected to my interbase database and have displayed
the results on a web page. my php code which displays the results is here:

<?php

while ($row = ibase_fetch_object ($result)) {
echo "<TR><TD align=left> $row->CLIENT </TD>";
echo "<TD align=left> $row->DBVERSION </TD>";
echo "<TD align=left> $row->POSTAHEAD </TD>";
echo "<TD align=left> $row->LASTUPDATED </TD>";
echo "<TD align=left> $row->INSTALLDATE </TD>";
echo "<TD align=left> $row->LIVEDATE </TD>";
echo "<TD align=left> $row->NOOFLICENCES </TD>";
echo "<TD align=left> $row->NOTES </TD></TR>";
}

ibase_free_result($result);

What i want is for the results in the first column i.e. the CLIENT results
to take the form of links which when clicked will take the user to another
screen where the details of that particular row can be edited within a form. Been struggling for ages. Don't know where to start 🙁

any help much appreciated as i am a newbie.

Anon

Probably the best thing to do (imho) is to use the ClientID (which I assume you have in your db) and do something like this:

echo "<TR><TD align=left><a href=\"edit.php?id=".$row->CLIENTID."\"</a> $row->CLIENT </TD>";

This will give you your link. On the edit.php page, you can simply grab the $HTTP_GET_VARS['id'] and perform another db query to get all the info you want and lay it out in a form.

Anon

echo "<tr><td align=\"left\"><a href=\"editrecord.php?client=\"".urlencode($row->CLIENT)."\">$row->CLIENT</a></td>";

Then in editrecord.php you'll know which record you should be editing, 'cos the client's name (as it appears in the database) is in $_GET['client'].

It's a bit cleaner, safer (and sometimes faster) to have a unique (probably numeric) ID to identify records, and use that in the link. So if you have such a primary key, use it instead.