-
Notifications
You must be signed in to change notification settings - Fork 0
/
StoreReminderRecord.php
29 lines (23 loc) · 1009 Bytes
/
StoreReminderRecord.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
27
28
29
<?php
$servername = "seekt.asia";
$username = "seektasi_fitness";
$password = "fitness53300";
$dbname = "seektasi_bus";
$con = mysqli_connect($servername,$username,$password,$dbname);
$reminderID = $_POST["id"];
$userID = $_POST["user_id"];
$repeats = $_POST["repeats"];
$time = $_POST["time"];
$day = $_POST["day"];
$date = $_POST["date"];
$availability = $_POST["availability"];
$created_at = $_POST["createdAt"];
$updateAt = $_POST["updateAt"];
$activity_id = $_POST["activity_id"];
$statement = mysqli_prepare($con,"INSERT INTO Reminder (id, user_id, repeats, time, day, date, availability, created_at, updated_at, activity_id)
Values(?,?,?,?,?,?,?,?,?,?)");
mysqli_stmt_bind_param($statement,"sisssiisss", $reminderID, $userID, $repeats, $time, $day, $date, $availability, $created_at, $updateAt, $activity_id);
echo(mysqli_stmt_execute($statement));
mysqli_stmt_close($statement);
mysqli_close($con);
?>