[acctman]

can someone help with a simiple PHP code that does the following...

When user visits show.php check mysql db table for there IP, if IP is present then deny access to that page (redirect to main.php) If IP is not present then store IP in the database.

i know a little bit about php so any example would be great

[Keith]

In a nutshell:

PHP Code:

<?php



$ip_found = mysql_num_rows(mysql_query("SELECT ip FROM table_name WHERE ip = '" . $_SERVER['REMOTE_ADDR'] . "'"));



if ($ip_found > 0)

header("location: main.php");

else

mysql_query("INSERT INTO table_name (ip) VALUES (" . $_SERVER['REMOTE_ADDR'] . ")");



// rest of page here



?>

[acctman]

can I use two database? the following is what i use to grab the user name and gender for the login. for the ip logging i what to store and get info from a different database "chatdb" is there a trick to working with two db's ?

PHP Code:

<?



        include $_SERVER['DOCUMENT_ROOT'] . '/dbmain.php';

        include $_SERVER['DOCUMENT_ROOT'] . '/kernel/db_funcs/mysql.php';

        sql_connect($db_server, $db_user, $db_pass);

        sql_select_db($db_name);







session_start();

$user=$_SESSION['user'];



if($user=="") {

header("Location: index.php");

}



$res = sql_query("select * from rate_members where m_user='$user'");

$info = mysql_fetch_assoc($res);

$u_type = $info['m_type'];

if ($u_type == 1) {

$sex = "F";

} else {

$sex = "M";

}

?>