本文整理汇总了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();