or
var userList = new kendo.data.DataSource({ transport: { read: { url: "php/usersModel.php", dataType: "json"}, data: {operationCode:"showUsers"}, type: "post" }, pageSize:10 });$operationCode = $_POST['operationCode'];$conn= new MySQLI($host,$user,$DBpassword,$baza);if (!empty($operationCode)){ Switch($operationCode) { case "deleteUser" : if (!empty($id)) { deleteUser($id,$conn,$baza); } break; case "showUsers" : showUsers($conn,$baza); break; case "addUser" : addUser($baza,$conn,$serializedData,$operationCode); break; case "editUser": editUser($conn,$baza,$serializedData,$operationCode); break; case "showLogs": showLogs($conn); break; }}function showUsers($conn,$baza){ $queryString="select id,username,email,telefon,imie,nazwisko,userlevel from ".$baza.".users t1 left join user_dane t2 on t1.id=t2.userid where t1.userlevel<>9 order by t1.id"; $results=mysqli_query($conn,$queryString); $usersResult = array(); while ($row=mysqli_fetch_assoc($results)) { array_push($usersResult, array('id'=>$row['id'], 'username'=>$row['username'], 'email'=>$row['email'], 'telefon'=>$row['telefon'], 'userlevel'=>$row['userlevel'], 'imie'=>$row['imie'], 'nazwisko'=>$row['nazwisko'] ) ); } echo json_encode($usersResult); }

