?????????????? ?????????????? ?????????????? ?????????????? '; echo 'alert("Team Added Successfully!")'; echo ''; } else { echo "Er: " . $sql . ":-" . mysqli_error($con) ; } mysqli_close($con); } else if (isset($_GET['id'])){ $id = $_GET['id']; $type = $_GET['type']; if($type=='delete') { $query="Delete from teams WHERE id='$id'"; if(mysqli_query($con,$query)) { if(mysqli_affected_rows($con)>0){ echo ''; } else { echo "Some error occurred!".mysqli_error($con); } }else{ echo "Some error occurred! Please try again".mysqli_error($con); } } else if($type=='update'){ $query2 = mysqli_query($con, "SELECT * FROM teams WHERE id='$id'"); if(mysqli_num_rows($query2)>=1){ while($row2 = mysqli_fetch_assoc($query2)){ $uId=$row2['id']; $uTournamentId=$row2['tournament_id']; $uTeamName= $row2['team_name']; $uTeamAbv= $row2['team_abv']; $uLogo= $row2['logo']; } } } } else if(isset($_POST['update'])) { $img; $FOLDER= "Images/Teams/"; $i = $_POST['id']; $team_name = $_POST['team_name']; $team_abv = $_POST['team_abv']; $logo = $_POST['logo']; $tournament_id = $_POST['tournament_id']; if(empty($_FILES["file"]["name"])){ $img=$logo; } else{ $img=uploadImage($FOLDER);; } // $sql = "UPDATE teams SET tournament_id='$tournament_id',team_name='$team_name',logo='$logo' WHERE id='$i'"; $sql = "UPDATE teams SET tournament_id='$tournament_id',team_name='$team_name',team_abv='$team_abv',logo='$img' WHERE id='$i'"; if (mysqli_query($con, $sql)) { echo ''; } else { echo "Er: " . $sql . ":-" . mysqli_error($con) ; } } function uploadImage($path){ $FOLDER_PATH = $path; if(isset($_FILES["file"]["name"])) { // get extention and set unique name $file_extention = @strtolower(@end(@explode(".", basename($_FILES["file"]["name"])))); $file_name = rand(10000, 990000) .'.'. $file_extention; $FOLDER_PATH = $FOLDER_PATH . $file_name; try { // Throws exception incase file is not being moved if (!move_uploaded_file($_FILES["file"]["tmp_name"], $FOLDER_PATH)) { // make error flag true $FOLDER_PATH = null; echo "Sorry! error found in file."; } } catch (Exception $e) { // Exception occurred. Make error flag true $FOLDER_PATH = null; echo $e->getMessage(); } } else { $FOLDER_PATH = null; echo "Error! File not found!"; } return $FOLDER_PATH; } ?> Teams
Go To Home

TEAMS

VIEW TEAMS

=1){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; while($row = mysqli_fetch_assoc($query)){ $ID[$i]= $row['id']; $delete_link='addTeams.php?id='.$ID[$i].'&type=delete'; $update_link='addTeams.php?id='.$ID[$i].'&type=update'; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo " "; $i++; } echo "
Team Id Tournament Team Name Team Abbreviation Logo Edit/Delete Record
".$row['id']."".$row['name']."".$row['team_name']."".$row['team_abv']."".$row['logo']."Delete / Update
"; } else{ echo "

No records to show

"; } $conn->close(); ?>