• Home
  • Knowledgebase
    • Technology
      • Video Technology
      • PHP
      • MySQL
      • WordPress
      • Cloud Computing
  • Thoughts
    • General
    • Stories
    • Places
    • Workplace
    • Social Issues
    • Reviews
  • Quotes
  • About
  • Contact

Kamalika's Notebook

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

How to connect to MySQL database using PHP

August 21, 2014 By Kamalika 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…]

Pages: 1 2 3

Filed Under: MySQL, PHP, Technology Tagged With: Connecting to MySQL using PHP, How to use PHP to connect to and retrieve data from MySQL, PHP & MySQL, sample php code to connect to mysql database

Top 10 Common MySQL Mistakes Made By PHP Developers

February 19, 2013 By Kamalika 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…]

Filed Under: MySQL, PHP Tagged With: MySQL, MySQL Database, MySQL Mistakes, PHP & MySQL

Connect with me online

  • Facebook
  • Google+
  • Instagram
  • LinkedIn
  • Twitter
  • YouTube

Hello There…

Hi, I'm Kamalika... a newbie entrepreneur & business coach, technology enabler, mentor, hobbyist photographer, YouTube, Netflix, Audible & Kindle indulgent, food enthusiast, Starbucks fan and former Disney employee. ...please click here to know more about me (only if you are interested!…

Follow my notebook

Enter your email address to follow my notebook and receive notifications of new posts by email.

Looking for something?

Copyright © 2019 · Kamalika Guha Roy