public function __construct() { $this->db = DBConnector::getInstance(); }
<?php if (session_status() == PHP_SESSION_NONE) { session_start(); } require 'scripts/init.php'; loadScripts(); $firstname = $_POST['firstname']; $lastname = $_POST['lastname']; $address = $_POST['address']; $city = $_POST['city']; $email = $_POST['email']; $password = $_POST['password']; $phonenumber = $_POST['phonenumber']; $province = $_POST['province']; $zipcode = $_POST['zipcode']; $userid = $_SESSION['userid']; $db = DBConnector::getInstance(); $password = MD5($password); $sql = "UPDATE USERS\n SET ADDRESS = '{$address}', City= '{$city}', email = '{$email}',\n password = '******', phonenumber = '{$phonenumber}', \n province = '{$province}', zipcode = '{$zipcode}'\n WHERE userid='{$userid}'"; $rows = $db->affectRows($sql); $data = array(); if ($rows > 0) { $data["msg"] = "Data updated!"; } else { $data["msg"] = "Data could not be updated! Try again."; } echo json_encode($data, JSON_FORCE_OBJECT);
/** * Returns a global instance of DBQuery. * * @param string $sIncDir Base include path of current system. This param is used by GlobalSystemUpdate. * * @return DBQuery */ public static function getInstance() { if (!self::$oDBQuery instanceof DBQuery) { self::$oDBQuery = new DBQuery(DBConnector::getInstance()); } return self::$oDBQuery; }
public function __construct() { $this->db = DBConnector::getInstance(); $_SESSION['cartId'] = $this->getCartId(); $this->cartId = $_SESSION['cartId']; }
public static function getLastId() { return DBConnector::getInstance()->lastInsertRowID(); }