Connect to OceanBase Database by using the PDO driver

[root]# vim podtest.php
<?php
$servername = "172.30.xx.xxx";
$port = "2881";
$username = "root@mysql";
$password = "xxxxxxx";
$dbname = "test";

// Create a connection
try {
    $conn = new PDO("mysql:host=$servername;port=$port;dbname=$dbname", $username, $password);
    // Set the PDO error mode to "EXCEPTION"
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    echo "Connection succeeded";
} catch(PDOException $e) {
    echo "Connection failed: " . $e->getMessage();
}
?>

[root]# php podtest.php
Connection failed: SQLSTATE[42000] [1049] Unknown database 'test123'

[root]# php podtest.php
Connection succeeded

[root]# vim podtest.php
<?php
$servername = "172.30.xxx.xxx"; // IP address of the MySQL server
$port = "2881"; // Port number of the MySQL server
$username = "root@mysql"; // MySQL username
$password = ""; // MySQL password
$dbname = "test"; // Name of the database to connect to

// Create a connection
try {
    $conn = new PDO("mysql:host=$servername;port=$port;dbname=$dbname", $username, $password);
    // Set the PDO error mode to "EXCEPTION"
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    echo "Connection succeeded";
} catch(PDOException $e) {
    echo "Connection failed: " . $e->getMessage();
}

// Create a table
try {
    $sql = "CREATE TABLE myguests (
    id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    firstname VARCHAR(30) NOT NULL,
    lastname VARCHAR(30) NOT NULL,
    email VARCHAR(50),
    reg_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
    )";
    $conn->exec($sql);
    echo "Table myguests is created successfully";
} catch(PDOException $e) {
    echo "Table creation error: " . $e->getMessage();
}

// Insert data
try {
    $sql = "INSERT INTO myguests (firstname, lastname, email)
    VALUES ('John', 'Doe', 'john@example.com')";
    $conn->exec($sql);
    echo "New record is inserted successfully";
} catch(PDOException $e) {
    echo "Data insertion error: " . $e->getMessage();
}

// Query table
try{
    $sql = "SELECT id, firstname, lastname FROM myguests";
    $stmt = $conn->prepare($sql);
    $stmt->execute();
    $result = $stmt->setFetchMode(PDO::FETCH_ASSOC);
    if ($stmt->rowCount() > 0) {
        // Output data
        while($row = $stmt->fetch()) {
            echo "id: " . $row["id"]. " - Name: " . $row["firstname"]. " " . $row["lastname"]. "<br>";
        }
    } else {
        echo "0 result";
    }
} catch(PDOException $e) {
    echo "Table query error: " . $e->getMessage();
}

// Delete table
try {
    $sql = "DROP TABLE myguests";
    $conn->exec($sql);
    echo "Table myguests is deleted successfully";
} catch(PDOException $e) {
    echo "Table deletion error: " . $e->getMessage();
}

// Close the connection
$conn = null;
?>

[root]# php podtest.php
Connection succeeded. Table myguests is created successfully. New record is inserted successfully. id: 1 - Name: John Doe<br>Table myguests is deleted successfully.