How to check the database on php website-PHP Problem-php.cn

How to check the database on php website

尚

Release： 2023-02-27 19:06:01

Original

4438 people have browsed it

How to check the database on php website

How to view the database on the php website:

Recommended: php server

Connect to the database code:

<?php
define("DB_HOST","localhost");
define("DB_USER","root");
define("DB_PWD","");
define("DB_NAME","wordpress4");
$conn = @mysql_connect(DB_HOST,DB_USER,DB_PWD) or die("连接服务器出错：".mysql_error());
@mysql_select_db(DB_NAME) or die("连接数据库出错：".mysql_error());
@mysql_query(&#39;SET NAMES UTF8&#39;);
?>

Copy after login

Read database information code:

$result = mysql_query("select * from wp_wf order by timer02 desc limit 0,50");//获取最新50条数
   while($row = mysql_fetch_array($result))//转成数组，且返回第一条数据,当不是一个对象时候退出
        {
        echo &#39;
    <div class="cp_haoma_list cat-list">
        <h2>数据详情<label>&#39;.$row[&#39;number02&#39;].&#39;</label></h2>
        <div class="haoma_con"><span>&#39;.
            str_ireplace(",","</span><span>",$row[&#39;datar02&#39;])
            .&#39;</span>  
        </div>
    </div>&#39;;
    }

Copy after login

Code to close the database:

mysql_close($conn);

Copy after login

By combining the three pieces of code, PHP can read the database and display it to the front desk of the website. The code is as follows:

<?php
   require "conn.php";//连接数据库  
  $result = mysql_query("select * from wp_kaijiangwf order by timer02 desc limit 0,50");//最新50条数
   while($row = mysql_fetch_array($result))//转成数组，且返回第一条数据,当不是一个对象时候退出
        {
        echo &#39;
    <div class="cp_haoma_list cat-list">
        <h2>数据详情<label>&#39;.$row[&#39;number02&#39;].&#39;</label></h2>
        <div class="haoma_con"><span>&#39;.
            str_ireplace(",","</span><span>",$row[&#39;datar02&#39;])
            .&#39;</span>  
        </div>
    </div>&#39;;
    }
        mysql_close($conn);// 关闭数据库
?>

Copy after login

The above is the detailed content of How to check the database on php website. For more information, please follow other related articles on the PHP Chinese website!