PHP _set_fetch_array_ 예제들

예제 #1

파일: class_inbox.php 프로젝트: ocpyosep78/ORDER-SMS

 function _class_inbox_($var_pesanno = "", $var_nohp = "", $var_tanggal = "")
 {
     $var_criteria = "";
     if (_is_not_null_($var_pesanno)) {
         $var_criteria = "pesanno = " . _set_input_string_($var_pesanno);
     }
     if (_is_not_null_($var_nohp)) {
         if (_is_not_null_($var_criteria)) {
             $var_criteria .= " AND ";
         }
         $var_criteria .= "nohp LIKE '%" . _set_input_string_($var_nohp) . "%'";
     }
     if (_is_not_null_($var_tanggal)) {
         if (_is_not_null_($var_criteria)) {
             $var_criteria .= " AND ";
         }
         $var_criteria .= "tanggal = '" . _set_input_string_($var_tanggal) . "'";
     }
     if (_is_not_null_($var_criteria)) {
         $var_criteria = " WHERE " . $var_criteria;
     }
     $this->var_array_inbox = array();
     $var_query_link = _set_query_("SELECT * FROM " . def_table_inbox . $var_criteria . " ORDER BY tanggal DESC");
     while ($var_array_inbox = _set_fetch_array_($var_query_link)) {
         $this->var_array_inbox[$var_array_inbox['pesanno']] = array('nohp' => $var_array_inbox['nohp'], 'pesan' => $var_array_inbox['pesan'], 'tanggal' => $var_array_inbox['tanggal'], 'statusyn' => $var_array_inbox['statusyn']);
     }
 }

예제 #2

파일: function_database.php 프로젝트: ocpyosep78/ORDER-SMS

function _set_field_value($var_table_name, $var_field_name, $var_criteria, $var_global_link = "db_link")
{
    global ${$var_global_link};
    $var_query_link = _set_query_("SELECT " . $var_field_name . " FROM " . $var_table_name . " WHERE " . $var_criteria);
    if (_get_num_rows_($var_query_link) > 0) {
        $var_array_link = _set_fetch_array_($var_query_link);
        return $var_array_link[$var_field_name];
    }
}

예제 #3

파일: class_daftarharga.php 프로젝트: ocpyosep78/ORDER-SMS

 function _set_data_($var_kode)
 {
     $var_query_link = _set_query_("SELECT * FROM " . def_table_daftarharga . " WHERE kode='" . _set_input_string_($var_kode) . "'");
     while ($var_array_daftarharga = _set_fetch_array_($var_query_link)) {
         $this->var_kode = $var_array_daftarharga['kode'];
         $this->var_menuid = $var_array_daftarharga['menuid'];
         $this->var_tanggal = $var_array_daftarharga['tanggal'];
         $this->var_harga = $var_array_daftarharga['harga'];
     }
 }

예제 #4

파일: class_handphone.php 프로젝트: ocpyosep78/ORDER-SMS

 function _set_data_($var_handphoneno)
 {
     $var_query_link = _set_query_("SELECT * FROM " . def_table_handphone . " WHERE handphoneno=" . _set_input_string_($var_handphoneno));
     while ($var_array_handphone = _set_fetch_array_($var_query_link)) {
         $this->var_model = $var_array_handphone['model'];
         $this->var_port = $var_array_handphone['port'];
         $this->var_connection = $var_array_handphone['connection'];
         $this->var_activeyn = $var_array_handphone['activeyn'];
     }
 }

예제 #5

파일: class_contactus.php 프로젝트: ocpyosep78/ORDER-SMS

 function _set_data_($var_contactusid)
 {
     $var_query_link = _set_query_("SELECT * FROM " . def_table_contactus . " WHERE contactusid='" . _set_input_string_($var_contactusid) . "'");
     while ($var_array_contactus = _set_fetch_array_($var_query_link)) {
         $this->var_contactusid = $var_array_contactus['contactusid'];
         $this->var_email = $var_array_contactus['email'];
         $this->var_nama = $var_array_contactus['nama'];
         $this->var_tanggal = $var_array_contactus['tanggal'];
         $this->var_pesan = $var_array_contactus['pesan'];
     }
 }

예제 #6

파일: function_session.php 프로젝트: ocpyosep78/ORDER-SMS

