本文整理匯總了PHP中Pool::getTableprefix方法的典型用法代碼示例。如果您正苦於以下問題：PHP Pool::getTableprefix方法的具體用法？PHP Pool::getTableprefix怎麽用？PHP Pool::getTableprefix使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類Pool的用法示例。
在下文中一共展示了Pool::getTableprefix方法的1個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: resolveAttributes
/**
* Resolve a files extended attributes
*
* @access public
*
* @param $retval file extended attributes
*/
public static function resolveAttributes(&$retval)
{
Log::in("query - resolveAtributes");
/* For printing via modxfs-getfattr for instance we need to
* resolve things like user number to a name, template id to
* a name, dates into strings etc.
* We are only using select statements here, if a query fails
* just leave the attribute alone and move on.
*/
$dbConn = Pool::get();
$prefix = Pool::getTableprefix();
foreach ($retval as $key => &$value) {
switch ($key) {
case 'editedon':
case 'createdon':
case 'pub_date':
case 'unpub_date':
case 'deletedon':
case 'publishedon':
$value = strftime("%G-%m-%j %H:%M:%S", $value);
break;
case 'parent':
$sql = "SELECT pagetitle";
$sql .= " FROM `{$prefix}" . "site_content`";
$sql .= " WHERE id = {$value}";
$result = mysql_query($sql, $dbConn);
if ($result !== false) {
$row = mysql_fetch_assoc($result);
if ($row['pagetitle'] != "") {
$value = $row['pagetitle'];
}
}
break;
case 'template':
$sql = "SELECT templatename";
$sql .= " FROM `{$prefix}" . "site_templates`";
$sql .= " WHERE id = {$value}";
$result = mysql_query($sql, $dbConn);
if ($result !== false) {
$row = mysql_fetch_assoc($result);
if ($row['templatename'] != "") {
$value = $row['templatename'];
}
}
break;
case 'editedby':
case 'deletedby':
case 'publishedby':
case 'createdby':
/* Only manager users here */
$sql = "SELECT username";
$sql .= " FROM `{$prefix}" . "manager_users`";
$sql .= " WHERE id = {$value}";
$result = mysql_query($sql, $dbConn);
if ($result !== false) {
$row = mysql_fetch_assoc($result);
if ($row['username'] != "") {
$value = $row['username'];
}
}
break;
default:
break;
}
}
Pool::release($dbConn);
Log::out("query - resolveAtributes");
}