本文整理匯總了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"];
}
}