Pablo Viquez Blog

Mi vida y cosas relacionadas

Skip to: Content | Sidebar | Footer

Category: Web Development

Export Excel Spreadsheets using Zend Framework

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 [...]

How to use json_encode with ISO-8859-1 data – Part2

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 [...]

How to use json_encode with ISO-8859-1 data – Part1

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 [...]

php set_include_path() function returns false

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 [...]

Como instalar Eclipse PDT y XDebug en Windows

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 [...]

Phar Files

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

Cual version para PHAR? PHP 5.2 o PHP 5.3

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 [...]

Encoding, UTF-8, ISO 8859-1 y PHP

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 [...]