{ /** * primary * length 11 * @var int */ public $id; /** * data char * length 100 * @var string */ public $name; } $database = new \db\database('db_samples', new \db\link('default', $config->database, $config->username, $config->password)); $database->link('default')->debug = true; $database->add('user'); $database->update(); //create lazarus $lazarus = new \user(); $lazarus->name = 'Lazarus'; //save lazarus $database->user->save($lazarus); //kill lazarus unset($lazarus); //resurrect lazarus $lazarus = $database->user->load(1); \db\debug($lazarus); //1 stands for lazarus id //as soon as it is the first row in user table //it will have id 1 auto generated
//in this sample we will learn how to modify field settings //it is done by documenting class and class properties //it is improtant that documentation section starts with line /** and ends with line */ include './000.config.php'; include '../db.php'; class user { /** * primary * length 11 * @var int */ public $id; /** * data char * length 100 * @var string */ public $name; } $database = new \db\database(); $database->link(new \db\link('default', $config->database, $config->username, $config->password)); $database->link('default')->debug = true; $database->default = 'db_samples'; $database->add('user'); //so if you are coming here from previous example //where user.name had not any configs you must have field 'name' in 'user' table char(128) //** and after runing update field 'name' will become char(100) because you specified it in length comment in public $name documentation $database->update(); \db\debug($database->user);
<?php include '../db.php'; include './013.model.php'; $database = new \db\database($config->hostname, $config->database, $config->username, $config->password); $database->scan('.galaxy'); //truncate previous load table records foreach ($database->context->tables as &$table) { $database->link($table->link)->query("truncate " . $table->name()); } $alpha = $database->save(new \galaxy\star('alpha', 4)); $sun = $database->save(new \galaxy\star('sun', 1)); $database->save(new \galaxy\planet($alpha, 'xxx', 2, false, 100)); $database->save(new \galaxy\planet($alpha, 'xxx', 2, false, 123));
<?php include '../db.php'; $database = new \db\database('mysql:host=127.0.0.1', 'test', 'root', '1234'); $database->debug(); $result = $database->link()->query('show databases'); echo "<pre>"; if ($result) { foreach ($result as $row) { var_export($row); } } echo "</pre>";