Advertisement
Guest User

Untitled

a guest
Sep 3rd, 2018
257
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.26 KB | None | 0 0
  1. <?php
  2. $table = 'users';
  3.  
  4. $_POST['email'] = "aaaa@gmail.com";
  5. $_POST['nama'] = "dsadad";
  6. $_POST['password'] = "4324";
  7. $_POST['jenis_kelamin'] = "L";
  8. $_POST['tanggal_lahir'] = "2018-01-01";
  9. $_POST['alamat'] = "indonesia";
  10.  
  11. $data = $_POST;
  12.  
  13. $host = '127.0.0.1';
  14. $db = 'test';
  15. $user = 'root';
  16. $pass = '';
  17. $charset = 'utf8mb4';
  18.  
  19. $dsn = "mysql:host=$host;dbname=$db;charset=$charset";
  20. $opt = [
  21. PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
  22. PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
  23. PDO::ATTR_EMULATE_PREPARES => false,
  24. ];
  25. try {
  26. $pdo = new PDO($dsn, $user, $pass, $opt);
  27. $fieldName = implode(", ", array_keys($data));
  28. $prepsValue = ":".implode(", :", array_keys($data));
  29.  
  30. $query = "INSERT INTO {$table} ($fieldName) VALUES ($prepsValue)";
  31. $stmt = $pdo->prepare($query);
  32.  
  33. $explodePreps = explode(", ", $prepsValue);
  34. $datas = array_combine($explodePreps, $data);
  35.  
  36. foreach ($datas as $key => $value) {
  37. $stmt->bindValue($key, $value , PDO::PARAM_STR);
  38. }
  39.  
  40. //exit;
  41.  
  42. $executes = $stmt->execute();
  43.  
  44. //$this->checkExecutes($executes);
  45.  
  46. } catch (\PDOException $e) {
  47. throw new \PDOException($e->getMessage(), (int)$e->getCode());
  48. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement