Publicado em 29 de mar.

Inserir datas no "insert" do CRUD

Olá pessoal estou com dificuldades de inserir datas (diferença entre datas) no INSERT do CRUD e converte -las para nossa ralidade alguem pode analisar o meu projeto. A principio o INDEX: <!DOCTYPE html>

<html lang="pt - BR"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1"> <meta name="description" content=""> <meta name="author" content=""> <title>ARMSTRONGTEC</title> <!-- Bootstrap Core CSS --> <link href="../bower_components/bootstrap/dist/css/bootstrap.min.css" rel="stylesheet"> <!-- MetisMenu CSS --> <link href="[https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/bootstrap.min.css](https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/bootstrap.min.css)" rel="stylesheet"> <!-- MetisMenu CSS --> <link href="[https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/metisMenu.min.css](https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/metisMenu.min.css)" rel="stylesheet"> <!-- Timeline CSS --> <link href="[https://ia601500.us.archive.org/26/items/www.armstrongtec1.com_937/timeline.css](https://ia601500.us.archive.org/26/items/www.armstrongtec1.com_937/timeline.css)" rel="stylesheet"> <!-- Custom CSS --> <link href="[https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/sb-admin-2.css](https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/sb-admin-2.css)" rel="stylesheet"> <!-- Morris Charts CSS --> <link href="[https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/morris.css](https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/morris.css)" rel="stylesheet"> <!-- Custom Fonts --> <link href="[https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/font-awesome.min.css](https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/font-awesome.min.css)" rel="stylesheet" type="text/css"> <link href="[https://ia801502.us.archive.org/27/items/www.armstrongtec1.com_215/font-awesome.css](https://ia801502.us.archive.org/27/items/www.armstrongtec1.com_215/font-awesome.css)" rel="stylesheet" type="text/css"> <link href=" [https://ia801506.us.archive.org/24/items/www.armstrongtec1.com_869/dataTables.responsive.css](https://ia801506.us.archive.org/24/items/www.armstrongtec1.com_869/dataTables.responsive.css)" rel="stylesheet"> <link rel="shortcut icon" href="[https://ia902607.us.archive.org/18/items/logoCpflRenovaveis/CPFL.jpg](https://ia902607.us.archive.org/18/items/logoCpflRenovaveis/CPFL.jpg)"> <link href="[http://netdna.bootstrapcdn.com/twitter-bootstrap/2.2.2/css/bootstrap-combined.min.css](http://netdna.bootstrapcdn.com/twitter-bootstrap/2.2.2/css/bootstrap-combined.min.css)" rel="stylesheet">

 <script src="https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js"></script> <script src="https://oss.maxcdn.com/libs/respond.js/1.4.2/respond.min.js"></script> <![endif]--> </head> <body> <div id="wrapper"> <!-- Navigation --> <nav class="navbar navbar-default navbar-static-top" role="navigation" style="margin-bottom: 0"> <div class="navbar-header"> <a href="index.php"><img src="[https://ia902607.us.archive.org/18/items/logoCpflRenovaveis/CPFL.jpg](https://ia902607.us.archive.org/18/items/logoCpflRenovaveis/CPFL.jpg)"width="60" height="60"></a> <button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-collapse"> <span class="sr-only">Toggle navigation</span> <span class="icon-bar"></span> <span class="icon-bar"></span> <span class="icon-bar"></span> </button> <a class="navbar-brand" href="index.php"></a> <!-- <img src="LINK DA IMAGEM" border=0">--> </div> <!-- /.navbar-header --> <ul class="nav navbar-top-links navbar-right"> <li class="dropdown"> <!-- <a class="dropdown-toggle" data-toggle="dropdown" href="#"> --> <!-- <i class="fa fa-envelope fa-fw"></i> <i class="fa fa-caret-down"></i> --> </a> <!-- /.dropdown-messages --> </li> <!-- /.dropdown --> <li class="dropdown"> <!-- <a class="dropdown-toggle" data-toggle="dropdown" href="#"> --> <!-- <i class="fa fa-tasks fa-fw"></i> <i class="fa fa-caret-down"></i> --> </a> <!-- /.dropdown-tasks --> </li> <!-- /.dropdown --> <li class="dropdown"> <!-- <a class="dropdown-toggle" data-toggle="dropdown" href="#"> --> <!-- <i class="fa fa-bell fa-fw"></i> <i class="fa fa-caret-down"></i> --> </a> <!-- /.dropdown-alerts --> </li> <!-- /.dropdown --> <li class="dropdown"> <a class="dropdown-toggle" data-toggle="dropdown" href="#"> <i class="fa fa-user fa-fw"></i> <i class="fa fa-caret-down"></i> </a> <ul class="dropdown-menu dropdown-user"> <li><a href="#"><i class="fa fa-user fa-fw"></i> User Profile</a> </li> <li><a href="#"><i class="fa fa-gear fa-fw"></i> Settings</a> </li> <li class="divider"></li> <li><a href="login.php"><i class="fa fa-sign-out fa-fw"></i> Logout</a> </li> </ul> <!-- /.dropdown-user --> </li> <!-- /.dropdown --> </ul> <!-- /.navbar-top-links --> <div class="navbar-default sidebar" role="navigation"> <div class="sidebar-nav navbar-collapse"> <ul class="nav" id="side-menu"> <!-- <li class="sidebar-search"> <div class="input-group custom-search-form"> <input type="text" class="form-control" placeholder="Search..."> <span class="input-group-btn"> <button class="btn btn-default" type="button"> <i class="fa fa-search"></i> </button> </span> </div> --> <!-- /input-group --> <li> <a href="index.php"><i class="fa fa-dashboard fa-fw"></i> Relatórios<span class="fa arrow"></span></a> <ul class="nav nav-second-level"> <li> <a href="#"><i class="fa fa-wrench"></i> Manutenções</a> </li> <li> <a href="#"><i class="fa fa-flash"></i> Ocorrencias</a> </li> <li> <a href="#"><i class="fa fa-gavel"></i> Intervenções</a> </li> </ul> </li> <li> <a href="#"><i class="fa fa-bar-chart-o fa-fw"></i> Índices<span class="fa arrow"></span></a> <ul class="nav nav-second-level"> <li> <a href="PieChart.php"><i class="fa fa-bar-chart-o fa-fw"></i> Manutenções</a> </li> <li> <a href="AreChart.php"><i class="fa fa-bar-chart-o fa-fw"></i> Ocorrências</a> </li> <li> <a href="ColumnChart.php"><i class="fa fa-bar-chart-o fa-fw"></i> Intervenções</a> </li> </ul> <!-- /.nav-second-level --> </li> <li> <a href="registroManutencao.php"><i class="fa fa-table fa-fw"></i> Registro<span class="fa arrow"></span></a> <ul class="nav nav-second-level"> <li> <a href="registroManutencao.php"><i class="fa fa-wrench"></i> Manutenções</a> </li> <li> <a href="registroOcorrencia.php"><i class="fa fa-flash"></i> Ocorrências</a> </li> <li> <a href="registroIntervencao.php"><i class="fa fa-gavel"></i> Intervenções</a> </li> </ul> </li> <li> <a href="forms.php"><i class="fa fa-edit fa-fw"></i> Formulários <span class="fa arrow"></span></a> <ul class="nav nav-second-level"> <li> <a href="flot.php"><i class="fa fa-wrench"></i> Manutenções</a> </li> <li> <a href="registroIntervencao"><i class="fa fa-flash"></i> Ocorrencias</a> </li> <li> <a href="registroIntervencao"><i class="fa fa-gavel"></i> Intervenções</a> </li> </ul> </li> <li> <a href="#"><i class="fa fa-wrench fa-fw"></i> Manutenções pendentes<span class="fa arrow"></span></a> <ul class="nav nav-second-level"> <!-- <li> <a href="panels-wells.php">Panels and Wells</a> </li> <li> <a href="buttons.php">Buttons</a> </li> <li> <a href="notifications.php">Notifications</a> </li> <li> <a href="typography.php">Typography</a> </li> <li> <a href="icons.php"> Icons</a> </li> <li> <a href="grid.php">Grid</a> </li> </ul> --> <!-- /.nav-second-level --> </li> <li> <a href="#"><i class="fa fa-sitemap fa-fw"></i> Consulta<span class="fa arrow"></span></a> <ul class="nav nav-second-level"> <li> <a href="consulta.php"><i class="fa fa-database"></i> Consultas</a> </li> <li> <a href="#"><i class="fa fa-flash"></i> Gerar O.S</a> </li> <li> <a href="#"><i class="fa fa-tasks"></i> Gerar Programações<span class="fa arrow"></span></a> <ul class="nav nav-third-level"> <li> <a href="flot.php"><i class="fa fa-wrench"></i> Manutenções</a> </li> <li> <a href="registroIntervencao"><i class="fa fa-flash"></i> Ocorrencias</a> </li> <li> <a href="registroIntervencao"><i class="fa fa-gavel"></i> Intervenções</a> </li> </ul> <!-- /.nav-third-level --> </li> </ul> <!-- /.nav-second-level --> </li> <li> <a href="#"><i class="fa fa-sitemap fa-fw"></i> Operação<span class="fa arrow"></span></a> <ul class="nav nav-second-level"> <li> <a href="chart.php"><i class="fa fa-tasks"></i> Programação</a> </li> <li> <a href="login.php"><i class="fa fa-user"></i> Login</a> </li> </ul> <!-- /.nav-second-level --> </li> </ul> </div> <!-- /.sidebar-collapse --> </div> <!-- /.navbar-static-side --> </nav> <!-- Page Content --> <div id="page-wrapper"> <div class="container-fluid"> <div class="row"> <div class="col-lg-12"> <div class="container"> <div class="row"> <div class="well"> <div id="datetimepicker" class="input-append date"> <input type="text"></input> <span class="add-on"> <i data-time-icon="icon-time" data-date-icon="icon-calendar"></i> </span> </div> <script type="text/javascript" src="http://cdnjs.cloudflare.com/ajax/libs/jquery/1.8.3/jquery.min.js"> </script> <!-- <script type="text/javascript" src="http://netdna.bootstrapcdn.com/twitter-bootstrap/2.2.2/js/bootstrap.min.js"> </script>--> <script type="text/javascript" src="http://tarruda.github.com/bootstrap-datetimepicker/assets/js/bootstrap-datetimepicker.min.js"> </script> <script type="text/javascript"> $('#datetimepicker').datetimepicker({ format: 'dd/MM/yyyy hh:mm:ss', language: 'pt-BR' }). </script>
</div> </div> <h1 class="page-header"><i class="fa fa-bar-chart-o fa-fw"></i> Sistema Geral de Manutenção</a></h1> <title>Diário de Manutenção</title> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <script type="text/javascript" src="https://www.google.com/jsapi"></script> <script type="text/javascript"> google.load("visualization", "1", {packages:["corechart"]}). google.setOnLoadCallback(drawChart). function drawChart() { var data = google.visualization.arrayToDataTable([ [ 'equipamento', 'total'], <?php
$link = mysqli_connect('localhost', 'root', 'STRONG', 'gestao'). $sth = mysqli_query($link, "SELECT equipamento, sum(total) from progarmacao group by equipamento").

while ($r = mysqli_fetch_array($sth)) {

 echo "['$r[0]', $r[1]],\n". }?> ]). var options = { title: 'Programação', is3D: true, }. var chart = new google.visualization.PieChart(document.getElementById('piechart_3d')). chart.draw(data, options). } </script> </head> <body> <div id="piechart_3d" style="width: 600px. height: 400px. "></div> </body> </div> <!-- Page Content -->
</div> <a href="PieChart/create.php" class="btn btn-primary">Novo Registro</a> <br> <br> <div> </div> <div class="container"> </div> <!-- /.panel-heading --> <table class="table table-striped table-hover" id="dataTables-example"> <thead> <tr> <th>Site</th> <th>Data_inicio</th> <th>Data_fim</th> <th>Equipamento</th> <th>Total</th> <th>total_horas</th> <th>Ação</th> </tr> </thead> <tbody> <?php include 'PieChart/basedados.php'. $pdo = Database::connect(). $sql = 'SELECT * FROM progarmacao ORDER BY id DESC'. foreach ($pdo->query($sql) as $row) { echo '<tr>'. echo '<td>'. $row['site']. '</td>'. echo '<td>'. $row['inicio']. '</td>'. echo '<td>'. $row['fim']. '</td>'. echo '<td>'. $row['equipamento']. '</td>'. echo '<td>'. $row['total']. '</td>'. echo '<td>'. $row['total_horas']. '</td>'. echo '<td width=250>'. echo '<a class="btn btn-warning" href="PieChart/read.php?id='.$row['id'].'">Ler</a>'. echo ' '. echo '<a class="btn btn-success" href="PieChart/update.php?id='.$row['id'].'">Atualizar</a>'. echo ' '. echo '<a class="btn btn-danger" href="PieChart/delete.php?id='.$row['id'].'">Excluir</a>'. echo '</td>'. echo '</tr>'. } Database::disconnect().?> </tbody> </table> </div> </div> <!-- /container --> <!-- /.col-lg-12 --> </div> <!-- /.row --> </div> <!-- /.container-fluid --> </div> <!-- /#page-wrapper --> </div> <!-- /#wrapper --> <!-- jQuery --> <!-- jQuery --> <!-- Bootstrap Core JavaScript --> <script src="https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/bootstrap.min.js"></script> <!-- Metis Menu Plugin JavaScript --> <script src="[https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/metisMenu.min.css](https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/metisMenu.min.css)"></script> <!-- DataTables JavaScript --> <script src="https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/jquery.dataTables.min.js"></script> <script src="https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/dataTables.bootstrap.min.js"></script> <!-- Custom Theme JavaScript --> <script src="https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/sb-admin-2.js"></script> <!-- Page-Level Demo Scripts - Tables - Use for reference --> <script> <script src="https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/jquery.min.js"></script> <!-- Bootstrap Core JavaScript --> <script src="https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/bootstrap.min.js"></script> <!-- Metis Menu Plugin JavaScript --> <script src="[https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/metisMenu.min.css](https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/metisMenu.min.css)"></script> <!-- Morris Charts JavaScript --> <script src="https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/raphael-min.js"></script> <script src="https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/morris.min.js"></script> <script src="https://ia601500.us.archive.org/26/items/www.armstrongtec1.com_937/morris-data.js"></script> <!-- Custom Theme JavaScript --> <script src="https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/sb-admin-2.js"></script> <script src="https://ia801506.us.archive.org/24/items/www.armstrongtec1.com_869/metisMenu.js"></script> <script src="https://ia801506.us.archive.org/24/items/www.armstrongtec1.com_869/select.js"></script> <script src="https://ia801506.us.archive.org/24/items/www.armstrongtec1.com_869/flot-data.js"></script> <script src=" [https://ia801506.us.archive.org/24/items/www.armstrongtec1.com_869/dataTables.jPaginator.js](https://ia801506.us.archive.org/24/items/www.armstrongtec1.com_869/dataTables.jPaginator.js)"></script> <!-- Page-Level Demo Scripts - Tables - Use for reference --> <script> $(document).ready(function() { $('#dataTables-example').DataTable({ responsive: true }). }). </script> </body> </html>

Agora o INSERT:

<?php require '../basedado.php'. if (!empty($_POST)) {

// keep track validation errors

$siteError = null. $inicio = null. $fim = null. $equipamentoError = null. $totalError = null. //$total_horasError = null. //$dataError = null.

// keep track post values

$site = $_POST['site']. $inicio = $_POST['inicio']. $fim = $_POST['fim']. $equipamento = $_POST['equipamento']. $total = $_POST['total']. //$total_horas = $_POST['total_horas'].

// validate input $valid = true. if (empty($site)) {

$siteError = 'Entre com Site'. $valid = false. }

if (empty($inicio)) {

$inicioError = 'Entre com Data_inicio'. $valid = false. }

if (empty($fim)) {

$fimError = 'Entre com Data_fim'. $valid = false. }

if (empty($equipamento)) {

$equipamentoError = 'Entre com Equipamento'. $valid = false. }

if (empty($total)) {

$totalError = 'Entre com Total'. $valid = false. }

//if (empty($total_hora)) {

// $total_horaError = 'Entre com Total'. // $valid = false.

//}

$inicio = DateTime::createFromFormat('d-m-Y H:i:s', $inicio)). $fim = DateTime::createFromFormat('d-m-Y H:i:s', $fim)). $diff = $inicio->diff($fim). $dias = $diff->format('%d'). $horas = $diff->format('%h'). $minutos = $diff->format('%i'). $segundos = $diff->format('%s'). $total_horas = ($dias * 24) + $horas. $total_horas. ':'. $minutos. ':'. $segundos.

