Also was haben wir: eine Tabelle
JavaScript
Index.js
var store = new Ext.data.Store({
url:
'db_query.php',
reader: new Ext.data.JsonReader({
root:'rows',
totalProperty: 'results',
id:'id'
},
[
'error_id',
'error_typ',
'error_title',
'error_message',
'error_solution'
])
});
var grid = new Ext.grid.EditorGridPanel({
id:
'grid_main',
store: store,
clickstoEdit: 1,
columns: [
{header: "Errortyp",
dataIndex: 'error_typ', width: 70, sortable: true, editor: error_typ_edit},
{header: "Error Title",
dataIndex: 'error_title', width: 300, sortable: true, editor:
error_title_edit},
{header: "Error Message",
dataIndex: 'error_message', width: 300, sortable: true, editor:
error_message_edit},
{header: 'Error Solution', dataIndex:
'error_solution',width: 700, sortable: true, editor: error_solution_edit}
]
});
Ext.onReady(function(){
var win
= new Ext.Window({
title:
'First Level Support',
layout:
'fit',
/*layout:
'border',*/
border:
false,
region: 'center',
renderTo: document.body,
frame:true,
height:700,
width:1400,
items: [grid]
});
win.show();
});
Alles anzeigen
Daten, die in der Tabelle oben sollen aus der Datenbank
"cop_support", tabele "solutions"
PHP
Mit Aufruf db_query.php geladen werden
<?php
$_db_host =
"localhost";
$_db_database =
"cop_support";
$_db_username =
"USER";
$_db_password =
"PASS";
$db_link =
mysqli_connect($_db_host, $_db_username, $_db_password, $_db_database);
$sql_query =
"SELECT * FROM 'solutions'";
$db_result =
mysqli_query( $db_link, $sql_query );
if ( !
$db_result ){
die('Invalid query: ' . mysqli_error());
}
while
($row = mysql_fetch_object($db_result)) {
$data[$row->id]
= $row->text;
}
mysqli_free_result(
$db_result );
?>
Alles anzeigen
Abe es funktioniert nicht! Mein Verdacht wäre store in index.js und db_query.php sind falsch.
Bitte um Hilfe!!