WHaG8PAY

1CREATE TABLE IF NOT EXISTS `category` (
2`id` int(11) NOT NULL auto_increment,
3`refid` int(11) NOT NULL,
4`realid` int(11) NOT NULL,
5`icon` varchar(50) NOT NULL,
6`name` varchar(250) NOT NULL,
7`translate` varchar(250) NOT NULL,
8`text` varchar(5000) NOT NULL,
9`keywords` varchar(2500) NOT NULL,
10`description` varchar(2500) NOT NULL,
11PRIMARY KEY (`id`),
12KEY `refid` (`refid`)
13) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
14	
15<select name="cat_id[]" id="category-0" class="form-control" onchange="select_category('0', '{$panel}');" required>
16   <option value="">---</option>
17   {foreach from=$acategory item=category}
18   <option value="{$category.id}">{$category.name|esc}</option>
19   {/foreach}
20</select>
21	
22{if $count > 0}
23<div class="col-md-4 col-sm-4 col-xs-4">
24   <select name="cat_id[]" id="category-{$row.id}" class="form-control" onchange="select_category('{$row.id}', '{$panel}');" required>
25      <option value="">---</option>
26      {foreach from=$acategory item=category}
27      <option value="{$category.id}">{$category.name|esc}</option>
28      {/foreach}
29   </select>
30</div>
31{/if}
32	
33function select_category(refid, admin) {
34    var id = $('#category-' + refid).val();
35    $.ajax({
36        data: {id: id, refid: refid},
37        type: "POST",
38        url: admin + '/category/select',
39        dataType: 'json',
40        success: function (data) {
41            if (data.error.length > 0) { // eсли oбрaбoтчик вeрнул oшибку
42                new Noty({
43                    type: 'error',
44                    layout: 'topRight',
45                    theme: 'relax',
46                    text: data['error'],
47                    timeout: 2000,
48                }).show();
49            } else {
50                if (data.count > 0) {
51                    $('#category').append(data.content);
52                }
53            }
54        }
55    });
56}