<?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(); }
<?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();