// insert data

if ($valid) {
$pdo = Database::connect(). $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION). $sql = "INSERT INTO progarmacao (site,inicio,fim,equipamento,total) values(?,?,?,?,?)". $q = $pdo->prepare($sql). $q->execute(array($site,$inicio,$fim$equipamento,$total). Database::disconnect(). header("Location:../PieChart.php"). }
}?>

<!DOCTYPE html>

<html lang="pt - BR">
<head> <meta charset="utf-8"> <link href="../css/bootstrap.min.css" rel="stylesheet"> <script src="js/bootstrap.min.js"></script>
</head> <body> <div class="container"> <div class="span10 offset1"> <div class="row"> <h3>Novo Registro</h3> </div> <form class="form-horizontal" action="create.php" method="post"> <div class="control-group <?php echo!empty($siteError)?'error':''.?>"> <label class="control-label">Site</label> <div class="controls"> <input name="site" type="text" placeholder="Site" value="<?php echo!empty($site)?$site:''.?>"> <?php if (!empty($siteError)):?> <span class="help-inline"><?php echo $siteError.?></span> <?php endif.?> </div> </div> <div class="control-group <?php echo!empty($inicioError)?'error':''.?>"> <label class="control-label">Data_inicio</label> <div class="controls"> <input name="inicio" type="DateTime" placeholder="Data_inicio" value="<?php echo!empty($inicioError)?$inicio:''.?>"> <?php if (!empty($inicioError)):?> <span class="help-inline"><?php echo $inicioError.?></span> <?php endif.?> </div> </div> <div class="control-group <?php echo!empty($fimError)?'error':''.?>"> <label class="control-label">Data_fim</label> <div class="controls"> <input name="fim" type="DateTime" placeholder="Data_fim" value="<?php echo!empty($fimError)?$fim:''.?>"> <?php if (!empty($fimError)):?> <span class="help-inline"><?php echo $fimError.?></span> <?php endif.?> </div> </div> <div class="control-group <?php echo!empty($equipamentoError)?'error':''.?>"> <label class="control-label">Equipamento</label> <div class="controls"> <input name="equipamento" type="text" placeholder="Equipamento" value="<?php echo!empty($equipamento)?$equipamento:''.?>"> <?php if (!empty($equipamentoError)):?> <span class="help-inline"><?php echo $equipamentoError.?></span> <?php endif.?> </div> </div> <div class="control-group <?php echo!empty($totalError)?'error':''.?>"> <label class="control-label">Total</label> <div class="controls"> <input name="total" type="DateTime" placeholder="Total" value="<?php echo!empty($total)?$total:''.?>"> <?php if (!empty($totalError)):?> <span class="help-inline"><?php echo $totalError.?></span> <?php endif.?> </div> </div> <div class="control-group <?php echo!empty($total_horasError)?'error':''.?>"> <label class="control-label">Total_horas</label> <div class="controls"> <input class="form-control" type="text" placeholder="Readonly input here…" readonly> <?php if (!empty($total_horasError)):?> <span class="help-inline"><?php echo $total_horasError.?></span> <?php endif.?> </div> </div> <div class="form-actions"> <button type="submit" class="btn btn-success">Novo Registro</button> <a class="btn" href="../PieChart.php">VOLTAR</a>
</div>
</form>
</div>
</div>
</div>
</div> </div> <!-- /container --> </body>
</html>

