Skip to content

Instantly share code, notes, and snippets.

View CoreText's full-sized avatar

Text_r CoreText

18 followers · 67 following
View GitHub Profile
@CoreText
CoreText / gist:c155e3c665d3622c4592c81d22622572
Created November 26, 2021 03:17 — forked from ozh/gist:8812721
Adding ping() function to PDO
<?php
// http://terenceyim.wordpress.com/2009/01/09/adding-ping-function-to-pdo/
class NPDO {
private $pdo;
private $params;
public function __construct() {
$this->params = func_get_args();
@CoreText
CoreText / gist:558b5daaa9ff75308168cf7e6da4fb51
Created November 26, 2021 03:16 — forked from ozh/gist:8780018
"The last PHP PDO library you will ever need"
<?php
class db extends PDO {
public function fetch_all( $query, $parameters=array() ) {
$read_stmt = $this->prepare_and_execute($query, $parameters);
$fetched_rows = $read_stmt->fetchAll(PDO::FETCH_CLASS);
$read_stmt->closeCursor();
@CoreText
CoreText / gist:f7416acbf090b06d8719af7b912517b8
Created November 26, 2021 03:15 — forked from ozh/gist:8470714
header connection close
<?php
ob_end_clean();
header("Connection: close");
ignore_user_abort(); // optional
ob_start();
echo ('Text the user will see');
$size = ob_get_length();
header("Content-Length: $size");
ob_end_flush(); // Strange behaviour, will not work
flush(); // Unless both are called !
@CoreText
CoreText / gist:cb9c687c7973cf67cbf294a16439ffb4
Created November 26, 2021 03:13 — forked from ozh/gist:8469863
mysqldump remote server
mysqldump --opt --compress --user=USERNAME --password=PASSWORD --host=SOURCE.HOST.HERE SOURCE_DB_NAME | mysql --user=USERNAME --password=PASSWORD --host=TARGET.HOST.HERE -D TARGET_DB_NAME -C TARGET_DB_NAME
@CoreText
CoreText / gist:578f00721b147828efc78c74d7588bb1
Created November 26, 2021 03:13 — forked from ozh/gist:8206890
Javascript check for a CSS feature support
function browserSupportsCSSProperty(propertyName) {
var elm = document.createElement('div');
propertyName = propertyName.toLowerCase();
if (elm.style[propertyName] != undefined)
return true;
var propertyNameCapital = propertyName.charAt(0).toUpperCase() + propertyName.substr(1),
domPrefixes = 'Webkit Moz ms O'.split(' ');
@CoreText
CoreText / gist:48fd2b035cf3fee68627e0db0fd11f16
Created November 26, 2021 03:11 — forked from ozh/gist:8169202
Human readable time difference between 2 dates in PHP
<?php
/**
* Get human readable time difference between 2 dates
*
* Return difference between 2 dates in year, month, hour, minute or second
* The $precision caps the number of time units used: for instance if
* $time1 - $time2 = 3 days, 4 hours, 12 minutes, 5 seconds
* - with precision = 1 : 3 days
* - with precision = 2 : 3 days, 4 hours
@CoreText
CoreText / gist:bf6ff4e5025a30de795173945b1f39a2
Created November 26, 2021 03:03 — forked from ozh/gist:8111644
time constants in seconds
// Constants for expressing human-readable intervals
// in their respective number of seconds.
define( 'MINUTE_IN_SECONDS', 60 );
define( 'HOUR_IN_SECONDS', 60 * MINUTE_IN_SECONDS );
define( 'DAY_IN_SECONDS', 24 * HOUR_IN_SECONDS );
define( 'WEEK_IN_SECONDS', 7 * DAY_IN_SECONDS );
define( 'YEAR_IN_SECONDS', 365 * DAY_IN_SECONDS );
@CoreText
CoreText / gist:b1aaba5c6def1be801c60a5f642ca99b
Created November 26, 2021 03:01 — forked from ozh/gist:6448067
CSS3 animations cheat sheet
/* Demo: http://www.justinaguilar.com/animations/index.html */
/*
==============================================
CSS3 ANIMATION CHEAT SHEET
==============================================
Made by Justin Aguilar
www.justinaguilar.com/animations/
@CoreText
CoreText / stats.md
Created November 26, 2021 02:32 — forked from ozh/stats.md
Most requested URLs

Most requested URLs: cat access.log | grep "GET " | cut -d\ -f7 | sort | uniq -|sort -n | tail -n50

@CoreText
CoreText / get_favicon.md
Created November 26, 2021 02:32 — forked from ozh/get_favicon.md
Most standard ways to get a favicon from a page

Most standard ways to get a favicon from a page, in preferred order

In file:

  • <link href="http://someserver/favicon.ico" rel="shortcut icon" />
  • <link href="http://someserver/favicon.ico" rel="shortcut" />
  • <link href="http://someserver/favicon.ico" rel="icon" />
  • <link href="http://someserver/favicon.png" rel="apple-touch-icon" />
  • <link href="http://someserver/favicon.png" rel="apple-touch-icon-precomposed" />
  • <link href="http://someserver/favicon.ico" rel="image_src" />