Running Queries to DB via PHP webpages.

[COOKIED89]

I need some help getting PHP to talk with a MYSQL database.

I want a PHP page with a table that is setup to be able to edit/retrieve and 'print' data from the table.

 

My tables are below :

 

authteam - id, teamname, teamlead, status.

authuser - id, uname, passwd, team, level, status, lastlogin, logincount.

state - state, name

timesheet - ID, uname, entrydate, state, hours

 

I want users, once logged in to be able to :

 

ADD AN ENTRY:

 

<username inserted automatically> (hidden?) <DATE> <STATE> <AMOUNT OF HOURS>

 

View Existing Entries (Like a 'Monthly Table/Overview) .. and if possible, be able to have edit buttons along the table somewhere.

STATE TOTAL HOURS

VIC 2.4

 

 

 

I know the queries I want to use, for example -

 

SELECT sum(`hours`) Total FROM timesheet WHERE `STATE` = "VIC";

 

.. It's just getting them to work within a PHP page and talk to the DB. The server at the moment is localhost and username root, no password.

But this will obviously change. Thank you.

[xtopolis]

http://www.tizag.com/mysqlTutorial/mysqlinsert.php