Monday, November 24, 2014
Text Size

PHP: First name and Initial of Surname

A note for myself on some code to convert a string of two names into a string made up of the first name and then using the initial of the second name.

  1.  -- What I have 
  2.  John Smith 
  3.  Fred.Bloggs 
  5.  -- What I want 
  6.  John S. 
  7.  Fred B. 


Anti-SQL Injection Function - Not a silver bullet

So, seriously, this is not going to stop all the attacks out there; it is simply a base function to build upon. This is a PHP function I got off the PHP forums years ago, and can't find it anymore, so I'm posting it here... And now people can see how I safeguard my sites but obscurity should never be a recommended security measure.

This function will check a posted string for suspicious activity and email the specified system administrator. You should modify it to suit your sites needs (eg. if you need to accept url encoded values). It needs some work I know but it's a start. I'd advise using PHP sessions though as well (see after).

Preg_Replace all strings between two tags

For those of you who use Preg_Replace. Preg_replace is a function that uses regular expressions to search and replace a string.

Because my understanding with regular expressions is shady and varies from language to language, I've written this article as a quick reference point.


Php convert filesizes to bytes kb mb gb

Just a quick note on how to format a given filesize and to reduce the display output to a small string, eg:

  1.  196 bytes          : displays as => "196 bytes" 
  2.     12945 bytes        : displays as => "12 Kb" 
  3.     1478515 bytes      : displays as => "1 Mb" 
  4.     8798745455 bytes   : displays as => "8 Gb" 

Convert seconds to total time in PHP

This is intended for activity/session durations and although I usually get MySQL to do the date/time calculations, there are times when we have to do with PHP. This is the shortest way I know to properly convert seconds into total hours, minutes and seconds (taking into account regional settings and without using a date function).


  1.  $total_time =intval(intval($total_seconds)/ 3600).":"; 
  2.  $total_time.=str_pad(intval(($total_seconds/60)%60),2,"0",STR_PAD_LEFT).":"; 
  3.  $total_time.=str_pad(intval($total_seconds%60),2,"0",STR_PAD_LEFT); 
  5.  // yields 
  6.  // 82800  = 23:00:00 
  7.  // 108000 = 30:00:00 
On one line:

  1.  $total_time=intval(intval($total_seconds)/ 3600).":".str_pad(intval(($total_seconds/60)%60),2,"0",STR_PAD_LEFT).":".str_pad(intval($total_seconds%60),2,"0",STR_PAD_LEFT); 

Latest Posts

  • Convert to Proper Case in T-SQL

    • Tue 11-Nov-14
      Hi Brandon, An excellent point as I completely forgot about that one. I guess in the UK we don't get ...
      Joel L.  
    • Thu 06-Nov-14
      Thank you for this! One of the cases I'm going to try to adapt it for is addresses. In the US, we ...
      Brandon C.
  • SSIS: How to loop through multiple flat files as data sources

    • Thu 13-Nov-14
      Hey Mario, Looks like for each loop you set up at #5 will take care of that, doesn't matter if you ...
      Ramsey K.  
    • Sat 01-Nov-14
      Hi, thanks, bit not clear on #6, I still have file name from step #1
  • Windows 7: System Clock is constantly going out of sync

    • Sat 01-Nov-14
      Thank you..that solved my issue. Just wondering whether preventing my computer from synchronizing ...
      Ravi G.