Sunday, September 6, 2015

How to connect Ionic mobile application with MySQL database and retrieve data using PHP.(Section 1)

In this Section we discussed how to Setup Wamp server and create Database using MySQL.

Part I: Install Wamp server

Download server from http://www.wampserver.com/en/
It conclude Apache server with MySql & PHP.
After Install Wamp server Double click icon and Run. With default server run on http://localhost:8080.but sometimes error comes because we use that port to run another server like IIS in our machine.
Fix that error you need to Left Click Wamp icon -->Apache --> httpd.conf


In that file in line 62, 63 and 221 you need to change port number and save file. I’m change it to 81      

                    
                     
After that you can check the server using http://localhost:81/. if You can see this kind of page then your successfully with first stage.




Go to place you install wamp and go to www directory. Create new folder inside that and rename it. You can use that folder to store your .php code files. Refresh your browser and you can see your folder under Your Project in that page.


Part II: Create Database using MySql

You can create database using
i)                    Left Click Wamp iconàMySQLàMySQL console


ii)                  http://localhost:81/phpmyadmin/
                         

  
iii)                MySQL workbench

I’m using second method.
Create new databaseàclick new link in left side top, type “Database_Name” and click Create button. I create FirstDB database.



Create tableàclick “Database_Name” in left side bar and give table name and number of columns and click Go button. I create Employee table.




Fill column name, type and length and click save.



Insert Data to Employee table click insert link.




Then fill the details. Click Go button.



You can see insert details by using SQL tab and type sql command
Select * from Employee
Next Section we discussed How to create new Ionic application and connect with MySQL Database using PHP ..To be Continue...

22 comments:

  1. Replies
    1. This comment has been removed by the author.

      Delete
  2. this is really great thank you..

    ReplyDelete
  3. aye, next tutorial up yet?

    ReplyDelete
  4. aye, next tutorial up yet?

    ReplyDelete
  5. after i changed the 'listen:81' , i still cant access the localhost page.. help?

    ReplyDelete
  6. thanks mr krishnan,

    very good explaination.. still waiting for the next tutorial.

    ReplyDelete
  7. Will you please post login with php mysql ionic code

    ReplyDelete
  8. I found your blog while searching for the updates, I am happy to be here. Very useful content and also easily understandable providing.. Believe me I did wrote an post about tutorials for beginners with reference of your blog. 
    rpa training in bangalore
    best rpa training in bangalore
    RPA training in bangalore
    rpa course in bangalore
    rpa training in chennai
    rpa online training

    ReplyDelete

  9. Whoa! I’m enjoying the template/theme of this website. It’s simple, yet effective. A lot of times it’s very hard to get that “perfect balance” between superb usability and visual appeal. I must say you’ve done a very good job with this.

    AWS certification Training Online Bangalore
    AWS Certification Training Online Pune
    AWS certification Training Online Chennai
    AWS Online Certification and Training

    ReplyDelete
  10. This is my 1st visit to your web... But I'm so impressed with your content. Good Job!
    AWS Training in pune
    AWS Online Training

    ReplyDelete
  11. Your technical information related with java programming is very useful and interesting. Also share updated details about java in your website. Thanks for sharing this article.

    java training in chennai

    java training in velachery

    aws training in chennai

    aws training in velachery

    python training in chennai

    python training in velachery

    selenium training in chennai

    selenium training in velachery

    ReplyDelete
  12. Great post. keep sharing such a worthy information.
    SEO Training in Chennai
    SEO Course

    ReplyDelete