set_include_path(dirname(dirname(getcwd()))); require_once 'constants.php'; require_once 'functions.php'; require_once 'dbConfig.php'; require_once 'config.php'; require_once 'database.php'; date_default_timezone_set(Config::timezone()); $id = loadvar('id'); $fieldname = loadvar('fieldname'); $p = loadvar('p'); $db = new Database(); if ($id != '' && $fieldname != '') { if ($p == 'show') { //show image $query = 'select AES_DECRYPT(picture, "' . Config::filePictureKey() . '") as picture1 from ' . Config::dbSurveyData() . '_pictures where primkey="' . $id . '" and variablename = "' . $fieldname . '"'; $result = $db->selectQuery($query); if ($result != null && $db->getNumberOfRows($result) > 0) { $row = $db->getRow($result); ob_clean(); header('Content-type: image/jpg'); if ($row['picture'] != null) { print $row['picture1']; } else { //display 'empty' image ob_clean(); header('Content-type: image/jpg'); echo file_get_contents('../../images/nopicture.png'); } exit; } else { //display 'empty' image
public static function select() { $database = new Database(); $database->selectQuery('users')->field('username')->field('password')->where('id', '5'); $result = $database->execute(); $database->selectQuery('users')->field('username')->field('password')->where('id', '15')->where('username', 'Alex'); $result = $database->execute(); $database->selectQuery('users')->field('username')->where('id', '25'); $result = $database->execute(); $database->selectQuery('users')->field('password')->where('id', '35'); $result = $database->execute(); $database->selectQuery('users')->field('*')->where('id', '55'); $result = $database->execute(); $database->selectQuery('users')->field('*')->where('id', '55')->limit(5); $result = $database->execute(); }