I have this "database table" here for example that i can add edit and delete from;
I want to have a page displayed that the user can search by different fields and retrived the disired information. Can anyone make me an example of how i can do this. The code below i have edited from another author to fit my specific needs (and these are the variables i want to be searching by)
Can be viewed here
<?PHP
// Change these variables to fit your needs:
$table = "SWG_items";
$field1 = "item_name";
$field1_label = "Item Name";
$field2 = "item_discription";
$field2_label = "Discription";
$field3 = "item_class";
$field3_label = "Class";
$field4 = "item_species";
$field4_label = "Species";
$field5 = "item_location";
$field5_label = "Body Location";
$field6 = "item_statmodifiers";
$field6_label = "Stat Modifiers";
$field7 = "item_picture";
$field7_label = "Picture URL";
$field8 = "item_ratio";
$field8_label = "Damage / Delay";
$field9 = "item_special";
$field9_label = "Special Attributes";
$field10 = "";
$field10_label = "";
$field11 = "";
$field11_label = "";
$field12 = "";
$field12_label = "";
$db_host="localhost";
$db_user="client1364";
$db_pass="d3@+0rd13";
$db="client1364_nobleben";
// End of variables definitions. No need to edit code beyond this line
// Connect to database
mysql_connect($db_host,$db_user,$db_pass);
mysql_select_db($db);
?>
<html>
<head>
<script language="JavaScript">
function focusform()
{
document.forms[0].field1_value.focus();
}
</script>
<head>
<body OnLoad="focusform()">
<?PHP
if (!empty($insert)) {
mysql_query( "insert into $table ($field1, $field2, $field3, $field4, $field5, $field6, $field7, $field8, $field9) values (\"$field1_value\",\"$field2_value\",\"$field3_value\", \"$field4_value\", \"$field5_value\", \"$field6_value\", \"$field7_value\", \"$field8_value\", \"$field9_value\")");
}
if (!empty($update)) {
mysql_query( "update $table set
$field1=\"$field1_value\",
$field2=\"$field2_value\",
$field3=\"$field3_value\",
$field4=\"$field4_value\",
$field5=\"$field5_value\",
$field6=\"$field6_value\",
$field7=\"$field7_value\",
$field8=\"$field8_value\",
$field9=\"$field9_value\" where id=$update");
}
if (!empty($delete)) {
mysql_query( "delete from $table where id=$delete");
}
if (mysql_errno()!=0) {
switch (mysql_errno()) {
default:
echo "Error #".mysql_errno(). " (".mysql_error(). ")<br>";
}
}
if (!$sort) $sort="$field1";
$query = "select * from $table";
switch ($sort) {
case "id": $query=$query. " order by id"; break;
case "$field1": $query=$query. " order by $field1"; break;
case "$field2": $query=$query. " order by $field2"; break;
case "$field3": $query=$query. " order by $field3"; break;
case "$field4": $query=$query. " order by $field4"; break;
case "$field5": $query=$query. " order by $field5"; break;
case "$field6": $query=$query. " order by $field6"; break;
case "$field7": $query=$query. " order by $field7"; break;
case "$field8": $query=$query. " order by $field8"; break;
case "$field9": $query=$query. " order by $field9"; break;
}
$result = mysql_query($query);
$rows = mysql_num_rows($result);
$i=0;
echo "<table border=1>\n";
echo "<tr><td><a href=\"?sort=id\">ID</a></td>\n";
echo "<td><a href=\"?sort=$field1\">$field1_label</a></td>\n";
echo "<td><a href=\"?sort=$field2\">$field2_label</a></td>\n";
echo "<td><a href=\"?sort=$field3\">$field3_label</a></td>\n";
echo "<td><a href=\"?sort=$field4\">$field4_label</a></td>\n";
echo "<td><a href=\"?sort=$field5\">$field5_label</a></td>\n";
echo "<td><a href=\"?sort=$field6\">$field6_label</a></td>\n";
echo "<td><a href=\"?sort=$field7\">$field7_label</a></td>\n";
echo "<td><a href=\"?sort=$field8\">$field8_label</a></td>\n";
echo "<td><a href=\"?sort=$field9\">$field9_label</a></td>\n";
echo "<td> </td><td> </td></tr>\n";
echo "<form action=\"$PHP_SELF\" method=\"post\">\n";
echo "<td>Insert New:</td>\n";
echo "<input type=hidden name=insert value=1></td>\n";
echo "<td><input type=text size=10 name=field1_value value=$today></td>\n";
echo "<td><input type=text size=10 name=field2_value></td>\n";
echo "<td><input type=text size=15 name=field3_value></td>\n";
echo "<td><input type=text size=15 name=field4_value></td>\n";
echo "<td><input type=text size=15 name=field5_value></td>\n";
echo "<td><input type=text size=15 name=field6_value></td>\n";
echo "<td><input type=text size=15 name=field7_value></td>\n";
echo "<td><input type=text size=15 name=field8_value></td>\n";
echo "<td><input type=text size=15 name=field9_value></td>\n";
echo "<td colspan=2 align=center>";
echo "<input type=submit value=\" Add \"></td>\n";
echo "<td></td>\n";
echo "</form>\n";
while ($i<$rows) {
echo "<tr>\n";
$id=mysql_result($result,$i, "id");
if (empty($read) || ($read!=$id)) {
echo "<td>".$id. "</a></td>\n";
echo "<td>".mysql_result($result,$i, "$field1"). "</td>\n";
echo "<td>".mysql_result($result,$i, "$field2"). "</td>\n";
echo "<td>".mysql_result($result,$i, "$field3"). "</td>\n";
echo "<td>".mysql_result($result,$i, "$field4"). "</td>\n";
echo "<td>".mysql_result($result,$i, "$field5"). "</td>\n";
echo "<td>".mysql_result($result,$i, "$field6"). "</td>\n";
echo "<td>".mysql_result($result,$i, "$field7"). "</td>\n";
echo "<td>".mysql_result($result,$i, "$field8"). "</td>\n";
echo "<td>".mysql_result($result,$i, "$field9"). "</td>\n";
echo "<td><a href=\"?read=$id\">edit</a></td>\n";
echo "<td><a href=\"?delete=$id\">delete</a></td>\n";
} else {
echo "<form action=\"$PHP_SELF\" method=\"post\">\n";
echo "<td>".$id. "</a></td>\n";
echo "<input type=hidden name=update value=\"$id\"></td>\n";
echo "<td><input type=text size=10 name=field1_value value=\"".mysql_result($result,$i, "$field1"). "\"></td>\n";
echo "<td><input type=text size=10 name=field2_value value=\"".mysql_result($result,$i, "$field2"). "\"></td>\n";
echo "<td><input type=text size=15 name=field3_value value=\"".mysql_result($result,$i, "$field3"). "\"></td>\n";
echo "<td><input type=text size=15 name=field4_value value=\"".mysql_result($result,$i, "$field4"). "\"></td>\n";
echo "<td><input type=text size=15 name=field5_value value=\"".mysql_result($result,$i, "$field5"). "\"></td>\n";
echo "<td><input type=text size=15 name=field6_value value=\"".mysql_result($result,$i, "$field6"). "\"></td>\n";
echo "<td><input type=text size=15 name=field7_value value=\"".mysql_result($result,$i, "$field7"). "\"></td>\n";
echo "<td><input type=text size=15 name=field8_value value=\"".mysql_result($result,$i, "$field8"). "\"></td>\n";
echo "<td><input type=text size=15 name=field9_value value=\"".mysql_result($result,$i, "$field9"). "\"></td>\n";
echo "<td colspan=2 align=center><input type=submit value=\" Update Feild! \"></td>\n";
echo "</form>\n";
}
echo "</tr>\n";
$i=$i+1;
}
mysql_close();
echo "</table>\n";
?>
</body></html>
😕
Thank You for your help,
Ben Aicholtz
nobleben@cinic.rr.com
If you like you can E-Mail me with what you have come up with.
I am trying to pull off somthing in this nature
http://www.everlore.com/items/itemslist.asp?mode=search&method=complex
