å¨è½å¤è®¿é®å¹¶å¤çæ°æ®åºä¸çæ°æ®ä¹åï¼å¿ é¡»å建å°è¾¾æ°æ®åºçè¿æ¥ã
å¨ PHP ä¸ï¼è¿ä¸ªä»»å¡éè¿ mysql_connect() å½æ°å®æã
å·¥å ·åæï¼çµè+php+mysql
phpé¾æ¥mysqlçæ¹æ³å¦ä¸ï¼
æ¹æ³ä¸ã
å ååºå¦ä¸å设ï¼ä¹éç¨ä¸æ¹æ³äºåæ¹æ³ä¸ï¼
$username=your_name;
$userpass=your_pass;
$dbhost=localhost;
$dbdatabase=your_database;
//çæä¸ä¸ªè¿æ¥
$db_connect=mysql_connect($dbhost,$username,$userpass) or die("Unable to connect to the MySQL!");
//éæ©ä¸ä¸ªéè¦æä½çæ°æ®åº
mysql_select_db($dbdatabase,$db_connect);
//æ§è¡MySQLè¯å¥
$result=mysql_query("SELECT id,name FROM user");
//æåæ°æ®
$row=mysql_fetch_row($result);
注æäºé¡¹ï¼ä»£ç 注éå·²ç»è¯´æäºä¸åãä¸è¿è¿éè¿éè¦åä¸äºè¡¥å ã
â å¨mysql_connect()ãmysql_select_db()çå½æ°ä¹å使ç¨@ï¼é误æ§å¶è¿ç®ç¬¦ï¼ï¼å¯ä»¥å¿½ç¥æç³»ç»äº§ççé误信æ¯ï¼ç¶åç¨die()æ¥èªå®ä¹é误信æ¯ï¼
â¡æåæ°æ®çæ¶åï¼é¤äºä¸é¢çmysql_fetch_rowï¼å¸¸è§çè¿æmysql_fetch_assocåmysql_fetch_arrayï¼å ·ä½å·®å«è¯·æ¥é PHP Manualï¼
â¢å¯¹äºmysql_query()å½æ°çè¿åå¼ï¼å¦ææ§è¡çè¯å¥æè¿åå¼ï¼å¦SELECTãSHOWãDESCRIBEçï¼ï¼åè¿åç¸åºæ°æ®ï¼æåæ¶ï¼æFALSEï¼å¤±è´¥æ¶ï¼ï¼å¦ææ§è¡çè¯å¥æ²¡æè¿åå¼ï¼å¦DELETEãDROPãINSERTãUPDATEçï¼ï¼åè¿åTRUEï¼æåæ¶ï¼æFALSEï¼å¤±è´¥æ¶ï¼ã
æ¹æ³äºãé¢å对象
å ¶å®è¿ç§æ¹æ³åæ®éæ¹æ³é常类似ï¼åªæ¯æç¸åºçå½æ°æ¢æäºé¢å对象æ¹æ³ï¼ç´æ¥ç代ç ã
$db=new mysqli($dbhost,$username,$userpass,$dbdatabase);
if(mysqli_connect_error()){
echo 'Could not connect to database.';
exit;
}
$result=$db->query("SELECT id,name FROM user");
$row=$result->fetch_row();
è¿éç¨å°çæ¯mysqliï¼ææå°±æ¯mysqlçæ©å±ï¼æ¢å¯ä»¥éè¿é¢åè¿ç¨çæ¹å¼ä¹å¯ä»¥éè¿é¢å对象çæ¹å¼ä¸æ°æ®åºè¿è¡äº¤äºï¼å¯ä¸ä¸åçæ¯è°ç¨å½æ°ï¼å¯¹è±¡æ¹æ³ï¼çæ¹å¼ä¸ä¸æ ·ã
æ¹æ³ä¸ãPDOæ¹æ³
PDOå ¶å®æ¯PHP Database Objectsç缩åï¼ä¸æå³PHPæ°æ®åºå¯¹è±¡ãå®æä¾äºä¸ç§ç»ä¸çPHPä¸æ°æ®åºäº¤äºçæ¹æ³ã
è¿æ¯ç®åæµè¡çä¸ç§è¿æ¥æ°æ®åºçæ¹æ³ãå®çä¼å¿å¨äºï¼åªè¦æ£ç¡®æä¾æ°æ®æºï¼ä½ä¸å¯¹äºæ°æ®åºçåºæ¬æä½é½æ¯ä¸æ ·çãä¹å°±æ¯è¯´ï¼åä¸æ®µä»£ç æ¢å¯ä»¥åMySQL交äºï¼ä¹å¯ä»¥åSQLite3交äºï¼å½ç¶ä¹å¯ä»¥åPostgreSQLè¿è¡äº¤äºï¼åææ¯ä½ æä¾äºæ£ç¡®çæ°æ®æºãä¸é¢çä¸ä¸è¿æ¥MySQLç代ç ï¼
$dsn='mysql:host='.$dbhost.';dbname='.$dbdatabase.';'
$dbh=new PDO($dsn,$username,$userpass);
å¦ææ¯SQLite3ï¼ç´æ¥ä½¿ç¨ä¸é¢ç代ç ï¼
$dsn='sqlite3:"C:\sqlite\user.db"';
$dbh=new PDO($dsn);
å¦ææ¯PostgreSQLï¼ä¸é¢ç代ç è½å¤å¯¹ä»ï¼
$dsn='pgsql:host='.$dbhost.' port=5432 dbname='.$dbdatabase.' user='.$username.' password='.$userpass;
$dbh=new PDO($dsn);
è·æ°æ®åºæå建ç«è¿æ¥ä¹åï¼ä¸é¢å°±åªéè¦ä»æ°æ®åºè·åæ°æ®ææå ¥æ´æ°æ°æ®ï¼å®ä¾ä»£ç å¦ä¸ï¼
$stmt=$dbh->query('SELECT id,name FROM user');
$row=$stmt->fetch();
综ä¸æè¿°æä¸ç§æ¹æ³é¾æ¥mysql
追é®çå ¨è°¢è°¢