Felix Penrose felixpenrose

## .gitignore
#
# If all files excluded and you will include only specific sub-directories
# the parent path must matched before.
#

/**
!/.gitignore

###############################
# Un-ignore the affected subdirectory

## split name into first and last.sql
UPDATE tbl t1,
(
	SELECT
		id,
		TRIM(SUBSTRING(name, 1, LENGTH(name) - LENGTH(SUBSTRING_INDEX(name, ' ', -1)))) AS first_name,
		SUBSTRING_INDEX(name, ' ', -1) AS last_name
	FROM reviews
	WHERE first_name IS NULL
) t2

## artisan log sql.php
DB::listen(function ($query) { dump($query->sql); dump($query->bindings); dump($query->time); echo PHP_EOL . PHP_EOL; });

## bind-unknown-num-params.php
<?php
$arr = [1,2,3];
$in  = str_repeat('?,', count($arr) - 1) . '?';
$sql = "SELECT * FROM table WHERE column IN ($in)";
$stm = $db->prepare($sql);
$stm->execute($arr);
$data = $stm->fetchAll();
	#
	# If all files excluded and you will include only specific sub-directories
	# the parent path must matched before.
	#

	/**
	!/.gitignore

	###############################
	# Un-ignore the affected subdirectory
	UPDATE tbl t1,
	(
	SELECT
	id,
	TRIM(SUBSTRING(name, 1, LENGTH(name) - LENGTH(SUBSTRING_INDEX(name, ' ', -1)))) AS first_name,
	SUBSTRING_INDEX(name, ' ', -1) AS last_name
	FROM reviews
	WHERE first_name IS NULL
	) t2
	<?php
	$arr = [1,2,3];
	$in = str_repeat('?,', count($arr) - 1) . '?';
	$sql = "SELECT * FROM table WHERE column IN ($in)";
	$stm = $db->prepare($sql);
	$stm->execute($arr);
	$data = $stm->fetchAll();