post form

[addie]

hi
anyone have posting form.
I need simple post form that user can post any message.

[addie]

ok ppl i got a script but i get error

Email = "$Email",
First_Name = "$Name"

this code is on form.php i get error on line Email = ..
PHP Parse error: parse error in C:\web\test\form.php on line 24

[ucbones]

Firstly, you've ended your lines with commas, end them with semi-colons- ";". Secondly, not really sure what the extract you posted is trying to achieve. Not really sure what you are trying to do, why don't you post the whole script here (provided it's not tooo long) and I'll take a look,

ucbones

[addie]

<form action="script.php">
Name: <input type="text" name="Name"><br>
Email: <input type="text" name="Email">
<input type="submit" name="submit" value="submit">
</form>

<?
$host = "localhost";
$login_name = "root";
$password = "*****";

//Connecting to MYSQL
MySQL_connect("$host","$login_name","$password");

//Select the database we want to use
MySQL_select_db("test") or die("Could not select database");

//Assign contents of form to variables
$name = $POST['Name'];
$email = $POST['Email'];

$sql = "INSERT INTO test SET"
Email = "$email",
First_Name = "$name"
");

$result = mysql_query($sql);

//Code to check if statement executed properly and display message
if ($result) {
echo("Email and Name successully added");
} else {
echo("An error has occured");
}

//Close connection with MySQL
MySQL_close()
?>

[ucbones]

instead of

$sql = "INSERT INTO test SET" 
Email = "$email", 
First_Name = "$name" 
");

just try

$sql = "INSERT INTO test SET Email='$email', First_Name='$name'"; 

hope that helps,

ucbones

[addie]

when on load i get this error

Email and Name successully added PHP Notice: Undefined index: Name in C:\web\test\form.php on line 20 PHP Notice: Undefined index: Email in C:\web\test\form.php on line 21

when i try to add anything
it says page cannot be found

http://127.0.0.1/test/script.php?Name=test&Email=[e-mail]&submit=submit

:rolleyes:

[addie]

ok i fixed both of them just it adds nothing to database only empty thing

[ucbones]

from the look of your link, you've misunderstood $_POST

http://127.0.0.1/test/script.php?Name=test&Email=[e-mail]&submit=submit

$_POST only accepts variables that were submitted in the form, not those that were specified by the URL, as yours are.

If you were to take out the line:

$name = $_POST['Name']; 
$email = $_POST['Email']; 

your code would work with the URL. People use $_POST to make their forms more secure.

ucbones

[addie]

anyone know why i cant add data to MySQL i got this code

<form action="form.php">
Name: <input type="text" name="Name"><br>
Password: <input type="text" name="Password"><br>
Email: <input type="text" name="Email"> <br>
Phone: <input type="text" name="Phone"> <br>
<input type="submit" name="submit" value="submit">
</form>

<?
require_once 'config.php';

MySQL_connect("$host","$login_name","$password");
MySQL_select_db("test") or die("Could not select database");
$sql = "INSERT INTO test SET Email='$email', First_Name='$name' Phone='$phone', Password='$password'";
$result = mysql_query($sql);

if ($result) {
echo("Email and Name successully added");
} else {
echo("An error has occured");
}

MySQL_close()
?>

on load i get this error
An error has occured PHP Notice: Undefined variable: email in C:\web\test\add.php on line 21 PHP Notice: Undefined variable: name in C:\web\test\add.php on line 21 PHP Notice: Undefined variable: phone in C:\web\test\add.php on line 21