· 6 years ago · Jun 21, 2019, 09:26 AM
1CREATE TABLE `pledge` (
2 `ID` INT(11) NOT NULL AUTO_INCREMENT,
3 `user` VARCHAR(45) NOT NULL,
4 `location` VARCHAR(45) NOT NULL,
5 `category` VARCHAR(45) NOT NULL,
6 `amount` DOUBLE NULL, NOT NULL,
7 `p_created` TIMESTAMP NOT NULL,
8 PRIMARY KEY (`ID`));
9
10INSERT a new record, if amount is not zero
11UPDATE an existing record, if key (column user, location, category) exists
12DELETE a record, if key (column user, location, category) exists AND amount is now zero
13
14
15
16try {
17 $conec = new Connection();
18 $con = $conec->Open();
19 $p_created = date("Y-m-d H:i:s");
20 $sql = "INSERT INTO `pledge`(
21 `user`,
22 `location`,
23 `category`,
24 `amount`,
25 `p_created`)
26 VALUES (
27 :user,
28 :location,
29 :category,
30 :amount,
31 :p_created)";
32
33 $pre = $con->prepare($sql, array(PDO::ATTR_CURSOR => PDO::CURSOR_FWDONLY));
34 if ($pre->execute(array(
35 ':user' => $user,
36 ':location' => $location,
37 ':category' => $category,
38 ':amount' => $amount,
39 ':p_created' => $p_created,
40 ))) {
41// echo "Successful";
42 }
43 } catch (PDOException $ex) {
44 echo $ex->getMessage();
45 }
46} // try