On Friday 12 December 2003 15:43, [EMAIL PROTECTED] wrote:
I keep getting this error:
Notice: Undefined index: tutor_id in /usr/local/..........
What does "undefined index" exactly mean?? I did a search on the web but couldn't find any solutions.
Basically it means you're trying to access a non-existent item in the array.
The line that cause this error is as follow:
$tutor_id = $_POST["tutor_id"];
print_r($_POST)
will show all the items in $_POST. Is your form set to use the "post" method? If not then look in $_GET for your form input data.
------------------------------------------------------------------------------- yah my form has been set to use the POST method:
Are you sure? You print out this form in this script, but that is not how you got here.
echo "<form name=\"edit_tutor\" method=\"post\" action=\"edit2.php\">";
What could be the problem???Or it could be related to "quoting" problem:
Not at all, remember the notice is displayed before you run this query. But always make sure user input is ALWAYS quoted and properly escaped in sql queries. The second form is vulnerable in this case.
$sql = mysql_query ("SELECT * FROM tutor WHERE tutor_id='$tutor_id'"); or $sql = mysql_query ("SELECT * FROM tutor WHERE tutor_id=$tutor_id");
????
What is the right way to define the variable "$tutor_id" ????
-------------------------------------------------------------------------- For reference, I have copied the block of code below:
$dsn = "mysql://root:[EMAIL PROTECTED]/tablename";
//connect to DB $db = DB::connect ($dsn); //check for any DB connection errors if (DB::isError ($db)) die ($db->getMessage());
$action = $_GET["action"];
$tutor_id = $_POST['tutor_id'];
print_r($_POST);
if($action == "delete") { $sql = mysql_query ("DELETE FROM tutor WHERE tutor_id='$tutor_id'");
$result = $db->query($sql);
if( DB::isError($result) ) { die ($result->getMessage()); }
echo "<a href='../index/timetable_main.php'>Back to main</a>"; }
if($action == "edit") { $sql = mysql_query ("SELECT * FROM tutor WHERE tutor_id='$tutor_id'");
$row = mysql_fetch_array($sql);
echo "<form name=\"edit_tutor\" method=\"post\" action=\"edit2.php\">"; echo "Tutor ID : ".$row['tutor_id']."<br>"; echo "<input type=\"hidden\" name=\"tutor_id\" value=\"".$row ['tutor_id']."\">"; echo "Name : <input name=\"tutor_name\" type=\"text\" value=\"".$row ['tutor_name']."\"><br>"; echo "Contact No : <input type=\"text\" name=\"tutor_contact\" value=\"".$row ['tutor_contact']."\"><br>"; echo "E-mail : <input type=\"text\" name=\"tutor_email\" value=\"".$row ['tutor_email']."\"><br>"; echo "Profile : <input type=\"text\" name=\"tutor_profile\" value=\"".$row ['tutor_profile']."\"><br>"; echo "<input type=\"submit\" name=\"Submit\" value=\"Update\">"; echo "</form>";
} ?>
echo "The entry has been deleted <br><br>";
For reference, i have copied the block of code below:
Irin.
Jason has explained it to you: you are accessing a variable or an array index that has not been defined. Rethink your logic.
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
