twilitegxa Posted July 8, 2009 Share Posted July 8, 2009 Can anyone help figure out what I am missing? Here is the error being produced upon opening the page: Parse error: parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING' in C:\wamp\www\addentry.php on line 62 And here is the code: <?php if ($_POST['op'] != "add") { //havent seen the form, so show it $display_block = "<h1>Add An Entry</h1> <form method=\"post\" action=\"$_SERVER[php_SELF]\"> <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></p> <p><strong>Address:</strong><br> <iput 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=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=5 wrap=virtual></textarea> <input type=\"hidden\" name=\"op\" value=\"add\"></p> <p><input type=\"submit\" name=\"submit\" value=\"Add Entry\"></p> </form>"; } else if ($_POST['op'] == "add") { //time to add to tables, so check for required fields if (($_POST['f_name'] == "") || ($_POST['l_name'] == "")) { header("Location: addentry.php"); exit; } //connect to database $conn = mysql_connect("localhost", "root", "") or die(mysql_error()); mysql_select_db("smrpg",$conn) or die(mysql_error()); //add to master_name table $add_master = "insert into master_name values ('', now(), now(), '$_POST['f_name']', '$_POST['l_name']')"; mysql_query($add_master) or die(mysql_error()); //get master_id for use with other tables $master_id = msql_insert_id(); if (($_POST['address']) || ($_POST['city']) || ($_POST['state']) || ($_POST['zipcode'])) { //something relevant, so add to address book $add_address = "insert into address values ('', $master_id, now(), now(), '$_POST['address']', '$_POST['city']', '$_POST['state']', '$_POST['zipcode']', '$_POST['add_type']')"; mysql_query($add_address) or die(mysql_error()); } if ($_POST['tel_number']) { //something relevant, so add to telephone table $add_tel = "insert into telephone values ('', $master_id, now(), now(), '$_POST['tel_phone']', '$_POST['tel_type']')"; mysql_query($add_tel) or die(mysql_error()); } if ($_POST['fax_number']) { //something relevant, so add to fax table $add_fax = "insert into fax values ('', $master_id, now(), now(), '$_POST['fax_number']', '$_POST['fax_type']')"; mysql_query($add_fax) or die(mysql_error()); } if ($_POST['email']) { //something relevant, so add to email table $add_email - "insert into email values ('', $master_id, now(), now(), '$_POST['email']', '$_POST['email_type']')"; mysql_query($add_email) or die(mysql_error()); } if ($_POST['note']) { //something relevant, so add to notes table $add_note - "insert into personal_notes value ('', $master_id, now(), now(), '$_POST['note']')"; mysql_query($add_note) or die(mysql_error()); } $display_block = "<h1>Entry Added</h1> <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> <?php print $display_block; ?> </body> </html> These are lines 60-63: //add to master_name table $add_master = "insert into master_name values ('', now(), now(), '$_POST['f_name']', '$_POST['l_name']')"; mysql_query($add_master) or die(mysql_error()); Link to comment https://forums.phpfreaks.com/topic/165152-solved-parse-error-expecting-t_string-or-t_variable-or-t_num_string/ Share on other sites More sharing options...
ignace Posted July 8, 2009 Share Posted July 8, 2009 $add_master = 'insert into master_name values (NULL, now(), now(), ' . $_POST['f_name'] . ', ' . $_POST['l_name'] . ')'; you can't use a ' between ' (the same applies for ") it breaks your code. This error occurs when php tries to parse everything in " Link to comment https://forums.phpfreaks.com/topic/165152-solved-parse-error-expecting-t_string-or-t_variable-or-t_num_string/#findComment-870860 Share on other sites More sharing options...
twilitegxa Posted July 8, 2009 Author Share Posted July 8, 2009 Thanks! I just took out all the single quotes between the first set of single quotes, and that fixed the problem! :-) Link to comment https://forums.phpfreaks.com/topic/165152-solved-parse-error-expecting-t_string-or-t_variable-or-t_num_string/#findComment-871291 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.