


PHP uses pdo to connect to the access database and display data operations in a loop
This article mainly introduces the operation of PHP using pdo to connect to the access database and display the data in a loop. It analyzes in detail the operation skills and related operations of PHP using pdo to connect to the access database, query, execute sql statements, preprocessing, etc. in the form of examples. Notes, friends in need can refer to
This article describes the example of PHP using pdo to connect to the access database and display the data in a loop. Share it with everyone for your reference, the details are as follows:
PDO connection and query:
try { $conn = new PDO("odbc:driver={microsoft access driver (*.mdb)}; dbq=".realpath("MyDatabase.mdb")) or die("链接错误!"); //echo "链接成功!"; } catch(PDOException $e){ echo $e->getMessage(); } $sql = "select * from users";
1. foreach()
Method
foreach ($conn->query($sql) as $row) { $row["UserID"]; $row["UserName"]; $row["UserPassword"]; }
2. while()
Method
$rs = $conn->query($sql); $rs->setFetchMode(PDO::FETCH_NUM); while($row=$rs->fetch()){ $row[0]; $row[1]; $row[2]; }
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()查询 $res = $db->query('select * from user'); $res->setFetchMode(PDO::FETCH_NUM); //数字索引方式 while ($row = $res->fetch()){ print_r($row); } ?>
(2)PDO->exec()
Processing sql
<?php //PDO->exec()处理sql $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $res = $db->exec("insert into user(id,name) values('','php点点通')"); echo $res; ?>
(3)PDO::prepare()
Preprocessing execution query
<?php //PDO::prepare()预处理执行查询 $res = $db->prepare("select * from user"); $res->execute(); while ($row = $res->fetchAll()) { print_r($row); } ?>
setAttribute()
The method is to set attributes. Common parameters are as follows:
PDO::CASE_LOWER -- Force column names to be lowercase
PDO::CASE_NATURAL -- Column names are in original form
PDO::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 form
PDO::FETCH_NUM -- Numeric index array form
PDO::FETCH_BOTH -- Both array forms are available, this is the default
PDO::FETCH_OBJ -- Follow The form of the object 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 entriesPDO::prepare()
Mainly a preprocessing operation, you need to execute the SQL statement in the preprocessing through $rs->execute()
Finally, two commonly used functions are introduced:
(1)fetchColumn()
Get the result of a field in the specified record, the default is the first one Field!
<?php $res = $db->query('select * from user'); //获取指定记录里第二个字段结果 $col = $res->fetchColumn(1); echo $col; ?>
(2)fetchAll()
, get data from a result set, and then store it in an associative array
<?php $res = $db->query('select * from user'); $res_arr =$res->fetchAll(); print_r($res_arr); ?>
Related recommendations:
PHP ADODB generates HTML table function rs2html function [with error handling function usage]
Example of PHP using regular expressions to filter illegal strings
# #
The above is the detailed content of PHP uses pdo to connect to the access database and display data operations in a loop. For more information, please follow other related articles on the PHP Chinese website!

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.

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 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 remains important in the modernization process because it supports a large number of websites and applications and adapts to development needs through frameworks. 1.PHP7 improves performance and introduces new features. 2. Modern frameworks such as Laravel, Symfony and CodeIgniter simplify development and improve code quality. 3. Performance optimization and best practices further improve application efficiency.

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

PHP type prompts to improve code quality and readability. 1) Scalar type tips: Since PHP7.0, basic data types are allowed to be specified in function parameters, such as int, float, etc. 2) Return type prompt: Ensure the consistency of the function return value type. 3) Union type prompt: Since PHP8.0, multiple types are allowed to be specified in function parameters or return values. 4) Nullable type prompt: Allows to include null values and handle functions that may return null values.

In PHP, use the clone keyword to create a copy of the object and customize the cloning behavior through the \_\_clone magic method. 1. Use the clone keyword to make a shallow copy, cloning the object's properties but not the object's properties. 2. The \_\_clone method can deeply copy nested objects to avoid shallow copying problems. 3. Pay attention to avoid circular references and performance problems in cloning, and optimize cloning operations to improve efficiency.

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.


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

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

WebStorm Mac version
Useful JavaScript development tools

Dreamweaver CS6
Visual web development tools

Atom editor mac version download
The most popular open source editor

DVWA
Damn Vulnerable Web App (DVWA) is a PHP/MySQL web application that is very vulnerable. Its main goals are to be an aid for security professionals to test their skills and tools in a legal environment, to help web developers better understand the process of securing web applications, and to help teachers/students teach/learn in a classroom environment Web application security. The goal of DVWA is to practice some of the most common web vulnerabilities through a simple and straightforward interface, with varying degrees of difficulty. Please note that this software

Safe Exam Browser
Safe Exam Browser is a secure browser environment for taking online exams securely. This software turns any computer into a secure workstation. It controls access to any utility and prevents students from using unauthorized resources.