closing connection with
$conn = null;
below FREE DATA from server… as is big data of cron job??? PHP PDO
$q1 = "SELECT *, COUNT(*) as c FROM logs WHERE.....GROUP BY page ORDER BY c desc;";
try {
$stmt1 = $conn->prepare($q1);
$stmt1->execute();
$result = $stmt1->setFetchMode(PDO::FETCH_ASSOC);
$profileData = $stmt1->fetchAll();
}
catch(PDOException $e) {
echo "Error: " . $e->getMessage();
}
$conn = null;