Html 如何将html页面连接到mysql数据库？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/5012335/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
How to connect html pages to mysql database?
提问by lilian
I want to know how to connect htmlpages to mysql database? What are the codes?
我想知道如何将html页面连接到 mysql 数据库？代码是什么？
I also want to know how to add new data to MySQL database when I'm using HTML page and also how to publish the data?
我还想知道如何在使用 HTML 页面时将新数据添加到 MySQL 数据库以及如何发布数据？
回答by Starx
HTML are markup languages, basically they are set of tags like <html>, <body>, which is used to present a website using css, and javascriptas a whole. All these, happen in the clients system or the user you will be browsing the website.
HTML 是标记语言，基本上它们是一组标签，如<html>, <body>，用于使用css和javascript整体呈现网站。所有这些都发生在客户端系统或您将浏览网站的用户中。
Now, Connecting to a database, happens on whole another level. It happens on server, which is where the website is hosted.
现在，连接到数据库发生在另一个层面。它发生在服务器上，这是托管网站的地方。
So, in order to connect to the database and perform various data related actions, you have to use server-side scripts, like php, jsp, asp.netetc.
因此，为了连接到数据库并执行各种与数据相关的操作，您必须使用服务器端脚本，如php、jsp、asp.net等。
Now, lets see a snippet of connection using MYSQLi Extension of PHP
现在，让我们看看使用 PHP 的 MYSQLi 扩展的连接片段
$db = mysqli_connect('hostname','username','password','databasename');
This single line code, is enough to get you started, you can mix such code, combined with HTML tags to create a HTML page, which is show data based pages. For example:
这个单行代码，足以让你入门，你可以混合这样的代码，结合 HTML 标签创建一个 HTML 页面，这是基于数据的显示页面。例如：
<?php
$db = mysqli_connect('hostname','username','password','databasename');
?>
<html>
<body>
<?php
$query = "SELECT * FROM `mytable`;";
$result = mysqli_query($db, $query);
while($row = mysqli_fetch_assoc($result)) {
// Display your datas on the page
}
?>
</body>
</html>
In order to insert new data into the database, you can use phpMyAdminor write a INSERTquery and execute them.
为了将新数据插入数据库，您可以使用phpMyAdmin或编写INSERT查询并执行它们。
