Using PHP to call the stored procedure of the database_PHP tutorial

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 In fact, I could write something more complicated, but unfortunately I didn’t study it deeply, so I had to keep it simple! Below 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 '

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

'; $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. It is really, you don’t need to know, it is amazing once you use it. ! (Source: Viphot)

http://www.bkjia.com/PHPjc/314154.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/314154.htmlTechArticleYesterday, I saw a comrade asking if I could use php to call a stored procedure. I felt that it should be possible, so, The experiment was carried out immediately and it was very successful! Very unexpected! Because...