PHP, MYSQL and blank data entry

[nickweb]

I have a small problem. Iv tried every combination of " , ' , \" and \' but still cant get this to work.. Any idea why this isnt takin the text from the textboxes and putting it into the sql query? All its doing is populating ym database with blanks... Nothing in it at all.. Just blank,. 🙁

<?php
$linkID = mysql_connect("localhost", "root", "") or die("nope..nope.. not workin!"); //Create the databse link, ("localhost", "username", "password")
$sql = "INSERT INTO email (frm, send, dt, subject) VALUES (\"$send\",\"$frm\",\"$dt\",\"$to\")"; //set up the query to insert the items in the text boxes into the database.
mysql_select_db("test", $linkID);
mysql_query("$sql", $linkID);
mysql_close($linkID);
echo "<form name='form1' method='post' action='$SCRIPT_NAME'>";
echo "  <p><input type='text' name='$send'>";
echo "</p>";
echo "  <p> ";
echo "    <input type='text' name='$frm'>";
echo "  </p>";
echo "  <p> ";
echo "    <input type='text' name='dt'>";
echo "  </p>";
echo "  <p> ";
echo "    <input type='text' name='subject'>";
echo "  </p>";
echo "  <p>";
echo "    <input type='submit' name='Submit' value='Submit'>";
echo "  </p>";
echo "</form>";
?>

Thank you,

Nick

[laserlight]

1. Use the $_POST superglobal array.
2. Name your form elements as name="name", not name="$name"

[nickweb]

It still dosent work.. No idea why. Iv tried the $POST and $GET..

All i get in the databse is blank entries.. :S

Weird..

This is the code im using now.. any ideas?

Lol.

Thank you.

<?php


echo "<form name='form1' method='$_POST' action='$SCRIPT_NAME'>";
echo "  <p><input type='text' name='send'>";
echo "</p>";
echo "  <p> ";
echo "    <input type='text' name='frm'>";
echo "  </p>";
echo "  <p> ";
echo "    <input type='text' name='dt'>";
echo "  </p>";
echo "  <p> ";
echo "    <input type='text' name='subject'>";
echo "  </p>";
echo "  <p>";
echo "    <input type='submit' name='Submit' value='Submit'>";
echo "  </p>";
echo "</form>";

$linkID = mysql_connect("localhost", "root", "") or die("nope..nope.. not workin!"); //Create the databse link, ("localhost", "username", "password")
$sql = "INSERT INTO email (frm, send, dt, subject) VALUES (\"$send\",\"$frm\",\"$dt\",\"$to\")"; //set up the query to insert the items in the text boxes into the database.
mysql_select_db("test", $linkID);
mysql_query("$sql", $linkID);
mysql_close($linkID);
?>

[laserlight]

<?php
if (isset($_POST['submit'])) {
	//Create the databse link, ("localhost", "username", "password")
	mysql_connect("localhost", "root", "")
		OR die(mysql_error()); //for debugging
	mysql_select_db("test")
		OR die(mysql_error()); //for debugging
	//ensure that items have been passed, and set them
	if (!empty($_POST['frm']))
		$frm = $_POST['frm'];
	else
		$frm = '';
	if (!empty($_POST['send']))
		$send = $_POST['send'];
	else
		$send = '';
	if (!empty($_POST['dt']))
		$dt = $_POST['dt'];
	else
		$dt = '';
	if (!empty($_POST['subject']))
		$subject = $_POST['subject'];
	else
		$subject = '';
	//set up the query to insert the items in the text boxes into the database.
	//use backticks (`) to enclose column and table names
	//use single quotes (') to enclose values
	//PHP variables are enclosed in braces to speed up parsing
	$sql = "INSERT INTO `email`
		(`frm`, `send`, `dt`, `subject`)
		VALUES ('{$send}','{$frm}','{$dt}','{$to}')";
	if (mysql_query($sql))
		echo 'Query executed';
	else
		die(mysql_error()); //for debugging
	mysql_close();
}
?>
<form name="form1" method="POST" action="<?php echo $_SERVER['PHP_SELF']; ?>">
  <p>
   <input type="text" name="send">
  </p>
  <p>
    <input type="text" name="frm">
  </p>
  <p> 
    <input type="text" name="dt">
  </p>
  <p>
    <input type="text" name="subject">
  </p>
  <p>
    <input type="submit" name="submit" value="Submit">
  </p>
</form>

[nickweb]

its saving it now! thank you! 😃

Looks like one field isnt saving tho.. ill play about with it n see wat up..

Thanks again 😃

Nick

[laserlight]

It's a simple mistake.

If you set error reporting to E_ALL you would have noticed that $to does not exist.
That's because you wish to use $subject instead.

I suggest that you try to understand what my example actually does.
If you have any further questions just ask.