schimpfk Posted April 2, 2013 Share 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 Quote Link to comment Share on other sites More sharing options...
Shinryuu Posted April 3, 2013 Share 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 Quote Link to comment Share on other sites More sharing options...
alcoriza05 Posted April 4, 2013 Share Posted April 4, 2013 Maybe the problem is your database info. Check the db name. Quote Link to comment Share on other sites More sharing options...
khaos Posted May 14, 2013 Share 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 Quote Link to comment Share on other sites More sharing options...
Krydos Posted May 15, 2013 Share 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.