The below code should be allowing me to modify entries which i choose from the script before hand, however it give the 500 error code.
it generates ......
http://tramp-space.co.uk/edittest/te...hp?master_id=1
where 1 is the record number (which exists)
Im baffled. can anybody help me please?
Expand|Select|Wrap|Line Numbers
- <?php
- if ((!$_POST) || (isset($_GET["master_id"] !=" ")) {
- //haven't seen the form, so show it
- $display_block = "
- <form method=\"post\" action=\"".$_SERVER["PHP_SELF"]."\">";
- if (isset($_GET["master_id"])) {
- //connect to database
- $mysqli = mysqli_connect("localhost", "web88-farmer", "whitep8", "web88-farmer");
- //get first, last names for display/tests validity
- $get_names_sql = "SELECT concat_ws('', f_name, l_name) AS display_name
- FROM master_name WHERE id = '".$_GET["master_id"]."'";
- $get_names_res = mysqli_query($mysqli, $get_names_sql)
- or die(mysqli_error($mysqli));
- if (mysqli_num_rows($get_names_res) == 1) {
- while ($name_info = mysqli_fetch_array($get_names_res)) {
- $display_name = stripslashes($name_info['display_name']);
- }
- }
- }
- if (isset($display_name)) {
- $display_block .= "<p>Adding information for
- <strong>$display_name</strong>:</p>";
- } else {
- $display_block .= "
- <p><strong>First/Last Names:</strong><br/>
- <input type=\"text\" name=\"f_name\" size=\"30\" maxlength=\"75\">
- <input type=\"text\" name=\"l_name\" size=\"30\" maxlength=\"75\">";
- }
- $display_block .= "<p><strong>Address:</strong><br/>
- <input type=\"text\" name=\"address1\" size=\"30\"></p>
- <input type=\"text\" name=\"address2\" size=\"30\"></p>
- <p><strong>City/State/Zip:</strong><br/>
- <input type=\"text\" name=\"city\" size=\"30\" maxlength=\"50\">
- <input type=\"text\" name=\"county\" size=\"20\" maxlength=\"20\">
- <input type=\"text\" name=\"post_code\" size=\"10\" maxlength=\"10\"></p>
- <p><strong>Address Type:</strong><br/>
- <input type=\"radio\" name=\"add_type\" value=\"home\" checked> home
- <input type=\"radio\" name=\"add_type\" value=\"work\"> work
- <input type=\"radio\" name=\"add_type\" value=\"other\"> other</p>
- <p><strong>Telephone Number:</strong><br/>
- <input type=\"text\" name=\"tel_number\" size=\"30\" maxlength=\"25\">
- <input type=\"radio\" name=\"tel_type\" value=\"home\" checked> home
- <input type=\"radio\" name=\"tel_type\" value=\"work\"> work
- <input type=\"radio\" name=\"tel_type\" value=\"other\"> other</p>
- <p><strong>Fax Number:</strong><br/>
- <input type=\"text\" name=\"fax_number\" size=\"30\" maxlength=\"25\">
- <input type=\"radio\" name=\"fax_type\" value=\"home\" checked> home
- <input type=\"radio\" name=\"fax_type\" value=\"work\"> work
- <input type=\"radio\" name=\"fax_type\" value=\"other\"> other</p>
- <p><strong>Email Address:</strong><br/>
- <input type=\"text\" name=\"email\" size=\"30\" maxlength=\"150\">
- <input type=\"radio\" name=\"email_type\" value=\"home\" checked> home
- <input type=\"radio\" name=\"email_type\" value=\"work\"> work
- <input type=\"radio\" name=\"email_type\" value=\"other\"> other</p>
- <p><strong>Personal Note:</strong><br/>
- <textarea name=\"note\" cols=\"35\" rows=\"3\" wrap=\"virtual\"></textarea></p>";
- if ($_GET) {
- $display_block .= "<input type=\"hidden\" name=\"master_id\" value=\"".$_GET["master_id"]."\">";
- }
- $display_block .= "<p><input type=\"submit\" name=\"submit\" value=\"Add Entry\"></p>
- </form>";
- } else if ($_POST) {
- //time to add to tables, so check for required fields
- if ((($_POST["f_name"] == "") || ($_POST["l_name"] == "")) &&
- (!isset($_POST["master_id"]))) {
- header("Location: addentry.php");
- exit;
- }
- //connect to database
- $mysqli = mysqli_connect("localhost", "web88-farmer", "whitep8", "web88-farmer");
- if (!$_POST["master_id"]) {
- //add to master_name table
- $add_master_sql = "INSERT INTO master_name (date_added, date_modified, f_name, l_name)
- VALUES (now(), now(), '".$_POST["f_name"]."', '".$_POST["l_name"]."')";
- $add_master_res = mysqli_query($mysqli, $add_master_sql) or die(mysqli_error($mysqli));
- //get master_id for use with other tables
- $master_id = mysqli_insert_id($mysqli);
- } else {
- $master_id = $_POST["master_id"];
- }
- if (($_POST["address1"]) || ($_POST["address2"]) ||($_POST["city"]) || ($_POST["county"]) || ($_POST["post_code"])) {
- //something relevant, so add to address table
- $add_address_sql = "INSERT INTO address (master_id, date_added, date_modified,
- address1, address2, city, county, post_code, type) VALUES ('".$master_id."',
- now(), now(), '".$_POST["address1"]."', '".$_POST["address2"]."', '".$_POST["city"]."',
- '".$_POST["county"]."' , '".$_POST["post_code"]."' , '".$_POST["add_type"]."')";
- $add_address_res = mysqli_query($mysqli, $add_address_sql) or die(mysqli_error($mysqli));
- }
- if ($_POST["tel_number"]) {
- //something relevant, so add to telephone table
- $add_tel_sql = "INSERT INTO telephone (master_id, date_added, date_modified,
- tel_number, type) VALUES ('".$master_id."', now(), now(),
- '".$_POST["tel_number"]."', '".$_POST["tel_type"]."')";
- $add_tel_res = mysqli_query($mysqli, $add_tel_sql) or die(mysqli_error($mysqli));
- }
- if ($_POST["fax_number"]) {
- //something relevant, so add to fax table
- $add_fax_sql = "INSERT INTO fax (master_id, date_added, date_modified,
- fax_number, type) VALUES ('".$master_id."', now(), now(),
- '".$_POST["fax_number"]."', '".$_POST["fax_type"]."')";
- $add_fax_res = mysqli_query($mysqli, $add_fax_sql) or die(mysqli_error($mysqli));
- }
- if ($_POST["email"]) {
- //something relevant, so add to email table
- $add_email_sql = "INSERT INTO email (master_id, date_added, date_modified,
- email, type) VALUES ('".$master_id."', now(), now(),
- '".$_POST["email"]."', '".$_POST["email_type"]."')";
- $add_email_res = mysqli_query($mysqli, $add_email_sql) or die(mysqli_error($mysqli));
- }
- if ($_POST["note"]) {
- //something relevant, so add to notes table
- $add_notes_sql = "UPDATE personal_notes set note = '".$_POST["note"]."' WHERE
- master_id = '".$master_id."'";
- $add_notes_res = mysqli_query($mysqli, $add_notes_sql) or die(mysqli_error($mysqli));
- }
- mysqli_close($mysqli);
- $display_block = "<p>Your entry has been added. Would you like to <a href=\"addentry.php\">add another</a>?</p>";
- }
- ?>
- <html>
- <head>
- <title>Add an Entry</title>
- </head>
- <body>
- <h1>Add an Entry</h1>
- <?php echo $display_block; ?>
- </body>
- </html>