function _session_write_($var_sessionid, $var_value)
{
    global $SESS_LIFE;
    $var_expiry = time() + $SESS_LIFE;
    $var_query_link = _set_query_("SELECT count(*) AS total FROM " . def_table_session . " WHERE sessionid='" . _set_input_string_($var_sessionid) . "'");
    $var_array_value = _set_fetch_array_($var_query_link);
    if ($var_array_value["total"] > 0) {
        return _set_query_("UPDATE " . def_table_session . " set expiry='" . _set_input_string_($var_expiry) . "', value='" . _set_input_string_($var_value) . "' WHERE sessionid='" . _set_input_string_($var_sessionid) . "'");
    } else {
        return _set_query_("INSERT INTO " . def_table_session . " VALUES ('" . _set_input_string_($var_sessionid) . "', '" . _set_input_string_($var_expiry) . "', '" . _set_input_string_($var_value) . "')");
    }
}

예제 #7

파일: class_setting.php 프로젝트: ocpyosep78/ORDER-SMS

 function _is_autoreply_()
 {
     $var_query_link = _set_query_("SELECT * FROM " . def_table_setting . " WHERE name='auto reply'");
     if (_get_num_rows_($var_query_link) > 0) {
         $var_objsetting = _set_fetch_array_($var_query_link);
         if (trim($var_objsetting["value"]) == "1") {
             return true;
         } else {
             return false;
         }
     } else {
         return true;
     }
 }

예제 #8

파일: class_voucher.php 프로젝트: ocpyosep78/ORDER-SMS

 function _get_voucher_($var_userid)
 {
     if (!_is_not_null_($var_userid)) {
         return 0;
     }
     $var_query_link = _set_query_("SELECT jumlah FROM " . def_table_voucher . " WHERE userid='" . _set_input_string_($var_userid) . "'");
     $var_jumlah = 0;
     while ($var_array_voucher = _set_fetch_array_($var_query_link)) {
         $var_jumlah += _set_double_($var_array_voucher['jumlah'], 0);
     }
     $var_query_link = _set_query_("SELECT jumlah FROM " . def_table_output . " WHERE userid='" . _set_input_string_($var_userid) . "'");
     while ($var_array_output = _set_fetch_array_($var_query_link)) {
         $var_jumlah -= _set_double_($var_array_output['jumlah'], 0);
     }
     return $var_jumlah;
 }

예제 #9

파일: class_user.php 프로젝트: ocpyosep78/ORDER-SMS

 function _is_status_($var_userid)
 {
     if (!_is_not_null_($var_userid)) {
         return false;
     }
     $var_query_link = _set_query_("SELECT statusyn FROM " . def_table_pemakai . " WHERE userid='" . _set_input_string_($var_userid) . "'");
     if (_get_num_rows_($var_query_link) > 0) {
         $var_array_user = _set_fetch_array_($var_query_link);
         if ($var_array_user["statusyn"] == def_yes) {
             return true;
         } else {
             return false;
         }
     } else {
         return false;
     }
 }

예제 #10

파일: class_jenis.php 프로젝트: ocpyosep78/ORDER-SMS

 function _delete_data_($var_jenisid)
 {
     if (!_is_not_null_($var_jenisid)) {
         return false;
     }
     if ($this->_is_primary_exist_($var_jenisid)) {
         _set_query_("DELETE FROM " . def_table_jenis . " WHERE jenisid='" . _set_input_string_($var_jenisid) . "'");
         $var_query_link = _set_query_("SELECT menuid FROM " . def_table_menu . " WHERE jenisid='" . _set_input_string_($var_jenisid) . "'");
         while ($var_array_menu = _set_fetch_array_($var_query_link)) {
             _set_query_("DELETE FROM " . def_table_pesan_detil . " WHERE menuid='" . _set_input_string_($var_array_menu['menuid']) . "'");
             _set_query_("DELETE FROM " . def_table_keranjang . " WHERE menuid='" . _set_input_string_($var_array_menu['menuid']) . "'");
             _set_query_("DELETE FROM " . def_table_daftarharga . " WHERE menuid='" . _set_input_string_($var_array_menu['menuid']) . "'");
         }
         _set_query_("DELETE FROM " . def_table_menu . " WHERE jenisid='" . _set_input_string_($var_jenisid) . "'");
     } else {
         return false;
     }
 }

예제 #11

파일: rpc.php 프로젝트: ocpyosep78/ORDER-SMS

