Delete and Update from table created by ODBC MS Access.

fusion_200

Anyone here who has any simple code that prints out a table using echo from an MS Access ODBC connection

And then makes it possible to select a specific post in the database for deletion or update.

I have been trying hard to find a simple solution to this problem. I am trying to make my own DVD Database. But i have no clue on how to make the table entries selectable and then connect each entry in the table to a delete or update button.

I hope someone has a simple solution. I have managed to print out the database entries in table form but i don't have any clue on how to specifically choose one of the entries for deletion or update.

kevinsequeira

could you post the code / table design you have used till now, so that i can modify it to update and delete ?

reg
kevin

fusion_200

This is the code i use and it is working but i get a Notice: Undefined index: delete in C:\Apache2\htdocs\Untitled6.php on line 5 error when i use it. And how do i add update easily ?

<?php

$dblink = odbc_connect("example_db", "", "");
echo $_SERVER['PHP_SELF'];
if ($_GET['delete'] == "delete") {

	$sql = odbc_exec($dblink,"DELETE FROM Fusion WHERE ID=$_GET[id]")
		or die(odbc_error());
	echo "<META HTTP-EQUIV='refresh' CONTENT='text/html; charset=ISO-2022-JP' URL='$_SERVER[PHP_SELF]'>";
} 
	$sql = odbc_exec($dblink,"SELECT * FROM Fusion")
		or die(odbc_error());
	while (odbc_fetch_into($sql,$var)) {

?>
<table width="100%" border="0" cellspacing="0" cellpadding="1">
<tr>
<td width="253"><?php echo "".$var[1].""?></td>
<td>[ <a href="<?php echo "$_SERVER[PHP_SELF]?delete=delete&id=".$var[0].""?>">Delete</a> ]</td>
</tr>
</table>
<?php
}

fusion_200

Ok i have managed to resolve the update with sql too.

But i still get the error Notice: Undefined index: delete in C:\Apache2\htdocs\Untitled6.php on line 6. Even though it is a variable it should get after the php script has posted the variable.