public function getMigrates($isUp = null) { $where = !is_null($isUp) ? " where isUp = {$isUp} " : null; $migrateRes = $this->db->select("select * from migration {$where} order by id asc"); $migrates = []; if ($migrateRes->rowCount() > 0) { while ($migrate = $migrateRes->nextObject()) { array_push($migrates, $migrate->name); } } return $migrates; }
/** * @param bmMySQLLink $db * @param $queryString * @param null $key * @param null $value * * @return array */ public static function queryToArray($db, $queryString, $key = null, $value = null) { $dbResult = $db->select($queryString); $arr = array(); while ($res = $dbResult->nextHash()) { if ($value === null) { if ($key === null) { $arr[] = $res; } else { $arr[$res[$key]] = $res; } } else { if ($key === null) { $arr[] = $res[$value]; } else { $arr[$res[$key]] = $res[$value]; } } } return $arr; }