Server : ApacheSystem : Linux sh00666.bluehost.com 5.14.0-687.26.1.el9_8.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Jul 14 16:32:02 EDT 2026 x86_64 User : ndkhermy ( 1200) PHP Version : 8.5.12 Disable Function : NONE Directory : /home1/ndkhermy/public_html/website_1ec2d7c2/apps/helpers/ |
Upload File : |
<?php if(!defined('BASEPATH')) exit('No direct script access allowed');
/**
* The global dbquery CI helpers
*/
if ( ! function_exists('custom_result_set'))
{
function custom_result_set($sql)
{
$ci = CI();
$query=$ci->db->query($sql);
if( $query->num_rows() > 0 )
{
return $query->result_array();
}
}
}
/*
$condtion = "WHERE page_id='16' AND status='1'" String format ;
$condtion = array('page_id'=>'16','status'=>'1') Array format;
*/
if ( ! function_exists('get_db_single_row'))
{
function get_db_single_row($tablename,$fields="*",$condition="1")
{
$ci = CI();
$cond = 'WHERE 1';
if( is_array($condition) && !empty($condition) )
{
foreach($condition as $key=>$value)
{
$cond .=" AND $key='".$value."'";
}
}else
{
$cond .= $condition;
}
$query=$ci->db->query("SELECT $fields FROM $tablename $cond");
$row_founds = $query->num_rows();
if( $row_founds > 1)
{
echo $message = "Query returns multiple result set please check : ";
echo_sql();
}elseif($row_founds > 0 )
{
return $query->row_array();
}
}
}
/*
$condtion = "WHERE page_id='16' AND status='1'" String format ;
$condtion = array('page_id'=>'16','status'=>'1') Array format;
*/
if ( ! function_exists('get_db_field_value'))
{
function get_db_field_value($tbl_name,$field,$condition)
{
$ci = CI();
$cond="WHERE 1";
if( @count($condition) > 0 && is_array($condition))
{
foreach($condition as $key=>$value)
{
$cond .=" AND $key='".$value."'";
}
}else
{
$cond .= $condition;
}
$query=$ci->db->query("SELECT $field FROM $tbl_name $cond");
if($query->num_rows() > 0)
{
$res=$query->row();
return $res->$field;
}
}
}
/*
*/
if ( !function_exists('count_record') )
{
function count_record ($table,$condition="")
{
$ci = CI();
if($table!="" && $condition!="")
{
$ci->db->from($table);
$ci->db->where($condition);
$num = $ci->db->count_all_results();
}else
{
$num = $ci->db->count_all($table);
}
return $num;
}
}
/*
*/
if ( !function_exists('get_found_rows') )
{
function get_found_rows()
{
$ci = CI();
$query=$ci->db->query('SELECT FOUND_ROWS() AS total');
$row=$query->row();
return $row->total;
}
}
/*
*/
if ( !function_exists('get_auto_increment') )
{
function get_auto_increment($tablename)
{
$ci = CI();
$query = $ci->db->query("SHOW TABLE STATUS LIKE '$tablename'");
if($query->num_rows()==1)
{
$row=$query->row();
return $inc=$row->Auto_increment;
}
}
}
/*
*/
if ( ! function_exists('echo_sql'))
{
function echo_sql()
{
$ci = CI();
echo"<font color='#ff0000' style='font-size:16px;font-family:verdana'><br />";
echo wordwrap($ci->db->last_query(),60,"<br />\n",TRUE);
echo"<br />\n </font>";
}
}