AutoCAD 3DMAX C语言 Pro/E UG JAVA编程 PHP编程 Maya动画 Matlab应用 Android
Photoshop Word Excel flash VB编程 VC编程 Coreldraw SolidWorks A Designer Unity3D
 首页 > PHP编程

PHP实现的Mysql读写分离

51自学网 2016-09-17 http://www.wanshiok.com

example.php
<?php/******************************************* mysql-rw-php version 0.1 @ 2009-4-16*** code by hqlulu#gmail.com*** http://www.aslibra.com*** http://code.google.com/p/mysql-rw-php/*** code modify from class_mysql.php (uchome)****************************************/require_once(’mysql_rw_php.class.php’);//rw info$db_rw = array(  ‘dbhost’=>’www.aslibra.com’,  ‘dbuser’=>’aslibra’,  ‘dbpw’=>’www.aslibra.com’,  ‘dbname’=>’test’);$db_ro = array(  array(    ‘dbhost’=>’www.aslibra.com:4306′,    ‘dbuser’=>’aslibra’,    ‘dbpw’=>’www.aslibra.com’  ));$DB = new mysql_rw_php;//connect Master$DB->connect($db_rw[dbhost], $db_rw[dbuser], $db_rw[dbpw], $db_rw[dbname]);//Method 1: connect one server$DB->connect_ro($db_ro[0][dbhost], $db_ro[0][dbuser], $db_ro[0][dbpw]);//Method 2: connect one server from a list by rand$DB->set_ro_list($db_ro);//send to rw$sql = “insert into a set a=’test’”;$DB->query($sql);//send to ro$sql = “select * from a”;$qr = $DB->query($sql);while($row = $DB->fetch_array($qr)){  echo $row[a];}?>


说明
:本教程来源互联网或网友上传或出版商,仅为学习研究或媒体推广,wanshiok.com不保证资料的完整性。
 
上一篇:php json_encode 中文 utf-8 乱码  下一篇:PHP安全之错误报告