adriano.eurich

Assim, obrigado... segue o código da conexao.php <?php $link = new mysqli('localhost','root','','db_sacola'); $link->set_charset('utf8'); if(!$link){ echo "Problemas ao realizar a conexao com o banco de dados (".mysqli_error().")"; exit(); }

Consultei no fórum um problema igual ao meu, ou mesmo código de erro, mas no meu caso não consegui resolver. Notice: Undefined variable: link in C:\xampp\htdocs\cadastro\sacola.php on line 30 Warning: mysqli_query() expects parameter 1 to be mysqli, null given in C:\xampp\htdocs\cadastro\sacola.php on line 30 sacola.php <?php session_start(); include_once 'includes/header.inc.php'; include_once 'includes/menu.inc.php'; ?> <!-- Formulário de Cadastro Cliente --> <div class="row container"> <p>&nbsp;</p> <fieldset class="formulario" style="padding: 5px; width: 650px;"> <legend><img src="imagens/sacola.png" alt="[imagem]"style="width:50px; height:45px"></legend> <br> <?php if(isset($_SESSION['msg'])): echo $_SESSION['msg']; session_unset(); endif; ?> <?php if (!@include_once "conexao.php" ) {echo "Arquivo: conexao.php não incluso";}; $x = 1; $sacola = 1; while($x <= 4) { echo "<div class='linha".$x."'>"; $y = 1; while ($y <= 5) { $sql = "SELECT SACOLA FROM TB_EMPRESTIMO WHERE SACOLA = ".$sacola." and SITUACAO = 2"; if($resultset = mysqli_fetch_assoc(mysqli_query($sql))) {; echo "<button id='botao' data-numero='".$sacola."' onclick='mudaCor(this)' style='width:120px; height:37px; background-color: #FF0000;'>".$sacola."</button>"; } else { echo "<button id='botao' data-numero='".$sacola."' onclick='mudaCor(this)' style='width:120px; height:37px; background-color: #0000FF;'>".$sacola."</button>"; } $sacola = $sacola + 1; $y = $y + 1; } $x = $x + 1; } ?> </fieldset> </div> <?php include_once 'includes/footer.inc.php';?> <?php include_once 'includes/script.inc.php'; create.php <?php session_start(); include_once 'conexao.php'; $nome = $_POST [ 'nome' ]; $telefone = $_POST [ 'telefone' ]; $cpf = $_POST [ 'cpf' ]; $sacola = $_POST [ 'sacola' ]; $periodo = $_POST [ 'periodo' ]; $situacao = $_POST [ 'situacao' ]; $queryInsert = $link->query("insert into tb_emprestimo VALUES(NULL,'".$nome."','".$telefone."','".$cpf."','".$sacola."','".$periodo."','".$situacao."')"); $affected_rows = mysqli_affected_rows($link); if($affected_rows > 0): $_SESSION['msg'] = "<p class='center green-text'>".'Empréstimo efetuado com Sucesso!'."<br>"; header("Location: ../sacola.php"); endif; emprestimo.php <?php session_start(); include_once 'includes/header.inc.php'; include_once 'includes/menu.inc.php'; ?> <!-- Formulário de Cadastro Cliente --> <div class="row container"> <p>&nbsp;</p> <form action="banco_de_dados/create.php" method="post" class="col s12"> <fieldset class="formulario" style="padding: 5px"> <legend><img src="imagens/sacola.png" alt="[imagem]"style="width:80px; height:45px"></legend> <br> <?php if(isset($_SESSION['msg'])): echo $_SESSION['msg']; session_unset(); endif; ?> <!-- Campo Nome --> <div class="input-field col s12"> <i class="material-icons prefix">account_circle</i> <input type="text" name="nome" id="nome" maxlength="40" required autofocus> <label for="nome">Nome</label> </div> <!-- Campo Telefone --> <div class="input-field col s12"> <i class="material-icons prefix">phone</i> <input type="text" name="telefone" id="telefone" maxlength="13" required> <label for="telefone">Telefone</label> </div> <!-- Campo Cpf --> <div class="input-field col s12"> <i class="material-icons prefix">credit_card</i> <input type="text" name="cpf" id="cpf" maxlength="14" required> <label for="cpf"> CPF</label> </div> <!-- Campo Número da Sacola --> <div class="input-field col s12"> <i class="material-icons prefix">mode_edit</i> <label>Numero da Sacola</label> <input type="text" value="<?php echo isset($_GET['sacola']) ? $_GET['sacola'] : null; ?>"> </div> <!-- Campo Periodo --> <div class="input-field col s12"> <i class="material-icons prefix">timelapse</i> <select name="periodo"> <option value="" disabled selected>Período</option> <option value="manha">Manhã</option> <option value="tarde">Tarde</option> <option value="noite">Noite</option> </select> </div> <!-- Botões --> <div class="input-field col s12"> <input type="submit"style="width:120px; height:37px" value="Empréstimo" class="btn blue"> <input type="submit"style="width:120px; height:37px" value="Devolução" class="btn red"> <input type="reset" style="width:120px; height:37px" value="limpar" class="btn lilac"> </div> </fieldset> </form> </div> <?php include_once 'includes/script.inc.php'; script da pagina <!-- Arquivos Jquery e JavaScrip --> <script type="text/javascript" src="materialize/js/jquery-3.3.1.min.js"></script> <script type="text/javascript" src="materialize/js/materialize.min.js"></script> <script type="text/javascript" src="materialize/js/jquery.mask.min"></script> <script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script> <script src="https://cdnjs.cloudflare.com/ajax/libs/materialize/1.0.0/js/materialize.min.js"></script> <script src="https://cdnjs.cloudflare.com/ajax/libs/jquery.maskedinput/1.3.1/jquery.maskedinput.min.js"></script> <!-- Inicialização Jquery --> <script type="text/javascript"> $(document).ready(function(){ $('.sidenav').sidenav(); $('.dropdown-trigger').dropdown(); }); </script> <!-- Inicialização Jquery Mascaras --> <script type="text/javascript"> jQuery.noConflict(); jQuery(function($){ //$("#datanasc").mask("99/99/9999"); //$("#telefone").mask("(099)99999-9999"); $("#cpf").mask("999.999.999-99"); }); document.addEventListener('DOMContentLoaded', function() { var elems = document.querySelectorAll('select'); var instances = M.FormSelect.init(elems, options); }); // Or with jQuery $(document).ready(function(){ $('select').formSelect(); }); </script> <script> //pega todos os botões const botões = document.querySelectorAll('#botao'); for (let i = 0; i < botões.length; i++) { //escuta o evento de click em cada botao botões[i].addEventListener('click', function (e) { //pega o numero do botao clicado const sacola = this.dataset.numero; //redireciona para emprestimos.php passando o numero do botao window.location.href = `emprestimo.php?sacola=${sacola}`; }); } </script> <script> //muda cor do botão function mudaCor(el){ var cor = el.style.backgroundColor; if(cor == 'rgb(0, 0, 255)') { el.style.backgroundColor = '#FF0000'; } else { el.style.backgroundColor = '#0000FF'; } } </script> </body> </html> estrutura do banco em phpadmin

<!DOCTYPE html> <html> <head> <title>teste</title> <!-- SCRIPTS --> <link rel="stylesheet" href="estilo.css"> <link rel="stylesheet" href="http://code.jquery.com/ui/1.9.0/themes/base/jquery-ui.css" /> <script src="http://code.jquery.com/jquery-1.8.2.js"></script> <script src="http://code.jquery.com/ui/1.9.0/jquery-ui.js"></script> </head> </head> <body> <h3><b>BIBLIOTECA CENTRAL<b /></h3> <form> <!-- Empréstimo de Socolas--> <fieldset> <legend>Empréstimo de Socola</legend> <table cellspacing="10"> <tr> <td> <label for="nome">Nome: </label> </td> <td align="left"> <input type="text" name="Nome" size="30" maxlength="25"> </td> </tr> <tr> <td> <label for="carterinha">Carterinha: </label> </td> <td align="left"> <input type="text" name="carterinha" size="10" maxlength="25"> </td> </tr> <tr> <td> <label for="cpf">CPF: </label> </td> <td align="left"> <input type="text" name="cpf" size="10" maxlength="25"> </td> </tr> <textarea rows="2" cols="51" maxlength="80"></textarea> <tr> <td> <label for="txtDtaEmprestimo">Data Empréstimo:</label> </td> <td align="left"> <input type="text" name="txtDtaEmprestimo" class="txtDta"> </td> </tr> <td> <hr> <label for="cpf">Período: </label><br><br> <input type="checkbox" name=mybox value="1">Manha<br> <input type="checkbox" name=mybox value="2">Tarde<br> <input type="checkbox" name=mybox value="3">Noite<br> </td> <center> <table class="cpo1" border="0" cellpadding="2" cellspacing="2"> <tr> <td class="sacola">01</td> <td class="sacola">02</td> <td class="sacola">03</td> <td class="sacola">04</td> <td class="sacola">05</td> <td class="sacola">06</td> <td class="sacola">07</td> <td class="sacola">08</td> <td class="sacola">09</td> <td class="sacola">10</td> <td class="sacola">11</td> <td class="sacola">12</td> </tr> <tr> <td class="sacola">13</td> <td class="sacola">14</td> <td class="sacola">15</td> <td class="sacola">16</td> <td class="sacola">17</td> <td class="sacola">18</td> <td class="sacola">19</td> <td class="sacola">20</td> <td class="sacola">21</td> <td class="sacola">22</td> <td class="sacola">23</td> <td class="sacola">24</td> </tr> </table> </table> </center> </fieldset> <input type="reset" value="Limpar"> </form> <script type="text/javascript"> jQuery(function ($) { $.datepicker.regional['pt'] = { closeText: 'Fechar', prevText: 'Anterior', nextText: 'Seguinte', currentText: 'Hoje', monthNames: ['Janeiro', 'Fevereiro', 'Mar&ccedil;o', 'Abril', 'Maio', 'Junho', 'Julho', 'Agosto', 'Setembro', 'Outubro', 'Novembro', 'Dezembro'], monthNamesShort: ['Jan', 'Fev', 'Mar', 'Abr', 'Mai', 'Jun', 'Jul', 'Ago', 'Set', 'Out', 'Nov', 'Dez'], dayNames: ['Domingo', 'Segunda-feira', 'Ter&ccedil;a-feira', 'Quarta-feira', 'Quinta-feira', 'Sexta-feira', 'S&aacute;bado'], dayNamesShort: ['Dom', 'Seg', 'Ter', 'Qua', 'Qui', 'Sex', 'S&aacute;b'], dayNamesMin: ['Dom', 'Seg', 'Ter', 'Qua', 'Qui', 'Sex', 'S&aacute;b'], weekHeader: 'Sem', dateFormat: 'dd/mm/yy', firstDay: 0, isRTL: false, showMonthAfterYear: false, yearSuffix: '' }; $.datepicker.setDefaults($.datepicker.regional['pt']); $('.txtDta').datepicker({ locale: 'pt-br' }); }); </script> </body> </html> body { background-color: #0489B1; font-family: "Trebuchet MS", Arial, Helvetica, sans-serif; margin:0px; font-size:0.7em; } .sacola:link { color: #999; text-decoration: none; } .sacola:visited { text-decoration: none; } .sacola:hover { background: #A9E2F3; color: #000000; font-weight: bold; border-color: #0404B4; } .sacola:active{ background: #B40404; color: #FFF; font-weight: bold; border-color: #0404B4; } .sacola { background: -webkit-linear-gradient(bottom, #E0E0E0, #F9F9F9 70%); background: -moz-linear-gradient(bottom, #E0E0E0, #F9F9F9 70%); background: -o-linear-gradient(bottom, #E0E0E0, #F9F9F9 70%); background: -ms-linear-gradient(bottom, #E0E0E0, #F9F9F9 70%); background: linear-gradient(bottom, #E0E0E0, #F9F9F9 70%); border: 1px solid #CCCCCE; border-radius: 3px; box-shadow: 0 3px 0 rgba(0, 0, 0, .3), 0 2px 7px rgba(0, 0, 0, 0.2); height: 40px; width: 40px; cursor:pointer; font-family:"Trebuchet MS", Arial, Helvetica, sans-serif; font-size: 11px; font-weight: bold; color: #000000; text-indent: 12px; } Nova pasta.rar