用php来对MySQL存储过程进行调用
mysql
php
存储
文章
调用
过程
进行
以下的文章主要介绍的是如何用php来对MySQL存储过程进行调用，我前几天在一个可信度特别好的网站看见关于php来对MySQL存储过程进行调用的资料，觉得挺好，就拿出来供大家分享。 498)this.width=498;' onmousewheel = 'javascript:return big(this)' alt="php
以下的文章主要介绍的是如何用php来对MySQL存储过程进行调用，我前几天在一个可信度特别好的网站看见关于php来对MySQL存储过程进行调用的资料，觉得挺好，就拿出来供大家分享。
<ol class="dp-xml"> <li class="alt"><span><span>nbsp;html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"</span><span class="tag">></span><span> </span></span></li> <li><span class="tag"><span class="tag-name">html</span><span> </span><span class="attribute">xmlns</span><span>=</span><span class="attribute-value">"http://www.w3.org/1999/xhtml"</span><span class="tag">></span><span> </span></span></li> <li class="alt"><span class="tag"><span class="tag-name">head</span><span class="tag">></span><span> </span></span></li> <li><span class="tag"><span class="tag-name">meta</span><span> </span><span class="attribute">http-equiv</span><span>=</span><span class="attribute-value">"Content-Type"</span><span> </span><span class="attribute">content</span><span>=</span><span class="attribute-value">"text/html; charset=gb2312"</span><span> </span><span class="tag">/></span><span> </span></span></li> <li class="alt"><span class="tag"><span class="tag-name">title</span><span class="tag">></span><span>无标题文档</span><span class="tag"></span><span class="tag-name">title</span><span class="tag">></span><span> </span></span></li> <li> <span class="tag"></span><span class="tag-name">head</span><span class="tag">></span><span> </span> </li> <li class="alt"><span class="tag"><span class="tag-name">body</span><span class="tag">></span><span> </span></span></li> <li><span class="tag"><span class="tag-name">table</span><span> </span><span class="attribute">align</span><span>=</span><span class="attribute-value">"center"</span><span> </span><span class="attribute">border</span><span>=</span><span class="attribute-value">1</span><span class="tag">></span><span> </span></span></li> <li class="alt"><span class="tag"><span class="tag-name">caption</span><span class="tag">></span><span class="tag"><span class="tag-name">h3</span><span class="tag">></span><span>用户管理</span><span class="tag"></span><span class="tag-name">h3</span><span class="tag">></span><span class="tag"></span><span class="tag-name">caption</span><span class="tag">></span><span> </span></span></span></li> <li><span class="tag"><span class="tag-name">tr</span><span> </span><span class="tag">></span><span> </span></span></li> <li class="alt"><span class="tag"><span class="tag-name">td</span><span> </span><span class="attribute">align</span><span>=</span><span class="attribute-value">"center"</span><span> </span><span class="attribute">colspan</span><span>=</span><span class="attribute-value">"7"</span><span class="tag">></span><span> </span></span></li> <li><span class="tag"><span class="tag-name">a</span><span> </span><span class="attribute">href</span><span>=</span><span class="attribute-value">"adduser.html"</span><span class="tag">></span><span>添加记录</span><span class="tag"></span><span class="tag-name">a</span><span class="tag">></span><span> </span></span></li> <li class="alt"> <span class="tag"></span><span class="tag-name">td</span><span class="tag">></span><span> </span> </li> <li> <span class="tag"></span><span class="tag-name">tr</span><span class="tag">></span><span> </span> </li> <li class="alt"><span class="tag"><span class="tag-name">tr</span><span class="tag">></span><span> </span></span></li> <li><span class="tag"><span class="tag-name">td</span><span> </span><span class="attribute">align</span><span>=</span><span class="attribute-value">"center"</span><span class="tag">></span><span class="tag"><span class="tag-name">font</span><span> </span><span class="attribute">style</span><span>=</span><span class="attribute-value">"FONT-WEIGHT: bold; FONT-SIZE: 12px; FONT-FAMILY: 黑体"</span><span class="tag">></span><span>姓名</span><span class="tag"></span><span class="tag-name">font</span><span class="tag">></span><span class="tag"></span><span class="tag-name">td</span><span class="tag">></span><span> </span></span></span></li> <li class="alt"><span class="tag"><span class="tag-name">td</span><span> </span><span class="attribute">align</span><span>=</span><span class="attribute-value">"center"</span><span class="tag">></span><span class="tag"><span class="tag-name">font</span><span> </span><span class="attribute">style</span><span>=</span><span class="attribute-value">"FONT-WEIGHT: bold; FONT-SIZE: 12px; FONT-FAMILY: 黑体"</span><span class="tag">></span><span>性别</span><span class="tag"></span><span class="tag-name">font</span><span class="tag">></span><span class="tag"></span><span class="tag-name">td</span><span class="tag">></span><span> </span></span></span></li> <li><span class="tag"><span class="tag-name">td</span><span> </span><span class="attribute">align</span><span>=</span><span class="attribute-value">"center"</span><span class="tag">></span><span class="tag"><span class="tag-name">font</span><span> </span><span class="attribute">style</span><span>=</span><span class="attribute-value">"FONT-WEIGHT: bold; FONT-SIZE: 12px; FONT-FAMILY: 黑体"</span><span class="tag">></span><span>年龄</span><span class="tag"></span><span class="tag-name">font</span><span class="tag">></span><span class="tag"></span><span class="tag-name">td</span><span class="tag">></span><span> </span></span></span></li> <li class="alt"><span class="tag"><span class="tag-name">td</span><span> </span><span class="attribute">align</span><span>=</span><span class="attribute-value">"center"</span><span class="tag">></span><span class="tag"><span class="tag-name">font</span><span> </span><span class="attribute">style</span><span>=</span><span class="attribute-value">"FONT-WEIGHT: bold; FONT-SIZE: 12px; FONT-FAMILY: 黑体"</span><span class="tag">></span><span>电话</span><span class="tag"></span><span class="tag-name">font</span><span class="tag">></span><span class="tag"></span><span class="tag-name">td</span><span class="tag">></span><span> </span></span></span></li> <li><span class="tag"><span class="tag-name">td</span><span> </span><span class="attribute">align</span><span>=</span><span class="attribute-value">"center"</span><span class="tag">></span><span class="tag"><span class="tag-name">font</span><span> </span><span class="attribute">style</span><span>=</span><span class="attribute-value">"FONT-WEIGHT: bold; FONT-SIZE: 12px; FONT-FAMILY: 黑体"</span><span class="tag">></span><span>地址</span><span class="tag"></span><span class="tag-name">font</span><span class="tag">></span><span class="tag"></span><span class="tag-name">td</span><span class="tag">></span><span> </span></span></span></li> <li class="alt"><span class="tag"><span class="tag-name">td</span><span> </span><span class="attribute">align</span><span>=</span><span class="attribute-value">"center"</span><span> </span><span class="attribute">colspan</span><span>=</span><span class="attribute-value">"2"</span><span class="tag">></span><span class="tag"><span class="tag-name">font</span><span> </span><span class="attribute">style</span><span>=</span><span class="attribute-value">"FONT-WEIGHT: bold; FONT-SIZE: 12px; FONT-FAMILY: 黑体"</span><span class="tag">></span><span>编辑</span><span class="tag"></span><span class="tag-name">font</span><span class="tag">></span><span class="tag"></span><span class="tag-name">td</span><span class="tag">></span><span> </span></span></span></li> <li> <span class="tag"></span><span class="tag-name">tr</span><span class="tag">></span><span> </span> </li> <li class="alt"> <span class="tag"></span><span class="tag-name">php</span><span> </span> </li> </ol>
登录后复制
通知服务器客户端可以处理由多语句或者MySQL存储过程执行生成的多结果集。当打开CLIENT_MULTI_STATEMENTS时，这个标志自动的被打开。可以在本表后查看更多关于该标志位的信息。）
<ol class="dp-xml">
<li class="alt"><span><span>define('CLIENT_MULTI_RESULTS', 131072); </span></span></li>
<li>
<span>$</span><span class="attribute">link</span><span> = </span><span class="attribute-value">mysql_connect</span><span>("localhost", "root", "123",1,CLIENT_MULTI_RESULTS) or die("数据库连接失败: ".mysql_error()); </span>
</li>
<li class="alt">
<span>$</span><span class="attribute">query</span><span>=</span><span class="attribute-value">mysql_query</span><span>("call bbs.p_alluserinfo()") or die("Query failed:" .mysql_error()); </span>
</li>
<li><span> </span></li>
<li class="alt">
<span>if(mysql_num_rows($query)</span><span class="tag">></span><span>0) </span>
</li>
<li><span>{ </span></li>
<li class="alt">
<span>$</span><span class="attribute">info</span><span>=</span><span class="attribute-value">mysql_fetch_array</span><span>($query); </span>
</li>
<li><span>do </span></li>
<li class="alt"><span>{ </span></li>
<li>
<span>echo "</span><span class="tag"><span class="tag-name">tr</span><span class="tag">></span><span>"; </span></span>
</li>
<li class="alt">
<span>echo "</span><span class="tag"><span class="tag-name">td</span><span class="tag">></span><span>$info[user_Name]</span><span class="tag"></span><span class="tag-name">td</span><span class="tag">></span><span>"; </span></span>
</li>
<li>
<span>echo "</span><span class="tag"><span class="tag-name">td</span><span class="tag">></span><span>$info[user_Sex]</span><span class="tag"></span><span class="tag-name">td</span><span class="tag">></span><span>"; </span></span>
</li>
<li class="alt">
<span>echo "</span><span class="tag"><span class="tag-name">td</span><span class="tag">></span><span>$info[user_Age]</span><span class="tag"></span><span class="tag-name">td</span><span class="tag">></span><span>"; </span></span>
</li>
<li>
<span>echo "</span><span class="tag"><span class="tag-name">td</span><span class="tag">></span><span>$info[user_Tel]</span><span class="tag"></span><span class="tag-name">td</span><span class="tag">></span><span>"; </span></span>
</li>
<li class="alt">
<span>echo "</span><span class="tag"><span class="tag-name">td</span><span class="tag">></span><span>$info[user_Adderss]</span><span class="tag"></span><span class="tag-name">td</span><span class="tag">></span><span>"; </span></span>
</li>
<li>
<span>echo "</span><span class="tag"><span class="tag-name">td</span><span class="tag">></span><span class="tag"><span class="tag-name">a</span><span> </span><span class="attribute">href</span><span>=</span><span class="attribute-value">'uduser.php?uid=$info[user_ID]'</span><span class="tag">></span><span>更新</span><span class="tag"></span><span class="tag-name">a</span><span class="tag">></span><span class="tag"></span><span class="tag-name">td</span><span class="tag">></span><span>"; </span></span></span>
</li>
<li class="alt">
<span>echo "</span><span class="tag"><span class="tag-name">td</span><span class="tag">></span><span class="tag"><span class="tag-name">a</span><span> </span><span class="attribute">href</span><span>=</span><span class="attribute-value">'deluser.php?uid=$info[user_ID]'</span><span class="tag">></span><span>删除</span><span class="tag"></span><span class="tag-name">a</span><span class="tag">></span><span class="tag"></span><span class="tag-name">td</span><span class="tag">></span><span>"; </span></span></span>
</li>
<li>
<span>echo "</span><span class="tag"></span><span class="tag-name">tr</span><span class="tag">></span><span>"; </span>
</li>
<li class="alt">
<span>}while($</span><span class="attribute">info</span><span>=</span><span class="attribute-value">mysql_fetch_array</span><span>($query)); </span>
</li>
<li>
<span>echo "</span><span class="tag"></span><span class="tag-name">table</span><span class="tag">></span><span>"; </span>
</li>
<li class="alt"><span>} </span></li>
<li><span>else </span></li>
<li class="alt"><span>{ </span></li>
<li>
<span>echo "</span><span class="tag"><span class="tag-name">tr</span><span class="tag">></span><span>没有记录</span><span class="tag"></span><span class="tag-name">tr</span><span class="tag">></span><span class="tag"></span><span class="tag-name">table</span><span class="tag">></span><span>"; </span></span>
</li>
<li class="alt"><span>} </span></li>
<li>
<span class="tag">?></span><span> </span>
</li>
<li class="alt">
<span class="tag"></span><span class="tag-name">table</span><span class="tag">></span><span> </span>
</li>
<li>
<span class="tag"></span><span class="tag-name">body</span><span class="tag">></span><span> </span>
</li>
<li class="alt">
<span class="tag"></span><span class="tag-name">html</span><span class="tag">></span><span> </span>
</li>
</ol>登录后复制
以上的相关内容就是对如何用php来对MySQL存储过程进行调用的介绍，望你能有所收获。
本站声明
本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系admin@php.cn
热AI工具
Undresser.AI Undress
人工智能驱动的应用程序，用于创建逼真的裸体照片
AI Clothes Remover
用于从照片中去除衣服的在线人工智能工具。
Undress AI Tool
免费脱衣服图片
Clothoff.io
AI脱衣机
Video Face Swap
使用我们完全免费的人工智能换脸工具轻松在任何视频中换脸！
热门文章
<🎜>：种植花园 - 完整的突变指南
3 周前
By DDD
<🎜>：泡泡胶模拟器无穷大 - 如何获取和使用皇家钥匙
3 周前
By 尊渡假赌尊渡假赌尊渡假赌
如何修复KB5055612无法在Windows 10中安装？
3 周前
By DDD
北端：融合系统，解释
3 周前
By 尊渡假赌尊渡假赌尊渡假赌
Mandragora：巫婆树的耳语 - 如何解锁抓钩
3 周前
By 尊渡假赌尊渡假赌尊渡假赌
热工具
记事本++7.3.1
好用且免费的代码编辑器
SublimeText3汉化版
中文版，非常好用
禅工作室 13.0.1
功能强大的PHP集成开发环境
Dreamweaver CS6
视觉化网页开发工具
SublimeText3 Mac版
神级代码编辑软件(SublimeText3)
MySQL：数据库，PHPMYADMIN：管理接口
Apr 29, 2025 am 12:44 AM
MySQL和phpMyAdmin可以通过以下步骤进行有效管理：1.创建和删除数据库：在phpMyAdmin中点击几下即可完成。2.管理表：可以创建表、修改结构、添加索引。3.数据操作：支持插入、更新、删除数据和执行SQL查询。4.导入导出数据：支持SQL、CSV、XML等格式。5.优化和监控：使用OPTIMIZETABLE命令优化表，并利用查询分析器和监控工具解决性能问题。
作曲家：通过AI的帮助开发PHP
Apr 29, 2025 am 12:27 AM
AI可以帮助优化Composer的使用，具体方法包括：1.依赖管理优化：AI分析依赖关系，建议最佳版本组合，减少冲突。2.自动化代码生成：AI生成符合最佳实践的composer.json文件。3.代码质量提升：AI检测潜在问题，提供优化建议，提高代码质量。这些方法通过机器学习和自然语言处理技术实现，帮助开发者提高效率和代码质量。
给MySQL表添加和删除字段的操作步骤
Apr 29, 2025 pm 04:15 PM
在MySQL中，添加字段使用ALTERTABLEtable_nameADDCOLUMNnew_columnVARCHAR(255)AFTERexisting_column，删除字段使用ALTERTABLEtable_nameDROPCOLUMNcolumn_to_drop。添加字段时，需指定位置以优化查询性能和数据结构；删除字段前需确认操作不可逆；使用在线DDL、备份数据、测试环境和低负载时间段修改表结构是性能优化和最佳实践。
session_start（）函数的意义是什么？
May 03, 2025 am 12:18 AM
session_start（）iscucialinphpformanagingusersessions.1）ItInitiateSanewsessionifnoneexists，2）resumesanexistingsessions，and3）setsasesessionCookieforContinuityActinuityAccontinuityAcconActInityAcconActInityAcconAccRequests，EnablingApplicationsApplicationsLikeUseAppericationLikeUseAthenticationalticationaltication and PersersonalizedContentent。
怎样卸载MySQL并清理残留文件
Apr 29, 2025 pm 04:03 PM
要安全、彻底地卸载MySQL并清理所有残留文件，需遵循以下步骤：1.停止MySQL服务；2.卸载MySQL软件包；3.清理配置文件和数据目录；4.验证卸载是否彻底。
MySQL批量插入数据的高效方法
Apr 29, 2025 pm 04:18 PM
MySQL批量插入数据的高效方法包括：1.使用INSERTINTO...VALUES语法，2.利用LOADDATAINFILE命令，3.使用事务处理，4.调整批量大小，5.禁用索引，6.使用INSERTIGNORE或INSERT...ONDUPLICATEKEYUPDATE，这些方法能显着提升数据库操作效率。
如何使用MySQL的函数进行数据处理和计算
Apr 29, 2025 pm 04:21 PM
MySQL函数可用于数据处理和计算。1.基本用法包括字符串处理、日期计算和数学运算。2.高级用法涉及结合多个函数实现复杂操作。3.性能优化需避免在WHERE子句中使用函数，并使用GROUPBY和临时表。
MySQL的字符集和排序规则如何配置
Apr 29, 2025 pm 04:06 PM
在MySQL中配置字符集和排序规则的方法包括：1.设置服务器级别的字符集和排序规则：SETNAMES'utf8';SETCHARACTERSETutf8;SETCOLLATION_CONNECTION='utf8_general_ci';2.创建使用特定字符集和排序规则的数据库：CREATEDATABASEexample_dbCHARACTERSETutf8COLLATEutf8_general_ci;3.创建表时指定字符集和排序规则：CREATETABLEexample_table(idINT
