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

PHP mysql_error_logging函数代码示例

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

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



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

示例1: mysql_query

    $MT[0] = '';
    $row = '';
    $rowx = '';
    $channel_live = 1;
    if (strlen($conf_exten) < 1 || strlen($exten) < 1) {
        $channel_live = 0;
        echo "Conf Exten {$conf_exten} nie jest prawidłowy or Exten {$exten} nie jest prawidłowy\n";
        exit;
    } else {
        $stmt = "UPDATE conferences set extension='{$exten}' where server_ip = '{$server_ip}' and conf_exten = '{$conf_exten}';";
        if ($format == 'debug') {
            echo "\n<!-- {$stmt} -->";
        }
        $rslt = mysql_query($stmt, $link);
        if ($mel > 0) {
            mysql_error_logging($NOW_TIME, $link, $mel, $stmt, '03013', $user, $server_ip, $session_name, $one_mysql_log);
        }
    }
    echo "Konferencja {$conf_exten} został zarejestrowany {$exten}\n";
}
if ($format == 'debug') {
    $ENDtime = date("U");
    $RUNtime = $ENDtime - $StarTtime;
    echo "\n<!-- czas działania skyptu: {$RUNtime} sekundy -->";
    echo "\n</body>\n</html>\n";
}
exit;
##### MySQL Error Logging #####
function mysql_error_logging($NOW_TIME, $link, $mel, $stmt, $query_id, $user, $server_ip, $session_name, $one_mysql_log)
{
    $NOW_TIME = date("Y-m-d H:i:s");
开发者ID:akandshuvo,项目名称:Vicidial,代码行数:31,代码来源:conf_exten_check.php


示例2: count

	echo "$row[0] ~$row[1] ~$row[2] ~$callback_id[$loop_count] ~$lead_id[$loop_count] ~$campaign_id[$loop_count] ~$status[$loop_count] ~$entry_time[$loop_count] ~$callback_time[$loop_count] ~$comments[$loop_count]\n";
	$loop_count++;
	}

}


################################################################################
### CalLBacKCounT - send the count of the USERONLY callbacks for an agent
################################################################################
if ($ACTION == 'CalLBacKCounT')
{
$stmt = "select count(*) from vicidial_callbacks where recipient='USERONLY' and user='$user' and campaign_id='$campaign' and status NOT IN('INACTIVE','DEAD');";
if ($DB) {echo "$stmt\n";}
$rslt=mysql_query($stmt, $link);
			if ($mel > 0) {mysql_error_logging($NOW_TIME,$link,$mel,$stmt,'00180',$user,$server_ip,$session_name,$one_mysql_log);}
$row=mysql_fetch_row($rslt);
$cbcount=$row[0];

echo "$cbcount";
}




if ($format=='debug') 
{
$ENDtime = date("U");
$RUNtime = ($ENDtime - $StarTtime);
echo "\n<!-- χρόνος εκτέλεσης: $RUNtime δευτερόλεπτα -->";
echo "\n</body>\n</html>\n";
开发者ID:h4ck3rm1k3,项目名称:vicidial-asterisk-gui,代码行数:31,代码来源:vdc_db_query.php


示例3: mysql_query

 }
 if (strlen($D_s_ip[2]) < 3) {
     $D_s_ip[2] = "0{$D_s_ip['2']}";
 }
 if (strlen($D_s_ip[3]) < 2) {
     $D_s_ip[3] = "0{$D_s_ip['3']}";
 }
 if (strlen($D_s_ip[3]) < 3) {
     $D_s_ip[3] = "0{$D_s_ip['3']}";
 }
 $server_ip_dialstring = "{$D_s_ip['0']}{$S}{$D_s_ip['1']}{$S}{$D_s_ip['2']}{$S}{$D_s_ip['3']}{$S}";
 ##### grab the datails of all active scripts in the system
 $stmt = "SELECT script_id,script_name FROM vicidial_scripts WHERE active='Y' order by script_id limit 1000;";
 $rslt = mysql_query($stmt, $link);
 if ($mel > 0) {
     mysql_error_logging($NOW_TIME, $link, $mel, $stmt, '01051', $VD_login, $server_ip, $session_name, $one_mysql_log);
 }
 if ($DB) {
     echo "{$stmt}\n";
 }
 $MM_scripts = mysql_num_rows($rslt);
 $e = 0;
 while ($e < $MM_scripts) {
     $row = mysql_fetch_row($rslt);
     $MMscriptid[$e] = $row[0];
     $MMscriptname[$e] = urlencode($row[1]);
     $MMscriptids = "{$MMscriptids}'{$MMscriptid[$e]}',";
     $MMscriptnames = "{$MMscriptnames}'{$MMscriptname[$e]}',";
     $e++;
 }
 $MMscriptids = substr("{$MMscriptids}", 0, -1);
