-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathaddchat.php
26 lines (21 loc) · 838 Bytes
/
addchat.php
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
<?php
require_once 'app/config.php';
$mhs_id=$_POST['id'];
$chat=htmlspecialchars($_POST['chat']);
$room_token=$_POST['token'];
$mhs_name=$_POST['nama_mahasiswa'];
// Setup Databse Connection
$conn = new PDO("mysql:host=".DB_HOST.";dbname=".DB_NAME,DB_USER, DB_PASS);
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
// Check Name Validity with mhs_id
$stmt = $conn->prepare("SELECT * FROM mahasiswa WHERE id='".$mhs_id."'");
$stmt->execute();
$result = $stmt->setFetchMode(PDO::FETCH_ASSOC);
$res=$stmt->fetchAll();
$data_mhs=$res[0];
if($mhs_name==$data_mhs['nama']){
$stmt = $conn->prepare("INSERT INTO chat (kelas_id,mhs_id,mhs_name,chat,unix_time,time) VALUES ('".$room_token."','".$mhs_id."','".$mhs_name."',:chat,'".time()."','".date('H:i')."')");
$stmt->bindParam(':chat', $chat);
$stmt->execute();
}
?>