PHP connects to the database and reads the data and prints it
<code><span><span><?php</span><span>$link</span> = mysqli_connect(<span>"localhost"</span>,<span>"root"</span>,<span>"root"</span>) <span>or</span><span>die</span>(<span>"Connect error"</span>);
<span>if</span>(<span>$link</span>){
<span>echo</span><span>"Connect success<br>"</span>;
mysqli_select_db(<span>$link</span>, <span>"world"</span>);
<span>$sql</span> = <span>"select * from city"</span>;
<span>$result</span> = mysqli_query(<span>$link</span>, <span>$sql</span>);
<span>$rows</span> = mysqli_num_rows(<span>$result</span>);
<span>$cols</span> = mysqli_num_fields(<span>$result</span>);
<span>echo</span><span>"rows are "</span>.<span>$rows</span>.<span>", cols are "</span>.<span>$cols</span>.<span>"<br>"</span>;
<span>echo</span><span>"<table border='1' align='center' width='80%'>"</span>;
<span>echo</span><span>"<caption>City info</caption>"</span>;
<span>echo</span><span>"<th>ID</th><th>Name</th><th>CountryCode</th><th>District</th><th>Population</th>"</span>;
<span>while</span> (<span>$row</span>=mysqli_fetch_row(<span>$result</span>)){
<span>echo</span><span>"<tr align='center'>"</span>;
<span>foreach</span> (<span>$row</span><span>as</span><span>$data</span>){
<span>echo</span><span>"<td>"</span>.<span>$data</span>.<span>"</td>"</span>;
}
<span>echo</span><span>"</tr>"</span>;
}
<span>echo</span><span>"</table>"</span>;
}<span>else</span> {
<span>echo</span><span>"Connect error"</span>;
}
<span>?></span></span></code>The above introduces PHP to connect to the database and read data and print, including the content. I hope it will be helpful to friends who are interested in PHP tutorials.
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
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
1662
14
1419
52
1311
25
1262
29
1234
24
What are the differences between Huawei GT3 Pro and GT4?
Dec 29, 2023 pm 02:27 PM
Many users will choose the Huawei brand when choosing smart watches. Among them, Huawei GT3pro and GT4 are very popular choices. Many users are curious about the difference between Huawei GT3pro and GT4. Let’s introduce the two to you. . What are the differences between Huawei GT3pro and GT4? 1. Appearance GT4: 46mm and 41mm, the material is glass mirror + stainless steel body + high-resolution fiber back shell. GT3pro: 46.6mm and 42.9mm, the material is sapphire glass + titanium body/ceramic body + ceramic back shell 2. Healthy GT4: Using the latest Huawei Truseen5.5+ algorithm, the results will be more accurate. GT3pro: Added ECG electrocardiogram and blood vessel and safety
Solution to PHP Fatal error: Call to undefined function mysqli_connect()
Jun 23, 2023 am 09:40 AM
When writing web applications using PHP, a MySQL database is often used to store data. PHP provides a way to interact with the MySQL database called MySQLi. However, sometimes when using MySQLi, you will encounter an error message, as shown below: PHPFatalerror:Calltoundefinedfunctionmysqli_connect() This error message means that PHP cannot find my
Fix: Snipping tool not working in Windows 11
Aug 24, 2023 am 09:48 AM
Why Snipping Tool Not Working on Windows 11 Understanding the root cause of the problem can help find the right solution. Here are the top reasons why the Snipping Tool might not be working properly: Focus Assistant is On: This prevents the Snipping Tool from opening. Corrupted application: If the snipping tool crashes on launch, it might be corrupted. Outdated graphics drivers: Incompatible drivers may interfere with the snipping tool. Interference from other applications: Other running applications may conflict with the Snipping Tool. Certificate has expired: An error during the upgrade process may cause this issu simple solution. These are suitable for most users and do not require any special technical knowledge. 1. Update Windows and Microsoft Store apps
PHP PDO vs. mysqli: compare and contrast
Feb 19, 2024 pm 12:24 PM
PDOPDO is an object-oriented database access abstraction layer that provides a unified interface for PHP, allowing you to use the same code to interact with different databases (such as Mysql, postgresql, oracle). PDO hides the complexity of underlying database connections and simplifies database operations. Advantages and Disadvantages Advantages: Unified interface, supports multiple databases, simplifies database operations, reduces development difficulty, provides prepared statements, improves security, supports transaction processing Disadvantages: performance may be slightly lower than native extensions, relies on external libraries, may increase overhead, demo code uses PDO Connect to mysql database: $db=newPDO("mysql:host=localhost;dbnam
What should I do if php cannot connect to mysqli?
Nov 09, 2022 am 10:07 AM
Solution to php unable to connect to mysqli: 1. Open the "php.ini" file; 2. Find "mysqli.reconnect"; 3. Change "mysqli.reconnect = OFF" to "mysqli.reconnect = on".
Detailed tutorial on establishing a database connection using MySQLi in PHP
Jun 04, 2024 pm 01:42 PM
How to use MySQLi to establish a database connection in PHP: Include MySQLi extension (require_once) Create connection function (functionconnect_to_db) Call connection function ($conn=connect_to_db()) Execute query ($result=$conn->query()) Close connection ( $conn->close())
PHP Warning: mysqli_connect(): (HY000/2002): Solution to Connection refused
Jun 23, 2023 am 08:54 AM
If you encounter the following error message when using PHP to connect to a MySQL database: PHPWarning:mysqli_connect():(HY000/2002):Connectionrefused, then you can try to solve this problem by following the steps below. To confirm whether the MySQL service is running normally, you should first check whether the MySQL service is running normally. If the service is not running or fails to start, it may cause a connection refused error. you can
Five selected Go language open source projects to take you to explore the technology world
Jan 30, 2024 am 09:08 AM
In today's era of rapid technological development, programming languages are springing up like mushrooms after a rain. One of the languages that has attracted much attention is the Go language, which is loved by many developers for its simplicity, efficiency, concurrency safety and other features. The Go language is known for its strong ecosystem with many excellent open source projects. This article will introduce five selected Go language open source projects and lead readers to explore the world of Go language open source projects. KubernetesKubernetes is an open source container orchestration engine for automated
