Example #1
0
    }
    $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');
}
Example #2
0
}
$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');