jQWidgets Forums

Forum Replies Created

Viewing 5 posts - 16 through 20 (of 20 total)
1 2
  • Author
    Posts
  • February 18, 2014 at 1:55 pm in reply to: I am getting no results I am getting no results #49683

    kbloem
    Participant

    Problem solved. I had some wrong code in one of the files.

    Thanks Peter!

    February 15, 2014 at 8:53 pm in reply to: I am getting no results I am getting no results #49577

    kbloem
    Participant

    Help i still need help with this.

    I followed the manuals and everything seems correct. When i replace

    url: 'data.txt', with url: 'takenlijstdata.php', i get no results while they are both in the same folder. Even when i use the full path to the file i still get no data.

    Could you have another look?

    Thanks!

    February 10, 2014 at 6:49 am in reply to: I am getting no results I am getting no results #49205

    kbloem
    Participant

    Hello PEter,

    i just tested the data.txt and that seems to work. However, when i use a php file for the results i get no data. Any idea?

    February 8, 2014 at 12:41 am in reply to: I am getting no results I am getting no results #49143

    kbloem
    Participant

    Hi Peter,

    this is the data that is returned…

    [{“taaknummer”:”63″,”naam”:”Kenny”,”taak”:”Murdered: Soul Suspect voor Xbox One en PS4 aanmaken”,”prioriteit”:”Laag”,”datum”:”06-02-2014″},{“taaknummer”:”65″,”naam”:”Kenny”,”taak”:”Screenshots, Reviews, hoesje toevoegen voor Tomb Raider “,”prioriteit”:”Hoog”,”datum”:”06-02-2014″},{“taaknummer”:”64″,”naam”:”Massai”,”taak”:”Features tomb raider aanpassen naar PS4 en Xbox One (toevoegen aan platform)”,”prioriteit”:”Hoog”,”datum”:”06-02-2014″},{“taaknummer”:”66″,”naam”:”Kenny”,”taak”:”Killer Instinct Xbox One aanmaken”,”prioriteit”:”Middel”,”datum”:”06-02-2014″},{“taaknummer”:”67″,”naam”:”Massai”,”taak”:”Features Killer instinct Xbox One kijken of ze er zijn”,”prioriteit”:”Middel”,”datum”:”06-02-2014″},{“taaknummer”:”68″,”naam”:”Kenny”,”taak”:”Warframe aanmaken voor PS4 en PC”,”prioriteit”:”Hoog”,”datum”:”06-02-2014″},{“taaknummer”:”69″,”naam”:”Massai”,”taak”:”Features van Warframe bij elkaar zoeken”,”prioriteit”:”Middel”,”datum”:”06-02-2014″},{“taaknummer”:”73″,”naam”:”Kenny”,”taak”:”Filter op nieuwsarchief”,”prioriteit”:”Middel”,”datum”:”07-02-2014″},{“taaknummer”:”72″,”naam”:”Kenny”,”taak”:”Mass Effect 4 toevoegen”,”prioriteit”:”Middel”,”datum”:”06-02-2014″},{“taaknummer”:”74″,”naam”:”Kenny”,”taak”:”Releasekalender”,”prioriteit”:”Middel”,”datum”:”07-02-2014″},{“taaknummer”:”75″,”naam”:”Kenny”,”taak”:”releasecheck”,”prioriteit”:”Hoog”,”datum”:”07-02-2014″},{“taaknummer”:”76″,”naam”:”Kenny”,”taak”:”url uniek maken”,”prioriteit”:”Heel Hoog”,”datum”:”07-02-2014″},{“taaknummer”:”77″,”naam”:”Kenny”,”taak”:”apache redirects”,”prioriteit”:”Heel Hoog”,”datum”:”07-02-2014″},{“taaknummer”:”79″,”naam”:”Kenny”,”taak”:”Captcha images “,”prioriteit”:”Hoog”,”datum”:”07-02-2014″}]

    And this is the code i use to get that data..

    $query = "SELECT * FROM takenlijst";
$from = 0; 
$to = 999;
$query .= " LIMIT ".$from.",".$to;
$result = mysql_query($query) or die("SQL Error 1: " . mysql_error());
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
	$taken[] = array(
    'taaknummer' => $row['taaknummer'],
    'naam' => $row['naam'],
	'taak' => $row['taak'],
	'prioriteit' => $row['prioriteit'],
	'datum' => $row['datum']
      );
}
echo json_encode($taken);
    February 7, 2014 at 3:19 pm in reply to: I am getting no results I am getting no results #49134

    kbloem
    Participant

    Sorry, this is the correct code…

    ‘<!DOCTYPE html>
    <html lang=”en”>
    <head>
    <link rel=”stylesheet” href=”http://www.site.nl/jquery/jqwidgets/styles/jqx.base.css” type=”text/css” />
    <link rel=”stylesheet” href=”http://www.site.nl/jquery/jqwidgets/styles/jqx.classic.css” type=”text/css” />
    <script type=”text/javascript” src=”http://www.site.nl/jquery/scripts/jquery-1.10.2.min.js”></script>
    <script type=”text/javascript” src=”http://www.site.nl/jquery/jqwidgets/jqxcore.js”></script>
    <script type=”text/javascript” src=”http://www.site.nl/jquery/jqwidgets/jqxbuttons.js”></script>
    <script type=”text/javascript” src=”http://www.site.nl/jquery/jqwidgets/jqxscrollbar.js”></script>
    <script type=”text/javascript” src=”http://www.site.nl/jquery/jqwidgets/jqxmenu.js”></script>
    <script type=”text/javascript” src=”http://www.site.nl/jquery/jqwidgets/jqxdata.js”></script>
    <script type=”text/javascript” src=”http://www.site.nl/jquery/jqwidgets/jqxgrid.js”></script>
    <script type=”text/javascript” src=”http://www.site.nl/jquery/jqwidgets/jqxgrid.selection.js”></script>
    <script type=”text/javascript”>
    $(document).ready(function () {
    // prepare the data
    var source =
    {
    datatype: “json”,
    datafields: [
    { name: ‘taaknummer’, type: ‘string’},
    { name: ‘naam’, type: ‘string’},
    { name: ‘taak’, type: ‘string’},
    { name: ‘prioriteit’, type: ‘string’},
    { name: ‘datum’, type: ‘string’}
    ],
    url: ‘takenlijstdata.php’,
    cache: false
    };

    var dataAdapter = new $.jqx.dataAdapter(source);

    $(“#jqxgrid”).jqxGrid(
    {
    source: dataAdapter,
    theme: ‘classic’,
    columns: [
    { text: ‘Company Name’, datafield: ‘taaknummer’, width: 250},
    { text: ‘ContactName’, datafield: ‘naam’, width: 150 },
    { text: ‘Contact Title’, datafield: ‘taak’, width: 180 },
    { text: ‘Address’, datafield: ‘prioriteit’, width: 200 },
    { text: ‘City’, datafield: ‘datum’, width: 120 }
    ]
    });
    });
    </script>
    </head>
    <body class=’default’>
    <div id=”jqxgrid”></div>
    </body>
    </html>
    ‘

  • Author
    Posts
Viewing 5 posts - 16 through 20 (of 20 total)
1 2