MySQL Tutorial database Tutorial Connection Classes
/*
Provide a simple and practical MySQL PHP Tutorial database connection Code Oh, if you are a PHP starter can come in and see if this database code is what you are looking for.
*/
Class mysql{
Private $host;
Private $user;
Private $pass;
Private $dbname;
function __construct ($host, $user, $pass, $dbname) {
$this->host= $host;
$this->user= $user;
$this->pass= $pass;
$this->dbname= $dbname;
$this->connect ();
}
function Connect () {
$link =mysql_connect ($this->host, $this->user, $this->pass) or Die (Mysql_error ());
if (mysql_select_db ($this->dbname, $link)) {
echo "Connected successfully";
}else{
echo "Failed";
}
mysql_query ("Set names UTF8");
}
function query ($sql) {
$run =mysql_query ($sql);
return $run;
}
function Fn_insert ($biaoming, $zdname, $value) {
$this->query ("INSERT into $biaoming ($zdname) VALUES ($value)");
}
}
This database connection class calls the method
$db =new mysql (' localhost ', ' root ', ' ', ' test ');
$sql = "SELECT * from BB";
$query = $db->query ($sql);
while ($rs = Mysql_fetch_array ($query))
{
echo ' ... ';
}
and use this class to save the data.
$db->fn_insert (' Test ', ' names ', ' 111cn.net ');