Insert Select PHP

Halo guys
Kali ini kita akan belajar cara Insert dan Select pada php
Berikut adalah source code untuk bahan belajar:)

Sebelum menjalankan programnya, pastikan nama database, nama tabel dan nama kolom sesuai dengan yang kalian buat ya...

-------------------------------------------------------------

Praktek 1 ( NAMA )

Code Index.php

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title> Input output database</title>
</head>
<body>
    <form method="post" action="tampil.php">
        <label> nama : </label>
        <input type="text" name="nama"><br><br>
        <input type="submit" value="kirim" name="proses">
        <input type="reset" value="reset">
</form>
</body>
</html>

Code koneksi.php

<?php

$conn = mysqli_connect("localhost", "root", "", "praktik");

?>

Code tampil.php

<?php

include "koneksi.php";

if(isset($_POST['proses'])){
    mysqli_query($conn, "insert into projek set
    NAMA = '$_POST[nama]'");
    echo "*Data baru telah tersimpan";
}
?>

<!DOCTYPE html>
<html>
<head>
    <title></title>
</head>
<body>
        <h1> TAMPILKAN DATA </h1>
        <table border="1">
            <tr>
                <th>ID</th>
                <th>NAMA</th>
            </tr>

            <?php
                include 'koneksi.php';
                $tampil = mysqli_query($conn, "SELECT * FROM projek order by ID desc limit 1");
                foreach ($tampil as $data) {
             ?>
             <tr>
                <td><?php echo $data["ID"]; ?></td>
                <td><?php echo $data["NAMA"]; ?></td>
            </tr>
            <?php
            }
           
            ?>

        </table>
</body>
</html>

Hasil

Isi dengan nama yang diinginkan:

Klik 'kirim'  
Data akan masuk ke database
dan data akan tampil pada website

Praktek 2 ( NAMA, KELAS )

Code Index.php

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title> Input output database</title>
</head>
<body>
    <form method="post" action="tampil.php">
        <label> nama : </label>
        <input type="text" name="nama"><br><br>
        <label> kelas : </label>
        <select name="kelas">
        <option value="X">X</option>
        <option value="XI">XI</option>
        <option value="XII">XII</option>
        </select><br><br>
        <input type="submit" value="kirim" name="proses">
        <input type="reset" value="reset">
</form>
</body>
</html>

Code koneksi.php

<?php

$conn = mysqli_connect("localhost", "root", "", "praktik2");

?>

Code tampil.php

<?php

include "koneksi.php";

if(isset($_POST['proses'])){
    mysqli_query($conn, "insert into projek2 set
    NAMA = '$_POST[nama]',
    KELAS = '$_POST[kelas]'");
    echo "*Data baru telah tersimpan";
}
?>

<!DOCTYPE html>
<html>
<head>
    <title></title>
</head>
<body>
        <h1> TAMPILKAN DATA </h1>
        <table border="1">
            <tr>
                <th>ID</th>
                <th>NAMA</th>
                <th>KELAS</th>
            </tr>

            <?php
                include 'koneksi.php';
                $tampil = mysqli_query($conn, "SELECT * FROM projek2 order by ID desc limit 1");
                foreach ($tampil as $data) {
             ?>
             <tr>
                <td><?php echo $data["ID"]; ?></td>
                <td><?php echo $data["NAMA"]; ?></td>
                <td><?php echo $data["KELAS"]; ?></td>
            </tr>
            <?php
            }
           
            ?>

        </table>
</body>
</html>

Hasil

Isi dengan nama dan kelas yang diinginkan:



Klik 'kirim'  
Data akan masuk ke database
dan data akan tampil pada website


Praktek 3 ( NAMA, JENIS KELAMIN )

Code Index.php

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>PHP 3</title>
</head>
<body>
    <form method="post" action="tampil.php">
        <label> nama : </label>
        <input type="text" name="nama"><br><br>

        <label> jenis kelamin : </label>
        <input type="radio" value="laki-laki" name="jenkel">
        <label for="laki"> Laki-Laki </label>
        <input type="radio" value="perempuan" name="jenkel">
        <label for="perempuan"> Perempuan</label><br><br>
        <input type="submit" value="kirim" name="proses">
        <input type="reset" value="reset">
</form>
</body>
</html>

Code koneksi.php

<?php

$conn = mysqli_connect("localhost", "root", "", "praktek3");

?>

Code tampil.php

<?php

include "koneksi.php";

if(isset($_POST['proses'])){
    mysqli_query($conn, "insert into projek3 set
    NAMA = '$_POST[nama]',
    JENISKELAMIN = '$_POST[jenkel]'");
    echo "*Data baru telah tersimpan";
}
?>

<!DOCTYPE html>
<html>
<head>
    <title></title>
</head>
<body>
        <h1> TAMPILKAN DATA </h1>
        <table border="1">
            <tr>
                <th>ID</th>
                <th>NAMA</th>
                <th>JENIS KELAMIN</th>
            </tr>

            <?php
                include 'koneksi.php';
                $tampil = mysqli_query($conn, "SELECT * FROM projek3 order by ID desc limit 1");
                foreach ($tampil as $data) {
             ?>
             <tr>
                <td><?php echo $data["ID"]; ?></td>
                <td><?php echo $data["NAMA"]; ?></td>
                <td><?php echo $data["JENISKELAMIN"]; ?></td>
            </tr>
            <?php
            }
           
            ?>

        </table>
</body>
</html>

Hasil

Isi dengan nama dan jenis kelamin yang diinginkan:



Klik 'kirim'  
Data akan masuk ke database
dan data akan tampil pada website

Praktek 4 ( NAMA, HOBI )

Code Index.php

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>PHP 3</title>
</head>
<body>
    <form method="post" action="tampilan.php">
        <label> nama : </label>
        <input type="text" name="nama"><br><br>
        <label> hobi : </label>
        <input type="checkbox" name="hobi[]" value="Olahraga"><label> Olahraga </label>
        <input type="checkbox" name="hobi[]" value="Gammers"><label> Gammers </label>
        <input type="checkbox" name="hobi[]" value="Slebew"><label> Slebew </label><br><br>
        <input type="submit" value="kirim" name="proses">
        <input type="reset" value="reset">
</form>
</body>
</html>

Code koneksi.php

<?php

$conn = mysqli_connect("localhost", "root", "", "praktek4");

?>

Code tampil.php

<?php

include "koneksi.php";
if(isset($_POST['proses'])){
    $nama = $_POST['nama'];
    $hobby = implode(', ', $_POST['hobi']);

    mysqli_query($conn,"INSERT INTO projek4 (NAMA, HOBY) values ('$nama','$hobby')");  
    echo "*Data baru telah tersimpan";

}
?>

<!DOCTYPE html>
<html>
<head>
    <title></title>
</head>
<body>
        <h1> TAMPILKAN DATA </h1>
        <table border="1">
            <tr>
                <th>ID</th>
                <th>NAMA</th>
                <th>HOBI</th>
            </tr>

            <?php
                include 'koneksi.php';

                $tampil = mysqli_query($conn, "SELECT * FROM projek4 order by ID desc limit 1");
                if(mysqli_num_rows($tampil)>0){
                    ?>
                    <?php while ($data = mysqli_fetch_array($tampil)){
                        ?>
            <tr>
                <td><?php echo $data["ID"]; ?></td>
                <td><?php echo $data["NAMA"]; ?></td>
                <td><?php echo $data["HOBY"]; ?></td>
            </tr>
            <?php }?>      
             
            <?php
            }
           
            ?>

        </table>
</body>
</html>

Hasil

Isi dengan nama dan hobi yang diinginkan:



Klik 'kirim'  
Data akan masuk ke database
dan data akan tampil pada website



-----------------------------------------

Sekian praktik yang saya buat
Semoga bisa bermanfaat:)

Komentar

Posting Komentar

Postingan populer dari blog ini

OPERATOR STRING

Gambar
CODE: <?php $nama = "Nandana" ; $barang = "Monitor" ; $hasil = "Terimakasih { $nama } telah memesan " . $barang ; $harga = 50000 ; $diskon = 50000 * 0.15 ; $bayar = $harga - $diskon ; $uang = 100000 ; $kembali = $uang - $bayar ; ? > < html > < head > < title > penjualan produk </ title > < style type = "text/css" > body {     background-image : url ( 'wp.jpg' );     background-size : 100% ;     font-family : roboto; } h1 {         color : red ; } tr {     background-color : #96D4D4 ; } table {     background-color : blue ; } .harga p {     color : green ; } .diskon p {     color : red ;     font-size : 40px ;     text-align : center ; } </ style > </ head > < body > < h1 align = "middle" > TOKO KOMPUTER MURAH </ h1 > < br > < table   bordercolor = "purple" border = "1" cellpadding...
Baca selengkapnya