PHP fnColumnToField函数代码示例

OGeek|极客世界-中国程序员成长平台 › 门户 › 编程› PHP›PHP编程经验

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

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

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

示例1: mysql_real_escape_string

/* Filtering - NOTE this does not match the built-in DataTables filtering which does it
 * word by word on any field. It's possible to do here, but concerned about efficiency
 * on very large tables, and MySQL's regex functionality is very limited
 */
$sWhere = "";
if ($_GET['sSearch'] != "") {
    $sWhere = "WHERE ( engine LIKE '%" . mysql_real_escape_string($_GET['sSearch']) . "%' OR " . "browser LIKE '%" . mysql_real_escape_string($_GET['sSearch']) . "%' OR " . "platform LIKE '%" . mysql_real_escape_string($_GET['sSearch']) . "%' OR " . "version LIKE '%" . mysql_real_escape_string($_GET['sSearch']) . "%' OR " . "grade LIKE '%" . mysql_real_escape_string($_GET['sSearch']) . "%' )";
}
for ($i = 0; $i < $_GET['iColumns']; $i++) {
    if ($_GET['sSearch_' . $i] != '') {
        if ($sWhere != "") {
            $sWhere .= " AND ";
        } else {
            $sWhere .= "WHERE ";
        }
        $sWhere .= fnColumnToField($i) . " LIKE '%" . mysql_real_escape_string($_GET['sSearch_' . $i]) . "%'";
    }
}
$sQuery = "\n\t\tSELECT SQL_CALC_FOUND_ROWS id, engine, browser, platform, version, grade\n\t\tFROM   ajax\n\t\t{$sWhere}\n\t\t{$sOrder}\n\t\t{$sLimit}\n\t";
$rResult = mysql_query($sQuery, $gaSql['link']) or fatal_error('MySQL Error: ' . mysql_errno());
$sQuery = "\n\t\tSELECT FOUND_ROWS()\n\t";
$rResultFilterTotal = mysql_query($sQuery, $gaSql['link']) or fatal_error('MySQL Error: ' . mysql_errno());
$aResultFilterTotal = mysql_fetch_array($rResultFilterTotal);
$iFilteredTotal = $aResultFilterTotal[0];
$sQuery = "\n\t\tSELECT COUNT(id)\n\t\tFROM   ajax\n\t";
$rResultTotal = mysql_query($sQuery, $gaSql['link']) or fatal_error('MySQL Error: ' . mysql_errno());
$aResultTotal = mysql_fetch_array($rResultTotal);
$iTotal = $aResultTotal[0];
$sOutput = '{';
$sOutput .= '"sEcho": ' . intval($_GET['sEcho']) . ', ';
$sOutput .= '"iTotalRecords": ' . $iTotal . ', ';

开发者ID:for-art，项目名称:ManagerLab，代码行数:31，代码来源:filter_col.php

示例2: DBConnection

$db=new DBConnection();

$searchColumns=array('commodities_groups_id','commodities_groups_name');
$searchLimit='';
if (isset($_GET['iDisplayStart'])&&$_GET['iDisplayLength']!='-1'){
    $searchLimit='LIMIT '.$db->string_escape($_GET['iDisplayStart']).', '.$db->string_escape($_GET['iDisplayLength']).'';
}

/* Ordering */
if (isset($_GET['iSortCol_0'])){
    $searchOrder="ORDER BY  ";
    for($i=0; $i<$db->string_escape($_GET['iSortingCols']); $i++ ){
	$addComma='';
	if($i!=0) $addComma.=', ';
	$searchOrder.=$addComma.fnColumnToField($db->string_escape($_GET['iSortCol_'.$i])).' '.$db->string_escape($_GET['iSortDir_'.$i]).'';
    }
}

$searchFor='';
if ($_GET['sSearch']!=''){

    $searchFor.='WHERE ';
    foreach ($searchColumns AS $Count=>$columnToSearch) {
	$addOr='';
	if($Count!=0) $addOr.=' OR ';
	$searchFor.=$addOr.$columnToSearch.' LIKE "%'.$db->string_escape($_GET['sSearch']).'%"';
    }
}

$searchQuery='SELECT SQL_CALC_FOUND_ROWS * FROM commodities_groups '.$searchFor.' '.$searchOrder.' '.$searchLimit.'';

开发者ID:sahartak，项目名称:v1poject，代码行数:30，代码来源:tables_commodities_groups.php

示例3: mysql_pconnect

