首页 / MYSQL / MYSQLI - mysqli

MYSQLI - mysqli

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了MYSQLI - mysqli，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含9649字，纯文字阅读大概需要14分钟。

内容图文

PHP MysqlI操作数据库

1连接数据库.
//procedural style
$mysqli =  mysqli_connect(‘host‘,‘username‘,‘password‘,‘database_name‘);

//object oriented style (recommended)
$mysqli = new mysqli(‘host‘,‘username‘,‘password‘,‘database_name‘);

推荐下面的方式
<?php
//Open a new connection to the MySQL server
$mysqli = new mysqli(‘host‘,‘username‘,‘password‘,‘database_name‘);

//Output any connection error
if ($mysqli->connect_error) {
    die(‘Error : (‘. $mysqli->connect_errno .‘) ‘. $mysqli->connect_error);
}

?>

2.选择多行
mysqli_fetch_assoc() : Below is the code to fetch multiple records as an associative array. The returned array holds the strings fetched from database, where the column names will be the key used to access the internal data. As you can see below, data is displayed in an HTML table.
<?php
//Open a new connection to the MySQL server
$mysqli = new mysqli(‘host‘,‘username‘,‘password‘,‘database_name‘);

//Output any connection error
if ($mysqli->connect_error) {
    die(‘Error : (‘. $mysqli->connect_errno .‘) ‘. $mysqli->connect_error);
}

//MySqli Select Query
$results = $mysqli->query("SELECT id, product_code, product_desc, price FROM products");

print ‘<table border="1">‘;
while($row = $results->fetch_assoc()) {
    print ‘<tr>‘;
    print ‘<td>‘.$row["id"].‘</td>‘;
    print ‘<td>‘.$row["product_code"].‘</td>‘;
    print ‘<td>‘.$row["product_name"].‘</td>‘;
    print ‘<td>‘.$row["product_desc"].‘</td>‘;
    print ‘<td>‘.$row["price"].‘</td>‘;
    print ‘</tr>‘;
}
print ‘</table>‘;

// Frees the memory associated with a result
$results->free();

// close connection
$mysqli->close();
?> 3.选择
fetch_array() : Function returns an array of both mysqli_fetch_row and mysqli_fetch assoc merged together, it is an extended version of the mysqli_fetch_row() function and both numeric and string can be used as keys to access the data.
<?php
//Open a new connection to the MySQL server
$mysqli = new mysqli(‘host‘,‘username‘,‘password‘,‘database_name‘);

//Output any connection error
if ($mysqli->connect_error) {
    die(‘Error : (‘. $mysqli->connect_errno .‘) ‘. $mysqli->connect_error);
}

//MySqli Select Query
$results = $mysqli->query("SELECT id, product_code, product_desc, price FROM products");

print ‘<table border="1"‘;
while($row = $results->fetch_array()) {
    print ‘<tr>‘;
    print ‘<td>‘.$row["id"].‘</td>‘;
    print ‘<td>‘.$row["product_code"].‘</td>‘;
    print ‘<td>‘.$row["product_name"].‘</td>‘;
    print ‘<td>‘.$row["product_desc"].‘</td>‘;
    print ‘<td>‘.$row["price"].‘</td>‘;
    print ‘</tr>‘;

}
print ‘</table>‘;

// Frees the memory associated with a result
$results->free();
// close connection
$mysqli->close();
?> 4.选择
fetch_object() : To fetch database result set as an objects, just use MySqli fetch_object(). The attributes of the object represent the names of the fields found within the result set.
<?php
//Open a new connection to the MySQL server
$mysqli = new mysqli(‘host‘,‘username‘,‘password‘,‘database_name‘);

//Output any connection error
if ($mysqli->connect_error) {
    die(‘Error : (‘. $mysqli->connect_errno .‘) ‘. $mysqli->connect_error);
}

//MySqli Select Query
$results = $mysqli->query("SELECT id, product_code, product_desc, price FROM products");

print ‘<table border="1">‘;
while($row = $results->fetch_object()) {
    print ‘<tr>‘;
    print ‘<td>‘.$row->id.‘</td>‘;
    print ‘<td>‘.$row->product_code.‘</td>‘;
    print ‘<td>‘.$row->product_name.‘</td>‘;
    print ‘<td>‘.$row->product_desc.‘</td>‘;
    print ‘<td>‘.$row->price.‘</td>‘;
    print ‘</tr>‘;
}

print ‘</table>‘;

