1. SA-MP Forums Archive
  2. Other
  3. Everything and Nothing

Threaded Mode
PHP Status show help
thimo
High-roller
*****
Posts: 1,130
Threads: 181
Joined: Jan 2009
Reputation: 0
#1

27.01.2012, 17:37
So im trying to make a PHP status show for the online player login but it always returns 0 rows anyone sees how to fix that?
PHP код:
<? 
session_start();
if(!session_is_registered(Name)){
header("location:Accounts.php");
}
?>

<html>
<body>
<?php
/* Change next two lines  if using online*/
$db="Censored";
$link = mysql_connect('Censored', 'Censored', 'Censored');
if (! $link) die(mysql_error());
mysql_select_db($db , $link) or die("Couldn't open $db: ".mysql_error());
$myusername=$_POST['myusername']; 
$mypassword=$_POST['mypassword'];
$myusername = stripslashes($myusername);
$mypassword = stripslashes($mypassword);
$myusername = mysql_real_escape_string($myusername);
$mypassword = mysql_real_escape_string($mypassword);
$result = mysql_query( "SELECT * FROM Users WHERE Name ='$Name' and Password='$mypassword'" )
          or die("SELECT Error: ".mysql_error());
$num_rows = mysql_num_rows($result);
print "There are $num_rows records.<br>";
print "<table width=600 border=1>\n";
print "Name, admin, PosX, PosY, PosZ, Score, Male/Female/Age";
while ($get_info = mysql_fetch_row($result)){
print "<tr>\n";
foreach ($get_info as $field)
print "\t<td>$field</td>\n";
print "</tr>\n";
}
print "</table>\n";
mysql_close($link);
?>

</body>
</html>
Thanks in advance
Find
Reply
Bumbis
Huge Clucker
***
Posts: 203
Threads: 11
Joined: Jan 2010
Reputation: 0
#2

27.01.2012, 17:42
I dont see variable $Name defined anywhere. I guess you might use $myusername instad of $Name in that query.
Find
Reply
thimo
High-roller
*****
Posts: 1,130
Threads: 181
Joined: Jan 2009
Reputation: 0
#3

27.01.2012, 17:44
Did that and it returns 0 rows
Find
Reply
royal_king
Gangsta
****
Posts: 597
Threads: 4
Joined: Jul 2010
Reputation: 0
#4

27.01.2012, 18:10
PHP код:
mysql_query( "SELECT * FROM Users WHERE Name ='$Name' and Password='$mypassword'" ) 
          or die("SELECT Error: ".mysql_error()); 
No $Name value defined so use this below one


PHP код:
mysql_query( "SELECT * FROM Users WHERE Name ='$myusername' and Password='$mypassword'" ) 
          or die("SELECT Error: ".mysql_error()); 
And is you're database got some values in it? (i mean information like name, etc..)

Insert some values into database for test and try, if any problem let us know.
Find
Reply
thimo
High-roller
*****
Posts: 1,130
Threads: 181
Joined: Jan 2009
Reputation: 0
#5

27.01.2012, 19:15
Well that aint working All i want to do is print the info of the specified player if you need my checklogin.php this is it:
PHP код:
<?php
$host="CENSORED"; // Host name 
$username="CENSORED"; // Mysql username 
$password="CENSORED"; // Mysql password 
$db_name="CENSORED"; // Database name 
$tbl_name="CENSORED"; // 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 Name ='$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("Name");
session_register("mypassword"); 
header("location:login_success.php");
}
else {
echo "Wrong Username or Password";
}
?>
Find
Reply
Sinner
Gangsta
*****
Posts: 772
Threads: 52
Joined: Aug 2010
Reputation: 0
#6

28.01.2012, 09:39
THe code looks good, maybe you have 2 records with the same name? Try:

PHP код:
echo "We found ".$count." rows"; // debug
if($count >= 1) {
    ...
} else {
    ...
} 
Find
Reply
thimo
High-roller
*****
Posts: 1,130
Threads: 181
Joined: Jan 2009
Reputation: 0
#7

