本文整理汇总了PHP中pdo::errorInfo方法的典型用法代码示例。如果您正苦于以下问题:PHP pdo::errorInfo方法的具体用法?PHP pdo::errorInfo怎么用?PHP pdo::errorInfo使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类pdo
的用法示例。
在下文中一共展示了pdo::errorInfo方法的3个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: pdo
<?php
$pdo = new pdo("mysql:host=localhost;dbname=ders", "root", "");
$sorgu = $pdo->prepare("select * from ders") or die("Hata: " . $pdo->errorInfo()[2]);
$sorgu->execute();
foreach ($sorgu as $veri) {
echo $veri[1];
}
示例2: pdo
<?php
$db = new pdo('sqlite::memory:');
$db->query('CREATE TABLE IF NOT EXISTS foo (id INT AUTO INCREMENT, name TEXT)');
$db->query('INSERT INTO foo VALUES (NULL, "PHP")');
$db->query('INSERT INTO foo VALUES (NULL, "PHP6")');
var_dump($db->query('SELECT * FROM foo'));
var_dump($db->errorInfo());
var_dump($db->lastInsertId());
$db->query('DROP TABLE foo');
示例3: execute
/**
* Executes sql statement without any return value. Please consider the usage of
* prepared statements which is fully supported.
*
* <code>
* <?php
* dbConn::execute("INSERT INTO :prefix:user (username, registered) VALUES (:0, :1);", 'felix', (new DateTime));
* ?>
*
* @param string $query The query in sql language.
* @param multiple strings The values that will fill the variables in the query.
* @static
*/
public static function execute()
{
$argsCount = func_num_args();
$par = array();
// no query as parameter given
if ($argsCount < 1) {
throw new Exception("No Sql-Query given");
}
// if there are parameters, insert in
if ($argsCount > 1) {
// create array with parameters for pdo usage
for ($i = 1; $i < $argsCount; $i++) {
$key = ":" . ($i - 1);
$par[$key] = func_get_arg($i);
}
}
// insert table prefix
$query = func_get_arg(0);
$query = str_replace(":prefix:", dbConn::$tablePrefix, $query);
// create pdo connection
$db = new pdo("mysql:" . "host=" . dbConn::$host . ";" . "dbname=" . dbConn::$database . ";" . "charset=UTF8", dbConn::$username, dbConn::$password);
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
try {
// prepare and execute
$sth = $db->prepare($query, array(PDO::ATTR_CURSOR => PDO::CURSOR_FWDONLY));
if (!$sth) {
throw new Exception($db->errorInfo());
}
$sth->execute($par);
} catch (Exception $ex) {
throw new Exception($ex->getMessage());
}
// close database connection
$db = null;
}