Set separator delimiter in CSV file to open correctly in Excel

Problem I made a PHP script to export a SQL query (from MySql) to a CSV file for opening in Excel. I cannot control how different users have their Excel setup, ie what separator delimiter they have set (this differs with language settings or user may have changed setting) So the field separator delimiter gave me some problems,… Continue reading Set separator delimiter in CSV file to open correctly in Excel

Solution: Bootstrap glyphicons-halflings-regular.woff 404 not found

I’m testing out Bootstrap 3.1.1 by redoing the design of a very old site of mine, running on Php 5.3 on a Windows 2008/IIS 7 server. The new version of the site has been slow at loading the icons (wich are a Glyphicons web font) for buttons and when I check the Javascript console in Chrome… Continue reading Solution: Bootstrap glyphicons-halflings-regular.woff 404 not found

PHP 5.3.1 upgrade on IIS7 and MySQL gives Internal Server Error

Solution After a lot of googling and testing I finally found Bruce Kirkpatrick’s comment at the end of the PHP install manual Seems it is no longer enough to have localhost in the servers local hosts file (C:\Windows\System32\drivers\etc\hosts) you also have to comment out or remove the IPv6 equivalent. 127.0.0.1 localhost #::1 localhost After I… Continue reading PHP 5.3.1 upgrade on IIS7 and MySQL gives Internal Server Error