28.01.2012, 16:21
I now got this:
PHP код:
<? 
session_start();
if(!session_is_registered(Name)){
header("location:Accounts.php");
}
?>

<html>
<body>
<?php
$host="Censored"; // Host name 
$username="Censored"; // Mysql username 
$password="Censored"; // Mysql password 
$db_name="Censored"; // Database name 
$tbl_name="Censored"; // 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'];

$sql= sprintf("SELECT Name, Password FROM $tbl_name WHERE Name ='$myusername'");
$result=mysql_query($sql);
while ($row = mysql_fetch_assoc($result))
{
    echo $row['Name'];
    echo $row['Password'];
}
?>

</body>
</html>
I found out that the thingy $myusername doesnt get the value from the login form so it doesnt query it with the right name...
Anyone have an idea why?
Find
Reply
Sinner
Gangsta
*****
Posts: 772
Threads: 52
Joined: Aug 2010
Reputation: 0
#8

28.01.2012, 18:23
Show us your input form please
Find
Reply
thimo
High-roller
*****
Posts: 1,130
Threads: 181
Joined: Jan 2009
Reputation: 0
#9

28.01.2012, 18:24
Код HTML:
<table width="100" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">

<tr>

<form name="form1" method="post" action="checklogin.php">

<td>

<table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">

<tr>

<td colspan="3"><strong>Player Login </strong></td>

</tr>

<tr>

<td width="50">Username</td>

<td width="1">:</td>

<td width="294"><input name="myusername" type="text" id="myusername"></td>

</tr>

<tr>

<td>Password</td>

<td>:</td>

<td><input name="mypassword" type="password" id="mypassword"></td>

</tr>

<tr>

<td>&nbsp;</td>

<td>&nbsp;</td>

<td><input type="submit" name="Submit" value="Login"></td>

</tr>

</table>

</td>

</form>

</tr>

</table>
And btw i now get these errors from checklogin.php when Username and pw are right:
Код:
Deprecated: Function session_register() is deprecated in /home/thimo/public_html/checklogin.php on line 37

Warning: session_register() [function.session-register]: Cannot send session cache limiter - headers already sent (output started at /home/thimo/public_html/checklogin.php:37) in /home/thimo/public_html/checklogin.php on line 37

Deprecated: Function session_register() is deprecated in /home/thimo/public_html/checklogin.php on line 38

Warning: Cannot modify header information - headers already sent by (output started at /home/thimo/public_html/checklogin.php:37) in /home/thimo/public_html/checklogin.php on line 39
And this is the checklogin.php
PHP код:
<?php
ini_set('display_errors', 1); // 0 = uit, 1 = aan
error_reporting(E_ALL);
$host="188.138.79.5"; // Host name 
$username="johan_Mysql"; // Mysql username 
$password="Thimo9"; // Mysql password 
$db_name="johan_Mysql"; // Database name 
$tbl_name="Users"; // 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 Name ='$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";
}
?>
Find
Reply
Sinner
Gangsta
*****
Posts: 772
Threads: 52
Joined: Aug 2010
Reputation: 0
#10

28.01.2012, 18:26
I think the reason is because you forgot to terminate your input fields ' />'

try this:
Код HTML:
<table width="100" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
	<tr>
	<form name="form1" method="post" action="checklogin.php">
		<td>
		<table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">
			<tr>
				<td colspan="3"><strong>Player Login </strong></td>
			</tr>
			<tr>
				<td width="50">Username</td>
				<td width="1">:</td>
				<td width="294"><input name="myusername" type="text" id="myusername" /></td>
			</tr>
			<tr>
				<td>Password</td>
				<td>:</td>
				<td><input name="mypassword" type="password" id="mypassword" /></td>
			</tr>
			<tr>
				<td>&nbsp;</td>
				<td>&nbsp;</td>
				<td><input type="submit" name="Submit" value="Login"></td>
			</tr>
		</table>
		</td>
	</form>
	</tr>
</table>
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. Other
  3. Everything and Nothing