PHP and MySQL · PACKERSHOME

Zero2Cool
Elite Member Topic Starter

15 years ago

Okay, effective, umm, now. No more host switching until next off season. I'm going to focus on learning PHP in a similar fashion that I know ASP.NET.

Click HERE to see the page.

Building the form, easy.
Coding the connection to the database, easy.
Grabbing the values from the radio buttons and storing them into variables to transfer to a database, kicking my ass.

I think I'm attacking this wrong because I'm using HTML code, but shouldn't I be able to use straight PHP code throughout?

Edit, here's how I'm starting out ...
http://w3schools.com/php/php_syntax.asp

lol

Wanna join the discussion?! Login to your PACKERSHOME forum account or Register a new forum account

IronMan
Veteran Member

15 years ago

I have no idea what you are talking about, but thanks for keeping this site running!

djcubez
Senior Member

15 years ago

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;

&lt;?php 
// start php

// see if the GET variable "picks" is set
if(isset($_GET["picks"])) {
	// if picks is equal to "yes" proceed
	if($_GET["picks"] == "yes") {
		echo "&lt;strong&gt;You picked the following winners:&lt;/strong&gt;&lt;br /&gt;";
		// if the GET variable "picks" is set, show picks
		// variables for the form are stored in an array called $_POST[]
		// the value for the array is the name of the input field i.e., rdoGame01
		// go through the post variable and display picks
		// assign variables
		$games = 16;	// number of games
		// if variable $x is less than the total number of games, add 1 to $x
		for($x = 0; $x &lt;= 16; $x++) {
			// check games
			if($x &lt; 10) {
				$x = "0" . $x . "";
			}
			if(isset($_POST["rdoGame" . $x . ""])) {
				// do whatever you want with each game right here
				if($x != "1") {echo ", ";}
				echo $_POST["rdoGame" . $x . ""] . "";
			}
		}
		echo "&lt;br /&gt;&lt;br /&gt;";
	}
}

?>

