I really thought it was hard to implement the IN clause in Zend Db Select, but after a few research, it was very easy just like the other clause in […]
Category: Database
MySQLDump In Many Many Ways
Again, there is another need to blog this thing. I encountered this situations where dumping the database using default options does not fit the purpose, so today, we will be […]
Importing Huge CSV File to MySQL via PHP
Yes there are several techniques to import CSV to MySQL. I have encountered this task several times already the those previous experiences worked out seamlessly, but this one is a […]
From SQL Script to Zend Db Query
Yesterday, I have debugged an AJAX request that gets a value from the database. It was actually me who developed that module and all calculations and SQL query are based […]
PHP MSSQL varchar / nvarchar Limitation
PHP and MSSQL database API has some major issues. One of them is the very outdated PHP MSSQL driver. Because of this, one of the problem with MSSQL integration into […]