用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中解釋外鍵的目的。
Apr 25, 2025 am 12:17 AM
在MySQL中，外鍵的作用是建立表與表之間的關係，確保數據的一致性和完整性。外鍵通過引用完整性檢查和級聯操作維護數據的有效性，使用時需注意性能優化和避免常見錯誤。
比較和對比Mysql和Mariadb。
Apr 26, 2025 am 12:08 AM
MySQL和MariaDB的主要區別在於性能、功能和許可證：1.MySQL由Oracle開發，MariaDB是其分支。 2.MariaDB在高負載環境中性能可能更好。 3.MariaDB提供了更多的存儲引擎和功能。 4.MySQL採用雙重許可證，MariaDB完全開源。選擇時應考慮現有基礎設施、性能需求、功能需求和許可證成本。
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、備份數據、測試環境和低負載時間段修改表結構是性能優化和最佳實踐。
怎樣卸載MySQL並清理殘留文件
Apr 29, 2025 pm 04:03 PM
要安全、徹底地卸載MySQL並清理所有殘留文件，需遵循以下步驟：1.停止MySQL服務；2.卸載MySQL軟件包；3.清理配置文件和數據目錄；4.驗證卸載是否徹底。
session_start（）函數的意義是什麼？
May 03, 2025 am 12:18 AM
session_start（）iscucialinphpformanagingusersessions.1）ItInitiateSanewsessionifnoneexists，2）resumesanexistingsessions，and3）setsasesessionCookieforContinuityActinuityAccontinuityAcconActInityAcconActInityAcconAccRequests，EnablingApplicationsApplicationsLikeUseAppericationLikeUseAthenticationalticationaltication and PersersonalizedContentent。
H5：HTML5的關鍵改進
Apr 28, 2025 am 12:26 AM
HTML5帶來了五個關鍵改進：1.語義化標籤提升了代碼清晰度和SEO效果；2.多媒體支持簡化了視頻和音頻嵌入；3.表單增強簡化了驗證；4.離線與本地存儲提高了用戶體驗；5.畫布與圖形功能增強了網頁的可視化效果。
