PHP and MySQL· Page 2 · PACKERSHOME

djcubez
Senior Member

15 years ago

dj, would you be willing to help me with this project? You're PHP skills are far superior to mine. I'm only good editing existing code. I could figure it out on my own, but having a genius help me would speed things up for shizzle.

"Zero2Cool" wrote:

I'll see what I can do. Schools a bit heavy now but come this weekend I might be able to set aside some time.

Zero2Cool
Elite Member Topic Starter

15 years ago

#12

"djcubez" wrote:

I'll see what I can do. Schools a bit heavy now but come this weekend I might be able to set aside some time.

"Zero2Cool" wrote:

Oh, you're in school. No worries, I don't want to take up any of your time. I know how it is with school, so no worries bud. 🙂 I'm sure I'll figure it out. You've given me a great starting point. Thanks.

Formo
Veteran Member

15 years ago

#13

I'm not sure this will help you understand, my comments might not be helpful if you're just learning.

Save this as "pickem.php":

&lt;!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"&gt;
&lt;html xmlns="http://www.w3.org/1999/xhtml"&gt;
&lt;head&gt;
&lt;meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /&gt;
&lt;title&gt;Untitled Poop&lt;/title&gt;
&lt;/head&gt;

-=snip snip=-

"djcubez" wrote:

Thanks to TheViking88 for the sig!!

Porforis
Veteran Member

15 years ago

#14

lol 4chan?

dhpackr
Registered

15 years ago

#15

did u get ur form to work??
i work with php/mysql database driven forms A LOT.
check boxes,radio buttons, drop down lists all the time.
i do not think the code posted is correct.
keep in mind u may have to edit more than 1 file and 1 function.

is there a template file
a class file
and a db file
and a index file
so to get the data to post to the database, and display on the form u may have to edit more than 1 file and 1 function. also, do you want to edit the selection, and give the user the ability to change a selection.

PHP is like c or java. u may need to edit a class and the functions within that class.

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

#16

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.

dhpackr
Registered

15 years ago

#17

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

Zero2Cool
Elite Member Topic Starter

15 years ago

#18

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.

dhpackr
Registered

15 years ago

#19

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

Pack93z
Select Member

15 years ago

#20

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

"The oranges are dry; the apples are mealy; and the papayas... I don't know what's going on with the papayas!"

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 (2h) : I would have otherwise admirably served

dfosterf (4h) : Also, no more provision for a write-in candidate, so Martha is off the table at least for this year

dfosterf (4h) : You do have to interpret the boring fine print, but all stockholders all see he is on the ballot

dfosterf (4h) : It also says he is subject to another ballot in 2028. I recall nothing of this nature with Murphy

dfosterf (4h) : Ed Policy is on my ballot subject to me penciling him in as a no.

dfosterf (4h) : I thought it used to be we voted for the whatever they called the 45, and then they voted for the seven, and then they voted for Mark Murphy

dfosterf (4h) : Because I was too lazy to change my address, I haven't voted fot years until this year

dfosterf (4h) : of the folks that run this team. I do not recall Mark Murphy being subject to our vote.

dfosterf (4h) : Ed Policy yay or nay is on the pre-approved ballot that we always approve because we are uninformed and lazy, along with all the rest

dfosterf (4h) : Weird question. Very esoteric. For stockholders. Also lengthy. Sorry. Offseason.

Zero2Cool (9h) : Maybe wicked wind chill made it worse?

Mucky Tundra (16h) : And then he signs with Cleveland in the offseason

Mucky Tundra (16h) : @SharpFootball WR Diontae Johnson just admitted he refused to enter a game in 41° weather last year in Baltimore because he felt “ice cold”

Zero2Cool (24-Jun) : Yawn. Rodgers says he is "pretty sure" this be final season.

Zero2Cool (23-Jun) : PFT claims Packers are having extension talks with Zach Tom, Quay Walker.

Mucky Tundra (20-Jun) : GB-Minnesota 2004 Wild Card game popped up on my YouTube page....UGH

