<?php
/*
How PHP connects to MySQL
*/
/* $link = mysql_connect (' localhost ', ' root ', ');
if (! $link) {
Die (' Could not connect: '. Mysql_error ());
}
Echo ' Connected successfully ';
Mysql_close ($link); * *
/*php How to select a database */
/* $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 how to execute a MySQL query */
/* $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 How to get the queried data */
$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", $link);
while ($doc = Mysql_fetch_array ($query, $link)) {
$doclist [] = $doc;
}
Var_dump ($doclist);
Mysql_close ($link);
/*php performing database read/write separation */
$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", $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 read-write separate PHP script