本文整理匯總了PHP中Zend_Db_Adapter_Pdo_Mysql::fetchRow方法的典型用法代碼示例。如果您正苦於以下問題:PHP Zend_Db_Adapter_Pdo_Mysql::fetchRow方法的具體用法?PHP Zend_Db_Adapter_Pdo_Mysql::fetchRow怎麽用?PHP Zend_Db_Adapter_Pdo_Mysql::fetchRow使用的例子?那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類Zend_Db_Adapter_Pdo_Mysql
的用法示例。
在下文中一共展示了Zend_Db_Adapter_Pdo_Mysql::fetchRow方法的2個代碼示例,這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚,您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: getImageById
/**
* Pega a Image por id
*
* @return array
*/
public function getImageById($id)
{
$db = new Zend_Db_Adapter_Pdo_Mysql(array('host' => 'localhost', 'username' => 'root', 'password' => '', 'dbname' => 'painelpadrao_imagem'));
$sql = "SELECT * FROM imagem WHERE id_avatar = " . $id;
$dados = $db->fetchRow($sql);
$dados["arquivo_base64"] = base64_encode($dados["arquivo"]);
$dados["arquivo"] = "";
return $dados;
}
示例2: exec
exec("cp " . $pimcoreRoot . "/tests/config/system.xml " . $documentRoot . "/website/var/config/system.xml");
}
// startup the phpunit_pimcore
include_once $documentRoot . "/pimcore/config/startup.php";
set_include_path(get_include_path() . PATH_SEPARATOR . $includePathBak);
@ini_set("display_errors", "On");
@ini_set("display_startup_errors", "On");
Pimcore::setSystemRequirements();
Pimcore::initAutoloader();
if (!$skipInstall) {
// setup the database for the phpunit_pimcore
try {
$db = new Zend_Db_Adapter_Pdo_Mysql($dbConfig);
$db->getConnection();
// check utf-8 encoding
$result = $db->fetchRow('SHOW VARIABLES LIKE "character\\_set\\_database"');
if ($result['Value'] != "utf8") {
die("Database charset is not utf-8");
}
} catch (Exception $e) {
echo $e->getMessage() . "\n";
die("Couldn't establish connection to mysql" . "\n");
}
$db->getConnection()->exec("DROP database IF EXISTS pimcore_phpunit;");
$db->getConnection()->exec("CREATE DATABASE pimcore_phpunit CHARACTER SET utf8");
$db = new Zend_Db_Adapter_Pdo_Mysql($dbConfig);
$db->getConnection();
$db->getConnection()->exec("SET NAMES UTF8");
$db->getConnection()->exec("SET storage_engine=InnoDB;");
// insert db dump
//$db = Pimcore_Resource::get();