Skip to content

Instantly share code, notes, and snippets.

View objecttothis's full-sized avatar

objecttothis

View GitHub Profile
@objecttothis
objecttothis / JSON
Created July 8, 2020 15:59
Links to Software Development related Resources
https://jsonlint.com/ - JSON validation
http://www.jsondiff.com/ - JSON comparison
@objecttothis
objecttothis / Flip Author's Name
Last active March 21, 2025 12:40
EXCEL Formulas
=IF(OR(H2="",ISNUMBER(FIND(",",H2))),"",TRIM(MID(H2,FIND("#",SUBSTITUTE(H2," ","#",LEN(H2)-LEN(SUBSTITUTE(H2," ",""))))+1,LEN(H2)))&", "&LEFT(H2,FIND("#",SUBSTITUTE(H2," ","#",LEN(H2)-LEN(SUBSTITUTE(H2," ",""))))-1))
@objecttothis
objecttothis / 0 OSPOS Related SQL Queries
Last active October 17, 2025 07:52
OSPOS SQL QUERIES
ob_start();
var_dump($variable_to_dump);
$results = ob_get_clean();
log_message('error',$results);
$measurement=-hrtime(true);
$memory_start = memory_get_usage(TRUE);
//Code to measure
$memory_end = memory_get_usage(TRUE);
$memory_used = ($memory_end - $memory_start)/1048576;
$average_memory = ($memory_used * 1024)/$number_of_items;
log_message('Error', "$memory_used MB of memory used. Average $average_memory KB per row");
$measurement+=hrtime(true);
$measurement = $measurement/1e+9;
$number_of_items = count($csv_rows);