Using ThinkPHP6 Db Facade for MySQL Queries and Executions

Prerequisite: ThinkPHP6 separates database and model operations into ThinkORM.

To use the Db class, import the facade think\facade\Db and call methods via the static entry point Db::.

1. query method executes MySQL SELECT queries.

<?php
$sql = "SELECT * FROM `shop_goods` where status=1";
$query = Db::query($sql);
print_r($query);
?>

2. execute method performs MySQL INSERT and UPDATE operations.

<?php
$execute = Db::execute("INSERT INTO `shop_goods` VALUES (3, 1)");
print_r($execute);
$execute = Db::execute("UPDATE `shop_goods` set `price`='1100' where `id`=3 ");
print_r($execute);
?>