abelcallejo

<?php

function propername( $name, $language="es-ph" )
    {
    $language = str_replace("-","_",$language);
    
    $exceptions = array(
        "es_ph" => array(
            "de",
            "del",

abelcallejo

Executing commands on a remote server by using a local script

Sometimes you will need to execute commands on a remote server routinely but you don't want them to be scheduled. This material will guide you in doing it.

Prepared script

prepared_bash_script.sh - a sample bash/shell script that is in the local machine.

abelcallejo

The jsonld_encode() function on PHP

Encodes an object or an array into JSON-LD format

Problem

JSON-LD uses the at '@' character as part of the JSON key naming convention.

Algorithm

abelcallejo

Creating bootable Linux USB using Mac

CentOS, Ubuntu, Slackware, etc. Whatever Linux-based OS it is, you can create a bootable USB for it by using a Mac.

1. Prepare the .iso file

Download it, copy it, whatever it takes to prepare that Linux-based OS .iso file

2. Convert the .iso file into a .img.dmg

abelcallejo

Creating triggers on PostgreSQL

Step 1. Create the function

CREATE FUNCTION custom_function() RETURNS trigger AS $$
  /**
  Do your magic here
  **/
$$

abelcallejo

Using the Screen tool

Starting a screen

screen

Detaching a screen

1. Press control + a then immidiately follow it with

abelcallejo

PHP date manipulation techniques

ISO string date to PHP date object

<?php
$date = new DateTime('2000-01-01');
echo $date->format('Y-m-d H:i:s');
?>

abelcallejo

Executing a PostgreSQL script using a local file

Execute the prepared script

psql --quiet -h hostname -U user_name -w -d postgres -f "/path/to/prepared_script.sql"

abelcallejo

Selecting all the column names of a particular table

Query statement

SELECT
  column_name
FROM
  information_schema.columns
WHERE

abelcallejo

Generating SSH keys

Generating private and public keys

ssh-keygen -t rsa -b 4096 -q -f "/home/bill/.ssh/id_rsa" -N ""

Generating PEM file