Generating code

In the last post we created a list that will adapt and show data from any table. But there is one problem. I have a large text filed in my blog table. And it fills up the entire list. That is something one would read or edit after opening the page, not show in lists. We could of course automatically remove columns with large chunks of text and we actually might do that in another post. But right now I want to modify the code for my very specific need.

One way to do that is to just create a new file and add the necessary code. But that is to much coding for my taste. Instead I want to add a feature that will generate a complete file with code in the appropriate location, so that I only have to do a few modifications in order to get the list that I want.

Let's start by creating a copy of our list.php name list_code.php in the views/generic/ folder. Then we modify the index.php, with a $generate variable, like this:

        if (!is_file('views/' . $module . '/' . $view . '.php')) {
            $generate = filter_input(INPUT_GET, 'generate', FILTER_SANITIZE_URL);
            if ($generate != '') {
                $generate = '_'.$generate;
            }
            if (is_file('views/generic/' . $view . $generate . '.php')) {
                include('views/generic/' . $view . $generate . '.php');
            } else {
                echo '
The file ' . $view . '.php' . ' is missing!
';
            }
        } else {
            include('views/' . $module . '/' . $view . '.php');
        }

This means that if the file already is generated it will not be overwritten, unless deleted manually first. All we have to do is add the text &generate=code to the url.

Now let's modify our list_code.php so that it turns code into a string. Make sure you add all the columns separately into the string. Then we can create a file with the code and also print the code on the screen by replacing < with <.

fetchFields();
$colCount = count($fields);
$code =
'columnName . '`) LIKE UPPER('%' . $searchText . '%')';
        }
$code .= '      $srchQry = '' . $srchQry . '';
    } else {
        $srchQry = '1';
    }
    
    if (filter_input(INPUT_GET, 'orderby', FILTER_SANITIZE_URL) == '') {
        $orderBy = 'id';
    } else {
        $orderBy = filter_input(INPUT_GET, 'orderby', FILTER_SANITIZE_URL);
    }
    $desc = '';
    if (filter_input(INPUT_GET, 'desc', FILTER_SANITIZE_URL) == 1) {
        $desc = 'DESC';
    }
    $order = 'orderby=' . $orderBy . '&desc=' . filter_input(INPUT_GET, 'desc', FILTER_SANITIZE_URL);
    $orderBy = ' ORDER BY ' . $orderBy . ' ' . $desc;

    $postsPerPage = 20; // How many posts do you want to show per page
    $currentPage = (int)filter_input(INPUT_GET, 'current_page', FILTER_SANITIZE_NUMBER_INT);
    if ($currentPage == 0) { $currentPage = 1; } // We are on page 1 as default when current_page is not set.
    $index = ($currentPage * $postsPerPage) - $postsPerPage;
    $limit = '';
    if ($page != 0) {
        $limit = " LIMIT $index, $postsPerPage";
    }
    $total = $obj->fetchCount(' WHERE ' . $srchQry);
    $list = $obj->fetchArray(' WHERE ' . $srchQry . ' ' . $orderBy . ' ' . $limit);
    $pages = ceil((($total-1)/$postsPerPage));
    
    $query  = '&search_text=' . $searchText
            ;

    $pData  = '&module=' . $module
            . '&view=' . $view
            . '&id=' . $id
            ;

    $params = $pData
            . $query 
            ;
?>

    
' . $obj->realClassName() . ' list
    New post
    

        
        
        
        
        
    
     post 1) { echo 's'; } ?> found

    
';
            foreach ($fields as $t) {
$code .= '                
';
            }
$code .= '        
';
                $cnt = 0;
                foreach ($fields as $t) {
                    $name = $t->varName;
$code .= '                
';
                }
$code .= '            
';
$code .= '        

        

            
Edit
            
Delete

';
                if (preg_match("/_id$/", $t->columnName, $matches)) {
                    $columnArr = explode('-', $t->columnName);
$code .= '                    ' . Db::realClassName(str_replace('_id', '', $columnArr[0])) . '
';
                } else {
$code .= '                    ' . Db::realClassName($t->columnName) . '
';
                }
$code .= '                    -
                    +
                
        
            

                

                    
                        Edit
                    
                
                

                    
                        Delete
                    
                

';
                    if (preg_match("/_id$/", $t->columnName, $matches)) {
                        $columnArr = explode('-', $t->columnName);
                        if (count($columnArr) < 2) {
                          $columnArr[1] = $t->columnName;
                        }
                        $table = preg_replace("/_id$/", '', $columnArr[1]);
                        $className = preg_replace('/s/', '', ''.$obj->className($table));
                        $sc = new $className((int)$item->$name);
$code .= '                          table_data[1]; ?>';
                    } else {
                        if ($cnt < 2) {
$code .= '                      
';
                        }
$code .= '                          ' . $name . '; ?>
';
                        if ($cnt < 2) { $code .= '                      '; }
                        $cnt++;
                    }
$code .= '
';
$code .= '                

        
id . '&view=' . $view . '&' . 

$query . '&' . $order); ?>
    

';
// Make dir if it does not exist. Named after $module
if (!is_dir('views/' . $module)) {
    mkdir('views/' . $module);
}
$fh = fopen('views/' . $module . '/' . $view . '.php', 'w');
fwrite($fh, $code);
fclose($fh);
?>

  
File generated
  

  

When the file has been generated you will no longer end up at the code generating view, but instead at the new file. And we can go in and manually edit that file to our liking.

As you might have noticed I use

 tags before I echo the code to the screen. This is because I use the highlightjs library for highlighting code. If you do not use that then just using 
 is enough.

        
2015-10-02 11:44:28 - 
        framework, php, generic, software