我要问:
$start = 0;
$number_of_posts = 10;
$sql = $db -> prepare("
SELECT U.username, U.offer_photo, F.activities, A.id_offer, A.offer, A.role, A.content, A.date_post, A.limit, B.type_offer, C.local
FROM type_offer B, local C, offer A
INNER JOIN users U
ON U.id_user = A.company_users_id_user1
INNER JOIN company F
ON F.users_id_user = A.company_users_id_user1
WHERE state = 0
AND
A.type_offer_id_type_offer = B.id_type_offer
AND
A.local_id_local = C.id_local
ORDER BY date_post
DESC LIMIT ?, ?
");
$sql -> bind_param( ii ,$start, $number_of_posts);
$sql -> execute();
$sql -> bind_result($username, $offer_photo, $actividades, $id_oferta, $oferta, $cargo, $conteudo, $data_post, $data_limite, $tipo_oferta, $local); //problem here
$sql->fetch();
$sql-close;
And i have memory_limit: 256M in phpinfo(); However i still getting a problem with the memory.
I already tried this code without success :
set_time_limit(0);
ini_set( memory_limit , 2000M );
因此,我的问题是,可以优化问答,或如何能够增加记忆? 我没有机会进入php.ini,但我认为256MB应当足够,因此,问题可能是争.。