} $count = 0; while ($count <= $loop) { $conn = new mysqli($servername, $username, $password, $dbname); if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } $result = $conn->query($sql); if ($result->num_rows > 0) { $i = 0; while ($val = $result->fetch_assoc()) { include 'arrays.php'; if ($i == $max) { break; } $i++; } } $conn->close(); $count++; } if (!isset($_GET['html'])) { if (empty($mainJson)) { print return_graph('No query results', 'text', 'throw'); } else { print return_graph($mainJson, 'json'); } } } else { print return_graph('No data table selected', 'text', 'throw'); }
} $result = $conn->query($sql); if ($result->num_rows > 0) { while ($row = $result->fetch_assoc()) { $pData = json_decode($row['product_info']); $saveImag = array(); $saveImag_size = array(); foreach ($pData as $pd) { $images = explode(',', $pd->images); $timeAgo = time_ago(strtotime($pd->timestamp)); $date = $pd->timestamp; foreach ($images as $img) { array_push($saveImag, pb_safe_image_structure(pb_table_data('pb_safe_image', 'string', "uid='{$img}'"))); array_push($saveImag_size, pb_safe_image_structure(pb_table_data('pb_safe_image', 'size', "uid='{$img}'"))); } $title = $pd->title; $desc = $pd->desc; $tags = $pd->tags; $price = $pd->price; $condition = $pd->condition; } $user_data = json_decode(pb_table_data('pb_users', 'user_data', "user_id='{$row['user_id']}'"), true); $comment = json_decode(get_comments($row['product_id'])); $imgSize = explode(':', $saveImag_size[0]); $entity = array('id' => $row['product_id'], 'type' => $row['type'], 'timestamp' => array('date' => $date, 'laps' => $timeAgo), 'user' => array('id' => $row['user_id'], 'name' => $user_data[0]['name'], 'username' => $user_data[0]['username'], 'avatar' => $user_data[0]['avatar']), 'images' => array('featured' => $saveImag[0], 'featured_size' => array('width' => $imgSize[0], 'height' => $imgSize[1]), 'list' => $saveImag), 'product_info' => array('title' => $title, 'desc' => $desc, 'tags' => $tags, 'price' => $price, 'condition' => $condition), 'comments' => array('count' => count($comment), 'comments' => $comment)); array_push($mainJson, $entity); } } $conn->close(); echo return_graph($mainJson, 'json');