Welcome Guest! You can login or register.
Login or Register.
#1
Posted
:
Tuesday, September 8, 2009 12:27:07 AM(UTC)
Joined: 10/13/2006(UTC)
Location: Green Bay, WI
Applause Given: 2,802
Applause Received: 4,982
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.asplol
#2
Posted
:
Tuesday, September 8, 2009 1:04:32 AM(UTC)
Joined: 8/7/2008(UTC)
Applause Given: 161
Applause Received: 138
I have no idea what you are talking about, but thanks for keeping this site running!
#3
Posted
:
Tuesday, September 8, 2009 1:34:41 AM(UTC)
Joined: 8/7/2008(UTC)
Location: Madison
Applause Given: 11
Applause Received: 17
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":
Code:<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Poop</title>
</head>
<?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 "<strong>You picked the following winners:</strong><br />";
// 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 <= 16; $x++) {
// check games
if($x < 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 "<br /><br />";
}
}
?>
<body>
<form action="pickem.php?picks=yes" method="post">
<table width="372" border="1">
<tr>
<td colspan="4"><div align="center">Week One </div></td>
</tr>
<tr>
<td width="56">Thursday</td>
<td width="127"><input name="rdoGame01" type="radio" value="Titans" />
Tenneesee </td>
<td width="17">at</td>
<td width="144"><input name="rdoGame01" type="radio" value="Steelers" />
Pittsburgh</td>
</tr>
<tr>
<td height="24">Sunday</td>
<td><input name="rdoGame02" type="radio" value="Dolphins" />
Miami </td>
<td>at</td>
<td><input name="rdoGame02" type="radio" value="Falcons" />
Atlanta</td>
</tr>
<tr>
<td>Sunday</td>
<td><input name="rdoGame03" type="radio" value="Broncos" />
Denver </td>
<td>at</td>
<td><input name="rdoGame03" type="radio" value="Bengals" />
Cincinnati</td>
</tr>
<tr>
<td>Sunday</td>
<td><input name="rdoGame04" type="radio" value="Packers" />
Minnesota </td>
<td>at</td>
<td><input name="rdoGame04" type="radio" value="Packers" />
Cleveland</td>
</tr>
<tr>
<td>Sunday</td>
<td><input name="rdoGame05" type="radio" value="Packers" />
Jacksonville </td>
<td>at</td>
<td><input name="rdoGame05" type="radio" value="Packers" />
Indianapolis</td>
</tr>
<tr>
<td>Sunday</td>
<td><input name="rdoGame06" type="radio" value="Packers" />
Detroit </td>
<td>at</td>
<td><input name="rdoGame06" type="radio" value="Packers" />
New Orleans</td>
</tr>
<tr>
<td>Sunday</td>
<td><input name="rdoGame07" type="radio" value="Packers" />
Dallas </td>
<td>at</td>
<td><input name="rdoGame07" type="radio" value="Packers" />
Tampa Bay</td>
</tr>
<tr>
<td>Sunday</td>
<td><input name="rdoGame08" type="radio" value="Packers" />
Philadelphia </td>
<td>at</td>
<td><input name="rdoGame08" type="radio" value="Packers" />
Carolina</td>
</tr>
<tr>
<td>Sunday</td>
<td><input name="rdoGame09" type="radio" value="Packers" />
Kansas City</td>
<td>at</td>
<td><input name="rdoGame09" type="radio" value="Packers" />
Baltimore</td>
</tr>
<tr>
<td>Sunday</td>
<td><input name="rdoGame10" type="radio" value="Packers" />
NY Jets</td>
<td>at</td>
<td><input name="rdoGame10" type="radio" value="Packers" />
Houston</td>
</tr>
<tr>
<td>Sunday</td>
<td><input name="rdoGame11" type="radio" value="Packers" />
Washington </td>
<td>at</td>
<td><input name="rdoGame11" type="radio" value="Packers" />
NY Giants</td>
</tr>
<tr>
<td>Sunday</td>
<td><input name="rdoGame12" type="radio" value="Packers" />
San Francisco</td>
<td>at</td>
<td><input name="rdoGame12" type="radio" value="Packers" />
Arizona</td>
</tr>
<tr>
<td>Sunday</td>
<td><input name="rdoGame13" type="radio" value="Packers" />
St. Louis</td>
<td>at</td>
<td><input name="rdoGame13" type="radio" value="Packers" />
Seattle</td>
</tr>
<tr>
<td>Sunday</td>
<td><input name="rdoGame14" type="radio" value="Packers" />
Chicago </td>
<td>at</td>
<td><input name="rdoGame14" type="radio" value="Packers" />
Green Bay</td>
</tr>
<tr>
<td>Monday</td>
<td><input name="rdoGame15" type="radio" value="Packers" />
Buffalo </td>
<td>at</td>
<td><input name="rdoGame15" type="radio" value="Packers" />
New England</td>
</tr>
<tr>
<td>Monday</td>
<td><input name="rdoGame16" type="radio" value="Packers" />
San Diego</td>
<td>at</td>
<td><input name="rdoGame16" type="radio" value="Packers" />
Oakland</td>
</tr>
</table>
<div><input type="submit" value="Submit Picks" /></div></form>
<p> </p>
</body>
</html>
#4
Posted
:
Tuesday, September 8, 2009 2:27:53 AM(UTC)
Joined: 10/13/2006(UTC)
Location: Green Bay, WI
Applause Given: 2,802
Applause Received: 4,982
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.
#5
Posted
:
Tuesday, September 8, 2009 10:48:30 AM(UTC)
Joined: 9/14/2008(UTC)
Applause Given: 107
Applause Received: 379
good job dj +1 for the code
#6
Posted
:
Tuesday, September 8, 2009 11:00:09 AM(UTC)
Joined: 9/14/2008(UTC)
Applause Given: 273
Applause Received: 431
" said: 
I have no idea what you are talking about, but thanks for keeping this site running!
#7
Posted
:
Tuesday, September 8, 2009 12:25:50 PM(UTC)
Joined: 8/22/2009(UTC)
Location: Milwaukee, WI
Applause Given: 445
Applause Received: 829
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. :P
#8
Posted
:
Tuesday, September 8, 2009 12:56:17 PM(UTC)
Joined: 9/28/2008(UTC)
Location: Nottingham, UK
Applause Given: 2
Applause Received: 18
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
#9
Posted
:
Tuesday, September 8, 2009 3:03:42 PM(UTC)
Joined: 8/7/2008(UTC)
Location: Madison
Applause Given: 11
Applause Received: 17
" said: 
good job dj +1 for the code
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.
#10
Posted
:
Tuesday, September 8, 2009 5:51:39 PM(UTC)
Joined: 10/13/2006(UTC)
Location: Green Bay, WI
Applause Given: 2,802
Applause Received: 4,982
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.
#11
Posted
:
Wednesday, September 9, 2009 12:16:53 AM(UTC)
Joined: 8/7/2008(UTC)
Location: Madison
Applause Given: 11
Applause Received: 17
" said: 
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.
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.
#12
Posted
:
Wednesday, September 9, 2009 8:57:14 AM(UTC)
Joined: 10/13/2006(UTC)
Location: Green Bay, WI
Applause Given: 2,802
Applause Received: 4,982
" said: 
" said: 
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.
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.
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.
#13
Posted
:
Wednesday, September 9, 2009 3:03:53 PM(UTC)
Joined: 8/12/2008(UTC)
Applause Given: 216
Applause Received: 159
" said: 
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":
Code:<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Poop</title>
</head>
-=snip snip=-

