$link = mssql_connect('localhost', 'sa', '123'); mssql_select_db("DVDSELL", $link); $sql = 'select username from Admin';//or (select * from Admin) $ret = mssql_query($sql); while ($row = mssql_fetch_array($ret)) { echo $row['username'], ' '; }
谢谢,你的回答,可是怎么总提示如下错误:Fatal error: Call to undefined function mssql_connect() in D:\wamp\www\database.php on line 6
刚刚我把php.ini配置文件中的mssql勾选上了。错误信息变了: Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: localhost in D:\wamp\www\database.php on line 6Warning: mssql_select_db(): supplied argument is not a valid MS SQL-Link resource in D:\wamp\www\database.php on line 7 jfy
成功! 是左半部分紫色页面! PHP Version 5.2.8 System Windows NT JFY 5.1 build 2600 Build Date Dec 8 2008 19:30:48 Configure Command cscript /nologo configure.js "--enable-snapshot-build" "--enable-debug-pack" "--with-snapshot-template=d:\php-sdk\snap_5_2\vc6\x86\template" "--with-php-build=d:\php-sdk\snap_5_2\vc6\x86\php_build" "--with-pdo-oci=D:\php-sdk\oracle\instantclient10\sdk,shared" "--with-oci8=D:\php-sdk\oracle\instantclient10\sdk,shared" Server API Apache 2.0 Handler Virtual Directory Support enabled
悬赏分:0 - 离问题结束还有 14 天 23 小时
最近刚刚练习php,想链接数据库尝试下,因为以前用sql server数据库。
所以想用php+sql server测试下:目的:读取数据库中一个表的一个字段所有值数据库用户名sa 密码123 数据库名称DVDSELL 表Admin 字段 username
就这些了,把这个字段的所有值读取出来就行了!
数据库本地 localhost最好能把所有的代码都写出来,谢谢!
mssql_select_db("DVDSELL", $link);
$sql = 'select username from Admin';//or (select * from Admin)
$ret = mssql_query($sql);
while ($row = mssql_fetch_array($ret)) {
echo $row['username'], ' ';
}
Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: localhost in D:\wamp\www\database.php on line 6Warning: mssql_select_db(): supplied argument is not a valid MS SQL-Link resource in D:\wamp\www\database.php on line 7
jfy
无法连接到服务器
导致
mssql_select_db()输入的不是有效link
为什么php链接不上?
参考那个暂时还看不懂。没到那水平
<head><title></title>
</head>
<body>
<?php
$link = mssql_connect('localhost', 'sa', '123');
mssql_select_db("DVDSELL", $link);
$sql = 'select username from Admin';//or (select * from Admin)
$ret = mssql_query($sql);
while ($row = mssql_fetch_array($ret)) {
echo $row['username'], ' ';
}
?>
</body>
</html>
$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($link));/* Printing results in HTML */
echo "<table>\n";
while ($row = msql_fetch_array($result, MSQL_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);
提示:assinsiment in condition
我发现是:根本不识别msql_connect这个函数!
<?php
phpinfo();?>
看看加载mssql模块没
是左半部分紫色页面!
PHP Version 5.2.8 System Windows NT JFY 5.1 build 2600
Build Date Dec 8 2008 19:30:48
Configure Command cscript /nologo configure.js "--enable-snapshot-build" "--enable-debug-pack" "--with-snapshot-template=d:\php-sdk\snap_5_2\vc6\x86\template" "--with-php-build=d:\php-sdk\snap_5_2\vc6\x86\php_build" "--with-pdo-oci=D:\php-sdk\oracle\instantclient10\sdk,shared" "--with-oci8=D:\php-sdk\oracle\instantclient10\sdk,shared"
Server API Apache 2.0 Handler
Virtual Directory Support enabled
可以完整的看出你的php配置,是否加载了MSSQL模块。
如果没有,看看你的php.ini中 extension_dir的路径是什么,
然后将php_mssql.dll复制过去,然后重启服务器php_mssql.dll没有网上找找