Re: Please, answer my question

Please ask PHP related support questions at php-general@lists.php.net Regards, Gabor Hojtsy S. M. írta:

I'll be appritiate if you could help me in solving my problem :) I have the following script using php to add announcements to the database . The problem is the script does not match with the database , i mean it does not insert or update or even delete what i have (the aim of the script) . I do not know if there is a problem with the representation of the variables .Because iam sure that my database works pefectly . If appritiate if you look to my script and replying me if you have any ideas to be corrected or added for my "graduation project" I'll be looking forward to hearing from you, with best regards <?php #include 'include.inc'; # mySQL host address (usually 'localhost') $db_host = "localhost"; # mySQL database name $db_name = "e_submission"; # mySQL database username $db_username = "root"; # mySQL database password $db_password = "esub"; # option to enable link to the to-do editor # to enable/disable, enter '1' to ENABLE or '0' to DISABLE (without quotes) $opt_link = 1; function db_connect() { // Open a connection to the DBMS global $db_host, $db_name, $db_username, $db_password; mysql_connect($db_host, $db_username, $db_password) or die ("<font color=red>Cannot connect to mySQL server</font>"); mysql_select_db($db_name) or die ("<font color=red>Cannot connect to mySQL database</font>"); } function todo() { global $db_host, $db_name, $db_username, $db_password, $opt_link; echo"<html>\n<head>\n<title>TO-DO List</title>\n</head>\n\n<body link=#C0C0C0 vlink=#C0C0C0 alink=#C0C0C0>\n"; echo"<font face=tahoma,arial><center><h2>TO-DO List</h2>\n\n"; db_connect(); $sql = "SELECT * FROM announcement ORDER BY id DESC LIMIT 0, 30"; $result = mysql_query($sql) or die ("Unknown mySQL error"); mysql_num_rows($result) or die ("<i>Nothing is currently on the to-do list</i> - <a href=$_SERVER[PHP_SELF]?do=edit>Edit the list</font></a>"); echo"<table border=3 cellspacing=3 cellpadding=2 bordercolor=#000000 bgcolor=#E0E0E0 width=80% style=\"font-size: 14px; border-collapse:collapse;\">\n<tr><td width=75><b>ID</b></td><td width=430><b>Title</b></td><td width=330><b>Content</b></td><td width=154><b>Date</b></td></tr>\n"; while ($row = mysql_fetch_array($result)) { echo"<tr bordercolor=#B9B3A2><td width=75>$row[id]</td><td width=430>$row[title]</td><td width=330>$row[content]</td><td width=154>$row[date_time]</td></tr>\n"; } if ($opt_link == 1) { echo"</table>\n\n<br><br><a href=$_SERVER[PHP_SELF]?do=edit><font color=black>TO-DO List Editor</font></a><br>"; } else { echo"</font></table>\n\n<br><br>"; } echo"<font size=1 color=#C0C0C0>Powered by <a href=http://mtnpeak.net>TO-DO List v0.2</a></font></font>\n\n</body>\n</html>"; } function todoedit() { global $db_host, $db_name, $db_username, $db_password; echo"<html><head><title>TO-DO List / editor</title></head> <body link=#C0C0C0 vlink=#C0C0C0 alink=#C0C0C0><center><b><font face=tahoma, arial> <center><b><h2>TO-DO List</b> / editor</h2></center> <table border=3 bordercolor=\"#000000\" style=\"border-collapse: collapse\" cellpadding=\"4\" cellspacing=\"1\" height=\"450\"><tr> <td width=50% height=\"441\"> <font> <form action=\"$_SERVER[PHP_SELF]?do=edit\" method=\"post\"> <b>Add</b> <table border=0><tr><td width=28><font size=\"2\">ID</font></td><td width=300> <font size=\"2\">Title</font></td><td width=80><font size=\"2\">Date</font></td></tr> <tr><td>X</td><td><input type=text name=\"item1\" size=45></td><td><input type=text name=\"date1\" size=10></td></tr> <tr><tr><td></td><td><font size=\"2\">Content:</font><br><input type=text name=\"notes1\" size=45></td></tr> <tr><td></td><td align=center><input type=submit value=Add name=add></td><td></td></tr></table><br><br><br> <form action=\"$_SERVER[PHP_SELF]?do=edit\" method=\"post\"> <b>Update</b> <table border=0><tr><td width=28><font size=\"2\">ID</font></td><td width=300> <font size=\"2\">Title</font></td><td width=80><font size=\"2\">Date</font></td></tr> <tr><td><input type=text name=\"id2\" size=1></td><td><input type=text name=\"item2\" size=45></td><td><input type=text name=\"date2\" size=10></td></tr> <tr><tr><td></td><td><font size=\"2\">Content:</font><br><input type=text name=\"notes2\" size=45></td></tr> <tr><td></td><td align=center><input type=submit value=Update name=update></td><td></td></tr></table><br><br><br> <form action=\"$_SERVER[PHP_SELF]?do=edit\" method=\"post\"> <b>Delete</b> <table border=0><tr><td width=28><font size=\"2\">ID</font></td><td width=300> <font size=\"2\">Title</font></td><td width=80><font size=\"2\">Date</font></td></tr> <tr><td><input type=text size=1 name=id></td><td><font size=\"2\">XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX</font></td><td> <font size=\"2\">XXXXXXX</font></td></tr> <tr><td></td><td align=center> <input type=submit value=Delete name=delete style=\"color: #FF0000\"></td><td></td></tr></table> </td><td width=50% valign=top height=\"441\"> <B>TO-DO List Preview Pane</b>&nbsp;&nbsp;&nbsp;<font size=1><a href=$_SERVER[PHP_SELF]?do=edit>Refresh</a></font>"; db_connect(); $sql = "SELECT * FROM announcement ORDER BY id DESC"; $result = mysql_query($sql) or die ("Unknown mySQL error"); mysql_num_rows($result) or die ("<br><i>Nothing is currently on the to-do list</i>"); echo"<table border=1 bordercolor=\"#C0C0C0\" style=\"font-size: 12px; border-collapse: collapse\" cellpadding=\"0\" cellspacing=\"0\"><tr><td width=30><b>ID</b></td><td width=300><b>Item</b></td><td width=170><b>Content</b></td><td width=80><b>Date</b></td></tr></font>"; while ($row = mysql_fetch_array($result)) { echo"<tr><td><font size=1 face=courier>$row[id]</font></td><td><font size=1 face=courier>$row[title]</font></td><td><font size=1 face=courier>$row[content]</font></td><td><font size=1 face=courier>$row[date_time]</font></td></tr>"; } echo"</td></tr></table><br><br><center><a href=$_SERVER[PHP_SELF]><font color=black>TO-DO List</font></a><br><font size=1 color=#C0C0C0></font></center></table></body></html>"; } if ($_GET['do']=="edit") { if(isset($add)) { db_connect(); $sql = "INSERT INTO announcement (title, date_time, content) VALUES ('$item1', '$date1', '$notes1')"; mysql_query($sql); todoedit(); } elseif(isset($update)) { db_connect(); $sql = "UPDATE announcement SET title='$item2', date_time='$date2', content='$notes2' WHERE id='$id2'"; mysql_query($sql); todoedit(); } elseif(isset($delete)) { db_connect(); $sql = "DELETE FROM announcement WHERE id='$id'"; mysql_query($sql); todoedit(); } elseif(!isset($add) || !isset($delete) || !isset($update)) { todoedit(); } } else { todo(); } ?> //The script with ext. php is attached with the mesg.in case you want to trace it --------------------------------- Do you Yahoo!? Yahoo! Photos: High-quality 4x6 digital prints for 25¢