Use PHP to call the stored procedure of the database! (Reprinted) I believe that friends who use PHP under WIN32 will find that there is a _PHP tutorial when using WIN32

Use PHP to call the stored procedure of the database!
Author: fox4000
Yesterday, I saw a comrade asking if he 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
Actually, you can also write more complex ones, but unfortunately I have to research this It’s not deep, so I have 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 '

Directive	Local Value< ;/th>	Master Value
'; print $fld0->value; print '	'; print $fld1->value; print '	'; http://www.bkjia.com/PHPjc/631432.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/631432.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 it should be possible, so I immediately conducted an experiment... Statement： The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn Previous article：Use PHP to set up web navigation_PHP tutorialNext article：Use PHP to set up web navigation_PHP tutorial Related articles See more How to use cURL to implement Get and Post requests in PHP How to use cURL to implement Get and Post requests in PHP How to use cURL to implement Get and Post requests in PHP How to use cURL to implement Get and Post requests in PHP All expression symbols in regular expressions (summary) Home Course Q&A My Home Course Article Q&A Dictionary Manual Download Topic Home Article Q&A Course Topic Download Game Dictionary 简体中文（ZH-CN）English（EN）繁体中文（ZH-TW）日本語（JA）한국어（KO）Melayu（MS）Français（FR）Deutsch（DE）