-
Notifications
You must be signed in to change notification settings - Fork 0
/
saveeditcustomer.php
74 lines (72 loc) · 2.83 KB
/
saveeditcustomer.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
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
<?php
// configuration
include('db.php');
// new data
$id = ($_POST['customer_ID'])? $_POST['customer_ID'] : '';
$a = ($_POST['firstName'])? $_POST['firstName'] : '';
$b = ($_POST['lastName'])? $_POST['lastName'] : '';
$c = ($_POST['contact'])? $_POST['contact'] : '';
$d = ($_POST['phone1'])? $_POST['phone1'] : '';
$e = ($_POST['phone2'])? $_POST['phone2'] : '';
$f = ($_POST['fax'])? $_POST['fax'] : '';
$g = ($_POST['email'])? $_POST['email'] : '';
$h = ($_POST['billAddress1'])? $_POST['billAddress1'] : '';
$i = ($_POST['billAddress2'])? $_POST['billAddress2'] : '';
$j = ($_POST['billFlat'])? $_POST['billFlat'] : '';
$k = ($_POST['billStreetNumber'])? $_POST['billStreetNumber'] : '';
$l = ($_POST['billStreet'])? $_POST['billStreet'] : '';
$m = ($_POST['billStreetType'])? $_POST['billStreetType'] : '';
$n = ($_POST['billSuburb'])? $_POST['billSuburb'] : '';
$o = ($_POST['billCity'])? $_POST['billCity'] : '';
$p = ($_POST['billState'])? $_POST['billState'] : '';
$q = ($_POST['billPostcode'])? $_POST['billPostcode'] : '';
$r = ($_POST['billNotes'])? $_POST['billNotes'] : '';
$s = ($_POST['deliveryTitle1'])? $_POST['deliveryTitle1'] : '';
$t = ($_POST['deliveryTitle2'])? $_POST['deliveryTitle2'] : '';
$u = ($_POST['deliveryFlat'])? $_POST['deliveryFlat'] : '';
$v = ($_POST['deliveryStreetNumber'])? $_POST['deliveryStreetNumber'] : '';
$w = ($_POST['deliveryStreetName'])? $_POST['deliveryStreetName'] : '';
$x = ($_POST['deliveryStreetType'])? $_POST['deliveryStreetType'] : '';
$y = ($_POST['deliverySuburb'])? $_POST['deliverySuburb'] : '';
$z = ($_POST['deliveryCity'])? $_POST['deliveryCity'] : '';
$aa = ( $_POST['deliveryState'])? $_POST['deliveryState'] : '';
$ab = ( $_POST['deliveryPostcode'])? $_POST['deliveryPostcode'] : '';
$ac = ( $_POST['deliveryNotes'])? $_POST['deliveryNotes'] : '';
$ad = ( $_POST['terms'])? $_POST['terms'] : '';
// query
$sql = $conn->prepare("UPDATE fnfCustomer SET
`firstName`= ?,
`lastName`= ?,
`contact`= ?,
`phone1`= ?,
`phone2`= ?,
`fax`= ?,
`email`= ?,
`billAddress1`= ?,
`billAddress2`= ?,
`billFlat`= ?,
`billStreetNumber`= ?,
`billStreet`= ?,
`billStreetType`= ?,
`billSuburb`= ?,
`billCity`= ?,
`billState`= ?,
`billPostcode`= ?,
`billNotes`= ?,
`deliveryTitle1`= ?,
`deliveryTitle2`= ?,
`deliveryFlat`= ?,
`deliveryStreetNumber`= ?,
`deliveryStreetName`= ?,
`deliveryStreetType`= ?,
`deliverySuburb`= ?,
`deliveryCity`= ?,
`deliveryState`= ?,
`deliveryPostcode`= ?,
`deliveryNotes`= ?,
`terms`= ?
WHERE customer_id=?");
//$q = $conn->prepare($sql);
$sql->execute(array($a,$b,$c,$d,$e,$f,$g,$h,$i,$j,$k,$l,$m,$n,$o,$p,$q,$r,$s,$t,$u,$v,$w,$x,$y,$z,$aa,$ab,$ac, $ad, $id));
header("location: customerView.php");
?>