function test_3_more_inserts() { DB::insert('`accounts`', array('username' => 'Bart', 'password' => 'hello', 'age' => 15, 'height' => 10.371)); $dbname = DB::$dbName; DB::insert("`{$dbname}`.`accounts`", array('username' => 'Charlie\'s Friend', 'password' => 'goodbye', 'age' => 30, 'height' => 155.23, 'favorite_word' => null)); $this->assert(DB::insertId() === 3); $counter = DB::queryFirstField("SELECT COUNT(*) FROM accounts"); $this->assert($counter === strval(3)); DB::insert('`accounts`', array('username' => 'Deer', 'password' => '', 'age' => 15, 'height' => 10.371)); $username = DB::queryFirstField("SELECT username FROM accounts WHERE password=%s0", null); $this->assert($username === 'Deer'); $password = DB::queryFirstField("SELECT password FROM accounts WHERE favorite_word IS NULL"); $this->assert($password === 'goodbye'); DB::$usenull = false; DB::insertUpdate('accounts', array('id' => 3, 'favorite_word' => null)); $password = DB::queryFirstField("SELECT password FROM accounts WHERE favorite_word=%s AND favorite_word=%s", null, ''); $this->assert($password === 'goodbye'); DB::$usenull = true; DB::insertUpdate('accounts', array('id' => 3, 'favorite_word' => null)); DB::$param_char = '###'; $bart = DB::queryFirstRow("SELECT * FROM accounts WHERE age IN ###li AND height IN ###ld AND username IN ###ls", array(15, 25), array(10.371, 150.123), array('Bart', 'Barts')); $this->assert($bart['username'] === 'Bart'); DB::insert('accounts', array('username' => 'f_u')); DB::query("DELETE FROM accounts WHERE username=###s", 'f_u'); DB::$param_char = '%'; $charlie_password = DB::queryFirstField("SELECT password FROM accounts WHERE username IN %ls AND username = %s", array('Charlie', 'Charlie\'s Friend'), 'Charlie\'s Friend'); $this->assert($charlie_password === 'goodbye'); $charlie_password = DB::queryOneField('password', "SELECT * FROM accounts WHERE username IN %ls AND username = %s", array('Charlie', 'Charlie\'s Friend'), 'Charlie\'s Friend'); $this->assert($charlie_password === 'goodbye'); $passwords = DB::queryFirstColumn("SELECT password FROM accounts WHERE username=%s", 'Bart'); $this->assert(count($passwords) === 1); $this->assert($passwords[0] === 'hello'); $username = $password = $age = null; list($age, $username, $password) = DB::queryOneList("SELECT age,username,password FROM accounts WHERE username=%s", 'Bart'); $this->assert($username === 'Bart'); $this->assert($password === 'hello'); $this->assert($age == 15); $mysqli_result = DB::queryRaw("SELECT * FROM accounts WHERE favorite_word IS NULL"); $this->assert($mysqli_result instanceof MySQLi_Result); $row = $mysqli_result->fetch_assoc(); $this->assert($row['password'] === 'goodbye'); $this->assert($mysqli_result->fetch_assoc() === null); }
public static function lookup_with_survey_tag($survey_tag) { $query = "SELECT * FROM credentials_stu WHERE survey_tag = %s"; $survey_id = DB::queryOneField('survey_id', $query, $survey_tag); if (!is_null($survey_id)) { // Hack to convert strings to ints but keep null as null. $survey_id = (int) $survey_id; } return $survey_id; }
public static function isTokenValid($newTokenValue) { $datetimeValid = "P1D"; // valid for 1 day $result = false; $lastAccess = CWM_API::getDateTime(strtotime(DB::queryOneField('LastAccess', 'SELECT * FROM CWM_ApiKeySession WHERE TokenValue=%?', $newTokenValue))); $lastAccess = new DateTime($lastAccess); $lastAccess->add(new DateInterval($datetimeValid)); $result = new DateTime(CWM_API::getDateTime(time())) < $lastAccess; // if not valid, update the date to be in the past if (!$result) { CWM_API::resetToken($datetimeValid, $newTokenValue); } return $result; }
public function getId() { return DB::queryOneField("Id", "SELECT * FROM CWM_Solution WHERE UserId=%? AND Name=%?", $this->UserId, $this->Name); }
<?php require_once $GLOBALS['dirLibs'] . '/external/meekrodb.2.2.class.php'; require_once $GLOBALS['dirCore'] . '/dbConfig.inc.php'; require_once $GLOBALS['dirRoot'] . '/api/ApiAuth.class.php'; $results = array(); $tokenValue = $f3->get('PARAMS.tokenValue'); if (CWM_API::IsTokenValid($tokenValue)) { $userId = DB::queryOneField("Id", "SELECT * FROM CWM_ApiKeySession aks JOIN CWM_User as u ON aks.UserId = u.Id WHERE TokenValue=%?", $tokenValue); $results = DB::query("SELECT * FROM CWM_Solution WHERE UserId=%?", $userId); } echo json_encode($results);
<?php require_once '../../../../core/dirHandler.php'; require_once $GLOBALS['dirLibs'] . '/external/meekrodb.2.2.class.php'; require_once $GLOBALS['dirCore'] . '/dbConfig.inc.php'; require_once $GLOBALS['dirCore'] . '/config.inc.php'; require_once $GLOBALS['dirCore'] . '/common.inc.php'; $url = $_POST['url']; $content = $_POST['content']; $theme = $_POST['theme']; $ID = DB::queryOneField('Id', "SELECT * FROM CWM_SourceDraft WHERE Url=%?", $url); if (!is_null($ID)) { DB::update('CWM_SourceDraft', array('Content' => $content, 'Theme' => $theme), "Id=%?", $ID); }
<?php require_once '../../../../core/dirHandler.php'; require_once $GLOBALS['dirLibs'] . '/external/meekrodb.2.2.class.php'; require_once $GLOBALS['dirCore'] . '/dbConfig.inc.php'; require_once $GLOBALS['dirCore'] . '/config.inc.php'; require_once $GLOBALS['dirCore'] . '/common.inc.php'; $selectId = $_POST['selectId']; $file = $_POST['fileFullName']; $content = DB::queryOneField('Content', "SELECT * FROM CWM_SourceDraft WHERE Url=%?", $selectId); echo file_put_contents($file, $content);
<?php require_once '../dirHandler.php'; require_once $GLOBALS['dirLibs'] . '/external/meekrodb.2.2.class.php'; require_once $GLOBALS['dirCore'] . '/dbConfig.inc.php'; $projectId = $_GET['projectId']; $results = DB::query("SELECT * FROM CWM_File WHERE ProjectId=%? AND UserId=%?", $projectId, $_GET['uid']); $data = array(); foreach ($results as $row) { $shareId = $row['ShareId']; $shareUrl = ""; if (!is_null($shareId)) { $shareUrl = DB::queryOneField("Url", "SELECT * FROM CWM_Share WHERE FileId=%?", $row['Id']); } array_push($data, array('name' => $row['Name'], 'solutionName' => $row['SolutionName'], 'projectName' => $row['ProjectName'], 'shareUrl' => $shareUrl)); } echo json_encode($data);