>백엔드 개발 >PHP 튜토리얼 >php,mysql_query()语句,提示内存溢出

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

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB원래의
2016-06-02 11:27:341382검색

mysqlphpphpmyadmin内存溢出timestamp

php后台接口,将两个表进行联合查询,使用union语句,在phpmyadmin中执行没有问题,
但是用postman进行测试时,提示内存溢出,有没有不使用ini_set的方法,解决这个问题,我试着unset了
几个变量,还是不行
$recommend = 1;

<code> $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</code>

这是错误信息
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

phpmyadmin运行正常

성명:
본 글의 내용은 네티즌들의 자발적인 기여로 작성되었으며, 저작권은 원저작자에게 있습니다. 본 사이트는 이에 상응하는 법적 책임을 지지 않습니다. 표절이나 침해가 의심되는 콘텐츠를 발견한 경우 admin@php.cn으로 문의하세요.