CRUD-2a

<?php
//=========berikut ini adalah list adminnya============
if(@isset($show) && $show=='admin')
{

?>
<link href="styles/kendo.common.min.css" rel="stylesheet">
<link href="styles/kendo.metro.min.css" rel="stylesheet">

<script src="js/jquery.min.js"></script>
<script src="js/kendo.web.min.js"></script>
<a href='?1'>back</a>
<div id='grid'></div>
<!-- TEMPLATENYA
Di sini kita butuh
id, name, email, pesan, status
-->
<script id="rowTemplate" type="text/x-kendo-tmpl">
                <tr>
                    <td class='no'>
                       #: name #
                    </td>
                    <td class="details">
                        #: email #
                    </td>
                    <td class="pos">
                       #: pesan #
                    </td>
                    <td class="pos">
                       #: status #
                    </td>
                    <td class="linkku">
                       <input type=button onclick='editData(#: id #);return false' value='Edit' />
        <input type=button onclick='deleteData(#: id #);return false' value='Delete' />
                    </td>
               </tr>
</script>
<hr>
sql:<pre>
CREATE TABLE IF NOT EXISTS `bukutamu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `detail` text NOT NULL,
  `pesan` text NOT NULL,
  `tanggal` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `stat` tinyint(4) NOT NULL,
  PRIMARY KEY (`id`)
)
</pre>
<script>
$(document).ready(function() {
    gridReload();
});

/*
GRID RELOAD
*/
function gridReload()
{
//===========div / form yang harus kosong sebelum grid jalan======

//==========Grid memakai json
 $("#grid").kendoGrid({
     dataSource: {
          transport: {
            read: {
            dataType: "json",
            url: "?act=json",
            }
           },
         pageSize: 10
     },
     groupable: true,
     sortable: true,
     pageable: {
         refresh: true,
         pageSizes: [10, 30, 50]
     },
     rowTemplate: kendo.template($("#rowTemplate").html()),
     height:490,
     columns: [ {
             field: "name",
             width: 40,
             title: "Nama"
         } , {
             field: "email",
             width: 20,
             title: "email"
         } ,{
             field: "pesan",
             width: 90,
             title: "Pesan"
         } , {
             field: "Status",
             width: 10,
             title: "Status"
         } , { command: "destroy", title: " ", width: "90px" }
     ]
 });
}
</script>
<?php
}