Welcome to your Green Bay Packers Online Community!

Since 2006, PackersHome has been providing a unique experience for fans.
Your participation is greatly anticipated!
Login or Register.
7 Pages<1234>»
Options
View
Go to last post Go to first unread
Offline Zero2Cool  
#16 Posted : Wednesday, September 9, 2009 8:53:32 PM(UTC)
Zero2Cool

Rank: Legend

Yahoo! Fantasy Football - Gold: 2009FleaFlicker Fantasy Football - Silver: 2010Yahoo! NCAA March Madness - Silver: 2011ESPN NCAA March Madness - Bronze: 2010Yahoo! NCAA March Madness - Bronze: 2013

United States
Posts: 25,675
Joined: 10/13/2006(UTC)
Location: Green Bay, WI

Applause Given: 1,846
Applause Received: 2,004

I haven't worked further on it. Kind of strapped for time.

My goal for this project is to link it with the website's database but only read the members column. Then upload the data to a separate database built specifically for this.

What you see above, is all I have thus far. I have an example of connecting to a db, reading, updating, importing, but storing the picks into variables TO be processed into the db is my flaw.

UserPostedImage
Click here and find the LATEST Packers News!
Offline dhpackr  
#17 Posted : Wednesday, September 9, 2009 9:11:44 PM(UTC)
dhpackr

Rank: 4th Round Draft Pick

Posts: 963
Joined: 12/12/2007(UTC)

Applause Given: 36
Applause Received: 36

i will shoot you some code samples next week. say tues night.
i work programming during the week and had a long day today. I work on forms all the time, its all i do.

i have used vb.net and ektron, but really got started doing classic asp. i have been doing php forms since july 1. basically, adding drop downs, radio buttons, check boxes, text feilds and validation to a program that already exists.

like i said PHP is like java or c. you have to edit several files and several functions for the program to work properly.
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
Offline Zero2Cool  
#18 Posted : Wednesday, September 9, 2009 11:14:34 PM(UTC)
Zero2Cool

Rank: Legend

Yahoo! Fantasy Football - Gold: 2009FleaFlicker Fantasy Football - Silver: 2010Yahoo! NCAA March Madness - Silver: 2011ESPN NCAA March Madness - Bronze: 2010Yahoo! NCAA March Madness - Bronze: 2013

United States
Posts: 25,675
Joined: 10/13/2006(UTC)
Location: Green Bay, WI

Applause Given: 1,846
Applause Received: 2,004

I've been programming professionally in VB.NET for two years. That's my strong spot, thus, me wanting to use ASP.NET :)

I did Java and C++ in college. I can 'do' it, if I have to, but not a fan of C++.

PHP and HTML I've been doing on/off for nearly a dozen years. I've built from the ground up with HTML, and with PHP I've only manipulated what I've seen to do as I want.

Just so you know the kind of dumb programmer you're working with here, lol.

Thinking more about this ...
This will all be with one database. I'll export the members from the website db, into the nfl picks db.
I'm siding with making this a module built into the website, not sure yet.
There will be several pages...
Log In
Current Standings
Weekly Winner
Each Week's Picks (with submit and finalize options) This means you can submit your picks, come back to them the day prior to the game, change them and hit 'finalize' to finalize your picks.

I think this is fairly simple to do, but don't have the time to get it all done. I was hoping to have it done this off season, but with ASP.NET. And after paying for two extra hosting packages and failing to meet my speed requirement for the forums, I've decided PHP is the best option as I know I can learn it, slowly but surely, lol.






Any help from you or dj is greatly appreciated or anyone else whom wants to help out.

UserPostedImage
Click here and find the LATEST Packers News!
Offline dhpackr  
#19 Posted : Thursday, September 10, 2009 4:30:29 PM(UTC)
dhpackr

Rank: 4th Round Draft Pick

Posts: 963
Joined: 12/12/2007(UTC)

