在 PHP 中使用 PDO 创建存储过程

时间:2023-05-06
本文介绍了在 PHP 中使用 PDO 创建存储过程的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着跟版网的小编来一起学习吧!

问题描述

限时送ChatGPT账号..

我正在从 PHP 读取 TEXT 文件并尝试从中执行命令,例如创建数据库及其拥有的所有表和过程.我的代码创建了表,但没有创建文件中给出的存储过程.

I am reading a TEXT file from PHP and trying to execute commands from it, like creating a DB and all the tables and procedures it has. My code creates the tables but does not create Stored Procedures given in the file.

 DELIMITER $$
 DROP PROCEDURE IF EXISTS `add_hits`$$
 CREATE DEFINER=`root`@`localhost` PROCEDURE `add_hits`( In id varchar(255))
 BEGIN
 select hits into @hits from db_books where Book_ID = id;
 update db_books set hits=@hits+1 where Book_ID = id;
 END$$

PDO 没有创建 SP,如何才能完成这项任务?我已经尝试将所有代码部分一起并逐行执行,但没有任何效果.
我正在尝试制作数据库安装程序脚本.

The PDO is not creating the SPs, how will be able to accomplish this task? I have tried executing all the code part together and line by line, but nothing works.
I am trying to make a DB installer script.

推荐答案

好吧,PMA 帮我回答了我自己的这个问题.
为了克服这个问题,您需要删除程序的分隔符部分,以便您的查询变成:

Well, PMA Helped me with answering this Question of my own.
To overcome this you need to remove the delimiter part of the procedure, so that your queries become like:

 DROP PROCEDURE IF EXISTS `add_hits`;
 CREATE DEFINER=`root`@`localhost` PROCEDURE `add_hits`( In id varchar(255))
 BEGIN
 declare hits_bk int;
 select hits into hits_bk from db_books where Book_ID = id;
 update db_books set hits=hits_bk+1 where Book_ID = id;
 END;

现在查询将起作用.
感谢@Your Common Sense 和@RiggsFolly 的帮助.

Now the queries will work.
Thanks to @Your Common Sense and @RiggsFolly for helping out.

这篇关于在 PHP 中使用 PDO 创建存储过程的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!

上一篇:PHP PDO 异常:找不到驱动程序 下一篇:如何使用 PDO 和 memcached 设计缓存系统?

相关文章