All posts by PF

SQL – LEFT OUTER JOIN adding returned null values

CodeIgniter, SQL

In a SQL with LEFT OUTER JOIN I had to sum some columns but some of them returned with NULL value and the result of it was a NULL.

So imagine that we want to add table1`.`columnA`to `table2`.`columnB`, we do something like this

SELECT *, (table1`.`columnA` + `table2`.`columnB`) AS total

and if some of them is NULL the total will be NULL.

What I had to do was this

SELECT *, (ifnull(`table1`.`columnA`,0 ) + ifnull(`table2`.`columnB`, 0)) AS total

And if you want to put it on codeigniter where is how I made it:

$this->db->select('*, (ifnull(`table1`.`columnA`,0 ) + ifnull(`table2`.`columnB`, 0)) AS total', FALSE);

Note the , FALSE, it has to be there.

$this->db->select() accepts an optional second parameter. If you set it to FALSE, CodeIgniter will not try to protect your field or table names with backticks. This is useful if you need a compound select statement.
http://ellislab.com/codeigniter/user-guide/database/active_record.html

CodeIgniter – radio and checkbox – value=”0″

CodeIgniter

So,

In a work that i’m working on, some values of checkboxes and radios have values = 0.
CodeIgniter don’t like them.

Found the solution for it here.

FYI – I fixed this bug. I dont know how to do pull requests – but you need to change Form_validation line 825:

from: if (($field == ” OR $value == ”) OR ($field != $value))
to: if (($field === ” OR $value === ”) OR ($field != $value))

Otherwise it doesnt evaluate the 0 correctly.

You probably also need to do it to lines 781 and 869 (set_select() and set_checkbox() )- but I havent tested it

By TheShiftExchange

CodeIgniter, dompdf-master and php-font-lib

CodeIgniter,

In a project for a non-lucrative organization, we need to implement a print to pdf.

rock ssd

A PHP Error was encountered

Severity: Warning Message: require_once(/home/creaftpu/subdomains/stocks/system/helpers/dompdf/lib/php-font-lib/classes/font.cls.php) [function.require-once]: failed to open stream: No such file or directory Filename: dompdf/dompdf_config.inc.php Line Number: 335 Fatal error: require_once() [function.require]: Failed opening required '/home/creaftpu/subdomains/stocks/system/helpers/dompdf/lib/php-font-lib/classes/font.cls.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in/home/creaftpu/subdomains/stocks/system/helpers/dompdf/dompdf_config.inc.php on line 335

We will use dompdf in codeigniter BUT the file that I’v downloaded from GitHub doesn’t has all the files that we need. It’s missing all the files of php-font-lib. So we had to download it and uploaded to the respective folder, to, to have dompdf working in codeigniter you might have to download php-font-lib.

My cPanel page was misconfigured with CloudFlare and had a strange IP on ‘Last Login From’

CloudFlare, cPanel

Today I’v logged in on my cPanel and is was misconfigured.

First thoughts was about cPanel had performed a bad update to cPanel from my hosting company (we always try to put the problems on the others), but then I’v logged in in a different account, in this case with no CloudFlare and I’v realised that the issue was caused by CloudFlare.


Continue reading My cPanel page was misconfigured with CloudFlare and had a strange IP on ‘Last Login From’ →

How to close session when browser is closed, in CodeIgniter?

CodeIgniter, , ,

We are building a small app for a non-lucrative, and we are using sessions on it – who doesn’t use it? -.
We need that when some user closes the browser the session must be destroyed.

This is how its done.

Open the geral config file application/config/config.php, search for $config[‘sess_expiration’]

$config['sess_cookie_name'] = 'ci_session';
$config['sess_expiration'] = 7200;
$config['sess_expire_on_close']	= FALSE;
$config['sess_encrypt_cookie']	= FALSE;
$config['sess_use_database']	= FALSE;

Change 7200 for -1. You should got something like

$config['sess_expiration'] = -1;

That should do the work! 🙂