Updating database using php
First thing you'll need to learn is to know how to post submission data to your thank you page.You can read and learn from the this guide: Assuming that you have set your form to post data to a custom URL page, you will have do some PHP/My SQL programming to do a form to My SQL.I don't have the form currently redirecting to another page because right now I can't even get the update to work. at a quick glance I can advise the following: You will probably need to surround your SET variables with quotes, ie: [ICODE]"...But, I eventually want to display a confirmation message either on the same or a different page. SET Publish Date='$update' ..."[/ICODE] Also, assuming that Publish Date is a datetime field of some sort in your database, you will need to …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']; ?Thus, you are actually now able to make very advanced and dynamic web solutions, where the users can maintain and update a database using forms.
In this lesson, we will look at how to update a database, i.e., edit the values of existing fields in the table.close(); /** HELPER FUNCTIONS BELOW **/ /** * Connect to a my SQL Database * The values used here are specific to this sandbox environment; * Replace these values with your my SQL server values.* */ function connect_to_db() function setup_table($db, $table) function add_three_records($db, $table) function print_table($db, $table) ?Read More around the variable in the middle, so that MYSQL will treat it as a string value: [i CODE]"UPDATE Books SET Publish Date='$update' where Book ID = '".$bookid."'";[/i CODE] is Book ID an integer?
if so, you will not need the single quotes around it and your code should look like: [i CODE]"UPDATE Books SET Publish Date='$update' where …
And if there is no submission ID matching, then a new insert is going to be made: Is it possible to get someone at Jot Form to help us bridge via API to Solve360 CRM?