Advertisement
Guest User

pg_query_params

a guest
Dec 16th, 2022
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.75 KB | None | 0 0
  1. function insert($POST)
  2.     {
  3.         $table = pg_escape_identifier($this->db, $POST["table"]);
  4.         unset($POST["table"]);
  5.         $values = "";
  6.         $columns = "";
  7.         foreach ($POST as $column => $value) {
  8.             $values .= pg_escape_literal($this->db, $value) . ",";
  9.             $columns .= pg_escape_identifier($this->db, $column) . ",";
  10.         }
  11.         $values = substr($values, 0, -1);
  12.         $columns = substr($columns, 0, -1);
  13.         $sql = 'INSERT INTO $1($2) VALUES($3)';
  14.         //return array($table, $columns, $values);
  15.         return pg_query_params($this->db, $sql, array($table, $columns, $values));
  16.         //return pg_query($this->db, "INSERT INTO " . $table . "(" . $columns . ") VALUES(" . $values . ")");
  17.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement