The current code does not distinguish between creating a new wish case and updating an existing one. My SQL users: Click here to download the source code that reflects the project state after the lesson is completed.
Data can be updated into My SQL tables by executing SQL UPDATE statement through PHP function mysql_query.Below is a simple example to update records into employee table.I don't have the form currently redirecting to another page because right now I can't even get the update to work.But, I eventually want to display a confirmation message either on the same or a different page. You can view my pages online here: need help with the "Edit" section, if you look online.
Here is the code for my Edit page: query($sql) or die(mysql_error()); $query=getenv(QUERY_STRING); parse_str($query); //$ud_title = $_POST['Title']; //$ud_pub = $_POST['Publisher']; //$ud_pubdate = $_POST['Publish Date']; //$ud_img = $_POST['Image']; ?
If the wish is edited, the value of the hidden field must change to the ID of the wish.
To create this hidden field, add the following line to the top of the Now you need to update the code that verifies the input data and inserts the wish to the database.
The value of the hidden field must be retrieved from the $wish array.
The value must be an empty string during the creation of a new wish.
Only the partitions (or subpartitions) listed are checked for matches, and a row that is not in any of these partitions or subpartitions is not updated, whether it satisfies the clause, are flagged as unsafe for statement-based replication.