Benji Bilheimer benjibee

benjibee / convert_excel_to_date.php

Last active October 12, 2021 15:10

Convert Excel date / time to PHP date

	<?php

	/**
	* Convert date and time from Excel into a PHP DateTime object
	*
	* Based on similar function from PHPExcel library.
	*
	* @see https://stackoverflow.com/a/11172688/401980
	* @see http://www.cpearson.com/excel/datetime.htm
	*/

benjibee / AppServiceProvider.php

Last active January 10, 2023 15:16

Use ngrok URLs in Laravel for all assets, generated URLs, etc.

	<?php

	namespace App\Providers;

	use Illuminate\Support\Facades\URL;
	use Illuminate\Support\ServiceProvider;
	use Illuminate\Support\Str;

	class AppServiceProvider extends ServiceProvider
	{

benjibee / delete_posts.sql

Created March 15, 2023 15:50

WordPress SQL Query: delete posts and post meta for posts older than N days

	DELETE p, pm
	FROM wp_posts p
	INNER
	JOIN wp_postmeta pm
	ON pm.post_id = p.ID
	WHERE p.post_type = 'page'
	AND p.post_date < (NOW() - INTERVAL 120 DAY);