help me with basic form

addie

hi, i got form like this

<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>

is there any function on submit it writes to mysql data
$sql = "INSERT INTO test SET Email='$Email', First_Name='$Name' Phone='$Phone', Password='$Password'";

laserlight

No, there isnt, until you write your own.

I suggest changing:
<form action="form.php">
to
<form action="form.php" method="post">

HTML forms default to the GET method, while most ppl code with the assumption that it is set to method="post" (which it usually is)

Aside from that, you'll need mysql_query() to actually send the query, though you'll need to connect to and select your database first.

addie

<?
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()
?>

there is query.
but as i said i need function on submit that add to mysql form data 🙂

laserlight

function?

but it should be a simple matter of adding

if (isset($_POST['submit']))

or some other check like that, shouldnt it?

addie

ok thanks
anyone else can help ?

DeltaRho2K

Right under the requireonce line, add the following:

extract ($_POST);

Of course, you do need to add the method="post" to your form tag.

<? 
require_once 'config.php'; 
extract ($_POST);

$connect = MySQL_connect("$host","$login_name","$password"); 

MySQL_select_db("test") or die("Could not select database"); 

$sql = mysql_query("INSERT INTO test VALUES(Email='$Email', First_Name='$Name' Phone='$Phone', Password='$Password')"); 

$sqlverify = mysql_query("SELECT * from test WHERE email = '$Email' AND First_Name = '$Name'");
$count = mysql_num_rows($sqlverify);

If ($count == "1"):
    echo("Email and Name successully added"); 
Else ($count == "0"):
    echo("There was a problem adding the user"); 
Endif;

MySQL_close($connect) 
?>

This is a really simple way of checking, and won't tell you if a duplicate was added, but it's a start.

Good luck with this.

~DR

benkillin

Im not sure with MySQL, but I just finished a class that taught MS Office 2000, and at the end we learned access, and in access you can set "primary keys" that are there to make sure duplicate entrys arent added.

DeltaRho2K

You can use primary keys here too, but if you are adding a new user (in this case), then the key isn't set yet anyhow until the record is added. (like in MS Access) In this case, we want to make sure the user name is unique. The primary key should be an auto-increment primary key so it is (by design) going to be unique.

What you would have to do is to run a query first to determine if that user name already exists, and if it does, then echo back a reply to say it already exists and give a back link, and then don't run the insert query.

If the user name doesn't already exist, then run the insert query, and proceed from there. You can leave the count portion of the query just as a double check to make sure the data was added after you verify it isn't a duplicate.

~DR