PHP:MySQLi【プロセス向け】操作データベース【接続、ライブラリ構築、テーブル構築、追加、削除、変更、検索、クローズ】
12657 ワード
function println($msg)
{
echo "
";
echo $msg;
}
/** */
$mysql_server_name = "localhost"; // mysql
$mysql_username = "root"; // mysql
$mysql_password = ""; // mysql
$mysql_database = "db2"; // mysql
$mysql_table = "person"; //
/**
*
*/
$con = mysqli_connect($mysql_server_name, $mysql_username, $mysql_password); //
if (!$con) {
die('Could not connect: ' . mysqli_error($con));
}
/**
* :db2
*/
$sql_delete_db = "drop database $mysql_database";
if (mysqli_query($con, $sql_delete_db)) {
println("$sql_delete_db ok");
} else {
println("$sql_delete_db failed:" . mysqli_error($con));
}
/**
* :db2
*/
$sql_create_db = "create database $mysql_database";
if (mysqli_query($con, $sql_create_db)) {
println("create ok");
} else {
println("create failed:" . mysqli_error($con));
}
/**
* ;db2
*/
mysqli_select_db($con, $mysql_database);
/**
* ;person
*/
$sql_create_table = "create table $mysql_table(id int NOT NULL AUTO_INCREMENT,PRIMARY KEY(id),name varchar(15),age int)";
if (mysqli_query($con, $sql_create_table)) {
println("create table ok");
} else {
println("create table failed:" . mysqli_error($con));
}
/**
* (person) ;
*/
$sql_delete = "delete from $mysql_table where age = 200";
if (mysqli_query($con, $sql_delete)) {
println("delete table ok");
} else {
println("delete table failed:" . mysqli_error($con));
}
/**
* (person) ;
*/
$age = rand(12, 80);//
$sql_inset = "insert into $mysql_table (name,age) value ('flying_$age',$age)";
if (mysqli_query($con, $sql_inset)) {
println("insert table ok");
} else {
println("insert table failed:" . mysqli_error($con));
}
/**
* (person) ;
*/
$sql_select = "select * from $mysql_table order by age";
$result = mysqli_query($con, $sql_select);
/** */
while ($row = mysqli_fetch_array($result)) {
println($row['id'] . " " . $row['name'] . " " . $row['age']);
}
$result->close();
/**
* (person) ;
*/
$sql_update = "update $mysql_table set age = 200 where age < 67";
$result = mysqli_query($con, $sql_update);
println($result);
if ($result) {
println("sql_update table ok");
} else {
println("sql_update table failed:" . mysqli_error($con));
}
/**
*
*/
mysqli_close($con);