[SOLVED] Need Help - Cannot Write Info to DB

TNGuy03 · May 9, 2007

I'm hoping someone can help me here. I had this script working for a couple days and was fiddling around with it, which now has me unable to write the form data to my db table. The email confirmations are still being sent without any problems but the data isn't being stored. I'm sure it's something simple, but I'm still new to this and just can't see it.

<?php

$email = "webmaster@liketolaugh.com";

$browser = $HTTP_USER_AGENT;

$sub = $_POST['subject'];

$require = $_POST['require'];

if(!empty($_POST['Submit']))

{

if(!($connection=@mysql_connect($hostName, $userName, $password)))

die("Cannot connect");

$first = mysqlclean($_POST, "first", 8, $connection);

$sex = mysqlclean($_POST, "sex", 6, $connection);

$age = mysqlclean($_POST, "age", 12, $connection);

$browse = mysqlclean($_POST, "browser", 30, $connection);

$modem = mysqlclean($_POST, "modem", 15, $connection);

$frequent = mysqlclean($_POST, "frequent", 25, $connection);

$reason = mysqlclean($_POST, "reason", 50, $connection);

$return = mysqlclean($_POST, "return", 18, $connection);

$rec = mysqlclean($_POST, "recommend", 18, $connection);

$viewer = mysqlclean($_POST, "email", 50, $connection);

$ip = $_SERVER['REMOTE_ADDR'];

if(!mysql_select_db($databaseName, $connection))

showerror();

$query = "INSERT INTO u_survey VALUES

(NULL, '{$first}', '{$sex}', '{$age}', '{$browse}', '{$modem}', '{$frequent}', '{$reason}', '{$return}', '{$rec}', '{$ip}')";

if(!(@mysql_query($query, $connection)))

echo 'The survey response could not be recorded in the database';

//START OF THANKS MESSAGE

$thanks = "

<b>Thank you for completing the Like to Laugh site survey!<br><br></b>

We are always looking for ways to improve our site to make the experiences of our visitors - individuals like you - as enjoyable as possible. Thank you again for taking your time to complete this survey. It is greatly appreciated.<br></p>";

//END OF THANKS MESSAGE

$dcheck = explode(",",$require);

while(list($check) = each($dcheck))

{

if(!$$dcheck[$check]) {

$error .= "You did not enter this field: <b>$dcheck[$check]</b><br>";

}

if ((!ereg(".+\@.+\..+", $viewer)) || (!ereg("^[a-zA-Z0-9_@.-]+$", $viewer))){

$error .= "<br>Wrong e-mail.<br>Your e-mail address <b>$viewer</b> is not valid. Please re-enter your e-mail address.";

}

if($error)

{

echo $error;

echo '<br><br><a href="#" onClick="history.go(-1)">Please try again</a>';

}

else

{

//START OF INCOMING MESSAGE (this message goes to your inbox)

$message = "

Someone has completed the Like to Laugh Site Survey!

Q: Is this the first time you have visited our site?

A: $first

Please tell us about yourself:

Q: What is your sex?

A: $sex

Q: What is your age?

A: $age

Q: Which web browser do you use?

A: $browse

Q: What is your modem access speed to the Internet?

A: $modem

Q: How often do you visit our site?

A: $frequent

Q: Why did you visit our site today?

A: $reason

Q: How likely are you to return to this website?

A: $return

Q: How likely are you to recommend this website?

A: $rec

-----------------------------

Browser: $browser

IP: $ip

";

//END OF INCOMING MESSAGE (this message goes to your inbox)

$subject = "Like to Laugh Site Survey Response"; //subject OF YOUR INBOX MESSAGE sent to you

$subject2 = "Thank You for Your Survey Response!"; //subject of OUTGOING MESSAGE - edit this

//OUTGOING MESSAGE TEXT

$message2 = "Thank you for completing the Like to Laugh site survey!

We are always looking for ways to improve our site to make the experiences of our visitors - individuals like you - as enjoyable as possible. Thank you again for taking your time to complete this survey. It is greatly appreciated.

";

//END OF outgoing MESSAGE

mail($email,"$subject","$message","From: $Name <$viewer>");

mail($viewer,"$subject2","$message2","From: <$email>");

echo "$thanks";

}

else

{

echo '

<tr>

<font size="2"><b>Welcome to Like to Laugh\'s Online Visitor Survey!</b></font><p>

<font size="2">This survey will take less than one minute of your

time to complete. Please take this small amount of time to

help Like to Laugh learn more about the individuals visiting our

site so that we can make your future experiences with us even

better. Your help and contribution to current and future site

improvements is greatly appreciated.</font></td>

</tr>

<tr>

</tr>

<tr>

<td colspan="9"><b><font size="2">Is this the first time you have visited our site?</font></b></td>

</tr>

<tr>

<option selected>Choose One</option>

</select></td>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

<td colspan="9"><b><font size="2">Please tell us about yourself.</font></b></td>

</tr>

<tr>

</tr>

<tr>

<option selected>Choose One</option>

<option>Female</option>

</select></td>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

<option selected>Choose One</option>

<option>Under 13</option>

<option>65 or older</option>

</select></td>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

<td colspan="9"><b><font size="2">Which web browser do you use?</font></b></td>

</tr>

<tr>

<option selected>Choose One</option>

<option>Netscape 4.0 or more</option>

<option>Netscape 3.0 or less</option>

<option>Internet Explorer 4.0 or more</option>

<option>Internet Explorer 3.0 or less</option>

<option>Other</option>

</select></td>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

<td colspan="9"><b><font size="2">What is your modem access speed to the Internet?</font></b></td>

</tr>

<tr>

<option selected>Choose One</option>

<option>Cable/ISDN</option>

<option>Other</option>

</select></td>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

<td colspan="9"><b><font size="2">How often do you visit our site?</font></b></td>

</tr>

<tr>

<option selected>Choose One</option>

<option>Daily</option>

<option>3-4 times per week</option>

<option>2-3 times per month</option>

<option>Once per month</option>

<option>Less than monthly</option>

<option>Other</option>

</select></td>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

<td colspan="9"><b><font size="2">Why did you visit our site today?</font></b></td>

</tr>

<tr>

<option selected>Choose One</option>

<option>Looking for videos</option>

<option>Looking for audio clips</option>

<option>To play games</option>

<option>Looking for pics & toons</option>

<option>Looking for jokes</option>

<option>Looking for pranks</option>

<option>Looking for insults</option>

<option>To use LTL Messaging</option>

<option>To inquire about advertising</option>

<option>To find company contact information</option>

<option>To request general company information</option>

<option>Other</option>

</select></td>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

<td colspan="9"><b><font size="2">How likely are you to:</font></b></td>

</tr>

<tr>

<td><i><font size="2">Return to this website?</font></i></td>

</tr>

<tr>

<option selected>Choose One</option>

<option>Very Likely</option>

<option>Somewhat Likely</option>

<option>Somewhat Unlikely</option>

<option>Not Likely</option>

</select></td>

</tr>

<tr>

</tr>

<tr>

<td><i><font size="2">Recommend this website?</font></i></td>

</tr>

<tr>

<option selected>Choose One</option>

<option>Very Likely</option>

<option>Somewhat Likely</option>

<option>Somewhat Unlikely</option>

<option>Not Likely</option>

</select></td>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

<td colspan="9"><b><font size="2">Your email address:</font></b></td>

</tr>

<tr>

</tr>

<tr>

</td>

</tr>

<tr>

</tr>

</table>

</div>

</form>';

}

?>

Thanks!

Dan

jitesh · May 9, 2007

Follow this and run this echo contents in mysql.

$query = "INSERT INTO u_survey VALUES

(NULL, '{$first}', '{$sex}', '{$age}', '{$browse}', '{$modem}', '{$frequent}', '{$reason}', '{$return}', '{$rec}', '{$ip}')";

echo $query;

exit;

TNGuy03 · May 9, 2007

Thank you, jitesh. As I expected a simple fix and I am happy to have it resolved.

Regards,

Dan

Sign In

[SOLVED] Need Help - Cannot Write Info to DB

Recommended Posts

TNGuy03

Link to comment

Share on other sites

jitesh

Link to comment

Share on other sites

TNGuy03

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information