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 (2h) : This page was generated in 0.135 seconds.

Mucky Tundra (2h) : Tbh, I can never tell the difference in speed unless it's completely shitting the bed

Zero2Cool (3h) : Sure does feel like site is more snappy

Zero2Cool (6h) : I thought that was the Lions OL

Mucky Tundra (7h) : Travis Glover placed on IR; seasons over for him

Zero2Cool (11h) : found bad sql in database, maybe site faster now?

dfosterf (5-Aug) : I'm going to call that a good move.

Zero2Cool (4-Aug) : Packers sign CB Corey Ballentine

Zero2Cool (4-Aug) : I'm not sure how to kill the draft order just yet so it's not so confusing.

Mucky Tundra (4-Aug) : *to be able

Mucky Tundra (4-Aug) : and because it's not a dynasty league (which makes a lot more sense to be ability to trade picks)

Mucky Tundra (4-Aug) : Oh I know; I was just exploring and it blew my mind that you could trade picks because of the whole reordering thing

Mucky Tundra (4-Aug) : Zero, I think I preferred my offer: your 1st for my 15th rounder

Zero2Cool (4-Aug) : Keep in mind, we do a draft reorder once all members locked in

Zero2Cool (4-Aug) : You can have my 12th Rd for your 2nd round

Mucky Tundra (4-Aug) : Hey i didn't know we could trade picks in fantasy

Mucky Tundra (3-Aug) : Update: Rock has tried a cheese curd, promises it's not his last

Zero2Cool (3-Aug) : watch it!! lol

Mucky Tundra (3-Aug) : you're right, we never did leave, the site just went down :P

Mucky Tundra (3-Aug) : Rock claims to have never eaten a cheese curd

Zero2Cool (3-Aug) : We did not leave.

Mucky Tundra (3-Aug) : Family Night! WE ARE SO BACK!

Mucky Tundra (2-Aug) : To this day, I'm still miffed about his 4 TD game against Dallas on Thanksgiving going to waste

Martha Careful (2-Aug) : Congratulations Sterling Sharpe. He was terrific and I loved watching him play.

beast (2-Aug) : I believe it's technically against the CBA rules, but Jerry just calls it a simple unofficial chat... and somehow gets away with it.

beast (2-Aug) : Jerry Jones is infamous for ̶n̶e̶g̶o̶t̶i̶a̶t̶i̶n̶g̶ chatting with players one on one... and going around the agent.

Mucky Tundra (1-Aug) : Oo just saw a blurb saying that Dallas negotiated directly with Parsons and not through his agent

Mucky Tundra (1-Aug) : I assumed that both guys will get paid, just a matter of when or how we get there

Zero2Cool (1-Aug) : McLaurin nor Micah going anywhere. They will get money

Mucky Tundra (1-Aug) : the Synder years or do they take care of one of their own?

Mucky Tundra (1-Aug) : Do the Commanders risk losing a top WR with an emerging QB just because he's turning 30 and potentially risk damaging the rebuild from

Mucky Tundra (1-Aug) : Turns 30 this September, plays at a high level and Washington has some cap space I believe

Mucky Tundra (1-Aug) : More interesting is Washington with Terry McLaurin

Mucky Tundra (1-Aug) : I would imagine Dallas will resolve this issue with a truckload of money

Zero2Cool (1-Aug) : Micah pulling a Myles with trade request

beast (1-Aug) : Packers should make some cheese forks

Mucky Tundra (31-Jul) : GRAB THE PITCHFORKS~

Zero2Cool (31-Jul) : CUT HIM

Mucky Tundra (31-Jul) : Socieltal collapse imminent

Mucky Tundra (31-Jul) : The West has fallen

Mucky Tundra (31-Jul) : After starting off camp with 25 straight made field goals, Brandon McManus has missed one

Zero2Cool (31-Jul) : But it should be stable

Zero2Cool (31-Jul) : It's probably gonna be slower.

Zero2Cool (31-Jul) : We're gonna just full go on to the new host.

Zero2Cool (31-Jul) : What crap. Site issues galore

Zero2Cool (30-Jul) : if PH dies, there is packerpeople com available

Zero2Cool (30-Jul) : database is on new host, eventually website will follow

Mucky Tundra (30-Jul) : Zero, regarding Ewers, you are correct.

Zero2Cool (30-Jul) : Sadly, this might be our life for awhile. I could put it on another host, but seems it was slower, although more stable

beast (30-Jul) : How long will it be down?

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