$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; }