$gaSql['user'] = "root";
$gaSql['password'] = "Laguna";
$gaSql['db'] = "mailing";
$gaSql['server'] = "localhost";
$gaSql['link'] = mysql_pconnect($gaSql['server'], $gaSql['user'], $gaSql['password']) or die('Could not open connection to server');
mysql_select_db($gaSql['db'], $gaSql['link']) or die('Could not select database ' . $gaSql['db']);
/* Paging */
$sLimit = "";
if (isset($_GET['iDisplayStart']) && $_GET['iDisplayLength'] != '-1') {
    $sLimit = "LIMIT " . mysql_real_escape_string($_GET['iDisplayStart']) . ", " . mysql_real_escape_string($_GET['iDisplayLength']);
}
/* Ordering */
if (isset($_GET['iSortCol_0'])) {
    $sOrder = "ORDER BY  ";
    for ($i = 0; $i < mysql_real_escape_string($_GET['iSortingCols']); $i++) {
        $sOrder .= fnColumnToField(mysql_real_escape_string($_GET['iSortCol_' . $i])) . "\n\t\t\t \t" . mysql_real_escape_string($_GET['sSortDir_' . $i]) . ", ";
    }
    $sOrder = substr_replace($sOrder, "", -2);
}
/* Filtering - NOTE this does not match the built-in DataTables filtering which does it
 * word by word on any field. It's possible to do here, but concerned about efficiency
 * on very large tables, and MySQL's regex functionality is very limited
 */
$sWhere = "";
if ($_GET['sSearch'] != "") {
    $sWhere = "WHERE name LIKE '%" . mysql_real_escape_string($_GET['sSearch']) . "%' OR " . "city LIKE '%" . mysql_real_escape_string($_GET['sSearch']) . "%' OR " . "tel LIKE '%" . mysql_real_escape_string($_GET['sSearch']) . "%' OR " . "email LIKE '%" . mysql_real_escape_string($_GET['sSearch']) . "%' OR " . "www LIKE '%" . mysql_real_escape_string($_GET['sSearch']) . "%'";
}
$sQuery = "\n\t\tSELECT SQL_CALC_FOUND_ROWS idhouses, name, city, tel, email, www\n\t\tFROM   houses\n\t\t{$sWhere}\n\t\t{$sOrder}\n\t\t{$sLimit}\n\t";
$rResult = mysql_query($sQuery, $gaSql['link']) or die(mysql_error());
$sQuery = "\n\t\tSELECT FOUND_ROWS()\n\t";
$rResultFilterTotal = mysql_query($sQuery, $gaSql['link']) or die(mysql_error());

开发者ID:Coalas，项目名称:mailing，代码行数:31，代码来源:server_processing_id.php

示例4: generateServiceReport

