Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- //connect.php
- $dsn = "mysql:dbname=test";
- $host = "localhost";
- $user = "test";
- $pass = "";
- try {
- $conn = new PDO($dsn, $user, $pass);
- } catch (PDOException $e) {
- echo "Koneksi ke database gagal: ".$e->getMessage();
- }
- //simpan.php
- include 'connect.php';
- if (isset($_POST)) {
- //cek dulu email udah ada atau belum di database
- $sql = 'SELECT COUNT(*) jumlah_user FROM tabel_biodata WHERE email=:email';
- $sth = $conn->prepare($sql, array(PDO::ATTR_CURSOR => PDO::CURSOR_FWDONLY));
- $sth->execute(array(':email' => $_POST[email]));
- $row = $sth->fetch(PDO::FETCH_ASSOC);
- if ( $row['jumlah_user] > 0 ) {
- //artinya email udah ada, silahkan tampilkan pesan error
- }
- else {
- //hanya insert jika email belum ada!!!
- $st = $conn->prepare('INSERT INTO tabel_biodata ( noreg, nama, email, jenis_kelamin, nm_perusahaan, alamat, tlp, no_hp, hadir, photo ) VALUES( :noreg, :nama, :email, :jenis_kelamin, :nm_perusahaan, :alamat, :tlp, :no_hp, :hadir, :photo )';
- $result = $st->execute( array(
- ':noreg' => $_POST['noreg'],
- ':nama' => $_POST['nama'],
- ':email' => $_POST['email'],
- ':jenis_kelamin' => $_POST['jenis'],
- ':nm_perusahaan' => $_POST['nm'],
- ':alamat' => $_POST['alamat'],
- ':tlp' => $_POST['tlp'],
- ':no_hp' => $_POST['no'],
- ':hadir' => $_POST['hadir'],
- ':photo' => $_POST['photo'],
- ) );
- //tampilkan pesan sukses atau gagal
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement