PDA

Click to See Complete Forum and Search --> : PHP help


NOTSOSURE
Feb 27th, 2006, 06:45 AM
Hey all

i need some help regarding my course work....dun want the solution just some help...here is the course work question:

implement a HTML form driven web application which has several sections and allows a user to query a student MYSQL database called SOC_DB (which you must create along with its constituent tables) and obtain information regarding students enrolled with the School of Computing. The basic queries are specified as follows:

(i) Find all students enrol a specified degree scheme.
(i) Find all students taking a specified module

You must also create an area where a user defined SQL query string can be entered and process it to affect a query. In this case you are required to write CGI script(s) (in Perl/PHP/ or other appropriate scripting language) in order that the query can be correctly processed and the database queried.


i have no exp in writing CGI scripts, can anyone suggest any good tutorials to get me on my way to produce the CGI scripts using PHP to access the database and carry out the queries?

Thanks

john tindell
Feb 27th, 2006, 08:39 AM
Best place to start is http://www.php.net the documentry explains everything and the user comments help alot with functions and methods of doing stuff.

For your MySQL assignment take a look at
http://uk2.php.net/mysql_connect

or just ask Google (http://www.google.co.uk/search?q=PHP%2BMySQL%2BTutorial&start=0&ie=utf-8&oe=utf-8) as there are millions upon millions of article and tutorials explaining how to use PHP with MySQL.