cldepo

I'm new to PHP and I'm trying to build a mock address book. DW CC keeps telling me that there are two syntax errors on lines 113 and 226, please help me figure what the issue is! Thanks! 1: <?php 2: include 'ch20_include.php'; 3: doDB(); 4: 5: if ((!$_POST) | | ($_GET[ 'master_id' ] != "")) { 6: // haven't seen the form, so show it 7: $display_block = " 8: <form method=\"post\" action=\"".$_SERVER [ ' PHP_SELF ' ] ."\" >"; 9: if (isset($_GET[ ' master_id ' ])) { 10: // create safe version of ID 11: $safe_id = mysqli_real_escape_string( $mysqli, $_GET [ ' master_id' ]); 12: 13: // get first, last names for display/ tests validity 14: $get_names_sql = "SELECT concat_ws( ' ', f_name, l_name) AS display_name 15: FROM master_name WHERE id = ' " .$safe_id. " ' " ; 16: $get_names_res = mysqli_query($mysqli, $get_names_sql) 17: or die(mysqli_error( $mysqli)) ; 18: 19: if (mysqli_num_rows ($get_names_res) == 1) { 20: while ($name_info = mysqli_fetch_array($get_names_res)) { 21: $display_name = stripslashes($name_info[ ' display_name ']); 22: } 23: } 24: } 25: 26: if (isset($display_name)) { 27: $display_block .= "<p>Adding information for 28: <strong>$display_name</strong>:</p>"; 29: } else { 30: $display_block .= <<<END_OF_TEXT <fieldset> 31: <legend>First/Last Names:</legend><br/> 32: <input type="text" name="f_name" size="30" 33: maxlength="75" required="required" /> 34: <input type="text" name="l_name" size="30" 35: maxlength="75" required="required" /> 36: </fieldset> 37: END_OF_TEXT; 38: } 39: $display_block .= <<<END_OF_TEXT 40: <p><label for="address">Street Address:</label><br/> 41: <input type="text" id="address" name="address" 42: size="30" /></p> 43: 44: <fieldset> 45: <legend>City/State/Zip:</legend><br/> 46: <input type="text" name="city" size="30" maxlength="50" /> 47: <input type="text" name="state" size="5" maxlength="2" /> 48: <input type="text" name="zipcode" size="10" maxlength="10" /> 49: </fieldset> 50: 51: <fieldset> 52: <legend>Address Type:</legend><br/> 53: <input type="radio" id="add_type_h" name="add_type" 54: value="home" checked /> 55: <label for="add_type_h">home</label> 56: <input type="radio" id="add_type_w" name="add_type" 57: value="work" /> 58: <label for="add_type_w">work</label> 59: <input type="radio" id="add_type_o" name="add_type" 60: value="other"/> 61: <label for="add_type_o">other</label> 62: </fieldset> 63: 64: <fieldset> 65: 66: <legend>Telephone Number:</legend><br/> 67: <input type="text" name="tel_number" size="30" maxlength="25" /> 68: <input type="radio" id="tel_type_h" name="tel_type" 69: value="home" checked /> 70: <label for="tel_type_h">home</label> 71: <input type="radio" id="tel_type_w" name="tel_type" 72: value="work" /> 73: <label for="tel_type_w">work</label> 74: <input type="radio" id="tel_type_o" name="tel_type" 75: value="other" /> 76: <label for="tel_type_o">other</label> 77: </fieldset> 78: 79: <fieldset> 80: <legend>Fax Number:</legend><br/> 81: <input type="text" name="fax_number" size="30" maxlength="25" /> 82: <input type="radio" id="fax_type_h" name="fax_type" 83: value="home" checked /> 84: <label for="fax_type_h">home</label> 85: <input type="radio" id="fax_type_w" name="fax_type" 86: value="work" /> 87: <label for="fax_type_w">work</label> 88: <input type="radio" id="fax_type_o" name="fax_type" 89: value="other" /> 90: <label for="fax_type_o">other</label> 91: </fieldset> 92: 93: <fieldset> 94: <legend>Email Address:</legend><br/> 95: <input type="email" name="email" size="30" maxlength="150" /> 96: <input type="radio" id="email_type_h" name="email_type" 97: value="home" checked /> 98: <label for="email_type_h">home</label> 99: <input type="radio" id="email_type_w" name="email_type" 100: value="work" /> 101: <label for="email_type_w">work</label> 102: <input type="radio" id="email_type_o" name="email_type" 103: value="other" /> 104: <label for="email_type_o">other</label> 105: </fieldset> 106: 107: <p><label for="note">Personal Note:</label><br/> 108: <textarea id="note" name="note" cols="35" 109: rows="3"></textarea></p> 110: END_OF_TEXT; 111: if ($_GET) { 112: $display_block .= "<input type=\"hidden\" name=\"master_id\" 113: value=\"".$_GET['master_id'] ."\" >"; 114: } 115: $display_block .= <<<END_OF_TEXT 116: <button type="submit" name="submit" 117: value="send">Add Entry</button> 118: </form> 119: END_OF_TEXT; 120: } else if ($_POST) { 121: // time to add to tables, so check for required fields 122: if ((($_POST['f_name'] == "") || ($_POST[‘l_name'] == "")) && 123: (!isset($_POST['master_id']))) { 124: header("Location: addentry.php"); 125: exit; 126: } 127: 128: // connect to database 129: doDB(); 130: // create clean versions of input strings 131: $safe_f_name = mysqli_real_escape_string($mysqli, 132: $_POST['f_name']); 133: $safe_l_name = mysqli_real_escape_string($mysqli, 134: $_POST['l_name']); 135: $safe_address = mysqli_real_escape_string($mysqli, 136: $_POST['address']); 137: $safe_city = mysqli_real_escape_string($mysqli, 138: $_POST['city']); 139: $safe_state = mysqli_real_escape_string($mysqli, 140: $_POST[ state']); 141: $safe_zipcode = mysqli_real_escape_string($mysqli, 142: $_POST['zipcode']); 143: $safe_tel_number = mysqli_real_escape_string($mysqli, 144: $_POST['tel_number']); 145: $safe_fax_number = mysqli_real_escape_string($mysqli, 146: $_POST['fax_number']); 147: $safe_email = mysqli_real_escape_string($mysqli, 148: $_POST['email']); 149: $safe_note = mysqli_real_escape_string($mysqli, 150: $_POST['note']); 151: 152: if (!$_POST['master_id']) { 153: // add to master_name table 154: $add_master_sql = "INSERT INTO master_name (date_added, date_modified, 155: f_name, l_name) VALUES (now(), now(), 156: '".$safe_f_name."', '".$safe_l_name."')"; 157: $add_master_res = mysqli_query($mysqli, $add_master_sql) 158: or die(mysqli_error($mysqli)); 159: 160: // get master_id for use with other tables 161: $master_id = mysqli_insert_id($mysqli); 162: } else { 163: $master_id = mysqli_real_escape_string($mysqli, $_POST['master_id']); 164: } 165: 166: if (($_POST['address']) || ($_POST['city']) || 167: ($_POST['state']) || ($_POST['zipcode'])) { 168: // something relevant, so add to address table 169: $add_address_sql = "INSERT INTO address (master_id, 170: date_added, date_modified, address, city, state, 171: zipcode, type) VALUES 172: ('".$master_id."', now(), now(), 173: '".$safe_address."', '".$safe_city."', 174: '".$safe_state."' , '".$safe_zipcode."' , 175: '".$_POST[‘add_type']."')"; 176: $add_address_res = mysqli_query($mysqli, $add_address_sql) 177: or die(mysqli_error($mysqli)); 178: } 179: 180: if ($_POST['tel_number']) { 181: // something relevant, so add to telephone table 182: $add_tel_sql = "INSERT INTO telephone (master_id, date_added, 183: date_modified, tel_number, type) VALUES 184: ('".$master_id."', now(), now(), 185: '".$safe_tel_number."', '".$_POST[‘tel_type']."')"; 186: $add_tel_res = mysqli_query($mysqli, $add_tel_sql) 187: or die(mysqli_error($mysqli)); 188: } 189: 190: if ($_POST['fax_number']) { 191: // something relevant, so add to fax table 192: $add_fax_sql = "INSERT INTO fax (master_id, date_added, 193: date_modified, fax_number, type) VALUES 194: ('".$master_id."', now(), now(), '".$safe_fax_number."', 195: '".$_POST['fax_type']."')"; 196: $add_fax_res = mysqli_query($mysqli, $add_fax_sql) 197: or die(mysqli_error($mysqli)); 198: } 199: if ($_POST['email']) { 200: // something relevant, so add to email table 201: $add_email_sql = "INSERT INTO email (master_id, date_added, 202: date_modified, email, type) VALUES 203: ('".$master_id."', now(), now(), '".$safe_email."', 204: '".$_POST['email_type']."')"; 205: $add_email_res = mysqli_query($mysqli, $add_email_sql) 206: or die(mysqli_error($mysqli)); 207: } 208: 209: if ($_POST['note']) { 210: // something relevant, so add to notes table 211: $add_notes_sql = "UPDATE personal_notes set note = 212: '".$safe_note."', date_modified = now() 213: WHERE master_id = '".$master_id."'"; 214: } 215: mysqli_close($mysqli); 216: $display_block = "<p>Your entry has been added. Would you 217: like to <a href=\"addentry.php\">add another</a>?</p>"; 218: } 219: ?> 220: <!DOCTYPE html> 221: <head> 222: <title>Add an Entry</title> 223: </head> 224: <body> 225: <h1>Add an Entry</h1> 226: <?php echo $display_block; ?> 227: </body> 228: </html>