January 2021
Intermediate to advanced
505 pages
9h 45m
Chinese
Content preview from PHP编程：第4版
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
MySQLi
对象接口
｜
225
如果你对面向对象的接口和概念不是很熟悉，请先复习第
6
章再深入本节。
既然此面向对象的接口通过标准安装配置被内置到
PHP
中（只需在
PHP
环境中激活
MySQLi
扩展），要想使用它，第一步要做的就是实例化它的类，代码如下所示 ：
$db = new mysqli(
host
,
user
,
password
,
databaseName
);
在这个例子中，我们有一个名叫
library
的数据库，假设用户名为
petermac
，密码为
1q2w3e9i8u7y
。实际代码如下
：
$db = new mysqli("localhost", "petermac", "1q2w3e9i8u7y", "library");
这样我们就能在
PHP
代码里访问数据库引擎本身了。我们会在后面访问指定的数据库表
和其他数据。一旦这个类被实例化到变量
$db
中，我们就可以用此对象的方法来继续做
数据库的工作。
向数据库
library
中插入一本新书的简明代码如下所示
：
$db = new mysqli("localhost", "petermac", "1q2w3e9i8u7y", "library");
$sql = "INSERT INTO books (authorid, title, ISBN, pub_year, available)
VALUES (4, 'I, Robot', '0-553-29438-5', 1950, 1)";
if ($db->query($sql)) {
echo ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.