/** * [update description] * @param [type] $id [description] * @return [type] [description] */ public function update($id) { $input = $_POST; $input['id'] = $id; # Build prepared update values $update = implode(', ', array_map(function ($v, $k) { return sprintf("%s = :%s", $k, $k); }, $input, array_keys($input))); # Prepare query $sql = "UPDATE user SET " . $update . " WHERE id = :id"; $stmt = Database::conn()->prepare($sql); $result = $stmt->execute($input); # Execute query if ($result) { return true; } else { return false; } }
* * Because we're not using virtual hosts, we'll have to set * our roots manually * ====================================================== */ define('DOC_NAMESPACE', __NAMESPACE__); define('DOC_ROOT', __DIR__); define('APP_ROOT', DOC_ROOT . '/App'); define('PUBLIC_ROOT', DOC_ROOT . '/Public'); define('SYSTEM_ROOT', DOC_ROOT . '/System'); define('VENDOR_ROOT', DOC_ROOT . '/Vendor'); define('WEB_ROOT', '//' . $_SERVER['HTTP_HOST'] . DOC_WEBROOT); /* ========================================================= * SETTINGS * ====================================================== */ set_include_path(DOC_ROOT); /* ========================================================= * INCLUDES * ====================================================== */ include 'System/functions.inc.php'; /* ========================================================= * VENDOR * ====================================================== */ //include ('Vendor/GUMP/gump.class.php'); /* ========================================================= * SET UP DATABASE CONNECTION * ====================================================== */ try { Database::connect(DB_HOST, DB_DATABASE, DB_USERNAME, DB_PASSWORD, DB_CHARSET); } catch (PDOException $e) { trigger_error($e->getMessage(), E_USER_ERROR); }