• 设为首页
  • 点击收藏
  • 手机版
    手机扫一扫访问
    迪恩网络手机版
  • 关注官方公众号
    微信扫一扫关注
    公众号
登陆 注册

PHP get_error_msg函数代码示例

原作者: [db:作者] 来自: [db:来源] 收藏 邀请

本文整理汇总了PHP中get_error_msg函数的典型用法代码示例。如果您正苦于以下问题：PHP get_error_msg函数的具体用法？PHP get_error_msg怎么用？PHP get_error_msg使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。



在下文中一共展示了get_error_msg函数的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的PHP代码示例。

示例1: error_reporting

error_reporting(0);
include "../LMC_LIB/CONNECTION.php";
include "../LMC_LIB/GET_USERSTAMP.php";
include "../LMC_LIB/COMMON.php";
$dir = dirname(dirname(__FILE__)) . DIRECTORY_SEPARATOR;
date_default_timezone_set('Asia/Singapore');
$parentdocfolder = get_reportdocfolder_id();
if ($_REQUEST['option'] == 'COMMON_DATA') {
    // category
    $categories = mysqli_query($con, "SELECT RDC_ID,RDC_CATEGORY FROM LMC_REPORT_DOCUMENT_CATEGORY ORDER BY RDC_CATEGORY ASC");
    while ($row = mysqli_fetch_array($categories)) {
        $category[] = $row["RDC_CATEGORY"];
    }
    //ERRPOR MESSAGE
    $errormsg = get_error_msg('133,141,142,146');
    $values = array($category, $errormsg);
    echo JSON_encode($values);
} elseif ($_REQUEST['option'] == 'tempfilname') {
    $uploadcount = $_REQUEST['ENT_upload_count'];
    $date = $_REQUEST['doc_date'];
    $category = $_REQUEST['doc_lb_category'];
    $uploaddate = date('Y-m-d', strtotime($date));
    $repdate = str_replace('-', '', $date);
    $upload_file_array = array();
    $uploadpath = $dir . $parentdocfolder . DIRECTORY_SEPARATOR;
    //    echo $uploadpath;exit;
    for ($x = 1; $x <= $uploadcount; $x++) {
        if ($_FILES['ENT_upload_filename' . $x]['name'] != '') {
            $attach_file_name = $repdate . '_' . date('His') . '_' . $_FILES['ENT_upload_filename' . $x]['name'];
            if (move_uploaded_file($_FILES['ENT_upload_filename' . $x]['tmp_name'], $uploadpath . $attach_file_name)) {
开发者ID:Rajagunasekaran，项目名称:lmc，代码行数:30，代码来源:DB_DOCUMENTATION_ENTRY.php


示例2: mysqli_query

                $status = mysqli_query($con, "SELECT PC_DATA from PROJECT_CONFIGURATION WHERE CGN_ID=7 ");
                $pro_status = array();
                while ($row = mysqli_fetch_array($status)) {
                    $pro_status[] = $row["PC_DATA"];
                }
                echo json_encode($pro_status);
            } else {
                if ($_REQUEST['option'] == 'AUTO') {
                    global $con;
                    $create_view = mysqli_query($con, "CREATE OR REPLACE VIEW VW_PROJECT AS SELECT PD_ID,MAX(PS_REC_VER)AS RECVER FROM PROJECT_STATUS GROUP BY PD_ID");
                    $auto = mysqli_query($con, " SELECT P.PD_PROJECT_NAME FROM PROJECT_DETAILS P,PROJECT_STATUS PS,VW_PROJECT V WHERE P.PD_ID=PS.PD_ID AND V.PD_ID=PS.PD_ID AND V.RECVER=PS.PS_REC_VER AND PS.PC_ID=3");
                    $pro_auto = array();
                    while ($row = mysqli_fetch_array($auto)) {
                        $pro_auto[] = $row["PD_PROJECT_NAME"];
                    }
                    $erro_msg = get_error_msg('62,63,79,80,81,83,99');
                    $project_result = mysqli_query($con, "select PC_ID,PC_DATA from PROJECT_CONFIGURATION");
                    $get_project_status_array = array();
                    while ($row = mysqli_fetch_array($project_result)) {
                        $get_project_status_array[] = array($row["PC_ID"], $row["PC_DATA"]);
                    }
                    $comp_startdate = get_company_start_date();
                    $values = array($pro_auto, $erro_msg, $comp_startdate, $get_project_status_array);
                    $drop_view = mysqli_query($con, 'drop view if exists VW_PROJECT');
                    echo json_encode($values);
                }
            }
        }
    }
}
if (isset($_REQUEST['option']) && $_REQUEST['option'] != '') {
开发者ID:Rajagunasekaran，项目名称:TS，代码行数:31，代码来源:DB_PROJECT_PROJECT_ENTRY_SEARCH_UPDATE.php


示例3: JSON_ENCODE

 if($_REQUEST['option']=="CONFIG_SRCH_UPD_load_mod")
 {
     // GET ERR MSG
     $CONFIG_SRCH_UPD_errmsg=get_error_msg('17,60,113,125,126,127,128,129,131,132');
     echo JSON_ENCODE($CONFIG_SRCH_UPD_errmsg);
 }
 if($_REQUEST['option']=="CONFIG_SRCH_UPD_load_type")
 {
     $CONFIG_SRCH_UPD_mod=$_REQUEST['module'];
     //CONFIG TYPE LIST
     $CONFIG_SRCH_UPD_type = mysqli_query($con,"SELECT * FROM LMC_CONFIGURATION WHERE CGN_ID IN (9,10,11,12,13,14,16,17,18,19,20) ORDER BY CGN_TYPE ASC");
     $CONFIG_SRCH_UPD_arr_type=array();
     while($row=mysqli_fetch_array($CONFIG_SRCH_UPD_type)){
         $CONFIG_SRCH_UPD_arr_type[]=array($row[0],$row[2]);
     }
     $CONFIG_SRCH_UPD_errmsg=get_error_msg('17,60,113,125,126,127,128,129,131,132');
     $values=array($CONFIG_SRCH_UPD_arr_type,$CONFIG_SRCH_UPD_errmsg);
     echo JSON_ENCODE($values);
 }
 //LOAD DATA FOR FLEX TABLE
 if($_REQUEST['option']=="CONFIG_SRCH_UPD_load_data")
 {
     $CONFIG_SRCH_UPD_type=$_REQUEST['CONFIG_SRCH_UPD_lb_type'];
     if($CONFIG_SRCH_UPD_type==13)
     {
         $CONFIG_SRCH_UPD_sql_data = mysqli_query($con,"SELECT LTC.TC_ID,LTC.TEAM_NAME,ULD.ULD_USERNAME,DATE_FORMAT((LTC.TC_TIMESTAMP),'%d-%m-%Y %T') AS TC_TIMESTAMP  FROM LMC_TEAM_CREATION LTC ,LMC_USER_LOGIN_DETAILS ULD WHERE LTC.ULD_ID=ULD.ULD_ID ORDER BY LTC.TEAM_NAME");
     }
     else if($CONFIG_SRCH_UPD_type==14)
     {
         $CONFIG_SRCH_UPD_sql_data = mysqli_query($con,"SELECT LMT.MT_ID,LMT.MT_TOPIC,ULD.ULD_USERNAME,DATE_FORMAT((LMT.MT_TIMESTAMP),'%d-%m-%Y %T') AS MT_TIMESTAMP FROM LMC_MEETING_TOPIC LMT,LMC_USER_LOGIN_DETAILS ULD WHERE LMT.ULD_ID=ULD.ULD_ID ORDER BY LMT.MT_TOPIC");
     }
开发者ID:Rajagunasekaran，项目名称:lmc，代码行数:31，代码来源:DB_CONFIGURATION_SEARCH_UPDATE_DELETE.php


示例4: error_reporting

//VER 0.03-SD:03/01/2015 ED:06/01/2015, TRACKER NO:74,DESC: SETTING PRELOADER POSITON AND MSGBOX POSITION
//DONE BY:LALITHA
//VER 0.02-SD:14/11/2014 ED:14/11/2014,TRACKER NO:74,Fixed width
//VER 0.01-INITIAL VERSION, SD:27/10/2014 ED:28/10/2014,TRACKER NO:99
//*********************************************************************************************************//
error_reporting(0);
if(isset($_REQUEST)){
    include "CONNECTION.php";
    include "COMMON.php";
    include "GET_USERSTAMP.php";
    $USERSTAMP=$UserStamp;
    global $con;
    //FUNCTION TO FETCHING EMAIL TEMPLATE SCRIPT NAME,ERROR MESSAGE FROM SQL TABLE
    if($_REQUEST['option']=="INITIAL_DATAS"){
        // GET ERR MSG
        $ET_SRC_UPD_DEL_errmsg=get_error_msg('56,87,88,89');
        $ET_SRC_UPD_DEL_emltemp = mysqli_query($con,"SELECT ET_ID,ET_EMAIL_SCRIPT FROM EMAIL_TEMPLATE ORDER BY ET_EMAIL_SCRIPT");
        $ET_SRC_UPD_DEL_script_object=array();
        while($row=mysqli_fetch_array($ET_SRC_UPD_DEL_emltemp)){
            $ET_SRC_UPD_DEL_script_object[]=array($row["ET_EMAIL_SCRIPT"],$row["ET_ID"]);
        }
        $ET_SRC_UPD_DEL_final_values=array($ET_SRC_UPD_DEL_script_object,$ET_SRC_UPD_DEL_errmsg);
        echo JSON_ENCODE($ET_SRC_UPD_DEL_final_values);
    }
    //FUNCTION FOR SHOW THE DATA IN TABLE
    if($_REQUEST['option']=="EMAIL_TEMPLATE_DETAILS"){
        $ET_SRC_UPD_DEL_scriptname=$_POST['ET_SRC_UPD_DEL_lb_scriptname'];
        $ET_SRC_UPD_DEL_flextbl= mysqli_query($con,"SELECT DATE_FORMAT(CONVERT_TZ(ETD.ETD_TIMESTAMP,'+00:00','+08:00'),'%d-%m-%Y %T') AS TIMESTAMP,ETD.ETD_EMAIL_SUBJECT,ETD.ETD_EMAIL_BODY,ULD.ULD_LOGINID,ETD.ETD_ID FROM EMAIL_TEMPLATE_DETAILS ETD,USER_LOGIN_DETAILS ULD WHERE ETD.ULD_ID=ULD.ULD_ID AND ETD.ET_ID='$ET_SRC_UPD_DEL_scriptname'");
        $ET_SRC_UPD_DEL_values=array();
        while($row=mysqli_fetch_array($ET_SRC_UPD_DEL_flextbl)){
            $ET_SRC_UPD_DEL_subject=$row["ETD_EMAIL_SUBJECT"];
开发者ID:Rajagunasekaran，项目名称:BACKUP，代码行数:31，代码来源:DB_EMAIL_EMAIL_TEMPLATE_SEARCH_UPDATE.php


示例5: JSON_ENCODE

//        while($row=mysqli_fetch_array($CONFIG_ENTRY_mod)){
//            $CONFIG_ENTRY_arr_mod[]=array($row[0],$row[1]);
//        }
//        $CONFIG_ENTRY_errmsg_modlist=array($CONFIG_ENTRY_errmsg,$CONFIG_ENTRY_arr_mod);
        echo JSON_ENCODE($CONFIG_ENTRY_errmsg);
    }
    if($_REQUEST['option']=="CONFIG_ENTRY_load_type")
    {
//        $CONFIG_ENTRY_mod=$_REQUEST['module'];
        //CONFIG TYPE LIST
        $CONFIG_ENTRY_type = mysqli_query($con,"SELECT * FROM LMC_CONFIGURATION WHERE CNP_ID='2' AND (CGN_NON_IP_FLAG is null) ORDER BY CGN_TYPE ASC");
        $CONFIG_ENTRY_arr_type=array();
        while($row=mysqli_fetch_array($CONFIG_ENTRY_type)){
            $CONFIG_ENTRY_arr_type[]=array($row[0],$row[2]);
        }
        $CONFIG_ENTRY_errmsg=get_error_msg('71,127,130,131');
        $values=array($CONFIG_ENTRY_arr_type,$CONFIG_ENTRY_errmsg);
        echo JSON_ENCODE($values);
    }
    //SAVE CODING
    if($_REQUEST['option']=="CONFIG_ENTRY_save")
    {
        $flag=$_REQUEST['CONFIG_ENTRY_lb_module'];
        $CONFIG_ENTRY_data=$_REQUEST['CONFIG_ENTRY_tb_data'];
        $CONFIG_ENTRY_data=$con->real_escape_string($CONFIG_ENTRY_data);
        $CONFIG_ENTRY_type=$_REQUEST['CONFIG_ENTRY_lb_type'];
        $CONFIG_ENTRY_arr_config=array(3=>array("LMC_USER_RIGHTS_CONFIGURATION","URC_DATA"));
        $sql1= "SELECT ".$CONFIG_ENTRY_arr_config[$flag][1]." FROM ".$CONFIG_ENTRY_arr_config[$flag][0]." CCN WHERE CCN.CGN_ID=(SELECT C.CGN_ID FROM LMC_CONFIGURATION C WHERE C.CGN_ID='$CONFIG_ENTRY_type') AND ".$CONFIG_ENTRY_arr_config[$flag][1]."='$CONFIG_ENTRY_data'";
        $CONFIG_ENTRY_type1 = mysqli_query($con,$sql1);
        $CONFIG_ENTRY_save=0;
        if($row=mysqli_fetch_array($CONFIG_ENTRY_type1)){
开发者ID:Rajagunasekaran，项目名称:lmc，代码行数:31，代码来源:DB_CONFIGURATION_ENTRY.php


示例6: IN

if(isset($_REQUEST)){
    include "CONNECTION.php";
    include "COMMON.php";
    include "GET_USERSTAMP.php";
    $USERSTAMP=$UserStamp;
    global $con;
//FETCHING DATAS LOADED FRM DB FOR LOGIN ID ND ERR MSGS
    if($_REQUEST['option']=="common")
    {
        $active_login_id=mysqli_query($con,"SELECT ULD_LOGINID from VW_ACCESS_RIGHTS_TERMINATE_LOGINID where URC_DATA!='SUPER ADMIN' AND ULD_LOGINID IN (SELECT ULD_LOGINID FROM USER_LOGIN_DETAILS WHERE ULD_ID NOT IN (SELECT ULD_ID FROM EMPLOYEE_PROJECT_DETAILS)) ORDER BY ULD_LOGINID");
        $REV_active_emp=array();
        while($row=mysqli_fetch_array($active_login_id)){
            $REV_active_emp[]=$row["ULD_LOGINID"];
        }
        $get_project_array=get_emp_projectentry();
        $EMP_ENTRY_errmsg=get_error_msg('71,83,117');
        $final_values=array($REV_active_emp,$get_project_array,$EMP_ENTRY_errmsg);
        echo JSON_ENCODE($final_values);
    }
    //FUNCTION FOR TO SAVE THE EMPLOYEE PROJECT DETAILS
    if($_REQUEST['option']=="PROJECT_PROPETIES_SAVE"){
        $EMP_ENTRY_loginid=$_POST['EMP_ENTRY_lb_loginid'];
        $uld_id=mysqli_query($con,"select ULD_ID from USER_LOGIN_DETAILS where ULD_LOGINID='$EMP_ENTRY_loginid'");
        while($row=mysqli_fetch_array($uld_id)){
            $EMP_ENTRY_uld_id=$row["ULD_ID"];
        }
        $project=$_POST['checkbox'];
        $length=count($project);
        $projectid;
        for($i=0;$i<$length;$i++){
            if($i==0){
开发者ID:Rajagunasekaran，项目名称:BACKUP，代码行数:31，代码来源:DB_EMPLOYEE_PROJECT_ACCESS.php


示例7: error_reporting

<?php
error_reporting(0);
include "../LMC_LIB/CONNECTION.php";
include "../LMC_LIB/GET_USERSTAMP.php";
include "../LMC_LIB/COMMON.php";
if($_REQUEST['option']=='Get_initialdata'){
    // ERRPOR MESSAGE
    $errormsg[]=get_error_msg('83,167,168');
    echo json_encode($errormsg);
}
else if($_REQUEST['option']=='Chart_input'){
    $fromdate=$_REQUEST['fromdate'];
    $todate=$_REQUEST['todate'];
    $flag=$_REQUEST['flag'];
    $chart_twodimens_arr=[];
    $contract_dtl=array();
    if($flag=='chart_flag_month'){
        $sqlquery="CALL SP_LMC_CONTRACT_CHART(1,'$fromdate',NULL,'$UserStamp',@TEMP_TABLE)";
    }
    else if($flag=='chart_flag_range'){
        $sqlquery="CALL SP_LMC_CONTRACT_CHART(2,'$fromdate','$todate','$UserStamp',@TEMP_TABLE)";
    }
    $result = $con->query($sqlquery);
    if (!$result) {
        $flag = 0;
        die("CALL failed: (" . $con->errno . ") " . $con->error);
    }
    $selecttable = $con->query('SELECT @TEMP_TABLE');
    $resulttable = $selecttable->fetch_assoc();
    $tablename = $resulttable['@TEMP_TABLE'];
    if($tablename!='') {
开发者ID:Rajagunasekaran，项目名称:lmc，代码行数:31，代码来源:DB_REPORT_CHARTS.php


示例8: error_reporting

//VER 0.03-SD:29/10/2014 ED:31/10/2014,TRACKER NO:97,Fixed the column nd div width,Changed the data table header is meaningful nd put space also,Updated Sorting fr dte,Hide the section id nd old dt datas while listbx changing fn,Added Preloader in list bx fn ,Column values alignd in centre
//VER 0.02-SD:14/10/2014 ED:21/10/2014,TRACKER NO:97,Did others two parts of projects,Changed data tble for prjct rvn by actv nonactv emp option,Removed hard code of list bx option(tkn data nd id also frm db),Updated data tble,validation,Loaded all err msg frm db,hiding err msg,lbls nd others fields in unwanted places,Changed queries,update dte frmt,Update comments,Set min nd max dte
//DONE BY:SASIKALA
//VER 0.01-INITIAL VERSION, SD:08/10/2014 ED:15/10/2014,TRACKER NO:97
//*********************************************************************************************************//
error_reporting(0);
if (isset($_REQUEST)) {
    include "../../TSLIB/TSLIB_CONNECTION.php";
    include "../../TSLIB/TSLIB_COMMON.php";
    include "../../TSLIB/TSLIB_GET_USERSTAMP.php";
    $USERSTAMP = $UserStamp;
    global $con;
    //FETCHING DATAS LOADED FRM DB FOR LISTBX
    if ($_REQUEST['option'] == "common") {
        // GET ERR MSG
        $REV_errmsg = get_error_msg('15,16,75,82,83,106,107,108,111,112');
        // REPORT CONFIGURATION LIST
        $REV_project_list = mysqli_query($con, "SELECT * FROM REPORT_CONFIGURATION WHERE CGN_ID=2");
        $REV_projectlist = array();
        while ($row = mysqli_fetch_array($REV_project_list)) {
            $REV_projectlist[] = array($row["RC_DATA"], $row["RC_ID"]);
        }
        // PROJECT NAME LIST
        $project_result = mysqli_query($con, "SELECT DISTINCT PD.PD_PROJECT_NAME FROM PROJECT_DETAILS PD JOIN PROJECT_STATUS PS WHERE PD.PD_ID=PS.PD_ID ORDER BY PD_PROJECT_NAME ASC ");
        $REV_project_array = array();
        while ($row = mysqli_fetch_array($project_result)) {
            $REV_project_array[] = $row["PD_PROJECT_NAME"];
        }
        // PROJECT NAME REV VERSION LIST
        $REV_recversion = $_REQUEST['REV_lb_recver'];
        $project_result = mysqli_query($con, "SELECT PS.PS_REC_VER FROM PROJECT_DETAILS PD JOIN PROJECT_STATUS PS WHERE PD.PD_ID=PS.PD_ID and PD.PD_PROJECT_NAME='{$REV_recversion}'");
开发者ID:Rajagunasekaran，项目名称:TS，代码行数:31，代码来源:DB_REPORT_REVENUE.php


示例9: error_reporting

//*******************************************FILE DESCRIPTION*********************************************//
//*******************************************PUBLIC HOLIDAY SEARCH/UPDATE*********************************************//
//DONE BY:LALITHA
//VER 0.01-INITIAL VERSION, SD:17/12/2014 ED:17/12/2014,TRACKER NO:74
//*********************************************************************************************************//
error_reporting(0);
if (isset($_REQUEST)) {
    include "../TSLIB/TSLIB_CONNECTION.php";
    include "../TSLIB/TSLIB_COMMON.php";
    include "../TSLIB/TSLIB_GET_USERSTAMP.php";
    $USERSTAMP = $UserStamp;
    global $con;
    //FETCHING DATAS LOADED FRM DB FOR LISTBX
    if ($_REQUEST['option'] == "common") {
        // GET ERR MSG
        $PH_SRC_UPD_nodate = get_error_msg('4,18,56,83,89');
        // YEAR FOR PUBLIC HOLIDAY
        $PH_SRC_UPD_yr_list = mysqli_query($con, "SELECT DISTINCT DATE_FORMAT(PH_DATE, '%Y')AS YEAR FROM PUBLIC_HOLIDAY;");
        $PH_SRC_UPD_yrlist = array();
        while ($row = mysqli_fetch_array($PH_SRC_UPD_yr_list)) {
            $PH_SRC_UPD_yrlist[] = array($row["YEAR"]);
        }
        $final_values = array($PH_SRC_UPD_yrlist, $PH_SRC_UPD_nodate);
        echo JSON_ENCODE($final_values);
    }
    if ($_REQUEST['option'] == "PUBLIC_HOLIDAY_DETAILS") {
        //FETCHING USER LOGIN DETAILS RECORDS
        $PH_SRC_UPD_year = $_REQUEST["PH_SRC_UPD_lb_yr"];
        $date = mysqli_query($con, "SELECT PH.PH_ID,DATE_FORMAT(PH.PH_DATE,'%d-%m-%Y') AS PH_DATE,PH.PH_DESCRIPTION,ULD.ULD_LOGINID,DATE_FORMAT(CONVERT_TZ(PH.PH_TIMESTAMP,'+00:00','+05:30'), '%d-%m-%Y %T') AS PH_TIMESTAMP FROM PUBLIC_HOLIDAY PH ,USER_LOGIN_DETAILS ULD WHERE PH.ULD_ID=ULD.ULD_ID AND YEAR(PH.PH_DATE)='{$PH_SRC_UPD_year}'");
        $ure_values = array();
        while ($row = mysqli_fetch_array($date)) {
开发者ID:Rajagunasekaran，项目名称:TS，代码行数:31，代码来源:DB_PUBLIC_HOLIDAY_SEARCH_UPDATE.php


示例10: while

    $uldid=$row["ULD_ID"];
}
if($_REQUEST['option']=='INITIAL_DATA')
{
// POSITION
    $position=mysqli_query($con,"SELECT WD_ID,WD_DESIGNATION FROM LMC_WORKER_DESIGNATION ORDER BY WD_DESIGNATION ASC");
    while($row=mysqli_fetch_array($position)){
        $employeepostion[]=array($row['WD_DESIGNATION'],$row['WD_ID']);
    }
//TEAM NAME
    $teamname=mysqli_query($con,"SELECT TC_ID,TEAM_NAME FROM LMC_TEAM_CREATION ORDER BY TEAM_NAME ASC");
    while($row=mysqli_fetch_array($teamname)){
        $empteamname[]=array($row['TEAM_NAME'],$row['TC_ID']);
    }
//ERROR MESSAGE
    $errormsg=get_error_msg('149,150,153,154,155');
//NOT ASSIGN
    $empnotassign=mysqli_query($con,"SELECT DISTINCT ULD_ID,ULD_WORKER_NAME FROM LMC_USER_LOGIN_DETAILS WHERE ULD_ID NOT IN (SELECT ULD_ID FROM LMC_EMPLOYEE_TEAM_DETAILS ) ORDER BY ULD_WORKER_NAME");
    $numrow=mysqli_num_rows($empnotassign);
    if($numrow>0)
    {
    while($row=mysqli_fetch_array($empnotassign)){
        $data[]=array($row['ULD_ID'],$row['ULD_WORKER_NAME']);
    }
    $values=array($data,$empteamname,$employeepostion,$errormsg);
    }
    else
    {
    $values=array($numrow,$empteamname,$employeepostion,$errormsg);
    }
    echo json_encode($values);
开发者ID:Rajagunasekaran，项目名称:lmc，代码行数:31，代码来源:DB_TEAM_ASSIGN.php


示例11: MAX

    $sql = "SELECT PC_BALANCE FROM PETTY_CASH WHERE PC_ID=(SELECT MAX(PC_ID) FROM PETTY_CASH)";
    $result = mysqli_query($con, $sql);
    while ($row = mysqli_fetch_array($result)) {
        $opt = $row["PC_BALANCE"];
    }
    if ($opt == null) {
        $opt = 0;
    }
    $error = '1,2,3,4,17,7';
    $error_array = get_error_msg($error);
    $finalarr = array($opt, $error_array);
    echo json_encode($finalarr);
}
if ($_REQUEST["option"] == "petty_cash_form") {
    $error = '1,2,3,7';
    $error_array[] = get_error_msg($error);
}
//FUNCTION FOR INSERT
if ($_POST['Option'] == 'Insert') {
    $Date = date("Y-m-d", strtotime($_POST['PC_tb_DATE']));
    $amount = $_POST['PC_tb_atm'];
    $inviceitem = $_POST['PC_tb_INVOICE_ITEMS'];
    $Report = $_POST['PC_tb_COMMENTS'];
    $cash = $_POST['PC_cash_radio'];
    if ($_POST['PC_cash_radio'] == "PC_CASH_IN") {
        $cashout = 'null';
        $QUERY = "CALL SP_PETTY_CASH_INSERT('{$Date}','{$amount}',{$cashout},'{$inviceitem}','{$Report}','{$USERSTAMP}',@flag)";
        $result = $con->query($QUERY);
        if (!$result) {
            die("CALL failed: (" . $con->errno . ") " . $con->error);
        }
开发者ID:Rajagunasekaran，项目名称:TS，代码行数:31，代码来源:DB_PETTY_CASH.php


示例12: JSON_ENCODE

     echo JSON_ENCODE($URSRC_role_array);
 }
 $project_result = mysqli_query($con, "SELECT AC_ID,AC_DATA FROM ATTENDANCE_CONFIGURATION WHERE AC_ID=15");
 $get_project_array = array();
 while ($row = mysqli_fetch_array($project_result)) {
     $get_project_array[] = array($row["AC_DATA"], $row["AC_ID"]);
 }
 //    }
 //FETCHING DATAS LOADED FRM DB FOR LOGIN ID ND ERR MSGS
 if ($_REQUEST['option'] == "common") {
     $REV_active_empname = mysqli_query($con, "SELECT * FROM VW_TS_ALL_ACTIVE_EMPLOYEE_DETAILS WHERE URC_DATA!='SUPER ADMIN'  ORDER BY EMPLOYEE_NAME");
     $REV_active_emp = array();
     while ($row = mysqli_fetch_array($REV_active_empname)) {
         $REV_active_emp[] = array($row["EMPLOYEE_NAME"], $row["ULD_ID"]);
     }
     $EMP_ENTRY_errmsg = get_error_msg('71,83,139,140');
     $final_values = array($REV_active_emp, $get_project_array, $EMP_ENTRY_errmsg);
     echo json_encode($final_values);
 }
 //FETCHING SELECT DATA VALUE
 if ($_REQUEST['option'] == "check_flag") {
     $loginid = $_REQUEST['loginid'];
     $check_flag = mysqli_query($con, "SELECT WFHA_FLAG FROM WORK_FROM_HOME_ACCESS WHERE WFHA_FLAG='X' AND ULD_ID={$loginid}");
     $flag = '';
     while ($row = mysqli_fetch_array($check_flag)) {
         $flag = $row['WFHA_FLAG'];
     }
     echo json_encode($flag);
 }
 //FUNCTION TO SAVE AND UPDATE THE EMPLOYEE PROJECT DETAILS
 $EMP_ENTRY_uld_id = $_POST['EMP_ENTRY_lb_loginid'];
开发者ID:Rajagunasekaran，项目名称:TS，代码行数:31，代码来源:DB_ACCESS_RIGHTS_ACCESS_RIGHTS-SEARCH_UPDATE.php


示例13: mysqli_report

<?php

//error_reporting(0);
include "TSLIB/TSLIB_GET_USERSTAMP.php";
include "TSLIB/TSLIB_CONNECTION.php";
include "TSLIB/TSLIB_COMMON.php";
$USERSTAMP = $UserStamp;
if ($_REQUEST['option'] == "MENU") {
    mysqli_report(MYSQLI_REPORT_STRICT);
    $user_ipaddress = $ip = getenv('HTTP_CLIENT_IP') ?: ($user_ipaddress = getenv('HTTP_X_FORWARDED_FOR') ?: ($user_ipaddress = getenv('HTTP_X_FORWARDED') ?: ($user_ipaddress = getenv('HTTP_FORWARDED_FOR') ?: ($user_ipaddress = getenv('HTTP_FORWARDED') ?: ($user_ipaddress = getenv('REMOTE_ADDR'))))));
    $ip_check_flag = 0;
    $flag_wfh = null;
    try {
        $err_msg = get_error_msg('61,119,124');
        $select_loginid_role = mysqli_query($con, "SELECT URC_DATA from VW_ACCESS_RIGHTS_TERMINATE_LOGINID where ULD_LOGINID='{$USERSTAMP}' ");
        $login_id_role;
        while ($row = mysqli_fetch_array($select_loginid_role)) {
            $login_id_role = $row["URC_DATA"];
        }
        $userstamp_id = mysqli_query($con, "select ULD_ID from USER_LOGIN_DETAILS where ULD_LOGINID='{$USERSTAMP}'");
        while ($row = mysqli_fetch_array($userstamp_id)) {
            $ADM_userstamp_id = $row["ULD_ID"];
        }
        $wfh_flag = mysqli_query($con, "select WFHA_FLAG from WORK_FROM_HOME_ACCESS where ULD_ID={$ADM_userstamp_id}");
        $wfh_row = mysqli_num_rows($wfh_flag);
        if ($wfh_row > 0) {
            if ($row = mysqli_fetch_array($wfh_flag)) {
                $flag_wfh = $row['WFHA_FLAG'];
            }
            if ($flag_wfh == 'X') {
                $ip_check_flag = 1;
开发者ID:Rajagunasekaran，项目名称:TS，代码行数:31，代码来源:DB_MENU.php


示例14: inital_data

include "../LMC_LIB/GET_USERSTAMP.php";
include "../LMC_LIB/COMMON.php";
function inital_data()
{
    global $con;
    $itemno = array();
    $itemdtl = mysqli_query($con, "SELECT LID_ID,LID_ITEM_NO,LID_DESCRIPTION FROM LMC_INVENTORY_ITEM_DETAILS ORDER BY LID_ITEM_NO");
    while ($row = mysqli_fetch_array($itemdtl)) {
        $itemno[] = array('id' => $row["LID_ID"], 'no' => $row["LID_ITEM_NO"], 'name' => $row["LID_DESCRIPTION"]);
    }
    return $itemno;
}
if ($_REQUEST['option'] == 'get_item_no') {
    $itemdetail = inital_data();
    // ERRPOR MESSAGE
    $errormsg = get_error_msg('3,7,83');
    $values = array($itemdetail, $errormsg);
    echo json_encode($values);
} elseif ($_REQUEST['option'] == 'get_item_name') {
    $itemnoid = $_REQUEST['item_no'];
    $itemname = array();
    $itemdtl = mysqli_query($con, "SELECT LID_DESCRIPTION FROM LMC_INVENTORY_ITEM_DETAILS WHERE LID_ID='{$itemnoid}'");
    if ($row = mysqli_fetch_array($itemdtl)) {
        $itemname = $row["LID_DESCRIPTION"];
    }
    echo $itemname;
} elseif ($_REQUEST['option'] == 'get_sitestock') {
    $fromdate = $_REQUEST['ISS_db_datesrchfrom'];
    $todate = $_REQUEST['ISS_db_datesrchto'];
    $itemno = $_REQUEST['ISS_lb_itemnosrch'];
    $itemname = $_REQUEST['ISS_lb_itemnamesrch'];
开发者ID:Rajagunasekaran，项目名称:lmc，代码行数:31，代码来源:DB_INVENTORY_SITE_STOCK.php


示例15: mysqli_query

$userstamp_id = mysqli_query($con, "SELECT ULD_ID FROM LMC_USER_LOGIN_DETAILS  WHERE ULD_USERNAME='{$UserStamp}'");
if ($row = mysqli_fetch_array($userstamp_id)) {
    $uldid = $row["ULD_ID"];
}
if ($_REQUEST['option'] == 'INITIAL_DATA') {
    //TEAM NAME
    $teamname = mysqli_query($con, "SELECT TC_ID,TEAM_NAME FROM LMC_TEAM_CREATION ORDER BY TEAM_NAME ASC");
    while ($row = mysqli_fetch_array($teamname)) {
        $empteamname[] = array($row['TEAM_NAME'], $row['TC_ID']);
    }
    //STATUS
    $status = mysqli_query($con, "SELECT LCS_ID,LCS_STATUS FROM LMC_CONTRACT_STATUS ORDER BY LCS_STATUS ASC");
    while ($row = mysqli_fetch_array($status)) {
        $jobstatus[] = array($row['LCS_STATUS'], $row['LCS_ID']);
    }
    $errormsg = get_error_msg('3,4,7,17');
    $values = array($empteamname, $jobstatus, $errormsg);
    echo json_encode($values);
} elseif ($_REQUEST['option'] == 'contractsaveupdate') {
    $CC_contractno = $_REQUEST['CC_contractid'];
    $CC_customername = $_REQUEST['CC_customername'];
    $CC_contactperson = $_REQUEST['CC_contactperson'];
    $CC_location = $_REQUEST['CC_location'];
    $CC_address = $_REQUEST['CC_address'];
    $CC_address = $con->real_escape_string($CC_address);
    $CC_paymentterm = $_REQUEST['CC_paymentterm'];
    $CC_nextnumber = $_REQUEST['CC_nextnumber'];
    $CC_type = $_REQUEST['CC_type'];
    if ($CC_type == 'SELECT') {
        $CC_type = '';
    }
开发者ID:Rajagunasekaran，项目名称:lmc，代码行数:31，代码来源:DB_CONTRACT_CREATION_UPDATE.php


示例16: error_reporting

//VER 0.02 SD:06/12/2014 ED:08/12/2014,TRACKER NO:74,Updated preloader position nd message box position,Changed loginid to emp name
//VER 0.01-INITIAL VERSION, SD:03/11/2014 ED:04/11/2014,TRACKER NO:97
//************************************************************************************************************//
require_once 'google/appengine/api/mail/Message.php';
use google\appengine\api\mail\Message;
error_reporting(0);
if (isset($_REQUEST)) {
    include "../../TSLIB/TSLIB_CONNECTION.php";
    include "../../TSLIB/TSLIB_COMMON.php";
    include "../../TSLIB/TSLIB_GET_USERSTAMP.php";
    $USERSTAMP = $UserStamp;
    global $con;
    // FETCHING ERROR MESSAGE FROM SQL TABLE
    if ($_REQUEST['option'] == "INITIAL_DATAS") {
        // GET ERR MSG
        $CPVD_errmsg = get_error_msg('3,7,15,83');
        $CPVD_act_employee = get_active_emp_id();
        $final_array = array($CPVD_errmsg, $CPVD_act_employee);
        echo JSON_ENCODE($final_array);
    }
    //FETCHING COMPANY PROPERTIES DETAILS
    if ($_REQUEST['option'] == "COMPANY_PROPERTY") {
        $CPVD_loginid = $_REQUEST['CPVD_lb_loginid'];
        $CPVD_cmpny_prop = mysqli_query($con, "SELECT CP.CP_LAPTOP_NUMBER,CP.CP_CHARGER_NUMBER FROM COMPANY_PROPERTIES CP,COMPANY_PROPERTIES_DETAILS CPD,EMPLOYEE_DETAILS EMP WHERE CP.CP_ID=CPD.CP_ID AND EMP.EMP_ID=CPD.EMP_ID AND EMP.ULD_ID='{$CPVD_loginid}'");
        while ($row = mysqli_fetch_array($CPVD_cmpny_prop)) {
            $CPVD_lap_no = $row["CP_LAPTOP_NUMBER"];
            $CPVD_charger_no = $row["CP_CHARGER_NUMBER"];
        }
        $CPVD_cmpny_values = array('CPVD_lap_no' => $CPVD_lap_no, 'CPVD_charger_no' => $CPVD_charger_no);
        $values_array[] = $CPVD_cmpny_values;
        echo JSON_ENCODE($values_array);
开发者ID:Rajagunasekaran，项目名称:TS，代码行数:31，代码来源:DB_EMPLOYEE_COMPANY_PROPERTY_VERIFICATION.php


示例17: error_reporting

//*******************************************CLOCK IN/OUT DETAILS*********************************************//
//DONE BY:LALITHA
//VER 0.02-SD:09/01/2015 ED:10/01/2015,TRACKER NO:74,Updated Sorting function
//VER 0.01-INITIAL VERSION, SD:03/01/2015 ED:05/01/2015,TRACKER NO:74
//*********************************************************************************************************//
error_reporting(0);
if (isset($_REQUEST)) {
    include "../../TSLIB/TSLIB_CONNECTION.php";
    include "../../TSLIB/TSLIB_COMMON.php";
    include "../../TSLIB/TSLIB_GET_USERSTAMP.php";
    $USERSTAMP = $UserStamp;
    global $con;
    //FETCHING DATAS LOADED FRM DB FOR INITIAL LISTBX
    if ($_REQUEST['option'] == "common") {
        // GET ERR MSG
        $REP_chk_errmsg = get_error_msg("15,16,18,83,121,122");
        //GET ACTIVE LOGIN ID
        $REP_chk_active_emp = get_active_emp_id();
        // NONACTIVE EMPLOYEE LIST
        $REP_chk_active_nonemp = get_nonactive_emp_id();
        // REPORT CONFIGURATION LIST
        $REP_report_config = mysqli_query($con, "SELECT * FROM REPORT_CONFIGURATION WHERE CGN_ID=16");
        $REP_rprtconfiglist = array();
        while ($row = mysqli_fetch_array($REP_report_config)) {
            $REP_rprtconfiglist[] = array($row["RC_DATA"], $row["RC_ID"]);
        }
        $REP_CHK_final_values = array($REP_chk_active_emp, $REP_chk_active_nonemp, $REP_rprtconfiglist, $REP_chk_errmsg);
        echo JSON_ENCODE($REP_CHK_final_values);
    }
    //SETTING MIN ND MAX DATE FOR DATE PICKER WITH LOGIN ID OPTION
    if ($_REQUEST["option"] == "datemin_max") {
开发者ID:Rajagunasekaran，项目名称:TS，代码行数:31，代码来源:DB_REPORT_CLOCK_IN_OUT_DETAILS.php


示例18: while

    while ($row = mysqli_fetch_array($URSRC_select_basicrole_result)) {
        $URSRC_basicrole = $row["URC_DATA"];
    }
    $URSRC_basicroleid_array_result = mysqli_query($con, "select * from LMC_USER_RIGHTS_CONFIGURATION URC,LMC_BASIC_ROLE_PROFILE BRP where URC.URC_DATA='" . $URSRC_basicrole . "' and URC.URC_ID=BRP.URC_ID");
    $URSRC_basicroleid_array = array();
    while ($row = mysqli_fetch_array($URSRC_basicroleid_array_result)) {
        $URSRC_basicroleid_array[] = $row["BRP_BR_ID"];
    }
    $get_URSRC_basicrole_profile_array = array();
    for ($i = 0; $i < count($URSRC_basicroleid_array); $i++) {
        $URSRC_basicrole_profile_array_result = mysqli_query($con, "select * from LMC_USER_RIGHTS_CONFIGURATION URC,LMC_BASIC_ROLE_PROFILE BRP where  BRP.BRP_BR_ID=URC.URC_ID and BRP.BRP_BR_ID='" . $URSRC_basicroleid_array[$i] . "' order by URC_DATA asc ");
        while ($row = mysqli_fetch_array($URSRC_basicrole_profile_array_result)) {
            $get_URSRC_basicrole_profile_array[] = $row["URC_DATA"];
        }
    }
    $get_URSRC_basicrole_profile_array = array_values(array_unique($get_URSRC_basicrole_profile_array));
    $comp_startdate = get_company_start_date();
    $value_array = array($get_rolecreation_array, $get_project_array, $get_menuname_array, $get_URSRC_basicrole_profile_array, $URSRC_errmsg, $get_emptype_array, $comp_startdate, $get_team_array);
    echo JSON_ENCODE($value_array);
}
if ($_REQUEST["option"] == "EMAIL_TEMPLATE_ENTRY") {
    $error = '71,85,86';
    $error_array = get_error_msg($error);
    $values_array = array($error_array);
    echo JSON_ENCODE($values_array);
}
if ($_REQUEST["option"] == "RESET_FORM") {
    $str = '20,138,139';
    $URSRC_errmsg = get_error_msg($str);
    echo JSON_ENCODE($URSRC_errmsg);
}
开发者ID:Rajagunasekaran，项目名称:lmc，代码行数:31，代码来源:COMMON.php


示例19: json_encode

    }
    $select = $con->query('SELECT @SUCCESS_FLAG');
    $result = $select->fetch_assoc();
    $flag = $result['@SUCCESS_FLAG'];
    echo json_encode($flag);
}
//FUNTION FOR INITIAL LOAD
if ($_REQUEST['Option'] == "initial_data") {
    $TH_active_emp = get_active_emp_id();
    $TH_active_empname = array();
    $TH_query = mysqli_query($con, "SELECT * from VW_TS_PAYSLIP_ALL_ACTIVE_EMPLOYEE_DETAILS where URC_DATA!='SUPER ADMIN' ORDER BY EMPLOYEE_NAME");
    while ($row = mysqli_fetch_array($TH_query)) {
        $TH_active_empname[] = $row["EMPLOYEE_NAME"];
    }
    $error = '1,2,3,4,17,7';
    $error_array = get_error_msg($error);
    $paymentmode = array();
    $TH_query = mysqli_query($con, "SELECT EPM_PAYMENT_MODE FROM EMPLOYEE_PAYMENT_MODE");
    while ($row = mysqli_fetch_array($TH_query)) {
        $paymentmode[] = $row["EPM_PAYMENT_MODE"];
    }
    $Earning_labels = array();
    $TH_query = mysqli_query($con, "SELECT EEL_EARNING_LABELS FROM EMPLOYEE_PAYMENT_EARNING_LABELS ORDER BY EEL_EARNING_LABELS ASC");
    while ($row = mysqli_fetch_array($TH_query)) {
        $Earning_labels[] = $row["EEL_EARNING_LABELS"];
    }
    $Dedution = array();
    $TH_query = mysqli_query($con, "SELECT EPDL_DEDUCTION_LABELS FROM EMPLOYEE_PAYMENT_DEDUCTION_LABELS");
    while ($row = mysqli_fetch_array($TH_query)) {
        $Dedution[] = $row["EPDL_DEDUCTION_LABELS"];
    }
开发者ID:Rajagunasekaran，项目名称:TS，代码行数:31，代码来源:DB_PAYROLL.php


示例20: while

if($_REQUEST['option']=='COMMON_DATA')
{
//FILE NAME
    $filename=mysqli_query($con,"SELECT ULD_DOC_FILE_NAME FROM LMC_USER_LOGIN_DETAILS ORDER BY ULD_DOC_FILE_NAME ASC");
    $attachedfilename=array();
    $final_filearry=array();
    while($row=mysqli_fetch_array($filename)){
        $attachedfilename=array();
        $attachedfilename=explode('/',$row["ULD_DOC_FILE_NAME"]);
        for($i=0;$i<count($attachedfilename);$i++){
            $final_filearry[]=$attachedfilename[$i];
        }
        $attachedfileid=$row['ULD_ID'];
    }
    $errormsg=get_error_msg('37,40,41,42,46,48,56,83,133,139,141,142,146');

    $select_role=mysqli_query($con,"select URC_DATA from VW_TS_ALL_ACTIVE_EMPLOYEE_DETAILS where ULD_USERNAME='$UserStamp'");
    if($row=mysqli_fetch_array($select_role)){
        $rolename=$row["URC_DATA"];
    }
    $select_name=mysqli_query($con,"SELECT ULD_ID,ULD_WORKER_NAME FROM LMC_USER_LOGIN_DETAILS ORDER BY ULD_WORKER_NAME ASC");
    while($row=mysqli_fetch_array($select_name)){
        $empname[]=array($row["ULD_ID"],$row["ULD_WORKER_NAME"]);
    }
    $rcname_result=mysqli_query($con,"SELECT * FROM LMC_ROLE_CREATION ORDER BY RC_NAME");
    while($row=mysqli_fetch_array($rcname_result)){
        $rcname_array[]=array($row["RC_NAME"],$row["RC_ID"]);
    }
    $final_values=array($final_filearry,$errormsg,$rolename,$empname,$rcname_array);
    echo json_encode($final_values);
开发者ID:Rajagunasekaran，项目名称:lmc，代码行数:30，代码来源:DB_WORKER_PROFILE_SEARCH.php



注：本文中的get_error_msg函数示例整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。

鲜花
握手
雷人
路过
鸡蛋
该文章已有0人参与评论

请发表评论

全部评论

专题导读
More+
上一篇：
PHP get_events函数代码示例发布时间：2022-05-15
下一篇：
PHP get_error_message函数代码示例发布时间：2022-05-15
热门推荐
More+
热门话题
More+
阅读排行榜

扫描微信二维码

查看手机版网站

随时了解更新最新资讯

139-2527-9053

在线客服（服务时间 9:00～18:00）

在线QQ客服
地址：深圳市南山区西丽大学城创智工业园
电邮：jeky_zhao#qq.com
移动电话：139-2527-9053

Powered by 互联科技 X3.4© 2001-2213 极客世界.|Sitemap