Esempio n. 1
0
<?php

try {
    $pdo = new PDO("mysql:host=127.0.0.1;dbname=tips", "root", "123456");
} catch (Exception $e) {
    var_dump($e);
}
if ($pdo->exec("insert into news(title,slug,text) values('title','test','content')")) {
    echo "插入成功!";
    echo $pdo->lastinsertid();
}
Esempio n. 2
0
<?php

$dbn = new PDO('mysql:host=192.168.1.199;dbname=test;', 'test', 'secret');
$dbn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$dbn->exec('set names utf8');
$sql = 'insert into users(username,email) values(:username,:email)';
$stmt = $dbn->prepare($sql);
$stmt->execute(array(':username' => 'wangzhongwei', ':email' => '*****@*****.**'));
echo $dbn->lastinsertid();