joseederangojr

#!/usr/bin/env bash
set -e

: ${PHP_VERSION:="8.2"}
: ${NODE_VERSION:="20"}
: ${APP_REPO:="https://github.com/laravel/laravel.git"}
: ${MYSQL_ROOT_PASSWORD:=$(openssl rand -base64 32)}
: ${MYSQL_ICSP_USER:="icspdbadmin"}
: ${MYSQL_ICSP_DATABASE:="icspdb"}
: ${MYSQL_ICSP_PASSWORD:=$(openssl rand -base64 32)}

lennardv2

Building the MAMP stack (php, apache & mysql) on Apple Silicon ARM (native)

Update! This tutorial is outdated. Nowadays brew installes m1 binaries just fine. Also use valet: https://laravel.com/docs/9.x/valet. It's 10x easier.

In this tutorial, we'll build the the nescessary packages for ARM via homebrew. After that we'll configure apache2 for using virtual hosts. The native php is ofcourse way faster, see the results of this benchmark below.

TEST NAME	SECONDS	OP/SEC

joseconti

# QTRANSLATE CLEANUP QUERIES

# create temp column to separate post content on <!--more--> tag to simplify queries
ALTER TABLE  `wp_posts`   ADD  `tmp_excerpt` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
ALTER TABLE  `wp_4_posts` ADD  `tmp_excerpt` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
ALTER TABLE  `wp_3_posts` ADD  `tmp_excerpt` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;


# split content

nr1q

# QTRANSLATE CLEANUP QUERIES

# create temp column to separate post content on <!--more--> tag to simplify queries
ALTER TABLE  `wp_posts` ADD  `tmp_excerpt` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;


# split content

## fill `tmp_exceprt` column
UPDATE wp_posts SET tmp_excerpt =

felipesr

//CONTROLLER

	public function listarPorCategoria($categoria_id, $page = 1) {  
	
		$params = array(
			'fields' => array('Empresa.*'),
			'conditions' => array(
							'Empresa.categoria_id' => $categoria_id,
							'Empresa.visivel' => 'S'
							),