getting php code to do as i wish

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
chris_s_22
Forum Commoner
Posts: 76
Joined: Wed Dec 31, 2008 2:05 pm

getting php code to do as i wish

Post by chris_s_22 »

im trying to figure out when a form is filled out each set of players gets the same gameno although if another form was to be submitted the gameno would be unique

if theres a tutorial please send link thx

for example
form1
PLAYER - SEX - GAMENO
player1 - male - 1
player2 - female - 1
player3 - male - 1
player4 - female - 1

form2
PLAYER - SEX - GAMENO
player1 - male - 2
player2 - female - 2
player3 - male - 2
player4 - female - 2

heres the code im working on,

Code: Select all

 
<?php
function create_game($playername0, $sex0, $playername1, $sex1, $playername2, $sex2, $playername3, $sex3, $playername4, $sex4, $playername5, $sex5, $playername6, $sex6, $playername7, $sex7, $playername8, $sex8, $playername9, $sex9, $playername10, $sex10, $playername11, $sex11, $playername12, $sex12, $playername13, $sex13, $playername14, $sex14, $finalscore) 
{
    // store the information in the database
    $query = "INSERT INTO `game` (`name`, `sex`, `finalscore`) values ('$playername0','$sex0','$finalscore')";
    $result = mysql_query($query) or die(mysql_error());
    $query =  "INSERT INTO `game` (`name`, `sex`, `finalscore`) values ('$playername1','$sex1','$finalscore')";
    $result = mysql_query($query) or die(mysql_error());         
    $query =  "INSERT INTO `game` (`name`, `sex`, `finalscore`) values ('$playername2','$sex2','$finalscore')";
    $result = mysql_query($query) or die(mysql_error());         
    $query =  "INSERT INTO `game` (`name`, `sex`, `finalscore`) values ('$playername3','$sex3','$finalscore')";
    $result = mysql_query($query) or die(mysql_error());         
    $query =  "INSERT INTO `game` (`name`, `sex`, `finalscore`) values ('$playername4','$sex4','$finalscore')";
    $result = mysql_query($query) or die(mysql_error());         
    $query =  "INSERT INTO `game` (`name`, `sex`, `finalscore`) values ('$playername5','$sex5','$finalscore')";
    $result = mysql_query($query) or die(mysql_error());         
    $query =  "INSERT INTO `game` (`name`, `sex`, `finalscore`) values ('$playername6','$sex6','$finalscore')";
    $result = mysql_query($query) or die(mysql_error());         
    $query =  "INSERT INTO `game` (`name`, `sex`, `finalscore`) values ('$playername7','$sex7','$finalscore')";
    $result = mysql_query($query) or die(mysql_error());         
    $query =  "INSERT INTO `game` (`name`, `sex`, `finalscore`) values ('$playername8','$sex8','$finalscore')";
    $result = mysql_query($query) or die(mysql_error());         
    $query =  "INSERT INTO `game` (`name`, `sex`, `finalscore`) values ('$playername9','$sex9','$finalscore')";
    $result = mysql_query($query) or die(mysql_error());         
    $query =  "INSERT INTO `game` (`name`, `sex`, `finalscore`) values ('$playername10','$sex10','$finalscore')";
    $result = mysql_query($query) or die(mysql_error());         
    $query =  "INSERT INTO `game` (`name`, `sex`, `finalscore`) values ('$playername11','$sex11','$finalscore')";
    $result = mysql_query($query) or die(mysql_error());         
    $query =  "INSERT INTO `game` (`name`, `sex`, `finalscore`) values ('$playername12','$sex12','$finalscore')";
    $result = mysql_query($query) or die(mysql_error());         
    $query =  "INSERT INTO `game` (`name`, `sex`, `finalscore`) values ('$playername13','$sex13','$finalscore')";
    $result = mysql_query($query) or die(mysql_error());         
    $query =  "INSERT INTO `game` (`name`, `sex`, `finalscore`) values ('$playername14','$sex14','$finalscore')";
    $result = mysql_query($query) or die(mysql_error());
 
    // if suceesfully inserted data into database, send confirmation link to email 
    if($result) 
    {
    header('Location: [url=http://www.pinkangel4u.com/truthdare/Game/gameboard.php');]http://www.pinkangel4u.com/truthdare/Game/...oard.php');[/url]
    }
}
?>
 
User avatar
paqman
Forum Contributor
Posts: 125
Joined: Sun Nov 14, 2004 7:41 pm
Location: Burnaby, BC, Canada

Re: getting php code to do as i wish

Post by paqman »

Can you explain your goal a little more? So you have 4 players per game? What does your form look like, and does the game number just increment each time you add another one?
User avatar
papa
Forum Regular
Posts: 958
Joined: Wed Aug 27, 2008 3:36 am
Location: Sweden/Sthlm

Re: getting php code to do as i wish

Post by papa »

Create a game table in mysql that stores game_id date with auto incremented game_id and some other relevant info and then have a table that stores the players and retrieves the unique game_id from game using mysql_insert_id.
Post Reply