Exemple #1
0
 function execute()
 {
     $qb = $this->container->get('QB');
     var_dump($qb);
     $query = QB::query('select version()');
     var_dump($query->get());
 }
Exemple #2
0
 /**
  * /u/@user/key.json
  */
 public function key($f3, $params)
 {
     $key = \QB::table('user_key')->select(['user_key.fingerprint', 'user_key.key'])->join('user', 'user.id', '=', 'user_key.user_id')->where('user.username', $params['username'])->where('user_key.type', 'public')->first();
     if (!$key) {
         \App::error(404);
     }
     $this->_json($key);
 }
Exemple #3
0
 /**
  * Initialize the app
  */
 static function init()
 {
     // Load configuration
     if (is_file('config.php')) {
         self::$_config = (require 'config.php');
     } else {
         throw new Exception('No config.php file found.');
     }
     // Initialize Composer autoloader
     require_once 'vendor/autoload.php';
     // Initialize framework
     self::$_router = Base::instance();
     self::$_router->mset(['AUTOLOAD' => 'app/', 'ESCAPE' => false, 'PACKAGE' => 'svlt/back', 'CORS.origin' => '*']);
     // Initialize database connection and query builder
     self::$_qb = new Pixie\Connection('mysql', ['driver' => 'mysql'] + self::$_config['db'], 'QB');
     self::$_db = new SQL(QB::pdo(), 'mysql:host=' . self::$_config['db']['host'] . ';port=3306;dbname=' . self::$_config['db']['database']);
     // Initialize routes
     require_once 'routes.php';
 }
Exemple #4
0
 public function replace($data, $table)
 {
     $keys = array_keys($data);
     $sql = QB::replaceQuery($table, $keys);
     $q = $this->conn->prepare($sql);
     $sth = $q->execute($data);
     if ($sth) {
         return true;
     } else {
         return false;
     }
 }