dropping my domain name path from url link

Discussion in 'PHP' started by Loulee, Oct 4, 2010.

  1. #1
    A url path is sent back to my page from a search box. When I click on the link which displays correctly, the address in my address bar adds my domain name which then stops the page being loaded and I get the 404 error. The part of the code where I am having trouble is: (Thank you in advance if you are able to help!)

    $query = "select * from movie where movie_title like \"%$trimmed%\"
    order by movie_title"; // EDIT HERE and specify your table and field names for the SQL query

    $numresults=mysql_query($query)or die (mysql_error());
    $numrows=mysql_num_rows($numresults) or die (mysql_error());
    // If we have no results, offer a google search as an alternative

    if ($numrows == 0)
    {
    echo "<h4>Results</h4>";
    echo "<p>Sorry, your search: &quot;" . $trimmed . "&quot; returned zero results</p>";

    // google
    echo "<p><a href=\"http://www.google.com/search?q="
    . $trimmed . "\" target=\"_blank\" title=\"Look up
    " . $trimmed . " on Google\">Click here</a> to try the
    search on google</p>";
    }

    // next determine if s has been passed to script, if not use 0
    if (empty($s)) {
    $s=0;
    }

    // get results
    $query .= " limit $s,$limit";
    $result = mysql_query($query) or die("Couldn't execute query");

    // display what the person searched for
    echo "<p>You searched for: &quot;" . $var . "&quot;</p>";

    // begin to show results set
    echo "The following results have been found:";
    echo "<br />";
    $count = 1 + $s ;

    // now you can display the results returned
    while ($row= mysql_fetch_array($result)) {
    $title = $row["movie_link"];
    $title_encoded = urlencode($title);
    echo "<a href=" . $title_encoded . ">" . $title . "</a>";
    echo "<br />";
    //echo "$count.)&nbsp;$title" ;
    $count++ ;
    }

    $currPage = (($s/$limit) + 1);

    //break before paging
    echo "<br />";

    // next we need to do the links to other results
    if ($s>=1) { // bypass PREV link if s is 0
    $prevs=($s-$limit);
    print "&nbsp;<a href=\"$PHP_SELF?s=$prevs&q=$var\">&lt;&lt;
    Prev 10</a>&nbsp&nbsp;";
    }

    // calculate number of pages needing links
    $pages=intval($numrows/$limit);

    // $pages now contains int of pages needed unless there is a remainder from division

    if ($numrows%$limit) {
    // has remainder so add one page
    $pages++;
    }

    // check to see if last page
    if (!((($s+$limit)/$limit)==$pages) && $pages!=1) {

    // not last page so give NEXT link
    $news=$s+$limit;

    echo "&nbsp;<a href=\"$PHP_SELF?s=$news&q=$var\">Next 10 &gt;&gt;</a>";
    }

    $a = $s + ($limit) ;
    if ($a > $numrows) { $a = $numrows ; }
    $b = $s + 1 ;
    echo "<p>Showing results $b to $a of $numrows</p>";

    ?>

    </body>
    </html>
     
    Loulee, Oct 4, 2010 IP
  2. Loulee

    Loulee Peon

    Messages:
    2
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    I have just solved this problem, but if anyone else was having the same problem you need to use the htmlspecialchars to drop your domain name showing up as well $title_encoded = htmlspecialchars($title);
     
    Loulee, Oct 4, 2010 IP