Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- something like that
- function insert_data($con, $tablename, $params){
- try{
- foreach($params as $key=>$value){
- $keys[]="`$key`";
- $values[]=":$key";
- }
- $keys_string= implode(', ', $keys);
- $values_string= implode(', ', $values);
- $qry= "insert into $tablename($keys_string) values ($values_string)";
- $stmt=$con->prepare($qry);
- foreach($params as $key=>$value){
- $stmt->bindparam(":$key", $value);
- }
- $stmt->execute();
- return $con->lastInsertId();
- }catch Exception($e){
- echo $e->getMessage();
- throw($e);
- }
- }
- $tablename='clientz';
- $params['name']='Miro';
- $params['addrezz']='NY NY';
- $params['mail']='miro@example.com';
- $params['registered']=date("Y-m-d H:i:s");
- insert_data($con, $tablename, $params);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement