/** * @return CL_MySQLi */ public static function get_instance() { if (self::$instance === null) { $config = CL_Config::get_instance(); $host = $config->get_value('database', 'host'); $user = $config->get_value('database', 'user'); $password = $config->get_value('database', 'password'); $database = $config->get_value('database', 'database'); self::$instance = new CL_MySQLi($host, $user, $password, $database); } return self::$instance; }
/** * @param int $userId * @param int $nearId * @param int $countryId * @param string $name * @param string $label * @param string $cat * @param string $sub * @param LatLng $latLng * @param Polygon $border * @param string[] $attrs * @return int */ public static function addNew($url, $nearId, $countryId, $userId, $name, $label, $cat, $sub, $latLng, $border, $attrs) { $mysql = CL_MySQLi::get_instance(); $query = insert($mysql)->into('poi_new')->value('url', $url)->value('userId', $userId)->value('countryId', $countryId)->value('nearId', $nearId)->value('name', $name)->value('label', $label)->value('cat', $cat)->value('sub', $sub)->value('lat', $latLng->lat())->value('lng', $latLng->lng())->value('border', $border === NULL ? 'NULL' : $border->toWKT())->op(GEOM_FROM_TEXT)->value('attrs', json_encode($attrs)); $mysql->query($query); return $mysql->insertId(); }