All posts in MySQL

Create your own fulltext searchengine with PHP and MySQL

By | March 20, 2010 | MySQL, PHP | 6 Comments

Do you want to search the text stored in your MySQL database, but hasn’t figured out how to do it efficiently? Then a  full-text search engine is the perfect solution for you. From version 4.0 MySQL has been supporting full-text search, which makes it very easy to build a good performing, robust and very accurate search engine.

In this post you’ll learn how to build a basic full-text search engine using PHP and MySQL.
Read more…

Adding special characters to MySQL

By | March 9, 2010 | MySQL, PHP | No comments

When you’re adding data to MySQL, you might experience that MySQL sometimes gives a SQL error in a code that normally works fine.

Typically this is caused by special characters like ‘ ” % in the new data, that conflicts with the SQL used to insert the data into the database. This post gives you some useful tips for handling this situation.

Read more…

Page 2 of 212