Deprecated: Optional parameter $keys declared before required parameter $cms_id is implicitly treated as a required parameter in /home/www/dev/work/class/blog/CmsKey.php on line 75

Deprecated: Creation of dynamic property lvesu\lvesu\controller\blog\php::$title is deprecated in /home/www/dev/work/website/lvesu/class/controller/blog/php.php on line 28

Deprecated: Creation of dynamic property lvesu\lvesu\controller\blog\php::$outlink is deprecated in /home/www/dev/work/website/lvesu/template/blog/cms/php.manual.tpl on line 2

Deprecated: Creation of dynamic property lvesu\lvesu\controller\blog\php::$status is deprecated in /home/www/dev/work/website/lvesu/template/blog/index.head.php on line 2
PHP - Manual: Basic usage - 互联网笔记

略微加速

PHP官方手册 - 互联网笔记

PHP - Manual: Basic usage

2025-06-09

Basic usage

This simple example shows how to connect, execute a query, print resulting rows and disconnect from a mSQL database.

Example #1 mSQL usage example

<?php
/* Connecting, selecting database */
$link msql_connect('localhost''username''password')
    or die(
'Could not connect : ' msql_error($link));

msql_select_db('database'$link)
    or die(
'Could not select database');

/* Issue SQL query */
$query 'SELECT * FROM my_table';
$result msql_query($query$link) or die('Query failed : ' msql_error());

/* Printing results in HTML */
echo "<table>\n";
while (
$row msql_fetch_array($resultMSQL_ASSOC)) {
    echo 
"\t<tr>\n";
    foreach (
$row as $col_value) {
        echo 
"\t\t<td>$col_value</td>\n";
    }
    echo 
"\t</tr>\n";
}
echo 
"</table>\n";

/* Free result set */
msql_free_result($result);

/* Close connection */
msql_close($link);
?>
add a note add a note

User Contributed Notes

There are no user contributed notes for this page.

官方地址:https://www.php.net/manual/en/msql.examples-basic.php

冷却塔厂家 广告
中文GPT4.0无需注册 广告
北京半月雨文化科技有限公司.版权所有 京ICP备12026184号-3