The JOIN keyword is used in an SQL statement to query data from two or more tables, based on a relationship between certain columns in these tables. [@via w3schools] A SQL JOIN clause combines records from two or more tables in a database. It creates a set that can be saved as a table or … Read more
Suppose, you have a product collection and you want to filter it by category. Suppose, you want to filter it by more than one category. You can use addCategoryFilter if you have only one category. But, what if you want to filter by more than one category? Category ids are stored for product in a … Read more
In this article, I will be presenting simple PHP & MySQL code to add, edit, delete and view data. This kind of system is also referred to CRUD (Create, Read, Update, Delete). Here is a step-by-step guide on creating a CRUD system using PHP & MySQL: First of all, we will create a new MySQL … Read more
In another article, I have written about Very Simple Add, Edit, Delete, View in PHP & MySQL. That article contains a basic CRUD (Create, Read, Update, Delete) system. It doesn’t have the feature of login and register. In this article, I will be presenting a complete CRUD system containing login and register feature. User should … Read more
This article shows how to backup/export and restore/import single & multiple databases and tables in MySQL. Backup/Export 1) Backup/Export single database mysqldump -h hostname -u username -p database_name > /path/backup.sql 2) Backup/Export multiple databases mysqldump -h hostname -u username -p –databases db1 db2 db3 > /path/threedb.sql Here: db1, db2, db3 are three different database name. … Read more
Problem: can’t create pid file: no such file or directory I had this problem and had a very tough and frustrating time with it. While I was installing a fresh copy of MySQL 5 in Windows XP, I got this problem. (I was installing it from the installer i.e. setup file.) The server was not … Read more