I have created a script which basically posts and lists fields and tables from a mysql database from html. I have been having problems trying to make it able to delete and update the rows through the html interface. Can anyone help? here is a copy of the code.
form.php
<?php
// Administrative Includes
$admin[1] = "THQ Phone List";
$admin[2] = "#000000";
$admin[3] = "http://is1.thq.com";
$admin[4] = "form.php";
$admin[5] = "help.html";
include("/usr/local/lib/includes/standard.php");
$dbname = phone;
$id_link = @mysql_connect($db_host, $db_user, $db_password);
$tables = mysql_list_tables($dbname, $id_link);
$num_tables = mysql_num_rows($tables);
$arr_tablenames[] = '';
$arr_num_fields[] = '';
// Inserted for Sort command
if ($sort == 0) $sort="f_name";
for ($i=0; $i < $num_tables; $i++) {
$arr_tablenames[$i] = mysql_tablename($tables, $i);
$arr_num_fields[$i] = mysql_num_fields(mysql_db_query($dbname, "select f_name, l_name, e_name from $arr_tablenames[$i]", $id_link));
}
for ($i=0; $i < $num_tables; $i++) {
for ($ii=0; $ii < $arr_num_fields[$i]; $ii++) {
$result = mysql_db_query($dbname, "select * from $arr_tablenames[$i] ORDER BY $sort", $id_link);
$hash_field_names[$i][$ii] = mysql_field_name($result, $ii);
}
}
include("/usr/local/lib/includes/header.php");
for ($i=0; $i < $num_tables; $i++) {
echo "<table align=\"center\" border=\"1\">\n";
echo "<tr>\n";
echo " <td>\n";
echo " <center>\n";
echo "<font color=\"#FFFFFF\" face=\"arial\" size=\"4\">\n";
echo " <b>First Name</b>\n";
echo "</font>\n";
echo " </center>\n";
echo " </td>\n";
echo " <td>\n";
echo " <center>\n";
echo "<font color=\"#FFFFFF\" face=\"arial\" size=\"4\">\n";
echo " <b>Last Name</b>\n";
echo "</font>\n";
echo " </center>\n";
echo " </td>\n";
echo " <td>\n";
echo " <center>\n";
echo "<font color=\"#FFFFFF\" face=\"arial\" size=\"4\">\n";
echo " <b>Ext.</b>\n";
echo "</font>\n";
echo " </center>\n";
echo " </td>\n";
echo " <td>\n";
echo " <img src=images/edit.gif>\n";
echo " </td>\n";
echo " <td>\n";
echo " <img src=images/trash.gif>\n";
echo " </td>\n";
echo "</tr>\n";
echo " <tr>\n";
$number_of_rows = @mysql_num_rows($result);
for ($iii = 0; $iii < $number_of_rows; $iii++) {
$record = @mysql_fetch_row($result);
for ($ii=0; $ii < $arr_num_fields[$i]; $ii++) {
echo " <td>\n";
echo "<font color=\"#FFFFFF\" face=\"helvetica\" size=\"3\">\n";
echo $record[$ii];
echo "</font>\n";
echo " </td>\n";
}
echo " <td>\n";
echo "<a href=update.php>\n";
echo "<img src=images/edit.gif border=0>\n";
echo "</a>\n";
echo " </td>\n";
echo " <td>\n";
echo "<a href=post.php?action=delete>\n";
echo "<img src=images/trash.gif border=0>\n";
echo "</a>\n";
echo " </td>\n";
echo(" </tr>\n");
}
echo "<form method=POST action=\"post.php?action=add\">\n";
?>
<tr>
<td>
<input type=text name=f_name>
</td>
<td>
<input type=text name=l_name>
</td>
<td>
<input type=text name=e_name>
</td>
</tr>
<tr>
<td>
<input type=submit value="Add / Update">
</td>
</tr>
</form>
<?php
echo "</table>\n";
include("/usr/local/lib/includes/footer.php");
}
?>
Post.php
<?php
include("/usr/local/lib/includes/standard.php");
$dbname = phone;
$conn = mysql_connect($db_host, $db_user, $db_password);
$db = mysql_select_db($dbname);
if ($action == "add") {
$resulted = mysql_query ("INSERT INTO list (f_name, l_name, e_name) VALUES ('$f_name', '$l_name', '$e_name')");
if(!$resulted) {
$message = "Error data was not posted";
$error_msg = mysql_error();
echo "<b><font face=\"arial\" size=50>$message</font></b>\n";
echo " <br>\n";
echo "$error_msg";
exit;
}
if($resulted) {
$message = "$f_name $l_name Successfully added";
}
}
if ($action == "delete") {
$resulted = mysql_query ("DELETE FROM list WHERE e_name='$e_name'");
$message = "Item Successfully Deleted";
}
mysql_query($resulted);
mysql_close($conn);
$ignore=true;
include("form.php");
?>
