how to use AND,OR in sql

Question

0.00/5 (No votes)

See more:

PHP

<?php
$search = $_POST['searchvalue'];
    $search= $_POST['searchvalue'];//first time the 'searchvalue' is from form
    $newsearch = $_GET['searchvalue'];//for next time 'searchvalue' is from url
 if((!$newsearch) && strlen($search)<=1)
    {
    echo "Search term too short";
    }
    else{    	    	
        echo "You searched for $search <hr size='1'></br>";
    $construct = "SELECT * FROM books WHERE category = '$name' AND ((title LIKE '%$search% ' or author LIKE '%$search% ')  or (title LIKE '%$newsearch% ' or author LIKE '%$newsearch% ' ))";
    $run = mysql_query($construct);
    $foundnum = mysql_num_rows($run);
    if ($foundnum==0){
    	//echo $_GET['start'];
    echo "Sorry, there are no matching result for $search.</br></br>1.";
    }
    else
    {
    echo "$foundnum results found !<p>";
    }
//I have next button here.
?>

if search results have 10 records i want to print 5 records per page, for first search i am getting 5 records in first page successfully it is only happening with this sql query

<br />
"$construct=SELECT * FROM books WHERE category = '$name' AND (title LIKE '%$search% ' or author LIKE '%$search% ')";

if i click next button the next five records is not printing in next page, its is due to POST, because FORM is in one php page and SEARCH.PHP is another page, I need to get the value from url for next search. so I used GET method, but problem is $search is using POST, hence I changed the sql query, like below as showed in code

$construct = "SELECT * FROM books WHERE category = '$name' AND ((title LIKE '%$search% ' or author LIKE '%$search% ')  or (title LIKE '%$newsearch% ' or author LIKE '%$newsearch% ' ))";<br />

but this time its not working even for first search, please anyone help me how to modify my query to GET the correct results. And sorry for my poor english. please try to understand my problem.

Posted 26-Feb-15 19:14pm

Member 11406049

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

hadi_rena · Answer 1 · 2015-02-26T19:52:00

Based on your question I assume that you want to have paging in your search result. Unfortunately paging in search result is impossible with POST method, you should use GET method.

Here sample code. It's should be working

PHP

<?php
// Chech whether specific page is requested or not
$page = isset($_GET["page"]) ? $_GET["page"] : 1;
// Get user search value
$search = $_GET["searchvalue"];
// We will have 5 record(s) each page
$maxRecordPerPage = 5;

// #01: Count total result
$construct = "SELECT COUNT(id) AS total FROM books WHERE category = '$category' AND (title LIKE '%$search%' OR author LIKE '%$search%')";
$run = mysql_query($construct);
if (!$run) {
	die("Count Result Failed");
}
$temp = mysql_fetch_assoc($run);
$total = $temp["total"];
$maxPage = ceil($total / $maxRecordPerPage);

// #02: Retrieve appropriate result based on user request
$startFrom = ($page - 1) * $maxRecordPerPage;
$construct = "SELECT * FROM books WHERE category = '$category' AND (title LIKE '%$search%' OR author LIKE '%$search%') LIMIT $startFrom, $maxRecordPerPage";
$run = mysql_query($construct);
if (!$run) {
	die("Count Result Failed");
}
?>

// HTML, BODY Removed from clarity

// Result Table
<table>
	<tr>
		<td>Title</td>
		<td>Author</td>
	</tr>
	<?php
	while ($row = mysql_fetch_assoc($run)) {
		print("<tr>");
		printf("<td>%s</td>", $row["title"]);
		printf("<td>%s</td>", $row["author"]);
		print("</tr>");
	}
	?>
</table>

// Paging for search
<ul>
	<?php
	for ($i = 1; $i <= $maxPage; $i++) {
		printf("<li><a href='search.php?page=%s&searchvalue=%s'>Page #%s</a></li>", $i, $search, $i);
	}
	?>
</ul>