PHP Scripting question?

[DIVAD3]

Also Mark I think the missing element might have to do with what it says here in this part of the script at the bottom:

// Then you need to make sure the database you want
// is selected.
mysql_select_db($db);
?>

Perhaps there is something I should be putting in this line???? OR NOT! it really doesnt make sense to me that I should be touching that part of it.
---------------------------------------
Just exactly what the variable is-is something I am not understanding. what is the variable as you were implying???

[mark6188]

No, you don't need to add a form, basically the form is already in the code.

//The web form for input ability
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";
 }

I think all you need to do is change this part of the code and replace the xxxx with the input names in the form above.

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

The code in the tutorial has it this way, so not sure why you changed the variables to xxxxx in your 1st post.

Honestly, I'm still not sure what your question is. When I click on your link, I see a "Error Connecting to Database" message. Is this what you need help with?

If so, you don't want to touch any of the code with the form in it. You need to modify the dbConfig.php file and put your username and password for the mysql database you setup.

<?
// Replace the variable values below
// with your specific database information.
$host = "localhost";
$user = "UserName";
$pass = "Password";
$db   = "dbName";

Change it to something like

<?
// Replace the variable values below
// with your specific database information.
$host = "localhost";
$user = "hostname_dvad3";
$pass = "abc123";
$db   = "hostname_dbName";

[DIVAD3]

Originally Posted by mark6188

The code in the tutorial has it this way, so not sure why you changed the variables to xxxxx in your 1st post.

Honestly, I'm still not sure what your question is. When I click on your link, I see a "Error Connecting to Database" message. Is this what you need help with?

If so, you don't want to touch any of the code with the form in it. You need to modify the dbConfig.php file and put your username and password for the mysql database you setup.

Thats a big yes! As to what I am troulbe with as well as uncertain to just where I insert my info in certain places.

And I was just putting the xxx's as to fill it in with something.

[DIVAD3]

Originally Posted by mark6188

<?
// Replace the variable values below
// with your specific database information.
$host = "localhost";
$user = "hostname_dvad3";
$pass = "abc123";
$db = "hostname_dbName";

Here I see where I should have it as = local host and not my entire server host name. so thats one area corrected now.