Skip to main content

Posts

Showing posts from 2022

Sort an Array by keys based on another Array

 <?php $customer [ 'address' ] = '123 fake st' ; $customer [ 'name' ] = 'Tim' ; $customer [ 'dob' ] = '12/08/1986' ; $customer [ 'dontSortMe' ] = 'this value doesnt need to be sorted' ; $properOrderedArray = array_merge ( array_flip ( array ( 'name' , 'dob' , 'address' )), $customer ); // or $properOrderedArray = array_replace ( array_flip ( array ( 'name' , 'dob' , 'address' )), $customer );

Custom Sorting Array List in PHP

 <?php $order = array("Z","Srilanka","34", "Canada", "India", "USA"); $array = array(     array('id' => 7867867, 'title' => 'USA'),     array('id' => 3452342, 'title' => 'India'),     array('id' => 1231233, 'title' => 'Srilanka'),     array('id' => 5867867, 'title' => 'Z'), ); usort($array, function ($a, $b) use ($order) {     $pos_a = array_search($a['title'], $order);     $pos_b = array_search($b['title'], $order);     return $pos_a - $pos_b; }); print_r($array); ?>

Reading Large JSON file through PHP Script

 <?php /* cat mexico.geojson | wc sed ':a;N;$!ba;s/\n/ /g' mexico.geojson  > mexico.geojson_out1 cat mexico.geojson_out1 | wc http://localhost/Utility/cord/largefile.php?filename=mexico.geojson_out1 sed -E 's/\{ "type": "FeatureCollection", "name": "mexico_administrative_osm_province_boundaries", "crs": \{ "type": "name", "properties": \{ "name": "urn:ogc:def:crs:OGC:1.3:CRS84" \} \}, "features": \[//g' ./mexico.geojson_out1  > mexico.geojson_out2 http://localhost/Utility/cord/largefile.php?filename=mexico.geojson_out2 sed -E 's/(\[|\{|\}|\])/ \1 /g' ./mexico.geojson_out2 > ./output/mexico.geojson_output http://localhost/Utility/cord/largefile.php?filename=output/mexico.geojson_output */ ini_set('max_execution_time', '500'); //300 seconds = 5 minutes ini_set('memory_limit', '1G');   //ini_set('max_execution...

Advance JS search

 <!DOCTYPE html> <html>     <head>         <title>             Choosen         </title>         <link href="chosen.min.css" rel="stylesheet" type="text/css">              <link crossorigin="anonymous" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.6.1/css/font-awesome.min.css" integrity="sha512-TECBPTD5Db97nlsJ/gGBBv9JLXg172YcGtrl/HHM4x9W++PPKEpHs61ogVd4x2omTgST1dIHoy2HeYWZzcZzHw==" referrerpolicy="no-referrer" rel="stylesheet"/>             <style type="text/css">                 .j-filters-level {     min-width: 400px;     border: 1...

Splitting Comma-Separated Values In MySQL

CREATE TABLE numbers (n INT);  INSERT INTO numbers VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9),     select id, substring_index( substring_index(email_recipients, ',', n), ',', -1 ) as email from dashboards join numbers on char_length(email_recipients) - char_length(replace(email_recipients, ',', '')) >= n - 1     Reference Site : https://www.sisense.com/blog/splitting-comma-separated-values-in-mysql/

Debounce and throttle script

  function debounce (fn, delay) { var timer = null ; return function () { var context = this , args = arguments ; clearTimeout(timer); timer = setTimeout( function () { fn.apply(context, args); }, delay); }; }   $( 'input.username' ).keypress( debounce ( function (event) { // do the Ajax request }, 250 )); function throttle (fn, threshhold, scope) { threshhold || (threshhold = 250 ); var last, deferTimer; return function () { var context = scope || this ; var now = + new Date , args = arguments ; if (last && now < last + threshhold) { // hold on to it clearTimeout(deferTimer); deferTimer = setTimeout( function () { last = now; fn.apply(context, args); }, threshhold); } else { last = now; fn.apply(context, args); } }; }     $( 'body' ).on( 'mousemove' , throttle ( function (event) { c...

React Hot Reload Issue in Ubuntu.

  React Hot Reload Issue in Ubuntu. Added this to store.js file if (module.hot) { // Enable Webpack hot module replacement for reducers module.hot.accept('../reducers', () => { const nextRootReducer = require('../reducers/index'); store.replaceReducer(nextRootReducer); }); } Commands > sysctl -a | grep inotify ( Output might be ----> user.max_inotify_watches = 524288 ) > sudo gedit /etc/sysctl.conf (append " fs.inotify.max_user_watches=524288 ") > sudo sysctl -p /etc/sysctl.conf (to apply changes)

Run zenity or any other GUI based program through cron.

 a shell script file like and following code and then add shell script in cron. Cron Entry * * * * * /var/www/html/runcron.sh Shell Script #!/bin/bash touch /var/www/html/tfile dbus_session_file=/home/suntec/.dbus/session-bus/$(cat /var/lib/dbus/machine-id)-0 if [ -e "$dbus_session_file" ]; then   . "$dbus_session_file"   export DBUS_SESSION_BUS_ADDRESS DBUS_SESSION_BUS_PID   dbus-send … fi zenity --error --text='Fill Time sheet' --display=:0.0