Page 1 of 1

Error querrying database

Posted: Tue Oct 05, 2010 6:10 pm
by srchulo
Hey, So below is my PHP code and I'm trying to send values into my database, and this is the answer that I'm getting: Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/srchulo/public_html/jdcode/survey.php on line 68
Error querying database

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Survey Completed</title>
</head>
<body>
<p>That completes the research project. Thank you for your help.</p>


<?php

$web_time = $_POST['pageStartTime'];
$pic_finish = $_POST['picClickedTime'];
$pic_start = $_POST['pic'];
$survey_end_time = $_POST['end'];
$image = $_POST['imagee'];
$picture_First = $_POST['pictureshownfirst'];
$p1 = $_POST['p1'];
$p2 = $_POST['p2'];
$p3 = $_POST['p3'];
$p4 = $_POST['p4'];
$p5 = $_POST['p5'];
$p6 = $_POST['p6'];
$p7 = $_POST['p7'];
$p8 = $_POST['p8'];
$p9 = $_POST['p9'];
$p10 = $_POST['p10'];
$p11 = $_POST['p11'];
$p12 = $_POST['p12'];
$p13 = $_POST['p13'];
$p14 = $_POST['p14'];
$p15 = $_POST['p15'];
$p16 = $_POST['p16'];
$p17 = $_POST['p17'];
$p18 = $_POST['p18'];
$p19 = $_POST['p19'];
$p20 = $_POST['p20'];
$p21 = $_POST['p21'];
$p22 = $_POST['p22'];
$p23 = $_POST['p23'];
$three_A = $_POST['threeA'];
$three_B = $_POST['threeB'];
$three_C = $_POST['threeC'];
$three_D = $_POST['threeD'];
$color_Blind = $_POST['color'];
$age = $_POST['age'];
$gender = $_POST['gender'];
$hispanic = $_POST['hispanic'];
$european = $_POST['europeand'];
$african = $_POST['africand'];
$asian = $_POST['asiand'];
$other = $_POST['otherd'];

$dbc = mysql_connect('localhost', 'srchulo', 'ponce')
or die('Could not connect: ' . mysql_error());

mysql_select_db('test') or die('Could not select database');

echo 'connected';

$query = "INSERT INTO jdsurvey (page_open_time, pic_start_time, pic_finish_time, survey_end_time, " .
"image_used, picture_first, p_1, p_2, p_3, p_4, p_5, p_6, p_7, p_8, p_9, p_10, p_11, p_12, " .
"p_13, p_14, p_15, p_16, p_17, p_18, p_19, p_20, p_21, p_22, p_23, three_a, three_b, " .
"three_c, three_d, color_blind, age, gender, hispanic, european, african, asian, other" .
"VALUES ('$web_time', '$pic_start', '$pic_finish', '$survey_end_time', '$image', " .
"'$picture_First', '$p1', '$p2', '$p3', '$p4', '$p5', '$p6', '$p7', '$p8', '$p9'," .
" '$p10', '$p11', '$p12', '$p13', '$p14', '$p15', '$p16', '$p17', '$p18', '$p19', " .
"'$p20', '$p21', '$p22', '$p23', '$three_A', '$three_B', '$three_C', '$three_D', " .
"'$color_Blind', '$age', '$gender', '$hispanic', '$european', '$african', '$asian', '$other')";
$result = mysql_query($dbc, $query)
or die('Error querying database');

mysql_close($dbc);

echo 'open time: ' . $web_time . '<br />';
echo 'pic start time: ' . $pic_start . '<br />';
echo 'pic finish Time: ' . $pic_finish . '<br />';
echo 'survey end: ' . $survey_end_time . '<br />';
echo 'image: ' . $image . '<br />';
echo 'picture first: ' . $picture_First . '<br />';
echo '1: ' . $p1 . '<br />';
echo '2: ' . $p2 . '<br />';
echo '3: ' . $p3 . '<br />';
echo '4: ' . $p4 . '<br />';
echo '5: ' . $p5 . '<br />';
echo '6: ' . $p6 . '<br />';
echo '7: ' . $p7 . '<br />';
echo '8: ' . $p8 . '<br />';
echo '9: ' . $p9 . '<br />';
echo '10: ' . $p10 . '<br />';
echo '11: ' . $p11 . '<br />';
echo '12: ' . $p12 . '<br />';
echo '13: ' . $p13 . '<br />';
echo '14: ' . $p14 . '<br />';
echo '15: ' . $p15 . '<br />';
echo '16: ' . $p16 . '<br />';
echo '17: ' . $p17 . '<br />';
echo '18: ' . $p18 . '<br />';
echo '19: ' . $p19 . '<br />';
echo '20: ' . $p20 . '<br />';
echo '21: ' . $p21 . '<br />';
echo '22: ' . $p22 . '<br />';
echo '23: ' . $p23 . '<br />';
echo $three_A . '<br />';
echo $three_B . '<br />';
echo $three_C . '<br />';
echo $three_D . '<br />';
echo $color_Blind . '<br />';
echo $age . '<br />';
echo $gender . '<br />';
echo $hispanic . '<br />';
echo $european . '<br />';
echo $african . '<br />';
echo $asian . '<br />';
echo $other . '<br />';
?>
</body>
</html>

Does anyone know what I'm doing wrong?

Thanks! :)

Re: Error querrying database

Posted: Tue Oct 05, 2010 7:25 pm
by mikosiko
for a start... is a missing ) in this line

Code: Select all

"three_c, three_d, color_blind, age, gender, hispanic, european, african, asian, other" .

Re: Error querrying database

Posted: Tue Oct 05, 2010 9:33 pm
by srchulo
wow, simple fix. Thanks a lot! Also, it's now saying that all of the values that I'm $_POSTing are undefined...but they're all in my HTML, do you have any idea why this is?

this is the error message: Notice: Undefined index: pageStartTime in /home/srchulo/public_html/jdcode/survey.php on line 14