mi hanno consigliato per fare una query su 2 tabelle il seguente code
1)
<?php
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT"); // Data passata
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
// sempre modificato
header("Cache-Control: no-store, no-cache, must-revalidate"); // HTTP/1.1
header("Cache-Control: post-check=0, pre-check=0", false);
header("Pragma: no-cache"); // HTTP/1.0
error_reporting(E_ALL);
$host = 'localhost';
$dbuser = 'root';
$dbpass = '';
$dbname = 'pro1';
$table = 'tutorial_user_auth,admin_user_auth';
//$table = 'admin_user_auth';
$db = @mysql_connect($host,$dbuser,$dbpass) or die("error=could not connect to $host");
$db = mysql_select_db($dbname);
if(!$db)
{
print "error=could not connect to $dbname table";
exit;
}
?>
2)
<?
require_once('conf.inc.php');
require_once('functions.php');
// ---
// login, check user
// ---
function login($username,$pass)
{
GLOBAL $db,$table;
$username = trim($username);
$pass = trim($pass);
echo $table;
$query = mysql_query("SELECT * FROM $table tutorial_user_auth WHERE userName = '$username' AND userPassword = '$pass'");
if (mysql_num_rows($query)== 0) {
$query = mysql_query("SELECT * FROM $table WHERE userAdmin = '$username' AND passAdmin = '$pass'");
return mysql_num_rows($query);
}
else {
return mysql_num_rows($query);
}
}
// decisional switch
// ---
if(isset($HTTP_POST_VARS["action"]))
{
switch($HTTP_POST_VARS["action"])
{
case "login":
$result = login($HTTP_POST_VARS['username'],$HTTP_POST_VARS['pass']);
print "user=" . $result;
break;
}
}
?>
non funge dove è l'errore
Rispondi quotando