// close connection
$mysqli->close();
?> 5.选择单行
<?php
//Open a new connection to the MySQL server
$mysqli = new mysqli(‘host‘,‘username‘,‘password‘,‘database_name‘);

//Output any connection error
if ($mysqli->connect_error) {
    die(‘Error : (‘. $mysqli->connect_errno .‘) ‘. $mysqli->connect_error);
}

//chained PHP functions
$product_name = $mysqli->query("SELECT product_name FROM products WHERE id = 1")->fetch_object()->product_name;
print $product_name; //output value

$mysqli->close();
?> 6.选择行数
<?php //Open a new connection to the MySQL server
$mysqli = new mysqli(‘host‘,‘username‘,‘password‘,‘database_name‘);

//Output any connection error
if ($mysqli->connect_error) {
    die(‘Error : (‘. $mysqli->connect_errno .‘) ‘. $mysqli->connect_error);
}

//get total number of records
$results = $mysqli->query("SELECT COUNT(*) FROM users");
$get_total_rows = $results->fetch_row(); //hold total records in variable

$mysqli->close();
?> 7.选择预处理
$search_product = "PD1001"; //product id

//create a prepared statement
$query = "SELECT id, product_code, product_desc, price FROM products WHERE product_code=?";
$statement = $mysqli->prepare($query);

//bind parameters for markers, where (s = string, i = integer, d = double,  b = blob)
$statement->bind_param(‘s‘, $search_product);

//execute query
$statement->execute();

//bind result variables
$statement->bind_result($id, $product_code, $product_desc, $price);

print ‘<table border="1">‘;

//fetch records
while($statement->fetch()) {
    print ‘<tr>‘;
    print ‘<td>‘.$id.‘</td>‘;
    print ‘<td>‘.$product_code.‘</td>‘;
    print ‘<td>‘.$product_desc.‘</td>‘;
    print ‘<td>‘.$price.‘</td>‘;
    print ‘</tr>‘;

}
print ‘</table>‘;

//close connection
$statement->close(); $search_ID = 1;
$search_product = "PD1001";

$query = "SELECT id, product_code, product_desc, price FROM products WHERE ID=? AND product_code=?";
$statement = $mysqli->prepare($query);
$statement->bind_param(‘is‘, $search_ID, $search_product);
$statement->execute();
$statement->bind_result($id, $product_code, $product_desc, $price);

print ‘<table border="1">‘;
while($statement->fetch()) {
    print ‘<tr>‘;
    print ‘<td>‘.$id.‘</td>‘;
    print ‘<td>‘.$product_code.‘</td>‘;
    print ‘<td>‘.$product_desc.‘</td>‘;
    print ‘<td>‘.$price.‘</td>‘;
    print ‘</tr>‘;

}
print ‘</table>‘;

//close connection
$statement->close(); 8.插入数据库
<?php
//values to be inserted in database table
$product_code = ‘"‘.$mysqli->real_escape_string(‘P1234‘).‘"‘;
$product_name = ‘"‘.$mysqli->real_escape_string(‘42 inch TV‘).‘"‘;
$product_price = ‘"‘.$mysqli->real_escape_string(‘600‘).‘"‘;

//MySqli Insert Query
$insert_row = $mysqli->query("INSERT INTO products (product_code, product_name, price) VALUES($product_code, $product_name, $product_price)");

32432432 if($insert_row){
    print ‘Success! ID of last inserted record is : ‘ .$mysqli->insert_id .‘<br />‘;
}else{
    die(‘Error : (‘. $mysqli->errno .‘) ‘. $mysqli->error);
}

?> 9.插入预处理
//values to be inserted in database table
$product_code = ‘P1234‘;
$product_name = ‘42 inch TV‘;
$product_price = ‘600‘;

$query = "INSERT INTO products (product_code, product_name, price) VALUES(?, ?, ?)";
$statement = $mysqli->prepare($query);

//bind parameters for markers, where (s = string, i = integer, d = double,  b = blob)
$statement->bind_param(‘sss‘, $product_code, $product_name, $product_price);

if($statement->execute()){
    print ‘Success! ID of last inserted record is : ‘ .$statement->insert_id .‘<br />‘;
}else{
    die(‘Error : (‘. $mysqli->errno .‘) ‘. $mysqli->error);
}
$statement->close(); 10.批量插入
//product 1
$product_code1 = ‘"‘.$mysqli->real_escape_string(‘P1‘).‘"‘;
$product_name1 = ‘"‘.$mysqli->real_escape_string(‘Google Nexus‘).‘"‘;
$product_price1 = ‘"‘.$mysqli->real_escape_string(‘149‘).‘"‘;

