or
001.<div id="grid"></div>002. 003.<script>004. $(document).ready(function() {005. var crudServiceBaseUrl = "main.php?a=quotereport", dataSource = new kendo.data.DataSource({006. transport : {007. read : {008. url : crudServiceBaseUrl + "&read=1",009. dataType : "json"010. },011. destroy : {012. url : crudServiceBaseUrl + "&destroy=1",013. dataType : "json"014. },015. parameterMap : function(options, operation) {016. if (operation !== "read" && options.models) {017. return {018. models : kendo.stringify(options.models)019. };020. }021. }022. },023. batch : true,024. schema : {025. data: "data",026. total: "total",027. model : {028. id : "id",029. fields : {030. id: {031. validation : {032. required : true033. }},034. first_name: {035. validation : {036. required : true037. }},038. last_name: {039. validation : {040. required : true041. }},042. dob: {043. validation : {044. required : true045. }},046. email: {047. validation : {048. required : true049. }},050. phone: {051. validation : {052. required : true053. }},054. age: {055. validation : {056. required : true057. }},058. date: {059. validation : {060. required : true061. }}062. }063. }064. }065. });066. 067. $("#grid").kendoGrid({068. dataSource : dataSource,069. pageable : false,070. height : 430,071. editable: 'inline',072. columns : [{073. field : "id",074. title : "ID"075. }, {076. field : "date",077. title : "Date" 078. }, {079. field : "first_name",080. title : "First Name"081. }, {082. field : "last_name",083. title : "Age"084. }, {085. field : "dob",086. title : "Birthday"087. }, {088. field : "email",089. title : "Email"090. }, {091. field : "phone",092. title : "Telephone"093. }, {094. field : "age",095. title : "Age" 096. }, 097. {098. command : ["destroy"],099. title : " ",100. width : "160px"101. }]102. });103. 104. }); 105.</script>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); }
