Database web application

Question

Question by Watergaite

How would i go about creating a php application for my web page that can extract data from my database (i currently get the data in a CSV file). id also like the user to be able to filter the data by certain parameters. can u help

Answer 1

Answer by Starx

Starx

There are many ways to start with like

A language

1. Asp.net c#
2. PHP Mysql
3. JSP Oracle

A server

1. Apache
2. Windows

A Framwework (like explained in another answer by Dolph Mathews )

1. Ruby on Rails (Ruby)
2. CakePHP (PHP)
3. Grails (Java)
4. Seam (Java)
5. Spring MVC (Java)
6. Symphony (PHP)
7. Zend (PHP)

Since you want it in PHP, you have to use php mysql and apache server. You can use WAMP to install all three of this in one go.
http://www.wampserver.com/en/

With wamp, you will also get phpMyAdmin, through which you can manage your database, like create, delete, manipulate ………..

Coming to the coding part, that you are going to have to google

Here are some links of W3schools to get started with

http://www.w3schools.com/php/php_mysql_intro.asp

http://www.w3schools.com/php/php_mysql_connect.asp

http://www.w3schools.com/php/php_mysql_create.asp

http://www.w3schools.com/php/php_mysql_insert.asp

http://www.w3schools.com/php/php_mysql_select.asp

http://www.w3schools.com/php/php_mysql_where.asp

http://www.w3schools.com/php/php_mysql_order_by.asp

http://www.w3schools.com/php/php_mysql_update.asp

http://www.w3schools.com/php/php_mysql_delete.asp