schimpfk Posted April 2, 2013 Posted April 2, 2013 I got a login script code but when add it it says: "Cannot select DB" You can find the whole code http://www.phpeasystep.com/phptu/6.html.Here it is: &--#60;?php $host="localhost"; // Host name $username="schimpfk"; // Mysql username $password="**PASSWORD**"; // Mysql password $db_name="test"; // Database name $tbl_name="members"; // Table name // Connect to server and select databse. mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB"); // username and password sent from form $myusername=$_POST['myusername']; $mypassword=$_POST['mypassword']; // To protect MySQL injection (more detail about MySQL injection) $myusername = stripslashes($myusername); $mypassword = stripslashes($mypassword); $myusername = mysql_real_escape_string($myusername); $mypassword = mysql_real_escape_string($mypassword); $sql="SELECT * FROM $tbl_name WHERE username='$myusername' and password='$mypassword'"; $result=mysql_query($sql); // Mysql_num_row is counting table row $count=mysql_num_rows($result); // If result matched $myusername and $mypassword, table row must be 1 row if($count==1){ // Register $myusername, $mypassword and redirect to file "login_success.php" session_register("myusername"); session_register("mypassword"); header("location:login_success.php"); } else { echo "Wrong Username or Password"; } ?&--#62; I changed my password! 1
Shinryuu Posted April 3, 2013 Posted April 3, 2013 <?php $host="localhost"; // Host name $username=""; // Mysql username $password=""; // Mysql password $db_name=""; // Database name $tbl_name=""; // Table name // Connect to server and select databse. $con = mysql_connect("$host", "$username", "$password")or die("cannot connect"); $db = mysql_select_db($db_name, $con); if(!$db){ echo "connection failed"; } else{ echo "connection worked"; } // username and password sent from form $myusername=$_POST['myusername']; $mypassword=$_POST['mypassword']; // To protect MySQL injection (more detail about MySQL injection) /* $myusername = stripslashes($myusername); $mypassword = stripslashes($mypassword); $myusername = mysql_real_escape_string($myusername); $mypassword = mysql_real_escape_string($mypassword); $sql="SELECT * FROM $tbl_name WHERE username='$myusername' and password='$mypassword'"; $result=mysql_query($sql); // Mysql_num_row is counting table row $count=mysql_num_rows($result); // If result matched $myusername and $mypassword, table row must be 1 row if($count==1){ // Register $myusername, $mypassword and redirect to file "login_success.php" session_register("myusername"); session_register("mypassword"); header("location:login_success.php"); } else { echo "Wrong Username or Password"; }*/ ?> works for me http://shinryuu.net/db_test.php
alcoriza05 Posted April 4, 2013 Posted April 4, 2013 Maybe the problem is your database info. Check the db name.
khaos Posted May 14, 2013 Posted May 14, 2013 your not calling the database right, best thing i can say unless i seen it, is trial and error my friend
Krydos Posted May 15, 2013 Posted May 15, 2013 $db_name="test"; // Database name This database name is incorrect because all databases that users can create have their username appended to the front of it. If you type in "test" then the database name is "schimpfk_test". Hence the "cannot select database" error.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now