global $wpdb;
include "connect.php";
//echo $_GET['login'];
$login='';
if(isset($_GET['login'])) $login=$_GET['login'];
if($login=='')
{
$user = wp_get_current_user();
$login=$user->user_login;
$id=$user->ID;
$r1=$user->user_lastname;
$r2=$user->user_name;
$r3=$user->user_middlename; ?>
Повернутися
}
else
{
// $login=$_GET['login'];
$sql="SELECT * FROM wpdn_users WHERE user_login='$login'";
$result = mysqli_query($link,$sql);
//$result = $wpdb->get_results($sql);
while($dt = mysqli_fetch_array($result))
{ $id=$dt[‘ID’];
$r1=$dt[‘user_lastname’];
$r2=$dt[‘user_name’];
$r3=$dt[‘user_middlename’]; }
?> Повернутися
}
$str=sprintf("Користувач: %s %s %s“,$r1,$r2,$r3); echo $str;
echo “
| № пп |
Режим |
Дата |
Результат |
Час, хв. |
Назва дисципліни |
“;
$all_results = $wpdb->get_results($wpdb->prepare(“SELECT a.id,a.dateres,a.user_login,a.testmode,a.correctq,a.totalq,a.percent,a.testtime,a.testname,a.hesh,b.name,b.id_kod FROM testresults a,{$wpdb->prefix}mtouchquiz_quiz b WHERE a.user_login=%s and a.testname=b.id_kod ORDER BY a.dateres DESC”,$login));
$i=1;
$b_body=””;
foreach ($all_results as $data)
{
if($data->testmode==’1′) $b_body.=’
| ‘.$i.’ |
‘;
else $b_body.=’
| ‘.$i.’ |
‘;
if($data->testmode==’1′) $b_body.=’
Іспит |
‘;
else $b_body.=’
Навчання |
‘;
$txt=date(“d-m-Y H:i:s”,strtotime($data->dateres));
//$b_body.=’
‘.$data->dateres.’ |
‘;
$b_body.=’
‘.$txt.’ |
‘;
if($data->testmode==’1′)
{ if($data->percent>=75) $b_body.=’
‘.$data->percent.’ % |
‘;
else $b_body.=’
‘.$data->percent.’ % |
‘;
}
else
{ if($data->percent>50) $b_body.=’
‘.$data->percent.’ % |
‘;
else $b_body.=’
‘.$data->percent.’ % |
‘;
}
$b_body.=’
‘.$data->testtime.’ |
‘;
$b_body.=’
‘.$data->name.’ |
‘;
$b_body.=’
‘;
$i++;
}
echo $b_body;
echo “
“;
?>