[Resolved] Using Loops to cycle results

[olly2111]

I have a mysql database with a list of urls in, i want to be able to cycle through the results and if the current hostname matches one in a database show the file, if not show an error. Is this possible?

[mystrymaster]

$query = mysql_query(SELECT url FROM TABLENAME) or die(mysql_error());
WHILE ($row = mysql_fetch_array($query)) {
    if ($row[url] == 'url_you_want_to_match') {
       //show what you want here
    } else {
      // show the error here
    }
}

[olly2111]

<?php
$connect = mysql_connect(HOST, USER, "PASS");
mysql_select_db(DB, $connect);
$url = $HTTP_SERVER_VARS["HTTP_HOST"];
$query = mysql_query("SELECT url FROM allowed") or die(mysql_error()); 
WHILE ($row = mysql_fetch_array($query)) { 
    if ($row[url] == '$url') { 
echo($url);
?>
       Approved
<?php
    } else {
echo($url);
?> 
      Denied
<?php
    } 
}
?>

It always says denied even though the correct url is in the database, whats the problem?

[olly2111]

ive changed a few things, however the code doesnt stop, how would i make it stop once it finds a url and also not display the error messages over and over again, only the once at the end if it doesnt find it?

[tuf-web_co_uk]

change

$query = mysql_query("SELECT url FROM allowed") or die(mysql_error());  

to

$query = mysql_query("SELECT url FROM allowed LIMIT 0,1") or die(mysql_error());  

from the sounds of it you are probably looking for the same domain from the result as the current domain

so you would want something like this

$query = mysql_query("SELECT url FROM allowed WHERE url='".$domain."' LIMIT 0,1") or die(mysql_error());  

[olly2111]

so what ur sayin is that i dont need the loop?
I just check the db for the $url and if found show code if not show error?

[tuf-web_co_uk]

exactly

<?php 
$connect = mysql_connect(HOST, USER, "PASS"); 
mysql_select_db(DB, $connect); 
$url = $HTTP_SERVER_VARS["HTTP_HOST"]; 
$query = mysql_query("SELECT url FROM allowed WHERE url='$url' LIMIT 0,1") or die(mysql_error());  

$num = mysql_num_results($query);
    if ($num < 1) {  

echo "$url Approved"; 
    } else { 
echo "$url Denied"; 
    }  

?> 

i think that should work :S

[tuf-web_co_uk]

i changed that incase u didnt notice ( $num < 0 ) to ( $num < 1 )

sorry

[olly2111]

Fatal error: Call to undefined function: mysql_num_results() in /home/ollyculv/public_html/chris/test.php on line 6

[olly2111]

mysql_num_rows instead 🙂

[tuf-web_co_uk]

sorry, its been like a couple of months since i coded php, and i turned my attention to vb

did that code work with mysql_num_rows?

[olly2111]

yea however i wanted something similar to that. Instead of the hostname. I wanted the first dir name e.g:
http://www.mydomain.com/test is in the db so its accepted however http://www.mydomain.com/testing isnt in the db so its rejected.
Is there any way to remove the url part after the first directory?

[olly2111]

bump
Any ideas?

[fean0r]

is the domain always the same?

$url = str_replace("http://www.mydomain.com/ ", "", $url);

[olly2111]

yea it is always the same, just different subdomains.
How would i use the above code to work out which subdomain they are using the script from?