This is a migrated thread and some comments may be shown as answers.

[Solved] trying kendo ui grid..

1 Answer 105 Views

Grid

This is a migrated thread and some comments may be shown as answers.

Gagan asked on 15 Dec 2014, 06:37 PM

This code didnt seem to work. What Am I doing wrong?



<!DOCTYPE html>

<html>

<head>

<link href="styles/kendo.common.min.css" rel="stylesheet" type="text/css" />

<link href="styles/kendo.default.min.css" rel="stylesheet" type="text/css" />

<script src="js/jquery.min.js"></script>

<script src="js/kendo.web.min.js"></script>

</head>

<body>

<?php

require_once 'lib/Kendo/Autoload.php';

$db = new PDO('mysql:host=localhost; dbname=sportssuite_demo', 'root', 'toor');

$statement=$db->prepare('SELECT * FROM sys_frm');

$statement-> execute();

$sys_frm= $statement->fetchAll(PDO::FETCH_ASSOC);

$model = new \Kendo\Data\DataSourceSchemaModel();

$frmfield = new \Kendo\Data\DataSourceSchemaModelField('Formulario');

$frmfield->type('string');

$ordenfield = new \Kendo\Data\DataSourceSchemaModelField('Orden');

$ordenfield->type('number');

$datafield = new \Kendo\Data\DataSourceSchemaModelField('Data');

$datafield->type('string');

$paramfield = new \Kendo\Data\DataSourceSchemaModelField('ParamType');

$paramfield->type('string');

$model->addField($frmfield, $ordenfield, $datafield, $paramfield);

$schema = new \Kendo\Data\DataSourceSchema();

$schema->model($model)

$dataSource = new \Kendo\Data\DataSource();

$dataSource->data($sys_frm)

->schema($schema);

$grid = new \Kendo\UI\Grid('grid');

$frmcolumn = new \Kendo\UI\GridColumn();

$frmcolumn->field('Forumulario')

->title('Formulario');

$ordencolumn = new \Kendo\UI\GridColumn();

$ordencolumn->field('Orden')

->width('130px')

->format('{0:c}')

->title('Orden');

$datacolumn = new \Kendo\UI\GridColumn();

$datacolumn->field('Data')

->width('130px');

$paramcolumn = new \Kendo\UI\GridColumn();

$paramcolumn->field('ParamType')

->width('130px');

$grid->addColumn($frmcolumn, $ordencolumn, $datacolumn, $paramcolumn);

echo $grid->render();

?>

</body>

</html>

[Solved] trying kendo ui grid..

1 Answer, 1 is accepted