require_once'_variables.php';
require_once'_mysql.php';
$result = new baseConnect();
$table = '';
$r = '';
$arrEmployee = [];
$i = 0;
$res = $result::connectTables("SELECT id, email, name, login, name_role, date_regist, date_input, date_output FROM "._TABLE_STAFF_);
while( $e = mysqli_fetch_assoc($res) ) {
$arrId = $e['id'];
$arrEmail = $e['email'];
$arrName = $e['name'];
$arrLogin = $e['login'];
$arrNameRole = $e['name_role'];
$arrDateReg = $e['date_regist'];
$arrDateInp = $e['date_input'];
$arrDateOut = $e['date_output'];
$i++;
$arrEmployee[$i] = [$arrId,$arrEmail,$arrName,$arrLogin,$arrNameRole,$arrDateReg,$arrDateInp,$arrDateOut];
}
foreach ($arrEmployee as $key => $value) {
$t = '<td>'.$value[0].'</td>'.
'<td>'.$value[1].'</td>'.
'<td>'.$value[2].'</td>'.
'<td>'.$value[3].'</td>'.
'<td>'.$value[4].'</td>'.
'<td>'.$value[5].'</td>'.
'<td>'.$value[6].'</td>'.
'<td>'.$value[7].'</td>'.
'<td><a id="'.$value[0].'" class="editing" href="#"><i class="ion-compose"></i></a></td>'.
'<td><a id="'.$value[0].'" class="removal" href="#"><i class="ion-close-round"></i></a></td>';
$table.='<tr>'.$t.'</tr>';
}
$out = json_encode(array(
table => $table,
));
echo $out;
$arrEmployee = [];
$result::MySQLClose();