prj11/function.php at main · vexra/prj11 · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
<?php
    session_start();
    function connect($db) {
        return mysqli_connect("localhost", "root", "", $db);
    }
    function insert_peserta($mail, $pass, $nama, $telp, $instansi) {
        return mysqli_query(connect("prjx"), "INSERT INTO `peserta`(`email`, `password`,`nama`,`telpon`,`instansi`) VALUES ('$mail','$pass','$nama','$telp','$instansi')");
    }

    function update_peserta($mail, $nama, $telp, $instansi, $job, $birth, $id) {
        return mysqli_query(connect("prjx"), "UPDATE peserta SET email = '$mail', nama = '$nama', telpon = '$telp', instansi = '$instansi', pekerjaan = '$job', birth = '$birth' Where id = '$id'");
    }

    function update_identitas($gambar, $nama) {
        return mysqli_query(connect("prjx"), "UPDATE anggota SET bukti_identitas = '$gambar' Where nama = '$nama'");
    }

    function update_gambar($gambar, $id) {
        return mysqli_query(connect("prjx"), "UPDATE peserta SET foto = '$gambar' Where id = '$id'");
    }

    function update_pembayaran($gambar, $id){
        return mysqli_query(connect("prjx"), "UPDATE pendaftaran SET buktiPembayaran = '$gambar' Where id = '$id'");

    }

    function update_karya($gambar, $id){
        return mysqli_query(connect("prjx"), "UPDATE pendaftaran SET karya = '$gambar' Where id = '$id'");

    }


    function registrasi($data){
        $email = htmlspecialchars( $data);
        $temp = mysqli_query(connect("prjx"), "SELECT email FROM peserta WHERE email = '$email'");
        if(mysqli_fetch_assoc($temp)){
           return true;
        }
    }


    function login_check($mail, $pass){

        $query = mysqli_query(connect("prjx"), "SELECT * FROM peserta WHERE email = '$mail'");
        $data = mysqli_fetch_assoc($query);
        if($data != null){
            if(password_verify($pass, $data['password'])==true){
                return true;
            }else{
                return false;
            }
        }
        else{
            return false;
        }


    }

    function insert_pendaftaran($nama, $instansi, $mail, $div, $id_pendaftaran){
        $conn = mysqli_connect("localhost", "root", "", "prjx");
        $q = "INSERT INTO `pendaftaran`(`divisi`, `sekolah`, `email`, `nama_tim`,`date` ,`id_peserta`) VALUES ('$div','$instansi','$mail','$nama',current_date(),'$id_pendaftaran')";
        mysqli_query($conn, $q);
        return mysqli_insert_id($conn);
    }

    // function get_last_pendaftaran(){
    //     return
    // }

    function insert_anggota($nama, $mail, $telpon, $birth, $id_pendaftaran, $instansi){
        return mysqli_query(connect("prjx"), "INSERT INTO `anggota`(`nama`, `email`,`birth`, `no_hp`, `id_pendaftaran`,`instansi`) VALUES ('$nama','$mail','$birth','$telpon','$id_pendaftaran','$instansi')");
    }


?>