[johny]

ok here is the script use:

<?php

// dbConfig.php is a file that contains your
// database connection information. This
// tutorial assumes a connection is made from
// this existing file.
include ("dbconfig.php");


// ==== Input validation and PHP dBase code ===============================
//
// ================================================== ======================

if ( $_GET["op"] == "reg" )
{
$bInputFlag = false;
foreach ( $_POST as $field )
{
if ($field == "")
{
$bInputFlag = false;
}
else
{
$bInputFlag = true;
}
}
// If we had problems with the input, exit with error
if ($bInputFlag == false)
{
die( "Problem with your registration info. "
."Please go back and try again.");
}

// Fields are clear, add user to database
// Setup query
$q = "INSERT INTO `dbusers` (`username`,`password`,`email`) "
."VALUES ('".$_POST["username"]."', "
."PASSWORD('".$_POST["password"]."'), "
."'".$_POST["email"]."')";
// Run query
$r = mysql_query($q);

// Make sure query inserted user successfully
if ( !mysql_insert_id() )
{
die("Error: User not added to database.");
}
else
{
// Redirect to thank you page.
Header("Location: register.php?op=thanks");
}
} // end if



// ==== Thank you page ================================================== ==
//
// ================================================== ======================
elseif ( $_GET["op"] == "thanks" )
{
echo "<h2>Thanks for registering!</h2>";
}



// ==== Main Form ================================================== =======
//
// ================================================== ======================
else
{
echo "<form action=\"?op=reg\" method=\"POST\">\n";
echo "Username: <input name=\"username\" MAXLENGTH=\"16\"><br />\n";
echo "Password: <input type=\"password\" name=\"password\" MAXLENGTH=\"16\"><br />\n";
echo "Email Address: <input name=\"email\" MAXLENGTH=\"25\"><br />\n";
echo "<input type=\"submit\">\n";
echo "</form>\n";
}
// EOF
?>



but then when i go to test it out to see if it works it says

error:user not added to database can you plz help,thanks

[johny]

can you please help me i really need it because this script needs to be done by tomorrow

[nekeno12]

Do you have phpMyAdmin? Because I don't think the database is set up to work with this script.

[johny]

yes i have phpmyadmin what do you suggest

[nekeno12]

Replace this query:

PHP Code:

$q = "INSERT INTO `dbusers` (`username`,`password`,`email`) "
."VALUES ('".$_POST["username"]."', "
."PASSWORD('".$_POST["password"]."'), "
."'".$_POST["email"]."')"; 

WITH

PHP Code:

$q = "INSERT INTO dbusers (username,password,email) VALUES ('$_POST[username]', '$_POST[password]', '$_POST[email]')"; 

This will fix your problem

[johny]

oh ok i will try that thanks for the help