//if(current_user_can('administrator') || current_user_can('editor'))
{
include "phpqrcode/qrlib.php";
include "connect.php";
mysqli_set_charset($link, 'CP1251' );
$login=$_GET['login'];
if($login<>'')
{
$sql="SELECT * FROM wpdn_users WHERE user_login='$login'";
$result = mysqli_query($link,$sql);
while($dt = mysqli_fetch_array($result))
{ $id=$dt['ID'];
$startdate=$dt['start_date'];
$enddate=$dt['end_date'];
$b='
Друк протоколу '; echo $b;
$usercourse = mysqli_query($link,"SELECT * FROM courselist WHERE user_login='$login' ORDER BY topicname");
$i=1;
while($data = mysqli_fetch_array($usercourse))
{
$id_kod=$data['course_id'];
$sql="SELECT * FROM testresults WHERE user_login='$login' AND testmode='1' AND testname='$id_kod' AND (DATE(dateres) >= '$startdate' AND DATE(dateres) <= '$enddate') ORDER BY dateres ASC";
$results = mysqli_query($link,$sql);
while($datares = mysqli_fetch_array($results))
{
$hesh=$datares['hesh'];
include "protokolua.php";
echo '
';
}
}
echo '
';
}
}else{
echo 'Логин не указан
';
}
}
?>