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.
Dynamic Results
Moderator: General Moderators
- novice4eva
- Forum Contributor
- Posts: 327
- Joined: Thu Mar 29, 2007 3:48 am
- Location: Nepal
Re: Dynamic Results
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
http://www.php.net/manual/en/mysql.examples.php
Re: Dynamic Results
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.. ? ? ?
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.. ? ? ?