Exemplos de generate_page_links em PHP

Exemplo n.º 1

Arquivo: listing.php Projeto: Himanshuxone/basic_cms

"></td>
					</tr>
				<?php 
        } else {
            ?>
					<td>No image</td></tr>
				<?php 
        }
    }
    ?>
	 			</tbody>
	 			</table>
	 
	 			<?php 
    if ($num_pages > 1) {
        echo generate_page_links($cur_page, $num_pages);
    }
} else {
    ?>
 					<p style="font-size:16px;font-color:red; font-weight:bold;">Please login to see the list</p><br /><br />
						<a href="login.php">Login to continue</a>
 			<?php 
}
?>
 		</div>
 		</div>
 	</div>
</div>
</body>
<?php 
require_once 'footer.php';

Exemplo n.º 2

Arquivo: search_OK.php Projeto: xudedong/develop

echo '</tr>';
// Connect to the database
require_once 'connectvars.php';
$dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
// Query to get the total results
$query = build_query($user_search, $sort);
$result = mysqli_query($dbc, $query);
$total = mysqli_num_rows($result);
$num_pages = ceil($total / $results_per_page);
// Query again to get just the subset of results
$query = $query . " LIMIT {$skip}, {$results_per_page}";
$result = mysqli_query($dbc, $query);
while ($row = mysqli_fetch_array($result)) {
    echo '<tr class="results">';
    echo '<td valign="top" width="20%">' . $row['titile'] . '</td>';
    echo '<td valign="top" width="50%">' . substr($row['description'], 0, 100) . '...</td>';
    echo '<td valign="top" width="10%">' . $row['state'] . '</td>';
    echo '<td valign="top" width="20%">' . substr($row['date_posted'], 0, 10) . '</td>';
    echo '</tr>';
}
echo '</table>';
// Generate navigational page links if we have more than one page
if ($num_pages > 1) {
    echo generate_page_links($user_search, $sort, $cur_page, $num_pages);
}
mysqli_close($dbc);
?>

</body>
</html>

Exemplo n.º 3

Arquivo: entity_search.php Projeto: sdgdsffdsfff/docs-1

                <?php 
    $query = "SELECT * FROM def where name = '{$keywords}'";
    $result = mysqli_query($dbc, $query) or die('Error querying database.');
    if ($row = mysqli_fetch_array($result)) {
        render_item($dbc, $row, $db_name);
    }
    //$query = "SELECT * FROM def where name like '%$keywords%' or def like '%$keywords%' ORDER BY name ASC LIMIT 0,10";
    $query = build_query($keywords) . " LIMIT {$skip}, {$results_per_page}";
    $result = mysqli_query($dbc, $query) or die('Error querying database.');
    while ($row = mysqli_fetch_array($result)) {
        render_item($dbc, $row, $db_name);
    }
    if ($num_pages > 1) {
        generate_page_links($url, $cur_page, $num_pages);
    }
    ?>
                <p><font color="gray">获得约<?php 
    echo $total;
    ?>
条结果。</font></p>
                <hr>
            </div>
            <div class="col-md-2">
                <?php 
    render_related($dbc, $db_name, $keywords);
    ?>
            </div>

        </div>

Exemplo n.º 4

Arquivo: relation_in_docs.php Projeto: sdgdsffdsfff/docs-1

    <?php 
$relation_tab_id = 'docs';
include_once "./relation_header.php";
//$query = "SELECT * FROM resource where title like '%$keywords%' or description like '%$keywords%' ORDER BY title ASC LIMIT 0,10";
// Calculate pagination information
$cur_page = isset($_GET['page']) ? $_GET['page'] : 1;
$results_per_page = 10;
// number of results per page
$skip = ($cur_page - 1) * $results_per_page;
$total = get_total($docs, $dbc);
$num_pages = ceil($total / $results_per_page);
echo '<p></p>';
echo '<p><font color="gray">该语义关系出现于如下' . $total . '篇文献之中:</font></p>';
echo '<hr>';
$query = build_query($docs) . " LIMIT {$skip}, {$results_per_page}";
$result = mysqli_query($dbc, $query) or die('Error querying database.');
while ($row = mysqli_fetch_array($result)) {
    render_content($row);
}
if ($num_pages > 1) {
    generate_page_links($id, $cur_page, $num_pages);
}
?>

</div>
<!-- Example row of columns -->


<!-- /container -->
<?php 
include_once "./foot.php";

Exemplo n.º 5

Arquivo: search.php Projeto: sdgdsffdsfff/docs-1

//$query = "SELECT * FROM resource where title like '%$keywords%' or description like '%$keywords%' ORDER BY title ASC LIMIT 0,10";
$query = build_query($keywords, array_keys($recommended)) . " LIMIT {$skip}, {$results_per_page}";
$result = mysqli_query($dbc, $query) or die('Error querying database.');
while ($row = mysqli_fetch_array($result)) {
    $id = $row[id];
    //if (!array_key_exists($id, $recommended)) {
    $title = $row[title];
    $def = $row[description];
    echo "<a class = 'lead' href=\"resource_viewer.php?db_name={$db_name}&id={$id}\">{$title}</a><br>";
    echo '<font color="green">' . $row[creator] . ' ' . $row[source] . '</font><br>';
    echo tcmks_substr($def);
    echo "<br><br>";
    //}
}
if ($num_pages > 1) {
    generate_page_links($db_name, $keywords, $cur_page, $num_pages);
}
?>











                </div>
                <div class="col-md-4">