为什么我的 PHP 不返回 MySQL 存储过程？

问：

好吧，我有我编写的这个MySQL存储过程，如果我在phpMyAdmin中运行以下内容，事情会正确返回：

SELECT game_name,urlfriendly(game_name) AS game_name2 FROM games

但是，如果我尝试运行以下代码，则会出现错误“警告：在 # 行的 /filepath.php 中为 foreach（） 提供的参数无效”

foreach ($this->database->query("SELECT game_name,urlfriendly(game_name) AS game_name2 FROM games") as $games)
{
    echo $games["game_name"] . " " . $games["game_name2"];
}

但是，如果我运行它，一切正常：

foreach ($this->database->query("SELECT game_name FROM games") as $games)
{
    echo $games["game_name"];
}

这意味着存储的过程不会返回到 PHP。

有什么想法吗？

编辑这是存储的过程（但我怀疑这是问题所在，因为phpMyAdmin正在从中提取值）

定界符//

DROP FUNCTION urlfriendly
//
CREATE FUNCTION urlfriendly (unsafe TEXT) RETURNS TEXT

DETERMINISTIC

BEGIN

DECLARE safe TEXT;

SET safe = REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(LOWER(unsafe),' ','-'),'&','and'),'`',''),'~',''),'!',''),'@',''),'#',''),'$',''),'%',''),'^',''),'*',''),'(',''),')',''),'_',''),'+',''),'=',''),'[',''),'{',''),']',''),'}',''),'|',''),'\\',''),"'",""),'"',''),':',''),';',''),'<',''),',',''),'>',''),'.',''),'/',''),'?','');

RETURN safe;

END
//

编辑2这是从MySQL返回的错误

execute command denied to user 'username'@'localhost' for routine 'databasename.urlfriendly' )