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 of this Website 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 Hot AI Tools Undresser.AI Undress AI-powered app for creating realistic nude photos AI Clothes Remover Online AI tool for removing clothes from photos. Undress AI Tool Undress images for free Clothoff.io AI clothes remover Video Face Swap Swap faces in any video effortlessly with our completely free AI face swap tool! Show More Hot Article How to fix KB5055612 fails to install in Windows 10? 4 weeks ago By DDD Roblox: Grow A Garden - Complete Mutation Guide 3 weeks ago By DDD Roblox: Bubble Gum Simulator Infinity - How To Get And Use Royal Keys 3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌 Nordhold: Fusion System, Explained 4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌 Mandragora: Whispers Of The Witch Tree - How To Unlock The Grappling Hook 3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌 Show More Hot Tools Notepad++7.3.1 Easy-to-use and free code editor SublimeText3 Chinese version Chinese version, very easy to use Zend Studio 13.0.1 Powerful PHP integrated development environment Dreamweaver CS6 Visual web development tools SublimeText3 Mac version God-level code editing software (SublimeText3) Show More Hot Topics Java Tutorial 1670 14 CakePHP Tutorial 1428 52 Laravel Tutorial 1329 25 PHP Tutorial 1274 29 C# Tutorial 1256 24 Show More Related knowledge PHP and Python: Different Paradigms Explained Apr 18, 2025 am 12:26 AM PHP is mainly procedural programming, but also supports object-oriented programming (OOP); Python supports a variety of paradigms, including OOP, functional and procedural programming. PHP is suitable for web development, and Python is suitable for a variety of applications such as data analysis and machine learning. Choosing Between PHP and Python: A Guide Apr 18, 2025 am 12:24 AM PHP is suitable for web development and rapid prototyping, and Python is suitable for data science and machine learning. 1.PHP is used for dynamic web development, with simple syntax and suitable for rapid development. 2. Python has concise syntax, is suitable for multiple fields, and has a strong library ecosystem. PHP and Python: A Deep Dive into Their History Apr 18, 2025 am 12:25 AM PHP originated in 1994 and was developed by RasmusLerdorf. It was originally used to track website visitors and gradually evolved into a server-side scripting language and was widely used in web development. Python was developed by Guidovan Rossum in the late 1980s and was first released in 1991. It emphasizes code readability and simplicity, and is suitable for scientific computing, data analysis and other fields. PHP's Impact: Web Development and Beyond Apr 18, 2025 am 12:10 AM PHPhassignificantlyimpactedwebdevelopmentandextendsbeyondit.1)ItpowersmajorplatformslikeWordPressandexcelsindatabaseinteractions.2)PHP'sadaptabilityallowsittoscaleforlargeapplicationsusingframeworkslikeLaravel.3)Beyondweb,PHPisusedincommand-linescrip PHP vs. Python: Use Cases and Applications Apr 17, 2025 am 12:23 AM PHP is suitable for web development and content management systems, and Python is suitable for data science, machine learning and automation scripts. 1.PHP performs well in building fast and scalable websites and applications and is commonly used in CMS such as WordPress. 2. Python has performed outstandingly in the fields of data science and machine learning, with rich libraries such as NumPy and TensorFlow. The Continued Use of PHP: Reasons for Its Endurance Apr 19, 2025 am 12:23 AM What’s still popular is the ease of use, flexibility and a strong ecosystem. 1) Ease of use and simple syntax make it the first choice for beginners. 2) Closely integrated with web development, excellent interaction with HTTP requests and database. 3) The huge ecosystem provides a wealth of tools and libraries. 4) Active community and open source nature adapts them to new needs and technology trends. Oracle's Role in the Business World Apr 23, 2025 am 12:01 AM Oracle is not only a database company, but also a leader in cloud computing and ERP systems. 1. Oracle provides comprehensive solutions from database to cloud services and ERP systems. 2. OracleCloud challenges AWS and Azure, providing IaaS, PaaS and SaaS services. 3. Oracle's ERP systems such as E-BusinessSuite and FusionApplications help enterprises optimize operations. MySQL: Structured Data and Relational Databases Apr 18, 2025 am 12:22 AM MySQL efficiently manages structured data through table structure and SQL query, and implements inter-table relationships through foreign keys. 1. Define the data format and type when creating a table. 2. Use foreign keys to establish relationships between tables. 3. Improve performance through indexing and query optimization. 4. Regularly backup and monitor databases to ensure data security and performance optimization. See all articles Public welfare online PHP training，Help PHP learners grow quickly！ About us Disclaimer Sitemap © php.cn All rights reserved