How to query all records in MySQL database using PHP

1. Establish a database connection

Before using PHP to query MySQL, we need to establish a database connection. When establishing a connection, we can use PHP's built-in mysql_connect() function.

<?php
$db_host = &#39;localhost&#39;;    // 数据库服务器名称
$db_user = &#39;username&#39;;     // 数据库用户名
$db_password = &#39;password&#39;; // 数据库密码
$db_name = &#39;database_name&#39;; // 数据库名称

$conn = mysql_connect($db_host, $db_user, $db_password);

if (!$conn) {
    die(&#39;无法连接数据库: &#39; . mysql_error());
}

mysql_select_db($db_name, $conn);

echo &#39;数据库连接成功&#39;;

mysql_close($conn);
?>

2. Query all records

Querying all records contained in the table is the next step after establishing a database connection. We can use the mysql_query() function to execute the query.

The following is a simple code example that uses the mysql_query() function to query all records in a table named "customer":

<?php
$sql = "SELECT * FROM customer";

$result = mysql_query($sql);

if (!$result) {
    die(&#39;查询失败: &#39; . mysql_error());
}

while ($row = mysql_fetch_array($result)) {
    echo $row[&#39;id&#39;] . &#39; &#39; . $row[&#39;name&#39;] . &#39; &#39; . $row[&#39;email&#39;];
    echo "<br />";
}

mysql_free_result($result);
mysql_close($conn);
?>

In the above code, we use mysql_query( ) function executes the SELECT statement and queries all records. Then, we use the mysql_fetch_array() function to get each row of data in the result set and print it to the screen.

The above is the detailed content of How to query all records in MySQL database using PHP. For more information, please follow other related articles on the PHP Chinese website!