Skip to content

Instantly share code, notes, and snippets.

@carlosleonam
carlosleonam / 7zip-7z-to-backup-mysql-mariadb-databases.md
Last active April 26, 2023 21:40
7zip (7z) to Backup MySQL/MariaDB Databases

7zip (7z) to Backup MySQL/MariaDB Databases

Remenber to install &zip before

Create a simple shell script

#!/bin/bash

BACKUPDIR="/backup/databases/"
DATE=`date +%s`
@carlosleonam
carlosleonam / xdebug-personal-styling.md
Last active April 23, 2023 17:22
XDebug Personal Styling

XDebug Personal Styling

Add below CSS to your styles files

/* Xdebug Styling II */
.xdebug-error {

 font-size: 12px !important;
@carlosleonam
carlosleonam / is_localhost
Created April 22, 2023 11:35 — forked from troutacular/is_localhost
PHP - Check if localhost
// Check if we are in a local environment
function is_localhost() {
// set the array for testing the local environment
$whitelist = array( '127.0.0.1', '::1' );
// check if the server is in the array
if ( in_array( $_SERVER['REMOTE_ADDR'], $whitelist ) ) {
@carlosleonam
carlosleonam / .php
Created April 22, 2023 11:26 — forked from cupertinobr/.php
Add texto no footer - addFooterWidget
<?php
....
//Adicionar um texto ao footer do form
$addText = new TTextDisplay(FormService::getByAndAt($object), 'gray', 10, 'i');
$this->form->addFooterWidget($addText);
@carlosleonam
carlosleonam / tdatagrid-order-relation-column.md
Last active April 6, 2023 20:00
Ordenação de Coluna Relacionada

Ordenação de Coluna Relacionada

Adicionar a Ordenação

    $order_fornecedor_id = new TAction(array($this, 'onReload'));
    $order_fornecedor_id->setParameter('order', 'fk_fornecedor_id->nome');
    $column_fk_fornecedor_id_nome->setAction($order_fornecedor_id);

Adicionar ao onReload o $param['order'] da Ordenação

@carlosleonam
carlosleonam / adianti-framework-static-method-class-php-cli.md
Last active March 10, 2023 00:53
Adianti Framework - Execute Static Method Class in PHP-CLI

Adianti Framework - Run Static Method Class in PHP-CLI

How to run static method class from bash shell (terminal)

php -r "include('init.php');GeneralFunctions::getColumnNamesFirebird('OBJETOS','base_gdb');"

Example running

#!/usr/bin/env zsh
# -*- coding: UTF8 -*-
# Author: Guillaume Bouvier -- [email protected]
# https://research.pasteur.fr/en/member/guillaume-bouvier/
# 2017-08-25 14:59:30 (UTC+0200)
usage ()
{
echo "Usage"
@carlosleonam
carlosleonam / .php
Created January 25, 2023 15:26 — forked from fayqLs/.php
CLASSE PARA IMPORTAÇÃO DE XML NFe
<?php
class ImportacaoXmlNFe
{
protected $chave;
protected $xml;
protected $versao;
public function __construct($arquivo, $tipo = 'arquivo')
{
@carlosleonam
carlosleonam / get-ip-address-optimized.php
Created November 2, 2022 15:20 — forked from cballou/get-ip-address-optimized.php
PHP - Advanced Method to Retrieve Client IP Address
<?php
function get_ip_address() {
$ip_keys = array('HTTP_CLIENT_IP', 'HTTP_X_FORWARDED_FOR', 'HTTP_X_FORWARDED', 'HTTP_X_CLUSTER_CLIENT_IP', 'HTTP_FORWARDED_FOR', 'HTTP_FORWARDED', 'REMOTE_ADDR');
foreach ($ip_keys as $key) {
if (array_key_exists($key, $_SERVER) === true) {
foreach (explode(',', $_SERVER[$key]) as $ip) {
// trim for safety measures
$ip = trim($ip);
// attempt to validate IP
if (validate_ip($ip)) {
/**
* Returns an string clean of UTF8 characters. It will convert them to a similar ASCII character
* www.unexpectedit.com
*/
function cleanString($text) {
// 1) convert á ô => a o
$text = preg_replace("/[áàâãªä]/u","a",$text);
$text = preg_replace("/[ÁÀÂÃÄ]/u","A",$text);
$text = preg_replace("/[ÍÌÎÏ]/u","I",$text);
$text = preg_replace("/[íìîï]/u","i",$text);