 |  |  |  |  |  |  |  |
limiting account names
Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
ive been working on my login script, and ive come to a halt. i need some help with writing somthing that will check if the name has already been used
like
if ( $current_Username = $Database_username)
echo "sorry user name taken";
else
{
continue with rest of functions
}
where current_username = $_POST[username] (from the form)
and
Database_username = "SELECT * FROM reg_info WHERE name = '$current_Username')
ive tried things along those lines, but i always get errors. Does anyone know how to correctly do it??
thanks for any help that anyone can offer
like
if ( $current_Username = $Database_username)
echo "sorry user name taken";
else
{
continue with rest of functions
}
where current_username = $_POST[username] (from the form)
and
Database_username = "SELECT * FROM reg_info WHERE name = '$current_Username')
ive tried things along those lines, but i always get errors. Does anyone know how to correctly do it??
thanks for any help that anyone can offer
Dont forget to spread the reputation to those that deserve!
If you don't post the errors and the code we can't help. There are too may things that could possibly hose your script up.
Need a website designer? arizona web design : phoenix web design : MCP Media intelligent web design and web development solutions. MCP Media is owned and operated by Chris Hooley - who happens to be a real nerd... on purpose :-)
so does that mean that im heading in the right direction with my code?
Dont forget to spread the reputation to those that deserve!
No, that means I didn't look at it because you didn't post the errors.
Need a website designer? arizona web design : phoenix web design : MCP Media intelligent web design and web development solutions. MCP Media is owned and operated by Chris Hooley - who happens to be a real nerd... on purpose :-)
i was asking for you to look for errors, i wanted to know if that was on the right track.
Dont forget to spread the reputation to those that deserve!
I understand that Killer_Typo. PHP and MySQL both spit out error messages when you have an error. That makes debugging buggy code easier. That's why I showed you how to echo a mysql error after you try running a query. PHP errors stop the page and tell you which line you have a problem on. AT this point, I don't know if you have a PHP problem, a SQL logic problem, a problem with your form, or a SQL statement problem, or other.
Although I could read your code and likely debug it from just reading it, it would take ME, the guy who is attempting to help you with your code problem, one tenth the time to debug your code if I knew exactly what errors where being thrown. It would take YOU the same amount of time to copy and paste the error onto the page and post it as it does to type "I have an error". If you really don't want to explain the error, why would I want to try and debug it for you?
Although I could read your code and likely debug it from just reading it, it would take ME, the guy who is attempting to help you with your code problem, one tenth the time to debug your code if I knew exactly what errors where being thrown. It would take YOU the same amount of time to copy and paste the error onto the page and post it as it does to type "I have an error". If you really don't want to explain the error, why would I want to try and debug it for you?
Need a website designer? arizona web design : phoenix web design : MCP Media intelligent web design and web development solutions. MCP Media is owned and operated by Chris Hooley - who happens to be a real nerd... on purpose :-)
lol meant to say wasnt asking for you to look for errors, but ill post the code in a minute when i get back up to my computer (downstairs right now). im sorry if i have to double post, but it wont let me edit my posts after i finish posting them.
EDIT:
heres the PHP that submits into the database, but is supposed to first check to see if the name has already or not already been used. ive left that part in the comment.
[php]
<?php
$DBhost = "localhost";//location of mySQL on server/site
$DBuser = "michael";//User name for logging onto mySQL
$DBpass = "";//Password for logging onto mySQL
$DBName = "registration";//Name of the databse for logging into
$Table = "reg_info";//Name of the Table to be used steps to create are included
$usr_name = "$_POST[usr_name]";//Name that the person gave on the form
$usr_pass = "$_POST[usr_pass]";//Password use uses
$con_usr_pass = "$_POST[con_usr_pass]";//confirmation of the password
$email = "$_POST[email]";//users email
$con_email = "$_POST[con_email]";//confirmation of the email
$gender = "$_POST[gender]";//their gender
$month = "$_POST[month]";//month they were born
$day = "$_post[day]";//day they were born
$year = "$_POST[year]";//year they were born
$alt_email = "$_POST[alt_email]";//any alternate emails they might use
$interests = "$_POST[interests]";//their interests
$hobbies = "$_POST[hobbies]";//their hobbies
mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable to connect to database"); //connecting to the database using the variable set
@mysql_select_db("$DBName") or die("Unable to select database $DBName"); //at connection to the databse select DBNAME (phpforms) or tell that it couldnt connect
$sqlquery = "SEARCH * FROM $Table WHERE usr_name = '$_POST[usr_name]'";
$results = mysql_query($sqlquery);
if ($results = $usr_name)
//(!$results)
echo "sorry that user name has been taken! please use your browsers back button and try a different one!";
//echo (mysql_error());
else
{
mysql_close();
if ($usr_pass != $con_usr_pass)
echo "sorry the passwords to not match, please use your browsers back button to fix this error";
else
{
if ($email != $con_email)
echo "sorry the Emails you provided do not match, please use your browsers back button to fix this error";
else
{
mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable to connect to database"); //connecting to the database using the variable set
@mysql_select_db("$DBName") or die("Unable to select database $DBName"); //at connection to the databse select DBNAME (phpforms) or tell that it couldnt connect
$sqlquery = "INSERT INTO $Table VALUES('$id','$usr_name','$usr_pass','$email','$gender','$month','$_POST[day]','$year','$alt_email','$interests','$hobbies')";
$results = mysql_query($sqlquery); //query the results
mysql_close();
echo "Information has been submitted into the database!";
}
}
}
?>
[/php]
i dont get any errors, i always get the if in the first if statment, saying that the username is taken when in fact its not. ive tried swaping the Search for Select in the mysql part.
EDIT:
PHP Syntax (Toggle Plain Text)
heres the PHP that submits into the database, but is supposed to first check to see if the name has already or not already been used. ive left that part in the comment.
[php]
<?php
$DBhost = "localhost";//location of mySQL on server/site
$DBuser = "michael";//User name for logging onto mySQL
$DBpass = "";//Password for logging onto mySQL
$DBName = "registration";//Name of the databse for logging into
$Table = "reg_info";//Name of the Table to be used steps to create are included
$usr_name = "$_POST[usr_name]";//Name that the person gave on the form
$usr_pass = "$_POST[usr_pass]";//Password use uses
$con_usr_pass = "$_POST[con_usr_pass]";//confirmation of the password
$email = "$_POST[email]";//users email
$con_email = "$_POST[con_email]";//confirmation of the email
$gender = "$_POST[gender]";//their gender
$month = "$_POST[month]";//month they were born
$day = "$_post[day]";//day they were born
$year = "$_POST[year]";//year they were born
$alt_email = "$_POST[alt_email]";//any alternate emails they might use
$interests = "$_POST[interests]";//their interests
$hobbies = "$_POST[hobbies]";//their hobbies
mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable to connect to database"); //connecting to the database using the variable set
@mysql_select_db("$DBName") or die("Unable to select database $DBName"); //at connection to the databse select DBNAME (phpforms) or tell that it couldnt connect
$sqlquery = "SEARCH * FROM $Table WHERE usr_name = '$_POST[usr_name]'";
$results = mysql_query($sqlquery);
if ($results = $usr_name)
//(!$results)
echo "sorry that user name has been taken! please use your browsers back button and try a different one!";
//echo (mysql_error());
else
{
mysql_close();
if ($usr_pass != $con_usr_pass)
echo "sorry the passwords to not match, please use your browsers back button to fix this error";
else
{
if ($email != $con_email)
echo "sorry the Emails you provided do not match, please use your browsers back button to fix this error";
else
{
mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable to connect to database"); //connecting to the database using the variable set
@mysql_select_db("$DBName") or die("Unable to select database $DBName"); //at connection to the databse select DBNAME (phpforms) or tell that it couldnt connect
$sqlquery = "INSERT INTO $Table VALUES('$id','$usr_name','$usr_pass','$email','$gender','$month','$_POST[day]','$year','$alt_email','$interests','$hobbies')";
$results = mysql_query($sqlquery); //query the results
mysql_close();
echo "Information has been submitted into the database!";
}
}
}
?>
[/php]
i dont get any errors, i always get the if in the first if statment, saying that the username is taken when in fact its not. ive tried swaping the Search for Select in the mysql part.
Dont forget to spread the reputation to those that deserve!
If you are doing a comparison you need to use "==" instead of "="
if ($results = $usr_name)
is always true.
if ($results = $usr_name)
is always true.
Need a website designer? arizona web design : phoenix web design : MCP Media intelligent web design and web development solutions. MCP Media is owned and operated by Chris Hooley - who happens to be a real nerd... on purpose :-)
another problem solved, thank sir!
NOOOOO spoke too soon. now it submits it, even if the name is in there twice. maybe my SQL formatting is off? maybe?
lol i do have an error in my syntax, now its about finding what it is and the correct syntax to use. to the mysql manual!
NOOOOO spoke too soon. now it submits it, even if the name is in there twice. maybe my SQL formatting is off? maybe?
lol i do have an error in my syntax, now its about finding what it is and the correct syntax to use. to the mysql manual!
Dont forget to spread the reputation to those that deserve!
not to be a jerk... but I am trying to help you, and I have helped you solve two programming problems since yesterday, and I see in my control panel that you gave me a negative reputation thing. What's up with that Killer_Typo?
Need a website designer? arizona web design : phoenix web design : MCP Media intelligent web design and web development solutions. MCP Media is owned and operated by Chris Hooley - who happens to be a real nerd... on purpose :-)
|
Other Threads in the PHP Forum
- Previous Thread: PHP Form Input
- Next Thread: updating 2 HTML tables on one PHP page
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest PHP Posts
- Today's Posts
- Unanswered Threads
301 apache api array autosuggest beginner binary broken cakephp checkbox class cms code compression cron curl data database date display dropdownlist dynamic echo email eregi error execution file files folder form forms function functions google href htaccess html httppost if...loop image include insert ip javascript joomla jquery key library limit link links login mail md5 menu mlm multiple mysql mysql_real_escape_string oop paypal pdf pdfdownload php phpvotingscript problem query radio random recursion remote screen script search searchbox server session sessions sms sorting source space sql syntax system table tutorial update upload url validator variable video volume votedown web website youtube zend
