using json with jquery for jtables?

Question

I am using jtables (http://www.jtable.org), but one of the options to create a combobox (dropdown menu) is such:

Branch: {
    title: 'Branch',
    type: 'list',
    options: {
        '1': 'Auckland',
        '2': 'Queensland'
    }
}

I want to be able to use a mysql query (JSON'ed?) for my "options" instead of hardcoding it. Any ideas?

Manuel · Accepted Answer · 2013-10-29 10:42:17Z

3

Branch:{
  title: 'Page Name',
  width: '30%',
  options:  'FieldNameLoader.php?action=Branch',
  list :true
}

if($_GET["action"] == "Branch") {


$result = mysql_query("SELECT * from tblPagelist ORDER BY PageName ASC;");
$rows = array();
while ($row = mysql_fetch_array($result)) {
    $eil = array();
    $eil["DisplayText"] = $row[1];
    $eil["Value"] = $row[0];
    $rows[] = $eil;
    }
$jTableResult = array();
$jTableResult['Result'] = "OK";
$jTableResult['Options'] = $rows;  
print json_encode($jTableResult);    }

edited Oct 29, 2013 at 10:42

Manuel

4,4536 gold badges38 silver badges52 bronze badges

answered Oct 29, 2013 at 10:18

Praveen Jayanna

213 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

user1403947 · Accepted Answer · 2012-05-22 16:25:07Z

1

Use PHP's json_encode with mysql_fetch_array

PHP

while($row = mysql_fetch_array($query)) {
  $options[$row['id']] = $row['name'];
}

$options = json_encode($options);

JSON

Branch: {
  title: 'Branch',
  type: 'list',
  options: <?=$options?>
}

answered May 22, 2012 at 16:25

user1403947

2 Comments

marche Over a year ago

doing this doesnt load the page at all.. I even tried putting <?php=$options?> but still nothing.. I checked the PHP and echo'ed the json, it is showing properly, but somehow the jquery plugin is refusing to load. Using options: <?php echo json_encode($options) ?> inside the jquery, the page loads, but the plugin is not showing the options displayed by the json

marche Over a year ago

OK, I was able to finally get it to work using <?php echo json_encode($options) ?> Just forgot to remove the comment of my include.. lol

Naftali · Accepted Answer · 2012-05-22 16:23:14Z

0

What I do is on the php side I query everything and put it into an array and then echo it to the javascript page:

            Branch: {
                title: 'Branch',
                type: 'list',
                options: <?php echo json_encode($branchArray)?>
            }

answered May 22, 2012 at 16:23

Naftali

147k41 gold badges247 silver badges304 bronze badges

Collectives™ on Stack Overflow

using json with jquery for jtables?

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related