Hello again,
I'm having a problem and don't know what is causing it. I'm copying from a book. double checked and can't figure out why I'd be getting this error (below in quotes)
Link to live view of what is being accomplished (trying to be accomplished)
http://skywardz.com/address_book/addEntry.php
LINE 87 :
if(!$_POST['master_id']){Notice: Undefined index: master_id in /hermes.../public_html/address_book/addEntry.php on line 87
Here is the script in full:
<?php
ini_set('display_errors',1);
error_reporting(E_ALL);
if((!$_POST)||(isset($_GET['master_id']))){
//Haven't seen form, so show it
$display_block ="<form method= \"POST\" action= \"".$_SERVER["PHP_SELF"]."\">";
if(isset($_GET['master_id'])){
//connect to database
$mysqli= mysqli_connect("someserverlocation.com","username","password","address_book");
//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 Name:</strong><br/>
<input type=\"text\" name=\"f_name\" size=\"30\" maxlength=\"75\"><br />
<input type=\"text\" name=\"l_name\" size=\"30\" maxlength=\"75\"></p>";
}
$display_block.="<p><strong> Address:</strong><br/>
<input type=\"text\" name=\"address\" size=\"30\"></p>
<p><strong> City/State/Zip:</strong><br/>
<input type=\"text\" name=\"city\" size=\"30\" maxlength=\"50\">
<input type=\"text\" name=\"state\" size=\"5\" maxlength=\"2\">
<input type=\"text\" name=\"zipcode\" size=\"10\" maxlength=\"5\"></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=\"125\">
<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.="<input type=\"submit\" name=\"submit\" value=\"Add Entry\"></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("Loacation:addEntry.php");
exit;
}
//connect to database
$mysqli= mysqli_connect("someserverlocation.com","username","password","address_book");
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["address"])||($_POST["city"])||($_POST["state"])||($_POST["zipcode"])){
//something relevant, so add to address table
$add_address_sql="INSERT INTO address (master_id, date_added, date_modified, address, city, state, zipcode, type) VALUES('".$master_id."',now(),now(), '".$_POST["address"]."','".$_POST["city"]."','".$_POST["state"]."','".$_POST["zipcode"]."','".$_POST["add_type"]."')";
$add_address_res= mysqli_query($mysqli, $add_address_sql) or die (mysqli_error($mysqli));
}
if($_POST["tel_number"]){
$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"]){
$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"]){
$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"]){
$add_notes_sql="UPDATE INTO 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.<br>Would you like to <a href=\"addEntry.php\">add another</a>?";
}
?>