我想搞个注册页面(数据库是mssql的,)
php如何存取数据进mssql?
没用过mssql不知道是否与mysql相同数据库名:GFS
表: user_table里面有
idusername
pw就这几个,帮我搞下
php如何存取数据进mssql?
没用过mssql不知道是否与mysql相同数据库名:GFS
表: user_table里面有
idusername
pw就这几个,帮我搞下
解决方案 »
- INCLUDE问题 求教
- 求助:任意选择下拉列表菜单选项,并执行对应的操作?
- php 能否制作 时间触发器
- 同个页面有的会显示,有的不显示,高手帮我看一下什么问题。谢谢。
- 想学习pear,大家给点意见
- 初级问题:php里面用什么函数执行*.sql文件中的sql语句。
- 用getenv("REMOTE_ADDR")得到的ip地址是什么数据类型的
- 怎样把自己用C++builder做的一个控件插入php或是html页面中?
- 我已经在PHP.INI中定义了session.save_path = "e:\server\php\tmp"为什么还不行。(其中tmp是我新建的文件夹)
- PHP@MySQL同时向两个表插入数据
- 这一条SQL怎么优化
- sql like 查询问题
<?php
// Server in the this format: <computer>\<instance name> or
// <server>,<port> when using a non default port number
$server = 'KALLESPC\SQLEXPRESS';// Connect to MSSQL
$link = mssql_connect($server, 'sa', 'phpfi');if (!$link) {
die('Something went wrong while connecting to MSSQL');
}
?>
//Returns records with Id#46 or first name starting with 'Mary'$server = '127.0.0.1';
$link = mssql_connect($server, 'sql_user', 'sql_user_pass'); //Select DB
$dbn = 'GFS';
mssql_select_db($dbn); //input variables
$name='Mary%';
$id=46;//necesssary for stored procedure
$params="@name varchar(50),@id int";
$paramslist="@name='$name%',@id='$id'";$sql = "select * where user_table" ;//important to have the "N'" !$result=mssql_query($dbsql,$link);
?>
Fatal error: Call to undefined function mssql_connect() in D:\AppServ\www\edd\s.php on line 7
phpinfo();
?>编辑一个php页面,把代码贴进去。运行该页面查看结果。
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 5.0.37 Directive Local Value Master Value
mysql.allow_persistent On On
mysql.connect_timeout 60 60
mysql.default_host no value no value
mysql.default_password no value no value
mysql.default_port no value no value
mysql.default_socket no value no value
mysql.default_user no value no value
mysql.max_links Unlimited Unlimited
mysql.max_persistent Unlimited Unlimited
mysql.trace_mode Off Off
mysqli
MysqlI Support enabled
Client API library version 5.0.37
Client API header version 5.0.36
MYSQLI_SOCKET /tmp/mysql.sock Directive Local Value Master Value
mysqli.default_host no value no value
mysqli.default_port 3306 3306
mysqli.default_pw no value no value
mysqli.default_socket no value no value
mysqli.default_user no value no value
mysqli.max_links Unlimited Unlimited
mysqli.reconnect Off Off
哪个?
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 5.0.37 Directive Local Value Master Value
mysql.allow_persistent On On
mysql.connect_timeout 60 60
mysql.default_host no value no value
mysql.default_password no value no value
mysql.default_port no value no value
mysql.default_socket no value no value
mysql.default_user no value no value
mysql.max_links Unlimited Unlimited
mysql.max_persistent Unlimited Unlimited
mysql.trace_mode Off Off
mysqli
MysqlI Support enabled
Client API library version 5.0.37
Client API header version 5.0.36
MYSQLI_SOCKET /tmp/mysql.sock Directive Local Value Master Value
mysqli.default_host no value no value
mysqli.default_port 3306 3306
mysqli.default_pw no value no value
mysqli.default_socket no value no value
mysqli.default_user no value no value
mysqli.max_links Unlimited Unlimited
mysqli.reconnect Off Off
哪个?
MSSQL Support enabled
Active Persistent Links 0
Active Links 0
Library version 7.0Directive Local Value Master Value
mssql.allow_persistent On On
mssql.batchsize 0 0
mssql.compatability_mode Off Off
mssql.connect_timeout 5 5
mssql.datetimeconvert On On
mssql.max_links Unlimited Unlimited
mssql.max_persistent Unlimited Unlimited
mssql.max_procs Unlimited Unlimited
mssql.min_error_severity 10 10
mssql.min_message_severity 10 10
mssql.secure_connection Off Off
mssql.textlimit Server default Server default
mssql.textsize Server default Server default
mssql.timeout 60 60
php.ini 中找到上行,去掉分号。重启apache.
/*Connect to the local server using Windows Authentication and
specify the AdventureWorks database as the database in use. */
$serverName = "(local)";
$conn = sqlsrv_connect( $serverName);if( $conn === false )
{
echo "Could not connect.\n";
die( print_r( sqlsrv_errors(), true));
}if( $client_info = sqlsrv_client_info( $conn))
{
foreach( $client_info as $key => $value)
{
echo $key.": ".$value."\n";
}
}
else
{
echo "Client info error.\n";
}/* Close connection resources. */
sqlsrv_close( $conn);
?>