Skip to content

Instantly share code, notes, and snippets.

@tuckbloor
tuckbloor / gist:77921236b0118a1c5c02f442cdd792d5
Created August 3, 2017 07:40
mysql get rows from by week
select *,
str_to_date(concat(yearweek(created_at), ' friday'), '%X%V %W') as end_of_week_date
from install_completed
order by end_of_week_date
//preload images for canvas on tag design
function preloadImages(srcs) {
if (!preloadImages.cache) {
preloadImages.cache = [];
}
var img;
for (var i = 0; i < srcs.length; i++) {
img = new Image();
img.src = srcs[i];
preloadImages.cache.push(img);
@tuckbloor
tuckbloor / pdf.php
Created November 28, 2016 14:32
muhimbi
<?php
namespace App\Http\Repositories;
ini_set('max_execution_time', 0);
use App\Http\Interfaces\GenerateInterface;
use App\Muhimbi\PdfConverterService;
use PHPExcel_IOFactory;
@tuckbloor
tuckbloor / gist:5211320087a0ca387fded41f5ff75df8
Created November 28, 2016 13:06
display data while in a loop
echo 'data goes here';
ob_flush();
flush();
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="filename.xls"');
header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($excel_obj, 'Excel2007');
$objWriter->save('php://output');
@tuckbloor
tuckbloor / footer_logo.ocmod.xml
Created November 23, 2016 20:21
add logo to footer in opencart v2.3
@tuckbloor
tuckbloor / gist:40aa7542bceb915494355ac70c71e9e0
Created November 7, 2016 13:49
trace where php function was called
$trace = debug_backtrace(DEBUG_BACKTRACE_IGNORE_ARGS, 1);
dd($trace);
@tuckbloor
tuckbloor / gist:a21fdbec4f303cf01709d61ab46d9058
Created October 26, 2016 20:27
copy a directory into the root copies files from a directory called "mobile" into the root
<?php
function recursive_copy($src,$dst) {
$dir = opendir($src);
@mkdir($dst);
while(false !== ( $file = readdir($dir)) ) {
if (( $file != '.' ) && ( $file != '..' )) {
if ( is_dir($src . '/' . $file) ) {
recursive_copy($src . '/' . $file,$dst . '/' . $file);
}
else {
@tuckbloor
tuckbloor / index.html
Created October 26, 2016 20:13
Datatables working inside jquery ui tabs
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8" />
<title>Datatables</title>
<script type="text/javascript" src="http://www.codecaven.co.uk/js/jquery.js"></script>
<script type="text/javascript" src="http://www.codecaven.co.uk/js/jquery.snippet.min.js"></script>
<style type="text/css" title="currentStyle">
@import "http://www.codecaven.co.uk/media/css/demo_page.css";
@import "http://www.codecaven.co.uk/media/css/demo_table.css";
@tuckbloor
tuckbloor / index.html
Created October 26, 2016 20:10
Google maps enter your postcode and it will give you directions to a preset postcode
<!DOCTYPE html>
<html>
<head>
<meta name="viewport" content="initial-scale=1.0, user-scalable=no"/>
<meta http-equiv="content-type" content="text/html; charset=UTF-8"/>
<title>Google Maps Postcode To Destination Working Example</title>
<script src="http://code.jquery.com/jquery-latest.js"></script>
<link href="http://code.google.com/apis/maps/documentation/javascript/examples/standard.css" rel="stylesheet" type="text/css" />
<script type="text/javascript" src="http://maps.google.com/maps/api/js?sensor=false"></script>
<script type="text/javascript">