Database web application

Question

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

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

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

Answer 2

Since you don't have any specific requirements, I would recommend looking for a web framework that features scaffolding. Scaffolding generally provides you with the ability to create, read, update, and destroy data in your database with zero effort spent coding. You may also be provided with features like sorting and pagination... all for free.

The following frameworks all provide scaffolding:

• Ruby on Rails (Ruby)
• CakePHP (PHP)
• Grails (Java)
• Seam (Java)
• Spring MVC (Java)

Since you mention PHP specifically, have a look at CakePHP's official documentation on scaffolding and bake, or this tutorial.