EMERGENCY! search function in my senior project!

annanicole

Hi I am extremely new at PHP. But like a nimrod I decided to use it in my senior project.

Here is the code from the search box:

ok now here is the code from my results page:
<?php require_once('Connections/Aiph.php'); ?>
<?php
$currentPage = $HTTP_SERVER_VARS["PHP_SELF"];

$sql = mysql_query("SELECT CityArea, FROM 'restaurant' WHERE CityArea LIKE %$area% ") or die (mysql_error());
?>
}

$maxRows_Recordset5 = 5;
$pageNum_Recordset5 = 0;
if (isset($HTTP_GET_VARS['pageNum_Recordset5'])) {
$pageNum_Recordset5 = $HTTP_GET_VARS['pageNum_Recordset5'];
}
$startRow_Recordset5 = $pageNum_Recordset5 * $maxRows_Recordset5;

mysql_select_db($database_Aiph, $Aiph);
$query_Recordset5 = "$sql";
$query_limit_Recordset5 = sprintf("%s LIMIT %d, %d", $query_Recordset5, $startRow_Recordset5, $maxRows_Recordset5);
$Recordset5 = mysql_query($query_limit_Recordset5, $Aiph) or die(mysql_error());
$row_Recordset5 = mysql_fetch_assoc($Recordset5);

if (isset($HTTP_GET_VARS['totalRows_Recordset5'])) {
$totalRows_Recordset5 = $HTTP_GET_VARS['totalRows_Recordset5'];
} else {
$all_Recordset5 = mysql_query($query_Recordset5);
$totalRows_Recordset5 = mysql_num_rows($all_Recordset5);
}
$totalPages_Recordset5 = ceil($totalRows_Recordset5/$maxRows_Recordset5)-1;

$queryString_Recordset5 = "";
if (!empty($HTTP_SERVER_VARS['QUERY_STRING'])) {
$params = explode("&", $HTTP_SERVER_VARS['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_Recordset5") == false &&
stristr($param, "totalRows_Recordset5") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_Recordset5 = "&" . implode("&", $newParams);
}
}
$queryString_Recordset5 = sprintf("&totalRows_Recordset5=%d%s", $totalRows_Recordset5, $queryString_Recordset5);
?>

The Connections/Aiph.php connects to my database for the recordset.

Ok I am sure you are asking what is with all the recordset crap? Well I want to display the reults in an orderfashion. If you check out this link:
stu.aii.edu/~anl183/php/index.php

You will be able to check out what I am trying to do. The individual links work i.e. Houston, Raleigh, etc.

I would appreciate any help to figure out what I have done wrong.

Thanks
Nicole

mattvenables

i'd love to help you out, but what's wrong with the code? what is it supposed to do/what does it not do correctly?

annanicole

I want to search my database, and display the results .

My database works. I used dreamweaver to create recordsets.

if you check out the site you will see everything but the search works
Check out the working site here

My table has the following:
Name
City
City area
address
description
telephone.

I want to search by say City area, but when the resulta are displayed I want to show each record with all fields (thus the recordset 5)

If this only complicates things let me know, I am ready to pull out all fo my hair 😉

Nicole

mattvenables

well, a couple things right off the top of my head:

for good practice, in the submit form, dont make the form name the same as any input names: you have the form named "area" and the input box named "area". This wont fix the problem, but it makes things less prone to error.

also, the code you showed for the results.php page wont compile; the first few lines are a problem:

<?php require_once('Connections/Aiph.php'); ?>
<?php
$currentPage = $HTTP_SERVER_VARS["PHP_SELF"];

$sql = mysql_query("SELECT CityArea, FROM 'restaurant' WHERE CityArea LIKE %$area% ") or die (mysql_error());
?>
}

see how you closed the php field? you never reopen it. and the "}" is out of place it seems. try removing the last two lines "?>" and "}" and see how the code works.

-Matt

