Home > php教程 > php手册 > body text

php 连接数据库并显示所要的数据

WBOY
Release: 2016-05-24 13:25:31
Original
1296 people have browsed it

这是一篇php入门教程,讲得就是关于php 连接数据库并显示所要的数据,也就是简单的php+mysql数据库在web网页上的应用实例了,代码如下:

<?php
$Host = "localhost";
$MySQL_UserName = "root";
$MySQL_UserPass = "password";
$MySQL_Database = "db";
$Query = "SELECT * FROM domain";
if (!mysql_connect($Host, $MySQL_UserName, $MySQL_UserPass)) { //开源代码phprm.com
    print "Cannot connect to MySQL: " . mysql_error();
    exit;
}
if (!mysql_select_db($MySQL_Database)) {
    print "Cannot select db<BR>";
    exit;
}
if (!$Result_ID = mysql_query($Query)) {
    print "Query Error: " . mysql_error();
    exit;
}
while ($Result = mysql_fetch_row($Result_ID)) {
    print "------------------<BR>";
    print "$Result[0]<BR>";
    print "$Result[1]<BR>";
    print "$Result[2]<BR>";
    print "$Result[3]<BR>";
    print "-------------------<BR>";
}
Copy after login


本文地址:

转载随意,但请附上文章地址:-)

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Recommendations
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!