Example #1
0
    {
        $db_connection = mysql_connect($this->db_server, $this->db_user, $this->db_password) or die(mysql_errno() . " - " . mysql_error() . "<br>");
        if (mysql_select_db($this->db_name)) {
            if (!($result = mysql_query("SELECT DISTINCT `cafe_id` FROM `cafeactivation`"))) {
                print __CLASS__ . "::" . __FUNCTION__ . "()[" . __FILE__ . ":" . __LINE__ . "]: " . mysql_errno() . " - " . mysql_error() . "<br>";
            }
        } else {
            print __CLASS__ . "::" . __FUNCTION__ . "()[" . __FILE__ . ":" . __LINE__ . "]: " . mysql_errno() . " - " . mysql_error() . "<br>";
        }
        //$row_count = mysql_num_rows($result);
        return $result;
        mysql_close($db_connection);
    }
}
//creating objects
$cafe_pay = new CafePay();
$cafe_details = new CafeDetails();
$result_cafe = $cafe_details->getAllActiveCafeIds();
while ($get_rows = mysql_fetch_array($result_cafe)) {
    $cafe_user_id = $get_rows['cafe_id'];
    $result = $cafe_details->getMacIdsByCafeUID($cafe_user_id);
    $amt = 0;
    while ($row = mysql_fetch_array($result)) {
        $mac_amt = 0;
        $mac_time = $cafe_pay->calcTimeOfMac($row['mac_id']);
        $mac_amt = $cafe_pay->calcAmountMac($cafe_user_id, $row['mac_id']);
        $amt = $amt + $mac_amt;
        $cafe_pay->insertPayMac($cafe_user_id, $row['mac_id'], $mac_time, $mac_amt);
    }
    $cafe_pay->insertPayCafe($cafe_user_id, $amt);
}