I tried to change the foreignkey drop down to text field in the symfony filter form. But after i change the drop down field to text field, my field name changed to xxx_filter['foreign_id']['text'] instead of xxx_filter['foreign_id']. And everytime i submit the form it show “SQLSTATE[HY093]: Invalid parameter number: parameter was not defined”.
After few hours of googling, i manage to find the solution for this filter form problem. To solve the problem follow the steps below:- Continue reading Symfony Filter: Change ForeignKey drop down to Text field »

I just setup a MySQL replication at 2 virtual machine. However today i found the replication stop at the slave machine with last_errno 1062. With the error message:-
This is a note for me to remember how to validate drop down list in Javascript. Although i have done this sooo many times but i still forget how to validate drop down list in javascript :p So hopefully with the help of this post, i’ll be able to refer if i forget again.

