<?php
include 'core/init.php'; //connect ke database
#// tambahan script 24 november 2016
if (isset($_POST['submit'])){
    $name = $_POST['name'];
    $username= $_POST['username'];
    $email= $_POST['email'];
    $phone = $_POST['phone'];
    $password = md5($_POST['password']);
    $interest1 = $_POST['interest1'];
    $interest2 = $_POST['interest2'];

 # Validasi form kosong
    if((!empty($name)) && (!empty($username)) && (!empty($email)) && (!empty($phone)) && (!empty($password)))

    {

    $query = "INSERT INTO user (nama, username, nomor_telefon, email, password, interest1, interest2) VALUES ('$name', '$username', '$phone', '$email', '$password', '$interest1', '$interest2')";
    mysqli_query($connection, $query);
    header("location: index.php");

    #untuk cek interest 1
     $mySql = "SELECT * from user,restoran where user.interest1 = restoran.id_kategori";
  $myQry = mysqli_query($connection, $mySql) ;
  while ($myData = mysqli_fetch_array($myQry))

  {

    $id_user = $myData['id_user'];
    $id_kategori = $myData['id_kategori'];
    $interest1 = $myData['interest1'];
    $interest2 = $myData['interest2'];
    $id_restoran = $myData['id_restoran'];



    if($interest1=$id_kategori){
        $query = "INSERT INTO nilai (id_user, id_kategori, id_restoran, nilai, koef ) VALUES ('$id_user', '$interest1', '$id_restoran', '100', '0.448276')";
    mysqli_query($connection, $query);}
    else{}
    }


    #untuk cek interest 2
    $mySql = "SELECT * from user,restoran where user.interest2 = restoran.id_kategori";
  $myQry = mysqli_query($connection, $mySql) ;
  while ($myData = mysqli_fetch_array($myQry))

  {

    $id_user = $myData['id_user'];
    $id_kategori = $myData['id_kategori'];
    $interest1 = $myData['interest1'];
    $interest2 = $myData['interest2'];
    $id_restoran = $myData['id_restoran'];



    if($interest2=$id_kategori){
        $query = "INSERT INTO nilai (id_user, id_kategori, id_restoran, nilai, koef ) VALUES ('$id_user', '$interest2', '$id_restoran', '80', '0.448276')";
    mysqli_query($connection, $query);}
    else{}
    }

    #untuk cek selain interest
    $mySql = "SELECT * from user,restoran where user.interest2 != restoran.id_kategori and user.interest1 != restoran.id_kategori ";
  $myQry = mysqli_query($connection, $mySql) ;
  while ($myData = mysqli_fetch_array($myQry)){

    $id_user = $myData['id_user'];
    $id_kategori = $myData['id_kategori'];
    $interest1 = $myData['interest1'];
    $interest2 = $myData['interest2'];
    $id_restoran = $myData['id_restoran'];



    $query = "INSERT INTO nilai (id_user, id_kategori, id_restoran, nilai, koef ) VALUES ('$id_user', '', '$id_restoran', '0', '0.448276')";
    mysqli_query($connection, $query);

  }
     }
     else{print "<script>alert('Maaf, tidak boleh ada field yang kosong !') ;
    javascript:history.go(-1);</script>";}

} // akhir tambahan script php (untuk login).
?>