Projekers - 13515051 - Girvandi Ilyas

Kelompok : Projekers

Description : A website application to order ojek

Contributors :

1. Girvandi Ilyas - 13515051
2. Aldrich Valentino Halim - 13515081
3. Mikhael Artur Darmakesuma - 13515099

model/order.php

@@ -12,8 +12,8 @@ class Order {
     function setTransaction($userId, $driverId, $pickup, $destination, $transactionDate, $rating, $comment){
         $con = mysqli_connect('localhost','root', '', 'projekers');
         mysqli_select_db($con, 'projekers');
-        $sql = 'INSERT INTO transaction(user_id, driver_id, pickup, destination, rating, comment, date) values('.
-                $userId.','.$driverId.',"'.$pickup.'","'.$destination.'",'.$rating.',"'.$comment.'","'.$transactionDate.'")';
+        $sql = 'INSERT INTO transaction(user_id, driver_id, pickup, destination, rating, comment, date, is_visible) values('.
+                $userId.','.$driverId.',"'.$pickup.'","'.$destination.'",'.$rating.',"'.$comment.'","'.$transactionDate.',",1)';
         mysqli_query($con, $sql);
         mysqli_close($con);
     }