This is my script:
<?php include 'include.php'; //investors addinvestor.php if ((!$_POST) || ($_GET['inv_id'] != "")) { $display_block = ""; if (isset($_GET['inv_id'])) { $safe_id = mysqli_real_escape_string($mysqli, $_GET['inv_id']); $get_name_sql = "SELECT name FROM investors WHERE inv_id = '".$safe_id."'"; $get_name_res = mysqli_query($mysqli, $get_name_sql) or die(mysqli_error($mysqli)); if (mysqli_num_rows($get_name_res) == 1) { while ($name_info = mysqli_fetch_array($get_name_res)) { $display_name = stripslashes($name_info['name']); } } } if (isset($display_name)) { $display_block .= "Adding information for $display_name:
"; } else { $display_block .= <<<END_OF_TEXT Name:END_OF_TEXT; } $display_block .= <<<END_OF_TEXT Address:
Phone Number:
URL:
END_OF_TEXT; if ($_GET) { $display_block .= ""; } $display_block .= <<<END_OF_TEXT Add Entry END_OF_TEXT; } else if ($_POST) { if (($_POST['name'] == "") and (!isset($_POST['inv_id'])) { header("Location: addinvestor.php"); exit; } doDB(); $safe_name = mysqli_real_escape_string($mysqli, $_POST['name']); $safe_address = mysqli_real_escape_string($mysqli, $_POST['address']); $safe_phone = mysqli_real_escape_string($mysqli, $_POST['phone']); $safe_url = mysqli_real_escape_string($mysqli, $_POST['url']); $safe_id = mysqli_real_escape_string($mysqli, $_POST['inv_id']); if ((!$_POST['inv_id']) && ($_POST['name'])) { $add_ins_sql = "INSERT INTO investors (name, address, phone, URL) VALUES ('".$safe_name."', '".$safe_address."', '".$safe_phone."', '".$safe_url."')"; $add_ins_res = mysqli_query($mysqli, $add_ins_sql) or die(mysqli_error($mysqli)); } if ($_POST['address']) { $add_add_sql = "UPDATE investors SET address = '".$safe_address."' WHERE inv_id = '".$safe_id."'"; $add_add_res = mysqli_query($mysqli, $add_add_sql) or die(mysqli_error($mysqli)); } if ($_POST['phone']) { $add_pho_sql = "UPDATE investors SET phone = '".$safe_phone."' WHERE inv_id = '".$safe_id."'"; $add_pho_res = mysqli_query($mysqli, $add_pho_sql) or die(mysqli_error($mysqli)); } if ($_POST['url']) { $add_url_sql = "UPDATE investors SET URL = '".$safe_url."' WHERE inv_id = '".$safe_id."'"; $add_url_res = mysqli_query($mysqli, $add_url_sql) or die(mysqli_error($mysqli)); } mysqli_close($mysqli); $display_block = "
Your entry has been added. Would you like to add another? Or would you like to return to the main page?
"; } ?> Add an InvestorAdd an Investor
<?php echo $display_block; ?> Return to Main Page?"and for some reason it returns “PHP Parse error: syntax error, unexpected ‘{’ in /var/www/html/Aisloc_Directory/addinvestor.php on line 58”
line 58 is " if (($_POST[‘name’] == “”) and (!isset($_POST[‘inv_id’])) { "
I’ve tried messing with it but I can’t seem to fingure it out.
Any help would be greatly appreciated.