Re: php search query
Posted: Mon Sep 02, 2013 6:05 am
Would I not need a variable for the other pages, or would it work fine like that for all of them?
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Code: Select all
<?php
$query = "SELECT * FROM downloads WHERE name LIKE :search LIMIT :start,:limit";
$ps = $pdo->prepare($query);
$ps->execute(array(':search' => '%' . $search . '%',
$ps->execute(array(':start' => $start,
$ps->execute(array(':limit' => $limit));
$num_rows = ($ps->fetchColumn());
$page=1;//Default page
$limit=5;//Records per page
$start=0;//starts displaying records from 0
if(isset($_GET['page']) && $_GET['page']!=''){
$page=$_GET['page'];
}
$start=($page-1)*$limit;
?>Code: Select all
<?php
$page = 1; //Default page
$limit = 5; //Records per page
if (isset($_GET['page']) && $_GET['page'] != '') {
$page= (intval) $_GET['page'];
}
$start = ($page - 1) * $limit;
$query = "SELECT name, category, username, file FROM downloads WHERE name LIKE :search LIMIT :start, :limit";
$ps = $pdo->prepare($query);
$ps->execute(array(
':search' => '%' . $search . '%',
':start' => $start,
':limit' => $limit
));
$num_rows = $ps->rowCount;Code: Select all
if (isset($_GET['page']) && $_GET['page'] != '') {
$page= (intval) $_GET['page'];
}
Code: Select all
$page = intval($_GET['page']);Code: Select all
<center>
<?php
require_once('submit/db/db_connection.php');
$search = (isset($_POST['search'])) ? ($_POST['search']) : '' ;
define('PUN_ROOT', dirname(__FILE__).'/../');
include PUN_ROOT.'include/common.php';
require_once('submit/db/db_connection.php');
?>
<?php
$page = 1; //Default page
$limit = 5; //Records per page
$start=0;//starts displaying records from 0
if(isset($_GET['page']) && $_GET['page']!=''){
$page=$_GET['page'];
}
$start=($page-1)*$limit;
function pagination($per_page = 10, $page = 1, $url = '', $total){
$adjacents = "2";
$page = ($page == 0 ? 1 : $page);
$start = ($page - 1) * $per_page;
$prev = $page - 1;
$next = $page + 1;
$lastpage = ceil($total/$per_page);
$lpm1 = $lastpage - 1;
$pagination = "";
if($lastpage > 1)
{
$pagination .= "<ul class='pagination'>";
$pagination .= "<li class='details'>Page $page of $lastpage</li>";
if ($lastpage < 7 + ($adjacents * 2))
{
for ($counter = 1; $counter <= $lastpage; $counter++)
{
if ($counter == $page)
$pagination.= "<li><a class='current'>$counter</a></li>";
else
$pagination.= "<li><a href='{$url}$counter'>$counter</a></li>";
}
}
elseif($lastpage > 5 + ($adjacents * 2))
{
if($page < 1 + ($adjacents * 2))
{
for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++)
{
if ($counter == $page)
$pagination.= "<li><a class='current'>$counter</a></li>";
else
$pagination.= "<li><a href='{$url}$counter'>$counter</a></li>";
}
$pagination.= "<li class='dot'>...</li>";
$pagination.= "<li><a href='{$url}$lpm1'>$lpm1</a></li>";
$pagination.= "<li><a href='{$url}$lastpage'>$lastpage</a></li>";
}
elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2))
{
$pagination.= "<li><a href='{$url}1'>1</a></li>";
$pagination.= "<li><a href='{$url}2'>2</a></li>";
$pagination.= "<li class='dot'>...</li>";
for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++)
{
if ($counter == $page)
$pagination.= "<li><a class='current'>$counter</a></li>";
else
$pagination.= "<li><a href='{$url}$counter'>$counter</a></li>";
}
$pagination.= "<li class='dot'>..</li>";
$pagination.= "<li><a href='{$url}$lpm1'>$lpm1</a></li>";
$pagination.= "<li><a href='{$url}$lastpage'>$lastpage</a></li>";
}
else
{
$pagination.= "<li><a href='{$url}1'>1</a></li>";
$pagination.= "<li><a href='{$url}2'>2</a></li>";
$pagination.= "<li class='dot'>..</li>";
for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++)
{
if ($counter == $page)
$pagination.= "<li><a class='current'>$counter</a></li>";
else
$pagination.= "<li><a href='{$url}$counter'>$counter</a></li>";
}
}
}
if ($page < $counter - 1){
$pagination.= "<li><a href='{$url}$next'>Next</a></li>";
// $pagination.= "<li><a href='{$url}$lastpage'>Last</a></li>";
}else{
//$pagination.= "<li><a class='current'>Next</a></li>";
// $pagination.= "<li><a class='current'>Last</a></li>";
}
$pagination.= "</ul>\n";
}
return $pagination;
}
if (isset($_GET['page']) && $_GET['page'] != '') {
$page = intval($_GET['page']);
}
$start = ($page - 1) * $limit;
$query = "SELECT name, category, username, file FROM downloads WHERE name LIKE :search LIMIT :start, :limit";
$ps = $pdo->prepare($query);
$ps->execute(array(
':search' => '%' . $search . '%',
':start' => $start,
':limit' => $limit
));
$num_rows = $ps->rowCount;
//....
Code: Select all
//line 113
));
Code: Select all
$query = "SELECT name, category, username, file FROM downloads WHERE name LIKE :search LIMIT :start, :limit";
$ps = $pdo->prepare($query);
$ps->execute(array(
':search' => '%' . $search . '%',
':start' => $start,
':limit' => $limit
));
$num_rows = $ps->rowCount;
if ($pun_user['is_guest'])
header("location: ../login.php");
?>
Code: Select all
$pdo->setAttribute(PDO::ATTR_EMULATE_PREPARES, FALSE);Code: Select all
<?php
$search = (isset($_POST['search'])) ? ($_POST['search']) : '' ;
?>
<div id="form_area" class="boxed">
<h2 class="heading">Quick Search</h2>
<div class="content">
<form method="post" action="search.php">
<div>
<label>Filename:<br /></label>
<input type="text" class="textfield" name="search" value="" size="18" /><br /><br />
<input class="button" type="submit" value="Search" title="Search" /><br /><br />
• <a href="ad_search.php">Advanced Search</a>
</div>
</form>
</div>
</div>
Code: Select all
echo "• <span class='text_bold'>File</span>: " .$row['name']."<br /><br />";
echo "• <span class='text_bold'>Category</span>: " .$row['category']."<br /><br />";
echo "• <span class='text_bold'>Author</span>: " .$row['username']."<br /><br />";
echo "• <span class='text_bold'>Size</span>: " .$row['size']." MB<br /><br /> ";
What does that mean?chris98 wrote:I am still having trouble with the stdclass thing.
Once I remove the php from the code above, it allows it.( ! ) Fatal error: Cannot use object of type stdClass as array in C:\wamp\www\stronghold2nation\downloads\search.php on line 203