Server : LiteSpeed
System : Linux premium84.web-hosting.com 4.18.0-553.44.1.lve.el8.x86_64 #1 SMP Thu Mar 13 14:29:12 UTC 2025 x86_64
User : claqxcrl ( 523)
PHP Version : 8.1.32
Disable Function : NONE
Directory : /home/claqxcrl/www/ondjoweb/admin/
|
Server : LiteSpeed System : Linux premium84.web-hosting.com 4.18.0-553.44.1.lve.el8.x86_64 #1 SMP Thu Mar 13 14:29:12 UTC 2025 x86_64 User : claqxcrl ( 523) PHP Version : 8.1.32 Disable Function : NONE Directory : /home/claqxcrl/www/ondjoweb/admin/ |
<?php
session_start();
include('includes/config.php');
error_reporting(0);
if(strlen($_SESSION['login'])==0)
{
header('location:index.php');
}
else{
// For adding post
if(isset($_POST['submit']))
{
$getClube = 'Teste';
$id_clube = $_POST['clube'];
foreach($post->dadosClube($id_clube) as $key => $value):
$getClube = $value->apelido_clube;
endforeach;
$posicao = $_POST['posicao'];
$pontos=$_POST['pontos'];
$numJogos=$_POST['numJogos'];
$jogoVictorias=$_POST['jogoVictorias'];
$numEmpates=$_POST['numEmpates'];
$jogoPerdidos=$_POST['jogoPerdidos'];
$golMarcados=$_POST['golMarcados'];
$golSofridos=$_POST['golSofridos'];
$situacao=$_POST['situacao'];
$anoCompeticao=$_POST['anoCompeticao'];
$competicao=$_POST['competicao'];
$query=mysqli_query($con,"insert into
tblclassificacao(id_clube, clube, posicao, pontos, numJogos, jogoVictorias, numEmpates, jogoPerdidos,
golMarcados, golSofridos, situacao,anoCompeticao, competicao)
values('$id_clube', '$getClube' ,'$posicao','$pontos','$numJogos','$jogoVictorias','$numEmpates','$jogoPerdidos','$golMarcados','$golSofridos','$situacao',
'$anoCompeticao','$competicao')");
if($query)
{
$msg="Tabela actualizada com sucesso! ";
}
else{
$error="Algo deu errado. Por favor tente outra vez.";
}
}
?>
<!DOCTYPE html>
<html lang="pt">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta name="description" content="">
<meta name="author" content="Coderthemes">
<!-- App favicon -->
<link rel="shortcut icon" href="assets/images/favicon.ico">
<!-- App title -->
<title>OndjoWEB | Actualizar Classificação</title>
<!-- Select2 -->
<link href="../plugins/select2/css/select2.min.css" rel="stylesheet" type="text/css" />
<!-- Jquery filer css -->
<link href="../plugins/jquery.filer/css/jquery.filer.css" rel="stylesheet" />
<link href="../plugins/jquery.filer/css/themes/jquery.filer-dragdropbox-theme.css" rel="stylesheet" />
<!-- App css -->
<link href="assets/css/bootstrap.min.css" rel="stylesheet" type="text/css" />
<link href="assets/css/core.css" rel="stylesheet" type="text/css" />
<link href="assets/css/components.css" rel="stylesheet" type="text/css" />
<link href="assets/css/icons.css" rel="stylesheet" type="text/css" />
<link href="assets/css/pages.css" rel="stylesheet" type="text/css" />
<link href="assets/css/menu.css" rel="stylesheet" type="text/css" />
<link href="assets/css/responsive.css" rel="stylesheet" type="text/css" />
<link rel="stylesheet" href="../plugins/switchery/switchery.min.css">
<script src="assets/js/modernizr.min.js"></script>
</head>
<body class="fixed-left">
<!-- Begin page -->
<div id="wrapper">
<!-- Top Bar Start -->
<?php include('includes/topheader.php');?>
<!-- ========== Left Sidebar Start ========== -->
<?php include('includes/leftsidebar.php');?>
<!-- Left Sidebar End -->
<!-- ============================================================== -->
<!-- Start right Content here -->
<!-- ============================================================== -->
<div class="content-page">
<!-- Start content -->
<div class="content">
<div class="container">
<div class="row">
<div class="col-xs-12">
<div class="page-title-box">
<h4 class="page-title">Actualizar Tabela Classificativa </h4>
<ol class="breadcrumb p-0 m-0">
<li>
<a href="#">Post</a>
</li>
<li>
<a href="#">Adicionar Post </a>
</li>
<li class="active">
Adicionar Post
</li>
</ol>
<div class="clearfix"></div>
</div>
</div>
</div>
<!-- end row -->
<div class="row">
<div class="col-sm-6">
<!---Success Message--->
<?php if($msg){ ?>
<div class="alert alert-success" role="alert">
<strong>Bem feito!</strong> <?php echo htmlentities($msg);?>
</div>
<?php } ?>
<!---Error Message--->
<?php if($error){ ?>
<div class="alert alert-danger" role="alert">
<strong>Oh pá!</strong> <?php echo htmlentities($error);?></div>
<?php } ?>
</div>
</div>
<div class="row">
<div class="col-md-10 col-md-offset-1">
<div class="p-6">
<div class="">
<form name="addpost" method="post" enctype="multipart/form-data">
<tr>
<div class="col-lg-3">
<div class="form-group m-b-20">
<label for="exampleInputEmail1">Clube</label>
<select class="form-control" name="clube" required>
<option value="">Selecione o clube </option>
<?php foreach($post->clubeInfo() as $key => $value){?>
<option value="<?php echo $value->id;?>"> <?php echo $value->apelido_clube;?> </option>
<?php }?>
</select>
</div>
</div>
<td>
<div class="col-lg-3">
<div class="form-group m-b-20">
<label for="exampleInputEmail1">Posicação</label>
<input type="number" class="form-control" id="posttitle" name="posicao" placeholder="" required maxlength="69">
</div>
</div>
</td>
<td>
<div class="col-lg-3">
<div class="form-group m-b-20">
<label for="exampleInputEmail1">Pontos</label>
<input type="number" class="form-control" id="posttitle" name="pontos" placeholder="" required maxlength="69">
</div>
</div>
</td>
<td>
<div class="col-lg-3">
<div class="form-group m-b-20">
<label for="exampleInputEmail1">Jogos feito</label>
<input type="number" class="form-control" id="posttitle" name="numJogos" placeholder="" required maxlength="69">
</div>
</div>
</td>
</tr>
<tr>
<td>
<div class="col-lg-3">
<div class="form-group m-b-20">
<label for="exampleInputEmail1">Victórias</label>
<input type="number" class="form-control" id="posttitle" name="jogoVictorias" placeholder="" required maxlength="69">
</div>
</div>
</td>
<td>
<div class="col-lg-3">
<div class="form-group m-b-20">
<label for="exampleInputEmail1">Empates</label>
<input type="number" class="form-control" id="posttitle" name="numEmpates" placeholder="" required maxlength="69">
</div>
</div>
</td>
<td>
<div class="col-lg-3">
<div class="form-group m-b-20">
<label for="exampleInputEmail1">Jogos Perdidos</label>
<input type="number" class="form-control" id="posttitle" name="jogoPerdidos" placeholder="" required maxlength="69">
</div>
</div>
</td>
<td>
<div class="col-lg-3">
<div class="form-group m-b-20">
<label for="exampleInputEmail1">Golos marcados</label>
<input type="number" class="form-control" id="posttitle" name="golMarcados" placeholder="" required maxlength="69">
</div>
</div>
</td>
</tr>
<tr>
<div class="col-lg-3">
<div class="form-group m-b-20">
<label for="exampleInputEmail1">Competição</label>
<select class="form-control" name="competicao" required>
<option value="">Selecione competição </option>
<?php
// Feching clube
$ret=mysqli_query($con,"select nome_competicao from tblcompeticao");
while($result=mysqli_fetch_array($ret))
{
?>
<option value="<?php echo htmlentities($result['nome_competicao']);?>"><?php echo htmlentities($result['nome_competicao']);?></option>
<?php } ?>
</select>
</div>
</div>
<td>
<div class="col-lg-3">
<div class="form-group m-b-20">
<label for="exampleInputEmail1">Golos sofridos</label>
<input type="number" class="form-control" id="posttitle" name="golSofridos" placeholder="" required maxlength="69">
</div>
</div>
</td>
<div class="col-lg-2">
<div class="form-group m-b-20">
<label for="exampleInputEmail1">Situação actual</label>
<select class="form-control" name="situacao">
<option value="Regular">Regular</option>
<option value="Descendo">Descendo</option>
<option value="Subindo">Subindo</option>
</select>
</div>
</div>
<div class="col-lg-2">
<div class="form-group m-b-20">
<label for="exampleInputEmail1">Ano Competição</label>
<select class="form-control" name="anoCompeticao" required>
<option value="2019">2019</option>
<option value="2020">2020</option>
<option value="2021">2021</option>
<option value="2022">2022</option>
<option value="2023">2023</option>
<option value="2024">2024</option>
<option value="2025">2025</option>
</select>
</div>
</div>
</tr>
<div class="col-lg-12">
<button type="submit" name="submit" class="btn btn-success waves-effect waves-light">Actualizar</button>
<button type="button" class="btn btn-danger waves-effect waves-light">Cancelar</button>
</div>
</form>
</div>
</div> <!-- end p-20 -->
</div> <!-- end col -->
</div>
<!-- end row -->
</div> <!-- container -->
</div> <!-- content -->
<?php include('includes/footer.php');
?>
</div>
<!-- ============================================================== -->
<!-- End Right content here -->
<!-- ============================================================== -->
</div>
<!-- END wrapper -->
<!-- jQuery -->
<script src="assets/js/jquery.min.js"></script>
<script src="assets/js/bootstrap.min.js"></script>
<script src="assets/js/detect.js"></script>
<script src="assets/js/fastclick.js"></script>
<script src="assets/js/jquery.blockUI.js"></script>
<script src="assets/js/waves.js"></script>
<script src="assets/js/jquery.slimscroll.js"></script>
<script src="assets/js/jquery.scrollTo.min.js"></script>
<script src="../plugins/switchery/switchery.min.js"></script>
<!-- Select 2 -->
<script src="../plugins/select2/js/select2.min.js"></script>
<!-- Jquery filer js -->
<script src="../plugins/jquery.filer/js/jquery.filer.min.js"></script>
<!-- page specific js -->
<script src="assets/pages/jquery.blog-add.init.js"></script>
<!-- App js -->
<script src="assets/js/jquery.core.js"></script>
<script src="assets/js/jquery.app.js"></script>
<script src="../plugins/switchery/switchery.min.js"></script>
</body>
</html>
<?php } ?>