php查询功能测试用例

//连接数据库
$connect = mysqli_connect("localhost","username","password");
//选择数据库
mysqli_select_db($connect,"databasename");
//查询数据
$result = mysqli_query($connect,"SELECT * FROM table_name");

//测试用例一：连接测试
public function test_connection() {
    $host = 'localhost';
    $username = 'root';
    $password = '';
    $database = 'test';

    //测试1：错误的主机名
    $conn = mysqli_connect('error', $username, $password, $database);
    $this->assertFalse($conn);

    //测试2：错误的用户名
    $conn = mysqli_connect($host, 'error', $password, $database);
    $this->assertFalse($conn);

    //测试3：错误的密码
    $conn = mysqli_connect($host, $username, 'error', $database);
    $this->assertFalse($conn);

    //测试4：错误的数据库
    $conn = mysqli_connect($host, $username, $password, 'error');
    $this->assertFalse($conn);

    //测试5：成功连接
    $conn = mysqli_connect($host, $username, $password, $database);
    $this->assertTrue($conn !== false);
}

//测试用例二：数据查询
public function test_data_query() {
    //连接数据库
    $host = 'localhost';
    $username = 'root';
    $password = '';
    $database = 'test';
    $mysqli = mysqli_connect($host, $username, $password, $database);

    //插入测试数据
    mysqli_query($mysqli, "INSERT INTO `users`(`id`, `name`, `email`) VALUES (1,'Bob','bob@test.com')");
    mysqli_query($mysqli, "INSERT INTO `users`(`id`, `name`, `email`) VALUES (2,'Alice','alice@test.com')");

    //测试1：查询全部数据是否正确
    $result = mysqli_query($mysqli, "SELECT * FROM `users`");
    $this->assertEquals(mysqli_num_rows($result), 2);

    //测试2：查询指定条件的人是否正确
    $result = mysqli_query($mysqli, "SELECT * FROM `users` WHERE `name` = 'Bob'");
    $this->assertEquals(mysqli_num_rows($result), 1);

    //测试3：查询不存在的数据是否返回空结果集
    $result = mysqli_query($mysqli, "SELECT * FROM `users` WHERE `name` = 'John'");
    $this->assertEquals(mysqli_num_rows($result), 0);

    mysqli_close($mysqli);
}