我 不懂PHP,現在查詢需要先登入再查詢，我想改成不需要登入就可以查詢 的不知道是不是要改我貼上的這段，請朋友們看看，謝謝，！
session_start();
error_reporting(0);
header("Content-type: text/html; charset=utf-8");
require "config.php";
@date_default_timezone_set(PRC);
set_time_limit(0);
@ob_end_clean();
ob_implicit_flush(true);
switch($_GET['act']){
case "database":
if(empty($_SESSION['member'])){
exit('var database=new Array("login");');
}
$connect_db = mysql_connect($dbnhost, $dbnuser, $dbnpass);
$select_db = mysql_select_db($dbname, $connect_db);
mysql_query("SET NAMES 'UTF8'");
mysql_query("SET CHARACTER SET UTF8");
mysql_query("SET CHARACTER_SET_RESULTS=UTF8");
$rs = mysql_query("SHOW TABLES FROM $dbname");
$tables = array();
while ($row = mysql_fetch_row($rs)) {
$tables[] = $row[0];
}
mysql_free_result($rs);
$array_tj=count($tables);
$count=1;
$text="";
foreach($tables as $key=>$tableName){
if($key==count($tables)-1){
$dian="";
}else{
$dian=",";
}
$text=$text.'"'.$tableName.'"'.$dian;
$count++;
}
echo "var database = new Array($text);";
break;
case "select":
if(empty($_SESSION['member'])){
echo "cnrv_msg(\"請登入\");addRow(\"登入後查詢\",\"登入後查詢\",\"登入後查詢\",\"登入後查詢\");";
exit;
}
$select_act=(int)addslashes(trim($_POST['select_act']));
$match_act=(int)addslashes(trim($_POST['match_act']));
$key=addslashes(trim($_POST['key']));
$table=addslashes(trim($_POST['table']));
if(empty($key) || $key==''){exit("請輸入查詢內容");}
if(strlen($key)<4){exit("key length!!!");}
$key = str_replace("_","\_",$key);
$key = str_replace("%","\%",$key);
switch($match_act){
case 2:$key = '=\''.$key.'\'';break;
case 1:$key = ' like \''.$key.'%\'';break;
default:exit("SB");
}
switch($select_act){//查詢方式
case 1:$limits="username".$key;break;
case 2:$limits="email".$key;break;
case 3:$limits="username".$key."or email".$key;break;
default:exit("SB");
}
$connect_db = mysql_connect($dbnhost, $dbnuser, $dbnpass);
$select_db = mysql_select_db($dbname, $connect_db);
mysql_query("SET NAMES 'UTF8'");
mysql_query("SET CHARACTER SET UTF8");
mysql_query("SET CHARACTER_SET_RESULTS=UTF8");
$sql="select $Field from `$table` where $limits LIMIT 30";
require "database.php";
$databasename=database($table);
if($result=mysql_query($sql)){
while($rows=mysql_fetch_assoc($result)){
$username= mysql_real_escape_string($rows['username']);
$email= mysql_real_escape_string($rows['email']);
$password= mysql_real_escape_string($rows['password']);
echo "addRow(\"$username\",\"$email\",\"$password\",\"$databasename\");";
}// end while
}
break;
default:print_r("SB");
}
回複討論(解決方案)
去掉
if(empty($_SESSION['member'])){
echo "cnrv_msg(\"請登入\");addRow(\"登入後查詢\",\"登入後查詢\",\"登入後查詢\",\"登入後查詢\");";
exit;
}
不行啊。去掉這個提示框不出了。但是不出查詢結果。。
if(empty($_SESSION['member'])){
exit('var database=new Array("login");');
}
if(empty($_SESSION['member'])){
echo "cnrv_msg(\"請登入\");addRow(\"登入後查詢\",\"登入後查詢\",\"登入後查詢\",\"登入後查詢\");";
exit;
}
這個去掉試試。
一樣。也是不出結果。
謝謝二位！！我沒重新整理，現在好了！
你選擇一個登陸後能查的地址重新登陸下。不顯示結果估計是參數的問題
0.0,好久沒看到mysql_的函數了.
去掉
13:if(empty($_SESSION['member'])){ exit('var database=new Array("login");');}47:if(empty($_SESSION['member'])){ echo "cnrv_msg(\"請登入\");addRow(\"登入後查詢\",\"登入後查詢\",\"登入後查詢\",\"登入後查詢\");"; exit; }78:$Field變數不存在,sql語句錯誤,可以列印一下sql語句,應該不正確,查詢不到結果,或者貼一下報錯代碼