//product 2
$product_code2 = ‘"‘.$mysqli->real_escape_string(‘P2‘).‘"‘;
$product_name2 = ‘"‘.$mysqli->real_escape_string(‘Apple iPad 2‘).‘"‘;
$product_price2 = ‘"‘.$mysqli->real_escape_string(‘217‘).‘"‘;

//product 3
$product_code3 = ‘"‘.$mysqli->real_escape_string(‘P3‘).‘"‘;
$product_name3 = ‘"‘.$mysqli->real_escape_string(‘Samsung Galaxy Note‘).‘"‘;
$product_price3 = ‘"‘.$mysqli->real_escape_string(‘259‘).‘"‘;

//Insert multiple rows
$insert = $mysqli->query("INSERT INTO products(product_code, product_name, price) VALUES
($product_code1, $product_name1, $product_price1),
($product_code2, $product_name2, $product_price2),
($product_code3, $product_name3, $product_price3)");

if($insert){
    //return total inserted records using mysqli_affected_rows
    print ‘Success! Total ‘ .$mysqli->affected_rows .‘ rows added.<br />‘;
}else{
    die(‘Error : (‘. $mysqli->errno .‘) ‘. $mysqli->error);
} 11.更新删除
//MySqli Update Query
$results = $mysqli->query("UPDATE products SET product_name=‘52 inch TV‘, product_code=‘323343‘ WHERE ID=24");

//MySqli Delete Query
//$results = $mysqli->query("DELETE FROM products WHERE ID=24");

if($results){
    print ‘Success! record updated / deleted‘;
}else{
    print ‘Error : (‘. $mysqli->errno .‘) ‘. $mysqli->error; }
12.预处理
$product_name = ‘52 inch TV‘;
$product_code = ‘9879798‘;
$find_id = 24;

$query = "UPDATE products SET product_name=?, product_code=? WHERE ID=?";
$statement = $mysqli->prepare($query);

//bind parameters for markers, where (s = string, i = integer, d = double,  b = blob)
$results =  $statement->bind_param(‘ssi‘, $product_name, $product_code, $find_id);

if($results){
    print ‘Success! record updated‘;
}else{
    print ‘Error : (‘. $mysqli->errno .‘) ‘. $mysqli->error;
} 13.删除

//MySqli Delete Query
$results = $mysqli->query("DELETE FROM products WHERE added_timestamp < (NOW() - INTERVAL 1 DAY)");

if($results){
    print ‘Success! deleted one day old records‘;
}else{
    print ‘Error : (‘. $mysqli->errno .‘) ‘. $mysqli->error;
}

MYSQLI - mysqli

标签：

本文系统来源：http://www.cnblogs.com/KTblog/p/5350276.html

内容总结

以上是互联网集市为您收集整理的MYSQLI - mysqli全部内容，希望文章能够帮你解决MYSQLI - mysqli所遇到的程序开发问题。如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容，请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

扫描二维码推送至手机访问。

本文链接：https://qyyshop.com/info/461210.html

来源：【匿名】

【上一篇】转：mysql 索引【下一篇】用IE远程创建Mysql数据库的简易程序

更多 ►

【MYSQLI - mysqli】教程文章相关的互联网学习教程文章

phpmyadmin提示mysqli_real_connect(): (HY000/2002): No such file or directory错误的解决办法

phpmyadmin上传到网站目录后提示解决phpmyadmin mysqli_real_connect(): (HY000/2002): No such file or directory的错误，解决方法把phpmyadmin目录中的配置文件config.sample.inc.php改成config.inc.php 打开编辑config.inc.php 找到： $cfg[‘Servers‘][$i][‘host‘] = ‘localhost‘; 改成： $cfg[‘Servers‘][$i][‘host‘] = ‘127.0.0.1‘; 再次刷新页面就不会出现mysqli_real_connect(): (HY000/2002): No such file or...

利用mysql和mysqli取得mysql的所有数据库和库中的所有表【代码】

功能：利用mysql和mysqli两种连接数据库的方法，取得Mysql服务器上的所有数据库和库中的所有表。环境：自己用分开安装apache mysql php搭建的环境操作系统是：windows 10代码如下：<?php/** * mysqli op mysql demo *//** * 公用函数*//** * 功能：列出一个数据库的所有表* @param $dbname * @param $con */function list_tables($dbname,$con) { mysql_select_db($dbname,$con) or die("选择数据库失败!"); $re...

mysql使用mysqldump 与 mysqlimport进行数据库迁移

1.导入数据库1）sourcesource /home/platvt/product/pc2_create_tables.sql2）mysqlimport使用mysqlimport导入数据：出现情况：（1）出现 Error: 1146[platvt@qa-qd-62-180 tmp]$ mysqlimport -uroot -p --fields-terminated-by=‘\t‘ test students Enter password: mysqlimport: Error: 1146, Table ‘test.students‘ doesn‘t exist, when using table: students在导入之前必须数据库里面有对应的表，所以必须先在数据库里面...

PHP mysqli扩展库预处理技术的使用分析

1、使用mysqli扩展库预处理技术 mysqli stmt 向数据库添加3个用户复制代码代码如下:<?php //mysqli扩展库预处理技术 mysqli stmt 向数据库添加3个用户 //1、创建mysqli对象 $mysqli = new MySQLi("localhost","root","root","test"); if($mysqli->connect_error){ die($mysqli->conncet_error); } //2、创建预编译对象 $sql="insert into user1(name,password,email,age) values(?,?,?,?)"; $m...

MySql总是弹出一个mySqlInstallerConsole的窗口【图】

MySQLInstallerConsole.exe程序偶尔自动弹出执行的问题。这是一条安装命令，Installing MYSQL 5.7 using MySQLInstallerConsole.exe 使用它可以设置一些下载安装包，当然使用的是默认安装不需人工干预。关掉它也没有什么影响，win10状态下，从开始---->所有应用----->管理工具----->任务计划程序----》左侧任务计划程序库文件夹，展开文件夹----》mYsql子文件夹installer，点击。在右侧窗口右击击鼠标禁用即可，见下图。650) this....

php+mysqli批量查询多张表数据的方法

本文实例讲述了php+mysqli批量查询多张表数据的方法。分享给大家供大家参考。具体实现方法如下：注意这里使用到了两个新的函数multi_query与store_result，具体代码如下：复制代码代码如下:<?php //1、创建数据库连接对象 $mysqli = new MySQLi("localhost","root","123456","liuyan"); if($mysqli->connect_error){ die($mysqli->connect_error); } $mysqli->query("set names ‘GBK‘"); //2、查询多个数据库表 $sqls = "selec...

php使用mysql和mysqli连接查询数据【代码】

mysql：<?php $code = $_POST[‘code‘]; $status = ""; $success = ""; $scookies = "";try {$dbname="root";$dbpass="root";$dbhost="127.0.0.1";$dbdatabase="mysql";//生成一个连接$db_connect=mysql_connect($dbhost,$dbname,$dbpass);//选择一个需要操作的数据库mysql_select_db($dbdatabase,$db_connect);// 获取查询结果$strsql="select * from `go_member_addmoney_record` where `code` = ‘$code‘ limit 1";$result=m...

PDO PDO_MYSQL MYSQLI MYSQL 的区别

MYSQL,MYSQLI 这两个扩展本身就是访问MYSQL数据库的驱动PDO则是一个抽象层概念PDO_MYSQL 和 MySQL Native(mysqlnd)是实现了PDO接口的MYSQL数据库驱动从下表可以看出他们之间是怎样的并列关系 PHP的mysqli扩展PDO (使用PDO MySQL驱动和MySQL Native驱动)PHP的mysql扩展引入的PHP版本5.05.03.0之前PHP5.x是否包含是是是MySQL开发状态活跃在PHP5.3中活跃仅维护在MySQL新项目中的建议使用程度建议 - 首选建议不建议API的字符集支持是是...

LOAD DATA INFILE & mysqlimport

+++++++++++++++++++++++++++++++++++++++++++++mysqlimport+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++其实如果用mysqlimport是mysql数据库提供的一个命令行程序，从本质来说j load data infile的命令接口，而且大多数的选项都和load data infile语法相同。shell>mysqlimport [option] db_name testfile1 [testfile2 ...] select into outfile 注意保持时以表名加.txt，以便恢复。和load data infile不同的是，...

mysqli扩展库的预处理技术 mysqli stmt【代码】【图】

思路原理代码如下： 1 <?php2//预编译演示3 //需求: 请使用预处理的方式，向数据库添加三个用户4 //1.创建mysqli对象 5$mysqli=new MySQLi("localhost","root","hsp123","test");6//2.创建预编译对象 7 $sql="insert into user1 (name,password,email,age) values(?,?,?,?)";8$mysqli_stmt=$mysqli->prepare($sql) or die($mysqli->error);9//绑定参数10$name="小倩"; 11$password="xiaoqian"; 12$email="aa@sohu.co...

PHP-MySQL,PHP-MySQLi,PDO的差异【代码】

PHP-MySQL是PHP操作MySQL数据库最原始的Extension ，PHP-MySQLi的i代表Improvement ，提供了更加高级的功能，就Extension而言，本身也增加了安全性。而PDO(PHP Data Object) 则是提供了一个 Abstraction Layer来操作数据库。我们通过代码来初步比较它们之间的差异。　　先来看一段PHP-MySQL的通用代码：<?phpmysql_connect($db_host, $db_user, $db_password);mysql_select_db($dn_name);$result = mysql_query("SELECT `name` FRO...

mysqli常用方法

//返回前一次 MySQL 操作（SELECT、INSERT、UPDATE、REPLACE、DELETE）所影响的记录行数。 //一个 > 0 的整数表示所影响的记录行数。0 表示没有受影响的记录。-1 表示查询返回错误。 int $mysqli->affected_rows; //返回MySQL客户端版本 int $mysqli->client_version; //返回最近查询的列数。 int $mysqli->field_count; //返回 MySQL 服务器主机名和连接类型。 string $mysqli->host_info; //返回MySQL服务器的版本号 str...

mysqli 封装【代码】

<?php//header header(‘content-type:text/html;charset=UTF-8‘);class DB {//定义属性private $host;//主机名private $port;//端口号private $name;//用户名private $pass;//密码private $dbname;//数据库名private $charset;//设置字符集private $link;//连接数据库private static $instance;//初始化构造函数private function __construct($arr = array()){$this->host = isset($arr[‘host‘]) ? $arr[‘host‘] : ‘local...

mysqli面向过程练手【代码】

1 代码:2//1.得到mysqli连接 3header("Content-type: text/html;charset=utf-8");4$mysqli=mysqli_connect("localhost","root","root","test");5if(!$mysqli){6die("连接失败".mysqli_connnect_error($mysqli));7 }8//2.向数据库发送sql语句(ddl,dml dql ...) 9$sql="select * from user1"; 10$res=mysqli_query($mysqli,$sql); 11//var_dump($res); 12 //3.处理得到的结果 13 //循环取出$res中的数据mysqli_fet...

PHP操作数据库出现错误：mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in【代码】

原因在于你操作数据库出错了，但是却没有对应的出错处理。解决方法是，在$result = mysqli_query($conn, $sql);后加上这样一段代码：if (!$result) {printf("Error: %s\n", mysqli_error($conn));exit(); }之后刷新页面查看具体错误信息。参考链接：1. https://blog.csdn.net/weixin_41470917/article/details/843305812. https://www.cnblogs.com/cc18/p/6150335.html原文：https://www.cnblogs.com/lfri/p/12229694.html

MYSQL - 技术教程分类

MySQL 教程 MySQL 安装 MySQL 管理 MySQL PHP 语法 MySQL 连接 MySQL 创建数据库 MySQL 删除数据库 MySQL 选择数据库 MySQL 数据类型 MySQL 创建数据表 MySQL 删除数据表 MySQL 插入数据 MySQL 查询数据 MySQL WHERE 子句 MySQL UPDATE 更新 MySQL DELETE 语句 MySQL LIKE 子句 MySQL UNION MySQL 排序 MySQL 分组 MySQL 连接的使用 MySQL NULL 值处理 MySQL 事务 MySQL ALTER命令 MySQL 索引 MySQL 临时表 MySQL 复制表 MySQL 元数据 MySQL 序列使用 MySQL 处理重复数据 MySQL 及 SQL 注入 MySQL 导出数据 MySQL 导入数据 MySQL 函数 MySQL 运算符 mysql 全部

MYSQL - 最热教程

sql分组取最大记录方法 mysql如何设置默认值 mysql创建数据表时指定默认值教程 MySQL 5.7 的初始化操作（root初始密码...Oracle中合并数据集(多行变一行)mysql 相同内容的字段合并为一条的方法解决mysql设置时区时的错误Unknown or ...解决ubuntu下mysql的'Access denied fo...ubuntu系统中MysqlERROR1045(28000)报错...mysql数据库设置不区分大小写

首页 / MYSQL / MYSQLI - mysqli

MYSQLI - mysqli

内容导读

内容图文

PHP MysqlI操作数据库

内容总结

内容备注

内容手机端

【MYSQLI - mysqli】教程文章相关的互联网学习教程文章

MYSQL - 技术教程分类

MYSQL - 最新教程

MYSQL - 最热教程