PHP manufacturer::search_by_name Examples

Example #1

File: searchManufacturer.php Project: sheffy61/Software-Engineering

</div>
<div class = "center1" >
<div style="text-align: center"></div>
<p style = "text-align:center; font-size: 30px"><b>List of manufacturers<b></p>
</div>

<div class = "center1" style="text-align:center" >

<?php 
include_once "manufacturersClass.php";
$obj = new manufacturer();
$search_text = "";
if (isset($_REQUEST['txtSearch'])) {
    $search_text = $_REQUEST['txtSearch'];
}
$obj->search_by_name($search_text);
echo "<table border='1'>";
echo "<tr style='background-color:olive; color:white; text-align:center'>\r\n\r\n<td>Manufacturer Name</td>\r\n<td>Manufacturer ID</td>\r\n<td>Address</td>\r\n<td> Edit/Delete</td>\r\n</tr>";
$row = $obj->fetch();
$style = "";
$i = 0;
while ($row) {
    if ($i % 2 == 0) {
        $style = "style='background-color:Khaki'";
    } else {
        $style = "";
    }
    echo "<tr {$style} >";
    echo "<td><span class='clickspot' onclick='getDesc({$row['manufacturer_id']})'>{$row['manufacturer_name']}<span></td>";
    echo "<td>{$row['manufacturer_id']}</td>";
    echo "<td>{$row['address']}</td>";