Membuat Aplikasi

 1. membuat koneksi ke database


2. crud.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>Document</title>


    <?php include 'koneksi.php'; ?>

</head>

<body>

    <form action="hasil.php" method="post">

        <table>

            <tr>

                <td>Nama</td>

                <td>:</td>

                <td>

                    <input type="text" name="namaku" placeholder="Nama Anda">

                </td>

            </tr>

            <tr>

                <td colspan="2">

                    <button type="submit" name="submit">Submit</button>

                </td>

                <td>

                    <button type="reset">Reset</button>

                </td>

            </tr>

        </table>

    </form>


    

</body>

</html>

Hasilnya: 


3. hasil.php

<?php 

include 'koneksi.php';


        

        

    if (isset($_POST['submit'])) {

        $nama = $_POST['namaku'];

        include 'koneksi.php';

        $hasil = "insert into contoh(id,nama) values('','$nama')";

        $input = mysqli_query($db, $hasil);

    }


$hasil = mysqli_query($db, "select * from contoh");


foreach ($hasil as $data){


?>


<table border="3">

    <tr>

        <td>

            <?php echo $data['id']; ?>

        </td>

        <td>

            <?php echo $data['nama']; ?>

        </td>

    </tr>

</table>

<?php } ?>

Hasilnya: 



Comments

Post a Comment

Popular posts from this blog

APLIKASI PERPUSTAKAAN DENGAN BOOTSTRAP 5, PHP DAN MYSQL

 koneksi.php <?php  $db = mysqli_connect("localhost","root","","perpus"); function query($query){     global $db;     $result = mysqli_query($db, $query);     $rows = [];     while ($row = mysqli_fetch_assoc($result)) {         $rows[] = $row;     }     return $rows; } function register($nis,$nama,$password){     global $db;     $result = mysqli_query($db, "select nis from user where nis = '$nis'");     if (mysqli_fetch_assoc($result)) {         echo "<script>         alert('NIS sudah terdaftar!')         </script>";         return false;     }     $sql = mysqli_query($db,"insert into user value('$nis','$nama','$password')");     return $sql; } function login($nis,$password){     global $db;     $sql = mysqli_query($db, "selec...
Read more

Aplikasi PKL dengan PHP

PHP koneksi.php <?php       $host = "localhost"; $username = "root"; $password = ""; $database = "pkl"; $koneksi = mysqli_connect($host,$username,$password,$database);       function register($username,$password,$nama) {         global $koneksi; $insert = mysqli_query($koneksi,"insert into user values ('$username','$password','$nama')"); return $insert; }   function login($username,$password,$remember) {         global $koneksi; $query = mysqli_query($koneksi,"select * from user where username='$username'"); $data_user = $query->fetch_array(); if(password_verify($password,$data_user['password'])) { if($remember) { setcookie('username', $username, time() + (60 * 60 * 24 * 5), '/'); setcookie('nama', $data_user['nama'], time() + (60 * 60 * 24 * 5), '/'); } $_SESSION['user...
Read more