PHP and MySQL· Page 3 · PACKERSHOME

Zero2Cool
Elite Member Topic Starter

14 years ago

with in the class pages, you will put your functions to store and retrieve your data as well as the functionality to save pics and change the picks..

what do you think.

BTW do not get me started talkin about programming. i am an junkie. i just started 4 years ago. two years of school, got hired for a fullt time programming job before i even graduated. worked 14 months full time, then the next 5 months part time.

i have received no training, just been cut loose on live projects since day 1. i've coded in cold fusion, vb6, vb.net, classic asp, sql, javascript, css, html, mysql, php.

mainly doing various database driven forms and validation. no fancy graphics or code editors.

my week is over no more coding for this week, & i'm going fishing. chat next week.

"dhpackr" wrote:

I'll add more to this when I get home.

I had two years of college as well. Graduated, then a few months later, got a full time VB job. I've done a lot of various coding, but nothing I'm proud or languages I care to admit to touching, publicly. :)

I thought we scrapped this project with the failed host move.. but the design that DH has listed looks pretty solid overall.. +1.

However maybe link the login credentials from here to the other app..

"pack93z" wrote:

Appreciate the kindly reminder of lost money and time on the second failed host move. 🙂

Decided to stay with Linux and learn PHP code.

Zero2Cool
Elite Member Topic Starter

14 years ago

#22

Okay, I'll be putting fours into this, today. starting, 8 minutes ago.

Providing nothing breaks down in the plant. 🙂

Zero2Cool
Elite Member Topic Starter

14 years ago

#23

HOLY SHIZNIZZLEFRAPS! I had some code that I had done awhile on this. By golly, I think I might be able to do this after all!

Zero2Cool
Elite Member Topic Starter

14 years ago

#24

I like VB, much more gooder. This coding via text editor > my ass. 🙂

Anyhow. I've got the form to send the picks to the database. But now I have to figure out an intelligent way to build the database. Current method, not too bright. :)

http://forums.devnetwork.net/viewforum.php?f=1&sid=eaaee9c21328f62de11485ad60691e80

Zero2Cool
Elite Member Topic Starter

14 years ago

#25

well, you are on the right track 4-sho.

1 database
4 tables

Log In table
Current Standings table
Weekly Winner table
Each Week's Picks table

now, you'll need your login page
this will have a
template page
a class page
a login.php page
a db class page

a current standings page

this will have a
template page
a class page
a db class page

Weekly Winner page
this will have a
template page
a class page
a db class page

Each Week's Picks page
this will have a
template page
a class page
a db class page

with in the class pages, you will put your functions to store and retrieve your data as well as the functionality to save pics and change the picks..

"dhpackr" wrote:

Oddly enough, I understand what you're saying, and if this was .NET I'd have it done already. However, I'm at a complete loss. Also, about the login page. I'd like to use the require (login.php) and take the member name from there. That would elminate having to make a new login/password for everyone. Which is one of the reasons I'm wanting to do it on the site instead of Yahoo! or something. Is that possible?

Edit, also ... a page is needed to submit the winners.

dhpackr
Registered

14 years ago

#26

is ur login page working??

ru using PHP/MyAdmin to build ur database???

create your login table. you can import data from another database, an excel spread sheet or cvs file, and add, edit, delete using the PHP/MYSQL admin area.

so you should be able to just add another table via the PHP admin area to the database u already have called login. it would have fields called username, password etc.

the members name can be added to the table and then u would write a query to select the usersname & password.

have u connected to your database and displayed some data yet??
u said u got the forms to display in the database, now is that data being displayed on the page??

as far as submitting the winners. u would want to write a function to display the winners and put this code in the class file for what ever page you wish to display the winners on.

So if you meet me Have some courtesy, Have some sympathy, and some taste
Use all your well-learned politesse, Or I'll lay your soul to waste

Zero2Cool
Elite Member Topic Starter

14 years ago

#27

is ur login page working??

"dhpackr" wrote:

I'm going to take the member name of the member and use that instead of having members create a new login.

ru using PHP/MyAdmin to build ur database???

"dhpackr" wrote:

I have one table for all of the picks right now. It's not going to be the fastest method, but I just want to get something done. (Table has fldMember, fldWeek, fldGame, fldSelection and fldWinner) So far, working out nicely.

create your login table. you can import data from another database, an excel spread sheet or cvs file, and add, edit, delete using the PHP/MYSQL admin area.

"dhpackr" wrote:

I think I might be able to get around doing the whole login.php thing.

so you should be able to just add another table via the PHP admin area to the database u already have called login. it would have fields called username, password etc.

