if (empty($updata["id"])) { errormsg("The 'clientID' is required."); } $dbh = new PDB(); $db = $dbh->db; $site = new Site($db); try { $ct = 0; $sql = "UPDATE clients SET "; foreach ($updata as $key => $value) { if ($value != "" && $key != "id") { if ($ct != 0) { $sql .= ", "; } $sql .= $key . " = :" . $key; $ct++; } } $sql .= " WHERE id = :id"; $st = $db->prepare($sql); foreach ($updata as $key => &$value) { if ($value != "") { $st->bindParam(":" . $key, $value); } } $st->execute(); $newclient = $dbh->getClient($user, $updata["id"]); } catch (PDOException $e) { errormsg($e->getMessage()); } exitjson(array("client" => $newclient));
<?php // check if logged in // per project or all tasks? // error_reporting(E_ALL); session_start(); session_regenerate_id(false); require_once "reqs/common.php"; require_once "reqs/pdo.php"; //require_once("reqs/auth.php"); checkLoggedIn(); $userID = $_SESSION["user"]; $dbh = new PDB(); $db = $dbh->db; $clientID = param($_GET, 'clientID', ''); if ($clientID == '') { $clients = $dbh->getClients($userID); } else { $clients = $dbh->getClient($userID, $clientID); } exitjson(array("clients" => $clients));