{"id":80,"date":"2021-07-06T12:31:15","date_gmt":"2021-07-06T12:31:15","guid":{"rendered":"http:\/\/localhost\/wordpress\/?page_id=80"},"modified":"2021-07-06T13:49:19","modified_gmt":"2021-07-06T13:49:19","slug":"columns-fields","status":"publish","type":"page","link":"https:\/\/xcrud.net\/wordpress\/index.php\/columns-fields\/","title":{"rendered":"Columns &#038; Fields"},"content":{"rendered":"\n<pre style=\"background:#777;color:#ffffff\" class=\"wp-block-code has-small-font-size\"><code><strong>&#91;xcrud]    \n    $xcrud = Xcrud::get_instance();\n    $xcrud-&gt;table('customers');\n    $xcrud-&gt;columns('customerName,phone,city,country'); \/\/ columns in grid\n    $xcrud-&gt;fields('customerName,creditLimit,salesRepEmployeeNumber'); \/\/ fields in details\n    echo $xcrud-&gt;render();\n&#91;\/xcrud]<\/strong><\/code><\/pre>\n\n\n<div class=\"xcrud\">\n<div style=\"display:none;\" class=\"xcrud-main-tab\">Customers<small> <\/small><\/div>\n<div class=\"xcrud-container\">\n<div class=\"xcrud-ajax\">\n            <input type=\"hidden\" class=\"xcrud-data\" name=\"key\" value=\"2d2de6d0da10973bf00edb74cf730cae280ffae2\" \/><input type=\"hidden\" class=\"xcrud-data\" name=\"orderby\" value=\"\" \/><input type=\"hidden\" class=\"xcrud-data\" name=\"order\" value=\"asc\" \/><input type=\"hidden\" class=\"xcrud-data\" name=\"start\" value=\"0\" \/><input type=\"hidden\" class=\"xcrud-data\" name=\"limit\" value=\"10\" \/><input type=\"hidden\" class=\"xcrud-data\" name=\"instance\" value=\"e32d985282738cc68327795197779c385fac9962\" \/><input type=\"hidden\" class=\"xcrud-data\" name=\"editmode\" value=\"\" \/><input type=\"hidden\" class=\"xcrud-data\" name=\"task\" value=\"list\" \/><\/p>\n<h2>Customers<small> <\/small><\/h2>\n<div class=\"xcrud-top-actions\">\n<div class=\"btn-group pull-right\">\n                <a href=\"javascript:;\" data-task=\"print\" class=\"btn btn-light xcrud-in-new-window xcrud-action\"><i class=\"fa fa-print\"><\/i> Print<\/a><a href=\"javascript:;\" data-task=\"csv\" class=\"btn btn-light xcrud-in-new-window xcrud-action\"><i class=\"fa fa-file\"><\/i> Export into CSV<\/a>            <\/div>\n<p>        <a href=\"javascript:;\" data-task=\"create\" class=\"btn btn-success xcrud-action\"><i class=\"fa fa-plus\"><\/i> Add<\/a>        <\/p>\n<div class=\"clearfix\"><\/div>\n<\/p><\/div>\n<div class=\"row\" style=\"margin: 0!important;overflow-x: scroll;\">\n<div class=\"xcrud-list-container \">\n<table class=\"xcrud-list table table-striped table-hover table-bordered\">\n<thead>\n<tr class=\"xcrud-th\">\n<th class=\"xcrud-num\">&#35;<\/th>\n<th data-order=\"asc\" data-orderby=\"customers.customerName\" class=\"xcrud-column xcrud-action\">Customername<\/th>\n<th data-order=\"asc\" data-orderby=\"customers.phone\" class=\"xcrud-column xcrud-action\">Phone<\/th>\n<th data-order=\"asc\" data-orderby=\"customers.city\" class=\"xcrud-column xcrud-action\">City<\/th>\n<th data-order=\"asc\" data-orderby=\"customers.country\" class=\"xcrud-column xcrud-action\">Country<\/th>\n<th class=\"xcrud-actions\">&nbsp;<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr class=\"xcrud-row xcrud-row-0\">\n<td class=\"xcrud-current xcrud-num\">1<\/td>\n<td>La Rochelle Gifts<\/td>\n<td>40.67.8555<\/td>\n<td>Nantes<\/td>\n<td>France<\/td>\n<td class=\"xcrud-current xcrud-actions xcrud-fix\"><span class=\"btn-group\"><a class=\"xcrud-action btn btn-info btn-sm\" title=\"View\" href=\"javascript:;\" data-primary=\"119\" data-task=\"view\"><i class=\"fa fa-search\"><\/i><\/a><a class=\"xcrud-action btn btn-warning btn-sm\" title=\"Edit\" href=\"javascript:;\" data-primary=\"119\" data-task=\"edit\"><i class=\"fa fa-edit \"><\/i><\/a><a class=\"xcrud-action btn btn-danger btn-sm\" title=\"Remove\" href=\"javascript:;\" data-primary=\"119\" data-task=\"remove\" data-confirm=\"Do you really want remove this entry?\"><i class=\"fa fa-remove\"><\/i><\/a><\/span><\/td>\n<\/tr>\n<tr class=\"xcrud-row xcrud-row-1\">\n<td class=\"xcrud-current xcrud-num\">2<\/td>\n<td>Baane Mini Imports<\/td>\n<td>07-98 9555<\/td>\n<td>Stavern<\/td>\n<td>Norway<\/td>\n<td class=\"xcrud-current xcrud-actions xcrud-fix\"><span class=\"btn-group\"><a class=\"xcrud-action btn btn-info btn-sm\" title=\"View\" href=\"javascript:;\" data-primary=\"121\" data-task=\"view\"><i class=\"fa fa-search\"><\/i><\/a><a class=\"xcrud-action btn btn-warning btn-sm\" title=\"Edit\" href=\"javascript:;\" data-primary=\"121\" data-task=\"edit\"><i class=\"fa fa-edit \"><\/i><\/a><a class=\"xcrud-action btn btn-danger btn-sm\" title=\"Remove\" href=\"javascript:;\" data-primary=\"121\" data-task=\"remove\" data-confirm=\"Do you really want remove this entry?\"><i class=\"fa fa-remove\"><\/i><\/a><\/span><\/td>\n<\/tr>\n<tr class=\"xcrud-row xcrud-row-0\">\n<td class=\"xcrud-current xcrud-num\">3<\/td>\n<td>Zbyszek Zbyszek Piestrzeniewicz<\/td>\n<td>266427555<\/td>\n<td>Warszawa<\/td>\n<td>Poland<\/td>\n<td class=\"xcrud-current xcrud-actions xcrud-fix\"><span class=\"btn-group\"><a class=\"xcrud-action btn btn-info btn-sm\" title=\"View\" href=\"javascript:;\" data-primary=\"125\" data-task=\"view\"><i class=\"fa fa-search\"><\/i><\/a><a class=\"xcrud-action btn btn-warning btn-sm\" title=\"Edit\" href=\"javascript:;\" data-primary=\"125\" data-task=\"edit\"><i class=\"fa fa-edit \"><\/i><\/a><a class=\"xcrud-action btn btn-danger btn-sm\" title=\"Remove\" href=\"javascript:;\" data-primary=\"125\" data-task=\"remove\" data-confirm=\"Do you really want remove this entry?\"><i class=\"fa fa-remove\"><\/i><\/a><\/span><\/td>\n<\/tr>\n<tr class=\"xcrud-row xcrud-row-1\">\n<td class=\"xcrud-current xcrud-num\">4<\/td>\n<td>Blauer See Auto, Co.<\/td>\n<td>+49 69 66 90 2555<\/td>\n<td>Frankfurt<\/td>\n<td>Germany<\/td>\n<td class=\"xcrud-current xcrud-actions xcrud-fix\"><span class=\"btn-group\"><a class=\"xcrud-action btn btn-info btn-sm\" title=\"View\" href=\"javascript:;\" data-primary=\"128\" data-task=\"view\"><i class=\"fa fa-search\"><\/i><\/a><a class=\"xcrud-action btn btn-warning btn-sm\" title=\"Edit\" href=\"javascript:;\" data-primary=\"128\" data-task=\"edit\"><i class=\"fa fa-edit \"><\/i><\/a><a class=\"xcrud-action btn btn-danger btn-sm\" title=\"Remove\" href=\"javascript:;\" data-primary=\"128\" data-task=\"remove\" data-confirm=\"Do you really want remove this entry?\"><i class=\"fa fa-remove\"><\/i><\/a><\/span><\/td>\n<\/tr>\n<tr class=\"xcrud-row xcrud-row-0\">\n<td class=\"xcrud-current xcrud-num\">5<\/td>\n<td>Land of Toys Inc.<\/td>\n<td>2125557818<\/td>\n<td>NYC<\/td>\n<td>USA<\/td>\n<td class=\"xcrud-current xcrud-actions xcrud-fix\"><span class=\"btn-group\"><a class=\"xcrud-action btn btn-info btn-sm\" title=\"View\" href=\"javascript:;\" data-primary=\"131\" data-task=\"view\"><i class=\"fa fa-search\"><\/i><\/a><a class=\"xcrud-action btn btn-warning btn-sm\" title=\"Edit\" href=\"javascript:;\" data-primary=\"131\" data-task=\"edit\"><i class=\"fa fa-edit \"><\/i><\/a><a class=\"xcrud-action btn btn-danger btn-sm\" title=\"Remove\" href=\"javascript:;\" data-primary=\"131\" data-task=\"remove\" data-confirm=\"Do you really want remove this entry?\"><i class=\"fa fa-remove\"><\/i><\/a><\/span><\/td>\n<\/tr>\n<tr class=\"xcrud-row xcrud-row-1\">\n<td class=\"xcrud-current xcrud-num\">6<\/td>\n<td>Euro+ Shopping Channel<\/td>\n<td>(91) 555 94 44<\/td>\n<td>Madrid<\/td>\n<td>Spain<\/td>\n<td class=\"xcrud-current xcrud-actions xcrud-fix\"><span class=\"btn-group\"><a class=\"xcrud-action btn btn-info btn-sm\" title=\"View\" href=\"javascript:;\" data-primary=\"141\" data-task=\"view\"><i class=\"fa fa-search\"><\/i><\/a><a class=\"xcrud-action btn btn-warning btn-sm\" title=\"Edit\" href=\"javascript:;\" data-primary=\"141\" data-task=\"edit\"><i class=\"fa fa-edit \"><\/i><\/a><a class=\"xcrud-action btn btn-danger btn-sm\" title=\"Remove\" href=\"javascript:;\" data-primary=\"141\" data-task=\"remove\" data-confirm=\"Do you really want remove this entry?\"><i class=\"fa fa-remove\"><\/i><\/a><\/span><\/td>\n<\/tr>\n<tr class=\"xcrud-row xcrud-row-0\">\n<td class=\"xcrud-current xcrud-num\">7<\/td>\n<td>Volvo Model Replicas, Co<\/td>\n<td>0921-12 3555<\/td>\n<td>Lule\u00c3\u00a5<\/td>\n<td>Sweden<\/td>\n<td class=\"xcrud-current xcrud-actions xcrud-fix\"><span class=\"btn-group\"><a class=\"xcrud-action btn btn-info btn-sm\" title=\"View\" href=\"javascript:;\" data-primary=\"144\" data-task=\"view\"><i class=\"fa fa-search\"><\/i><\/a><a class=\"xcrud-action btn btn-warning btn-sm\" title=\"Edit\" href=\"javascript:;\" data-primary=\"144\" data-task=\"edit\"><i class=\"fa fa-edit \"><\/i><\/a><a class=\"xcrud-action btn btn-danger btn-sm\" title=\"Remove\" href=\"javascript:;\" data-primary=\"144\" data-task=\"remove\" data-confirm=\"Do you really want remove this entry?\"><i class=\"fa fa-remove\"><\/i><\/a><\/span><\/td>\n<\/tr>\n<tr class=\"xcrud-row xcrud-row-1\">\n<td class=\"xcrud-current xcrud-num\">8<\/td>\n<td>Danish Wholesale Imports<\/td>\n<td>31 12 3555<\/td>\n<td>Kobenhavn<\/td>\n<td>Denmark<\/td>\n<td class=\"xcrud-current xcrud-actions xcrud-fix\"><span class=\"btn-group\"><a class=\"xcrud-action btn btn-info btn-sm\" title=\"View\" href=\"javascript:;\" data-primary=\"145\" data-task=\"view\"><i class=\"fa fa-search\"><\/i><\/a><a class=\"xcrud-action btn btn-warning btn-sm\" title=\"Edit\" href=\"javascript:;\" data-primary=\"145\" data-task=\"edit\"><i class=\"fa fa-edit \"><\/i><\/a><a class=\"xcrud-action btn btn-danger btn-sm\" title=\"Remove\" href=\"javascript:;\" data-primary=\"145\" data-task=\"remove\" data-confirm=\"Do you really want remove this entry?\"><i class=\"fa fa-remove\"><\/i><\/a><\/span><\/td>\n<\/tr>\n<tr class=\"xcrud-row xcrud-row-0\">\n<td class=\"xcrud-current xcrud-num\">9<\/td>\n<td>Saveley &#038; Henriot, Co.<\/td>\n<td>78.32.5555<\/td>\n<td>Lyon<\/td>\n<td>France<\/td>\n<td class=\"xcrud-current xcrud-actions xcrud-fix\"><span class=\"btn-group\"><a class=\"xcrud-action btn btn-info btn-sm\" title=\"View\" href=\"javascript:;\" data-primary=\"146\" data-task=\"view\"><i class=\"fa fa-search\"><\/i><\/a><a class=\"xcrud-action btn btn-warning btn-sm\" title=\"Edit\" href=\"javascript:;\" data-primary=\"146\" data-task=\"edit\"><i class=\"fa fa-edit \"><\/i><\/a><a class=\"xcrud-action btn btn-danger btn-sm\" title=\"Remove\" href=\"javascript:;\" data-primary=\"146\" data-task=\"remove\" data-confirm=\"Do you really want remove this entry?\"><i class=\"fa fa-remove\"><\/i><\/a><\/span><\/td>\n<\/tr>\n<tr class=\"xcrud-row xcrud-row-1\">\n<td class=\"xcrud-current xcrud-num\">10<\/td>\n<td>Dragon Souveniers, Ltd.<\/td>\n<td>+65 221 7555<\/td>\n<td>Singapore<\/td>\n<td>Singapore<\/td>\n<td class=\"xcrud-current xcrud-actions xcrud-fix\"><span class=\"btn-group\"><a class=\"xcrud-action btn btn-info btn-sm\" title=\"View\" href=\"javascript:;\" data-primary=\"148\" data-task=\"view\"><i class=\"fa fa-search\"><\/i><\/a><a class=\"xcrud-action btn btn-warning btn-sm\" title=\"Edit\" href=\"javascript:;\" data-primary=\"148\" data-task=\"edit\"><i class=\"fa fa-edit \"><\/i><\/a><a class=\"xcrud-action btn btn-danger btn-sm\" title=\"Remove\" href=\"javascript:;\" data-primary=\"148\" data-task=\"remove\" data-confirm=\"Do you really want remove this entry?\"><i class=\"fa fa-remove\"><\/i><\/a><\/span><\/td>\n<\/tr>\n<\/tbody>\n<tfoot>\n                            <\/tfoot>\n<\/table><\/div>\n<p>        <!-- Side Edit Mode --><\/p>\n<div class=\"xcrud-nav form-inline\">\n<div class=\"btn-group xcrud-limit-buttons\" data-toggle=\"buttons-radio\"><button type=\"button\" class=\"btn btn-secondary active xcrud-action\" data-limit=\"10\">10<\/button><button type=\"button\" class=\"btn btn-secondary xcrud-action\" data-limit=\"25\">25<\/button><button type=\"button\" class=\"btn btn-secondary xcrud-action\" data-limit=\"50\">50<\/button><button type=\"button\" class=\"btn btn-secondary xcrud-action\" data-limit=\"100\">100<\/button><button type=\"button\" class=\"btn btn-secondary xcrud-action\" data-limit=\"all\">All<\/button><\/div>\n<ul class=\"pagination\">\n<li class=\"page-item active\"><span class=\"page-link xcrud-action\">1<\/span><\/li>\n<li class=\"page-item\"><a href=\"javascript:;\" class=\"xcrud-action page-link\" data-start=\"10\">2<\/a><\/li>\n<li class=\"page-item\"><a href=\"javascript:;\" class=\"xcrud-action page-link\" data-start=\"20\">3<\/a><\/li>\n<li class=\"page-item\"><a href=\"javascript:;\" class=\"xcrud-action page-link\" data-start=\"30\">4<\/a><\/li>\n<li class=\"page-item\"><a href=\"javascript:;\" class=\"xcrud-action page-link\" data-start=\"40\">5<\/a><\/li>\n<li class=\"page-item\"><a href=\"javascript:;\" class=\"xcrud-action page-link\" data-start=\"50\">6<\/a><\/li>\n<li class=\"page-item\"><a href=\"javascript:;\" class=\"xcrud-action page-link\" data-start=\"60\">7<\/a><\/li>\n<li class=\"page-item active\"><span class=\"page-link xcrud-action\">&#133;<\/span><\/li>\n<li class=\"page-item\"><a href=\"javascript:;\" class=\"xcrud-action page-link\" data-start=\"110\">12<\/a><\/li>\n<li class=\"page-item\"><a href=\"javascript:;\" class=\"xcrud-action page-link\" data-start=\"120\">13<\/a><\/li>\n<\/ul>\n<p>            <a class=\"xcrud-search-toggle btn btn-secondary\" href=\"javascript:;\">Search<\/a><span class=\"xcrud-search form-inline\" style=\"display:none;\"><input class=\"xcrud-searchdata xcrud-search-active input-small form-control\" name=\"phrase\" data-type=\"text\" style=\"\" data-fieldtype=\"default\" type=\"text\" value=\"\" \/><select class=\"xcrud-data xcrud-columns-select input-small form-control\" name=\"column\"><option value=\"\">All fields<\/option><option value=\"customers.customerName\" data-type=\"text\">Customername<\/option><option value=\"customers.phone\" data-type=\"text\">Phone<\/option><option value=\"customers.city\" data-type=\"text\">City<\/option><option value=\"customers.country\" data-type=\"text\">Country<\/option><\/select><span class=\"btn-group\"><a class=\"xcrud-action btn btn-primary\" href=\"javascript:;\" data-search=\"1\">Go<\/a><\/span><\/span>\n        <\/div>\n<\/p><\/div>\n<\/p><\/div>\n<div class=\"xcrud-overlay\"><\/div>\n<\/p><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"_links":{"self":[{"href":"https:\/\/xcrud.net\/wordpress\/index.php\/wp-json\/wp\/v2\/pages\/80"}],"collection":[{"href":"https:\/\/xcrud.net\/wordpress\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/xcrud.net\/wordpress\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/xcrud.net\/wordpress\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/xcrud.net\/wordpress\/index.php\/wp-json\/wp\/v2\/comments?post=80"}],"version-history":[{"count":3,"href":"https:\/\/xcrud.net\/wordpress\/index.php\/wp-json\/wp\/v2\/pages\/80\/revisions"}],"predecessor-version":[{"id":139,"href":"https:\/\/xcrud.net\/wordpress\/index.php\/wp-json\/wp\/v2\/pages\/80\/revisions\/139"}],"wp:attachment":[{"href":"https:\/\/xcrud.net\/wordpress\/index.php\/wp-json\/wp\/v2\/media?parent=80"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}