14,970
edits
Data cleaning: Difference between revisions
Jump to navigation
Jump to search
→check if field value was not fulfilled: NULL, empty value
| Line 191: | Line 191: | ||
#* [http://php.net/manual/en/function.empty.php empty()] function to find 0, null, false, empty string, empty array values. | #* [http://php.net/manual/en/function.empty.php empty()] function to find 0, null, false, empty string, empty array values. | ||
#* <code>if(empty($var) && $var !== 0 && $var !== "0"){ .. } </code> to find null, false, empty string, empty array values BUT not 0. | #* <code>if(empty($var) && $var !== 0 && $var !== "0"){ .. } </code> to find null, false, empty string, empty array values BUT not 0. | ||
# check if field value was NULL & not equal to some value | |||
#* MySQL: [http://stackoverflow.com/questions/17097890/mysql-select-on-fields-containing-null-values MySql select on fields containing null values - Stack Overflow] | |||
# MySQL: [http://stackoverflow.com/questions/17097890/mysql-select-on-fields-containing-null-values MySql select on fields containing null values - Stack Overflow] | |||
=== check if field value was fulfilled === | === check if field value was fulfilled === | ||