the members name can be added to the table and then u would write a query to select the usersname & password.

"dhpackr" wrote:

I think using the member name from the member already logged into PH might be the easiest solution instead of having everyone use another login to remember.

have u connected to your database and displayed some data yet??

"dhpackr" wrote:

Yes sir. I've read, write, updated and displayed data on the PHP page from the MySQL database.

u said u got the forms to display in the database, now is that data being displayed on the page??

"dhpackr" wrote:

I don't have any forms displaying IN the database. I have the page posted on the original post displaying a form. The form table layout is hardcoded.

as far as submitting the winners. u would want to write a function to display the winners and put this code in the class file for what ever page you wish to display the winners on.

"dhpackr" wrote:

I was considering making a admin page, secured via password and entering the winners in there.

I've kind of laid off on this because I just don't have the time to dedicate to it. I made some good progress and if I had a couple days to do dedicate to it, I'd have it done. Wouldn't be anything pretty or to brag about, but would serve the purpose and work well. The problem is with not knowing what I can do, it's slowing me down. I have to try several different things before finding one that works.

dhpackr
Registered

14 years ago

#28

if you ever need any help with forms or validation, let me know.

i do not do design work or photoshop, but if you want some one to hack out some code let me know.

So if you meet me Have some courtesy, Have some sympathy, and some taste
Use all your well-learned politesse, Or I'll lay your soul to waste

Zero2Cool
Elite Member Topic Starter

14 years ago

#29

I will need your help buddy. I'm going to get something to eat. Beat my daughter up and then I'll be back.

http://packershome.com/index.php?name=NFL_Picks <-- That's where I'm at right now. I have several questions.

dhpackr
Registered

14 years ago

#30

OK, i took a quick look. i guess you would want some validation to make sure all the picks are made.

FYI- i am a little cross eyed right now. I was fishing all day, from 6 a.m to about 6 p.m.

right now i feel like i am still bobbing up and down in a boat.

i think after the picks are made you want to have the user click submit and store their selection in your database table, and also have the click send the user to a confirmation page that displays their picks.

passing values from one form to another takes some solid PHP programming.

i got a little to much sun today, so i need to take a break. Mon a.m. i can work with you if you want.

So if you meet me Have some courtesy, Have some sympathy, and some taste
Use all your well-learned politesse, Or I'll lay your soul to waste

Important Information:

The PACKERSHOME uses cookies. By continuing to browse this site, you are agreeing to our use of cookies. More Details Close

Fan Shout

Mucky Tundra (7h) : Adds most of the information this time of year comes from agents.

Mucky Tundra (7h) : @RealAlexBarth Bill Belichick says accurate draft information doesn't leak from teams until about 12 hours before the draft. Adds most of th

Mucky Tundra (7h) : I am very happy that for moment, Jordan Love seems like a normal human being

Zero2Cool (18h) : Belichick * whatever

Zero2Cool (18h) : "There's a lot of depth at Offensive Tackle and Wide Receiver." Bill Bellichick

Zero2Cool (17-Apr) : Thanks! I can't believe it's over haha

Martha Careful (16-Apr) : Congratulations

Zero2Cool (16-Apr) : Boom. Student Loan. $0.00. Only took about 20 years.

Zero2Cool (14-Apr) : Packers DT Kenny Clark: New defensive coordinator Jeff Hafley will 'allow us to be way more disruptive'

Zero2Cool (12-Apr) : Saints have agreed to terms on a contract with former Packers wide receiver Equanimeous St. Brown.

beast (12-Apr) : No, but of it's for legislation, then half of the country will find it evil, not good, whatever it says....

Mucky Tundra (12-Apr) : Draft is still 2 weeks away. UGH

dhazer (11-Apr) : Does anyone know of a good AI generator to create letters of Support for legislation?

Zero2Cool (11-Apr) : Gordon "Red" Batty retires as equipment manager

Zero2Cool (10-Apr) : Sounds like that's pretty certain now.

Zero2Cool (10-Apr) : Packers "at" Eagles in Brazil. Week One

dfosterf (10-Apr) : Va' Fazer As Malas Va' !

Zero2Cool (9-Apr) : Mark Murphy tipping us off?

Zero2Cool (9-Apr) : “We’re either the first- or second-most popular team in Brazil.”

Zero2Cool (9-Apr) : Christian Watson got married. Wife better be careful with those hamstrings!! 😂😂

dfosterf (9-Apr) : Those poor bastards

Zero2Cool (8-Apr) : Falcons have signed former Packers CB Kevin King, who has been out of football since 2021.

