PhpMyAdmin Invalid Column Count in CSV input on line 1

If you are receiving this error while tryng to import a CSV file, make sure that the number of columns in your CSV matches that of your existing database table.I had an existing table with 10 columns, the first column was `id` an auto-increment field. I omitted this from my CSV file presuming it would be auto geberated but it's not.number of c...
Rate this blog entry:
Continue reading
9 Hits
0 Comments

Google In-Page Analytics Not Working

I find this Chrome plugin very useful. However recently it stopped working, the solution (always works for me) appears to be;​open Chromemanage extensionsdisable In-Page Analyticsre-enable In-Page Analyticsreload page (Ctrl+F5)Hope this helps!
Rate this blog entry:
Continue reading
39 Hits
0 Comments

Tsohost UK Web Host Review & Promo Discount Code

I recently moved hosts from SiteGround to Tsohost, mainly because my SiteGround renewal was coming in at far too much money for what I was receiving in my opinion. My first year was approximately £90, whereas my second year was approximately double this at £180 - for no extra services. I began my hunt for an alternative provider... enter ...
Rate this blog entry:
Continue reading
43 Hits
0 Comments

PHP 7.1 with Win 10, XAMPP & SQLSRV Driver

​If you're trying to use XAMPP on Windows and connect to a SQL server using PHP, hopefully the following will help.Firstly download XAMPP for Windows (32 bit). Follower the installer, default options.Then download the Microsoft Drivers 4.3 for PHP for SQL Server.  Extract the contents of this download to your PHP extensions directory...
Rate this blog entry:
Continue reading
2409 Hits
0 Comments

Ubuntu 14 Install and Configure SSH

Ensure the OS is up to date.Install OpenSSH server on the OS.It's also a good idea to make a copy of the default SSH configuration, so that if you ever mess up your SSH settings you can revert to the original.That's all you need in order to get SSH working. You should now be able to use a program like Putty in order to connect to the remote OS...
Rate this blog entry:
Continue reading
461 Hits
0 Comments

Server Side Events with MySQL and PHP

​I wanted to build an application that would display a 'real time' feed of data on my web page.I had access to a MySQL database that contained a 'transactions' table, this table received numerous events every second. I needed to display the transactions in real time (or close enough). Not only did I need to display the live data, but I also wa...
Rate this blog entry:
Continue reading
587 Hits
0 Comments