本文整理匯總了PHP中Zend_Db_Adapter_Pdo_Mysql::prepare方法的典型用法代碼示例。如果您正苦於以下問題:PHP Zend_Db_Adapter_Pdo_Mysql::prepare方法的具體用法?PHP Zend_Db_Adapter_Pdo_Mysql::prepare怎麽用?PHP Zend_Db_Adapter_Pdo_Mysql::prepare使用的例子?那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類Zend_Db_Adapter_Pdo_Mysql
的用法示例。
在下文中一共展示了Zend_Db_Adapter_Pdo_Mysql::prepare方法的2個代碼示例,這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚,您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: get_elements_private_status_by_value
private function get_elements_private_status_by_value($search_string, $element_name = "Title", $collection_id = 4)
{
$db = get_db();
$config = $db->getAdapter()->getConfig();
$db_hack = new Zend_Db_Adapter_Pdo_Mysql(array('host' => $config["host"], 'username' => $config["username"], 'password' => $config["password"], 'dbname' => $config["dbname"]));
if (!$db->getConnection()) {
_log("__CONNECTION ROTTEN IN get_elements_private_status_by_value");
return false;
}
$sql = self::illegal_sql_generator($search_string, false, $element_name, $collection_id);
$stmt = $db_hack->prepare($sql);
$stmt->execute();
$itemId = $stmt->fetch();
if ($itemId) {
if (array_key_exists("id", $itemId)) {
$sql2 = self::illegal_sql_generator(false, $itemId["id"], "Privacy Required", $collection_id);
$stmt = $db_hack->prepare($sql2);
$stmt->execute();
$item = $stmt->fetch();
if ($item) {
if (array_key_exists("text", $item)) {
if ($item["text"] == "ja") {
return true;
}
}
}
}
}
return false;
}
示例2: _getMysqlColumns
private function _getMysqlColumns($tsql, Zend_Db_Adapter_Pdo_Mysql $dbh)
{
$sth = $dbh->prepare($tsql);
$sth->execute();
$colcount = $sth->columnCount();
for ($i = 0; $i < $colcount; $i++) {
$coll = $sth->getColumnMeta($i);
$cols[] = $coll['name'];
}
//print_r($cols);
return $cols;
}