dfosterf (8-Apr) : Collectively, we need to spend more time in what we have, when analyzing ostendible needs and historical proclivities

dfosterf (8-Apr) : I say he is better than so many of these draft picks

dfosterf (8-Apr) : Question of the week for me: Has anyone besides me done any deep dive into the potential of Alex McGough, our 3rd string qb?

Zero2Cool (8-Apr) : Or in Tunsil's case, something gets released day of draft or day before lol

Zero2Cool (8-Apr) : Seems every year someone does something pre-draft.

dfosterf (8-Apr) : Falling down drunk. The draft board

dfosterf (8-Apr) : Allright! Potential character guy/f#×k up pickup in D'Vondre Sweat!

Zero2Cool (7-Apr) : Go Badgers!!!

Martha Careful (6-Apr) : Go Boilermakers!!!

Martha Careful (5-Apr) : Diggs has not stepped up in the playoffs and has a high cost

beast (5-Apr) : Probably not going to let Diggs walk away unless he's horrible... but according to reports he also might not be as good as he used to be.

beast (5-Apr) : The 25th pick in the draft has been an offensive player since 2017, 2 TE, 2 WR, 1 RB, 1 OC

Mucky Tundra (5-Apr) : Odd, why give up a 2025 2nd Rounder for him if you're just gonna let him walk?

Zero2Cool (4-Apr) : Texans to let Diggs be free agent in '25

buckeyepackfan (4-Apr) : 49r's aign RB Patrick Taylor.

Martha Careful (4-Apr) : Reversion to the mean would indicate we will keep it

Zero2Cool (4-Apr) : It's also been utilized in a trade in 14 of the past 20 years

Zero2Cool (4-Apr) : The 25th pick in the draft hasn't been made by it's original holder since 2016.

Mucky Tundra (4-Apr) : Gotta imagine that Green Bay vs Houston will be a primetime game this upcoming season

Zero2Cool (3-Apr) : No. Kill QB. No worries. 😁

Mucky Tundra (3-Apr) : Diggs, Collins, Dell and Schultz is gonna be tough to cover

Zero2Cool (3-Apr) : Stefon Diggs' trade will not be processed as a post-June 1 designation, so that is just over $31 million in dead cap this year.

Zero2Cool (3-Apr) : Bills trading WR Stefon Diggs to the Texans in exchange for a 2025 2nd-round pick. (via @rapsheet)

beast (3-Apr) : Using Patterson as RB and RB/WR tweener... so I think they also signed Patterson as a 3rd down RB, not just a kick returner as articles are

beast (3-Apr) : I think PFT missed the real Steelers/Patterson connection, Steelers new OC Arthur Smith has been Patterson's head coach the last 3 years

wpr (2-Apr) : It has Martha. I was stunned when I was in HS to learn Iowa was still playing half court BB in the 70's.

Martha Careful (2-Apr) : Caitlin Clark, Angel Reese...women's sports has come a long way. GREAT TO SEE!!

Martha Careful (31-Mar) : Happy Easter everyone. I hope you all have a great day.

Please sign in to use Fan Shout

2023 Packers Schedule

Sunday, Sep 10 @ 3:25 PM

Bears

38 - 20

Sunday, Sep 17 @ 12:00 PM

Falcons

24 - 25

Sunday, Sep 24 @ 12:00 PM

SAINTS

18 - 17

Thursday, Sep 28 @ 7:15 PM

LIONS

20 - 34

Monday, Oct 9 @ 7:15 PM

Raiders

13 - 17

Sunday, Oct 22 @ 3:25 PM

Broncos

17 - 19

Sunday, Oct 29 @ 12:00 PM

VIKINGS

10 - 24

Sunday, Nov 5 @ 12:00 PM

RAMS

20 - 3

Sunday, Nov 12 @ 12:00 PM

Steelers

19 - 23

Sunday, Nov 19 @ 12:00 PM

CHARGERS

23 - 20

Thursday, Nov 23 @ 11:30 AM

Lions

29 - 22

Sunday, Dec 3 @ 7:20 PM

CHIEFS

27 - 19

Monday, Dec 11 @ 7:15 PM

Giants

22 - 24

Sunday, Dec 17 @ 12:00 PM

BUCCANEERS

20 - 34

Sunday, Dec 24 @ 12:00 PM

Panthers

33 - 30

Sunday, Dec 31 @ 7:20 PM

Vikings

33 - 10

Sunday, Jan 7 @ 3:25 PM

BEARS

17 - 9

Sunday, Jan 14 @ 3:30 PM

Cowboys

48 - 32

Saturday, Jan 20 @ 7:15 PM

49ers

21 - 24