开发者ID:jamesdouglas,项目名称:vicidial,代码行数:31,代码来源:vicidial.php


示例4: custom_list_fields_values

function custom_list_fields_values($lead_id, $list_id, $uniqueid, $user)
{
    $STARTtime = date("U");
    $TODAY = date("Y-m-d");
    $NOW_TIME = date("Y-m-d H:i:s");
    $vicidial_list_fields = '|lead_id|vendor_lead_code|source_id|list_id|gmt_offset_now|called_since_last_reset|phone_code|phone_number|title|first_name|middle_initial|last_name|address1|address2|address3|city|state|province|postal_code|country_code|gender|date_of_birth|alt_phone|email|security_phrase|comments|called_count|last_local_call_time|rank|owner|';
    require "dbconnect.php";
    $CFoutput = '';
    $stmt = "SHOW TABLES LIKE \"custom_{$list_id}\";";
    if ($DB > 0) {
        echo "{$stmt}";
    }
    $rslt = mysql_query($stmt, $link);
    if ($mel > 0) {
        mysql_error_logging($NOW_TIME, $link, $mel, $stmt, '05002', $user, $server_ip, $session_name, $one_mysql_log);
    }
    $tablecount_to_print = mysql_num_rows($rslt);
    if ($tablecount_to_print > 0) {
        $stmt = "SELECT count(*) from custom_{$list_id};";
        if ($DB > 0) {
            echo "{$stmt}";
        }
        $rslt = mysql_query($stmt, $link);
        if ($mel > 0) {
            mysql_error_logging($NOW_TIME, $link, $mel, $stmt, '05003', $user, $server_ip, $session_name, $one_mysql_log);
        }
        $fieldscount_to_print = mysql_num_rows($rslt);
        if ($fieldscount_to_print > 0) {
            $rowx = mysql_fetch_row($rslt);
            $custom_records_count = $rowx[0];
            $select_SQL = '';
            $stmt = "SELECT field_id,field_label,field_name,field_description,field_rank,field_help,field_type,field_options,field_size,field_max,field_default,field_cost,field_required,multi_position,name_position,field_order from vicidial_lists_fields where list_id='{$list_id}' order by field_rank,field_order,field_label;";
            $rslt = mysql_query($stmt, $link);
            if ($mel > 0) {
                mysql_error_logging($NOW_TIME, $link, $mel, $stmt, '05004', $user, $server_ip, $session_name, $one_mysql_log);
            }
            $fields_to_print = mysql_num_rows($rslt);
            $fields_list = '';
            $o = 0;
            while ($fields_to_print > $o) {
                $rowx = mysql_fetch_row($rslt);
                $A_field_id[$o] = $rowx[0];
                $A_field_label[$o] = $rowx[1];
                $A_field_name[$o] = $rowx[2];
                $A_field_description[$o] = $rowx[3];
                $A_field_rank[$o] = $rowx[4];
                $A_field_help[$o] = $rowx[5];
                $A_field_type[$o] = $rowx[6];
                $A_field_options[$o] = $rowx[7];
                $A_field_size[$o] = $rowx[8];
                $A_field_max[$o] = $rowx[9];
                $A_field_default[$o] = $rowx[10];
                $A_field_cost[$o] = $rowx[11];
                $A_field_required[$o] = $rowx[12];
                $A_multi_position[$o] = $rowx[13];
                $A_name_position[$o] = $rowx[14];
                $A_field_order[$o] = $rowx[15];
                $A_field_value[$o] = '';
                if (!preg_match("/\\|{$A_field_label[$o]}\\|/", $vicidial_list_fields)) {
                    if ($A_field_type[$o] == 'DISPLAY' or $A_field_type[$o] == 'SCRIPT') {
                        $select_SQL .= "8,";
                        $A_field_select[$o] = '----EMPTY----';
                    } else {
                        $select_SQL .= "{$A_field_label[$o]},";
                        $A_field_select[$o] = $A_field_label[$o];
                    }
                } else {
                    $select_SQL .= "8,";
                    $A_field_value[$o] = '--A--' . $A_field_label[$o] . '--B--';
                }
                $o++;
                $rank_select .= "<option>{$o}</option>";
            }
            $o++;
            $rank_select .= "<option>{$o}</option>";
            $last_rank = $o;
            $select_SQL = preg_replace("/.\$/", '', $select_SQL);
            $list_lead_ct = 0;
            if (strlen($select_SQL) > 0) {
                ##### BEGIN grab the data from custom table for the lead_id
                $stmt = "SELECT {$select_SQL} FROM custom_{$list_id} where lead_id='{$lead_id}' LIMIT 1;";
                $rslt = mysql_query($stmt, $link);
                if ($mel > 0) {
                    mysql_error_logging($NOW_TIME, $link, $mel, $stmt, '05005', $user, $server_ip, $session_name, $one_mysql_log);
                }
                if ($DB) {
                    echo "{$stmt}\n";
                }
                $list_lead_ct = mysql_num_rows($rslt);
            }
            if ($list_lead_ct > 0) {
                $row = mysql_fetch_row($rslt);
                $o = 0;
                while ($fields_to_print >= $o) {
                    $A_field_value[$o] = trim("{$row[$o]}");
                    if ($A_field_select[$o] == '----EMPTY----') {
                        $A_field_value[$o] = '';
                    }
                    if (preg_match("/\\|{$A_field_label[$o]}\\|/", $vicidial_list_fields)) {
                        $A_field_value[$o] = '--A--' . $A_field_label[$o] . '--B--';
//.........这里部分代码省略.........
开发者ID:J-Rod1988,项目名称:Vicidial,代码行数:101,代码来源:functions.php


示例5: custom_list_fields_values

function custom_list_fields_values($lead_id, $list_id, $uniqueid, $user)
{
    $STARTtime = date("U");
    $TODAY = date("Y-m-d");
    $NOW_TIME = date("Y-m-d H:i:s");
    $vicidial_list_fields = '|lead_id|vendor_lead_code|source_id|list_id|gmt_offset_now|called_since_last_reset|phone_code|phone_number|title|first_name|middle_initial|last_name|address1|address2|address3|city|state|province|postal_code|country_code|gender|date_of_birth|alt_phone|email|security_phrase|comments|called_count|last_local_call_time|rank|owner|';
    require "dbconnect_mysqli.php";
    $CFoutput = '';
    $stmt = "SHOW TABLES LIKE \"custom_{$list_id}\";";
    if ($non_latin > 0) {
        $rslt = mysql_to_mysqli("SET NAMES 'UTF8'", $link);
    }
    if ($DB > 0) {
        echo "{$stmt}";
    }
    $rslt = mysql_to_mysqli($stmt, $link);
    if ($mel > 0) {
        mysql_error_logging($NOW_TIME, $link, $mel, $stmt, '05002', $user, $server_ip, $session_name, $one_mysql_log);
    }
    $tablecount_to_print = mysqli_num_rows($rslt);
    if ($tablecount_to_print > 0) {
        $stmt = "SELECT count(*) from custom_{$list_id};";
        if ($DB > 0) {
            echo "{$stmt}";
        }
        $rslt = mysql_to_mysqli($stmt, $link);
        if ($mel > 0) {
            mysql_error_logging($NOW_TIME, $link, $mel, $stmt, '05003', $user, $server_ip, $session_name, $one_mysql_log);
        }
        $fieldscount_to_print = mysqli_num_rows($rslt);
        if ($fieldscount_to_print > 0) {
            $rowx = mysqli_fetch_row($rslt);
            $custom_records_count = $rowx[0];
            $select_SQL = '';
            $stmt = "SELECT field_id,field_label,field_name,field_description,field_rank,field_help,field_type,field_options,field_size,field_max,field_default,field_cost,field_required,multi_position,name_position,field_order from vicidial_lists_fields where list_id='{$list_id}' order by field_rank,field_order,field_label;";
            $rslt = mysql_to_mysqli($stmt, $link);
            if ($mel > 0) {
                mysql_error_logging($NOW_TIME, $link, $mel, $stmt, '05004', $user, $server_ip, $session_name, $one_mysql_log);
            }
            $fields_to_print = mysqli_num_rows($rslt);
            $fields_list = '';
            $o = 0;
            while ($fields_to_print > $o) {
                $rowx = mysqli_fetch_row($rslt);
                $A_field_id[$o] = $rowx[0];
                $A_field_label[$o] = $rowx[1];
                $A_field_name[$o] = $rowx[2];
                $A_field_description[$o] = $rowx[3];
                $A_field_rank[$o] = $rowx[4];
                $A_field_help[$o] = $rowx[5];
                $A_field_type[$o] = $rowx[6];
                $A_field_options[$o] = $rowx[7];
                $A_field_size[$o] = $rowx[8];
                $A_field_max[$o] = $rowx[9];
                $A_field_default[$o] = $rowx[10];
                $A_field_cost[$o] = $rowx[11];
                $A_field_required[$o] = $rowx[12];
                $A_multi_position[$o] = $rowx[13];
                $A_name_position[$o] = $rowx[14];
                $A_field_order[$o] = $rowx[15];
                $A_field_value[$o] = '';
                if (!preg_match("/\\|{$A_field_label[$o]}\\|/i", $vicidial_list_fields)) {
                    if ($A_field_type[$o] == 'DISPLAY' or $A_field_type[$o] == 'SCRIPT') {
                        $select_SQL .= "8,";
                        $A_field_select[$o] = '----EMPTY----';
                    } else {
                        $select_SQL .= "{$A_field_label[$o]},";
                        $A_field_select[$o] = $A_field_label[$o];
                    }
                } else {
                    $select_SQL .= "8,";
                    $A_field_value[$o] = '--A--' . $A_field_label[$o] . '--B--';
                }
                $o++;
                $rank_select .= "<option>{$o}</option>";
            }
            $o++;
            $rank_select .= "<option>{$o}</option>";
            $last_rank = $o;
            $select_SQL = preg_replace("/.\$/", '', $select_SQL);
            $list_lead_ct = 0;
            if (strlen($select_SQL) > 0) {
                ##### BEGIN grab the data from custom table for the lead_id
                $stmt = "SELECT {$select_SQL} FROM custom_{$list_id} where lead_id='{$lead_id}' LIMIT 1;";
                $rslt = mysql_to_mysqli($stmt, $link);
                if ($mel > 0) {
                    mysql_error_logging($NOW_TIME, $link, $mel, $stmt, '05005', $user, $server_ip, $session_name, $one_mysql_log);
                }
                if ($DB) {
                    echo "{$stmt}\n";
                }
                $list_lead_ct = mysqli_num_rows($rslt);
            }
            if ($list_lead_ct > 0) {
                $row = mysqli_fetch_row($rslt);
                $o = 0;
                while ($fields_to_print >= $o) {
                    $A_field_value[$o] = trim("{$row[$o]}");
                    if ($A_field_select[$o] == '----EMPTY----') {
                        $A_field_value[$o] = '';
//.........这里部分代码省略.........
开发者ID:vultuk,项目名称:VicidialSubversion,代码行数:101,代码来源:functions.php


示例6: status_group_gather

function status_group_gather($status_group_id, $record_type)
{
    global $NOW_TIME, $link, $mel, $user, $server_ip, $session_name, $one_mysql_log;
    $status_group_statuses = '';
    $cs_ct = 0;
    if (strlen($status_group_id) > 0 and $status_group_id != 'NONE') {
        $stmt = "SELECT status,status_name,scheduled_callback,min_sec,max_sec from vicidial_campaign_statuses where campaign_id='{$status_group_id}' and selectable='Y';";
        if ($DB) {
            echo "{$stmt}\n";
        }
        $rslt = mysql_to_mysqli($stmt, $link);
        if ($mel > 0) {
            mysql_error_logging($NOW_TIME, $link, $mel, $stmt, '00654', $user, $server_ip, $session_name, $one_mysql_log);
        }
        if ($rslt) {
            $cs_ct = mysqli_num_rows($rslt);
        }
        $i = 0;
        while ($cs_ct > $i) {
            $row = mysqli_fetch_row($rslt);
            $status = $row[0];
            $status_name = $row[1];
            $scheduled_callback = $row[2];
            $min_sec = $row[3];
            $max_sec = $row[4];
            $status_group_statuses .= "{$status}|{$status_name}|{$scheduled_callback}|{$min_sec}|{$max_sec},";
            $i++;
        }
        if (strlen($status_group_statuses) > 0) {
            $status_group_statuses = substr("{$status_group_statuses}", 0, -1);
        }
    }
    return $status_group_statuses;
}
开发者ID:vultuk,项目名称:VicidialSubversion,代码行数:34,代码来源:vdc_db_query.php


示例7: get_audited_comments

function get_audited_comments($lead_id, $format, $user, $mel, $NOW_TIME, $link, $server_ip, $session_name, $one_mysql_log)
{
    global $ACcount;
    global $ACcomments;
    $stmt = "select user_id,comment from vicidial_comments where lead_id='{$lead_id}';";
    if ($mel > 0) {
        mysql_error_logging($NOW_TIME, $link, $mel, $stmt, "00142-65-AuditComments:{$stmt} LeadID: {$lead_id},{$format},{$user},{$mel},{$NOW_TIME},{$link},{$server_ip},{$session_name},{$one_mysql_log}", $user, $server_ip, $session_name, $one_mysql_log);
    }
    $rslt = mysql_query($stmt, $link);
    if ($mel > 0) {
        mysql_error_logging($NOW_TIME, $link, $mel, $stmt, '00142-69-AuditComments', $user, $server_ip, $session_name, $one_mysql_log);
    }
    $ACcount = mysql_num_rows($rslt);
    mysql_error_logging($NOW_TIME, $link, $mel, $stmt, '00142-72-AuditComments $ACcount=' . $ACcount, $user, $server_ip, $session_name, $one_mysql_log);
    if ($ACcount > 0) {
        $i = 0;
        while ($i < $ACcount) {
            $row = mysql_fetch_row($rslt);
            mysql_error_logging($NOW_TIME, $link, $mel, $stmt, '00142-77-AuditComments UserID=' . $row[0], $user, $server_ip, $session_name, $one_mysql_log);
            $ACcomments .= "UserID: {$row['0']}\n";
            mysql_error_logging($NOW_TIME, $link, $mel, $stmt, '00142-79-AuditComments Comment=' . $row[1], $user, $server_ip, $session_name, $one_mysql_log);
            $ACcomments .= $row[1];
            $ACcomments .= "\n----------------------------------\n";
            $i++;
        }
        return true;
    } else {
        return false;
    }
}
开发者ID:himanshu12k,项目名称:ce-www,代码行数:30,代码来源:audit_comments.php


示例8: get_audited_comments

function get_audited_comments($lead_id, $format, $user, $mel, $NOW_TIME, $link, $server_ip, $session_name, $one_mysql_log)
{
    global $ACcount;
    global $ACcomments;
    $stmt = "SELECT user_id,comment,timestamp from vicidial_comments where lead_id='{$lead_id}' order by timestamp desc;";
    $rslt = mysql_to_mysqli($stmt, $link);
    if ($mel > 0) {
        mysql_error_logging($NOW_TIME, $link, $mel, $stmt, '00142-69-AuditComments', $user, $server_ip, $session_name, $one_mysql_log);
    }
    $ACcount = mysqli_num_rows($rslt);
    if ($ACcount > 0) {
        $i = 0;
        while ($i < $ACcount) {
            $row = mysqli_fetch_row($rslt);
            $C_user[$i] = $row[0];
            $C_comment[$i] = $row[1];
            $C_date[$i] = $row[2];
            $i++;
        }
        $i = 0;
        while ($i < $ACcount) {
            $C_name[$i] = 'Unknown';
            $C_level[$i] = '1';
            $FCS = '';
            $FCE = '';
            $stmt = "SELECT full_name,user_level from vicidial_users where user='{$C_user[$i]}';";
            $rslt = mysql_to_mysqli($stmt, $link);
            if ($mel > 0) {
                mysql_error_logging($NOW_TIME, $link, $mel, $stmt, '00142-70-AuditCommentsUser', $user, $server_ip, $session_name, $one_mysql_log);
            }
            $Ucount = mysqli_num_rows($rslt);
            if ($Ucount > 0) {
                $row = mysqli_fetch_row($rslt);
                $C_name[$i] = $row[0];
                $C_level[$i] = $row[1];
            }
            if ($C_level[$i] > 7) {
                $FCS = '--------ADMINFONTBEGIN--------';
                $FCE = '--------ADMINFONTEND--------';
            }
            $ACcomments .= _QXZ("UserID: {$FCS}%1s - %2s{$FCE},  Date: %3s", 0, '', $C_user[$i], $C_name[$i], $C_date[$i]) . "\n";
            $ACcomments .= $C_comment[$i];
            $ACcomments .= "\n----------------------------------\n";
            $i++;
        }
        return true;
    } else {
        return false;
    }
}
开发者ID:vultuk,项目名称:VicidialSubversion,代码行数:50,代码来源:audit_comments.php



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


鲜花

握手

雷人

路过

鸡蛋
该文章已有0人参与评论

请发表评论

全部评论

专题导读
上一篇:
PHP mysql_escape函数代码示例发布时间:2022-05-15
下一篇:
PHP mysql_error函数代码示例发布时间:2022-05-15
热门推荐
阅读排行榜

扫描微信二维码

查看手机版网站

随时了解更新最新资讯

139-2527-9053

在线客服(服务时间 9:00~18:00)

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

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