Archive for mysql
4Gamers.be Launched
October 29th, 2010 • 1 comment codeigniter, memcache, memcached, mysql, php, portfolio, squid, varnish
After months of intense labor, togheter with PHP Developer Jens and Designer Michiel, I am pleased to announce that the new website 4gamers.be has reached the stadium of public beta. To make the whole website work, we used PHP, CodeIgniter, MySQL (MyIsam and InnoDB), Varnish and Memcache.
4Gamers is een nieuw belgisch gaming portaal dat nu een groot aantal van de (ex) 9-lives redactie bevat. Op de website vind je reviews, previews, specials, trailers, screenshot en de nieuwste releases. Buiten game nieuws richt 4Gamers zich ook voor een deel op esports en hardware. Zeker een website om eens te bezoeken!
Technical Aspects
CodeIgniter
It was the first time for me to do such a large scale project in CodeIgniter and I have to say CodeIgniter did dissapoint me on several points. The more I used CodeIgniter, the more I noticed that it was lacking basic features (or perhaps I suck at using Google?). First thing I can think of was the session class… I prefer to store my sessions in memcacge, but CI only has two choices (flat file or database). Sure, you could extend the class and rewrite it. But I am not using a framework to do all this AGAIN.
Varnish
Varnish is always a breeze to use. Clear config files and it is slightly faster compared to Squid. The only issue encountered was while using Invision Power Board behind the proxy. It would not properly recognize whether or not a user is logged in (we base our caching on a certain cookie name & value combination). This results in no proxy caching being enabled on the forum… This is quite dissapointing as it can quickly become the backbone of all conversations on 4gamers. Sure enough I’ll find a solution…
mysqli for WordPress 2.9.1
January 7th, 2010 • 3 comments freebies, mysql, patch, wordpress
WordPress does not officialy support the mysqli drivers. I needed my WordPress installation to use the mysqli class instead of the mysql ones. I’m sure there will be someone else out there with the same needs I decided to place the modified database class and the patch file online. Use whichever you prefer.
xampp mysqli crashes apache
November 18th, 2009 • apache, mysql, php, windows, xampp
Is your XAMPP installation crashing apache when using the mysqli PHP functions on windows? The apache logs are not telling anything even when you have debug mode enabled? Are you getting something like “Faulting application apache.exe, version 2.2.11.0, faulting module ntdll.dll” or “Faulting application apache.exe, version 2.2.11.0, faulting module MSVCR71.dll.” ?
Really? Sure? Well here’s your solution…
Download the most recent version of php_mysqli.dll and place it in <yourxampdir>\php\ext directory.You might want to take a backup of the file you’re replacing in case it doesn’t work…
You can download the php_mysqli.dll righ here or you’ll have to find a recent version for your PHP version yourself.