Example of how PHP uses the PDO abstraction layer to obtain query results-PHP Tutorial-php.cn

Home

Backend Development

PHP Tutorial

Example of how PHP uses the PDO abstraction layer to obtain query results

jacklove

Jun 25, 2018 pm 05:16 PM

pdo php Inquire

This article mainly introduces the method of PHP using PDO abstract layer to obtain query results. It analyzes three common ways of using PDO abstract layer to obtain query results and related function usage skills in the form of examples. Friends in need can refer to the following

The example in this article describes how PHP uses the PDO abstraction layer to obtain query results. Share it with everyone for your reference, the details are as follows:

PHP uses the PDO abstraction layer to obtain query results. There are three main ways:

(1) PDO::query() query.

Look at the following php code:

<?php
//PDO::query()查询
$psql="SELECT * FROM user";
$res = $db->query($psql);
$res->setFetchMode(PDO::FETCH_NUM); //数字索引方式
while ($row = $res->fetch()){
print_r($row);
}
?>

Copy after login

## (2) PDO->exec() processes sql

<?php
//PDO->exec()处理sql
$psql="INSERT INTO user(id , username) values(&#39;&#39; , &#39;张三&#39;)";
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$res = $db->exec($psql);
echo $res;
?>

Copy after login

(3) PDO::prepare() preprocessing execution query

<?php
//PDO::prepare()预处理执行查询
$psql="SELECT * FROM user";
$res = $db->prepare($psql);
$res->execute();
while ($row = $res->fetchAll()) {
print_r($row);
}
?>

Copy after login

setAttribute() The method is to set attributes. Common parameters are as follows:

##PDO::CASE_LOWER

-- Mandatory Column names are lowercasePDO::CASE_NATURAL
-- Column names are in the original wayPDO::CASE_UPPER
-- Force column names to be uppercase

setFetchMode

method to set the type of return value for obtaining the result set. Common parameters are as follows:

PDO::FETCH_ASSOC

-- Associative array FormPDO::FETCH_NUM
-- Numeric index array formPDO::FETCH_BOTH
--Both array forms are available, this is the defaultPDO::FETCH_OBJ
-- According to the form of the object, it is similar to the previous mysql_fetch_object()

The above is summarized as follows:

The query operation is mainly

PDO::query()

, PDO::exec(), PDO::prepare().

PDO->query()

— Process a SQL statement and return a "PDOStatement" PDO->exec()
— Process a SQL statement and returns the number of affected entries

PDO::prepare()

It is mainly a preprocessing operation and needs to be performed through $rs->execute() Process the SQL statements inside

Finally introduce two commonly used functions:

(1)

fetchColumn()

Get the result of a field in the specified record , the default is the first field!

<?php
$psql="SELECT * FROM user";
$res = $db->query($psql);
//获取指定记录里第二个字段结果
$col = $res->fetchColumn(1);
echo $col;
?>

Copy after login

(2)

fetchAll()

Get data from a result set and store it in an associative array

<?php
$psql="SELECT * FROM user";
$res = $db->query($psql);
$res_arr =$res->fetchAll();
print_r($res_arr);
?>

Copy after login

Articles you may be interested in:

Example of PHP method to compress image size and convert to jpg format_php Tips

#PHP Method Example of Remembering Status When Searching_php Tips

laravel project uses twemproxy to deploy redis Complete steps for clustering php instance

The above is the detailed content of Example of how PHP uses the PDO abstraction layer to obtain query results. For more information, please follow other related articles on the PHP Chinese website!

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress images for free

Clothoff.io

AI clothes remover

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Roblox: Grow A Garden - Complete Mutation Guide

4 weeks ago By DDD

Roblox: Bubble Gum Simulator Infinity - How To Get And Use Royal Keys

4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Nordhold: Fusion System, Explained

1 months ago By 尊渡假赌尊渡假赌尊渡假赌

Mandragora: Whispers Of The Witch Tree - How To Unlock The Grappling Hook

4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Clair Obscur: Expedition 33 UE-Sandfall Game Crash? 3 Ways!

2 weeks ago By DDD

Hot Tools

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Hot Topics

Java Tutorial

1677

CakePHP Tutorial

1431

Laravel Tutorial

1334

PHP Tutorial

1279

C# Tutorial

1257

Related knowledge

PHP and Python: Different Paradigms Explained Apr 18, 2025 am 12:26 AM

PHP is mainly procedural programming, but also supports object-oriented programming (OOP); Python supports a variety of paradigms, including OOP, functional and procedural programming. PHP is suitable for web development, and Python is suitable for a variety of applications such as data analysis and machine learning.

Choosing Between PHP and Python: A Guide Apr 18, 2025 am 12:24 AM

PHP is suitable for web development and rapid prototyping, and Python is suitable for data science and machine learning. 1.PHP is used for dynamic web development, with simple syntax and suitable for rapid development. 2. Python has concise syntax, is suitable for multiple fields, and has a strong library ecosystem.

PHP and Python: A Deep Dive into Their History Apr 18, 2025 am 12:25 AM

PHP originated in 1994 and was developed by RasmusLerdorf. It was originally used to track website visitors and gradually evolved into a server-side scripting language and was widely used in web development. Python was developed by Guidovan Rossum in the late 1980s and was first released in 1991. It emphasizes code readability and simplicity, and is suitable for scientific computing, data analysis and other fields.

PHP's Impact: Web Development and Beyond Apr 18, 2025 am 12:10 AM

PHPhassignificantlyimpactedwebdevelopmentandextendsbeyondit.1)ItpowersmajorplatformslikeWordPressandexcelsindatabaseinteractions.2)PHP'sadaptabilityallowsittoscaleforlargeapplicationsusingframeworkslikeLaravel.3)Beyondweb,PHPisusedincommand-linescrip

PHP vs. Python: Use Cases and Applications Apr 17, 2025 am 12:23 AM

PHP is suitable for web development and content management systems, and Python is suitable for data science, machine learning and automation scripts. 1.PHP performs well in building fast and scalable websites and applications and is commonly used in CMS such as WordPress. 2. Python has performed outstandingly in the fields of data science and machine learning, with rich libraries such as NumPy and TensorFlow.

The Continued Use of PHP: Reasons for Its Endurance Apr 19, 2025 am 12:23 AM

What’s still popular is the ease of use, flexibility and a strong ecosystem. 1) Ease of use and simple syntax make it the first choice for beginners. 2) Closely integrated with web development, excellent interaction with HTTP requests and database. 3) The huge ecosystem provides a wealth of tools and libraries. 4) Active community and open source nature adapts them to new needs and technology trends.

What happens if session_start() is called multiple times? Apr 25, 2025 am 12:06 AM

Multiple calls to session_start() will result in warning messages and possible data overwrites. 1) PHP will issue a warning, prompting that the session has been started. 2) It may cause unexpected overwriting of session data. 3) Use session_status() to check the session status to avoid repeated calls.

The Compatibility of IIS and PHP: A Deep Dive Apr 22, 2025 am 12:01 AM

IIS and PHP are compatible and are implemented through FastCGI. 1.IIS forwards the .php file request to the FastCGI module through the configuration file. 2. The FastCGI module starts the PHP process to process requests to improve performance and stability. 3. In actual applications, you need to pay attention to configuration details, error debugging and performance optimization.

See all articles