Form not working

Tezread

Im still uncertain as to what ive doen wrong here- im trying to create a form with an insert statement. My form displays fine but when I test it my database is stil empty! Worst of all even though ive put echo statements in to test it out they don't show up in my localhost.

<?php
$user="root";
$host="localhost"
$password="";
$database="c:\MySQL\data\taf";
case "login":

$connection = mysql_connect($localhost, $root,$password)
or die ("Couldn't connect to server.");
$db = mysql_select_db($database, $connection)
or die ("Couldn't select database.");

if (isset($POST['submit'])) {
$q1 = $POST['q1'];
$q2 = $POST['q2'];
$q3 = $POST['q3'];
$q4 = $POST['q4'];
$q5 = $POST['q5'];
$q6 = $POST['q6'];
$q7 = $POST['q7'];
$q8 = $POST['q8'];
echo 'q2 = ' . $POST['q2'] . '<br />';
$sql = "INSERT INTO journalentry (tresponse)
VALUES ('', '" . $POST['q1'] . "', '" . $POST['q2'] . "', '" . $POST['q3'] . ''', '" . $POST['q4'] . "', '" . $POST['q5'] . "', '" . $POST['q6'] . "','" . $POST['q7']."', '" . $POST['q8'] . "','" );
$result = $db->query($sql); echo $sql;
?>

zhabala

Your SQL statement is definitelly wrong.
Column count doesn't match value count.

paulnaj

Hi murphdev,

<?php
$user = "root"; 
$host = "localhost" 
$password = "";

// What's this: case "login": ???

// Wrong: $connection = mysql_connect($localhost, $root, $password) 
$connection = @mysql_connect($host, $root, $password) 
	or die ("Couldn't connect to server."); 


// Why are you using a filepath? $database = "c:\\MySQL\\data\taf"; ???

$database = "taf"; 
$db = @mysql_select_db($database, $connection) 
	or die ("Couldn't select database.");

if (isset($_POST['submit'])) { 
	// Good way to display a whole array in one go
	echo '<hr><pre>'; print_r($_POST); echo '</pre><hr>';

// You've only specified one field. 
// Put the other 8 names in ... why not?
// I'd do it, but don't know the names of the fields.
$sql = '
INSERT INTO journalentry (tresponse) 
VALUES (""
, 	"'.$_POST['q1'].'"
, 	"'.$_POST['q2'].'"
, 	"'.$_POST['q3'].'"
, 	"'.$_POST['q4'].'"
, 	"'.$_POST['q5'].'"
, 	"'.$_POST['q6'].'"
, 	"'.$_POST['q7'].'"
, 	"'.$_POST['q8'].'"
');
//$result = $db->query($sql); 
echo $sql; 
}

?>

Hope that helps.

Paul. 🙂

Tezread

I thought about the design of my database as I ddint design it and it is wrong yuo know- I need more than one tresponse field for each question the user responds to.
Other thsan the fields is the remainder of the code ok?

paulnaj

Have you read the comments?

Tezread

Thx for the help their- I made the changes and tried it out but the values I tried are still not entering into the MySQL db
Would it help to show you guys the code behind my form (journalform.php) or is all the work done by PHP?

Tezread

I redesigned my db aswell so now it looks like this

entry id (pk)
tresponse1
tresponse2 etc
gresponse1
gresponse2 etc etc

paulnaj

Hi again Tezread,

When you use 'INSERT', for each field listed in the INTO (...) clause there must be a corresponding entry in the VALUES(...) clause.

So a good idea would be to show us:

1) ALL of the fields in the table (including which is the PRIMARY KEY)

2) The expected values in the $_POST array.

We can go from there.

Paul 🙂

Tezread

My fields in the table called journalentry are:

entryid (primary key)
tresponse1 (blob)
tresponse2 (blob)

tresponse3 (blob)
tresponse4 (blob)
tresponse5 (blob)
tresponse6 (blob)
tresponse7 (blob)
tresponse8 (blob)
gresponse1 (blob)
gresponse2 (blob)
gresponse3 (blob)
gresponse4 (blob)
date (date)
timein (time)
timeout(time)

Im not sure about the second point you raise as im a bit miffed about the use of arrays

Tezread

Forget the bottom 3 fields as they don't exist (date, timein,timeout)

Tezread

Ive also changed my security settings so I have anewe host, user, root name and still no joy.

Im using PHP4 on Apache Server

paulnaj

Hi again,

What I mean in point (2) is what variables do you expect to be sent to this page?

In your first code, the form fields were labelled q1 ... q8. Is that still the case?

If it is, which form field corresponds to which table field?

Paul 🙂

Tezread

form field q1 corresponds to tresponse1
form field q2 corresponds to tresponse2
etc
form field q9 corresponds to gresponse1
form field q10 corresponds to gresponse2

etc

Tezread

here is my form code (journalform.php)

<html>
<head><title>My Journal</title>
</head>
<body topmargin="0" leftmargin="0" marginheight="0"
marginwidth="0">
<table border="0" align="center" cellpadding="5" cellspacing="0">
<tr>
<td colspan="3" bgcolor="gray" align="center">
<font color="white" size="+10">
<b>My Journal</b></font></td>
</tr>
<tr>
<td width="33%" valign="top">
<font size="+1"><b>Make your journal entries below;</b></font>
<p>

<form action="journalentry.php" method="POST">
<table border="0">

<?php
if (isset($message_new)) #55
echo "<tr><td colspan='2'><b>$message_new</b>
</td></tr>";
?>
<tr>
<td align="right" nowrap> <div align="left">How did you feel as you arrived to the training session? </div></td>
<td><textarea name="q1" cols="50"><?php echo @$q1 ?></textarea></td></tr>
<tr>
<td align="right"> <div align="left">How did you feel during the session? </div></td>
<td><textarea name="q2" cols="50"><?php echo @$q2 ?></textarea></td>
</tr>
<tr>
<td align="right"> <div align="left">Did any of the activities provoke a strong emotional response from you? </div></td>
<td><textarea name="q3" cols="50"><?php echo @$q3 ?></textarea></td>
</tr>

       <tr>
         <td align="right"> <div align="left">Did any of your feelings surprise you? </div></td>
         <td><textarea name="q4" cols="50"><?php echo @$q4 ?></textarea></td>
       </tr>
       <tr><td align="right"> <div align="left">How did your react to your fellow participants? </div></td>
           <td><textarea name="q5" cols="50"><?php echo @$q5 ?></textarea></td></tr>
       <tr>
         <td align="right"> <div align="left">What did you learn about yourself? </div></td>
         <td><textarea name="q6" cols="50"><?php echo @$q6 ?></textarea></td>
       </tr>
					  <tr><td align="right"> <div align="left">What did you learn about Counselling? </div></td>
           <td><textarea name="q7" cols="50"><?php echo @$q7 ?></textarea></td></tr>
                      <tr>
                        <td align="right"> <div align="left">What did you learn about your own skills?  </div></td>
                        <td><textarea name="q8" cols="50"><?php echo @$q8 ?></textarea></td>
                      </tr>
       <tr>
         <td align="right"> <div align="left">What happened today? </div></td>
           <td><textarea name="q9" cols="50"><?php echo @$q9 ?></textarea></td></tr>
       <tr>
         <td align="right"> <div align="left">How did it make you feel? </div></td>
           <td><textarea name="q10" cols="50"><?php echo @$q10 ?></textarea></td></tr>
       <tr>
         <td height="41" align="right"> <div align="left">What did you learn about yourself? </div></td>
         <td><textarea name="q11" cols="50"><?php echo @$q11 ?></textarea></td>
       </tr>
       <tr>
         <td align="right"> <div align="left">How have you practiced your skills? How has this gone? </div></td>
           <td>                  
             <textarea name="q12" cols="50"><?php echo @$q12 ?></textarea></td>
       </tr>
       <tr>
         <td align=right><div align="left"></div></td>
         <td><input type="submit" name="Submit" value="Submit entries">             </tr>
     </table>
 </form>     </td>

</tr>
<tr>
<td valign="top"> </td>
<td bgcolor="#FFFFFF"></td>
<td> </td>
</tr>
<tr><td colspan="3" bgcolor="gray"> </td></tr>
</table>
<div align="center"><font size="-1">
All comments and suggestions are appreciated. Please
send comments to <a href="mailto:tez@mindseyemidlands.co.uk.">
tez@mindseyemidlands.co.uk</A> </font></div>
</body></html>

jannoy

try putting
after mysql_query(insert) function

this

or die (mysql_error());

eg
msyql_query("insert into table blah blah blah ") or die (mysql_error());

Tezread

Thx for the help guys- im still getting a blank page when I hit my submit button- goodness knows why. I figured your suggestions would fix my problem but maybe the problem is more deep routed

onion2k

Originally posted by Tezread
My fields in the table called journalentry are:
tresponse1 (blob)
... ... ...

Blobs? Why?

Tezread

I thoight the equivalent of say a memo box in Access (crudely speaking) was the use of a blob in MySQL?
I suppose I could use char/varchar and limit the numbe rof chars but isnt char limited to 255 chars?
This isn't my problem though- my problem is that my scripting just doesn't work- I jus tried a little samle script to test out me server and got nada!

<? php
phpinfo()
?>

Yamakazi

Hmmzz that's weird. So your apache doesn't parse PHP files. But doens't output anything either? Are you sure you have this line in you httpd.conf:

AddType application/x-httpd-php .php

And just to be sure... you loaded PHP as a module in apache right?

And please tell us wich platform you're on. Linux, Windows, ...?

onion2k

Originally posted by Tezread
<? php
phpinfo()
?>

You have a space between <? and php. It ought to be <?php .. no spaces.