Applause Given: 36
Applause Received: 36

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..

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.
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
Offline Pack93z  
#20 Posted : Thursday, September 10, 2009 4:35:02 PM(UTC)
Pack93z

Rank: Hall of Famer

PackersHome NFL Pick'em - Bronze: 2012

United States
Posts: 12,752
Joined: 3/16/2007(UTC)
Location: North Central Wisconsin

Applause Given: 381
Applause Received: 1,022

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..
I think when there's enough will and aggression, there's no shortage of talent either.

UserPostedImage
Offline Zero2Cool  
#21 Posted : Thursday, September 10, 2009 5:07:34 PM(UTC)
Zero2Cool

Rank: Legend

Yahoo! Fantasy Football - Gold: 2009FleaFlicker Fantasy Football - Silver: 2010Yahoo! NCAA March Madness - Silver: 2011ESPN NCAA March Madness - Bronze: 2010Yahoo! NCAA March Madness - Bronze: 2013

United States
Posts: 25,675
Joined: 10/13/2006(UTC)
Location: Green Bay, WI

Applause Given: 1,846
Applause Received: 2,004

Originally Posted by: " Go to Quoted Post
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.


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. :)



Originally Posted by: " Go to Quoted Post
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..

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
Click here and find the LATEST Packers News!
Offline Zero2Cool  
#22 Posted : Saturday, September 12, 2009 9:09:01 AM(UTC)
Zero2Cool

Rank: Legend

Yahoo! Fantasy Football - Gold: 2009FleaFlicker Fantasy Football - Silver: 2010Yahoo! NCAA March Madness - Silver: 2011ESPN NCAA March Madness - Bronze: 2010Yahoo! NCAA March Madness - Bronze: 2013

United States
Posts: 25,675
Joined: 10/13/2006(UTC)
Location: Green Bay, WI

Applause Given: 1,846
Applause Received: 2,004

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

Providing nothing breaks down in the plant. :)

UserPostedImage
Click here and find the LATEST Packers News!
Offline Zero2Cool  
#23 Posted : Saturday, September 12, 2009 9:31:21 AM(UTC)
Zero2Cool

Rank: Legend

Yahoo! Fantasy Football - Gold: 2009FleaFlicker Fantasy Football - Silver: 2010Yahoo! NCAA March Madness - Silver: 2011ESPN NCAA March Madness - Bronze: 2010Yahoo! NCAA March Madness - Bronze: 2013

United States
Posts: 25,675
Joined: 10/13/2006(UTC)
Location: Green Bay, WI

Applause Given: 1,846
Applause Received: 2,004

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
Click here and find the LATEST Packers News!
Offline Zero2Cool  
#24 Posted : Saturday, September 12, 2009 11:36:55 AM(UTC)
Zero2Cool

Rank: Legend

Yahoo! Fantasy Football - Gold: 2009FleaFlicker Fantasy Football - Silver: 2010Yahoo! NCAA March Madness - Silver: 2011ESPN NCAA March Madness - Bronze: 2010Yahoo! NCAA March Madness - Bronze: 2013

United States
Posts: 25,675
Joined: 10/13/2006(UTC)
Location: Green Bay, WI

Applause Given: 1,846
Applause Received: 2,004

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...1328f62de11485ad60691e80

UserPostedImage
Click here and find the LATEST Packers News!
Offline Zero2Cool  
#25 Posted : Saturday, September 12, 2009 10:47:02 PM(UTC)
Zero2Cool

Rank: Legend

Yahoo! Fantasy Football - Gold: 2009FleaFlicker Fantasy Football - Silver: 2010Yahoo! NCAA March Madness - Silver: 2011ESPN NCAA March Madness - Bronze: 2010Yahoo! NCAA March Madness - Bronze: 2013

United States
Posts: 25,675
Joined: 10/13/2006(UTC)
Location: Green Bay, WI

Applause Given: 1,846
Applause Received: 2,004

