Page 1 of 1

Mysql atažinimas ip is lenteles

Posted: 2013 Apr 05 16:41
by Spag
Kaip tiksliai reikia atpazinti ip is lenteles ir duoti tikrinimus?

db pavadinimas = duomenys
IP adreso lenteles pavadinimas = IP

Code: Select all

$tikrinimas = mysql_query("SELECT `IP` FROM `duomenys` WHERE `IP` = '".$ip_addr."' LIMIT 1;") or die(mysql_error());$patikra = mysql_fetch_array($tikrinimas);  if ($patikra){...}else {...{
bet sitaip neveikia, as blogai kazkaip tikrinu ta ip is lenteles su esamuoju ip, gal galit padeti?

Re: Mysql atažinimas ip is lenteles

Posted: 2013 Apr 05 22:14
by psychical

Code: Select all

$result = mysql_query("SELECT * FROM `lentele` WHERE `row_kuriame_ip` = '".$_SERVER['REMOTE_ADDR']."'"); if(mysql_num_rows($result)){    //vyksta kai randa}else{    //vyksta, kai neranda}

Re: Mysql atažinimas ip is lenteles

Posted: 2013 Apr 06 14:43
by Spag
psychical wrote:

Code: Select all

$result = mysql_query("SELECT * FROM `lentele` WHERE `row_kuriame_ip` = '".$_SERVER['REMOTE_ADDR']."'"); if(mysql_num_rows($result)){    //vyksta kai randa}else{    //vyksta, kai neranda}
ačiū, + karma