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