Fix search function using php on Wordpress blog

IN PROGRESS
Bids
26
Avg Bid (USD)
N/A
Project Budget (USD)
$30 - $250

Project Description:
I have a Wordpress website/blog here: http://dietthatreallyworks.com

I am trying to set up a way to search a database. See the “Carb Database” page.

When a food is input, and “Search” is pressed, I want to execute the php code below.

The database is not part of the Wordpress site but is hosted on the same server.

I can send you the database.

"Mcarbs",
"Fiber" => "Mfiber",
"Sugar" => "Msugar",
"Sodium" => "Msodium",
"Saturated Fat" => "Msatfat",
"Total Fat" => "Mlipid",
"Cholesterol" => "Mchol");

// Get the search variable from URL

$var = @$_GET['q'];

//trim whitespace from the stored variable

$trimmed = trim($var);

// rows to return

$limit = 1000;

// check for a search parameter

if (strlen($trimmed) == 0 || strlen($var) == 0) {
// echo "We don't seem to have a search parameter!";

exit;
}

//connect to your database

mysql_connect("localhost", "***", "***") or die("Unable to connect to database"); // host, username, password
mysql_select_db("***") or die("Unable to select database"); // database

//specify database

// DEPRECATED mysql_select_db("carbs") or die("Unable to select database");

// Build SQL Query

$query = "SELECT * FROM `carbs` WHERE `Desc` LIKE '%" . mysql_real_escape_string($trimmed) . "%' ";

// $query = "select * from carbs where Desc like "%$trimmed%"";

// $numresults = $query->num_rows();

// $numresults=mysql_query($query);

// $numrows=mysql_num_rows($numresults);

// $numrows = $query->num_rows(); ????

// 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");

// $result = mysql_query($query) or die("Couldn't execute query");

// display what the person searched for

echo "You searched for: "" . strip_tags($var) . """;

echo "Results by food and serving sizes. "[No data]" means information not in database. Unless otherwise specified, results are in grams of carbs which is what we use to count our carbs.Search Results KeyCarbs: Total carbsFiber: Total fiberSugar: How many of the total carbs are simple carbsSodium: Milligrams of saltSaturated fat: How much bad fatTotal fat: Good and bad fat combinedCholesterol: Milligrams of cholesterol";
$count = 1 + $s ;

// now you can display the results returned

while ($row = mysql_fetch_array($result)) {
// $food = $row["Desc"];
// $calories = $row["Energy_Kcal"];
// $protein = $row["Protein_(g)"];

echo "";
$count++ ;
echo "" . $row["Desc"] . " ";
echo "Serving size 1: " . $row["GmWt_Desc1"] . ": ";
foreach ($carbs_1 as $key => $value) {
echo $key . ": " . $row[$value . "1"] . ", ";
}
echo "";
echo "Serving size 2: " . $row["GmWt_Desc2"] . ": ";
foreach ($carbs_1 as $key => $value) {
echo $key . ": " . $row[$value . "2"] . ", ";
}
}
echo "";

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

//break before paging

echo "";

// next we need to do the links to other results

if ($s >= 1) { // bypass PREV link if s is 0
$prevs = ($s-$limit);
print " <

Please provide me with files/instructions. Thank you.

Skills required:
MySQL, PHP, Wordpress
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.