本文整理汇总了PHP中PearDatabase::fetch_row方法的典型用法代码示例。如果您正苦于以下问题：PHP PearDatabase::fetch_row方法的具体用法？PHP PearDatabase::fetch_row怎么用？PHP PearDatabase::fetch_row使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类PearDatabase的用法示例。
在下文中一共展示了PearDatabase::fetch_row方法的1个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: selectCityStateAndRegion
/**
* Add state and region to city container.
*
* @param array $currentCity - description of city name, socr and code
* @param PearDatabase $db
*/
private function selectCityStateAndRegion(&$currentCity, $db)
{
/* Get lelvel 1 location for current entity of level 3-4 */
$firstLevelLocationCode = substr($currentCity["cityCode"], 0, 2) . "00000000000";
$firstLevelLocationResult = $db->pquery("select name, socr FROM sp_kladr WHERE code=?", array($firstLevelLocationCode));
if ($firstLevelLocationRow = $db->fetch_row($firstLevelLocationResult)) {
$currentCity["stateName"] = $firstLevelLocationRow["name"];
$currentCity["stateSocr"] = $firstLevelLocationRow["socr"];
}
/* Get lelvel 2 location for current entity of level 3-4 */
$currentCity["regionName"] = "";
$currentCity["regionSocr"] = "";
$secondLevelLocationCode = substr($currentCity["cityCode"], 0, 5) . "00000000";
$secondLevelLocationResult = $db->pquery("select name, socr FROM sp_kladr WHERE code=? " . "AND socr IN (select scname FROM sp_kladr_socrbase WHERE level=2)", array($secondLevelLocationCode));
if ($secondLevelLocationRow = $db->fetch_row($secondLevelLocationResult)) {
$currentCity["regionName"] = $secondLevelLocationRow["name"];
$currentCity["regionSocr"] = $secondLevelLocationRow["socr"];
}
}