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();
}
