Forum und email

mSQL Functions

簡介

These functions allow you to access mSQL database servers. More information about mSQL can be found at » https://www.hughes.com.au/.

安裝

In order to have these functions available, you must compile PHP with msql support by using the --with-msql[=DIR] option. DIR is the mSQL base install directory, defaults to /usr/local/msql3.

Note: Note to Win32 Users 需要有DLL檔案存在於PATH的Windows系統上,來使此擴充功能運作。參見FAQ主題為"如何增加PHP目錄至Windows上的PATH環境變數",可獲得如何完成這些步驟的資訊。雖然從PHP資料夾複製DLL檔案至Windows系統目錄也可行(因為PATH預設包含系統目錄),不過不建議這樣做。此擴充功能需要以下檔案存在PATH中: msql.dll

執行時期設定

這些函式的行為受 php.ini 的影響。

mSQL configuration options
Name Default Changeable Changelog
msql.allow_persistent "1" PHP_INI_ALL  
msql.max_persistent "-1" PHP_INI_ALL  
msql.max_links "-1" PHP_INI_ALL  
有關 PHP_INI_* 常數進一步的細節與定義參見php.ini directives

以下是設定選項的簡要解釋。

msql.allow_persistent boolean

Whether to allow persistent mSQL connections.

msql.max_persistent integer

The maximum number of persistent mSQL connections per process.

The maximum number of mSQL connections per process, including persistent connections.

資源類型

There are two resource types used in the mSQL module. The first one is the link identifier for a database connection, the second a resource which holds the result of a query.

預設常數

以下常數由擴充功能定義,因此只有在擴充功能被編譯到 PHP 中,或者在執行時被動態載入後才有效。

MSQL_ASSOC (integer)
MSQL_NUM (integer)
MSQL_BOTH (integer)

範例

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);
?>

Table of Contents