PHP问题
<?$mysql_server_name="localhost";
$mysql_username ="root";
$mysql_password ="";
$mysql_database ="qjkt";
//............................
echo $ip=getenv('REMOTE_ADDR');
//select
$conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password);
$sql="SELECT * FROM `counter` WHERE ip = '$ip' AND name = 'qjkt1' ";
$result=mysql_db_query($mysql_database,$sql,$conn);
$row=mysql_fetch_row($result);
print_r($row);
mysql_free_result($result);
if(!$row)
{
$conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password);
$sql="INSERT INTO `counter` ( `name` , `new` , `ip` , `time_at` ) VALUES ('qjkt1', '1', '$ip', NOW( ) )";
mysql_select_db($mysql_database,$conn);
$result=mysql_query($sql);
mysql_close($conn);
}
else
{
$conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password);
$sql="SELECT TIME_TO_SEC( NOW( ) ) - TIME_TO_SEC( time_at )
FROM `counter` WHERE ip = '$ip' AND name = 'qjkt1'ORDER BY `TIME_TO_SEC( NOW( ) ) - TIME_TO_SEC( time_at )` ASC ";
$result=mysql_db_query($mysql_database,$sql,$conn);
$row=mysql_fetch_row($result);
print_r($row);
mysql_free_result($result);
if([color=Red]$row[0]>5[/color])
{
$conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password);
$sql="INSERT INTO `counter` ( `name` , `new` , `ip` , `time_at` ) VALUES ('qjkt1', '1', '$ip', NOW( ) )";
mysql_select_db($mysql_database,$conn);
$result=mysql_query($sql);
mysql_close($conn);
}
}
//............................................//
$conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password);
$sql="SELECT COUNT(*) FROM `counter` WHERE name='qjkt1'";
$result=mysql_db_query($mysql_database,$sql,$conn);
$row=mysql_fetch_row($result);
//print_r($row);
mysql_free_result($result);
?>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head>
<body>
<? echo [color=Red]$row[0]; [/color]?>
</body>
</html>
请问红色部分表示的东西不是一样的么? 但是前者是时间 后者是栏位啊 怎么能这样 谁能帮我解释下 小菜鸟在着不胜感激了 谢谢你了 !~~~ 这是数组的第一个元素 恩...我知道是指数组第一个元素啊
但是...貌似第一个是时间 第2个是指数值哟
页:
[1]
