php sql 讀取寫入操作數據庫

即將學習面向對象，所以呢，一些代碼需要刪除，這裏做一下記錄
這串代碼主要用於帝國數據庫的寫入操作等等

<?php
// header('content-type:text/html;charset=utf-8;');
// header('content-type:application/json;charset=utf-8');
define('DB_NAME', 'rming');
define('DB_USER', 'rming');
define('DB_PASSWORD', 'Px6nCaaYESbMHmST');
define('DB_HOST', 'localhost');
define('DB_CHARSET', 'utf8');
define('DB_PREFIX', 'phome_');

// 檢測連接
if (!$conn = @mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME)) {
    die("<b>PHP鏈接MYSQL數據庫出現錯誤！請檢查配置！</b>");
}
//選擇數據庫
if(!mysqli_select_db($conn,DB_NAME)){
    die("<b>PHP選擇MYSQL數據庫出現錯誤！請檢查配置！</b>");
}
$pages = 300;

//設置字符集
mysqli_set_charset($conn,DB_CHARSET);

$id = $_GET['id']-1;

//執行SQL語句
$select = mysqli_query($conn,'SELECT * FROM `phome_author` ORDER BY `id` ASC  limit '.$pages*$id.','.$pages.'');
$where = '';
while($arr = mysqli_fetch_array($select)){
    $where .= "(NULL, '$arr[booker]', '', '')".',';
}

$where = rtrim($where,',');
$where = "INSERT INTO `phome_booker` (`id`, `booker`, `bookerurl`, `bookid`) VALUES " . $where;
echo $where;
// $arr = mysqli_fetch_all($select,MYSQLI_ASSOC);
// print_r(json_encode($arr));

// 
//關閉數據庫
mysqli_close($conn);