PHP and MySQL· Page 3 · PACKERSHOME

Zero2Cool
Elite Member Topic Starter

15 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

15 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

15 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

15 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

15 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

15 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

15 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

15 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

15 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

15 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

Martha Careful (1h) : Two terrific NCAA Football Semi-Final Games...We can only hope the Championship game is as good

Zero2Cool (21h) : Eagles WR DeVonta Smith will be a DNP in today’s practice. He’s dealing with back tightness. But the expectation is that he’ll play Sunday.

Zero2Cool (22h) : Jalen Hurts has cleared the concussion protocol. He’s playing Sunday.

Zero2Cool (22h) : 𝕏avier McKinney First Team All-Pro

Zero2Cool (10-Jan) : NFL moves Vikings-Rams playoff tilt to Arizona due to fires

Zero2Cool (10-Jan) : Rams lose home field advantage for Monday game.

Mucky Tundra (9-Jan) : Notre Lame=Notre Dame, Luckeyes=Ohio State, Pedo St=Penn St

Zero2Cool (9-Jan) : ... It clearly was not what we were supposed to be in, certainly."

Zero2Cool (9-Jan) : Hafley says 3rd and 11 call there was a miscommunication.

Zero2Cool (9-Jan) : The only team I know is Texas from that. Who are the other three?

Mucky Tundra (9-Jan) : Notre Lame vs Pedo St tonight and the Luckeyes vs Texas tomorrow

Mucky Tundra (9-Jan) : Stud

Zero2Cool (9-Jan) : E. Cooper. Rookie of Month. Defense.

Mucky Tundra (8-Jan) : @AaronNagler · 2m Both Jordan Love and Malik Willis were Limited participants at Packers practice today.

Zero2Cool (8-Jan) : Johnson didn't make it until 2020. Ring 2023. 🤷 Personally, he should have been in years prior to Hall.

Zero2Cool (8-Jan) : HUMP DAY

beast (8-Jan) : Guys that have a good shot at making the NFL Hall of Fame usually get into their teams pretty fast

beast (8-Jan) : Yeah, but is Kampman and the others in the NFL Hall of Fame?

Zero2Cool (8-Jan) : Johnson was Hall of Fame, 2020. Should haev been in Ring a year later, not three years.

Zero2Cool (8-Jan) : I could be wrong there though

Zero2Cool (8-Jan) : Guys like Kampman, Tim Harris, Al Harris, etc all over 15 years. Hall of Fame is 5 year wait

Zero2Cool (8-Jan) : I guess I see players in Packers Hall come way later

beast (8-Jan) : Yeah, usually teams hall of fames are a much lower bar than the NFL

Zero2Cool (8-Jan) : is it uncommon for Hall before Ring?

Zero2Cool (8-Jan) : S Xavier McKinney named first-team All-Pro by NFLPA

beast (8-Jan) : I missed it, sorry, but he got into the NFL Hall of Fame years before that

Zero2Cool (8-Jan) : Jones took his sweet ole time!

Zero2Cool (8-Jan) : Yeah, he's in the ring of honor, just saw video and his name is up there

Zero2Cool (8-Jan) : Didn't they have a thing in 2023 for Jimmy's ring of honor? I swear I saw it

beast (8-Jan) : Though if they're legitimately trying to re-sign MM, then it makes sense.

beast (8-Jan) : Jerry Jones still hasn't put Jimmy Johnson in the Ring of Honor, but he's in the NFL's Hall of Fame, Jones is petty

Mucky Tundra (8-Jan) : Unless the Cowboys are planning an extension, seems kinda petty

beast (8-Jan) : Cowboys denied Bears request

Mucky Tundra (6-Jan) : From what I'm reading, MM is under contract through the 14th of January; after that he's free game

Zero2Cool (6-Jan) : McCarthy let go or not extended??

Mucky Tundra (6-Jan) : Chicago Bears have asked the Dallas Cowboys permission to interview Mike McCarthy for head coaching vacancy

Zero2Cool (6-Jan) : The winners page that is

Zero2Cool (6-Jan) : I was not hoping for that. It messes up the page lol

beast (6-Jan) : Thank you, and I was really opening we were going to get 4 or more tied for the top 3.

beast (6-Jan) : Thank you, and I was really opening we were going to get 4 or more tied for the top 3

Zero2Cool (6-Jan) : congrats beast on 2024 !

Zero2Cool (6-Jan) : congrats porky on winning 2023 pick'em! (oops sorry)

Zero2Cool (6-Jan) : Packers have $60M+ of 2025 cap space on paper TODAY.

Mucky Tundra (6-Jan) : Missed FG into a Lions TD; that'll do pig, that'll do

Mucky Tundra (6-Jan) : That might be it for the Vikings

Mucky Tundra (6-Jan) : Oh so the refs do know what intentional grounding is

Mucky Tundra (6-Jan) : what the hell was that Goff?! Not much pressure and he just air mails it to Harrison

Mucky Tundra (6-Jan) : They really need to to get rid of the auto first down for illegal contact

Martha Careful (6-Jan) : watching the Vikings and Lions it's understandable why they swept the Packers. So much better product

Please sign in to use Fan Shout

2024 Packers Schedule

Friday, Sep 6 @ 7:15 PM

Eagles

29 - 34

Sunday, Sep 15 @ 12:00 PM

COLTS

16 - 10

Sunday, Sep 22 @ 12:00 PM

Titans

30 - 14

Sunday, Sep 29 @ 12:00 PM

VIKINGS

29 - 31

Sunday, Oct 6 @ 3:25 PM

Rams

24 - 19

Sunday, Oct 13 @ 12:00 PM

CARDINALS

34 - 13

Sunday, Oct 20 @ 12:00 PM

TEXANS

24 - 22

Sunday, Oct 27 @ 12:00 PM

Jaguars

30 - 27

Sunday, Nov 3 @ 3:25 PM

LIONS

14 - 24

Sunday, Nov 17 @ 12:00 PM

Bears

20 - 19

Sunday, Nov 24 @ 3:25 PM

49ERS

38 - 10

Thursday, Nov 28 @ 7:20 PM

DOLPHINS

30 - 17

Thursday, Dec 5 @ 7:15 PM

Lions

31 - 34

Sunday, Dec 15 @ 7:20 PM

Seahawks

30 - 13

Monday, Dec 23 @ 7:15 PM

SAINTS

34 - 0

Sunday, Dec 29 @ 3:25 PM

Vikings

25 - 27

Sunday, Jan 5 @ 12:00 PM

BEARS

22 - 24