<?php
require_once 'autoload.php';
use website\Common;
use website\model\User;
use website\utils\Password;
use website\model\Module;
use website\model\StudentModuleSubscription;
use website\model\TeacherModuleSubscription;
$common = Common::getInstance();
$common->db()->exec('DELETE FROM ' . StudentModuleSubscription::tableName());
$common->db()->exec('DELETE FROM ' . TeacherModuleSubscription::tableName());
$common->db()->exec('DELETE FROM ' . User::tableName());
$common->db()->exec('DELETE FROM ' . Module::tableName());
$bananaHashed = Password::hash('banana', false);
$admin = new User();
$admin->first_name = "super admin";
$admin->last_name = "nameless";
$admin->login = '******';
$admin->password = $bananaHashed;
$admin->role = 'admin';
$admin->address = 'nowhere';
$admin->date_of_birth = '2000-01-01';
$admin->phone = '000';
$admin->email = '*****@*****.**';
$admin->valid = true;
$admin->save();
$prof = new User();
$prof->first_name = "teneyug";
$prof->last_name = "nameless";
$prof->login = '******';
<?php
require_once '../Common.php';
$common = \website\Common::getInstance();
$user = new \website\model\User();
$user->age = 15;
$user->login = '******' . rand();
$user->password = \website\utils\Password::hash('5a1v564a1v564a1');
$user->first_name = 'toto';
$user->last_name = 'caca';
var_dump($user->save());
echo '------------------------<br/>';
var_dump($user);
echo '------------------------<br/>';
$user->age = 16;
var_dump($user->save());
echo '------------------------<br/>';
var_dump($user);
echo '------------------------<br/>';
var_dump(\website\model\User::find());
echo '------------------------<br/>';
var_dump(\website\model\User::findOneWhere(['id'], [5]));
var_dump(\website\model\User::findOneWhere(['id' => 5]));
var_dump(\website\model\User::findOneWhere('id = ?', [5]));
<?php
namespace website;
require_once 'autoload.php';
use website\db\DBTrait;
class Common
{
use DBTrait;
private static $instance = null;
public static function setup()
{
ini_set('display_errors', 'On');
error_reporting(E_ALL | E_STRICT);
}
public static function getInstance()
{
if (is_null(self::$instance)) {
self::$instance = new self();
}
return self::$instance;
}
}
Common::setup();
