MySQL在PHP上连接 [英] MySQL connect on PHP
本文介绍了MySQL在PHP上连接的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
在MySQL上连接PHP应用程序的最佳方法是什么.
what is the best way to connect PHP application on MySQL.
到目前为止,我具有以下连接类.
So far I had the below connection classes.
class Connection{
private static $server = "127.0.0.1";
private static $catalog = "schemadb";
private static $username = "rootuser";
private static $password = "password";
public static $current = null;
public static function Open(){
self::$current = mysqli_init();
if(!self::$current){
die("Failed to initialize connection");
}
if(!self::$current->real_connect(self::$server,self::$username,self::$password,self::$catalog)){
die("Cannot connect to server");
}
return self::$current;
}
public static function Close(){
self::$current->close();
}
}
我也有
abstract class abstractDAO
{
protected function getConnection()
{
$mysqli = new mysqli("127.0.0.1","rootuser","password","schemadb");
return $mysqli;
}
}
,或者是否还有其他最佳方法可以在MySQL上连接PHP应用程序.请告知谢谢.
or if there's any other best approach to connect PHP application on MySQL. Please advise thanks..
推荐答案
您可以尝试使用PDO对象:
You can try using the PDO object:
<?php
try {
$dbh = new PDO('mysql:host=localhost;dbname=test', $user, $pass);
} catch (PDOException $e) {
print "Error!: " . $e->getMessage() . "<br/>";
die();
}
?>
看看 PHP PDO文档页面
这篇关于MySQL在PHP上连接的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文