- 论坛徽章:
- 0
|
<?
//数据库设置
$mysql_server_name = "localhost";
$mysql_username = "root";
$mysql_password = "123456";
$mysql_database = "count";
//建立连接 通过(服务器地址,用户名,密码)
$conn=mysql_connect( $mysql_server_name, $mysql_username, $mysql_password);
//SQL查询语法
$sql = "INSERT INTO `count`.`counter` (`new`)VALUES ('1')";
//选取数据库
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 'count'.'counter' ";
$result = mysql_db_query($sql_database,$sql,$conn);
mysql_fetch_row($result); --------------31行
print_r($row);
mysql_free_result($result); --------------35行
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title></title>
</head>
<body>
Hits:<?echo $row[0];?>
</body>
</html>
-----------------------------------------------=++++++++++++++++++++++++++++++++++++++++++++++++====
以下是错误显示:
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in F:\xampp\htdocs\index.php on line 31
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in F:\xampp\htdocs\index.php on line 35 |
|
免费注册
发表于 2008-06-15 10:24
