PHP supplier::fetch_object Examples

Example #1

File: supplier_informations.php Project: patmark/care2x-tz

$supplier_obj->dbconnect();
$supplier_obj->dbselect();
switch ($mode) {
    case 'show':
        $result = $supplier_obj->show_supplier_details($supplier_id);
        $results = 'gui/gui_show_supplier.php';
        break;
    case 'edit':
        $result = $supplier_obj->show_supplier_details($supplier_id);
        $results = 'gui/gui_edit_supplier.php';
        break;
    case 'erase':
        $result = $supplier_obj->show_supplier_details($supplier_id);
        $results = 'gui/gui_delete_supplier.php';
}
while ($show_result = $supplier_obj->fetch_object($result)) {
    $id = $show_result->Suplier_id;
    $company = $show_result->Company_Name;
    $person = $show_result->Contact_Person;
    $address1 = $show_result->Address1;
    $address2 = $show_result->Address2;
    $phone1 = $show_result->Phone1;
    $phone2 = $show_result->Phone2;
    $cell1 = $show_result->Cell1;
    $cell2 = $show_result->Cell2;
    $mail = $show_result->Email;
    $fax = $show_result->Fax;
    $banker = $show_result->Banker;
    $bankdetails = $show_result->Bank_Details;
    $account = $show_result->Account_no;
    $creditlimit = $show_result->Credit_Limit;

Example #2

File: purchase_order_supplier.php Project: patmark/care2x-tz

 $supplier_obj->dbconnect();
 $supplier_obj->dbselect();
 if ($keyword == "*") {
     //$sql2="select Suplier_id,Company_Name,Contact_Person from care_tz_supplier_deatail ORDER BY Suplier_id DESC";
     $result = $supplier_obj->get_all_suppliers();
 } else {
     if ($keyword && $criteria) {
         $result = $supplier_obj->get_criteria_search_results($criteria, $keyword);
     }
 }
 if ($result) {
     $number_of_search_results = $supplier_obj->recordcount($result);
     $message = "";
     $bg_color_change = 1;
     //#CCCCCC#ffffaa#EEEEEE#ffffdd
     while ($search_element = $supplier_obj->fetch_object($result)) {
         if ($bg_color_change) {
             $http_buffer .= "<tr bgcolor=#CCCCCC>";
             $bg_color_change = 0;
         } else {
             $http_buffer .= "<tr bgcolor=#EEEEEE>";
             $bg_color_change = 1;
         }
         $supplier_id = $search_element->Suplier_id;
         $company_name = $search_element->Company_Name;
         $contactperson = $search_element->Contact_Person;
         $http_buffer .= " <td>" . $supplier_id . "</td>\n                    <td>" . $company_name . "</td>\n                    <td>" . $contactperson . "</td>\n\n\n\n\n                    <td><div align=\"center\"><a href=\"purchase_order.php?mode=create&supplier_id=" . $supplier_id . "\"><img src=\"" . $root_path . "gui/img/common/default/en_ok_small.gif\"    border=\"0\"></a></td>\n                    ";
         $http_buffer .= "</tr>";
     }
 } else {
     $message = "Specify a Search Criteria Please";