bigprof

Bash script to switch PHP version on Debian/Ubuntu

You can run multiple versions of PHP on the same server. This is useful in many cases. For example:

• Testing the same PHP app under multiple PHP versions.
• Running several PHP apps that each requires a different version of PHP

I personally find this very useful to rapidly test apps generated by AppGini under multiple PHP versions.

AppGini is a nocode/lowcode graphical tool for configuring and generating web applications for easily managing data for small businesses, organizations, teams in small/large companies, or even your indvidual projects. Apps created by AppGini support multiple users, are responsive and mobile-friendly, work on LAMP stack for easy installation and wide support, allow importing and exporting of data to CSV, and many more features. A free fully working trial of AppGini can be downloaded from here

bigprof

Steps to add a theme switcher to your AppGini app

1. Place the code below in the generated hooks/footer-extras.php file.
2. Open the folder where AppGini is installed, typically C:\program files\appgini and navigate to the add-ons\themes folder.
3. Copy all the CSS files in that folder to the resources\initializr\css folder inside your AppGini app.

If you follow the above steps, you should be able to switch your app themes like this:

bigprof

<script>
  $j(() => {
    // show row numbers in TVP of the following tables
    // CHANGE THE TABLE NAMES IN THE LINE BELOW TO MATCH YOUR APP
    const tables = ['customers', 'employees'],
          tn = AppGini.currentTableName();

    if(tables.indexOf(tn) < 0) return;
    if(!tn || !$j('#sendToPrinter').length) return;

bigprof

Simple automated GIT Deployment using GIT Hooks

Here are the simple steps needed to create a deployment from your local GIT repository to a server based on this in-depth tutorial.

How it works

You are developing in a working-copy on your local machine, lets say on the master branch. Most of the time, people would push code to a remote server like github.com or gitlab.com and pull or export it to a production server. Or you use a service like deepl.io to act upon a Web-Hook that's triggered that service.

bigprof

*** Settings ***
Library  Selenium2Library
Suite Setup  start browser
Suite Teardown  end browser


*** Variables ***
${browser} =  ff

bigprof

<?php
     // my app includes
     include('./app/defaultLang.php');
     include('./app/lib.php');

bigprof

<?xml version="1.0" encoding="UTF-8"?>
<phpunit backupGlobals="false"
         backupStaticAttributes="false"
         bootstrap="bootstrap.php"
         colors="true"
         convertErrorsToExceptions="true"
         convertNoticesToExceptions="true"
         convertWarningsToExceptions="true"
         processIsolation="false"
         stopOnFailure="false">

bigprof

<?php
	/* Change the values below to match your database */
	$config = [
		'server' => 'localhost',
		'user' => 'dbuser',
		'pass' => 'password'
	];
	
	if(!isset($_REQUEST['db']) || !isset($_REQUEST['table'])) {
		?>

bigprof

<?php
	/**
	 * Basic script to perform global search on all tables of an AppGini application.
	 * Create a new file inside the hooks folder and name it 'global-search.php' then copy this code to it.
	 * Related post: https://forums.appgini.com/phpbb/viewtopic.php?f=2&t=1689&p=4510
	 */

	/* Assuming this custom file is placed inside 'hooks' */
	define('PREPEND_PATH', '../');
	$hooks_dir = dirname(__FILE__);

bigprof

<?php
	/* Assuming this custom file is placed inside 'hooks' */
	define('PREPEND_PATH', '../');
	$hooks_dir = dirname(__FILE__);
	include("{$hooks_dir}/../defaultLang.php");
	include("{$hooks_dir}/../language.php");
	include("{$hooks_dir}/../lib.php");
	
	include_once("{$hooks_dir}/../header.php");