When using alot of Ajax it is recommended to use JSON instead of XML for data. This is mainly because JSON is native to Javascript and is faster to process. As Script.aculo.us creator Thomas Fuchs puts it XML is “dog slow…don’t do it”. In this tutorial i’m going to show you a simple implementation of a PHP JSON web service.
If you want a quick and easy way to setup a PHP/MySQL development environment use XAMPP. XAMPP is a very easy Apache distribution giving you instant support for PHP, Perl and more.
XAMPP even contains an FTP server, phpMyAdmin, and a mail server. There’s no easier and better way to instantly serve your web applications.
You can download the latest version of XAMPP from the ApacheFriends website. XAMPP is reguarly updated for the latest versions of the packages used.
When writing an application that has poetential to grow it is important to use Object Relational Mapping(ORM) to access data in your database. Doctrine for PHP is an ORM which generates models for your tables, giving you access to methods to update/delete/insert/find records in your database. It also supports the relationships between objects through the table relations.
I have been trying to find a solution to generate a CSV document from MySQL using PHP. To generate the CSV from MySQL was quite simple, but getting the document to open the file in both Internet Explorer and Firefox took a bit of time. Looking at examples on the internet, they either worked in Firefox but not in Internet Explorer, or the other way around.
Here is my implementation of MySQL CSV exporting in PHP. You can simply replace the $sql variable with an SQL statement of your choice.
Recently I have been writing an XLS/CSV parser in PHP for inserting records into a database. I wanted to implement a way to upload either a XLS/CSV file and for the data to be parsed and imported. Here is my implementation.
Read the rest of this entry »
Recent Comments