code

Remove Javascript and CSS versioning from WordPress

- 1 minute read.
Remove Javascript and CSS versioning from WordPress 1

While trying to optimize my site a while back I came across some issues with Javascript and CSS versions causing caching issues, or rather not being cached. This lack of caching of the Javascript and CSS files was lowering the site score on many testing sites including WebPageTest. I searched around a bit and came …

Read More

WP-Installer Revisited

- 1 minute read.

A while back I started work on WP-Installer.com then I just stopped. No real reason why, but anyways I recently jumped back into the code again. Hope to have a very alpha version up an running in the next couple of days… though it will probably lead into a few weeks. More details will be posted as I make progress.

Adding users from a CSV file to a MySQL database

- 1 minute read.

I recently was hit with an issue where I had to import about 500 employees into a database and having each one added to multiple departments. With the use of an array, I was able to write up some pretty simple code to import a CSV file that simply contained “username, real name” into the database. Thought I would post it in case anyone ever needed to do something along these lines.

<?php
include('../config.php');
$departments = array("department1", "department2", "department3", "department4");
mysql_connect("$dbhost", "$dbuser", "$dbpass") or die(mysql_error());
mysql_select_db("$dbase") or die(mysql_error());
$handle = fopen("employees.csv", "r");
while (($data = fgetcsv($handle, 5000, ",")) !== FALSE) {
    foreach ($departments as &$value) {
        $query = "INSERT INTO employees (`id`, `name`, `realname`, `tickets`, `dept`) VALUES (NULL, '$data[0]', '$data[1]', '0', '$value')";
        $result = mysql_query($query) or die(mysql_error());
        echo $data[1] . ' successfully added to ' . $value . ' department<br>';
    }
}
unset($value);
?>