password protect

[Jboy56af]

Hey so far I have a form that submits the info into a mysql database. Thats easy. But what I want to do is make it so it only posts to the database if you enter the correct password. I want not multiple usernames and passwords. But just 1 password for everybody that is going to be submitting stuff in. How would I do this?

I have the form and it sends it to 'submit.php' which sends it to the database.

[cgraz]

When they submit to form, connect to database, grab password, match it with the password they typed. If they match, INSERT into db, if not, don't insert.

$query = mysql_query("SELECT password FROM your_table");
$row = mysql_fetch_array($query);

$password_db = $row["password"];

if ($password_form == $password_db) {
   // INSERT INTO DATABASE
} else {
   echo "You did not type the right password";
}

That's the logic behind it, you'll have to modify it to suit your needs though. You could apply encryption to the password if you wanted to.

Cgraz

[daphreeek]

na - thats silly. if it is only 1 password for everyone, then why use a database? just put an if into ur php code:

if ($password == "this_is_my_password") {
     // put mysql insert statement here
}else{
     echo "You entered the wrong password.";
}

then just have a field in your form called password 🙂 much easier + saves on system resources/load time.

• Matt