Newbie help: Insert Record problem

lisa371

I am testing a larger form with a smaller form. Basically, very simple, submit form to page below, and this page should insert the record to the mysql database.

However, I get nothing: no errors, nothing.I do know that register globals are off, is that the issue?
I want to do it this way, because I want to assign two of the form fields to one variable, then record that in the database, as indicated below.

This is the insert page (not the complete html code, such as header details, but complete php code. etc...)

<?
$db_name = "name"
$dbserver = "servername";
$dbuser = "username";
$dbpass = "password";

$connection = mysql_pconnect($dbserver, $dbuser, $dbpass)
or die("Couldn't connect.");

if (!$connection)
{
echo "Error: Could not connect to database.";
exit
}

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

$sname = $POST ['sname'];
$semail = $POST['semail'];
$date_filled = $_POST['date_filled'];
(eventually want to have here as this line:

           $hours= $_POST['hoursam'] . $_ ['hourspm'];

          or whatever the right format would be...)

$query = mysql_query("INSERT INTO student (semail, sname, date_filled) VALUES ('$sname', '$semail', '$date_filled')") or die (mysql_error());

?>
<html header here>
<body>

<?
echo $semail;
echo $sname;

echo mysql_affected_rows()." record inserted into database.";
?>
</body>
</html>

As I said, nothing gets submitted.

Thanks for helping a newbie!-

leatherback

Hi,

Since you do not get anything when you echo the $_POST[} values, you shoul dhave a lok at the complete $POST array:

print_r($_POST);

This will show you the content of the post array, and you can check whether there is a type in your names.

Besides that.. your insert query swaps name and email in the table, which is going to give you a headache later on..

lisa371

that came up blank as well. The names are right ... doublechecked.

WOuld it have anything to do with the types of data? Should that be declared in the insert form?

Chrisskidmore

This may be too obvious but
Are you sure you have used method = "post" in the sending <form> tag

lisa371

Yeah, I did. Though I appreicate you saying so... you never know!

Chrisskidmore

If
echo "<pre>";
print_r($_POST);

didn't work try

echo "<pre>";
print_r($_GLOBALS);

See if any of your values are in their.

What version of php are you on?

Can you post your script for the sending page (ie the form)

lisa371

<table >
<tr
<td ><input type="text" name="sname" /></td>
</tr>
<tr >input type="text" name="date_filled"/>
<td >email</td>
<td >
<input name="semail" type="text" id="semail" /></td>
<td width="50%"><span class="required">Email Address:</span>
<input type="submit" name="Submit" value="Submit" /></td>
</tr>
</table>
</form>

Chrisskidmore

If you cut and pasted that then the problem could be in the html.

You are missing some tag ends and the table isn't "straight". This could be interfering with the input tags so it's not sedning anything.

Try copying this simplified into a new page called "test.php" or something

then see if the other page receives it with
<?php
echo "<pre>";
print_r($_POST);
?>