Posts tagged ‘MySQL’

Zend Framework and Doctrine. Part 2

November 18th, 2009

Today we start actual development with Doctrine and Zend Framework. Base of this post is my code which I have been using for quite a few projects and it worked really well.
These are the steps required to setup Doctrine:

Create MySQL (or any other adapter supported by Doctrine) database
Download Doctrine 1.2 (as of today – 1.2.0beta3). [...]

Comments (10) | TrackBack URI

Zend Framework and Microsoft IIS

May 5th, 2009

My task today was to make Rob Allen’s Zend framework tutorial project run on Windows. Some years ago such task could have been a problem, but as you will see, now it’s nothing special.
To start with, Windows sometimes really annoys. For example, by default I can’t add files to C:\inetpub\wwwroot. It doesn’t ask for “Allow/Cancel?“, [...]

Comments (2) | TrackBack URI

Setting up Windows for PHP server

April 21st, 2009

To start with, all work took about 1:30, including Skype distractions, reading how-to’s, etc. Only one problem I had is that I was given remote desktop connection access to Windows Server 2008 machine, but I’m working with Linux. How to connect to remote desktop from Linux?
Luckily, I had Windows XP in VirtualBox so I tried [...]

Comments (2) | TrackBack URI

Starting with Zend_Search_Lucene

March 11th, 2009

As websites grows, searches like “LIKE title ‘%search term%’” becomes unreliable. There are very good solutions like Sphinx, Lucene, etc, but not surprisingly, you can’t always have Sphinx installed (shared servers again) and other solutions should be chosen.
MySQL supports full-text indexing, but it doesn’t give a lot of control over actual index. Luckily, Zend [...]

Comments (9) | TrackBack URI

Zend Server – complete PHP environment in minutes

February 19th, 2009

I believe that everyone who develops in PHP knows Zend (I know them from certification which I’ve done some time ago), especially now, when Zend Framework is more and more popular. Zend also makes (and probably specializes) software for web servers – Zend Guard, Zend Optimizer, etc. Recently Zend introduced new product – Zend Server. [...]

Comments (7) | TrackBack URI

Solving Sudoku puzzle with only MySQL

February 11th, 2009

More than a year ago I’ve read very interesting article in Lamneth blog about MySQL Sudoku solver. I’ve searched for some time, but information was very minimal and I couldn’t find a way to contact original author. So I decided to try it myself and easily found working solution.
Beauty of solving Sudoku puzzle in MySQL [...]

Comments (8) | TrackBack URI