Computing: page 12
Recently I produced a website for hosting on a Linux box running with PHP5 and MySQL5. Well it now needs to move over to a Windows 2003 server with MS SQL as the DB and IIS as opposed to Apache. Install MyODBC Install SQL Server 2005 Express Using MS SQL Server Management create a new database. (right click on databases in the Object Explorer) Use the following SQL Server SQL to create a link to your MySQL DB: Read more ⇒
Here is a small script that I put together to grab the XML list from the ISO website and convert it into an SQL statement. The idea is that the script can be used to just obtain a list for web projects or it can be setup to run periodically to make sure that a list is always kept up to date. Obviously none of the associated checks to make that work have been written into this code so you will need to add it yourself (ie. Read more ⇒
Geographic Calculations in PHP
warning This library is now deprecated in favour of my new Navigator library. Please use it instead - its much better, tested and makes use of newer PHP features! Recently I have been involved with a project that maps yachts during an ocean race, which got me thinking about basic calculations and conversions that would be useful to fellow developers. I envisage this being useful in projects leveraging Google or Yahoo maps. Read more ⇒
I recently had a server go offline, taking with it the DNS for my main email domain. I had long suspected this would be a major potential problem in the setup. When the server went down the DNS settings where not backed up by the hosting company so all of a sudden people emailing me started to encounter bounce backs and I could not work out why. Then it dawned on me that when the server died something must have gone missing. Read more ⇒
I have been looking through my hosts logs of late and I have noticed an ever increasing amount of referrer spam. Now whilst this is of no real concern to me as I do not use referrer logs or display them anywhere it is however really quite annoying to see this type of thing in your logs. Apparently its not a new scam even though I have only started see it from the beginning of this year. Read more ⇒
I have updated the sites backend code. Thought I would change the looks at the same time. So a nice simple new layout. Enjoy. Read more ⇒
Form SPAM (not "HAM") fighting tips
A site that I have up called Alfa Romeo Sprint QV has recently been the target of malicious spammers and/or their robots. The messages mainly consisted of porn and poker sites. Now the script used to generate the Your Sprints section of the site was written a long time ago when spamming forms and blogs was not a common occurrence and my site had a relative small readership and no Google rank or anything like that. Read more ⇒
I have been asked numerous times in the past how I create this effect in some forum signatures so now I am releasing the code so you can see. It could equally be used as a background image in CSS (like the photo of the excavator above) so you could have a circulating series of background or in this case header images. I am sure you can think of many other neat uses for this script. Read more ⇒
Well I would like to say it went smoothly, but… At least its all transferred over and backed up now. This new server should be faster as well as more reliable than the old one. I even managed to get something up on FullOctane.com Read more ⇒
I have been setting up a mail server of which smtp is an integral part. I could access it through my old net connection at home and I can through work but I am currently staying somewhere with Optus Cable. They block port 25! I called their tech support to confirm, he did say it was possible to have to port re-opened for this individual connection. But I am not the account holder. Read more ⇒