mysql_conncet('主机地址','用户名','密码')连接数据库
$link = mysql_connect("localhost","root","123456")or die("连接失败!".mysql_error());
if($link){
echo "数据库连接成功!";
}
mysql_select_db("数据库名",连接)选择数据库
$select_db = mysql_select_db("db_admin",$link)or die("数据库不存在!");
if($select_db){
echo "选择数据库成功!";
}
mysql_query(SQL,连接)执行SQL语句
$result = mysql_query("insert into admin(user,pwd)values('admin','111')",$link)or die("操作失败!");
if($result){
echo "操作成功!";
}
mysql_fetch_array($result);将查询结果封装为一个array数组
(row的扩展版,能作为索引储存,不明显比row慢)
$arr = mysql_fetch_array($result);
do{
echo $arr[0]." ";
echo $arr[1]." ";
echo $arr[2]."<br>";
}while($arr=mysql_fetch_array($result));//循环读取直到没有下一条数
mysql_fetch_object($result);将查询结果封装为一个对象
$object = mysql_fetch_object($result);
do{
echo $object->id." ";
echo $object->user." ";
echo $object->pwd."<br>";
}while($object=mysql_fetch_object($result));//循环读取直到没有下一条数据
mysql_fetch_row($result);将查询结果封装为一个数组
$row = mysql_fetch_row($result);
do{
echo $row[0]." ";
echo $row[1]." ";
echo $row[2]."<br>";
}while($row=mysql_fetch_row($result));//循环读取直到没有下一条数据
mysql_num_rows($result);返回查询结果的条数
$nums = mysql_num_rows($result);
echo $nums;
将数据库连接封装成一个类
<?php
class ConnDB{
var $dbtype;//定义链接属性
var $host;
var $user;
var $pwd;
var $dbname;
var $conn;
function ConnDB($dbtype,$host,$user,$pwd,$dbname){//创建构造方法
$this->dbtype = $dbtype;
$this->host = $host;
$this->user = $user;
$this->pwd = $pwd;
$this->dbname = $dbname;
}
function getConn(){//链接方法
$this->conn = mysql_connect($this->host,$this->user,$this->pwd) or die("链接失败".mysql_error());
mysql_select_db($this->dbname,$this->conn) or die("选择失败".mysql_error());
mysql_query("set names utf-8");
return $this->conn;
}
function closeConn(){
mysql_close($this->conn);
}
}
?>
调用时:
$conn_db = new ConnDB("mysql","localhost","root","123456","db_admin");
$conn_db->getConn();
$sql = mysql_query("insert into student(name,pro,remark)values('$name','$pro','$remark')");
if($sql){
echo "添加成功!";
}
$conn_db->closeConn();