Tag Archives: Mysql

How to prevent gaps/holes in a MySQL

Oct 28, 2014

Generally during the MySQL database development you create tables with a Primary Key, a very simple way to create a primary key is make it..

Read more

Clean Variables in PHP

Sep 02, 2014

It’s always important to clean/sanitize variables that are submitted via web forms to prevent against all kinds of different malicious threat. Here is a complete..

Read more

How To Change Your Joomla Administrator Password

Jul 04, 2014

Navigate to phpMyAdmin and select the database for the Joomla! site in the left-hand drop-down list box. This will show the database tables on the..

Read more

How much memory do PHP variables use?

Apr 12, 2014

There are cases when it might be quite important to know how much memory uses each variable in PHP script. The function memory_get_usage returns the..

Read more

Difference between MySql drop table, truncate table,

Apr 07, 2014

DROP command is used for deleting the table and its structure from the data base.Use this command when you don’t need that table any more…

Read more

Full-text search in MySQL

Mar 18, 2014

Normally, most of us use “SELECT * FROM table WHERE field1 LIKE ‘%$keyword%’” OR field2 LIKE ‘%$keyword%‘ ..etc” to search our table and get results…

Read more