howdy,
im totally new to php and need sum help! I tried to get this script working but i keep getting messages with 'query is empty' ..any advice about wot i do wrong? thnx!
Succesfully created a table 'phone_book' in database 'test' in mysql.
create table phone_book(
id integer not null auto_increment,
first_name varchar(50),
last_name varchar(50),
phone varchar(50),
primary key (id)
)
and here's the script that goes with it:
<?php
$table = "phone_book";
$field1 = "first_name";
$field1_label = "First Name";
$field2 = "last_name";
$field2_label = "Last Name";
$field3 = "phone";
$field3_label = "Phone";
$db="test";
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) values (\"$field1_value\",\"$field2_value\",\"$field3_val ue\")");
}
if (!empty($update)) {
mysql_query( "update $table set $field1=\"$field1_value\", $field2=\"$field2_value\",$field3=\"$field3_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;
}
$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> </td><td> </td></tr>\n";
echo "<form action=\"$PHP_SELF\" method=\"post\">\n";
echo "<td>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 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><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 colspan=2 align=center><input type=submit value=\" Do it! \"></td>\n";
echo "</form>\n";
}
echo "</tr>\n";
$i=$i+1;
}
mysql_close();
echo "</table>\n";
?>
</body></html>
need sum help!