&lt;body&gt;
&lt;form action="pickem.php?picks=yes" method="post"&gt;
&lt;table width="372" border="1"&gt;
  &lt;tr&gt;
    &lt;td colspan="4"&gt;&lt;div align="center"&gt;Week One &lt;/div&gt;&lt;/td&gt;
  &lt;/tr&gt;

  &lt;tr&gt;
    &lt;td width="56"&gt;Thursday&lt;/td&gt;
    &lt;td width="127"&gt;&lt;input name="rdoGame01" type="radio" value="Titans" /&gt;
      Tenneesee &lt;/td&gt;
    &lt;td width="17"&gt;at&lt;/td&gt;
    &lt;td width="144"&gt;&lt;input name="rdoGame01" type="radio" value="Steelers" /&gt;
      Pittsburgh&lt;/td&gt;

  &lt;/tr&gt;
 &lt;tr&gt;
    &lt;td height="24"&gt;Sunday&lt;/td&gt;
    &lt;td&gt;&lt;input name="rdoGame02" type="radio" value="Dolphins" /&gt;
      Miami &lt;/td&gt;
    &lt;td&gt;at&lt;/td&gt;
    &lt;td&gt;&lt;input name="rdoGame02" type="radio" value="Falcons" /&gt;

      Atlanta&lt;/td&gt;
  &lt;/tr&gt;
  &lt;tr&gt;
    &lt;td&gt;Sunday&lt;/td&gt;
    &lt;td&gt;&lt;input name="rdoGame03" type="radio" value="Broncos" /&gt;
      Denver &lt;/td&gt;
    &lt;td&gt;at&lt;/td&gt;

    &lt;td&gt;&lt;input name="rdoGame03" type="radio" value="Bengals" /&gt;
      Cincinnati&lt;/td&gt;
  &lt;/tr&gt;
  &lt;tr&gt;
    &lt;td&gt;Sunday&lt;/td&gt;
    &lt;td&gt;&lt;input name="rdoGame04" type="radio" value="Packers" /&gt;
      Minnesota &lt;/td&gt;

    &lt;td&gt;at&lt;/td&gt;
    &lt;td&gt;&lt;input name="rdoGame04" type="radio" value="Packers" /&gt;
      Cleveland&lt;/td&gt;
  &lt;/tr&gt;
  &lt;tr&gt;
    &lt;td&gt;Sunday&lt;/td&gt;
    &lt;td&gt;&lt;input name="rdoGame05" type="radio" value="Packers" /&gt;

      Jacksonville &lt;/td&gt;
    &lt;td&gt;at&lt;/td&gt;
    &lt;td&gt;&lt;input name="rdoGame05" type="radio" value="Packers" /&gt;
      Indianapolis&lt;/td&gt;
  &lt;/tr&gt;
  &lt;tr&gt;
    &lt;td&gt;Sunday&lt;/td&gt;

    &lt;td&gt;&lt;input name="rdoGame06" type="radio" value="Packers" /&gt;
      Detroit &lt;/td&gt;
    &lt;td&gt;at&lt;/td&gt;
    &lt;td&gt;&lt;input name="rdoGame06" type="radio" value="Packers" /&gt;
      New Orleans&lt;/td&gt;
  &lt;/tr&gt;
  &lt;tr&gt;

    &lt;td&gt;Sunday&lt;/td&gt;
    &lt;td&gt;&lt;input name="rdoGame07" type="radio" value="Packers" /&gt;
      Dallas &lt;/td&gt;
    &lt;td&gt;at&lt;/td&gt;
    &lt;td&gt;&lt;input name="rdoGame07" type="radio" value="Packers" /&gt;
      Tampa Bay&lt;/td&gt;
  &lt;/tr&gt;

  &lt;tr&gt;
    &lt;td&gt;Sunday&lt;/td&gt;
    &lt;td&gt;&lt;input name="rdoGame08" type="radio" value="Packers" /&gt;
      Philadelphia &lt;/td&gt;
    &lt;td&gt;at&lt;/td&gt;
    &lt;td&gt;&lt;input name="rdoGame08" type="radio" value="Packers" /&gt;
      Carolina&lt;/td&gt;

  &lt;/tr&gt;
  &lt;tr&gt;
    &lt;td&gt;Sunday&lt;/td&gt;
    &lt;td&gt;&lt;input name="rdoGame09" type="radio" value="Packers" /&gt;
      Kansas City&lt;/td&gt;
    &lt;td&gt;at&lt;/td&gt;
    &lt;td&gt;&lt;input name="rdoGame09" type="radio" value="Packers" /&gt;

      Baltimore&lt;/td&gt;
  &lt;/tr&gt;
  &lt;tr&gt;
    &lt;td&gt;Sunday&lt;/td&gt;
    &lt;td&gt;&lt;input name="rdoGame10" type="radio" value="Packers" /&gt;
      NY Jets&lt;/td&gt;
    &lt;td&gt;at&lt;/td&gt;

    &lt;td&gt;&lt;input name="rdoGame10" type="radio" value="Packers" /&gt;
      Houston&lt;/td&gt;
  &lt;/tr&gt;
  &lt;tr&gt;
    &lt;td&gt;Sunday&lt;/td&gt;
    &lt;td&gt;&lt;input name="rdoGame11" type="radio" value="Packers" /&gt;
      Washington &lt;/td&gt;

    &lt;td&gt;at&lt;/td&gt;
    &lt;td&gt;&lt;input name="rdoGame11" type="radio" value="Packers" /&gt;
      NY Giants&lt;/td&gt;
  &lt;/tr&gt;
  &lt;tr&gt;
    &lt;td&gt;Sunday&lt;/td&gt;
    &lt;td&gt;&lt;input name="rdoGame12" type="radio" value="Packers" /&gt;

      San Francisco&lt;/td&gt;
    &lt;td&gt;at&lt;/td&gt;
    &lt;td&gt;&lt;input name="rdoGame12" type="radio" value="Packers" /&gt;
      Arizona&lt;/td&gt;
  &lt;/tr&gt;
  &lt;tr&gt;
    &lt;td&gt;Sunday&lt;/td&gt;

    &lt;td&gt;&lt;input name="rdoGame13" type="radio" value="Packers" /&gt;
      St. Louis&lt;/td&gt;
    &lt;td&gt;at&lt;/td&gt;
    &lt;td&gt;&lt;input name="rdoGame13" type="radio" value="Packers" /&gt;
      Seattle&lt;/td&gt;
  &lt;/tr&gt;
  &lt;tr&gt;

    &lt;td&gt;Sunday&lt;/td&gt;
    &lt;td&gt;&lt;input name="rdoGame14" type="radio" value="Packers" /&gt;
      Chicago &lt;/td&gt;
    &lt;td&gt;at&lt;/td&gt;
    &lt;td&gt;&lt;input name="rdoGame14" type="radio" value="Packers" /&gt;
      Green Bay&lt;/td&gt;
  &lt;/tr&gt;

  &lt;tr&gt;
    &lt;td&gt;Monday&lt;/td&gt;
    &lt;td&gt;&lt;input name="rdoGame15" type="radio" value="Packers" /&gt;
      Buffalo &lt;/td&gt;
    &lt;td&gt;at&lt;/td&gt;
    &lt;td&gt;&lt;input name="rdoGame15" type="radio" value="Packers" /&gt;
      New England&lt;/td&gt;

  &lt;/tr&gt;
  &lt;tr&gt;
    &lt;td&gt;Monday&lt;/td&gt;
    &lt;td&gt;&lt;input name="rdoGame16" type="radio" value="Packers" /&gt;
      San Diego&lt;/td&gt;
    &lt;td&gt;at&lt;/td&gt;
    &lt;td&gt;&lt;input name="rdoGame16" type="radio" value="Packers" /&gt;

      Oakland&lt;/td&gt;
  &lt;/tr&gt;
 
