PHP calls MSSQL 2000 stored procedure Code

PHP calls MSSQL 2000 stored procedure code that's what I did yesterday. Oh, let's take a look at the code that uses PHP to invoke the MSSQL stored procedure.

$start = isset ($_get[' start ')? $_get[' Start ']:0;

$end = isset ($_get[' End '])? $_get[' End ']:0;

$pagesize = isset ($_get[' pagesize ')? $_get[' pagesize ']:0;

$stmt = Mssql_init ("Bigdatabase", $link) or Die ("");

Mssql_bind ($stmt, "@pagesize", $pagesize, SQLINT4);

Mssql_bind ($stmt, "@start", $start, SQLINT4);

@ $ms _result = Mssql_execute ($stmt, false);

Mssql_query ("DUMP TRANSACTION tempdb with no_log");

Now look at the MSSQL data table stored procedure function Oh bigdatabase

CREATE PROCEDURE Bigdatabase

@pagesize int,

@start int

As

declare @bsql nvarchar (4000)

Set @bsql = ' SELECT top ' + str (@pagesize) + ' username,from person where ID is not in (select top ' + str (@start) + ' ID from Person ORDER BY ID ASC) ORDER by ID ASC '

Execute sp_executesql @bsql