Lil Josh

A tech blog about web development with PHP, MySQL, jQuery, CSS3 and various other programming languages.

Sort HTML table using jQuery

September 14, 2013

I’ve put together a script that allows you to make any HTML table sortable by clicking on the table headings. See the example below:

Name Age
John Smith 18
Ashley Washington 26
Patrick Green 19

To use, download ljSortable.min.js and include it near the bottom of your page (after the table) and give your table an id of “ljSortable”. For example:

<table id="ljSortable">
<td>John Smith</td>
<td>Ashley Washington</td>
<td>Patrick Green</td>
<script src=""></script>
HTML jquery sort sortable sorting table

Javascript Format Phone Number Function

July 2, 2013

This is a Javascript function to format any 10 digit phone number into the following format: (555) 555-5555

* Created by
* Formats a phone number to be in (555) 555-5555 format
function phoneFormat(phone) {
phone = phone.replace(/[^0-9]/g, '');
phone = phone.replace(/(\d{3})(\d{3})(\d{4})/, "($1) $2-$3");
return phone;

Example usage:

<div id="phoneNumber">555-555-5555</div>
var phone = $("#phoneNumber").text();
phone = phoneFormat(phone);

See demo:

format function javascript jquery phone number

Introduction to PHP PDO

June 12, 2013


//replace host, database, user, password
$dbh = new PDO(";dbname=DATABASE", 'USER', 'PASSWORD'); 


$stmt = $dbh->prepare("SELECT id, name FROM table");
$result = $stmt->fetchAll();
foreach($result as $row) {
echo "$row[id]: $row[name]<br />";


$example = $_GET["example"];
$stmt = $dbh->prepare("SELECT id, name FROM table WHERE column = :value"); //value can be named whatever you'd like
$stmt->bindParam(":value", $example); //pass a variable to the named parameter
$result = $stmt->fetchAll();
foreach($result as $row) {
echo "$row[id]: $row[name]<br />";


$firstname = $_GET["firstname"];
$lastname = $_GET["lastname"];
$stmt = $dbh->prepare("INSERT INTO `users` (`firstName`, `lastName`) VALUES (:firstname, :lastname)"); 
$stmt->bindParam(":firstname", $firstname);
$stmt->bindParam(":lastname", $lastname);


$date = date("Y-m-d H:i:s");
$id = $_GET["id"];
$stmt = $dbh->prepare('UPDATE `users` SET `lastLogin` = :lastLogin WHERE `id` = :id');
$stmt->bindParam(":lastLogin", $date);
$stmt->bindParam(":id", $id);
cheatsheet code samples mysql PDO PHP queries quickstart Security

Setting up Subversion on Dreamweaver

December 24, 2012

This tutorial shows you how to setup Subversion on Dreamweaver using Google Code. I’m using CS6, but it likely applies to earlier versions.

  1. Create an account on Google Code:
  2. Create a new project:
    Create Project
  3. Click “Source” and you should see something similar to:
    Login Info
    You’ll need the following information.
    Server address: (replace with yours)
    Repository Path: /svn/trunk
    Username: (replace with yours)
    Password: You can find your password by clicking password.
  4. Open your site in Dreamweaver. From the dropdown click Site -> Manage Sites and double click your site to open it.
  5. Click the Version Control tab from the left.
  6. Enter your Google code information from step 3. For example:
    Dreamweaver Settings
  7. Click Test and then Save if everything worked.
  8. I’d recommend watching this video to get a quick overview of the Dreamweaver’s Subversion features: (skip to 1:40)

I spent a lot of time trying to figure out how to setup a subversion server, and found that Google Code was the easiest solution. If you have any feedback or questions feel free to leave a comment. Thank you and enjoy!

CS6 dreamweaver google code subversion svn