TUTORIAL || HOW TO MAKE CRUD WITH PHP AND MYSQL USING METHOD DISPLAY FROM BATABASE

in utopian-io •  7 years ago  (edited)

What Will I Learn?

  • We will learn how to make crud with PHP
  • We will learn how to make connect data base with crud, and input data so that can be accessed by crud.
  • We will learn to display data from database into crud
  • We will learn how to work from crud using PHP MYSQL

Requirements

  • Xampp
  • Text Editor (Sublime Text)
  • Browser Application

Difficulty

  • Intermediate

Tutorial Contents

What is CRUD ??

C (Create): which means creating a new data, for example we are registering in a web that is already a Create from CRUD because we create and store registration data to the 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 mostly use the CRUD function therein. This function is used to add data, delete data, and update data.

STEP MAKE OF CRUD
  • Because in the crud-making process we will play with DataBase So the first step of crud creation is to create a database.
  • Create a data base with the name "crud".

1.png

  • Then create table with "user "

2.png

  • And then create 4 colom in User Table (id, name, address, job)
  • And input data like this

3.png

  • to make it easy you can import the following SQL

"
INSERT INTO `crud`.`user` (`id`, `nama`, `alamat`, `pekerjaan`) 
VALUES 
('01', 'bahri', 'blangpulo lhokseumawe', 'web programmer'),
('02', 'samsul', 'cunda lhokseumawe', 'web programmer'), 
('03', 'dolah', 'lhoksukon aceh utara', 'DBMS'), 
('04', 'Dahlan', 'Kuta blang Lhokseumawe', 'pegawai'), 
('05', 'Dilan', 'paya bakong aceh utara', 'pegawai'); 
"
How to display data from MYSQL database
  • First we have to make a single look on the web page.
  • Now we create a page with the name idex.php

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>
"
  • Then we will make a connection between Index.php with Crud Yang database that we created earlier

koneksi.php

"

<?php

$host = mysql_connect("localhost","root","");

$db = mysql_select_db("crud");

"

SYNTAX PROGRAM Explanation

in the index.php file in the following syntax section

'

< ?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.";
}

}
? >

'

    • In this syntax serves to retrieve data memalalui URL to create a message notification data, for example the data has been successfully in the input, delete or in the update.

'
< 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>
'

    • sintax above serves to Display in the table.

'
< ?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 } ? >
'

    • Notice the syntax above first we haverus connect the Index.ph file with koneksi.php because we need konesi into the index.php file to the database to retrieve data from the database and then in show in the table with us paste the file koneksi.php with the function include.

'
include "koneksi.php";
'

if everything is understood and finished next we will beautify the look of index.php in the following way.

style.css

"'
body{

font-family: 'roboto';
color: #000;

}

.judul{
background: #87D1D8;

padding: 10px;

text-align: center;

}

.judul h1,h2,h3{

height: 15px;

}

a{

/*color: #fff;*/

padding: 5px;

text-decoration: none;  

}

.table{

border-collapse: collapse;

}

table.table th th , table.table tr td{

padding: 10px 20px  ;

}
"

  • or like in


4.png

  • if all the stages are done then the crud display on index.php will be like this

5.png

and finish

Curriculum



Posted on Utopian.io - Rewarding Open Source Contributors

Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!
Sort Order:  

Thank you for the contribution. It has been approved.

You can contact us on Discord.
[utopian-moderator]

Hey @rajamalikulfajar I am @utopian-io. I have just upvoted you!

Achievements

  • You have less than 500 followers. Just gave you a gift to help you succeed!
  • Seems like you contribute quite often. AMAZING!

Suggestions

  • Contribute more often to get higher and higher rewards. I wish to see you often!
  • Work on your followers to increase the votes/rewards. I follow what humans do and my vote is mainly based on that. Good luck!

Get Noticed!

  • Did you know project owners can manually vote with their own voting power or by voting power delegated to their projects? Ask the project owner to review your contributions!

Community-Driven Witness!

I am the first and only Steem Community-Driven Witness. Participate on Discord. Lets GROW TOGETHER!

mooncryption-utopian-witness-gif

Up-vote this comment to grow my power and help Open Source contributions like this one. Want to chat? Join me on Discord https://discord.gg/Pc8HG9x

Congratulations @rajamalikulfajar! You have completed some achievement on Steemit and have been rewarded with new badge(s) :

Award for the number of upvotes

Click on any badge to view your own Board of Honor on SteemitBoard.
For more information about SteemitBoard, click here

If you no longer want to receive notifications, reply to this comment with the word STOP

By upvoting this notification, you can help all Steemit users. Learn how here!