- Count lines of code on a Database field
- // Get LOC
- $a = $code_source; // Variable holding our code
- $result = count_chars($a, 0);
- for ($i=0; $i < count($result); $i++) {
- if ($result[$i] != 0) {
- if (chr($i) == "n") // line feed
- $n = $result[$i];
- if (chr($i) == "r") // carriage return
- $r = $result[$i];
- }
- }
- if ($n > $r) $l = $n + 1;
- if ($r >= $n) $l = $r + 1;
- if (!isset($l) ) $l = "2";
- echo "Line Of Code = " . $l;
- //Get Disk Space Used
- if (function_exists('mb_strlen')) {
- $size = mb_strlen($code_source, '8bit');
- } else {
- $size = strlen($code_source);
- }
- if($size >= 1024)
- $size = round($size / 1024, 2).' KB';
- else
- $size = $size.' bytes';
- echo 'size of file' . ': ' . $size;
- class SourceCodeHelper{
- // Count total number of Lines (LOC)
- public function countLOC($string){
- $result = count_chars($string, 0);
- for ($i=0; $i < count($result); $i++) {
- if ($result[$i] != 0) {
- if (chr($i) == "nn") // line feed
- $n = $result[$i];
- if (chr($i) == "r") // carriage return
- $r = $result[$i];
- }
- }
- if ($n > $r) $l = $n + 1;
- if ($r >= $n) $l = $r + 1;
- if (!isset($l) ) $l = "2";
- //substr_count ($data, "n") + 1;
- return $l;
- }
- // Count total Source code lines of Code (SLOC)
- public function countSLOC($string){
- return count(preg_split("/ns*/", $string));
- }
- // Calculate disk space usage of string
- public function stringDiskSpace($string){
- if (function_exists('mb_strlen')) {
- $size = mb_strlen($string, '8bit');
- } else {
- $size = strlen($string);
- }
- return diskSpacePretty($size);
- }
- // Format a disk space usage into human readable format
- public function diskSpacePretty($size){
- if($size >= 1024)
- $size = round($size / 1024, 2).' KB';
- else
- $size = $size.' bytes';
- return $size;
- }
- substr_count ($data, "n") + 1; // since one n creates two lines
- count (preg_split ("/ns*/", $data))
- SELECT
- SUM( LENGTH(fieldname) - LENGTH(REPLACE(fieldname, 'n', ''))+1)
- FROM tablename