PHP基礎------操作mysql函數

標籤：

//串連資料庫function conn($dbhost,$dbuser,$dbpwd,$dbname){    $link = @mysql_connect($dbhost,$dbuser,$dbpwd) or die("串連資料庫錯誤!".mysql_error());    mysql_select_db($dbname,$link);    mysql_query("set names utf8");}//執行sql語句function query($sql){    return mysql_query($sql);}//返回記錄數function numRows($sql){    $result = mysql_query($sql);    return mysql_num_rows($result);}//擷取一條資訊,返回一維數組function getOne($sql){    $result = mysql_query($sql);    return mysql_fetch_assoc($result);}//擷取多條資訊，返回多維陣列function getAll($sql){    $result = mysql_query($sql);    $rows = array();    while($rs = mysql_fetch_assoc($result))    {        $rows[] = $rs;    }    return $rows;}//關閉資料庫function close(){    mysql_close();}

<?php$config = array(    ‘dbhost‘=>‘localhost‘,    ‘dbuser‘=>‘root‘,    ‘dbpwd‘=>‘‘,    ‘dbname‘=>‘myblog‘);

 

PHP基礎------操作mysql函數