Deploy - MySQL to API - Method
<?php
// Database Settings
$dbserver = "[server path]";
$dbname = "[database name]";
$dbuser = "[database user]";
$dbpassword = "[database password]";
// Make a database connection
mysql_connect($dbserver,$dbuser,$dbpassword) or die('Could not connect: ' . mysql_error());
mysql_select_db($dbname);
// Set the URL Path
$route = '/products/';
$app->get($route, function () use ($app){
// Input Query Parameter
if(isset($_REQUEST['query'])){ $query = urldecode($_REQUEST['query']); } else { $query = '';}
// Build SQL Statement
$Query = "SELECT ID,Name,Price,Description FROM products";
$Query .= " WHERE Name LIKE '%" . $query . "%' OR Description LIKE '%" . $query . "%'";
$Query .= " ORDER BY Name DESC";
$Query .= " LIMIT 25";
$ProductResult = mysql_query($Query) or die('Query failed: ' . mysql_error());
$Products = array();
while ($Product = mysql_fetch_assoc($ProductResult))
{
// Pull Each Record
$ID = $Product['ID'];
$Name = $Product['Name'];
$Price = $Product['Price'];
$Description = $Product['Description'];
// Build Product Array
$P = array();
$P['ID'] = $ID;
$P['Name'] = $Name;
$P['Price'] = $Price;
$P['Description'] = $Description;
array_push($Products, $P);
}
// Return JSON
$app->response()->header("Content-Type", "application/json");
echo json_encode($Products);
});
?>