Depending on which item is selected, after pressing the button, your SQL query should be executed. The problem is that I do not know how to associate the value of a select with php processing. The same question to the checkbox. Code:

if(isset($_POST['show-select'])) { $strSQL="SELECT * FROM worktime WHERE year(date)= year(now()) AND week(date, 1) = week(now(), 1) AND pcid='".$_SESSION['currpcid']."' AND date BETWEEN '$start_date' AND '$end_date' ORDER BY date DESC"; //Выбор записей за неделю } <form action="" method="post" name="dropdownlist" id="select-interval"> <select class="select rounded shadow" id="workname" size="1"> <option disabled selected>Выберите интервал</option> <option value="week">Неделя</option> <option value="month">Месяц</option> <option value="month3">Квартал</option> <option data-type="range">Выберите даты...</option> </select> <input class="submit color_button rounded" type="submit" value="Выбрать" name="show-select" id="submit" /><Br> <input type="checkbox" name="otchet" value="a1">Создать отчет </form>
  • It seems you forgot to assign the name to this select - oleg kalenchuk

2 answers 2

First of all you need to put the name attribute to this select

 if(isset($_POST['show-select'])) { echo $_POST['interval']; // здесь ваше значение от select echo $_POST['otchet']; // здесь ваше значение от checkbox (или a1 или пустота) $strSQL="SELECT * FROM worktime WHERE year(date)= year(now()) AND week(date, 1) = week(now(), 1) AND pcid='".$_SESSION['currpcid']."' AND date BETWEEN '$start_date' AND '$end_date' ORDER BY date DESC"; //Выбор записей за неделю } <form action="" method="post" name="dropdownlist" id="select-interval"> <select name="interval" class="select rounded shadow" id="workname" size="1"> <option disabled selected>Выберите интервал</option> <option value="week">Неделя</option> <option value="month">Месяц</option> <option value="month3">Квартал</option> <option data-type="range">Выберите даты...</option> </select> <input class="submit color_button rounded" type="submit" value="Выбрать" name="show-select" id="submit" /><Br> <input type="checkbox" name="otchet" value="a1">Создать отчет </form>

    select should have a name:

     <select name='show-select' ...>

    Have checkbox

     <input type="checkbox" name="otchet" value="a1">

    If it is pressed, $_POST['otchet'] will be equal to a1 ,
    if not pressed, $_POST['otchet'] will be empty