<?php
$host = "localhost";
$user = "root";
$pass = "root";
$db = "users";
//创建一个mysql连接
$connection = mysql_connect($host, $user, $pass) or die("Unable to connect!");
mysql_query("set names 'utf8'");
//选择一个数据库
mysql_select_db($db) or die("Unable to select database!");
//查
$query = "SELECT * FROM user";
//执行SQL语句
$result = mysql_query($query) or die("Error in query: $query. ".mysql_error());
if(mysql_num_rows($result)>0){
while($row=mysql_fetch_row($result)){
print_r($row);
}
}
//插入数据
$sql = "insert into user (id,name,age,sex) values ('
$host = "localhost";
$user = "root";
$pass = "root";
$db = "users";
//创建一个mysql连接
$connection = mysql_connect($host, $user, $pass) or die("Unable to connect!");
mysql_query("set names 'utf8'");
//选择一个数据库
mysql_select_db($db) or die("Unable to select database!");
//查
$query = "SELECT * FROM user";
//执行SQL语句
$result = mysql_query($query) or die("Error in query: $query. ".mysql_error());
if(mysql_num_rows($result)>0){
while($row=mysql_fetch_row($result)){
print_r($row);
}
}
//插入数据
$sql = "insert into user (id,name,age,sex) values ('