-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathedit.php
More file actions
41 lines (39 loc) · 1.36 KB
/
Copy pathedit.php
File metadata and controls
41 lines (39 loc) · 1.36 KB
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
<?php
// edit == ok
$user_id = (int)$_GET['user_id'];
if (isset($_POST['edit']))
{
$username = $_POST['username'];
$password = $_POST['password'];
$email = $_POST['email'];
$sql = 'UPDATE users SET username=:username , password=:password , email=:email WHERE user_id=:user_id';
$query = $db->prepare($sql);
$query->bindParam('username',$username,PDO::PARAM_STR);
$query->bindParam('password',$password,PDO::PARAM_STR);
$query->bindParam('email',$email,PDO::PARAM_STR);
$query->bindParam('user_id',$user_id,PDO::PARAM_STR);
$update = $query->execute();
if ($update == TRUE)
{
$_SESSION['success'] = 'user data has been edited seccessfuly';
header('location:index.php');
}
}
$user_id = (int)$_GET['user_id'];
$sql ='SELECT * FROM users WHERE user_id=:user_id';
$query = $db->prepare($sql);
$query->bindParam('user_id',$user_id,PDO::PARAM_STR);
$query->execute();
$user = $query->fetch();
//pre($user);
require_once 'template/edit_user.php';
//require_once 'controller/edit.php';
$user_id = (int)$_GET['user_id'];
$sql ='SELECT * FROM users WHERE user_id=:user_id';
$query = $db->prepare($sql);
$query->bindParam('user_id',$user_id,PDO::PARAM_STR);
$query->execute();
$user = $query->fetch();
//pre($user);
require_once 'template/edit_user.php';
?>