User:Krams036/PHP Cheatsheet

From Wikivoyage
Jump to navigation Jump to search

Essential SublimeText Packages

[edit]
  • Package Control
  • Color Hints
  • Emmet
  • EmmetCSS
  • Color Picker
  • Color Convert

Excel to PHP Time

[edit]
$str_date = time();
$toExcel = intval(25569 + $str_date / 86400);    //Convert PHP time to Excel time
$frExcel = intval(($toExcel - 25569)*86400 );    //Convert Excel time to PHP time

Count/Sum all in PHP

[edit]
$rows = $result->query("SELECT COUNT(*) as count FROM USERIDS");
$row = $rows->fetchArray();
$numRows = $row['count'];

Detect Browser

[edit]

https://stackoverflow.com/questions/2257597/reliable-user-browser-detection-with-php