echo search query results to another html page

Question

4.00/5 (1 vote)

See more:

how can i echo out the search query results to another page.. I know you have to save it in $_session then header it out but i can figure it out.. help me please! the search bar would be on top of my page.. and would this fix the "Confirm Form Resubmission" prompt?

PHP

<?php

error_reporting(E_ALL);
ini_set('display_errors', '1');

$search_output = "";
if(isset($_POST['searchquery']) && $_POST['searchquery'] != ""){
    $searchquery = preg_replace('#[^a-z 0-9?!]#i', '', $_POST['searchquery']);
{
    $sqlCommand = "(SELECT id, links, page_body, page_title AS title FROM pages WHERE MATCH(page_title,page_body) AGAINST ('$searchquery'))";
}
include_once("db_connects.php");
$query = mysql_query($sqlCommand) or die(mysql_error());
$count = mysql_num_rows($query);
if($count > 1){
    $search_output .= "<hr />$count results for $searchquery<hr />";
     while($row = mysql_fetch_array($query)){

    $id = $row["id"];
    $title = $row["title"];
    $link = $row["links"];
    $body = $row["page_body"];

    $search_output .= "<a href='".$link."'>".$title."</a> - $body<br>";

    } // close while
} else {
    $search_output = "<hr />0 results for $searchquery<hr />";

  
}
}
  ?>

Posted 4-Apr-13 19:13pm

suzanne88

Add a Solution

Comments

Prasad Khandekar 5-Apr-13 2:11am

Hello Suzanne,

Why can't this page output the search reasults? Consider using a framework like CodeIgnitor or Prado.

Regards,

3 solutions

Solution 2

Hello Suzzane,

You probably do not need to redirect to another page. I am assuming that links are seperated by a semicolon and each link is a well formed html just like the page body. If these assumptions are corret then you can alter your page as shown below.

PHP

<?php
error_reporting(E_ALL);
ini_set('display_errors', '1');
include_once("db_connects.php");
 
if (isset($_POST['searchquery']) && $_POST['searchquery'] != "") {
    $searchquery = preg_replace('#[^a-z 0-9?!]#i', '', $_POST['searchquery']);

    $sqlCommand = "(SELECT id, links, page_body, page_title AS title FROM pages WHERE MATCH(page_title,page_body) AGAINST ('$searchquery'))";

    $result = mysql_query($sqlCommand) or die(mysql_error());
    $row = mysql_fetch_row($result);
    if ($row) {?<
<html>
<head>
<title><?=$row[3]?></title>
<?php
$links = exlpode(';', $row[1]);
foreach ($array as $i => $links) {
    echo $links[$i];
}?>
</head>
<body><?=$row[2]?></body>
</html>
<?php
    }
    mysql_free_result($result);
}

Regards,

Posted 4-Apr-13 20:38pm

Prasad Khandekar

Solution 1

hi prasad,

this code would be in my header which is where the search bar would be. if someone types in a search the results would have to show up on another page. im pretty new to coding and never heard of CodeIgnitor or Prado... i just want to php this result to another page

Posted 4-Apr-13 20:20pm

suzanne88

Comments

Prasad Khandekar 5-Apr-13 2:39am

Suzane use Have a Question or Comment? button to post the comments.

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)

suzanne88 · Accepted Answer · 2013-04-05T13:24:00

I have solved my own question. now the newpage.php would have to session_start(); then foreach throught the values.

PHP

<?php

session_start();
error_reporting(E_ALL);
ini_set('display_errors', '1');

include_once("db_connects.php");

$queryArray = array();
$goodQuery = true;
$search_output = "";

if(isset($_POST['searchquery']) && $_POST['searchquery'] != ""){
    $searchquery = preg_replace('#[^a-z 0-9?!]#i', '', $_POST['searchquery']);
{
    $sqlCommand = "(SELECT id, links, page_body, page_title AS title FROM pages WHERE MATCH (page_title,page_body) AGAINST ('$searchquery'))";
}

$query = mysql_query($sqlCommand) or die(mysql_error());
$count = mysql_num_rows($query);

if($count > 1){

    $search_output .= "<hr />$count results for <strong>$searchquery</strong><hr />";

    while($row = mysql_fetch_assoc($query)){
        $queryArray[] = $row;
    }
}
else {
     $goodQuery = false;

}

if($goodQuery){

    $_SESSION['search_output'] = $queryArray;
    header("Location: newpage.php");

    exit;
}
else{
    echo $search_output;
}
}
  ?>