Use PHP to call the stored procedure of the database! _PHP Tutorial

Use PHP to call the stored procedure of the database!
Author: fox4000

Yesterday, I saw a comrade asking if I could use php to call the stored procedure. I felt that it should be possible, so I immediately conducted the experiment and it was very successful! Very unexpected! Therefore, write it down for everyone’s reference!
As we all know, a stored procedure is a script program on the server side, which is very fast to execute, but it also has a disadvantage, that is, it relies on a fixed database and has poor portability!
My last article mentioned that you can use COM components to access ado and related components. Whether you build it yourself or bring it with the system, you can expand the functions of the system, but now PHP does not support dcom/com+, but I believe it should be supported in the next version.
Without further ado, let’s try it right away.

The following is a simple storage procedure of mine
CREATE PROCEDURE [sp_mystoreprocedure] AS
select companyname, contactname, city from customers

In fact, you can also write more complex ones , it’s a pity that I didn’t study this in depth, so I had to keep it simple!

The following is my php file

define ("OLEDB_CONNECTION_STRING",
"Provider=SQLOLEDB; Data Source=zzb; Initial Catalog=Northwind; User ID=sa; Password=");
$dbc = new COM("ADODB.Connection");
$dbc->Open(OLEDB_CONNECTION_STRING);
$command = "sp_mystoreprocedure";
$rs = $dbc->Execute($command); // Recordset
$i = 0;

echo '

';

while (!$rs->EOF) {
$i += 1;
$fld0 = $rs->Fields(0);
$fld1 = $rs->Fields(1);
$fld2 = $rs- >Fields(2);
print '

tr>';

$rs->MoveNext();
}
print '

Directive	Local Value	Master Value
'; print $fld0->value; print '	'; print $fld1- >value; print '	'; print $fld2->value; print '

';

$rs->Close();
?>

Note that your server must be turned on! In addition, you cannot write the wrong name of the stored procedure. Otherwise, a fatal error will occur, and you don't even know where the error is. This is the poor handling of errors in the PHP file, but I believe it will be improved in the future.

I have been learning PHP for a long time, but I found that it is not so easy to really use it well, but it is indeed beyond my imagination. Some things are really amazing. Really, no need to use it. You know, it’s amazing when you use it!

http://www.bkjia.com/PHPjc/315945.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/315945.htmlTechArticleUse PHP to call the stored procedure of the database! Author: fox4000 Yesterday, I saw a comrade asking if the stored procedure could be called using php. I felt that it should be possible, so I immediately conducted an experiment...