annanicole

All I get is Parse errors with every line from the bottom

ok here is the entire page code

<?php require_once('Connections/Aiph.php'); ?>
<?php
{ 
   echo("<font face=\"tahoma\" size=\"3\" color=\"green\"><b>Results for $words</b></font><br><br>"); 
   $location = "*****"; // database host (localhost)
   $username = "*****"; // mysql username
   $password = "*****"; //mysql password
   $database = "*****"; //mysql database name


   $conn = mysql_connect("$location","$username","$password"); 
   if (!$conn) die ("Could not connect MySQL"); 
   mysql_select_db($database,$conn) or die ("Could not open database"); 

$currentPage = $HTTP_SERVER_VARS["PHP_SELF"];

$sql = mysql_query("SELECT CityArea,  FROM 'restaurant' WHERE CityArea LIKE %$area% ") or die (mysql_error());


$maxRows_Recordset5 = 5;
$pageNum_Recordset5 = 0;
if (isset($HTTP_GET_VARS['pageNum_Recordset5'])) {
  $pageNum_Recordset5 = $HTTP_GET_VARS['pageNum_Recordset5'];
}
$startRow_Recordset5 = $pageNum_Recordset5 * $maxRows_Recordset5;

mysql_select_db($database_Aiph, $Aiph);
$query_Recordset5 = "$sql";
$query_limit_Recordset5 = sprintf("%s LIMIT %d, %d", $query_Recordset5, $startRow_Recordset5, $maxRows_Recordset5);
$Recordset5 = mysql_query($query_limit_Recordset5, $Aiph) or die(mysql_error());
$row_Recordset5 = mysql_fetch_assoc($Recordset5);

if (isset($HTTP_GET_VARS['totalRows_Recordset5'])) {
  $totalRows_Recordset5 = $HTTP_GET_VARS['totalRows_Recordset5'];
} else {
  $all_Recordset5 = mysql_query($query_Recordset5);
  $totalRows_Recordset5 = mysql_num_rows($all_Recordset5);
}
$totalPages_Recordset5 = ceil($totalRows_Recordset5/$maxRows_Recordset5)-1;

$queryString_Recordset5 = "";
if (!empty($HTTP_SERVER_VARS['QUERY_STRING'])) {
  $params = explode("&", $HTTP_SERVER_VARS['QUERY_STRING']);
  $newParams = array();
  foreach ($params as $param) {
    if (stristr($param, "pageNum_Recordset5") == false && 
        stristr($param, "totalRows_Recordset5") == false) {
      array_push($newParams, $param);
    }
  }
  if (count($newParams) != 0) {
    $queryString_Recordset5 = "&" . implode("&", $newParams);
  }
}
$queryString_Recordset5 = sprintf("&totalRows_Recordset5=%d%s", $totalRows_Recordset5, $queryString_Recordset5);
?>

<html>

Nicole

mattvenables

mind if you show me Connections/Aiph.php? i dont get why you have the open bracket on the first line unless there is an if clause in that aiph.php file...

mattvenables

parse errors are a syntax error, so maybe you need to close that bracket some time during the code?

annanicole

connections is the connection to my database that dreamweaver uses to display the record set

<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_Aiph = "********";
$database_Aiph = "*****";
$username_Aiph = "*****";
$password_Aiph = "*****";
$Aiph = mysql_pconnect($hostname_Aiph, $username_Aiph, $password_Aiph) or die(mysql_error());
?>

Nicole

mattvenables

ok, so try removing that opening { on the results page. i think that will help with the parse errors.

annanicole

what about the recordset?

If I remove the connections how will it know where to take from?

mattvenables

no, i mean just remove the text "{" from the top of the results.php file. there's no need for it as far as i can see.

annanicole

should i just email you my files. I am ready to commit a completely brutal suicide.

Nicole

mattvenables

if you'd like to, that would be fine by me. i hope i can help!