- <?php
- /* Connect to a MySQL server 连接数据库服务器 */
- $link = mysqli_connect(
- 'localhost', /* The host to connect to 连接MySQL地址 */
- 'user', /* The user to connect as 连接MySQL用户名 */
- 'password', /* The password to use 连接MySQL密码 */
- 'world'); /* The default database to query 连接数据库名称*/
- if (!$link) {
- printf("Can't connect to MySQL Server. Errorcode: %s ", mysqli_connect_error());
- exit;
- }
- /* Send a query to the server 向服务器发送查询请求*/
- if ($result = mysqli_query($link, 'SELECT Name, Population FROM City ORDER BY Population DESC LIMIT 5')) {
- //print("Very large cities are: ");
- /* Fetch the results of the query 返回查询的结果 */
- while( $row = mysqli_fetch_assoc($result) ){
- printf("%s (%s) ", $row['Name'], $row['Population']);
- }
- /* Destroy the result set and free the memory used for it 结束查询释放内存 */
- mysqli_free_result($result);
- }
- /* Close the connection 关闭连接*/
- mysqli_close($link);
- ?>
PHP5i如何连接MySQL数据库和读取数据
最新推荐文章于 2019-02-20 19:37:37 发布