crud-oop

// edit.php

<?php
include_once 'class.php';
$db = new Connections(); // instansiasi obj
$db->OpenConnection(); // get connection
$getData = new dataDiri();
$id = isset( $_GET['id_usr'] ) ? mysql_real_escape_string( $_GET['id_usr'] ) : NULL;
?>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
    <table>
        <tr>
            <td>Nama</td>
            <td>:</td>
            <td><input type="text" value="<?php echo$getData->edit_data( 'nama', $id ); ?>"></td>
        </tr>
        <tr>
            <td>Email</td>
            <td>:</td>
            <td><input type="text" value="<?php echo$getData->edit_data( 'email', $id ); ?>"></td>
        </tr>
        <tr>
            <td>No. Telepon</td>
            <td>:</td>
            <td><input type="text" value="<?php echo$getData->edit_data( 'telp', $id ); ?>"></td>
        </tr>
        <tr>
            <td>Username</td>
            <td>:</td>
            <td><input type="text" value="<?php echo$getData->edit_data( 'username', $id ); ?>"></td>
        </tr>
        <tr>
            <td>Password</td>
            <td>:</td>
            <td><input type="text" value="<?php echo$getData->edit_data( 'password', $id ); ?>"></td>
        </tr>
        <tr>
            <td></td>
            <td></td>
            <td></td>
        </tr>
    </table>
</form>

<?php
// UPDATE DATA
// $getData->update_data( $_POST['nama'], );
?>


// class.php

<?php

class Connections {
    private $conn;
    private $db_host = 'localhost';
    private $db_user = 'root';
    private $db_pswd = '';
    private $db_name = 'lat_crud';

    function OpenConnection() {
        $this->conn = mysql_connect( $this->db_host, $this->db_user, $this->db_pswd ) or die ( "fuck". mysql_error() );
        if ( $this->conn ) {
            mysql_select_db( $this->db_name );
        } else {
            die( "Connection problem !". mysql_error() );
        }
    }
} // END: Class Connections


class DataDiri {
    function insert_data( $nama, $email, $telp, $username, $password ) {
        $sql = "INSERT INTO data_diri( nama, email, telp, username, password )
                VALUES ( '$nama', '$email', '$telp', '$username', '$password' )";
        $query = mysql_query( $sql );
        return $query;
    }

    function display_data() {
        $data = '';
        $sql = mysql_query( "SELECT * FROM data_diri" );
        while ( $row = mysql_fetch_assoc( $sql ) ) {
            $data[] = $row;
        }
        return $data;
    }

    function edit_data( $field, $id_usr ) {
        $sql = mysql_query( "SELECT * FROM data_diri WHERE id_user = '$id_usr'" );
        $data = mysql_fetch_assoc( $sql );
        if ( $field == 'nama' ) return $data['nama'];
        elseif ( $field == 'email ') return $data['email'];
        elseif ( $field == 'telp ') return $data['telp'];
        elseif ( $field == 'username ') return $data['username'];
        elseif ( $field == 'password ') return $data['password'];
    }

    function update_data() {

    }

    function delete_data( $id ) {
        $sql = mysql_query( "DELETE FROM data_diri WHERE id_user = '$id'" );
        return $sql;
    }

} // END: Class DataDiri

?>





// index.php

<?php
include_once 'class.php';

$db = new Connections(); // instansiasi obj
$db->OpenConnection(); // get connection
?>

<form action="" method="post">
    <table>
        <tr>
            <td></td>
            <td></td>
            <td><input type="text" name="nama" placeholder="Nama"></td>
        </tr>
        <tr>
            <td></td>
            <td></td>
            <td><input type="email" name="email" placeholder="Email"></td>
        </tr>
        <tr>
            <td></td>
            <td></td>
            <td><input type="text" name="telp" placeholder="No Telp"></td>
        </tr>
        <tr>
            <td></td>
            <td></td>
            <td><input type="text" name="username" placeholder="Username"></td>
        </tr>
        <tr>
            <td></td>
            <td></td>
            <td><input type="password" name="password" placeholder="Password"></td>
        </tr>
        <tr>
            <td></td>
            <td></td>
            <td><input type="submit" name="btn-save" value="save"></td>
        </tr>
    </table>
</form>

<br>
<table>
    <tr>
        <td>No</td>
        <td>Nama</td>
        <td>Email</td>
        <td>No. Telepon</td>
        <td>Username</td>
        <td>Password</td>
        <td colspan="2">Aksi</td>
    </tr>
    <?php
    $dt = new DataDiri();
    $display_data = $dt->display_data();
    $no = 1;
    if ( ! empty( $display_data ) ) :
        foreach ( $display_data as $row ) :
    ?>
            <tr>
                <td><?= $no; ?></td>
                <td><?= $row['nama']; ?></td>
                <td><?= $row['email']; ?></td>
                <td><?= $row['telp']; ?></td>
                <td><?= $row['username']; ?></td>
                <td><?= '**********'; ?></td>
                <td><a href="edit-data.php?id_usr=<?php echo $row['id_user']; ?>">Edit</a></td>
                <td><a href="">Hapus</a></td>
            </tr>
            <?php  $no++;
        endforeach;
    else :
        echo 'Tidak ada data.';
    endif;
    ?>
</table>

<?php
if ( isset( $_POST['btn-save'] ) ) {
    $nama = $_POST['nama'];
    $email = $_POST['email'];
    $telp = $_POST['telp'];
    $username = $_POST['username'];
    $password = md5( $_POST['password'] );

    if ( empty( $nama ) || empty( $email ) || empty( $telp ) || empty( $username ) || empty( $password ) ) {
        echo "<script>alert( 'Data tidak boleh kosong !' ); window.location.href='./';</script>";
    } else {
        $insert = new DataDiri(); // instansiasi
        $insert->insert_data( $nama, $email, $telp, $username, $password );

        echo "<script>alert( 'Data berhasil disimpan !' ); window.location.href='./';</script>";
    }
}