Kamalika's Notebook

thinking nothing...............!!

How to connect to MySQL database using PHP

By Leave a Comment

In this article we’ll try to achieve three things:

1) Connect to MySQL using PHP

2) Create a database and table in MySQL

3) Connect to MySQL using PHP and fetch / retrieve data from the database

Scope of this article is to guide beginners who have just started PHP programming and have never tried to connect to any database using PHP, although PHP have the capability to connect to MySQL, MySQLi, PostGRESQL, Oracle and other number of databases today we’ll only discuss about PHP and MySQL connectivity and the development environment considered is XAMPP on Windows. [Read more…]

Top 10 Common MySQL Mistakes Made By PHP Developers

By Leave a Comment

Top 10 Common MySQL Mistakes Made By PHP Developers

The LAMP Stack

As per Wikipedia definition: LAMP is a solution stack of free, open source software. The acronym LAMP refers to the first letters of Linux (Operating System), Apache HTTP Server, MySQL (Database software), and PHP, Perl or Python, principal components to build a viable general purpose web server.

It is evident from the definition that Database is a fundamental component of most web applications. Even for developing static websites CMS software like WordPress, Joomla, Drupal are used all of which have a Database in the back end to store static content. If you are using PHP, Perl or Python then MySQL is an integral part of the development.

PHP is easy, is it a boon or bane?

PHP’s greatest strength has been its ease of use, any entry level programmer who has little bit knowledge of C Language and understands HTML / CSS / JavaScript to some extent can get a head start with PHP programming. But getting a head start does not ensure efficient completion of an expedition; it requires stability, fail safeness, sustainability & reliability. In order to write stable & reliable code along with building a solid, dependable, robust Database takes expertise and expertise comes from practice, experience & learning from mistakes. Here are 10 nasty mistakes I have seen PHP developers making quite often. [Read more…]