Originally Posted by: " Go to Quoted Post
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..


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
Click here and find the LATEST Packers News!
Offline dhpackr  
#26 Posted : Tuesday, September 15, 2009 6:36:47 PM(UTC)
dhpackr

Rank: 4th Round Draft Pick

Posts: 963
Joined: 12/12/2007(UTC)

Applause Given: 36
Applause Received: 36

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
Offline Zero2Cool  
#27 Posted : Wednesday, September 16, 2009 2:57:58 PM(UTC)
Zero2Cool

Rank: Legend

Yahoo! Fantasy Football - Gold: 2009FleaFlicker Fantasy Football - Silver: 2010Yahoo! NCAA March Madness - Silver: 2011ESPN NCAA March Madness - Bronze: 2010Yahoo! NCAA March Madness - Bronze: 2013

United States
Posts: 25,675
Joined: 10/13/2006(UTC)
Location: Green Bay, WI

Applause Given: 1,846
Applause Received: 2,004

Originally Posted by: " Go to Quoted Post
is ur login page working??

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


Originally Posted by: " Go to Quoted Post
ru using PHP/MyAdmin to build ur database???

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.

Originally Posted by: " Go to Quoted Post
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.

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

Originally Posted by: " Go to Quoted Post
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.

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.

Originally Posted by: " Go to Quoted Post
have u connected to your database and displayed some data yet??

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

Originally Posted by: " Go to Quoted Post
u said u got the forms to display in the database, now is that data being displayed on the page??

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.

Originally Posted by: " Go to Quoted Post
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.

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
Click here and find the LATEST Packers News!
Offline dhpackr  
#28 Posted : Friday, September 18, 2009 9:51:04 PM(UTC)
dhpackr

Rank: 4th Round Draft Pick

Posts: 963
Joined: 12/12/2007(UTC)

Applause Given: 36
Applause Received: 36

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
Offline Zero2Cool  
#29 Posted : Friday, September 18, 2009 10:08:23 PM(UTC)
Zero2Cool

Rank: Legend

Yahoo! Fantasy Football - Gold: 2009FleaFlicker Fantasy Football - Silver: 2010Yahoo! NCAA March Madness - Silver: 2011ESPN NCAA March Madness - Bronze: 2010Yahoo! NCAA March Madness - Bronze: 2013

United States
Posts: 25,675
Joined: 10/13/2006(UTC)
Location: Green Bay, WI

Applause Given: 1,846
Applause Received: 2,004

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 &lt;-- That's where I'm at right now. I have several questions.

UserPostedImage
Click here and find the LATEST Packers News!
Offline dhpackr  
#30 Posted : Friday, September 18, 2009 10:35:18 PM(UTC)
dhpackr

Rank: 4th Round Draft Pick

Posts: 963
Joined: 12/12/2007(UTC)

Applause Given: 36
Applause Received: 36

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
Rss Feed 
Users browsing this topic
Guest
7 Pages<1234>»
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Notification

Icon
Error

Recent Topics
0m / Green Bay Packers Talk / nerdmann

1m / Green Bay Packers Talk / nerdmann

1h / Green Bay Packers Talk / StarrMax1

1h / Green Bay Packers Talk / Mucky Tundra

1h / Green Bay Packers Talk / Mucky Tundra

4h / Random Babble / Dulak

12h / Green Bay Packers Talk / DakotaT

13h / Green Bay Packers Talk / uffda udfa

17h / Green Bay Packers Talk / DarkaneRules

17h / Green Bay Packers Talk / DarkaneRules

23h / Green Bay Packers Talk / Mucky Tundra

23h / Green Bay Packers Talk / nerdmann

31-Jul / Green Bay Packers Talk / DarkaneRules

31-Jul / Green Bay Packers Talk / Tezzy

31-Jul / Green Bay Packers Talk / nerdmann


Tweeter

Copyright © 2006-2014 PackersHome.com™. All Rights Reserved.