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
Category: PHP
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
Split text into multiple columns in PHP
I made a Swedish shopping directory using affiliate links for a site and wanted to split it into two columns. I wrote the following php function that can be used to split a string in two or more pieces. One parameter is at what character or string you want to split. For example if you… Continue reading Split text into multiple columns in PHP
Install cURL PHP Extension on Windows IIS
I tried to run a new PHP script that someone else wrote for me on my Windows Server 2008 and got some errors relating to cURL such as this: Fatal error: Call to undefined function curl_multi_init() First I spent a lot of time trying to find information on how to install cURL on a Windows… Continue reading Install cURL PHP Extension on Windows IIS
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
PHP 5 with IIS 7 on Windows Server 2008 Tutorial
A few years back I wrote a simple tutorial on how to install and configure PHP5 with IIS6 on Windows Server 2003 in five easy steps. Back then things were not as straight forward as they turned out to be when I tried it again today on a different server setup. The following worked like… Continue reading PHP 5 with IIS 7 on Windows Server 2008 Tutorial
PHP5 with IIS6 on Windows Server 2003 in five easy steps
[Update: Follow this link if you are looking for an updated tutorial on PHP5 with IIS7 on Windows Server 2008] How to install and configure PHP5 with IIS6 on Windows Server 2003 in five easy steps. I thought installing PHP would be as easy as just using the install program. Well it wasn’t… But by… Continue reading PHP5 with IIS6 on Windows Server 2003 in five easy steps