&lt;/table&gt;
&lt;div&gt;&lt;input type="submit" value="Submit Picks" /&gt;&lt;/div&gt;&lt;/form&gt;
&lt;p&gt;&nbsp;&lt;/p&gt;
&lt;/body&gt;
&lt;/html&gt;

Zero2Cool
Elite Member Topic Starter

15 years ago

Very awesome of you, thank you for taking the time to do that. Unfortunately, I have to go to sleep now, but hopefully I can spend some time on this tomorrow.

dhazer
Veteran Member

15 years ago

good job dj +1 for the code

Just Imagine this for the next 6-9 years. What a ride it will be 🙂 (PS, Zero should charge for this)

Rockmolder
Honored Member

15 years ago

I have no idea what you are talking about, but thanks for keeping this site running!

"IronMan" wrote:

Porforis
Veteran Member

15 years ago

As crazy inefficient as it is, this makes me miss Visual Basic (6, of course. None of that .net sorcery). As a kid I'd spend afternoons and weekends experimenting with code, not having the slightest clue what I was doing until I got it to work and figured out why. Nowadays I'm working with shell scripts (linux), I miss that fluid feel VB6 had. Didn't miss having to make API calls for some more advanced graphical manipulation and trying to learn directx, but at its core it was streamlined and not as unusable for higher-end applications as most people say...

Regardless, a bit off-topic I suppose. I guess some people like making websites, some people like making computer games, and then there's database nerds. 😛

Grabacr
Member

15 years ago

Hooray...only spent $20000 on college so far and i understand the code....the system works!

good job man. Will have to see what i come up with in my spare time when im back at college

djcubez
Senior Member

15 years ago

good job dj +1 for the code

"dhazer" wrote:

Maybe I'll finally have to take you off my ignore list now :P

I feel like I click to read your posts half the time anyway hah.

@DKF295: I remember being a kid (not too long ago, in fact i'm probably still one now) and doing the same thing, albeit with websites. My dad was a website designer for over a decade so I kind of picked up the tools of the trade at a young age--not because I had too but because I found it fun.

@grabacr: I haven't learned an ounce about PHP or web design in college. In fact my teacher gave me a B in my web design course because she disliked that I knew almost everything already. I'm not saying I'm a genius or anything or that you won't learn anything in college, I just happen to learn things better on my own.

Zero2Cool
Elite Member Topic Starter

15 years ago

#10

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.

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

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

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

Mucky Tundra (11h) : @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

Cheesey (6-Jun) : I can't even imagine what that would have been like

wpr (6-Jun) : "Come on, you sons of bitches. Do you want to live forever?"

wpr (6-Jun) : Facing a line of machine guns 2 time medal of Honor recipient, First Sergeant Dan Daly told his men,

wpr (6-Jun) : Another detachment went into the Belleau Wood.

wpr (6-Jun) : On the 6th the Marines took Hill 142 but suffered terrible losses.

wpr (6-Jun) : It’s time to remember dfoster’s Marine brothers in Belleau Wood. The battle went on from June 1-26. Nearly 10,000 casualties.

packerfanoutwest (6-Jun) : Nick Collins and Morgan Burnett have signed with the PACK

packerfanoutwest (6-Jun) : he won't be wearing #12, maybe he will wear number two

packerfanoutwest (6-Jun) : He will fail this season, should have retired

Mucky Tundra (5-Jun) : Thus the cycle of Hall of Fame Packer QBs going to the Jets and then the Vikings is broken

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