beast (20-Jun) : Hmm 🤔 re-signing Walker before Tom? Sounds highly questionable to me.

Mucky Tundra (19-Jun) : One person on Twitter=cannon law

Zero2Cool (19-Jun) : Well, to ONE person on Tweeter

Zero2Cool (19-Jun) : According to Tweeter

Zero2Cool (19-Jun) : Packers are working on extension for LT Walker they hope to have done before camp

dfosterf (18-Jun) : E4B landed at Andrews last night

dfosterf (18-Jun) : 101 in a 60

dfosterf (18-Jun) : FAFO

Zero2Cool (18-Jun) : one year $4m with incentives to make it up to $6m

dfosterf (18-Jun) : Or Lions

dfosterf (18-Jun) : Beats the hell out of a Vikings signing

Zero2Cool (18-Jun) : Baltimore Ravens now have signed former Packers CB Jaire Alexander.

dfosterf (14-Jun) : TWO magnificent strikes for touchdowns. Lose the pennstate semigeezer non nfl backup

dfosterf (14-Jun) : There was minicamp Thursday. My man Taylor Engersma threw

dfosterf (11-Jun) : There will be a mini camp practice Thursday.

Zero2Cool (11-Jun) : He's been sporting a ring for a while now. It's probably Madonna.

Martha Careful (10-Jun) : We only do the tea before whoopee, it relaxes me.

wpr (10-Jun) : That's awesome Martha.

Mucky Tundra (10-Jun) : How's the ayahuasca tea he makes, Martha?

Martha Careful (10-Jun) : Turns out he like older women

Martha Careful (10-Jun) : I wasn't supposed to say anything, but yes the word is out and we are happy 😂😂😂

Mucky Tundra (10-Jun) : I might be late on this but Aaron Rodgers is now married

Mucky Tundra (10-Jun) : Well he can always ask his brother for pointers

Zero2Cool (10-Jun) : Bo Melton taking some reps at CB as well as WR

Zero2Cool (10-Jun) : key transactions coming today at 3pm that will consume more cap in 2025

Zero2Cool (9-Jun) : Jaire played in just 34 of a possible 68 games since the start of the 2021 season

Zero2Cool (9-Jun) : reported, but not expected to practice

Zero2Cool (9-Jun) : Jenkins has REPORTED for mandatory camp

Zero2Cool (9-Jun) : I really thought he'd play for Packers.

buckeyepackfan (9-Jun) : Packers releasing Jaire Alexander.

Mucky Tundra (8-Jun) : (Context: he wants his defense to create turnovers)

Mucky Tundra (8-Jun) : Giants DC Shane Bowen tells players to “be a damn pirate."

dfosterf (6-Jun) : Semper fi !

Cheesey (6-Jun) : This is why I have so much respect for those that have gone through battles

Please sign in to use Fan Shout

2025 Packers Schedule

Sunday, Sep 7 @ 3:25 PM

LIONS

Thursday, Sep 11 @ 7:15 PM

COMMANDERS

Sunday, Sep 21 @ 12:00 PM

Browns

Sunday, Sep 28 @ 7:20 PM

Cowboys

Sunday, Oct 12 @ 3:25 PM

BENGALS

Sunday, Oct 19 @ 3:25 PM

Cardinals

Sunday, Oct 26 @ 7:20 PM

Steelers

Sunday, Nov 2 @ 12:00 PM

PANTHERS

Monday, Nov 10 @ 7:15 PM

EAGLES

Sunday, Nov 16 @ 12:00 PM

Giants

Sunday, Nov 23 @ 12:00 PM

VIKINGS

Thursday, Nov 27 @ 12:00 PM

Lions

Sunday, Dec 7 @ 12:00 PM

BEARS

Sunday, Dec 14 @ 3:25 PM

Broncos

Friday, Dec 19 @ 11:00 PM

Bears

Friday, Dec 26 @ 11:00 PM

RAVENS

Saturday, Jan 3 @ 11:00 PM

Vikings