如何从PHP执行sql-server函数? [英] How to execute a sql-server function from PHP?

问题描述

我在MSSQL中具有功能，我需要从PHP开始.我的连接已经准备好，但是我不知道如何从PHP执行.

I have function in MSSQL and I need to start that from PHP. My connection is ready, but I don't know howto execute from PHP.

这是我尝试执行的功能:

Here's the function I try to execute:

USE [database]
GO
DECLARE     @return_value int
EXEC  @return_value = [dbo].[ict_es2_import_ceniku]
@Id_ceniku = N'Maloobchodni cenik'
SELECT      'Return Value' = @return_value
GO

推荐答案

这有效！

$username = "xxx";
$password = "xxx";
$hostname = 'xxx';
$dbname = "xxx";


$dbcon = mssql_connect($hostname, $username, $password)or die("Unable to connect to MSSQL");
mssql_select_db($dbname, $dbcon); // vybere databázi

$stmt = mssql_init('ict_es2_import_ceniku');
$variace = 'Maloobchodni cenik';
$Id_ceniku = '@Id_ceniku';
mssql_bind($stmt, $Id_ceniku, $variace,  SQLTEXT, false);
mssql_execute($stmt);
mssql_free_statement($stmt);
echo $return_value;

这篇关于如何从PHP执行sql-server函数?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！