-
Notifications
You must be signed in to change notification settings - Fork 0
/
savevariety.php
89 lines (72 loc) · 2.56 KB
/
savevariety.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
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
<?php
// configuration
include('db.php');
// new data
$cid = isset($_POST['ptid'])? $_POST['cid'] : '';
$pid = isset($_POST['ptid'])? $_POST['pid'] : '';
$id = isset($_POST['ptid'])? $_POST['ptid'] : '';
// Get the CID and PID
//////////////////////
// CATEGORY
//////////////////////
/*$a = ($_POST['categoryName'])? $_POST['categoryName'] : '';
$b = ($_POST['categoryImage'])? $_POST['categoryImage'] : '';
$c = ($_POST['cStatus'])? $_POST['cStatus'] : '';
$d = ($_POST['cArchive'])? $_POST['cArchive'] : '';*/
// category query
/*$categoryUpdate = $conn->prepare("UPDATE category SET
`categoryName`= ?,
`categoryImage`= ?,
`status`= ?,
`archive`= ?
WHERE `cid` = ?");*/
//$q = $conn->prepare($sql);
//$categoryUpdate->execute( array( $a, $b, $c, $d, $cid ) );
//////////////////////
// PRODUCT
//////////////////////
//$e = ($_POST['productName'])? $_POST['productName'] : '';
//$f = ($_POST['productBlurb'])? $_POST['productBlurb'] : '';
//$g = 1;
//$h = 0;
// $g = ($_POST['pStatus'])? $_POST['pStatus'] : '';
// $h = ($_POST['pArchive'])? $_POST['pArchive'] : '';
// category query
/*$productUpdate = $conn->prepare("UPDATE product SET
`productName`= ?,
`productBlurb`= ?,
`status`= ?,
`archive`= ?
WHERE `pid` = ?");*/
//$q = $conn->prepare($sql);
//$productUpdate->execute( array( $e, $f, $g, $h, $pid ) );
//////////////////////
// Variety Details
//////////////////////
$cid = isset($_POST['cid'])? $_POST['cid'] : '';
$pid = isset($_POST['pid'])? $_POST['pid'] : '';
$ptid = isset($_POST['ptid'])? $_POST['ptid'] : '';
$ptName = isset($_POST['ptName'])? $_POST['ptName'] : '';
$ptImage = isset($_POST['ptImage'])? $_POST['ptImage'] : '';
$kilo = isset($_POST['kilo'])? $_POST['kilo'] : '';
$box = isset($_POST['box'])? $_POST['box'] : '';
$punnet = isset($_POST['punnet'])? $_POST['punnet'] : '';
$bunch = isset($_POST['bunch'])? $_POST['bunch'] : '';
$single = isset($_POST['single'])? $_POST['single'] : '';
$ptBlurb = isset($_POST['ptBlurb'])? $_POST['ptBlurb'] : '';
//$q = ($_POST['varietyRecipe'])? $_POST['varietyRecipe'] : '';
$varietyUpdate = $conn->prepare("UPDATE productType SET
`ptName`= ?,
`ptImage`= ?,
`kilo`= ?,
`box`= ?,
`punnet`= ?,
`bunch`= ?,
`single`= ?,
`ptBlurb`= ?,
`pid` = ?,
`cid` = ?
WHERE `ptid` = ?");
$varietyUpdate->execute(array( $ptName, $ptImage, $kilo, $box, $punnet, $bunch, $single, $ptBlurb, $pid, $cid, $ptid ) );
header("location: productView.php");
?>