Posts under Open Source

MySQL: Full text search for multiple words

advertisement

mysqlI notice one of my MySQL full text search result for multiple words doesnt seems correct. After some checking, i realize i don’t know how to do full text search for multiple words! LOL. This is because i use ONLY single words during testing. After go thru the MySQL documentation again, now i get a clear view of how to structure the SQL statement for full text search (multiple words)!

Here are some example for MySQL full text search for multiple words:-

Continue reading MySQL: Full text search for multiple words »

Symfony Filter: Change ForeignKey drop down to Text field

advertisement

symfonyI 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 »

Common MySQL database maintenance command

advertisement

mysql, mysql databaseThis post is a note for me to remember the common MySQL maintenance command. These MySQL maintenance command (check table, repair table, analyze table and optimize table) is very useful to ensure the MySQL database run smoothly and error free. Understanding these MySQL maintenance command will allow you to perform the right operation at the right time.

Here are the MySQL maintenance command simple brief:-

Continue reading Common MySQL database maintenance command »