+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Programmers Gateway (https://lckb.dev/forum/forumdisplay.php?fid=196)
+---- Forum: Coders Talk (https://lckb.dev/forum/forumdisplay.php?fid=192)
+---- Thread: PHP, Login... (/showthread.php?tid=1467)
Pages:
1
2
- smogg - 12-31-2012
Dear LCKB Community :3
I want to start to learn "MySQL"...
Now I have found on YouTube a video
(How To make a Login and Register System in PHP) and is everything okay so far..., nevertheless, if I want to connect with the DB a mistake always comes although everything is properly:S
Login Control (only PHP):
<title>Login</title>
<form action="login2.php" method="post">
<table>
<Tr>
<td>Username: </td>
<td><input type="text" name="username" ></td>
</Tr>
<Tr>
<td>Password: </td>
<td><input type="password" name="password" ></td>
</Tr>
<Tr>
<td><input type="submit" name="loginbtn" value="Login"></td>
<td><a href="newregister.php">Register</a></td>
</Tr>
</table>
Login Script (Not yet ready but with Error):
<?php
$user_id = $_POST['username'];
$passwd = $_POST['password'];
if($user_id && $passwd){
$connect = mysql_connect("localhost","root","");
mysql_select_db("ep1_db_auth");
$query = mysql_query("SELECT * FROM bg_user WHERE username='$user_id' && password='$passwd'");
$numrows = mysql_num_rows($query);
echo("$numrows");
}
else
echo("Bitte geben sie ihre Daten ein.");
?>
I get this mistake over and over again; "Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in D:\xampp\htdocs\login2.php on line 9"
Hope somebody can help me :S
~SmoGG.
- AdiH97 - 12-31-2012
Error :
$query = mysql_query("SELECT * FROM bg_user WHERE username='$user_id' && password='$passwd'");
Changed to this
$query = mysql_query("SELECT * FROM bg_user WHERE username='$user_id' AND password='$passwd'");
Correct me if i'm wrong
- smogg - 12-31-2012
Error :
$query = mysql_query("SELECT * FROM bg_user WHERE username='$user_id' && password='$passwd'");
Changed to this
$query = mysql_query("SELECT * FROM bg_user WHERE username='$user_id' AND password='$passwd'");
Correct me if i'm wrong
Hmmm nope same Problem :S
Here the Video (look 4:30-5:30 maybe) -
- AdiH97 - 12-31-2012
You are working with bg_user of newproject_db_suth??
- smogg - 12-31-2012
mysql_select_db("ep1_db_auth");
so yes
- AdiH97 - 12-31-2012
ok
$query = mysql_query("SELECT * FROM bg_user WHERE user_id='$user_id' && passwd='$passwd'");
- smogg - 12-31-2012
hmm now another error :
Notice: Undefined index: user_id in D:\xampp\htdocs\login2.php on line 2
Notice: Undefined index: passwd in D:\xampp\htdocs\login2.php on line 3
<?php
$user_id = $_POST['username'];
$passwd = $_POST['password'];
if($user_id && $passwd){
$connect = mysql_connect("localhost","root","");
mysql_select_db("ep1_db_auth");
$query = mysql_query("SELECT * FROM bg_user WHERE user_id='$user_id' && passwd='$passwd'");
$numrows = mysql_num_rows($query);
echo("$numrows");
}
else
echo("Bitte geben sie ihre Daten ein.");
?>
- AdiH97 - 01-01-2013
Go fisrt to login.php, then press submit and watch if in login2.php you have the same error.
- smogg - 01-01-2013
Go fisrt to login.php, then press submit and watch if in login2.php you have the same error.
Okay working now ... thanks for your help. :3
- Wizatek - 01-01-2013
If u start to learn, and u are not familliar with a certain system yet.
Please start with mysqli or PDO, the old mysql_ functions used in php should no longer be used so it would be a waste to learn how to work with that.