如题所述
<?php
$conn=new MySQLi("db_host","db_username","db_password");
$conn->select_db("db_name");
//查询
$sql="select * from table_name";
//添加
$sql='insert into table_name(column1,column2) values("value1","value2")';
//修改
$sql='update table_name set column1="value1" , column2="value2" where column0="value0"';
//删除
$sql='delete from table_name where column0="value0"';
$conn->query($sql);
?>
$conn=new MySQLi("db_host","db_username","db_password");
$conn->select_db("db_name");
//查询
$sql="select * from table_name";
//添加
$sql='insert into table_name(column1,column2) values("value1","value2")';
//修改
$sql='update table_name set column1="value1" , column2="value2" where column0="value0"';
//删除
$sql='delete from table_name where column0="value0"';
$conn->query($sql);
?>
温馨提示:答案为网友推荐,仅供参考
第1个回答 推荐于2017-09-26
// 查询
SELECT
*
FROM
tableName
WHERE
// ... 你的查询条件, 如果不添加查询条件将查询所有数据
// 删除
DELETE
FROM
tableName
WHERE
// ... 你的删除条件, 如果不添加将删除所有数据
// 添加
INSERT INTO tableName (id, name, addr) // 需要添加的字段
VALUES (1, 'hello', 'china'); // 赋值本回答被网友采纳
SELECT
*
FROM
tableName
WHERE
// ... 你的查询条件, 如果不添加查询条件将查询所有数据
// 删除
DELETE
FROM
tableName
WHERE
// ... 你的删除条件, 如果不添加将删除所有数据
// 添加
INSERT INTO tableName (id, name, addr) // 需要添加的字段
VALUES (1, 'hello', 'china'); // 赋值本回答被网友采纳
第2个回答 2017-09-25
<?php
$conn=new MySQLi("db_host","db_username","db_password");
$conn->select_db("db_name");
//查询
$sql="select * from table_name";
//添加
$sql='insert into table_name(column1,column2) values("value1","value2")';
//修改
$sql='update table_name set column1="value1" , column2="value2" where column0="value0"';
//删除
$sql='delete from table_name where column0="value0"';
$conn->query($sql);
?>
$conn=new MySQLi("db_host","db_username","db_password");
$conn->select_db("db_name");
//查询
$sql="select * from table_name";
//添加
$sql='insert into table_name(column1,column2) values("value1","value2")';
//修改
$sql='update table_name set column1="value1" , column2="value2" where column0="value0"';
//删除
$sql='delete from table_name where column0="value0"';
$conn->query($sql);
?>