Dynamic Results

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
necee8483
Forum Newbie
Posts: 20
Joined: Mon Nov 03, 2008 3:09 pm

Dynamic Results

Post by necee8483 »

Okay. I am not even sure what kind of code I should be looking for. If someone could point me in the correct direction between google and the 5 books i have i can create a basic script. Here is what I am looking to do:

I have a accountability program for my agents in my company, everyday they enter in their numbers for the day and then for a while i was compiling information entering in excel manually and sending out the results at the end of the day manually and then at the end of the week i would announce the winner. As you can imagine it is impossible for me to continue this process.

what I want to do is take a web form have the agent input the information and then have the information entered into a database. This part I know how to do.

What I need it to do from there is on submit have the agent redirected to a page that displays the data from that day that all agents have entered and place the agents. Kinda like a scoreboard style.

Then I want to have a weekly total below that day to show who is winning the week.

So I guess the page would have to pull information from the database to do this. What kind of functions should I be looking up and do you have any websites that might help me with some general knowledge ? thanks so much in advance.
User avatar
novice4eva
Forum Contributor
Posts: 327
Joined: Thu Mar 29, 2007 3:48 am
Location: Nepal

Re: Dynamic Results

Post by novice4eva »

I am under the assumption that you will be using mySql for all this, there is a straight forward example in here:
http://www.php.net/manual/en/mysql.examples.php
necee8483
Forum Newbie
Posts: 20
Joined: Mon Nov 03, 2008 3:09 pm

Re: Dynamic Results

Post by necee8483 »

thanks now, i think i am starting to understand how to do what i want to do.. i am reading a whole bunch of books about php and mysql and i think i have figured out how to write the script.. now from what i understand the $_POST and the $_GET are superglobal variables that pull inputed information that a end user put into a form.

Is there a superglobal that is used to pull information from the database ? or would that script look like the following ? :

$link = mysqli_connect ('localhost','root', '123', 'acme') ;

$select = "SELECT first_name, last_name FROM customers" ;

$result = mysqli_query ($link, $select);

in essence connecting to the database selecting the column from the table and then printing the results.. ? ? ?
Post Reply