php优化
<?php<br />//define server info begin<br />$servername = "192.168.1.182"; <br />$serverusername = "whh"; <br />$serverpassword = "whh"; <br />$database="whh";<br />$usertable="user";<br />$userfield="user_name";<br />$passwordfield="password";<br />//define server info end<br /><br />$fh = fopen("php://stdin", 'r');<br />$stdout = fopen('php://stdout', 'w');<br />$fs = fopen("auth-log.txt." . getmypid(), 'a');<br /><br />if(!$fh){<br /> die("Cannot open STDIN\n");<br />}<br /><br />do{<br /> $lenBytes = fgets($fh, 3);<br /> $len = unpack('n', $lenBytes);<br /> $len = $len[1];<br /> if($len<1) continue;<br /> $msg = fgets($fh, $len+1);<br /> $toks=explode(':',$msg);<br /> fwrite($fs, $msg . "\n");<br /><br /> $method = array_shift($toks);<br /> fwrite($fs, "$method\n");<br /> $result = false;<br /><br /> switch($method){<br /> case 'auth':<br /> list($username, $server, $password) = $toks;<br /> $password = trim($password);<br /> fwrite($fs, "checking user: $username and password $password\n");<br /> //check password begin<br /> $conn=mysql_connect($servername, $serverusername, $serverpassword); <br /> mysql_query("set names 'utf8'");<br /> <b>6本文来源gao@dai!ma.com搞$代^码!网7</b><pre>搞gaodaima代码
if(!$conn){
die(“could not connect to the database”);
}
$db_select=mysql_select_db($database);//选择数据库
if(!$db_select)
{
die(“could not to the database”);
}
$query=”select * from $usertable where $userfield = ‘$username’ and $passwordfield=’$password'”;//构建查询语句
$result=mysql_query($query);//执行查询
$count=mysql_numrows($result);//取得条数
mysql_close($conn);
if($count > 0){
$result = true;
}else{
$result = false;
}
//check password end
break;
case ‘isuser’:
list($username, $server) = $toks;
//check password begin
$conn=mysql_connect($servername, $serverusername, $serverpassword);
mysql_query(“set names ‘utf8′”);
if(!$conn){
die(“could not connect to the database”);
}
$db_select=mysql_select_db($database);//选择数据库
if(!$db_select)
{
die(“could not to the database”);
}
$query=”select * from $usertable where $userfield = ‘$username'”;//构建查询语句
$result=mysql_query($query);//执行查询
$count=mysql_numrows($result);//取得条数
mysql_close($conn);
if($count > 0){
$result = true;
}else{
$result = false;
}
//check password end
break;
default:
$result = false;
}
$message = @pack(“nn”, 2, $result);
fwrite($stdout, $message);
$dump = @unpack(“nn”, $message);
$dump = $dump[“n”];
fwrite($fs, $dump . “\n”);
flush();
} while(true);
大家好！
对php我不懂，请大家看下是否可以对该php做些优化呢?
我是写java的，发现可能在这个地方“$conn=mysql_connect($servername, $serverusername, $serverpassword);”可以进行优化，没有必要每次都生成一个$conn。
转载请注明原文链接：php优化解决方案
