How to query mysql data display in php

How to query MySQL data display in php: 1. Connect to the database server; 2. Set the character set so that the page encoding is consistent with the database encoding; 3. Define database command query; 4. Execute database records; 5. Display The data results are enough.

The operating environment of this article: windows7 system, PHP7.1 version, DELL G3 computer

How does php query mysql data display?

PHP MYSQL database query

1. Basic code

mysql_connect(): used to establish a connection with the MYSQL database, there are 5 parameters, usually only the first 3 parameters are used. The three parameters are the MySQL server address, username and password.

mysql_select_db(): Used to specify the database to be operated. If the database to be operated has not been created, you must first create the database and then create the tables in the database.

mysql_query(): A dedicated function for query instructions. All SQL statements are executed through it and the result set is returned.

mysql_fetch_row(): Get a row from the result set as enumeration data, get a row of data from the result set associated with the specified result identifier and return it as an array.

mysql_fetch_array(): Get a row from the result set as an associative array, or a numeric array, or both. In addition to storing the data in the array as a numeric index, you can also use the data as an associative index. Save, using field name as key name.

mysql_fetch_object(): Get a row from the result set as an object, and use the field name as an attribute.

mysql_fetch_assoc(): Gets a row from the result set as an associative array, which means that this function cannot use the index to get the value like mysql_fetch_row, but can only use the field name to get the value.

mysql_num_rows(): Get the number of rows in the result set queried by the select statement

2. Example

<?php
    /* 连接数据库服务器，用or die的目的为了即使连接错误，系统不会继续执行，而是返回错误*/
    $link=mysql_connect("localhost","root","12345678") or die("数据库连接失败");
      /* 连接数据库*/
      mysql_select_db("phptest",$link);
      /*设置字符集，使得页面的编码与数据库的编码一致。如果不一致将出现中文乱码*/
      mysql_query("set names utf8");
      /*定义数据库命令查询*/
      $q="select*from tb_user";
      /*执行数据库查询*/
      $result=mysql_query($q);
      /*执行数据库记录*/
      while($row=mysql_fetch_assoc($result)){
          echo "<tr><td>".$row["id"]."</td><td>".$row["username"]."</td><td>".$row["password"]."</td></tr>";
             /*显示数据结果*/
      }
?>

3. Example

PHP page querytest .php

<?php
    /* 连接数据库服务器，用or die的目的为了即使连接错误，系统不会继续执行，而是返回错误*/
    $link=mysql_connect("localhost","root","12345678") or die("数据库连接失败");
      /* 连接数据库*/
      mysql_select_db("phptest",$link);
      /*设置字符集，使得页面的编码与数据库的编码一致。如果不一致将出现中文乱码*/
      mysql_query("set names utf8");
      /*定义数据库命令查询*/
      $q="select*from tb_user";
      /*执行数据库查询*/
      $result=mysql_query($q);
      /*执行数据库记录*/
      while($row=mysql_fetch_assoc($result)){
          echo "<tr><td>".$row["id"]."</td><td>".$row["username"]."</td><td>".$row["password"]."</td></tr>";
             /*显示数据结果*/
      }
?>


序号
用户名
密码

Recommended learning: "PHP Video Tutorial"

The above is the detailed content of How to query mysql data display in php. For more information, please follow other related articles on the PHP Chinese website!