Discussão (0)

Entre ou cadastre-se para participar da discussão

Entrar Criar conta

Carregando comentários...

<html lang="pt - BR"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1"> <meta name="description" content=""> <meta name="author" content=""> <title>ARMSTRONGTEC</title>  <link href="../bower_components/bootstrap/dist/css/bootstrap.min.css" rel="stylesheet">  <link href="[https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/bootstrap.min.css](https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/bootstrap.min.css)" rel="stylesheet">  <link href="[https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/metisMenu.min.css](https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/metisMenu.min.css)" rel="stylesheet">  <link href="[https://ia601500.us.archive.org/26/items/www.armstrongtec1.com_937/timeline.css](https://ia601500.us.archive.org/26/items/www.armstrongtec1.com_937/timeline.css)" rel="stylesheet">  <link href="[https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/sb-admin-2.css](https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/sb-admin-2.css)" rel="stylesheet">  <link href="[https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/morris.css](https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/morris.css)" rel="stylesheet">  <link href="[https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/font-awesome.min.css](https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/font-awesome.min.css)" rel="stylesheet" type="text/css"> <link href="[https://ia801502.us.archive.org/27/items/www.armstrongtec1.com_215/font-awesome.css](https://ia801502.us.archive.org/27/items/www.armstrongtec1.com_215/font-awesome.css)" rel="stylesheet" type="text/css"> <link href=" [https://ia801506.us.archive.org/24/items/www.armstrongtec1.com_869/dataTables.responsive.css](https://ia801506.us.archive.org/24/items/www.armstrongtec1.com_869/dataTables.responsive.css)" rel="stylesheet"> <link rel="shortcut icon" href="[https://ia902607.us.archive.org/18/items/logoCpflRenovaveis/CPFL.jpg](https://ia902607.us.archive.org/18/items/logoCpflRenovaveis/CPFL.jpg)"> <link href="[http://netdna.bootstrapcdn.com/twitter-bootstrap/2.2.2/css/bootstrap-combined.min.css](http://netdna.bootstrapcdn.com/twitter-bootstrap/2.2.2/css/bootstrap-combined.min.css)" rel="stylesheet">

echo "['$r[0]', $r[1]],\n". }?> ]). var options = { title: 'Programação', is3D: true, }. var chart = new google.visualization.PieChart(document.getElementById('piechart_3d')). chart.draw(data, options). } </script> </head> <body> <div id="piechart_3d" style="width: 600px. height: 400px. "></div> </body> </div>  </div> <a href="PieChart/create.php" class="btn btn-primary">Novo Registro</a> <br> <br> <div> </div> <div class="container"> </div>  <table class="table table-striped table-hover" id="dataTables-example"> <thead> <tr> <th>Site</th> <th>Data_inicio</th> <th>Data_fim</th> <th>Equipamento</th> <th>Total</th> <th>total_horas</th> <th>Ação</th> </tr> </thead> <tbody> <?php include 'PieChart/basedados.php'. $pdo = Database::connect(). $sql = 'SELECT * FROM progarmacao ORDER BY id DESC'. foreach ($pdo->query($sql) as $row) { echo '<tr>'. echo '<td>'. $row['site']. '</td>'. echo '<td>'. $row['inicio']. '</td>'. echo '<td>'. $row['fim']. '</td>'. echo '<td>'. $row['equipamento']. '</td>'. echo '<td>'. $row['total']. '</td>'. echo '<td>'. $row['total_horas']. '</td>'. echo '<td width=250>'. echo '<a class="btn btn-warning" href="PieChart/read.php?id='.$row['id'].'">Ler</a>'. echo ' '. echo '<a class="btn btn-success" href="PieChart/update.php?id='.$row['id'].'">Atualizar</a>'. echo ' '. echo '<a class="btn btn-danger" href="PieChart/delete.php?id='.$row['id'].'">Excluir</a>'. echo '</td>'. echo '</tr>'. } Database::disconnect().?> </tbody> </table> </div> </div>   </div>  </div>  </div>  </div>     <script src="https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/bootstrap.min.js"></script>  <script src="[https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/metisMenu.min.css](https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/metisMenu.min.css)"></script>  <script src="https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/jquery.dataTables.min.js"></script> <script src="https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/dataTables.bootstrap.min.js"></script>  <script src="https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/sb-admin-2.js"></script>  <script> <script src="https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/jquery.min.js"></script>  <script src="https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/bootstrap.min.js"></script>  <script src="[https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/metisMenu.min.css](https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/metisMenu.min.css)"></script>  <script src="https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/raphael-min.js"></script> <script src="https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/morris.min.js"></script> <script src="https://ia601500.us.archive.org/26/items/www.armstrongtec1.com_937/morris-data.js"></script>  <script src="https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/sb-admin-2.js"></script> <script src="https://ia801506.us.archive.org/24/items/www.armstrongtec1.com_869/metisMenu.js"></script> <script src="https://ia801506.us.archive.org/24/items/www.armstrongtec1.com_869/select.js"></script> <script src="https://ia801506.us.archive.org/24/items/www.armstrongtec1.com_869/flot-data.js"></script> <script src=" [https://ia801506.us.archive.org/24/items/www.armstrongtec1.com_869/dataTables.jPaginator.js](https://ia801506.us.archive.org/24/items/www.armstrongtec1.com_869/dataTables.jPaginator.js)"></script>  <script> $(document).ready(function() { $('#dataTables-example').DataTable({ responsive: true }). }). </script> </body> </html>

