insert data by using Form

[Anon]

hi,...

<form action="">
ID#:<input type="text" name=Id>
Name:<input type="text" name=username>
.
.
.
</form>

$sql = "INSERT INTO users(Id,username)VALUES ('$Id','$username')";
$result = mysql_query("$sql",$db);

I need to insert data to MySQL by using form.

the error is in the part of:

VALUES '$Id','$username')";

undefined $Id , $username variables.

any Idea?

[[deleted]]

Most likely the 'register_globals' is off in your PHP config.
Try this:
$sql = "INSERT INTO users(Id,username)VALUES ('".$HTTP_GET_VARS['Id']."','".$HTTP_GET_VARS['username']."')";

[sayma]

Try with this. Hope this will work.

$sql = \"INSERT INTO users VALUES (\'$Id\',\'$username\')\";
$result = mysql_query(\"$sql\",$db);

[Anon]

hi Vincent

thanks for your help, but It didn't solve my problem.Any other Idea?

[Anon]

hi Sayma

thanks for your help, but It didn't solve my problem.Any other Idea?

[sayma]

<form action="insert.php">
ID#:<input type="text" name="id">
Name:<input type="text" name="username">

</form>

insert.php

mysql_connect("localhost","username","password") or die ("could not connect with atabase");
mysql_select_db ("database name") or die "could not select database")

$sql = "INSERT INTO users VALUES ('$Id','$username')";
$result = mysql_query("$sql");

hope ths will work. I use this code for myself whenever i need. And it is working fine in my server.