Zero2Cool
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.
UserPostedImage
Zero2Cool
14 years ago
Okay, I'll be putting fours into this, today. starting, 8 minutes ago.

Providing nothing breaks down in the plant. 🙂
UserPostedImage
Zero2Cool
14 years ago
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!
UserPostedImage
Zero2Cool
14 years ago
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 
UserPostedImage
Zero2Cool
14 years ago

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.
UserPostedImage
dhpackr
14 years ago
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
14 years ago

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.
UserPostedImage
dhpackr
14 years ago
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
14 years ago
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.
UserPostedImage
dhpackr
14 years ago
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
Users browsing this topic
    Fan Shout
    Zero2Cool (8h) : Chase Young to sign $13M contract with Saints
    Zero2Cool (8h) : Yosh to Panthers what noooo. Wait he didn't do crap
    wpr (18-Mar) : I say that he is technically HER BIL as he married her sister. I checked it out, he's considered my BIL as well. Sad.
    Mucky Tundra (18-Mar) : wpr, I assume its your BIL via marriage to your wife? If so, I can figure out where the smarts in the family went ;)
    wpr (18-Mar) : Mucky my B-I-L is Bare Stupid. I could write a book.
    Mucky Tundra (18-Mar) : As a teenager in Rockford IL I would get heckled by adults in public for wearing GB gear
    Mucky Tundra (18-Mar) : if you think the online ones are bad, try *living amongst* them
    Mucky Tundra (18-Mar) : Never doubt wprs loyalty. Poor guy is surrounded by Bears fans in Northern IL
    wpr (17-Mar) : pass Martha. Thanks for the invite though.
    Martha Careful (17-Mar) : blog * as the same ugly Illinois colors were adopted by the Baer
    Martha Careful (17-Mar) : WPR, perhaps you should be joining the Bears fans blog has the same ugly Illinois colors were adopted by the Bears
    Mucky Tundra (17-Mar) : Ah a fellow U of Illinois hater. I can respect that though I imagine it's for different reasons
    Zero2Cool (17-Mar) : BTW. I didn't catch the game. I just hate Illinois.
    Mucky Tundra (17-Mar) : They're your Big Ten Chumps and you will like it!
    Zero2Cool (17-Mar) : No, not for the record. Referee's handled that BS. Orange team was trash ass
    Mucky Tundra (17-Mar) : *Your* Big Ten Chumps for the record
    Zero2Cool (17-Mar) : No, not Big Ten Champs. IL is big ten CHUMPS
    wpr (17-Mar) : Big Ten Champs
    wpr (17-Mar) : !!!
    wpr (17-Mar) : INI
    wpr (17-Mar) : ILL
    Martha Careful (17-Mar) : Wisconsin with an outstanding on in the men’s Big Ten basketball tournament. Let’s hope it continues in the NCAAs
    Zero2Cool (17-Mar) : Almost like taking QB in 2020 even if you don't need one is good move.
    Mucky Tundra (16-Mar) : 2021 QB Draft class looking like a real clunker
    Mucky Tundra (16-Mar) : A conditional 6th rounder? I remember Bears fans arguing they'd get a day 2 pick at worst lol
    dfosterf (16-Mar) : So I got the no extension part right and the have to wait on the CW physical wrong
    Zero2Cool (16-Mar) : Bears are trading Justin Fields for a 2025 6th-round pick that goes to a 4th-round pick based on playtime, per sources.
    Zero2Cool (16-Mar) : Former Packer Jarrett Bush opens Wisconsin’s first blow dry bar in Green Bay
    dfosterf (16-Mar) : If the Bears are not doing a deal with Washington, they also cannot trade Fields until Williams physical with them. All hail Caleb Williams!
    dfosterf (16-Mar) : The talent is undeniable, but the (advertised) haul is obscene.
    dfosterf (16-Mar) : If the Bears are cutting a deal with the Commanders, in either scenario, cannot happen until williams passes a Commanders physical
    dfosterf (16-Mar) : My guess is no to the Fields extension, but yes to the trade back with the Commanders.
    dhazer (15-Mar) : I think the Bears do a Love extension and they will trade out of the 1st pick and take the haul
    Martha Careful (15-Mar) : that might make sense
    Zero2Cool (15-Mar) : Justin Fields to Steelers?
    Zero2Cool (15-Mar) : Kenny Pickett. Eagles. Done.
    Zero2Cool (15-Mar) : They can claim best two WR tandem.
    Mucky Tundra (15-Mar) : Aaron Donald retiring
    dhazer (15-Mar) : Campbell signing with 49ers
    dhazer (15-Mar) : I love how the Bear Fans are now claiming they have the best skill players in the NFC North lol
    Zero2Cool (15-Mar) : Vikings made a move to get a 2nd first round pick
    Mucky Tundra (15-Mar) : That's a not a bad deal for the Bears
    Zero2Cool (15-Mar) : Bears have traded for WR Keenan Allen sending Chargers a fourth rounder.
    Martha Careful (15-Mar) : *signs
    Martha Careful (14-Mar) : MLB Devon White science with the Eagles
    Mucky Tundra (14-Mar) : But that was before FA started
    Mucky Tundra (14-Mar) : Dhaze, I thought Kurls would be their #1 target when I read that he was an Amos comp (jack of all trades guy)
    dhazer (14-Mar) : I would like to see the Packers target 2 more FA still available Kamren Curl Safety and Chase Young edge
    Martha Careful (14-Mar) : wow...didn't see that coming
    Zero2Cool (14-Mar) : AJ Dillon re-signing with Packers.
    Please sign in to use Fan Shout
    2023 Packers Schedule
    Sunday, Sep 10 @ 3:25 PM
    Bears
    Sunday, Sep 17 @ 12:00 PM
    Falcons
    Sunday, Sep 24 @ 12:00 PM
    SAINTS
    Thursday, Sep 28 @ 7:15 PM
    LIONS
    Monday, Oct 9 @ 7:15 PM
    Raiders
    Sunday, Oct 22 @ 3:25 PM
    Broncos
    Sunday, Oct 29 @ 12:00 PM
    VIKINGS
    Sunday, Nov 5 @ 12:00 PM
    RAMS
    Sunday, Nov 12 @ 12:00 PM
    Steelers
    Sunday, Nov 19 @ 12:00 PM
    CHARGERS
    Thursday, Nov 23 @ 11:30 AM
    Lions
    Sunday, Dec 3 @ 7:20 PM
    CHIEFS
    Monday, Dec 11 @ 7:15 PM
    Giants
    Sunday, Dec 17 @ 12:00 PM
    BUCCANEERS
    Sunday, Dec 24 @ 12:00 PM
    Panthers
    Sunday, Dec 31 @ 7:20 PM
    Vikings
    Sunday, Jan 7 @ 3:25 PM
    BEARS
    Sunday, Jan 14 @ 3:30 PM
    Cowboys
    Saturday, Jan 20 @ 7:15 PM
    49ers
    Recent Topics
    5h / Green Bay Packers Talk / beast

    13h / Green Bay Packers Talk / dfosterf

    14h / Green Bay Packers Talk / beast

    18-Mar / Around The NFL / Mucky Tundra

    16-Mar / Random Babble / Martha Careful

    16-Mar / Green Bay Packers Talk / TheKanataThrilla

    15-Mar / Green Bay Packers Talk / dhazer

    15-Mar / Green Bay Packers Talk / dfosterf

    14-Mar / Green Bay Packers Talk / beast

    14-Mar / Random Babble / Zero2Cool

    14-Mar / Green Bay Packers Talk / dfosterf

    13-Mar / Random Babble / Zero2Cool

    13-Mar / Green Bay Packers Talk / Martha Careful

    13-Mar / Green Bay Packers Talk / Martha Careful

    13-Mar / Green Bay Packers Talk / beast

    Headlines