


PHP uses pdo to connect to the access database and display data operations in a loop
Jun 05, 2018 pm 04:38 PMThis 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("鏈接錯(cuò)誤!"); //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); //數(shù)字索引方式 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點(diǎn)點(diǎn)通')"); echo $res; ?>
(3)PDO::prepare()
Preprocessing execution query
<?php //PDO::prepare()預(yù)處理執(zhí)行查詢 $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'); //獲取指定記錄里第二個(gè)字段結(jié)果 $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!

Hot AI Tools

Undress AI Tool
Undress images for free

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Clothoff.io
AI clothes remover

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

Hot Article

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

The method to get the current session ID in PHP is to use the session_id() function, but you must call session_start() to successfully obtain it. 1. Call session_start() to start the session; 2. Use session_id() to read the session ID and output a string similar to abc123def456ghi789; 3. If the return is empty, check whether session_start() is missing, whether the user accesses for the first time, or whether the session is destroyed; 4. The session ID can be used for logging, security verification and cross-request communication, but security needs to be paid attention to. Make sure that the session is correctly enabled and the ID can be obtained successfully.

To extract substrings from PHP strings, you can use the substr() function, which is syntax substr(string$string,int$start,?int$length=null), and if the length is not specified, it will be intercepted to the end; when processing multi-byte characters such as Chinese, you should use the mb_substr() function to avoid garbled code; if you need to intercept the string according to a specific separator, you can use exploit() or combine strpos() and substr() to implement it, such as extracting file name extensions or domain names.

UnittestinginPHPinvolvesverifyingindividualcodeunitslikefunctionsormethodstocatchbugsearlyandensurereliablerefactoring.1)SetupPHPUnitviaComposer,createatestdirectory,andconfigureautoloadandphpunit.xml.2)Writetestcasesfollowingthearrange-act-assertpat

In PHP, the most common method is to split the string into an array using the exploit() function. This function divides the string into multiple parts through the specified delimiter and returns an array. The syntax is exploit(separator, string, limit), where separator is the separator, string is the original string, and limit is an optional parameter to control the maximum number of segments. For example $str="apple,banana,orange";$arr=explode(",",$str); The result is ["apple","bana

JavaScript data types are divided into primitive types and reference types. Primitive types include string, number, boolean, null, undefined, and symbol. The values are immutable and copies are copied when assigning values, so they do not affect each other; reference types such as objects, arrays and functions store memory addresses, and variables pointing to the same object will affect each other. Typeof and instanceof can be used to determine types, but pay attention to the historical issues of typeofnull. Understanding these two types of differences can help write more stable and reliable code.

std::chrono is used in C to process time, including obtaining the current time, measuring execution time, operation time point and duration, and formatting analysis time. 1. Use std::chrono::system_clock::now() to obtain the current time, which can be converted into a readable string, but the system clock may not be monotonous; 2. Use std::chrono::steady_clock to measure the execution time to ensure monotony, and convert it into milliseconds, seconds and other units through duration_cast; 3. Time point (time_point) and duration (duration) can be interoperable, but attention should be paid to unit compatibility and clock epoch (epoch)

ToaccessenvironmentvariablesinPHP,usegetenv()orthe$_ENVsuperglobal.1.getenv('VAR_NAME')retrievesaspecificvariable.2.$_ENV['VAR_NAME']accessesvariablesifvariables_orderinphp.iniincludes"E".SetvariablesviaCLIwithVAR=valuephpscript.php,inApach

When encountering the problem that header('Location:...') does not work, the common reasons and solutions are as follows: 1. There is output in advance, causing the header to fail. The solution is to ensure that there is no output before the jump, including spaces, HTML or echo; 2. There is excess output or UTF-8 BOM characters in the include or require file. The file encoding should be checked and saved as "UTF-8 BOM-free"; 3. It is recommended to use ob_start() to turn on the output buffer before the jump, and cooperate with ob_end_flush() to delay the output; 4. After the jump, be sure to add exit to prevent subsequent code execution; 5. Make sure that the header() function call is before all outputs.