function generateServiceReport($conn)
{
    global $gTEXT;
    require_once 'tcpdf/tcpdf.php';
    //require_once('fpdf/fpdi.php');
    //$pdf = new FPDI();
    $pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);
    $pdf->SetPrintHeader(false);
    $pdf->SetPrintFooter(false);
    $pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT);
    $pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
    $pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
    $pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
    $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
    if (@file_exists(dirname(__FILE__) . '/lang/eng.php')) {
        require_once dirname(__FILE__) . '/lang/eng.php';
        $pdf->setLanguageArray($l);
    }
    $pdf->AddPage();
    $pdf->SetFillColor(255, 255, 255);
    //=====================================================National Inventory Table=======================================================
    $Year = $_POST['Year'];
    $Month = $_POST['Month'];
    $CountryId = $_POST['CountryId'];
    $ServiceType = $_POST['ServiceType'];
    if ($CountryId) {
        $CountryId = " AND a.CountryId = " . $CountryId . " ";
    }
    $sLimit = "";
    if (isset($_POST['iDisplayStart'])) {
        $sLimit = " LIMIT " . mysql_real_escape_string($_POST['iDisplayStart']) . ", " . mysql_real_escape_string($_POST['iDisplayLength']);
    }
    $sOrder = "";
    if (isset($_POST['iSortCol_0'])) {
        $sOrder = " ORDER BY  ";
        for ($i = 0; $i < mysql_real_escape_string($_POST['iSortingCols']); $i++) {
            $sOrder .= fnColumnToField(mysql_real_escape_string($_POST['iSortCol_' . $i])) . "" . mysql_real_escape_string($_POST['sSortDir_' . $i]) . ", ";
        }
        $sOrder = substr_replace($sOrder, "", -2);
    }
    $sWhere = "";
    if ($_POST['sSearch'] != "") {
        $sWhere = " AND (FacilityName LIKE '%" . mysql_real_escape_string($_POST['sSearch']) . "%'\n                         OR NewPatient LIKE '%" . mysql_real_escape_string($_POST['sSearch']) . "%'\n                         OR TotalPatient LIKE '%" . mysql_real_escape_string($_POST['sSearch']) . "%') ";
    }
    $sql = "SELECT SQL_CALC_FOUND_ROWS a.FacilityId, FacilityName, IFNULL(SUM(a.NewPatient),0) NewPatient, IFNULL(SUM(a.TotalPatient),0) TotalPatient \n            FROM t_cfm_patientoverview a\n            INNER JOIN t_facility b ON a.FacilityId = b.FacilityId AND b.FLevelId = 99\t\n            INNER JOIN t_formulation d ON a.FormulationId = d.FormulationId AND d.ServiceTypeId = " . $ServiceType . "\n            INNER JOIN t_cfm_masterstockstatus f ON a.CFMStockId = f.CFMStockId AND StatusId = 5\n            WHERE a.MonthId = " . $Month . " AND a.Year = '" . $Year . "' " . $CountryId . " {$sWhere}  \n            GROUP BY a.FacilityId, FacilityName\n           \t{$sOrder} {$sLimit} ";
    $result = mysql_query($sql, $conn);
    $total = mysql_num_rows($result);
    if ($total > 0) {
        $data = array();
        $f = 0;
        $tblHTML = '';
        while ($rec = mysql_fetch_array($result)) {
            $data['SL'][$f] = $f;
            $data['FacilityName'][$f] = $rec['FacilityName'];
            $data['TotalPatient'][$f] = $rec['TotalPatient'] == 0 ? '' : $rec['TotalPatient'];
            //$data['NewPatient'][$f]=$rec['NewPatient']== 0? '' : $rec['NewPatient'];
            $tblHTML .= '<tr style="page-break-inside:avoid;">
                            <td align="center" width="50" valign="middle">' . ($data['SL'][$f] + 1) . '</td>  
                            <td align="left" width="300" valign="middle">' . $data['FacilityName'][$f] . '</td>
                            <td align="right" width="300" valign="middle">' . $data['TotalPatient'][$f] . '</td>
                            
                            
                    </tr>';
            //<td align="right" width="200" valign="middle">'.$data['NewPatient'][$f].'</td>
            $f++;
        }
        $Year = $_POST['Year'];
        $Month = $_POST['Month'];
        $CountryId = $_POST['CountryId'];
        $ServiceType = $_POST['ServiceType'];
        if ($CountryId) {
            $CountryId = " AND a.CountryId = " . $CountryId . " ";
        }
        $sql = "SELECT SQL_CALC_FOUND_ROWS a.FacilityId, FacilityName, IFNULL(SUM(a.NewPatient),0) NewPatient, IFNULL(SUM(a.TotalPatient),0) TotalPatient \n                FROM t_cfm_patientoverview a\n                INNER JOIN t_facility b ON a.FacilityId = b.FacilityId AND b.FLevelId = 99\t\n                INNER JOIN t_formulation d ON a.FormulationId = d.FormulationId AND d.ServiceTypeId = " . $ServiceType . "\n                INNER JOIN t_cfm_masterstockstatus f ON a.CFMStockId = f.CFMStockId AND StatusId = 5\n                WHERE a.MonthId = " . $Month . " AND a.Year = '" . $Year . "' " . $CountryId . "  \n                GROUP BY a.FacilityId, FacilityName";
        $result = mysql_query($sql);
        $totalPatient = 0;
        while ($aRow = mysql_fetch_object($result)) {
            $totalPatient = $totalPatient + $aRow->TotalPatient;
        }
        $Year = $_POST['Year'];
        $MonthName = $_POST['MonthName'];
        $CountryName = $_POST['CountryName'];
        $ServiceTypeName = $_POST['ServiceTypeName'];
        $html = '
        <!-- EXAMPLE OF CSS STYLE -->
        <style>
        </style>
        <body>
            <h4 style="text-align:center;"><b>' . $gTEXT['Facility Service Indicators Report of '] . '  ' . $CountryName . ' on ' . $MonthName . ',' . $Year . '</b></h4>
            <h4 style="text-align:center;"><b>' . $gTEXT['Service Type'] . ': ' . $ServiceTypeName . '</b></h4>
            <h4 style="text-align:center;"><b>' . $gTEXT['Total Patient'] . ' is ' . number_format($totalPatient) . ' </b></h4>
        </body>';
        $pdf->SetFont('dejavusans', '', 10);
        $pdf->writeHTMLCell(0, 0, 10, 10, $html, '', 0, 0, false, 'C', true);
        $html = '
            <!-- EXAMPLE OF CSS STYLE -->
            <style>
             td{
                 height: 6px;
                 line-height:3px;
//.........这里部分代码省略.........

开发者ID:sankam-nikolya，项目名称:lptt，代码行数:101，代码来源:r_facility_service_indicators_pdf.php

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

鲜花

握手

雷人

路过

鸡蛋

该文章已有0人参与评论

请发表评论

全部评论

专题导读

More+

10-27 六六分期app的软件客服如何联系？(六六分期

11-06 可心卡盟:win10系统火狐flash插件崩溃怎么

11-06 亲亲特价:怎么删除回收站图标

11-06 济南大学虚拟社区:鲁大师节能降温的具体办

11-06 xlueops.exe:无线网络安装向导

11-06 女斗合众国:win7系统cf与主机连接不稳定怎

11-06 0xc000022-[cf烟雾头]cf怎么调烟雾头

11-06 qizideyouhuo:应用程序无法正常启动0xc0000

11-06 ipz-185:win7系统vcf文件怎么打开

11-06 傻哥蹦迪:win10系统s4怎么打开usb调试

11-06 八神浩树gtaste:回收站清空了怎么恢复

11-06 妖尾之黑色守护:win10系统电脑没有1440x900

11-06 校园至尊魔王小说:win7系统浏览网页时字体

11-06 女斗合众国:win10系统访问共享文件夹提示请

11-06 tokyo hot n0654:恢复win7系统默认字体一招

11-06 雨酷仙境:设置win7系统转移临时文件夹腾出

11-06 阿穆纳伊之杖:win7系统开始菜单在右边还原

11-06 tunespotting:win10系统火狐flash插件总是

11-06 甘尔葛分析师：计谋网站seo关键词暴涨有什

11-06 蔡贵霖: 计谋网站seo关键词暴涨有什么秘密

11-06 博益网首页:ao3网页版进入不了解决方法

11-06 漏斗子专栏: 网站数据分析小白易懂精华篇

11-06 见证双虹怎么做:win7系统开启telnet命令的

11-06 颾狐蝶蜋:系统资源不足无法完成请求的服务

11-06 国光中学校歌:提交网站到alexa查询详细步骤

11-06 西安有情天:静态网页和动态网页的区别

11-06 红木雅尚斋:外部链接构造对网站的好处

11-06 前官礼遇：防止域名劫持–增强域安全性的10

11-06 密传二转答案: 中文分词算法有哪些

11-06 金泉家园邮编:百度快照劫持的表现及应对方

PHP fnSearchCondition函数代码示例发布时间：2022-05-15

PHP fmt函数代码示例发布时间：2022-05-15

DelphiFindowWindow,FindowWindowEx

1 krishnaik06/Machine-Learning-in-90-days

krishnaik06/Machine-Learning-in-90-days

阅读：1040|2022-08-18

2 armancodv/building-energy-model-matlab:

armancodv/building-energy-model-matlab: It is a small software which is develope

阅读：1091|2022-08-17

3 美元符号为什么是“$”

在美元的英文“dollar”里面明明没有字母“s”，为什么美元的符号($)是一条竖线穿过字

阅读：1039|2022-11-06

4 基于MATLAB实现的云模型计算隶属度

”云”或者’云滴‘是云模型的基本单元，所谓云是指在其论域上的一个分布，可以用联合

阅读：532|2022-07-18

5 FGRibreau/import-tweets-to-mastodon: How

FGRibreau/import-tweets-to-mastodon: How to import tweets to mastodon (e.g. http

阅读：904|2022-08-17

6 CVE-2022-21533

Vulnerability in the Oracle Solaris product of Oracle Systems (component: SMB Se

阅读：445|2022-07-29

7 CVE-2022-30223

Windows Hyper-V Information Disclosure Vulnerability. This CVE ID is unique from

阅读：924|2022-07-29

8 blevesearch/bleve: A modern text indexin

blevesearch/bleve: A modern text indexing library for go

阅读：1047|2022-08-15

9 tboronczyk/localization-middleware: PSR-

tboronczyk/localization-middleware: PSR-15 middleware to assist primarily with l

阅读：488|2022-08-16

10 长沙科技学院怎么样?是几本

长沙城南，有一所以“环保”为名的学校，从1979年创立以来，四易归属、五更其名。这

阅读：731|2022-11-06

客服电话

电子邮件

PHP fnColumnToField函数代码示例

示例1: mysql_real_escape_string

示例2: DBConnection

示例3: mysql_pconnect

示例4: generateServiceReport

请发表评论

全部评论

上一篇：

下一篇：

librespeed/speedtest: Self-hosted Speedt

avehtari/BDA_m_demos: Bayesian Data Anal

四维彩超怎么看性别？四维看男孩女孩诀窍

CVE-2022-2486

medfreeman/markdown-it-toc-and-anchor: m

DelphiFindowWindow,FindowWindowEx

GaloyMoney/galoy-mobile

swcarpentry/matlab-novice-inflammation:

美国三一学院字怎么样？专业特色有哪些？

Twzy/MarkWord: a markdown editer

home-assistant/supervised-installer: Ins

关于我们

产品与服务

解决方案

139-2527-9053