buchberg Posted February 21, 2012 Share Posted February 21, 2012 To anyone, Apache 2.2.21/PHP5.3.5/MySQL 5.2.36. The following code returns the below errors. I am trying to get the POSTed values into MySQL. There are no other errors. It's like the code stopped at the ?> closing statement. Why would the code not return the 'echo' statements? Any ideas????? Much appreciated....Buchberg Notice: Use of undefined constant id - assumed 'id' in C:\website\do_addrecord_auth_users.php on line 2 Notice: Undefined index: id in C:\website\do_addrecord_auth_users.php on line 2 <? if ((!$_POST[id]) || (!$_POST[f_name]) || (!$_POST[l_name]) || (!$_POST[username]) || (!$_POST[password]) || (!$_POST[firm]) || (!$_POST[email])) { ("Location: /show_addrecord_auth_users.html"); exit; } $db_name="booster"; $table_name="auth_users"; $connection=mysql_connect("localhost", "username", "password") or die (mysql_error()); $db=mysql_select_db($db_name, $connection) or die (mysql_error()); $sql="INSERT INTO $table_name (id, f_name, l_name, username, password, firm, email) VALUES ('$_POST[id]', '$_POST[f_name]', '$_POST[l_name]', '$_POST[username]', '$_POST[password]', '$_POST[firm]', '$_POST[email]')"; $result=mysql_query($sql, $connection) or die (mysql_error()); ?> <HTML> <HEAD> <TITLE>Add a record to Auth Users</TITLE> </HEAD> <BODY> <H1>Adding a record to <? echo "$table_name"; ?></H1> <TABLE CELLSPACING=3 CELLPADDING=3> <TR> <TD VALIGN=TOP> <P>id<BR> <? echo "$_POST[id]"; ?></P> </TD> <TD VALIGN=TOP> <P>First Name<BR> <? echo "$_POST[f_name]"; ?></P> </TD> <TD VALIGN=TOP> <P>Last Name<BR> <? echo "$_POST[l_name]"; ?></P> </TD> <TD VALIGN=TOP> <P>Username<BR> <? echo "$_POST[username]"; ?></P> </TD> <TD VALIGN=TOP> <P>Password<BR> <? echo "$_POST[password]"; ?></P> </TD> <TD VALIGN=TOP> <P>Firm<BR> <? echo "$_POST[firm]"; ?></P> </TD> <TD VALIGN=TOP> <P>email<BR> <? echo "$_POST[email]"; ?></P> </TD> <P><a href="show_addrecord_auth_users.html">Add Another</a></P> </TD> </TR> </TABLE> </BODY> </HTML> Quote Link to comment https://forums.phpfreaks.com/topic/257422-php-no-echo-statements-or-data-posted/ Share on other sites More sharing options...
Pikachu2000 Posted August 28, 2012 Share Posted August 28, 2012 $_POST['id'] doesn't exist, and you mangled the header() call, so it's just running flat into the exit(), and well, exiting. Quote Link to comment https://forums.phpfreaks.com/topic/257422-php-no-echo-statements-or-data-posted/#findComment-1373077 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.