Новичок
Покинул форум
Сообщений всего: 30
Дата рег-ции: Янв. 2017
Помог: 0 раз(а)
|
Cпасибо. Выбор появился но данные не передаються в базуданных вот полностью код.
kassa.php Спойлер (Отобразить)CODE ( htmlphp):
скопировать код в буфер обмена
<?PHP if($_SESSION['user']){ } else{ } $username = $_SESSION['user']; $class = $_SESSION['class']; require 'home.php'; ?> <html> <head> <title><?=$config['title']?></title> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/> </head> <body> <table border="2" align="center"> <tr> <td align="center" >id</td> <td align="center">Номер документа</td> <td align="center">Номер договора</td> <td align="center">Имя клиента</td> <td align="center">Основание</td> <td align="center" size="5">Приход</td> <td align="center" size="5">Расход</td> <td align="center">Тело кредита</td> <td align="center">%</td> <td align="center">Штраф</td> <td align="center">НУ</td> <form method="POST"> <td align="center"><input type="date" name="needdate" value="<?php echo $_POST['needdate']?>"/></td> <!--ввожу нужную переменную--> <td align="center"><input type="submit" name="ondate" value="На дату"/></th> <!--кнопка после которой начинаеться обработка--> </form> <td></td> <td align="center">ФИО кассира</td> <td align="center">Название офиса</td> </tr> <?php // остановился тут !!! if(isset($_POST['ondate'])) //условия о кнопки если она нажата { $needdate = trim($_POST['needdate']); // приравниваяю данные из переменной print_r('переменная 1 : '. $_POST['needdate']); // вывожу для себя визуально переменную переменная 1 $needdate $where = !empty($needdate) ? "AND `date` = '" . $needdate . "'" : ''; //формирую дополнение к запросу sql где таблице ищю столбец с заголовком `cratedate` и в нем пытаюсь найти полученную переменную '$needdate' print_r(' переменная 2 : '.$where); // вывожу визуально для себя этот запрос переменная 2 $where $result = mysqli_query($connection, "SELECT kassa.id, kassa.numberdocument, kassa.numberagreement, kassa.nameofclient, kassa.base, kassa.coming, kassa.consumption, kassa.bodyloan, kassa.interest, kassa.fine, kassa.well, kassa.date, kassa.idofoffice, kassa.idofuser, kassa.dateofpost, users.user, office.nameofoffice FROM kassa INNER JOIN users ON users.id = kassa.idofuser INNER JOIN office ON office.idofoffice = kassa.idofoffice WHERE office.idofoffice = $class " . $where . " "); //запрос на вывод данных из таблицы $sum4 += $row['coming']; $sum5 += $row['consumption']; $sum6 += $row['bodyloan']; $sum7 += $row['interest']; $sum8 += $row['fine']; $sum9 += $row['well']; Print '<tr>'; Print '<td align="center">'. $row['id'] . "</td>"; Print '<td align="center">'. $row['numberdocument'] . "</td>"; Print '<td align="center">'. $row['numberagreement'] . "</td>"; Print '<td align="center">'. $row['nameofclient'] . "</td>"; Print '<td align="center" size="5">'. $row['base'] . "</td>"; Print '<td align="center" size="5">'. $row['coming'] . "</td>"; Print '<td align="center">'. $row['consumption'] . "</td>"; Print '<td align="center">'. $row['bodyloan'] . "</td>"; Print '<td align="center">'. $row['interest'] . "</td>"; Print '<td align="center">'. $row['fine'] . "</td>"; Print '<td align="center">'. $row['well'] . "</td>"; Print '<td align="center">'. $row['date'] . "</td>"; Print '<td align="center"><a href="editkassa.php?id='. $row['id'] .'">edit</a> </td>'; Print '<td align="center"><a href="#" onclick="myFunction('.$row['id'].')">delete</a> </td>'; Print '<td align="center">'. $row['user'] . "</td>"; Print '<td align="center">'. $row['nameofoffice'] . "</td>"; Print '</tr>'; endwhile; } else { $result = mysqli_query($connection, "SELECT kassa.id, kassa.numberdocument, kassa.numberagreement, kassa.nameofclient, kassa.base, kassa.coming, kassa.consumption, kassa.bodyloan, kassa.interest, kassa.fine, kassa.well, kassa.date, kassa.idofoffice, kassa.idofuser, kassa.dateofpost, users.user, office.nameofoffice FROM kassa INNER JOIN users ON users.id = kassa.idofuser INNER JOIN office ON office.idofoffice = kassa.idofoffice WHERE office.idofoffice = $class "); $sum4 += $row['coming']; $sum5 += $row['consumption']; $sum6 += $row['bodyloan']; $sum7 += $row['interest']; $sum8 += $row['fine']; $sum9 += $row['well']; Print '<tr>'; Print '<td align="center">'. $row['id'] . "</td>"; Print '<td align="center">'. $row['numberdocument'] . "</td>"; Print '<td align="center">'. $row['numberagreement'] . "</td>"; Print '<td align="center">'. $row['nameofclient'] . "</td>"; Print '<td align="center" size="5">'. $row['base'] . "</td>"; Print '<td align="center" size="5">'. $row['coming'] . "</td>"; Print '<td align="center">'. $row['consumption'] . "</td>"; Print '<td align="center">'. $row['bodyloan'] . "</td>"; Print '<td align="center">'. $row['interest'] . "</td>"; Print '<td align="center">'. $row['fine'] . "</td>"; Print '<td align="center">'. $row['well'] . "</td>"; Print '<td align="center">'. $row['date'] . "</td>"; Print '<td align="center"><a href="editkassa.php?id='. $row['id'] .'">edit</a> </td>'; Print '<td align="center"><a href="#" onclick="myFunction('.$row['id'].')">delete</a> </td>'; Print '<td align="center">'. $row['user'] . "</td>"; Print '<td align="center">'. $row['nameofoffice'] . "</td>"; Print '</tr>'; endwhile; } ?> <form method="POST" action="/addkassa.php"> <tr> <th>#</th> <th><input type="text" name="numberdocument" size="5" value="<?=$numberdocument?>"/><br/></th> <th><input type="text" name="numberagreement" step="1" size="15" value="<?=$numberagreement?>"/><br/></th> <th><input type="text" name="nameofclient" step="1" value="<?=$nameofclient?>"/><br/></th> <th><select> <option name="base" value="<?=$row['idofbase']?>"><?=$row['nameofbase']?></option> <? endwhile?> </select></th> <!--<input type="text" name="base" size="5" step="1" required="1" value="<?=$base?>"/><br/>--> <th><input type="number" name="coming" size="5" step="1" value="<?=$coming?>"/><br/></th> <th><input type="number" name="consumption" step="1" value="<?=$consumption?>"/><br/></th> <th><input type="number" name="bodyloan" step="1" value="<?=$bodyloan?>"/><br/></th> <th><input type="number" name="interest" step="1" value="<?=$interest?>"/><br/></th> <th><input type="number" name="fine" step="1" value="<?=$fine?>"/><br/></th> <th><input type="number" name="well" step="1" value="<?=$well?>"/><br/></th> <th><input type="date" name="date" size="5" value="<?php echo($curedate);?>"/><br/></th> <th><input type="submit" name="add" value="Добавить"/></th> </tr> </form> <tr> <td></td> <td></td> <td></td> <td></td> <td>Cуммма:</td> <td><?=$sum4?></td> <td><?=$sum5?></td> <td><?=$sum6?></td> <td><?=$sum7?></td> <td><?=$sum8?></td> <td><?=$sum9?></td> <td></td> </tr> </table> <script> function myFunction(id) { var r=confirm("Удалить?"); if (r==true) { window.location.assign("deletekassa.php?id=" + id); } } </script> </body> </html>
addkassa.phpСпойлер (Отобразить)CODE ( htmlphp):
скопировать код в буфер обмена
<?php require_once "home.php"; mysqli_query($connection, "INSERT INTO `kassa` (`numberdocument`,`numberagreement`,`nameofclient`,`base`,`coming`,`consumption`,`bodyloan`,`interest`,`fine`,`well`,`date`,`idofoffice`,`idofuser`,`dateofpost`) VALUES ('".$_POST['numberdocument']."','".$_POST['numberagreement']."','".$_POST['nameofclient']."','".$_POST['base']."','".$_POST['coming']."','".$_POST['consumption']."','".$_POST['bodyloan']."','".$_POST['interest']."','".$_POST['fine']."','".$_POST['well']."','".$_POST['date']."','".$_SESSION['class']."','".$_SESSION['id']."','".$curedate."')"); header("location:/kassa.php"); ?>
Прикреплено изображение (Нажмите для увеличения)
(Отредактировано автором: 05 Февраля, 2017 - 14:04:41)
|