-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathedit_contact.php
43 lines (39 loc) · 1.43 KB
/
edit_contact.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
<?php
function showFormEditContact($contact, $error = 0) {
echo '<strong>Edit Contact</strong><br/><br/>';
echo '<form method="POST">';
echo 'Name';
echo '<input class="form-control" type="text" name="name" value="'.$contact['name'].'"/>';
echo 'Email';
echo '<input class="form-control" type="email" name="email" value="'.$contact['email'].'"/>';
echo 'Address';
echo '<input class="form-control" type="textarea" name="address" value="'.$contact['address'].'"/>';
echo 'Phone';
echo '<input class="form-control" type"tel" name="phone" value="'.$contact['phone'].'"/><br/>';
echo '<input class="btn btn-dark" type="submit" value="Save"/>';
echo '</form>';
if($error == 1) {
echo '<p>Error inserting in database</p>';
} elseif ($error == 2) {
echo '<p>Field "name" cannot be blank</p>';
}
}
function editContact($id, $name, $email, $address, $phone) {
require 'config.php';
$sql = "UPDATE contact SET name = :name, email = :email, address = :address, phone = :phone ";
$sql.=" WHERE id = :id";
$sql = $pdo->prepare($sql);
$sql->bindValue(':id', $id);
$sql->bindValue(':name', $name);
$sql->bindValue(':email', $email);
$sql->bindValue(':address', $address);
$sql->bindValue(':phone', $phone);
try {
$sql->execute();
return 0;
} catch(PDOException $e) {
echo 'Error:'.$e->getMessage();
return 1;
}
}
?>