コード例 #1
0
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;
}
コード例 #2
0
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);
}