/**
* conn/disconnect を繰り返せることをテストする
*/
public function test_disconnect_04()
{
$db = SimpleDBI::conn();
$value = $db->value('SELECT 1');
$this->assertEquals(1, $value);
$db->disconnect();
$db = SimpleDBI::conn();
$value = $db->value('SELECT 1');
$this->assertEquals(1, $value);
$db->disconnect();
}
public static function get()
{
$db = SimpleDBI::conn();
$q = $db->row('select * from question WHERE id = :id', ['id' => rand_int()]);
return $q;
}
public function __construct()
{
$this->db = SimpleDBI::conn();
}
function rand_int()
{
$db = SimpleDBI::conn();
$max = $db->value('SELECT COUNT(*) from question');
return rand(1, $max);
}
public static function get($q_id)
{
$db = SimpleDBI::conn();
$a = $db->value('select answer from answer WHERE q_id = :id', ['id' => $q_id]);
return $a;
}
