How to connect the web page to the database?

How to connect a web page to a database: First create a PHP code file for the web page to connect to the database; then solve the browser encoding problem and specify the database character set; finally select and connect to the database through the "mysql_select_db" function.

HTML cannot read the database. HTML is the front-end scripting language of the page. If you want to obtain the data in the SQL database from the HTML web page, you need to use JSP or ASP or PHP or RUBY and other languages ​​to achieve. A simple relationship can be understood like this: Database<--->JSP or ASP or PHP or RUBY and other languages<--->HTML

The web page link database code is as follows (written in PHP):

<?php
header(&#39;content-type:text/html;charset=gb2312;&#39;);//解决浏览器编码问题
$lnk = mysql_connect(&#39;localhost&#39;, &#39;root&#39;, &#39;********&#39;) or die (&#39;连接失败 : &#39; . mysql_error());//密码填的是连接数据库的密码
mysql_query("set names gb2312");//这就是指定数据库字符集
//选择当前连接数据库为student
mysql_select_db(&#39;book&#39;, $lnk);
//获取查询项和查询关键字的值
$searchitem=$_POST[&#39;searchitem&#39;];
$searchvalue=$_POST[&#39;searchvalue&#39;];
/*定义查询语句，如果查询关键字的值不为空，则在SQL语句的Where子句中
指定查询项模糊匹配关键字，否则查询所有记录*/
if($searchvalue!="") 
  $myquery="SELECT * from books where {$searchitem} like &#39;%{$searchvalue}%&#39;";  
else
  $myquery="SELECT * from books";   
//执行查询，生成结果集
$result = mysql_query($myquery)	or die("<br>查询表books失败: " . mysql_error());
//从结果集中取得一行作为关联数组
$row=mysql_fetch_array($result);
//循环读取每一行记录
while ($row)
{
}
?>

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