Mysql读写分离php脚本

<?php
/*
php如何连接mysql
*/

/*$link = mysql_connect(‘localhost‘, ‘root‘, ‘‘);
if (!$link) {
die(‘Could not connect: ‘ . mysql_error());
}
echo ‘Connected successfully‘;
mysql_close($link);*/

/*php如何选择数据库*/
/*$link = mysql_connect(‘localhost‘, ‘root‘, ‘‘);
if (!$link) {
die(‘Could not connect: ‘ . mysql_error());
}

$selectdb = mysql_select_db(‘wiki‘, $link);
var_dump($selectdb);
mysql_close($link);*/

/*php如何执行mysql的查询*/
/*$link = mysql_connect(‘localhost‘, ‘root‘, ‘‘);
if (!$link) {
die(‘Could not connect: ‘ . mysql_error());
}

$selectdb = mysql_select_db(‘wiki‘, $link);
$query = mysql_query("select title from wiki_doc limit 1",$link);
var_dump($query);
mysql_close($link);*/

/*php如何获取查询到的数据*/
$link = mysql_connect(‘localhost‘, ‘root‘, ‘‘);
if (!$link) {
die(‘Could not connect: ‘ . mysql_error());
}
//mysql_query("set names utf8");
$selectdb = mysql_select_db(‘wiki‘, $link);
$query = mysql_query("select title from wiki_doc limit 10",$link);
while($doc = mysql_fetch_array($query,$link)){
$doclist[] = $doc;
}
var_dump($doclist);
mysql_close($link);

/*php执行数据库读写分离*/
$readlink = mysql_connect(‘localhost‘, ‘root‘, ‘‘);
//mysql_query("set names utf8");
$readdb = mysql_select_db(‘wiki‘, $readlink);
$readquery = mysql_query("select title from wiki_doc limit 10",$readlink);
while($doc = mysql_fetch_array($readquery,$readlink)){
$doclist[] = $doc;
}
var_dump($doclist);

$writelink = mysql_connect(‘localhost‘, ‘root‘, ‘‘);
//mysql_query("set names utf8");
$writedb = mysql_select_db(‘wiki‘, $writelink);
$writequery = mysql_query(" update wiki_doc set title=‘124‘ where did=45",$writelink);

var_dump($doclist);

?>

Mysql读写分离php脚本

标签：while   from   数据   success   erro   read   sel   php脚本   query