<?php
include 'functions.php';
include 'model.php';
$res = get_drug($_GET['query']);
foreach ($res as $value) {
?>
<div class ="search_content_info" id ="search_content">
<div class="details" id="more_details">
<ul class = "moredetailsinfolist" id ="moredetails_list">
<li>
<?php
if (!empty($value->productIMG)) {
?>
<img src = "<?php
print $value->productIMG;
?>
" height = "50" width = "50">
<?php
}
?>
</li>
<li class="moreinfo" id ="moredetaillink">
<?php
print "<a href = products.php?id={$value->productID} >{$value->productName}</a>";
?>
</li>
</ul>
</div>
</div>
<?php
require_once '../../config.php';
require_once '../../db_functions.php';
require_once '../../db_queries.php';
$patient_id = $_POST['patient'];
$doctor_id = $_POST['doctor'];
$specialty_id = $_POST['specialty'];
$drug_id = $_POST['drug'];
$route_id = $_POST['route'];
$amount = $_POST['amount'];
$patient = get_patient($patient_id);
$drug = get_drug($drug_id);
if (mysql_query("CALL add_order({$patient_id}, {$specialty_id}, {$doctor_id}, {$drug_id}, {$route_id}, {$amount})")) {
header('Location: ../confirmation/order_created.php?patient=' . $patient . '&drug=' . $drug);
} else {
header('Location: ../../error.php?error=' . mysql_error());
}
<?php
include 'functions.php';
include 'model.php';
echo embed('tpl/home.tpl.php', array('header' => embed('tpl/header.tpl.php', array()), 'sidebar_first' => embed('tpl/category.tpl.php', array('result' => get_category())), 'body' => embed('tpl/searchquery.tpl.php', array('result' => get_drug($_GET['query']))), 'sidebar_second' => embed('tpl/top_last_added.tpl.php', array('result' => last_added()))));
