creating rows in mysql with data

The Voigts · The Voigts

Hi i have two files

<HTML>
<BODY>
<form method="post" action="datain.php">
First name:<input type="Text" name="first"><br>
Last name:<input type="Text" name="last"><br>
Nick Name:<input type="Text" name="nickname"><br>
E-mail:<input type="Text" name="email"><br>
Salary:<input type="Text" name="salary"><br>
<input type="Submit" name="submit" value="Enter information">
</form>
</HTML>
and
<HTML>
<?php
$db = mysql_connect("localhost", "root","");
mysql_select_db("learndb",$db);
$sql = "INSERT INTO personnel (firstname, lastname, nick, email, salary)
VALUES ('$first','$last','$nickname','$email','$salary')" ;
$result = mysql_query($sql);
echo "Thank you! Information entered.\n";
?>
</HTML>
this creates empty rows and nothing else. the data i enter in the form isnt
being used. can someone help? Im running phpdev v423.

Thanks

Jedi121 · Jedi121

The Voigts a écrit le 29/01/2004 :
[...]

> $sql = "INSERT INTO personnel (firstname, lastname, nick, email, salary)
> VALUES ('$first','$last','$nickname','$email','$salary')" ;

[...]

> this creates empty rows and nothing else. the data i enter in the form isnt
> being used. can someone help? Im running phpdev v423.

Try using $_POST['var'] instead of $var :

$sql = "INSERT INTO personnel (firstname, lastname, nick, email,
salary) "
."VALUES
('".$_POST['first']."','".$_POST['last']."','".$_POST['nickname']."','".$_POST['email']."','".$_POST['salary']."')";

creating rows in mysql with data

Thread Tools

Display

creating rows in mysql with data

Similar Questions and Discussions

extension for creating professional charts based on mysql data?

creating unique rows

working RSS code - creating using mysql data ??

are there any guides to creating a dynamic menu from mysql data?

Help in creating data entry forms with MySQL

Re: creating rows in mysql with data

Posting Permissions