Closed

Fix search function using php on Wordpress blog

This project was awarded to abdoosilver for $64 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
$30 - $250 USD
Total Bids
26
Project Description

I have a Wordpress website/blog here: [url removed, login to view]

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 [url removed, login to view] 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.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online