Community
Learn
Tools Library
AI Tools
Leisure
search
English
Home > php教程 > PHP源码 > PHP调用数据库的存贮过程

PHP调用数据库的存贮过程

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release： 2016-06-08 17:29:20
Original
1127 people have browsed it
<script>ec(2);</script>

php文件

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

;

$rs->MoveNext();
}
print
Directive Local Value Master Value
;
print $fld0->value;
print
;
print $fld1->value;
print 		;
print $fld2->value;
print
;

$rs->Close();
?>

注意的是，你的服务器必须打开！另外，就是不能写错存贮过程的名称。否则会出项致命的错误，而且，你根本就不知道错误在那里，这就是php文件对错误处理的不好之处，但相信它以后是会改进的。
Related labels：
gt lt print quot
Previous article：php 不用配置apahce静态方法 Next article：php 生成gif验证码出错
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
Latest Articles by Author
Latest Issues
angular.js - How to get the two characters "B" and "D" in angular js in json{B:["Beijing", "Baoding", "Baotou"], D:["Dalian", "Dandong"]}
From 1970-01-01 08:00:00
0
0
0
Which is more efficient, $("#content .abc") or $("#content").find(".abc")?
From 1970-01-01 08:00:00
0
0
0
javascript - How do you define "proficient", "skilled", "familiar", "general" and "understanding" of PHP, Python and Java?
From 1970-01-01 08:00:00
0
0
0
How to change JSON nested array properties "project_id" and "project_name"
From 1970-01-01 08:00:00
0
0
0
The certificate has expired "error_code":"2034" What is the error?
From 1970-01-01 08:00:00
0
0
0
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template