iWareWolf_ Posted June 3, 2013 Share Posted June 3, 2013 $data = mysql_query("SELECT ip,points FROM information") or die(mysql_error()); if (!empty($_SERVER['HTTP_CLIENT_IP'])){ $ip=$_SERVER['HTTP_CLIENT_IP']; }elseif (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])){ $ip=$_SERVER['HTTP_X_FORWARDED_FOR']; }else{ $ip=$_SERVER['REMOTE_ADDR']; } $ip = ip2long($ip); while($info = mysql_fetch_array( $data )) { if($info['ip'] != null && $info['ip'] == $ip){ Print "You have $info[points] points!"; } else { mysql_query("INSERT INTO information VALUES ('$ip','0')'"); Print "You have 0 points!"; } } This is just giving me a blank page. Link to comment https://forums.phpfreaks.com/topic/278699-i-dont-understand-why-this-isnt-doing-anything/ Share on other sites More sharing options...
Jessica Posted June 3, 2013 Share Posted June 3, 2013 Well, turn on error reporting. A blank page where there should be output indicates a fatal error. Link to comment https://forums.phpfreaks.com/topic/278699-i-dont-understand-why-this-isnt-doing-anything/#findComment-1433732 Share on other sites More sharing options...
iWareWolf_ Posted June 3, 2013 Author Share Posted June 3, 2013 I would normally get errors but this gives me a blank page. Also Im using Dreamweaver CS5.5 Link to comment https://forums.phpfreaks.com/topic/278699-i-dont-understand-why-this-isnt-doing-anything/#findComment-1433734 Share on other sites More sharing options...
mac_gyver Posted June 3, 2013 Share Posted June 3, 2013 have you intentionally echoed a test string right after that block of code so that you know that code is being executed? what does the 'view source' of your blank page show? Link to comment https://forums.phpfreaks.com/topic/278699-i-dont-understand-why-this-isnt-doing-anything/#findComment-1433735 Share on other sites More sharing options...
iWareWolf_ Posted June 3, 2013 Author Share Posted June 3, 2013 Just this. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Wolf Empire</title> </head> <body> </body> </html> There is nothing there. I got most of the code online and placed it together. Link to comment https://forums.phpfreaks.com/topic/278699-i-dont-understand-why-this-isnt-doing-anything/#findComment-1433736 Share on other sites More sharing options...
mac_gyver Posted June 3, 2013 Share Posted June 3, 2013 assuming the php code you posted is supposed to output it's result between the <body></body> tags, the implies that your database table doesn't have any rows in it. is that all of the php code (less any database credentials)? Link to comment https://forums.phpfreaks.com/topic/278699-i-dont-understand-why-this-isnt-doing-anything/#findComment-1433737 Share on other sites More sharing options...
Jessica Posted June 3, 2013 Share Posted June 3, 2013 Then yes, your query is not returning anything. Did you try running the query directly in MySQL? Also, stop using Dreamweaver. Now. Link to comment https://forums.phpfreaks.com/topic/278699-i-dont-understand-why-this-isnt-doing-anything/#findComment-1433738 Share on other sites More sharing options...
iWareWolf_ Posted June 3, 2013 Author Share Posted June 3, 2013 At the moment, it returns MySQL returned an empty result set (i.e. zero rows). ( Query took 0.0004 sec ) I don't have anything on it atm, but Im planning to add. Also the code seems to stop off here. while($info = mysql_fetch_array( $data )) { Link to comment https://forums.phpfreaks.com/topic/278699-i-dont-understand-why-this-isnt-doing-anything/#findComment-1433868 Share on other sites More sharing options...
jcbones Posted June 3, 2013 Share Posted June 3, 2013 Mysql can't return something it doesn't have. So of course it will stop at the data call. Add some test data, test it, then comw back here with any questions. Link to comment https://forums.phpfreaks.com/topic/278699-i-dont-understand-why-this-isnt-doing-anything/#findComment-1433870 Share on other sites More sharing options...
Jessica Posted June 3, 2013 Share Posted June 3, 2013 ... What did you think would happen? Link to comment https://forums.phpfreaks.com/topic/278699-i-dont-understand-why-this-isnt-doing-anything/#findComment-1433872 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.