[SOLVED] PHP Query Error

AcidDriver · July 22, 2008

Hi all,

I am having a query problem with this one mySQL query through PHP. I bolded it for convenience.

<?php

{

// Else, connect direct to the database

mysql_connect("localhost", "root", "") or die(mysql_error()); //Need to setup dedicated H.O.P.E server to link to mySQL, then input user/server info.

mysql_select_db("hope") or die(mysql_error());

//Search for search term once in database.

$data = mysql_query("SELECT * FROM 'hope' WHERE '$_POST['field']' LIKE '$_POST['find']'");

//Display results

while($result = mysql_fetch_array( $data ))

{

echo "";

echo $result['fname'];

echo " ";

echo $result['lname'];

echo " ID Number: ";

echo $result['idnum'];

echo " Graduation Year: ";

echo $result['gradyear'];

//echo " Donor: ";

//echo $result['donor'];

//echo " FOH/Community Partner: ";

//echo $result['foh'];

echo " Organization/Firm: ";

echo $result['org'];

//echo " HOPE Fellow: ";

//echo $result['fellow'];

//echo " HOPE Senior Fellow: ";

//echo $result['sfellow'];

//echo " Miami Scholar: ";

//echo $result['scholar'];

//echo " Public Interest Loan Reduction Recipient: ";

//echo $result['lreduce'];

echo " Home Address:";

echo $result['address'];

echo " ";

echo $result['city'] .", " .$result['state'] ." " .$result['zip'];

echo " Work Address: ";

echo $result['waddress'];

echo " ";

echo $result['wcity'] .", " .$result['wstate'] ." " .$result['wzip'];

echo " Work Phone:";

echo $result['wphone'];

echo " Fax number: ";

echo $result['fax'];

echo " Cell Phone: ";

echo $result['cphone'];

echo " Email:";

echo $result['email'];

//echo " Interests: ";

//echo $result['Interests'];

//echo " Project Leader: ";

//echo $result['project'];

//echo " HOPE Liason: ";

//echo $result['liason'];

//echo " Center for Ethics and Public Service Liason: ";

//echo $result['pliason'];

echo " Community Service Hours:";

echo $result['comtotalhours'];

echo " <dd>Project Name/Agency: </dd>";

echo $result['comagency'];

echo " <dd>Date of Project: </dd>";

echo $result['comdate'];

echo " <dd>Community Service Project Hours: </dd>";

echo $result['comhours'];

echo " Advocacy Service Hours: ";

echo $result['adtotalhours'];

echo " <dd>Project Name/Agency: </dd>";

echo $result['adagency'];

echo " <dd>Date of Project: </dd>";

echo $result['addate'];

echo " <dd>Hours Volunteered: </dd>";

echo $result['adhours'];

echo " <dd>Supervising Attorney: </dd>";

echo $result['adattorney'];

echo " <dd>Attorney Contact: </dd>";

echo $result['adattorneycon'];

//echo " Languages: ";

//echo $result['languages'];

echo " ";

}

//This counts the number or results - and if there wasn't any it gives them a little message explaining that

$matchnum=mysql_num_rows($data);

if ($matchnum == 0)

{

echo "There were no results for you mySQL query. ";

}

//Echo back what the user searched for:

echo "Searched For: " .$find;

echo "Number of Results: " .$matchnum;

echo " ";

echo '<a href="http://127.0.0.1/HOPE%20Database/index.htm">Search Again</a>';

}

?>

I am running PHP 5.2

I have not tried anything, becuase enything that I do try, seems to turn up more errors.

I am trying to have this script search for a field that is passed from the HTML Page.

<html>

<head>

<title>Welcome to the HOPE Database</title>

</head>

<body>

<h1>H.O.P.E Volunteer Database Search</h1>

Please enter your database query below.

Search: <input type="text" value="$find" name="find" /> Category:

<Option value="fname">First Name</option>

<Option value="idnum">ID Number</option>

<option value="gradyear">Graduation Year</option>

</Select>

</form>

<a href="volunteer.htm">Input a new volunteer</a>

</body>

</html>

revraz · July 22, 2008

And you don't post any of the errors you get... so we can only guess.

One thing, you dont put single quotes around the Table Name 'Hope', you need backticks `Hope`

Next, you'll want to put { } around your POST arrays.

Without more info from you, it's hard to tell what errors you get and where.

AcidDriver · July 22, 2008

....... and i think that is a complete lack of attention...

sorry everyone

Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in H:\Documents\My Web Sites\HOPE Search Database\search.php on line 10

AcidDriver · July 22, 2008

I am trying out this new query, because my previous one just acted like a wildcard, showing me every entry.

AcidDriver · July 22, 2008

Oh wow, you two fixes worked!!! There are new errors here though.

The first, and most important, is that no results will show up, even if the data is correct.

For instance, if I search Damian in First Name, stored as fname in the HTML form, as well as in the mySQL table, it gives this.

There were no results for you mySQL query.

Notice: Undefined variable: find in H:\Documents\My Web Sites\HOPE Search Database\search.php on line 94

Searched For: Number of Results: 0

Sign In

[SOLVED] PHP Query Error

Recommended Posts

AcidDriver

Link to comment

Share on other sites

revraz

Link to comment

Share on other sites

AcidDriver

Link to comment

Share on other sites

AcidDriver

Link to comment

Share on other sites

AcidDriver

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information