functionsphp

<?php

$conn = mysqli_connect("localhost","root","","phpdasar");
$query = "SELECT * FROM mahasiswa";

//pagination
$jumlahdataPerhalaman = 5;
$result = mysqli_query($conn,"SELECT * FROM mahasiswa");
$jumlahdata = mysqli_num_rows($result);
$jumlahHalaman = ceil($jumlahdata / $jumlahdataPerhalaman);
$halamanAktif = (isset($_GET["halaman"]) ) ?$_GET["halaman"] : 1 ;
$awalData = ($jumlahdataPerhalaman * $halamanAktif ) - $jumlahdataPerhalaman;


$query =("SELECT * FROM mahasiswa LIMIT $awalData,$jumlahdataPerhalaman") ;

$tb=mysqli_query($conn,$query);
if (!$tb) {
    echo "tidak ada";
}

function query ($query){
    global $conn;
    $result = mysqli_query($conn, $query);
    $rows = [];
    while( $row = mysqli_fetch_assoc($result) ){
        $rows[] = $row;
    }
    return $rows;
}

function registrasi($data){
    global $conn;

    $username = strtolower(stripslashes($data['username']));
    $password = mysqli_real_escape_string($conn, $data['password']);
    $password2 = mysqli_real_escape_string($conn, $data['password2']);

    //cek username sudah ada atau belum
    $result = mysqli_query($conn,"SELECT username FROM user WHERE username='$username'");
    if ( mysqli_fetch_assoc($result) ) {
        echo "<script>
        alert('username yang dipilih sudah terdaftar !')
                <script>";
        return false;
    }

    //cek konfirmasi passsword
    if ( $password !== $password2 ){
            echo "<script>
            alert( 'konfirmasi password tidak sesuai ! ' );
            </script>";
            return false;
    }


    //enkripsi password
    $password = password_hash($password, PASSWORD_DEFAULT);

    //tambahkan userbaru ke database
    mysqli_query($conn, "INSERT INTO user VALUES('', '$username','$password')");

    return mysqli_affected_rows($conn);


}

//fungsi pencarian


if(isset($_GET['cari'])){
    $cari = $_GET['cari'];
    echo "";
}

function cari($keyword){
    $query = "SELECT * FROM mahasiswa
                WHERE
                nama = '$keyword'
             ";
    return query($query);
}


 ?>