Example #1
0
function GetResult($select, $from, $where = '', $order_by = NULL)
{
    $results = GetResults($select, $from, $where, $order_by);
    if (!$results) {
        return $results;
    }
    return GetArr($results);
}
Example #2
0
    //         }else{
    //             $quotation_transfers = 1;
    //         }
    $update_data = array();
    $update_data = array_copy('id,country_residence,destination,source,handled_by,agent_name,client_name,email,in_date,tr_date,arrival_date,arrival_option,number_of_night,adults,child,infant,currency,budget_from,budget_to,remarks,hotel_start_preference,status' . $dated, $_POST);
    InsertUpdateRecord($update_data, DB_TABLE_PREFIX . 'inquiry', 'id');
    $message = "Inquiry has beed updated";
    enqueueMsg($message, "success", "inquiry.php");
}
if (isset($_GET['id'])) {
    $id = $_GET["id"];
    $where = array('id' => $id);
    $result_arr = getRows(DB_TABLE_PREFIX . 'inquiry', $where);
    if ($result_arr['total_recs'] > 0) {
        $result = $result_arr['result'];
        $row_data = GetArr($result);
        extract($row_data);
        $var_clear = false;
    } else {
        enqueueMsg('Invalid record id.', "alert");
    }
}
if ($var_clear) {
    $id = 0;
    $full_name = "";
    $email = "";
    $mobile = "";
    $hotel_name = "";
    $hotel_address = "";
    $total_adult = "";
    $total_child = "";
Example #3
0
function greaterthanRows($from, $where = '', $select = '*', $sort_order = '', $join = '', $group_by = '', $do_paging = "N", $record_per_page = '20', $rewrite_url = false)
{
    $order_by = "";
    $sqlWhere = "";
    $joinSql = "";
    if (is_array($select)) {
        $select = implode(",", $select);
    }
    $sqlWhere2 = array();
    if (is_array($where) && count($where) > 0) {
        foreach ($where as $col => $val) {
            $sqlWhere2[] = $col . " >= '" . Encode($val) . "'";
        }
    } else {
        if (!empty($where)) {
            $sqlWhere = $where;
        }
    }
    if ($sort_order != "") {
        $order_by = "ORDER BY {$sort_order}";
    }
    if ($group_by != "") {
        $group_by = "GROUP BY {$group_by}";
    }
    if (count($sqlWhere2)) {
        $sqlWhere = " WHERE " . implode(' AND ', $sqlWhere2);
    }
    if (is_array($join) && !empty($join)) {
        foreach ($join as $tbl => $con) {
            $tmp = explode("|", $tbl);
            if (isset($tmp[1])) {
                $joinSql .= ' ' . strtoupper($tmp[0]) . ' JOIN ' . $tmp[1] . ' ON ' . $con;
            } else {
                $joinSql .= ' JOIN ' . $tbl . ' ON ' . $con;
            }
        }
    } else {
        if (!empty($join)) {
            $joinSql = $join;
        }
    }
    $sql = "SELECT " . $select . " FROM `" . $from . '` ' . $joinSql . " {$sqlWhere} {$group_by} {$order_by}";
    //echo $sql; //exit;
    if ($do_paging == "Y") {
        return customPaging($sql, $record_per_page, $rewrite_url);
    } else {
        $r = Query($sql);
        $num_rows = Num($r);
        $data = array();
        if ($num_rows > 0) {
            while ($o = GetArr($r)) {
                array_push($data, $o);
            }
        }
        mysql_data_seek($r, 0);
        return array('data' => $data, 'result' => $r, 'total_recs' => $num_rows);
    }
}
Example #4
0
include_once 'inc/class.phpmailer.php';
if ($_SESSION['Auth_user']) {
    if (!empty($_POST)) {
        $pid = $_POST["pid"];
        $chk = 'select * from wishlist where id =' . $pid . ' and user_id = ' . $_SESSION['Auth_id'];
        $chk_ret = Query($chk);
        $obj_chk = Num($chk_ret);
        if ($obj_chk > 0) {
            echo "This product already exist in your wishlist";
            exit;
        } else {
            $return = 'select * from product where id =' . $pid;
            $ret = Query($return);
            if ($ret) {
                $i = 1;
                $obj = GetArr($ret);
                $len = count($obj);
                $insert1 = "insert into wishlist( ";
                $insert2 = " VALUES ( ";
                foreach ($obj as $key => $field) {
                    if ($i == $len) {
                        $insert1 .= $key . ",user_id)";
                    } else {
                        $insert1 .= $key . ',';
                    }
                    if ($i == $len) {
                        $field1 = mysql_real_escape_string($field);
                        $insert3 .= "'" . $field1 . "','" . $_SESSION['Auth_id'] . "')";
                    } else {
                        $field1 = mysql_real_escape_string($field);
                        $insert3 .= "'" . $field1 . "',";
Example #5
0
<?php

include_once 'inc/config.inc.php';
require_once 'inc/admin_secure.inc.php';
$msg = deQueueMsg();
include 'header_dashboard.php';
$sql = "select * from users where email = '" . $_SESSION['Auth_user'] . "'";
$sql_user = Query($sql);
$obj = GetArr($sql_user);
?>
<div>
    <ul class="breadcrumb">
        <li><a href="dashboard.php">Home</a> <span class="divider">/</span></li>
        
    </ul>
</div>

<div class="row-fluid sortable">
    <div class="box span12">
        <div class="box-header well" data-original-title>
            <h2><i class="icon-edit"></i> Edit Profile</h2>
            <div class="box-icon">
                <!--<a href="#" class="btn btn-setting btn-round"><i class="icon-cog"></i></a>-->
                <a href="#" class="btn btn-minimize btn-round"><i class="icon-chevron-up"></i></a>
                <a href="#" class="btn btn-close btn-round"><i class="icon-remove"></i></a>
            </div>
        </div>
        <div class="box-content">
            <form class="form-horizontal">
                <input name="id" value="" type="hidden" />
                <fieldset>
Example #6
0
<?php

include_once '../inc/config.inc.php';
require_once '../inc/admin_secure.inc.php';
$msg = deQueueMsg();
$res = Query("SELECT * FROM admin_user WHERE id = '" . Encode($_SESSION['S_ID']) . "'");
if (Num($res) > 0) {
    $user_arr = GetArr($res);
    extract($user_arr);
} else {
    enqueueMsg("Invalid User");
}
if (!empty($_POST)) {
    extract($_POST);
    if (!isset($new_password) && !isset($password_confirm)) {
        if (empty($email)) {
            enqueueMsg("Enter your email address");
        } else {
            if (empty($name)) {
                enqueueMsg("Enter your name");
            } else {
                Query("UPDATE admin_user SET full_name = '" . Encode($name) . "', email = '" . Encode($email) . "' WHERE id = '" . Encode($_SESSION['S_ID']) . "'");
                enqueueMsg("Profile has been updated successfully!", "success");
            }
        }
    } else {
        if (isset($new_password) && isset($password_confirm)) {
            $r = Query("SELECT * FROM admin_user WHERE id = '" . Encode($_SESSION['S_ID']) . "' AND password = '******'");
            if (Num($r) > 0) {
                if ($new_password != $password_confirm) {
                    enqueueMsg("Password and confirm password does not match!");