Connecting to Database

Note: Before you attempt this tutorial you should have some DB server running on your computer such as MySql. If not download dev5beta3.exe and install PHP, Apache and MySql together with phpMyAdmin with one click, and you will be ready for all the dynamic tutorials.

1. Go to Window > Databases or Press Ctrl+Shift+F10 to open Databases window if it is not open. Press + sign and choose MySql connection.

image 1

2. You will be displayed with the pop-up window where you can insert the database connection details. Give a name for the connection in the first field. Second for MySQL server insert localhost, if your server location is different from localhost insert the correct location. For the Username and Password insert your admin username and password, if you don't have one go to phpMyAdmin and create one. For the Database insert your database name or press select button to choose from the existing database list if there are any.

image 2

3. After you have inserted all the connection details press on the Test button. If everything went OK, you should see a success message.

image 3

4. Now you should be able to see your Database connection details in the Databases Window. If you click on the + plus sign for the Tables then you will see all the list of Tables for this specific database.

image 4


Close    To Top
  • Prev Article-Web Design:
  • Next Article-Web Design:
  • Now: Tutorial for Web and Software Design > Web Design > HTMLCSS > Web Design Content
    Photoshop Tutorial
     

    Special Effect

      3D Effect
      Photoshop Articles
    Programming Tutorial
     

    C/C++ Tutorial

      Visual Basic
      C# Tutorial
    Database Tutorial
     

    MySQL Tutorial

      MS SQL Tutorial
      Oracle Tutorial
    Geek Tutorial
     

    Blogging Tutorial

      RSS Tutorial
      Podcasting Tutorial
    Graphic Design Tutorial
      Coreldraw Tutorial
      Illustrator Tutorial
      3D Tutorials
    Webmaster Articles
     

    Domain Service

      Web Hosting
      Site Promotion
    Java Tutorial/ Articles
     

    Java Servlets

      JavaEE Tutorial
     

    JavaBeans Tutorial

    XML Tutorial/ Articles
     

    XML Style

      AJAX Tutorial
      XML Mobile
    Flash Tutorial/ Articles
     

    Flash Video

      Action Script
      Flash Articles
    OS Tutorial/ Articles
      Linux Tutorial
      Symbian Tutorial
      MacOS Tutorial
    Personal Tech
      Hardware Tutorial
      Software Tutorial
      Online Auction