$inicio = DateTime::createFromFormat('d-m-Y H:i:s', $inicio)). $fim = DateTime::createFromFormat('d-m-Y H:i:s', $fim)). $diff = $inicio->diff($fim). $dias = $diff->format('%d'). $horas = $diff->format('%h'). $minutos = $diff->format('%i'). $segundos = $diff->format('%s'). $total_horas = ($dias * 24) + $horas. $total_horas. ':'. $minutos. ':'. $segundos.

if ($valid) { $pdo = Database::connect(). $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION). $sql = "INSERT INTO progarmacao (site,inicio,fim,equipamento,total) values(?,?,?,?,?)". $q = $pdo->prepare($sql). $q->execute(array($site,$inicio,$fim$equipamento,$total). Database::disconnect(). header("Location:../PieChart.php"). } }?>

<html lang="pt - BR"> <head> <meta charset="utf-8"> <link href="../css/bootstrap.min.css" rel="stylesheet"> <script src="js/bootstrap.min.js"></script> </head> <body> <div class="container"> <div class="span10 offset1"> <div class="row"> <h3>Novo Registro</h3> </div> <form class="form-horizontal" action="create.php" method="post"> <div class="control-group <?php echo!empty($siteError)?'error':''.?>"> <label class="control-label">Site</label> <div class="controls"> <input name="site" type="text" placeholder="Site" value="<?php echo!empty($site)?$site:''.?>"> <?php if (!empty($siteError)):?> <span class="help-inline"><?php echo $siteError.?></span> <?php endif.?> </div> </div> <div class="control-group <?php echo!empty($inicioError)?'error':''.?>"> <label class="control-label">Data_inicio</label> <div class="controls"> <input name="inicio" type="DateTime" placeholder="Data_inicio" value="<?php echo!empty($inicioError)?$inicio:''.?>"> <?php if (!empty($inicioError)):?> <span class="help-inline"><?php echo $inicioError.?></span> <?php endif.?> </div> </div> <div class="control-group <?php echo!empty($fimError)?'error':''.?>"> <label class="control-label">Data_fim</label> <div class="controls"> <input name="fim" type="DateTime" placeholder="Data_fim" value="<?php echo!empty($fimError)?$fim:''.?>"> <?php if (!empty($fimError)):?> <span class="help-inline"><?php echo $fimError.?></span> <?php endif.?> </div> </div> <div class="control-group <?php echo!empty($equipamentoError)?'error':''.?>"> <label class="control-label">Equipamento</label> <div class="controls"> <input name="equipamento" type="text" placeholder="Equipamento" value="<?php echo!empty($equipamento)?$equipamento:''.?>"> <?php if (!empty($equipamentoError)):?> <span class="help-inline"><?php echo $equipamentoError.?></span> <?php endif.?> </div> </div> <div class="control-group <?php echo!empty($totalError)?'error':''.?>"> <label class="control-label">Total</label> <div class="controls"> <input name="total" type="DateTime" placeholder="Total" value="<?php echo!empty($total)?$total:''.?>"> <?php if (!empty($totalError)):?> <span class="help-inline"><?php echo $totalError.?></span> <?php endif.?> </div> </div> <div class="control-group <?php echo!empty($total_horasError)?'error':''.?>"> <label class="control-label">Total_horas</label> <div class="controls"> <input class="form-control" type="text" placeholder="Readonly input here…" readonly> <?php if (!empty($total_horasError)):?> <span class="help-inline"><?php echo $total_horasError.?></span> <?php endif.?> </div> </div> <div class="form-actions"> <button type="submit" class="btn btn-success">Novo Registro</button> <a class="btn" href="../PieChart.php">VOLTAR</a> </div> </form> </div> </div> </div> </div> </div>  </body> </html>