Mortgage Calculator - Secured Loans - Actress - Western Union - Personal Loans

PDA

View Full Version : what do i need to do this


dougvcd
Mar 21st 2008, 5:22 am
hi again
what do i need to populate a form from database and view each record and amend or delete it
cheers
Doug

Weirfire
Mar 21st 2008, 5:38 am
Just create an action flag for the submit button and switch it in the IF POST.


if($_POST){

$id = $_POST['id'];
$item1 = $_POST['item1'];
$item2 = $_POST['item2'];
$item3 = $_POST['item3'];

mysql_query("UPDATE <TABLE> SET item1 = '" . $item1 . "', item2 = '" . $item2 . "', item3 = '" . $item3 . "' WHERE id = '" . $id . "'");

}



print "<table>";

$result = mysql_query("SELECT * FROM <TABLE>");
while($row = mysql_fetch_array($result)){

print "<form>
<input type='hidden' name='id' value='" . $row['id'] . "' /><tr>
<td>Item 1 : <input name='item1' type='text' value='" . $row['item1'] . "' /></td>
<td>Item 2 : <input name='item2' type='text' value='" . $row['item2'] . "' /></td>
<td>Item 3 : <input name='item3' type='text' value='" . $row['item3'] . "' /></td>
<td><input type='submit' value='edit' /></td>
</tr></form>";

}

print "</table>";

dougvcd
Mar 21st 2008, 1:45 pm
sorry not sure what to do with this code as i have very little know how as i am still learning
cheers
Doug

Weirfire
Mar 22nd 2008, 8:59 am
No problem Doug. I'd suggest you learn the basics of PHP before you start using databases. :)

www.php.net