Some definitions of foreign key:- A FOREIGN KEY in one table points to a PRIMARY KEY in another table. A foreign key is a field in a relational table that matches the primary key of another table. The foreign key can be used to cross-reference tables. A table may have multiple foreign keys, and each [...]

In my previous article (Magento: Very Useful Collection Functions), I had written about database interaction functions present in class Varien_Data_Collection_Db. Here, I am going to explain some database interaction functions present in the class Mage_Eav_Model_Entity_Collection_Abstract. These collection functions are very useful to select data from Magento database. We need them almost all the time for [...]

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 [...]

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 [...]

You can add attribute from Admin Panel -> Catalog -> Attributes -> Manage Attributes. You can also add attributes from mysql setup file of your module. MySql setup file is present inside “YourModule/sql/yourmodule_setup” directory.

Suppose, you have a module called MyModule. Its version is 0.1.0. Now, you want to do some database changes for the module. You have the mysql setup file (mysql install file) mysql4-install-0.1.0.php in MyModule/sql/mymodule_setup folder of your module. You don’t need to make direct changes to database. You can upgrade your module to make your [...]

Before I had posted an article to add, edit, delete, and display contents. I had also included sessions there. There was the facility to login and register users too. But i got feedback that it was a bit complex for novice users of PHP (users who have just started PHPing). It was a kind of [...]

Problem: Concatenate and fetch data from two fields of database and then break it again. Solution:

Hello everyone! here is a simple and complete tutorial to add, edit, delete, login, and register in PHP with MySQL database. The description is present in the code.. in comments :D I hope those comments are sufficient to describe the code. The database part is in the sql file named ‘database.sql’.

1) To make a backup of a single MySQL database You have to make backup before you enter inside your MySQL system i.e. by typing mysql –u username –p password . (Here, username and password indicates your MySQL server username and password.)

Problem: “Fails to start the service. Please wait 30 seconds to try again.” I faced this problem 2 years back when I was a newbie to MySQL. I was just starting to learn PHP and MySQL at that time.

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 [...]

At first create database named ‘test’ in mysql. Use ‘test’. Then create table ‘project’. MySQL queries for the above tasks :: Now the php code::