Tutorial || HOW TO MAKE CRUD WITH PHP MYSQL USING INPUT DATA METHOD...

What Will I Learn?

We will learn how to make crud
We will learn how to input manual data
We will study the working system of the crud input with the method of inputting data.

Requirements

Xampp
Sublime text (text editor)
Aplikasi browser

Difficulty

Intermediate

Tutorial Contents

C (Create): which means to create a new data, for example we are doing the registration disebuah web that already constitute Create from CRUD because we make and save registration data to database.

R (Read): Read or display a data that was located in MySQL database for example, then displayed in WEB using Php .

U programming language (Update): well for this one process is editing a data from database which then edited using Php programming language in the form of WEB. Example edit facebook profile.

D (Delete): Surely you know what function is not it? Its function is almost the same as Update but this process is to do the deletion of data in the database through Php language. Examples on a blog sometimes have comments, then we delete the comment, well it includes the delete process in CRUD.

CRUD is often used in data processing applications that most mengguanakan CRUD functions therein. This function is used to add data, delete data, and update data.

Getting Started.

Create a data base with the name "crud".

Kemuadian create table with "user"

And then create 4 colom in User Table (id, nama, alamat , pekerjaan)

then we create a tamplate for the data input page

index.php

"
< !DOCTYPE html>

< html>

< head>

< title>How To Make CRUD With PHP And MySQL - Displays data from database< /title>

< link rel="stylesheet" type="text/css" href="style.css">

< /head>

< body>
< div class="judul">
< h1>Make CRUD With PHP And MySQL< /h1>
< h2>Displays data from database< /h2>

< /div>
< br/>

< ?php 
if(isset($_GET['pesan'])){
    $pesan = $_GET['pesan'];
    if($pesan == "input"){
        echo "Data berhasil di input.";
    }else if($pesan == "update"){
        echo "Data berhasil di update.";
    }else if($pesan == "hapus"){
        echo "Data berhasil di hapus.";
    }
}
? >
< br/>
< a  class="tombol" href="input.php">+ Tambah Data Baru</a>

< h3>Data user</h3>
< table border="1" class="table">
    < tr>
        < th>No</th>
        < th>Nama</th>
        < th>Alamat</th>
        < th>Pekerjaan</th>
        < th>Opsi</th>      
    < /tr>
    < ?php 
    include "koneksi.php";
    $query_mysql = mysql_query("SELECT * FROM user")or die(mysql_error());
    $nomor = 1;
    while($data = mysql_fetch_array($query_mysql)){
    ? >
    < tr>
        < td>< ?php echo $nomor++; ? >< /td>
        < td>< ?php echo $data['nama']; ? >< /td>
        < td>< ?php echo $data['alamat']; ? >< /td>
        < td>< ?php echo $data['pekerjaan']; ? >< /td>
        < td>
            < a class="edit" href="edit.php?id=<?php echo $data['id']; ?>">Edit</a> |
            < a class="hapus" href="hapus.php?id=<?php echo $data['id']; ?>">Hapus</a>                  
        < /td>
    < /tr>
    < ?php } ?>
< /table>

< /body>
< /html>
"

after tample to display data from crud now we create tamplate for data input

input.php
"
< !DOCTYPE html>

< html>

< head>
< title>Make CRUD With PHP And MySQL< /title>

< link rel="stylesheet" type="text/css" href="style.css">

< /head>

< body>
< div class="judul">
< h1>Make CRUD With PHP And MySQL< /h1>

    < h2>Displays data from database< /h2>
< /div>

< br/>

< a href="index.php">Lihat Semua Data</a>

< br/>
< h3>Input data baru< /h3>
< form action="input-aksi.php" method="post">       
    < table>
        < tr>
            < td>Nama< /td>
            < td><input type="text" name="nama">< /td>                  
        </tr>   
        <tr>
            < td>Alamat</td>
            < td><input type="text" name="alamat">< /td>                    
        </tr>   
        < tr>
            < td>Pekerjaan< /td>
            < td><input type="text" name="pekerjaan">< /td>                 
        < /tr>  
        < tr>
            < td>< /td>
            < td><input type="submit" value="Simpan">< /td>                 
        < /tr>              
    < /table>
< /form>

< /body>
< /html>
"