#14
Posted
:
Wednesday, September 9, 2009 4:31:03 PM(UTC)
Joined: 8/22/2009(UTC)
Location: Milwaukee, WI
Applause Given: 445
Applause Received: 829
#15
Posted
:
Wednesday, September 9, 2009 8:43:17 PM(UTC)
Joined: 12/12/2007(UTC)
Applause Given: 36
Applause Received: 36
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.
#16
Posted
:
Wednesday, September 9, 2009 8:53:32 PM(UTC)
Joined: 10/13/2006(UTC)
Location: Green Bay, WI
Applause Given: 2,802
Applause Received: 4,982
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.
#17
Posted
:
Wednesday, September 9, 2009 9:11:44 PM(UTC)
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.
#18
Posted
:
Wednesday, September 9, 2009 11:14:34 PM(UTC)
Joined: 10/13/2006(UTC)
Location: Green Bay, WI
Applause Given: 2,802
Applause Received: 4,982
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.
#19
Posted
:
Thursday, September 10, 2009 4:30:29 PM(UTC)
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.
#20
Posted
:
Thursday, September 10, 2009 4:35:02 PM(UTC)
Joined: 3/16/2007(UTC)
Location: North Central Wisconsin
Applause Given: 444
Applause Received: 1,252
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..
Users browsing this topic
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.