This tutorial is intended for developers using MySQL (http://www.MySQL.com/) and PHP (http://www.php.net) who want to create a searchable database of some sort of textual data. It will focus on the Full-text capabilities presented by MySQL
We have a database that contains articles. We might create a table of database contents using a statement like this:
CREATE TABLE articles (body TEXT, title VARCHAR(250), id INT NOT NULL auto_increment, PRIMARY KEY(id);
The syntax for cross-table update in MySQL is somewhat different than T-SQL. Personally, the way it’s done in MySQL makes more sense.
I see a lot of people on forums and on my training courses asking about the best way (or any way) to manage dates stored in a MySQL database and used in PHP. Three options follow, but first the problem.
PHP uses unix timestamps for all its date functionality. It has methods to convert these timestamps into pretty much any text format you could want but internally it uses the timestamp format. A timestamp is simply an integer. Specifically, it’s the number of seconds that have elapsed since midnight on January 1st 1970 (greenwich mean time).
MySQL has useful extention to the GROUP BY operation: function GROUP_CONCAT:
GROUP_CONCAT(expr) – This function returns a string result with the concatenated non-NULL values from a group.
Where it can be useful?
If you are using WordPress as a CMS, then you probably want to present your content with multiple languages. Recently, I came across a WordPress blog that presents their content with three different languages, so I decided to investigate the methods and plugins to turn WordPress into a multilingual website, and share my findings with WDB’s readers.
Maintaining a multilingual website is not easy. The best way to present multilingual content to your visitors is to allow them to switch between different languages anytime. So, the plugin needs to take care of this and links different languages’ content together.
Your XML sitemap URL will be submitted to Google, Yahoo!, Bing (MSN), Ask.com.
Here is a very simple demonstration of how the select all checkbox is implemented in jQuery
Javascript supports the following programming paradigms:
By default, when you install XAMPP in your windows machine, the ‘root’ password for the MySQL is set to empty. But this is not recommended, as the MySQL database without a password will be accessible to everyone. To avoid this, a proper/secure password must be set to the user ‘root‘. To do it in XAMPP, there are two ways.
While developing a website, you may want to use multiple databases. Its very easy in Drupal 7 to use multiple databases. Here are the steps:
Hi there! Today we are going to combine Paypal with PHP to allow for the easy processing of payments on your website.
