function convert_datetime_to_vn($date_time_us) { $p = explode(' ', $date_time_us); if (count($p) != 2) { return NULL; } return convert_date_to_vn($p[0]) . ' ' . $p[1]; }
public function findRelated($promo_date, $seo_url) { $sql = 'SELECT seo_url, subject, promo_date FROM promos WHERE promo_date <= ? AND seo_url <> ? ' . 'ORDER BY promo_date DESC LIMIT 0, 10'; $ps = new PreparedStatement($sql); $ps->setString(1, $this->ds->escape(convert_date_to_us($promo_date))); $ps->setString(2, $this->ds->escape($seo_url)); $rs = $this->ds->execute($ps->getSql()); $list_promo = array(); while ($row = mysql_fetch_array($rs)) { $list_promo[] = array('seo_url' => $row['seo_url'], 'promo_date' => convert_date_to_vn($row['promo_date']), 'subject' => htmlspecialchars($row['subject'])); } mysql_free_result($rs); return $list_promo; }
function findByAll() { $sql = 'SELECT P.id, full_name, birthday, P.phone, ' . '(SELECT name FROM cities AS Q WHERE Q.id = P.city_id) AS city_name ' . 'FROM customers AS P ' . 'ORDER BY P.id'; $rs = $this->ds->execute($sql); $list_cust = array(); while ($row = mysql_fetch_array($rs)) { $id = (int) $row['id']; $list_cust[$id] = array('full_name' => htmlspecialchars($row['full_name']), 'birthday' => convert_date_to_vn($row['birthday']), 'city_name' => htmlspecialchars($row['city_name']), 'phone' => htmlspecialchars($row['phone'])); } mysql_free_result($rs); return $list_cust; }