k,
post daw ng source code sa retrieve.php.
Results 11 to 20 of 38
Thread: Help with my php code
-
01-26-2012, 09:31 PM #11Junior Member
- Join Date
- Jan 2012
- Gender
- Posts
- 31
-
01-26-2012, 09:32 PM #12Elite Member
- Join Date
- Jun 2010
- Gender
- Posts
- 1,018
Re: Help with my php code
try daw ni...from boang's codes and stuff I just remembered.
Kung naa nay debug bay...try checking when nag-null or false ang result.Code:$link=mysql_connect("localhost", "root", ""); if(!$link){ die("ERROR".mysql_error()); } mysql_select_db("databasename", $link); $myusername=$_POST['myusername']; $mypassword=$_POST['mypassword']; $sql="SELECT * FROM table_name WHERE username='$myusername' and password='$mypassword'"; //Added the connection parameter, since you are using procedural. Try the OOP approach if it fits your style. $result=mysql_query($link, $sql); //You are getting a null or boolean value from $result because during the query the resource object was not supplied //which in this case is the connection or link $count=mysql_num_rows($result); if($count>0){ echo "Success"; } else { echo "Wrong Username or Password"; }Last edited by Klave; 01-26-2012 at 09:35 PM.
-
01-26-2012, 09:36 PM #13 Re: Help with my php code
Noted. I'm still reviewing my PHP.
Originally Posted by Klave
btw,
$query=('SELECT * FROM USERS WHERE USERNAME = "$user" and PASSWORD = "$pass"')
ang kaning bold letters (parenthesis)? gamit ba ni? mura'g mao ni siguro naka error?
-
01-26-2012, 09:41 PM #14C.I.A.
- Join Date
- Jul 2009
- Gender
- Posts
- 3,806
Re: Help with my php code
<?php
$link=mysql_connect("localhost", "root", "") or die(mysql_error());
mysql_select_db("user", $link) or die(mysql_error());
$myusername=$_POST['user'];
$mypassword=$_POST['pass'];
$sql=("SELECT * FROM USERS WHERE username='$myusername' and password='$mypassword'") or die(mysql_error());
$result=mysql_query($sql);
while($row=mysql_num_rows($result))
{
$user=$row['USERNAME'];
$pass=$row['PASSWORD'];
{
if((strcmp($user,$myusername)) and (strcmp($pass,$mypassword)))
{
header('Location:home.html');
}
else
{
echo"FAILED TO LOGIN!";
}
}
}
?>
i altered my code and the local server responded slowly....kung akong i false di li mo echo...kung true mau kay mo sud sa header location...pero loading pud lagi kau...ok ra ang code nako? well for basics anyway
-
01-26-2012, 09:46 PM #15C.I.A.
- Join Date
- Jul 2009
- Gender
- Posts
- 3,806
Re: Help with my php code
changed to fetch array because the previous seems illogical....and still not working..crap with this man.... Originally Posted by senpai91
Last edited by senpai91; 01-26-2012 at 09:49 PM.
-
01-26-2012, 09:48 PM #16C.I.A.
- Join Date
- Jul 2009
- Gender
- Posts
- 3,806
Re: Help with my php code
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> Originally Posted by merinoabs
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<form action = "retrieve.php" method="POST">
USERNAME<input type="text" name="user">
PASSWORD<input type="password" name="pass">
<input type="submit" name="submit">
</form>
</body>
</html>
-
01-26-2012, 09:50 PM #17C.I.A.
- Join Date
- Jul 2009
- Gender
- Posts
- 3,806
Re: Help with my php code
kung null kay blank php...
pero kung true or false....kay false permi ang statement....di jud ma true....
-
01-26-2012, 09:51 PM #18Junior Member
- Join Date
- Jan 2012
- Gender
- Posts
- 31
Re: Help with my php code
ok nana bai sa kni nlng na part.
if((strcmp($user,$myusername)) and (strcmp($pass,$mypassword)))
to
if(strcmp($user,$myusername) == 0 AND strcmp($pass,$mypassword) == 0)
-
01-26-2012, 09:58 PM #19C.I.A.
- Join Date
- Jul 2009
- Gender
- Posts
- 3,806
Re: Help with my php code
^dude
if(strcmp($user,$myusername) == 0 AND strcmp($pass,$mypassword) == 0)
//if($myusername==$user and $mypassword==$pass)
the above not comment code is yours and tried it works if the statement is true...pero kung false or null a blank php dili mo echo ang naa sa else
the comment there is mine same thing kung true mo work pero kung null or false no luck...
-
01-26-2012, 10:08 PM #20Junior Member
- Join Date
- Jan 2012
- Gender
- Posts
- 31
Re: Help with my php code
gi simplify lng nko bro.
nabantayn sd nko nga double checking n cya so ako nlng gipa mub.an
//Connect to database
$link = mysql_connect("localhost", "root", "") or die(mysql_error());
mysql_select_db("user", $link) or die(mysql_error());
//Get post parameters from form
$myusername=$_POST['user'];
$mypassword=$_POST['pass'];
//Check database if username & password exist
$sql = ("SELECT * FROM USERS WHERE username='$myusername' and password='$mypassword'") or die(mysql_error());
$result = mysql_query($sql);
if(mysql_num_rows($result) > 0)
header('Location:home.html');
else
echo"FAILED TO LOGIN!";
gamit 'mysql_real_escape_string' sa mga global variables kng production use ni cya pra ma prevent sa SQL Injection.
Reply With Quote
Advertisement
Similar Threads |
|
Posting Permissions
|