Lindorm:Développer des applications avec PHP

$lindorm_addr="ld-uf6k8yqb741t3****-proxy-sql-lindorm-public.lindorm.rds.aliyuncs.com";
$lindorm_username="user";
$lindorm_password="test";
$lindorm_database="default";
$lindorm_port=33060;

<?php

// The MySQL-compatible endpoint for LindormTable.
$lindorm_addr="ld-uf6k8yqb741t3****-proxy-sql-lindorm-public.lindorm.rds.aliyuncs.com";
// The username for the LindormTable connection.
$lindorm_username="user";
// The password for the LindormTable connection.
$lindorm_password="test";
// The name of the database to connect to.
$lindorm_database="default";
// The port for the MySQL protocol of LindormTable.
$lindorm_port=33060;

// Connect to LindormTable.
$lindorm_conn = mysqli_connect(
    $lindorm_addr,
    $lindorm_username,
    $lindorm_password,
    $lindorm_database,
    $lindorm_port
);
if (!$lindorm_conn) {
    printf("Can't connect to Lindorm Server. Errorcode: %s \n", mysqli_error($lindorm_conn));
    exit;
} else {
    printf("connect to Lindorm successfully\n");
}

// Create a table.
$create_table = "create table if not exists user_test(id int, name varchar, age int, primary key(id))";
if (mysqli_query($lindorm_conn, $create_table)) {
    printf("create table successfully\n");
} else {
    printf("create table error: %s \n", mysqli_error($lindorm_conn));
    exit;
}

// Insert data. LindormTable uses "upsert into" instead of standard INSERT INTO.
$insert_sql = "upsert into user_test(id, name, age) values(1, 'zhangsan', 17)";
if (mysqli_query($lindorm_conn, $insert_sql)) {
    printf("insert data successfully\n");
} else {
    printf("insert data error: %s \n", mysqli_error($lindorm_conn));
    exit;
}

// Query data.
$select_sql = "select * from user_test";
$result = mysqli_query($lindorm_conn, $select_sql);
while ($row = mysqli_fetch_array($result)) {
    printf("id %d\n", $row["id"]);
    printf("name %s\n", $row["name"]);
    printf("age %d\n", $row["age"]);
}

?>

connect to Lindorm successfully
create table successfully
insert data successfully
id 1
name zhangsan
age 17