Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $table = 'users';
- $_POST['email'] = "aaaa@gmail.com";
- $_POST['nama'] = "dsadad";
- $_POST['password'] = "4324";
- $_POST['jenis_kelamin'] = "L";
- $_POST['tanggal_lahir'] = "2018-01-01";
- $_POST['alamat'] = "indonesia";
- $data = $_POST;
- $host = '127.0.0.1';
- $db = 'test';
- $user = 'root';
- $pass = '';
- $charset = 'utf8mb4';
- $dsn = "mysql:host=$host;dbname=$db;charset=$charset";
- $opt = [
- PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
- PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
- PDO::ATTR_EMULATE_PREPARES => false,
- ];
- try {
- $pdo = new PDO($dsn, $user, $pass, $opt);
- $fieldName = implode(", ", array_keys($data));
- $prepsValue = ":".implode(", :", array_keys($data));
- $query = "INSERT INTO {$table} ($fieldName) VALUES ($prepsValue)";
- $stmt = $pdo->prepare($query);
- $explodePreps = explode(", ", $prepsValue);
- $datas = array_combine($explodePreps, $data);
- foreach ($datas as $key => $value) {
- $stmt->bindValue($key, $value , PDO::PARAM_STR);
- }
- //exit;
- $executes = $stmt->execute();
- //$this->checkExecutes($executes);
- } catch (\PDOException $e) {
- throw new \PDOException($e->getMessage(), (int)$e->getCode());
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement