24 August, 2009 (14:04) | PHP, Web Development, tech | By: Pablo Viquez
Last week, I had to allow the user to export a given report into an MS Excel file format.
The application uses Zend Framework 1.9.1 and so far ZF does not support for “Office” formats, so after searching for a nice implementation, I found a PEAR module called Spreadsheet Excel Writter, which looked pretty good, it [...]
Tags: Excel Spreadsheets, pear, PHP, Zend Framework
Comments: 11
31 July, 2009 (12:04) | PHP, Web Development, iso 8859-1, utf-8 | By: Pablo Viquez
To continue with the previous post.
Problem: Function json_encode does not support ISO-8859-1 encoded data.
One solution that I did, in order to preserve the character set was to encode the
data before using the json_encode function to use just A-Z, a-z and 0-9 characters,
instead of sending text with accents or symbols.
One encoding that fits perfectly in this [...]
Tags: ajax, i18n, iso 8859-1, jquery, json, json_encode, PHP, utf-8
Comments: 6
17 July, 2009 (13:51) | PHP, Web Development, debug, iso 8859-1, utf-8 | By: Pablo Viquez
Download the demo files
While I was looking at some AJAX calls, I started to have a problem, for some reason, when I tried to query a JSON service I did using JQuery, the result was null for some fields.
Going a little deeper, I notice that the records from the DB were OK, and the JavaScript [...]
Tags: ajax, i18n, iso 8859-1, jquery, json, json_encode, PHP, utf-8
Comments: 1
14 June, 2009 (19:22) | PHP, Web Development, debug, errors | By: Pablo Viquez
After a while struggling with the php function set_include_path() on windows, became to my attention that using the windows registry to set php configuration values they are set using the php_admin_value which forbids overriding it on run time.
So for example, if you set the include_path on the windows registry and then you call the set_include_path [...]
Tags: debug, PHP, set_include_path, windows registry
Comments: -
13 June, 2009 (02:09) | PHP, Web Development, debug, training | By: Pablo Viquez
Este tutorial enseña como ejecutar un script PHP paso a paso haciendo su depuración más sencilla y fácil. Tambien muestra paso a paso como instalar Eclipse PDT y configurarlo para usar XDebug.
Este mismo tutorial esta disponible para descargar, haga click aquí
Que necesita:
Eclipse PDT
http://www.eclipse.org/pdt/downloads/
Extensión de XDebug
http://xdebug.org/files/php_xdebug-2.0.4-5.2.8.dll
Para este tutorial, se asume lo siguiente:
Ya tiene instalado Apache y [...]
Tags: debug, eclipse, ejecutar paso a paso, xdebug
Comments: 4
29 September, 2008 (18:08) | PHP, Web Development | By: Pablo Viquez
So I gave my presentation on PHp ARchive files, at the Schematic Tech Summit.
For those who don’t know, Phar is a way to pack multiple files into one single file. It’s awsome!
I made available the slides here
PHAR Slides
Technorati Tags: phar,php,schematiccon08,zip,tar,schematic
Tags: phar, php5
Comments: 1
9 September, 2008 (20:03) | PHP, Web Development | By: Pablo Viquez
En mis ratos libres he estado investigando los archivos Phar, los cuales son una manera de contener una aplicación entera en un solo archivo, parecidos a los JAR de Java.
Aunque no tengo mi proyecto todavia terminado, voy a publicar las notas de la investigación, por si alguien esta teniendo los mismos problemas/dudas.
Cual versión de PHP?
La [...]
Tags: phar, php5
Comments: -
4 September, 2008 (17:01) | PHP, Web Development | By: Pablo Viquez
Hace unos dias tuve un problema tratando de desplegar tildes en una aplicación, el problema surgió cuando quise hacer que toda la aplicación fuera UTF-8.
Es decir, que la DB hablara UTF-8 y las paginas desplegaran UTF-8:
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=UTF-8">
Ahora, cuando hice el despliegue en la página, en vez de ver caracteres con tildes [...]
Tags: i18n, iso 8859-1, l10n, PHP, utf-8
Comments: 8