-
Notifications
You must be signed in to change notification settings - Fork 0
/
processAddClient.php
34 lines (27 loc) · 1.15 KB
/
processAddClient.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
30
31
32
33
34
<?php
session_start();
if(isset($_SESSION['user'])){
require_once "./attributes/includes/db.php";
echo 'Processing... add user ';
// Check for POST variable
if(isset($_POST['demoboxNameWaarden'])){
$demoboxNameWaarden = mysqli_real_escape_string($db, $_POST['demoboxNameWaarden']);
$demoboxBerschijfingWaarden = mysqli_real_escape_string($db, $_POST['demoboxBerschijfingWaarden']);
$demoboxImgWaarden = mysqli_real_escape_string($db, $_POST['demoboxImgWaarden']);
$userid = mysqli_real_escape_string($db, $_SESSION["id"]);
$query = "INSERT INTO opdrachtgevers(name, img, beschijfing) VALUES('$demoboxNameWaarden', '$demoboxImgWaarden', '$demoboxBerschijfingWaarden')";
if(mysqli_query($db, $query)){
echo 'opdrachtgever Added...';
$last_id = mysqli_insert_id($db);
echo "New record created successfully. Last inserted ID is: " . $last_id;
$query = "INSERT INTO opdrachtgevers_users(opdrachgever_id, user_id) VALUES('$last_id', '$userid')";
if(mysqli_query($db, $query)){
echo 'opdrachtgever user Added...';
} else {
echo 'ERROR: '. mysqli_error($db);
}
} else {
echo 'ERROR: '. mysqli_error($db);
}
}
}