PHP连接MySQL数据库

普通方式

$connect = mysqli_connect('host', 'username', 'password', 'dbname', 'port');

mysqli_query($connect, 'SET NAMES UTF8');

$result = mysqli_query($connect, $sql);

mysqli_close($connect);

面向对象

$mysqli = new mysqli('host', 'username', 'password', 'dbname', 'port');

if(mysqli_connect_error()) {

    echo 'Could not connect to database';

    exit;

}

$mysqli -> query('set names utf8');

$mysqli -> query($sql);

$mysqli -> close();

PDO

try

{

    $dsn='mysql:host='.$host.';dbname='.$dbname.';'

    $pdos=new PDO($dsn, $username, $password); 

}catch(PDOException $e) {

    echo $e->getMessage();

}

$stmt=$pdos->query($sql);

$row=$stmt->fetch();