function _check_it_($var_userid, $var_menuid, $var_qty, &$var_subtotal, &$var_total)
{
    require_once def_directory_classes . "class_keranjang.php";
    $var_class_keranjang = new _class_keranjang_();
    $var_subtotal = 0;
    $var_total = 0;
    $var_query_link = _set_query_("SELECT menuid, qty FROM " . def_table_keranjang . " WHERE userid='" . _set_input_string_($var_userid) . "' AND menuid='" . _set_input_string_($var_menuid) . "'");
    while ($var_menu = _set_fetch_array_($var_query_link)) {
        $var_subtotal += (int) $var_qty * _set_double_($var_class_keranjang->_set_harga_($var_menu['menuid']), 0);
    }
    $var_query_link = _set_query_("SELECT menuid, qty FROM " . def_table_keranjang . " WHERE userid='" . _set_input_string_($var_userid) . "'");
    while ($var_menu = _set_fetch_array_($var_query_link)) {
        if ($var_menu['menuid'] == $var_menuid) {
            $var_total += (int) $var_qty * _set_double_($var_class_keranjang->_set_harga_($var_menu['menuid']), 0);
        } else {
            $var_total += (int) $var_menu['qty'] * _set_double_($var_class_keranjang->_set_harga_($var_menu['menuid']), 0);
        }
    }
}

예제 #12

파일: class_keranjang.php 프로젝트: ocpyosep78/ORDER-SMS

 function _set_harga_($var_menuid)
 {
     $var_query_link = _set_query_("SELECT * FROM " . def_table_daftarharga . " WHERE menuid='" . _set_input_string_($var_menuid) . "' ORDER BY tanggal DESC");
     if (_get_num_rows_($var_query_link) > 0) {
         $var_array_daftarharga = _set_fetch_array_($var_query_link);
         return _set_double_($var_array_daftarharga['harga'], 0);
     } else {
         return 0;
     }
 }

예제 #13

파일: module_update.php 프로젝트: ocpyosep78/ORDER-SMS

echo _set_label_("", "Menu");
?>
</td>
                                                <td><?php 
echo _set_label_("", "Restoran");
?>
</td>
                                                <td><?php 
echo _set_label_("", "Qty");
?>
</td>
                                                <td>&nbsp;</td>
                                            </tr>
                                            <?php 
$var_query_link = _set_query_("SELECT * FROM " . def_table_pesan_detil . " WHERE notransaksi='" . _set_input_string_($var_class_pesan->var_notransaksi) . "'");
while ($var_array_pesan = _set_fetch_array_($var_query_link)) {
    ?>
                                            <tr>
                                                <td>
                                                    <?php 
    echo _set_label_("", $var_array_pesan['menuid'] . ' - ' . _set_field_value(def_table_menu, "nama", "menuid='" . _set_input_string_($var_array_pesan['menuid']) . "'"));
    ?>
                                                </td>
                                                <td>
                                                    <?php 
    echo _set_label_("", _set_field_value(def_table_restoran, "nama", "restoranid='" . _set_input_string_(_set_field_value(def_table_menu, "restoranid", "menuid='" . _set_input_string_($var_array_pesan['menuid']) . "'")) . "'"));
    ?>
                                                </td>
                                                <td>
                                                    <?php 
    echo _set_label_("", $var_array_pesan['qty']);

예제 #14

파일: class_pemakai.php 프로젝트: ocpyosep78/ORDER-SMS

 function _delete_data_($var_userid)
 {
     if (!_is_not_null_($var_userid)) {
         return false;
     }
     if ($this->_is_primary_exist_($var_userid)) {
         _set_query_("DELETE FROM " . def_table_pemakai . " WHERE userid='" . _set_input_string_($var_userid) . "'");
         _set_query_("DELETE FROM " . def_table_voucher . " WHERE userid='" . _set_input_string_($var_userid) . "'");
         $var_query_link = _set_query_("SELECT notransaksi FROM " . def_table_pesan_header . " WHERE userid='" . _set_input_string_($var_userid) . "'");
         while ($var_array_pesan_header = _set_fetch_array_($var_query_link)) {
             _set_query_("DELETE FROM " . def_table_pesan_detil . " WHERE notransaksi='" . _set_input_string_($var_array_pesan_header['notransaksi']) . "'");
         }
         _set_query_("DELETE FROM " . def_table_pesan_header . " WHERE userid='" . _set_input_string_($var_userid) . "'");
         _set_query_("DELETE FROM " . def_table_output . " WHERE userid='" . _set_input_string_($var_userid) . "'");
         _set_query_("DELETE FROM " . def_table_login . " WHERE userid='" . _set_input_string_($var_userid) . "'");
         _set_query_("DELETE FROM " . def_table_keranjang . " WHERE userid='" . _set_input_string_($var_userid) . "'");
     } else {
         return false;
     }
 }