function do_insert($data, $table, $opt = false) { global $conn; $fields = ''; //fields $rows2insert = ''; //fields to insert $fields_sqlCond = ''; //where if (!is_array(reset($data))) { $data = array($data); } //aschronize to multi rows foreach ($data as $row) { $sqls = fields_sql($row); //filter fields into sql data if (!$fields) { $fields = $sqls['fields']; } //get fields if (!$fields_sqlCond) { $fields_sqlCond = $sqls['fields_sqlCond']; } $rows2insert .= '(' . $sqls['fields_sql2insert'] . '),'; //multi rows } $rows2insert = substr($rows2insert, 0, strlen($rows2insert) - 1); //pure $query_insert = 'INSERT INTO ' . $table . '(' . $fields . ') VALUES' . $rows2insert; //var_dump( $query_insert); $rs = mysql_query($query_insert, $conn); if ($opt == true) { $recent_post = mysql_query('SELECT * FROM ' . $table . ' WHERE ' . $fields_sqlCond, $conn); //get recent user that registry return mysql_fetch_array($recent_post); //return this user } return $rs; }
function get_news($id = '', $opts = array()) { global $conn; $where = ''; //filter if (is_numeric($id)) { $where .= (preg_match('#where#', $where) ? ' and ' : ' where ') . 'id="' . $id . '"'; } if (is_array($id)) { $filter = fields_sql($id); if ($filter['fields_sqlCond']) { $where .= (preg_match('#where#', $where) ? ' and ' : ' where ') . $filter['fields_sqlCond']; } } $sql = 'select vcn_news.*,(case when DATEDIFF(DATE_FORMAT(NOW(),"%Y-%m-%d"),post_time)<5 then "*" else "" end) as is_new from vcn_news ' . $where; if (isset($opts['order'])) { $sql .= ' order by ' . $opts['order']; } else { $sql .= ' order by id DESC'; } if (isset($opts['limit'])) { $sql .= ' limit ' . $opts['limit']; } $sql = sql_totalresults_var($sql); //echo $sql; return mysql_query($sql); }