Мне нужна помощь с Php-формами. Я пытаюсь вставить в MySQL как минимум 2 и максимум 3 данных игроков команды для регистрации.
Используя цикл для получения трех значений формы и итерации до тех пор, пока данные не будут сохранены в таблицах
Первая таблица – таблица Players: имена столбцов следующие.
playerid, playerfirstname, имя игрока, playerdob, playernationalranking, playerphonenumber, playeremailaddress, playerpassportnumber, playerplayinghistory, playeraddress, playpartountry
Вторая таблица – таблица участников: имена столбцов следующие.
playerid, participtionid, championid, countryid, created_at, статус (удален или нет), room_booking_status
Третья таблица – ссылки на фото
Время, FileLocation, IP, idUsers, playerid
Кроме того, мне нужно вставить четвертую таблицу и таблицу teamplayers: имена столбцов следующие.
Teamid, participtionid, countryid, idplayer1, idplayer2, idplayer3, TimeStamp
PHP-код начинается следующим образом:
if (!isset($_SESSION)) { session_start(); } $editFormAction = $_SERVER['PHP_SELF']; if (isset($_SERVER['QUERY_STRING'])) { $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']); } $colname_numRows = "-1"; if (isset($_SESSION['MM_UserGroup'])) { $colname_numRows = $_SESSION['MM_UserGroup']; } if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) { for($i=1;$i<4;$i++) { // combining date of birth $playerDob = $_POST['year'.$i]."-".$_POST['month'.$i]."-".$_POST['day'.$i]; $playerDob = mysql_real_escape_string($playerDob); // first query $insertPlayerInfo = sprintf("INSERT INTO players (playerid, playerfirstname, playerlastname, playerdob, playernationalranking, playerphonenumber, playeremailaddress, playerpassportnumber, playerplayinghistory, playeraddress, playercountry) VALUES ('', %s, %s, '$playerDob', %s, %s, %s, %s, %s, %s, %s)", GetSQLValueString(str_replace('\' ', '\'', ucwords(str_replace('\'', '\' ', strtolower($_POST['playerFirstName'.$i])))), "text"), GetSQLValueString(str_replace('\' ', '\'', ucwords(str_replace('\'', '\' ', strtolower($_POST['playerLastName'.$i])))), "text"), GetSQLValueString($_POST['playerNationalRanking'.$i], "int"), GetSQLValueString($_POST['playerPhoneNumber'.$i], "text"), GetSQLValueString($_POST['playerEmailAddress'.$i], "text"), GetSQLValueString($_POST['playerPassportNumber'.$i], "text"), GetSQLValueString($_POST['playerPlayingHistory'.$i], "text"), GetSQLValueString($_POST['playerAddress'.$i], "text"), GetSQLValueString($_POST['playerCountryID'.$i], "int")); mysql_select_db($db, $EntrySystem); if($myPlayerInfoResult = mysql_query($insertPlayerInfo, $EntrySystem)) { $_SESSION['playerid'.$i] = mysql_insert_id($EntrySystem) or die(mysql_error()); // second query $insertSQL = sprintf("INSERT INTO participants (playerid, participationid, championshipid, countryid, created_at, status, room_booking_status) VALUES ('".$_SESSION['playerid'.$i]."','', %s, %s, %s, '1', '0')", GetSQLValueString($_POST['championshipid'], "int"), GetSQLValueString($_POST['countryid'], "int"), GetSQLValueString($_POST['created_at'], "date")); mysql_select_db($db, $EntrySystem); if($myInsertSQL = mysql_query($insertSQL, $EntrySystem)) { // if successfully submitted, proceed to next page $participationid = mysql_insert_id($EntrySystem)or die(mysql_error()); $_SESSION['participationid'.$i] = $participationid; } if(!is_dir("upload/".$_SESSION['MM_Username'])) { mkdir("upload/".$_SESSION['MM_Username']); } function savedata(){ global $_FILES, $_POST, $putItAt; $sql = "INSERT INTO `db`.`photos` ( `Time`, `FileLocation`, `IP`, `countryid`, `participationid`) VALUES (NOW(),'".mysql_real_escape_string($putItAt)."', '". $_SERVER['REMOTE_ADDR']."', '". $_SESSION['MM_UserGroup']."' ,'" .$_SESSION['participationid'.$i]."');"; mysql_query($sql) or die(mysql_error()); } $putItAt = "upload/".$_SESSION['MM_Username']."/" .sha1(rand())."-" .basename($_FILES['uploadedfile'.$i]['name']); $putItAt = str_replace("php", "txt" , $putItAt); if(move_uploaded_file($_FILES['uploadedfile'.$i]['tmp_name'],$putItAt)) { savedata(); } else { if(copy($_FILES['uploadedfile'.$i]['tmp_name'],$putItAt)) { savedata(); } else { echo 'Image upload has not been successful. go back and try again.'; } } // Ids mysql_select_db($db, $EntrySystem); $insertTeamInfo = sprintf("INSERT INTO teamPlayers (Teamid, participationid, countryid, idplayer1, idplayer2, idplayer3, TimeStamp) VALUES('','".$_SESSION['participationid']."', %s,'".$_SESSION['playerID1']."', '".$_SESSION['playerID2']."', '".$_SESSION['playerID3']."','')", GetSQLValueString($_POST['countryid'], "int")); mysql_query($insertTeamInfo) or die(mysql_error()); $insertGoTo = "myentries.php"; if (isset($_SERVER['QUERY_STRING'])) { $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?"; $insertGoTo .= $_SERVER['QUERY_STRING']; } header(sprintf("Location: %s", $insertGoTo)); } } } HTML-форма идет здесь …
<form enctype="multipart/form-data" method="post" name="form1" action="<?php echo $editFormAction; ?>"> <table width="100%"> <tr> <td align="center"> <label> <p>Select Championship</p> </label> <select name="championshipid"> <option>Select championship..</option> <?php do { ?> <option value="<?php echo $row_availableChampionships['championshipid']?>" ><?php echo $row_availableChampionships['championshipname']?></option> <?php } while ($row_availableChampionships = mysql_fetch_assoc($availableChampionships)); ?> </select> </td> </td> </tr> </table> // First table for selecting Championship <!-- Form one starts here --> Player 1 <label><p>First Name </p></label> <input type="text" name="playerFirstName1" value="" /> <input type="hidden" name="MAX_FILE_SIZE" value="5000000" /> Choose a photo to upload: <input name="uploadedfile1" type="file" /> <input name="countryid" type="hidden" value="<?php echo $_SESSION['MM_UserGroup']; ?>" /> <input name="participationid" type="hidden" value="<?php echo $_SESSION['idparticipants']; ?>" /> <label>Last Name</label> <input type="text" name="playerLastName1" value="" /> <label>Date of Birth</label> <select name="day1"> <option>Day</option> <?php for ($day = 1; $day <= 31; $day++) { echo "<option value=\"$day\">$day</option>\n"; } ?> </select> <span class="selectRequiredMsg">Please select an item.</span></span><span id="spryMonthSelect"> <select name="month1"> <option>Month</option> <option value="01" >01-January</option> <option value="02" >02-February</option> <option value="03" >03-March</option> <option value="04" >04-April</option> <option value="05" >05-May</option> <option value="06" >06-June</option> <option value="07" >07-July</option> <option value="08" >08-August</option> <option value="09" >09-September</option> <option value="10" >10-October</option> <option value="11" >11-November</option> <option value="12" >12-December</option> </select> <select name="year1"> <option>Year</option> <?php for ($year = 1950; $year <= 2005; $year++) { echo "<option value=\"$year\">$year</option>\n"; } ?> </select> <label>National Ranking</label> <input type="text" name="playerNationalRanking1" value="" > <label>Phone Number</label> <input type="text" name="playerPhoneNumber1" value="" > <label> Email Address</label> <input type="text" name="playerEmailAddress1" value=""> <label> Passport Number </label><input type="text" name="playerPassportNumber1" value=""> <label>Playing History</label> <textarea name="playerPlayingHistory1" value=""></textarea> <label> Address </label> <textarea name="playerAddress1" value=""></textarea> </table> <input type="hidden" name="playerID1" value=""> <input type="hidden" name="playerdob1" value=""> <input type="hidden" name="playercountry1" value="<?php echo $_SESSION['MM_UserGroup']; ?>"> <input type="hidden" name="idUsers1" value="<?php echo $_SESSION['MM_UserGroup']; ?>"> <input type="hidden" name="created_at1" value="<?php $now = new DateTime(); echo $now->format('Ymd H:i:s');?>"> <!-- Form one ENDS here --> <!-- Form two starts here --> Player 2 <label><p>First Name </p></label> <input type="text" name="playerFirstName2" value=""> <input type="hidden" name="MAX_FILE_SIZE" value="5000000" /> Choose a photo to upload: <input name="uploadedfile2" type="file" /> <input name="countryid" type="hidden" value="<?php echo $_SESSION['MM_UserGroup']; ?>"> <input name="participationid" type="hidden" value="<?php echo $_SESSION['idparticipants']; ?>"> <label>Last Name</label> <input type="text" name="playerLastName2" value=""> <label>Date of Birth</label> <select name="day2"> <option>Day</option> <?php for ($day = 1; $day <= 31; $day++) { echo "<option value=\"$day\">$day</option>\n"; } ?> </select> <span class="selectRequiredMsg">Please select an item.</span></span><span id="spryMonthSelect"> <select name="month2"> <option>Month</option> <option value="01" >01-January</option> <option value="02" >02-February</option> <option value="03" >03-March</option> <option value="04" >04-April</option> <option value="05" >05-May</option> <option value="06" >06-June</option> <option value="07" >07-July</option> <option value="08" >08-August</option> <option value="09" >09-September</option> <option value="10" >10-October</option> <option value="11" >11-November</option> <option value="12" >12-December</option> </select> <select name="year2"> <option>Year</option> <?php for ($year = 1950; $year <= 2005; $year++) { echo "<option value=\"$year\">$year</option>\n"; } ?> </select> <label>National Ranking</label> <input type="text" name="playerNationalRanking2" value="" > <label>Phone Number</label> <input type="text" name="playerPhoneNumber2" value="" > <label> Email Address</label> <input type="text" name="playerEmailAddress2" value=""> <label> Passport Number </label><input type="text" name="playerPassportNumber2" value=""> <label>Playing History</label> <textarea name="playerPlayingHistory2" value=""></textarea> <label> Address </label> <textarea name="playerAddress2" value=""></textarea> </table> <input type="hidden" name="playerID2" value=""> <input type="hidden" name="playerdob2" value=""> <input type="hidden" name="playercountry2" value="<?php echo $_SESSION['MM_UserGroup']; ?>"> <input type="hidden" name="idUsers2" value="<?php echo $_SESSION['MM_UserGroup']; ?>"> <input type="hidden" name="created_at2" value="<?php $now = new DateTime(); echo $now->format('Ymd H:i:s');?>"> <!-- Form two ENDS here --> <!-- Form Three starts here --> Player 3 <label><p>First Name </p></label> <input type="text" name="playerFirstName3" value=""> <input type="hidden" name="MAX_FILE_SIZE" value="5000000" > Choose a photo to upload: <input name="uploadedfile3" type="file" > <input name="countryid" type="hidden" value="<?php echo $_SESSION['MM_UserGroup']; ?>"> <input name="participationid" type="hidden" value="<?php echo $_SESSION['idparticipants']; ?>"> <label>Last Name</label> <input type="text" name="playerLastName3" value=""> <label>Date of Birth</label> <select name="day3"> <option>Day</option> <?php for ($day = 1; $day <= 31; $day++) { echo "<option value=\"$day\">$day</option>\n"; } ?> </select> <span class="selectRequiredMsg">Please select an item.</span></span><span id="spryMonthSelect"> <select name="month3"> <option>Month</option> <option value="01" >01-January</option> <option value="02" >02-February</option> <option value="03" >03-March</option> <option value="04" >04-April</option> <option value="05" >05-May</option> <option value="06" >06-June</option> <option value="07" >07-July</option> <option value="08" >08-August</option> <option value="09" >09-September</option> <option value="10" >10-October</option> <option value="11" >11-November</option> <option value="12" >12-December</option> </select> <select name="year3"> <option>Year</option> <?php for ($year = 1950; $year <= 2005; $year++) { echo "<option value=\"$year\">$year</option>\n"; } ?> </select> <label>National Ranking</label> <input type="text" name="playerNationalRanking3" value="" > <label>Phone Number</label> <input type="text" name="playerPhoneNumber3" value="" > <label> Email Address</label> <input type="text" name="playerEmailAddress3" value=""> <label> Passport Number </label><input type="text" name="playerPassportNumber3" value=""> <label>Playing History</label> <textarea name="playerPlayingHistory3" value=""></textarea> <label> Address </label> <textarea name="playerAddress3" value=""></textarea> </table> <input type="hidden" name="playerID3" value=""> <input type="hidden" name="playerdob3" value=""> <input type="hidden" name="playercountry3" value="<?php echo $_SESSION['MM_UserGroup']; ?>"> <input type="hidden" name="idUsers3" value="<?php echo $_SESSION['MM_UserGroup']; ?>"> <input type="hidden" name="created_at3" value="<?php $now = new DateTime(); echo $now->format('Ymd H:i:s');?>"> <!-- Form Three ENDS here --> <input type="hidden" name="MM_insert" value="form1"> </form> <?php // }//end the if statement for the number of participants ?>
Я не знаю, где я ошибся, некоторые из них не хранят все данные, он хранит 2 игрока и 2 участника и сохраняет только один идентификатор в таблице teamsplayers и 2 изображения в таблице файлов.
Как заставить этот скрипт работать так, как он должен. Все предложения приветствуются.