-
Notifications
You must be signed in to change notification settings - Fork 0
/
Edit_account_employer.php
55 lines (45 loc) · 1.18 KB
/
Edit_account_employer.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
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
<?php
//start session
session_start();
require 'db_connection.php';
require 'upload_picture.php';
$id = $_SESSION['account_id'];
uploadProfilePicture($id);
$city = trim($_POST['city']);
$country = trim($_POST['country']);
$post_code = trim($_POST['post_code']);
$company = trim($_POST['company']);
$industry = trim($_POST['industry']);
$position_type = $_POST['position_type'];
//edit employer basic information
$edit_employee_query = 'REPLACE INTO g1116887.Employee SET
user_id = :user_id,
city = :city,
country = :country,
post_code = :post_code,
company = :company,
industry = :industry,
position_type = :position_type';
$main_values = array(
':user_id' => $id,
':city' => $city,
':country' => $country,
':post_code' => $post_code,
':company' => $company,
':industry' => $industry,
':position_type' => $position_type
);
try{
$pdo->beginTransaction();
//perform edit values & update values in database
$res1 = $pdo->prepare($edit_employee_query);
$res1->execute($main_values);
$pdo->commit();
header('location: ./Profile/EmployerProfile.php');
}
catch (Exception $e)
{
echo 'Edit Profile failed.<br>';
echo $e->getMessage();
die();
}