php mysql 内存溢出_php,mysql_query()语句,提示内存溢出

php后台接口,将两个表进行联合查询,使用union语句,在phpmyadmin中执行没有问题,

但是用postman进行测试时,提示内存溢出,有没有不使用ini_set的方法,解决这个问题,我试着unset了

几个变量,还是不行

$recommend = 1;$check_status = 2; $art_act_reslut = mysql_query( "SELECT * FROM ( SELECT publish_time, article_id as id, user_id as user_brand_id, article_text as text, article_thumbs as thumds_person_num, sort_weight, '' as title, article_comment_number as article_comment_number FROM article WHERE recommend = '$recommend' and check_status = '$check_status' and publish_time > '$timestamp' UNION SELECT publish_time, activity_id as id, brand_id as user_beand_id, activity_content as text, join_persons as thumds_person_num, sort_weight, activity_title as title, '' as article_comment_number FROM activity WHERE recommend = '$recommend' and check_status = '$check_status' and publish_time > '$timestamp') stain ORDER BY stain.publish_time DESC, stain.sort_weight DESC"); unset($recommend); unset($check_status); //赋值到cards for($i=0;$i<20;$i++) { $cards_arr = array(); $art_act_reslut_value = mysql_fetch_assoc($art_act_reslut); //给相应的参数赋值 $id = $art_act_reslut_value["id"]; $user_brand_id = $art_act_reslut_value["user_brand_id"]; $text = $art_act_reslut_value["text"]; $thumds_person_num = $art_act_reslut_value["thumds_person_num"]; $article_comment_nummber = $art_act_reslut_value["article_comment_number"]; $publish_time = $art_act_reslut_value["publish_time"]; $title = $art_act_reslut_value["title"]; $sort_weight = $art_act_reslut_value["sort_weight"]; unset($art_act_reslut_value);

这是错误信息

Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 20 bytes) in /home/fgang/local/apache/htdocs/bimu/interface/get_home_recommand.php on line 102

1460894569_910309.png

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值