PHP srch_hの例

コード例 #1

ファイル: site_pages.php プロジェクト: centaurustech/collaborate-usa

    }
    </script>
    <form action="" method="post" name="f1" onsubmit="return validate_f1();">
    <input type="hidden" name="command" value="del" />


    <table border="0" cellpadding="0" cellspacing="0" class="datagrid dg_middle" width="100%">

    <?php 
$recrd = false;
#### Build SQL
$where = "";
##### Search String
if ($search_it) {
    include_once "../../includes/srch_lib.php";
    $src = new srch_h();
    $get_where = '';
    if (!empty($sr_title)) {
        $get_where .= $src->where_it($sr_title, 'sp.title', 'title');
    }
    if (!empty($sr_seo_tag)) {
        $get_where .= $src->where_it($sr_seo_tag, 'st.seo_tag', 'seo_tag');
    }
    if ($sr_cat_id != '') {
        $get_where .= $src->where_it($sr_cat_id, 'cat_id', 'cat_id', 'equals');
    }
    if ($sr_is_active != '') {
        $get_where .= $src->where_it($sr_is_active, 'sp.is_active', 'is_active', 'equals');
    }
    if ($sr_popup_only != '') {
        $get_where .= $src->where_it($sr_popup_only, 'sp.popup_only', 'popup_only', 'equals');

コード例 #2

ファイル: site_contacts.php プロジェクト: centaurustech/collaborate-usa

*/
?>
    <form action="" method="post" name="f1" onsubmit="return validate_f1();">
    <input type="hidden" name="xcommand" value="del" />


    <table border="0" cellpadding="0" cellspacing="0" class="datagrid dg_middle" width="100%">

    <?php 
$recrd = false;
#### Build SQL
$where = "";
##### Search String
if ($search_it) {
    include_once "../../includes/srch_lib.php";
    $src = new srch_h();
    $get_where = '';
    if (!empty($sr_c_key)) {
        $get_where .= $src->where_it($sr_c_key, 'c_key', 'c_key');
    }
    if (!empty($sr_c_value)) {
        $get_where .= $src->where_it($sr_c_value, 'c_value', 'c_value');
    }
    $where .= $get_where;
}
#####--
$orderby = (int) getgpcvar("orderby", "G");
if (in_array($orderby, array(1, 2)) == false) {
    $orderby = 1;
}
switch ($orderby) {

コード例 #3

ファイル: site_media.php プロジェクト: centaurustech/collaborate-usa

    }
    </script>
    <form action="" method="post" name="f1" onsubmit="return validate_f1();">
    <input type="hidden" name="command" value="del" />


    <table border="0" cellpadding="0" cellspacing="0" class="datagrid" width="100%">

    <?php 
$recrd = false;
#### Build SQL
$where = "";
##### Search String
if ($search_it) {
    include_once "../../includes/srch_lib.php";
    $src = new srch_h();
    $get_where = '';
    if (!empty($sr_placement_tag)) {
        $get_where .= $src->where_it($sr_placement_tag, 'placement_tag', 'placement_tag');
    }
    if (!empty($sr_alt_text)) {
        $get_where .= $src->where_it($sr_alt_text, 'alt_text', 'alt_text');
    }
    if (!empty($sr_m_cat)) {
        $get_where .= $src->where_it($sr_m_cat, 'm_cat', 'm_cat');
    }
    $where .= $get_where;
}
#####--
$orderby = (int) getgpcvar("orderby", "G");
if (in_array($orderby, array(1, 2, 3, 4)) == false) {

コード例 #4

ファイル: admin_users.php プロジェクト: centaurustech/collaborate-usa

    }
    </script>
    <form action="" method="post" name="f1" onsubmit="return validate_f1();">
    <input type="hidden" name="command" value="del" />


    <table border="0" cellpadding="0" cellspacing="0" class="datagrid dg_middle" width="100%">

    <?php 
$recrd = false;
#### Build SQL
$where = "";
##### Search String
if ($search_it) {
    include_once "../../includes/srch_lib.php";
    $src = new srch_h();
    $get_where = '';
    if (!empty($sr_email_add)) {
        $get_where .= $src->where_it($sr_email_add, 'email_add', 'email_add');
    }
    if (!empty($sr_first_name)) {
        $get_where .= $src->where_it($sr_first_name, 'first_name', 'first_name');
    }
    if (!empty($sr_last_name)) {
        $get_where .= $src->where_it($sr_last_name, 'last_name', 'last_name');
    }
    $where .= $get_where;
}
#####--
$orderby = (int) getgpcvar("orderby", "G");
if (in_array($orderby, array(1, 2, 3, 4)) == false) {

コード例 #5

ファイル: voice_cats.php プロジェクト: centaurustech/collaborate-usa

    </script>
    <form action="" method="post" name="f1" onsubmit="return validate_f1();">
    <input type="hidden" name="command" value="del" />


    <table border="0" cellpadding="0" cellspacing="0" class="datagrid" width="100%">

    <?php 
$recrd = false;
#### Build SQL
$where = "";
$having = '';
##### Search String
if ($search_it) {
    include_once "../../includes/srch_lib.php";
    $src = new srch_h();
    $get_where = '';
    $get_having = '';
    if (!empty($sr_category)) {
        $get_where .= $src->where_it($sr_category, 'category', 'category');
    }
    $cdir = 'equals';
    if ($sr_uc_dir == 'lte') {
        $cdir = 'less-than-equals';
    }
    if ($sr_uc_dir == 'gte') {
        $cdir = 'greater-than-equals';
    }
    if ($sr_usage_count != '') {
        $get_having .= $src->where_it($sr_usage_count, 'usage_count', 'usage_count', $cdir);
    }

コード例 #6

ファイル: p_points_config.php プロジェクト: centaurustech/collaborate-usa

    }
    </script>
    <form action="" method="post" name="f1" onsubmit="return validate_f1();">
    <input type="hidden" name="xcommand" value="del" />


    <table border="0" cellpadding="0" cellspacing="0" class="datagrid" width="100%">

    <?php 
$recrd = false;
#### Build SQL
$where = "";
##### Search String
if ($search_it) {
    include_once "../../includes/srch_lib.php";
    $src = new srch_h();
    $get_where = '';
    if (!empty($sr_action_title)) {
        $get_where .= $src->where_it($sr_action_title, 'action_title', 'action_title');
    }
    if (!empty($sr_category)) {
        $get_where .= $src->where_it($sr_category, 'category', 'category');
    }
    if (!empty($sr_action_key)) {
        $get_where .= $src->where_it($sr_action_key, 'action_key', 'action_key');
    }
    $cdir = 'equals';
    if ($sr_cost_dir == 'lte') {
        $cdir = 'less-than-equals';
    }
    if ($sr_cost_dir == 'gte') {

コード例 #7

ファイル: user_payments.php プロジェクト: centaurustech/collaborate-usa

    }
    </script>
    <form action="" method="post" name="f1" onsubmit="return validate_f1();">
    <input type="hidden" name="command" value="del" />


    <table border="0" cellpadding="0" cellspacing="0" class="datagrid" width="100%">

    <?php 
$recrd = false;
#### Build SQL
$where = "";
##### Search String
if ($search_it) {
    include_once "../../includes/srch_lib.php";
    $src = new srch_h();
    $get_where = '';
    if (!empty($sr_invoice)) {
        $get_where .= $src->where_it($sr_invoice, 'invoice', 'invoice');
    }
    if (!empty($sr_email_add)) {
        $get_where .= $src->where_it($sr_email_add, 'email_add', 'email_add');
    }
    $cdir = 'equals';
    if ($sr_amount_dir == 'lte') {
        $cdir = 'less-than-equals';
    }
    if ($sr_amount_dir == 'gte') {
        $cdir = 'greater-than-equals';
    }
    if ($sr_amount != '') {

コード例 #8

ファイル: voices_dump.php プロジェクト: centaurustech/collaborate-usa

    </script>
    <form action="" method="post" name="f1" onsubmit="return validate_f1();">
    <input type="hidden" name="command" value="del" />


    <table border="0" cellpadding="0" cellspacing="0" class="datagrid" width="100%">

    <?php 
$recrd = false;
#### Build SQL
$where = "";
$having = '';
##### Search String
if ($search_it) {
    include_once "../../includes/srch_lib.php";
    $src = new srch_h();
    $get_where = '';
    $get_having = '';
    if (!empty($sr_email_add)) {
        $get_where .= $src->where_it($sr_email_add, 'email_add', 'email_add');
    }
    if ($sr_voice_cat_id != '') {
        $get_where .= $src->where_it($sr_voice_cat_id, 'voice_cat_id', 'voice_cat_id', 'equals');
    }
    if (!empty($sr_question_text)) {
        $get_where .= $src->where_it($sr_question_text, 'question_text', 'question_text');
    }
    $cdir = 'equals';
    if ($sr_vc_dir == 'lte') {
        $cdir = 'less-than-equals';
    }

コード例 #9

ファイル: users.php プロジェクト: centaurustech/collaborate-usa

    }
    </script>
    <form action="" method="post" name="f1" onsubmit="return validate_f1();">
    <input type="hidden" name="command" value="del" />


    <table border="0" cellpadding="0" cellspacing="0" class="datagrid" width="100%">

    <?php 
$recrd = false;
#### Build SQL
$where = "";
##### Search String
if ($search_it) {
    include_once "../../includes/srch_lib.php";
    $src = new srch_h();
    $get_where = '';
    if (!empty($sr_email_add)) {
        $get_where .= $src->where_it($sr_email_add, 'email_add', 'email_add');
    }
    if (!empty($sr_first_name)) {
        $get_where .= $src->where_it($sr_first_name, 'first_name', 'first_name');
    }
    if (!empty($sr_last_name)) {
        $get_where .= $src->where_it($sr_last_name, 'last_name', 'last_name');
    }
    if ($sr_package_id != '') {
        $get_where .= $src->where_it($sr_package_id, 'package_id', 'package_id', 'equals');
    }
    if ($sr_account_activated != '') {
        $get_where .= $src->where_it($sr_account_activated, 'account_activated', 'account_activated', 'equals');

コード例 #10

ファイル: site_misc_data.php プロジェクト: centaurustech/collaborate-usa

    }
    </script>
    <form action="" method="post" name="f1" onsubmit="return validate_f1();">
    <input type="hidden" name="command" value="del" />


    <table border="0" cellpadding="0" cellspacing="0" class="datagrid" width="100%">

    <?php 
$recrd = false;
#### Build SQL
$where = "";
##### Search String
if ($search_it) {
    include_once "../../includes/srch_lib.php";
    $src = new srch_h();
    $get_where = '';
    if (!empty($sr_title)) {
        $get_where .= $src->where_it($sr_title, 'title', 'title');
    }
    if (!empty($sr_m_value)) {
        $get_where .= $src->where_it($sr_m_value, 'm_value', 'm_value');
    }
    if (!empty($sr_m_cat)) {
        $get_where .= $src->where_it($sr_m_cat, 'm_cat', 'm_cat');
    }
    $where .= $get_where;
}
#####--
$orderby = (int) getgpcvar("orderby", "G");
if (in_array($orderby, array(1, 2, 3)) == false) {

コード例 #11

ファイル: voice_tags_ajax.php プロジェクト: centaurustech/collaborate-usa

}
/////////////////////////////////////////////////////////////////////////
$search_it = (int) @getgpcvar("search_it", "G");
$sr_tag = @getgpcvar("term", "G");
if (empty($sr_tag) || $search_it <= 0) {
    exit;
}
/////////////////////////////////////////////////////////////////////////
//////////////////////////////////////////////////////////////////////////////////////////
$recrd = false;
#### Build SQL
$where = "";
##### Search String
if ($search_it) {
    include_once "../../includes/srch_lib.php";
    $src = new srch_h();
    $get_where = '';
    if (!empty($sr_tag)) {
        $get_where .= $src->where_it($sr_tag, 'tag', 'tag');
    }
    $where .= $get_where;
}
#####--
$query = sprintf("SELECT vt.id, vt.tag\nFROM voice_tags vt\nWHERE 1 = 1 %s\nORDER BY tag ASC, added_on DESC\n", $where);
//echo '<pre>'.$query; die();
#### ---
$recrds = format_str(@mysql_exec($query));
///////////////////////////////
if (empty($recrds)) {
    exit;
} else {

コード例 #12

ファイル: packages.php プロジェクト: centaurustech/collaborate-usa

    }
    </script>
    <form action="" method="post" name="f1" onsubmit="return validate_f1();">
    <input type="hidden" name="command" value="del" />


    <table border="0" cellpadding="0" cellspacing="0" class="datagrid" width="100%">

    <?php 
$recrd = false;
#### Build SQL
$where = "";
##### Search String
if ($search_it) {
    include_once "../../includes/srch_lib.php";
    $src = new srch_h();
    $get_where = '';
    if (!empty($sr_title)) {
        $get_where .= $src->where_it($sr_title, 'lp.title', 'title');
    }
    $cdir = 'equals';
    if ($sr_cost_dir == 'lte') {
        $cdir = 'less-than-equals';
    }
    if ($sr_cost_dir == 'gte') {
        $cdir = 'greater-than-equals';
    }
    if ($sr_cost != '') {
        $get_where .= $src->where_it($sr_cost, 'cost', 'cost', $cdir);
    }
    if ($sr_is_basic != '') {

コード例 #13

ファイル: pages_categories.php プロジェクト: centaurustech/collaborate-usa

    }
    </script>
    <form action="" method="post" name="f1" onsubmit="return validate_f1();">
    <input type="hidden" name="command" value="del" />


    <table border="0" cellpadding="0" cellspacing="0" class="datagrid dg_middle" width="100%">

    <?php 
$recrd = false;
#### Build SQL
$where = "";
##### Search String
if ($search_it) {
    include_once "../../includes/srch_lib.php";
    $src = new srch_h();
    $get_where = '';
    if (!empty($sr_title)) {
        $get_where .= $src->where_it($sr_title, 'title', 'title');
    }
    if ($sr_is_active != '') {
        $get_where .= $src->where_it($sr_is_active, 'is_active', 'is_active', 'equals');
    }
    $where .= $get_where;
}
#####--
$orderby = (int) getgpcvar("orderby", "G");
if (in_array($orderby, array(1, 2)) == false) {
    $orderby = 1;
}
switch ($orderby) {

コード例 #14

ファイル: voice_tags.php プロジェクト: centaurustech/collaborate-usa

    </script>
    <form action="" method="post" name="f1" onsubmit="return validate_f1();">
    <input type="hidden" name="command" value="del" />


    <table border="0" cellpadding="0" cellspacing="0" class="datagrid" width="100%">

    <?php 
$recrd = false;
#### Build SQL
$where = "";
$having = '';
##### Search String
if ($search_it) {
    include_once "../../includes/srch_lib.php";
    $src = new srch_h();
    $get_where = '';
    $get_having = '';
    if (!empty($sr_tag)) {
        $get_where .= $src->where_it($sr_tag, 'tag', 'tag');
    }
    $cdir = 'equals';
    if ($sr_uc_dir == 'lte') {
        $cdir = 'less-than-equals';
    }
    if ($sr_uc_dir == 'gte') {
        $cdir = 'greater-than-equals';
    }
    if ($sr_usage_count != '') {
        $get_having .= $src->where_it($sr_usage_count, 'usage_count', 'usage_count', $cdir);
    }