Exemple #1
0
        $fields = '';
        $values = '';
        $sql = '';
        $comma = '';
        $round = 0;
        foreach ($phpArray as $key => $value) {
            $comma = ',';
            if ($round == $sizeOfArray) {
                $comma = '';
            }
            $fields .= $key . '' . $comma;
            $values .= '\'' . trim($value) . '\'' . $comma;
            $round++;
        }
        $sql = 'insert into ' . $table . ' (id,' . $fields . ',date) values (NULL,' . $values . ',NOW());';
        return parent::query($sql, $rows, $num_rows, $last_id);
    }
    public function get()
    {
        $sql = 'select * from research where 1;';
        parent::query($sql, $rows, $num_rows, $last_id);
        print_r($rows);
    }
}
$rs = new Research();
$result = $rs->set($json, 'research');
if ($result === true) {
    echo "success";
} else {
    echo $result;
}