{"id":202,"date":"2015-05-29T15:39:46","date_gmt":"2015-05-29T15:39:46","guid":{"rendered":"https:\/\/wpdatatables.com\/?page_id=202"},"modified":"2024-11-26T14:21:59","modified_gmt":"2024-11-26T14:21:59","slug":"creating-mysql-based-wpdatatables-with-server-side-processing","status":"publish","type":"page","link":"https:\/\/wpdatatables.com\/documentation\/creating-wpdatatables\/creating-mysql-based-wpdatatables-with-server-side-processing\/","title":{"rendered":"Creating MySQL-based tables with server-side processing"},"content":{"rendered":"<section class=\"wpb-content-wrapper\"><p>[vc_row][vc_column][vc_column_text]<\/p>\n<h1>Creating MySQL-based tables with server-side processing<\/h1>\n<p>[\/vc_column_text]<div class=\"card\" id=\"video\"><div class=\"card-header ch-alt\"><div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"#\" data-href=\"https:\/\/wpdatatables.com\/documentation\/creating-wpdatatables\/creating-mysql-based-wpdatatables-with-server-side-processing\/#Video_tutorial\" >Video tutorial<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"#\" data-href=\"https:\/\/wpdatatables.com\/documentation\/creating-wpdatatables\/creating-mysql-based-wpdatatables-with-server-side-processing\/#wpDataTable_MySQL_server-side_processing\" >wpDataTable MySQL server-side processing<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"#\" data-href=\"https:\/\/wpdatatables.com\/documentation\/creating-wpdatatables\/creating-mysql-based-wpdatatables-with-server-side-processing\/#Instructions_to_create_the_table\" >Instructions to create the table<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"#\" data-href=\"https:\/\/wpdatatables.com\/documentation\/creating-wpdatatables\/creating-mysql-based-wpdatatables-with-server-side-processing\/#Create_a_wpDataTable_with_server-side_processing_feature_enabled\" >Create a wpDataTable with server-side processing feature enabled<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"#\" data-href=\"https:\/\/wpdatatables.com\/documentation\/creating-wpdatatables\/creating-mysql-based-wpdatatables-with-server-side-processing\/#Define_additional_table_and_columns_settings_Optional\" >Define additional table and columns settings (Optional)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"#\" data-href=\"https:\/\/wpdatatables.com\/documentation\/creating-wpdatatables\/creating-mysql-based-wpdatatables-with-server-side-processing\/#Insert_the_wpDataTable_in_WordPress_post_or_Page\" >Insert the wpDataTable in WordPress post or Page<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"#\" data-href=\"https:\/\/wpdatatables.com\/documentation\/creating-wpdatatables\/creating-mysql-based-wpdatatables-with-server-side-processing\/#Read_more\" >Read more<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Video_tutorial\"><\/span><span>Video tutorial<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2><\/div> <!-- \/.card-header --><div class=\"card-body card-padding\">[vc_video link=&#8221;https:\/\/www.youtube.com\/watch?v=8q1U-VN72eg&#8221; el_width=&#8221;60&#8243; align=&#8221;center&#8221;]<\/div><\/div> <!-- \/.card --><div class=\"card\" id=\"server-side\"><div class=\"card-header ch-alt\"><h2><span class=\"ez-toc-section\" id=\"wpDataTable_MySQL_server-side_processing\"><\/span><span>wpDataTable MySQL server-side processing<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2><\/div> <!-- \/.card-header --><div class=\"card-body card-padding\">[vc_message message_box_style=&#8221;solid&#8221;]This tutorial, and this wpDataTable creation method, assume you have at least some knowledge about SQL, and you are able to prepare the data on the MySQL side and are able to fetch it with a query.[\/vc_message][vc_column_text]When your data set is larger than a couple of thousand rows, it can&#8217;t effectively be loaded onto the page from a Google Spreadsheet, a CSV or Excel file, or other sources. Each of these methods first reads the data from the source, and then prints out the complete table data on your page; so, as the row count grows, it makes both the page generation time on the server side and the page load and initialization time on the client side, slower and slower. If your host has a certain memory or timeout limit defined for PHP scripts, it can &#8216;break&#8217; the page, because the script would try to allocate more memory than it&#8217;s allowed. <strong>But no worries! wpDataTables has a solution for that &#8211; datatables server-side processing!<\/strong><\/p>\n<p>Server-side processing is available only for tables saved in the database (SQL tables); consequently, <strong>all filtering, sorting, pagination, and other data processing routines will be delegated to the MySQL engine<\/strong>, and only a smaller number of rows will be fetched from the server by a background AJAX request at a time. If you wanted to find out how to improve SQL performance, this is it.<\/p>\n<p>Please refer to <a href=\"\/documentation\/table-features\/server-side-processing\/\">this documentation section<\/a> for a full explanation of the Server-side processing feature.<\/p>\n<p>This tutorial will use a data set of 2.560.000 rows; you can download the SQL dump sample (only 10.000 rows, because the whole dump is very large) using <a href=\"\/sample_files\/sample_large_table.sql\">this link<\/a>. A table without server-side processing with 2.560.000 rows would typically require 5-15 minutes for loading (if it loaded at all). Let&#8217;s see how it performs with server-side processing enabled. Just try to filter or sort the table.<\/p>\n<p>The step-by-step tutorial on how to create one of these huge tables with no hassle.[\/vc_column_text]\n<div class=\"wpdt-c wdt-skin-aqua\">\n    \n    <input type=\"hidden\" id=\"wdtNonceFrontendServerSide_7\" name=\"wdtNonceFrontendServerSide_7\" value=\"07bee614ac\" \/><input type=\"hidden\" name=\"_wp_http_referer\" value=\"\/wp-json\/wp\/v2\/pages\/202\" \/>    <input type=\"hidden\" id=\"table_1_desc\"\n           value='{\"tableId\":\"table_1\",\"tableType\":\"mysql\",\"selector\":\"#table_1\",\"responsive\":true,\"responsiveAction\":\"icon\",\"editable\":false,\"inlineEditing\":false,\"infoBlock\":true,\"pagination_top\":0,\"pagination\":true,\"paginationAlign\":\"right\",\"paginationLayout\":\"full_numbers\",\"paginationLayoutMobile\":\"simple\",\"file_location\":\"\",\"tableSkin\":\"aqua\",\"table_wcag\":0,\"simple_template_id\":0,\"scrollable\":false,\"fixedLayout\":true,\"globalSearch\":true,\"showRowsPerPage\":true,\"popoverTools\":false,\"loader\":\"1\",\"showCartInformation\":1,\"hideBeforeLoad\":true,\"number_format\":2,\"decimalPlaces\":2,\"spinnerSrc\":\"https:\\\/\\\/wpdatatables.com\\\/wp-content\\\/plugins\\\/wpdatatables\\\/assets\\\/\\\/img\\\/spinner.gif\",\"index_column\":0,\"groupingEnabled\":false,\"tableWpId\":7,\"dataTableParams\":{\"sDom\":\"BT\\u003C\\u0027clear\\u0027\\u003Elftip\",\"bSortCellsTop\":false,\"bFilter\":true,\"bPaginate\":true,\"sPaginationType\":\"full_numbers\",\"aLengthMenu\":[[1,5,10,25,50,100,-1],[1,5,10,25,50,100,\"All\"]],\"iDisplayLength\":10,\"columnDefs\":[{\"masterDetailColumnOption\":1,\"sType\":\"formatted-num\",\"wdtType\":\"int\",\"bVisible\":false,\"orderable\":true,\"searchable\":true,\"InputType\":\"none\",\"name\":\"id\",\"origHeader\":\"id\",\"notNull\":false,\"conditionalFormattingRules\":[],\"transformValueRules\":\"\",\"className\":\"numdata integer  column-id\",\"aTargets\":[0]},{\"masterDetailColumnOption\":1,\"sType\":\"string\",\"wdtType\":\"string\",\"bVisible\":true,\"orderable\":true,\"searchable\":true,\"InputType\":\"none\",\"name\":\"name\",\"origHeader\":\"name\",\"notNull\":false,\"conditionalFormattingRules\":[],\"transformValueRules\":\"\",\"className\":\" column-name\",\"aTargets\":[1]},{\"masterDetailColumnOption\":1,\"sType\":\"string\",\"wdtType\":\"string\",\"bVisible\":true,\"orderable\":true,\"searchable\":true,\"InputType\":\"none\",\"name\":\"company\",\"origHeader\":\"company\",\"notNull\":false,\"conditionalFormattingRules\":[],\"transformValueRules\":\"\",\"className\":\" column-company\",\"aTargets\":[2]},{\"masterDetailColumnOption\":1,\"sType\":\"date-custom\",\"wdtType\":\"date\",\"bVisible\":true,\"orderable\":true,\"searchable\":true,\"InputType\":\"none\",\"name\":\"order_date\",\"origHeader\":\"order_date\",\"notNull\":false,\"conditionalFormattingRules\":[],\"transformValueRules\":\"\",\"className\":\" column-order_date\",\"aTargets\":[3]},{\"masterDetailColumnOption\":1,\"sType\":\"string\",\"wdtType\":\"string\",\"bVisible\":true,\"orderable\":true,\"searchable\":true,\"InputType\":\"none\",\"name\":\"product\",\"origHeader\":\"product\",\"notNull\":false,\"conditionalFormattingRules\":[],\"transformValueRules\":\"\",\"className\":\" column-product\",\"aTargets\":[4]},{\"masterDetailColumnOption\":1,\"sType\":\"formatted-num\",\"wdtType\":\"int\",\"bVisible\":true,\"orderable\":true,\"searchable\":true,\"InputType\":\"none\",\"name\":\"amount\",\"origHeader\":\"amount\",\"notNull\":false,\"conditionalFormattingRules\":[],\"transformValueRules\":\"\",\"className\":\"numdata integer  column-amount\",\"sWidth\":\"10%\",\"aTargets\":[5]},{\"masterDetailColumnOption\":1,\"sType\":\"formatted-num\",\"wdtType\":\"float\",\"bVisible\":true,\"orderable\":true,\"searchable\":true,\"InputType\":\"none\",\"name\":\"total\",\"origHeader\":\"total\",\"notNull\":false,\"conditionalFormattingRules\":[],\"transformValueRules\":\"\",\"className\":\"numdata float  column-total\",\"sWidth\":\"10%\",\"aTargets\":[6]}],\"bAutoWidth\":false,\"order\":[[0,\"asc\"]],\"ordering\":true,\"fixedHeader\":{\"header\":false,\"headerOffset\":0},\"fixedColumns\":false,\"buttons\":[{\"extend\":\"colvis\",\"className\":\"DTTT_button DTTT_button_colvis\",\"text\":\"Columns\",\"collectionLayout\":\"wdt-skin-aqua\"},{\"extend\":\"print\",\"exportOptions\":{\"columns\":\":visible\",\"stripHtml\":true},\"className\":\"DTTT_button DTTT_button_print\",\"text\":\"Print\",\"title\":\"MySQL table with server-side processing example\"},{\"extend\":\"collection\",\"className\":\"DTTT_button DTTT_button_export\",\"text\":\"Export\",\"buttons\":[{\"extend\":\"excelHtml5\",\"exportOptions\":{\"columns\":\":visible\",\"stripHtml\":true},\"filename\":\"MySQL table with server-side processing example\",\"title\":null,\"text\":\"Excel\"},{\"extend\":\"csvHtml5\",\"exportOptions\":{\"columns\":\":visible\",\"stripHtml\":true},\"title\":\"MySQL table with server-side processing example\",\"text\":\"CSV\"},{\"extend\":\"copyHtml5\",\"exportOptions\":{\"columns\":\":visible\",\"stripHtml\":true},\"filename\":\"MySQL table with server-side processing example\",\"title\":null,\"text\":\"Copy\"},{\"extend\":\"pdfHtml5\",\"exportOptions\":{\"columns\":\":visible\"},\"orientation\":\"portrait\",\"pageSize\":\"A4\",\"title\":\"MySQL table with server-side processing example\",\"text\":\"PDF\"}]},{\"buttons\":[\"pageLength\"],\"className\":\"DTTT_button DTTT_button_spacer\",\"text\":\"Spacer\"}],\"oLanguage\":{\"sSearchPlaceholder\":\"Search table\",\"sSearch\":\"\\u003Cspan class=\\u0022wdt-search-icon\\u0022\\u003E\\u003C\\\/span\\u003E\"},\"bProcessing\":false,\"serverSide\":true,\"ajax\":{\"url\":\"https:\\\/\\\/wpdatatables.com\\\/wp-admin\\\/admin-ajax.php?action=get_wdtable&table_id=7\",\"type\":\"POST\"},\"oSearch\":{\"bSmart\":false,\"bRegex\":false,\"sSearch\":\"\"}},\"customRowDisplay\":\"\",\"tabletWidth\":\"1024\",\"mobileWidth\":\"480\",\"renderFilter\":\"footer\",\"advancedFilterEnabled\":true,\"advancedFilterOptions\":{\"aoColumns\":[{\"type\":\"text\",\"columnType\":\"int\",\"numberOfDecimalPlaces\":\"2\",\"possibleValuesType\":\"read\",\"globalSearchColumn\":1,\"values\":null,\"origHeader\":\"id\",\"displayHeader\":\"id\",\"possibleValuesAddEmpty\":false,\"possibleValuesAjax\":-1,\"column_align_fields\":\"\",\"defaultValue\":\"\",\"column_align_header\":\"\",\"column_rotate_header_name\":\"\",\"exactFiltering\":false,\"filterLabel\":\"\",\"searchInSelectBox\":1,\"searchInSelectBoxEditing\":1,\"checkboxesInModal\":0,\"andLogic\":0,\"linkButtonLabel\":\"\",\"rangeSlider\":false,\"rangeMaxValueDisplay\":\"0\",\"customMaxRangeValue\":\"0\"},{\"type\":\"text\",\"columnType\":\"string\",\"numberOfDecimalPlaces\":\"2\",\"possibleValuesType\":\"read\",\"globalSearchColumn\":1,\"values\":null,\"origHeader\":\"name\",\"displayHeader\":\"Name\",\"possibleValuesAddEmpty\":false,\"possibleValuesAjax\":10,\"column_align_fields\":\"\",\"defaultValue\":\"\",\"column_align_header\":\"\",\"column_rotate_header_name\":\"\",\"exactFiltering\":false,\"filterLabel\":\"\",\"searchInSelectBox\":1,\"searchInSelectBoxEditing\":1,\"checkboxesInModal\":0,\"andLogic\":0,\"linkButtonLabel\":\"\",\"rangeSlider\":false,\"rangeMaxValueDisplay\":\"0\",\"customMaxRangeValue\":\"0\"},{\"type\":\"select\",\"columnType\":\"string\",\"numberOfDecimalPlaces\":\"2\",\"possibleValuesType\":\"read\",\"globalSearchColumn\":1,\"values\":[{\"value\":\"Microsoft\",\"label\":\"Microsoft\"},{\"value\":\"Macromedia\",\"label\":\"Macromedia\"},{\"value\":\"Google\",\"label\":\"Google\"},{\"value\":\"Yahoo\",\"label\":\"Yahoo\"},{\"value\":\"Lycos\",\"label\":\"Lycos\"},{\"value\":\"Altavista\",\"label\":\"Altavista\"},{\"value\":\"Chami\",\"label\":\"Chami\"},{\"value\":\"Adobe\",\"label\":\"Adobe\"},{\"value\":\"Borland\",\"label\":\"Borland\"},{\"value\":\"Lavasoft\",\"label\":\"Lavasoft\"}],\"origHeader\":\"company\",\"displayHeader\":\"Company\",\"possibleValuesAddEmpty\":false,\"possibleValuesAjax\":10,\"column_align_fields\":\"\",\"defaultValue\":\"\",\"column_align_header\":\"\",\"column_rotate_header_name\":\"\",\"exactFiltering\":false,\"filterLabel\":\"\",\"searchInSelectBox\":1,\"searchInSelectBoxEditing\":1,\"checkboxesInModal\":0,\"andLogic\":0,\"linkButtonLabel\":\"\",\"rangeSlider\":false,\"rangeMaxValueDisplay\":\"0\",\"customMaxRangeValue\":\"0\"},{\"type\":\"date-range\",\"columnType\":\"date\",\"numberOfDecimalPlaces\":\"2\",\"possibleValuesType\":\"read\",\"globalSearchColumn\":1,\"values\":null,\"origHeader\":\"order_date\",\"displayHeader\":\"Order Date\",\"possibleValuesAddEmpty\":false,\"possibleValuesAjax\":-1,\"column_align_fields\":\"\",\"defaultValue\":\"\",\"column_align_header\":\"\",\"column_rotate_header_name\":\"\",\"exactFiltering\":false,\"filterLabel\":\"\",\"searchInSelectBox\":1,\"searchInSelectBoxEditing\":1,\"checkboxesInModal\":0,\"andLogic\":0,\"linkButtonLabel\":\"\",\"rangeSlider\":false,\"rangeMaxValueDisplay\":\"0\",\"customMaxRangeValue\":\"0\"},{\"type\":\"select\",\"columnType\":\"string\",\"numberOfDecimalPlaces\":\"2\",\"possibleValuesType\":\"read\",\"globalSearchColumn\":1,\"values\":[{\"value\":\"Product One\",\"label\":\"Product One\"},{\"value\":\"Product Two\",\"label\":\"Product Two\"},{\"value\":\"Product Three\",\"label\":\"Product Three\"},{\"value\":\"Product Four\",\"label\":\"Product Four\"},{\"value\":\"Product Five\",\"label\":\"Product Five\"},{\"value\":\"Product Six\",\"label\":\"Product Six\"},{\"value\":\"Product Seven\",\"label\":\"Product Seven\"},{\"value\":\"Product Eight\",\"label\":\"Product Eight\"},{\"value\":\"Product Nine\",\"label\":\"Product Nine\"},{\"value\":\"Product Ten\",\"label\":\"Product Ten\"}],\"origHeader\":\"product\",\"displayHeader\":\"Product\",\"possibleValuesAddEmpty\":false,\"possibleValuesAjax\":10,\"column_align_fields\":\"\",\"defaultValue\":\"\",\"column_align_header\":\"\",\"column_rotate_header_name\":\"\",\"exactFiltering\":false,\"filterLabel\":\"\",\"searchInSelectBox\":1,\"searchInSelectBoxEditing\":1,\"checkboxesInModal\":0,\"andLogic\":0,\"linkButtonLabel\":\"\",\"rangeSlider\":false,\"rangeMaxValueDisplay\":\"0\",\"customMaxRangeValue\":\"0\"},{\"type\":\"number-range\",\"columnType\":\"int\",\"numberOfDecimalPlaces\":\"2\",\"possibleValuesType\":\"read\",\"globalSearchColumn\":1,\"values\":null,\"origHeader\":\"amount\",\"displayHeader\":\"Amount\",\"possibleValuesAddEmpty\":false,\"possibleValuesAjax\":-1,\"column_align_fields\":\"\",\"defaultValue\":\"\",\"column_align_header\":\"\",\"column_rotate_header_name\":\"\",\"exactFiltering\":false,\"filterLabel\":\"\",\"searchInSelectBox\":1,\"searchInSelectBoxEditing\":1,\"checkboxesInModal\":0,\"andLogic\":0,\"linkButtonLabel\":\"\",\"rangeSlider\":false,\"rangeMaxValueDisplay\":\"0\",\"customMaxRangeValue\":\"0\"},{\"type\":\"number-range\",\"columnType\":\"float\",\"numberOfDecimalPlaces\":\"2\",\"possibleValuesType\":\"read\",\"globalSearchColumn\":1,\"values\":null,\"origHeader\":\"total\",\"displayHeader\":\"Total\",\"possibleValuesAddEmpty\":false,\"possibleValuesAjax\":-1,\"column_align_fields\":\"\",\"defaultValue\":\"\",\"column_align_header\":\"\",\"column_rotate_header_name\":\"\",\"exactFiltering\":false,\"filterLabel\":\"\",\"searchInSelectBox\":1,\"searchInSelectBoxEditing\":1,\"checkboxesInModal\":0,\"andLogic\":0,\"linkButtonLabel\":\"\",\"rangeSlider\":false,\"rangeMaxValueDisplay\":\"0\",\"customMaxRangeValue\":\"0\"}],\"bUseColVis\":true},\"filterInForm\":false,\"serverSide\":true,\"autoRefreshInterval\":0,\"processing\":true,\"fnServerData\":true,\"columnsFixed\":0,\"sumFunctionsLabel\":\"\",\"avgFunctionsLabel\":\"\",\"minFunctionsLabel\":\"\",\"maxFunctionsLabel\":\"Max =\",\"columnsDecimalPlaces\":{\"id\":-1,\"name\":-1,\"company\":-1,\"order_date\":-1,\"product\":-1,\"amount\":-1,\"total\":-1},\"columnsThousandsSeparator\":{\"id\":1,\"amount\":1},\"sumColumns\":[],\"avgColumns\":[],\"sumAvgColumns\":[],\"timeFormat\":\"h:i A\",\"datepickFormat\":\"dd\\\/mm\\\/yy\",\"cascadeFiltering\":0,\"cascadeFilteringLogic\":\"\",\"hideTableBeforeFiltering\":0,\"showSearchFiltersButton\":0,\"disableSearchFiltersButton\":0}'\/>\n\n    <table id=\"table_1\"\n           class=\"  responsive display nowrap wdt-no-display data-t data-t wpDataTable wpDataTableID-7 \"\n           style=\"display: none; \"\n           data-described-by='table_1_desc'\n           data-wpdatatable_id=\"7\">\n        \n        <!-- Table header -->\n        \n<thead>\n<tr>\n                    <th\n                data-hide=\"phone\"        class=\"phone wdtheader sort numdata integer \"\n        style=\"\">        id<\/th>        <th\n        data-class=\"expand\"                class=\" wdtheader sort \"\n        style=\"\">        Name<\/th>        <th\n                data-hide=\"phone\"        class=\"phone wdtheader sort \"\n        style=\"\">        Company<\/th>        <th\n                data-hide=\"phone\"        class=\"phone wdtheader sort \"\n        style=\"\">        Order Date<\/th>        <th\n                data-hide=\"phone\"        class=\"phone wdtheader sort \"\n        style=\"\">        Product<\/th>        <th\n                data-hide=\"phone\"        class=\"phone wdtheader sort numdata integer \"\n        style=\"\">        Amount<\/th>        <th\n                data-hide=\"phone\"        class=\"phone wdtheader sort numdata float \"\n        style=\"\">        Total<\/th>    <\/tr>\n<\/thead>\n        <!-- \/Table header -->\n\n        <!-- Table body -->\n        \n<tbody>\n<!-- Table body -->\n<div data-id=\"7\"\n     class=\"wdt-timeline-item wdt-timeline-table_1\"\n     style=\"\">\n    <div class=\"wdt-table-loader\">\n        <div class=\"wdt-table-loader-row wdt-table-loader-header\">\n            <div class=\"wdt-table-loader-header-cell wdt-animated-background\"><\/div>\n            <div class=\"wdt-table-loader-header-cell wdt-animated-background\"><\/div>\n            <div class=\"wdt-table-loader-header-cell wdt-animated-background\"><\/div>\n        <\/div>\n                    <div class=\"wdt-table-loader-row\">\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n            <\/div>\n                    <div class=\"wdt-table-loader-row\">\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n            <\/div>\n                    <div class=\"wdt-table-loader-row\">\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n            <\/div>\n                    <div class=\"wdt-table-loader-row\">\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n            <\/div>\n                    <div class=\"wdt-table-loader-row\">\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n            <\/div>\n                    <div class=\"wdt-table-loader-row\">\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n            <\/div>\n                    <div class=\"wdt-table-loader-row\">\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n            <\/div>\n                    <div class=\"wdt-table-loader-row\">\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n            <\/div>\n                    <div class=\"wdt-table-loader-row\">\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n            <\/div>\n                    <div class=\"wdt-table-loader-row\">\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n            <\/div>\n                    <div class=\"wdt-table-loader-row\">\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n            <\/div>\n            <\/div>\n<\/div><!-- \/Table body -->\n                    <tr id=\"table_7_row_0\"\n            data-row-index=\"0\">\n                            <td style=\"\">1<\/td>\n                            <td style=\"\">Yoshio W. Roach<\/td>\n                            <td style=\"\">Cakewalk<\/td>\n                            <td style=\"\">30\/10\/2018<\/td>\n                            <td style=\"\">Product Five<\/td>\n                            <td style=\"\">10<\/td>\n                            <td style=\"\">136.00<\/td>\n                    <\/tr>\n                            <tr id=\"table_7_row_1\"\n            data-row-index=\"1\">\n                            <td style=\"\">2<\/td>\n                            <td style=\"\">Sawyer M. Good<\/td>\n                            <td style=\"\">Cakewalk<\/td>\n                            <td style=\"\">26\/11\/2016<\/td>\n                            <td style=\"\">Product Seven<\/td>\n                            <td style=\"\">1<\/td>\n                            <td style=\"\">1,806.00<\/td>\n                    <\/tr>\n                            <tr id=\"table_7_row_2\"\n            data-row-index=\"2\">\n                            <td style=\"\">3<\/td>\n                            <td style=\"\">Flynn M. Bryant<\/td>\n                            <td style=\"\">Sibelius<\/td>\n                            <td style=\"\">23\/09\/2017<\/td>\n                            <td style=\"\">Product Four<\/td>\n                            <td style=\"\">4<\/td>\n                            <td style=\"\">154.00<\/td>\n                    <\/tr>\n                            <tr id=\"table_7_row_3\"\n            data-row-index=\"3\">\n                            <td style=\"\">4<\/td>\n                            <td style=\"\">Stephanie Q. Robles<\/td>\n                            <td style=\"\">Adobe<\/td>\n                            <td style=\"\">25\/03\/2018<\/td>\n                            <td style=\"\">Product Three<\/td>\n                            <td style=\"\">1<\/td>\n                            <td style=\"\">1,576.00<\/td>\n                    <\/tr>\n                            <tr id=\"table_7_row_4\"\n            data-row-index=\"4\">\n                            <td style=\"\">5<\/td>\n                            <td style=\"\">Lacey T. Rocha<\/td>\n                            <td style=\"\">Borland<\/td>\n                            <td style=\"\">10\/03\/2017<\/td>\n                            <td style=\"\">Product Five<\/td>\n                            <td style=\"\">7<\/td>\n                            <td style=\"\">1,990.00<\/td>\n                    <\/tr>\n                            <tr id=\"table_7_row_5\"\n            data-row-index=\"5\">\n                            <td style=\"\">6<\/td>\n                            <td style=\"\">Garrison J. Foreman<\/td>\n                            <td style=\"\">Adobe<\/td>\n                            <td style=\"\">04\/04\/2018<\/td>\n                            <td style=\"\">Product Three<\/td>\n                            <td style=\"\">3<\/td>\n                            <td style=\"\">810.00<\/td>\n                    <\/tr>\n                            <tr id=\"table_7_row_6\"\n            data-row-index=\"6\">\n                            <td style=\"\">7<\/td>\n                            <td style=\"\">Maisie M. Park<\/td>\n                            <td style=\"\">Macromedia<\/td>\n                            <td style=\"\">21\/02\/2018<\/td>\n                            <td style=\"\">Product Five<\/td>\n                            <td style=\"\">10<\/td>\n                            <td style=\"\">1,202.00<\/td>\n                    <\/tr>\n                            <tr id=\"table_7_row_7\"\n            data-row-index=\"7\">\n                            <td style=\"\">8<\/td>\n                            <td style=\"\">Salvador Y. Jennings<\/td>\n                            <td style=\"\">Lycos<\/td>\n                            <td style=\"\">01\/05\/2018<\/td>\n                            <td style=\"\">Product Two<\/td>\n                            <td style=\"\">1<\/td>\n                            <td style=\"\">834.00<\/td>\n                    <\/tr>\n                            <tr id=\"table_7_row_8\"\n            data-row-index=\"8\">\n                            <td style=\"\">9<\/td>\n                            <td style=\"\">Valentine D. Knight<\/td>\n                            <td style=\"\">Cakewalk<\/td>\n                            <td style=\"\">18\/12\/2016<\/td>\n                            <td style=\"\">Product Six<\/td>\n                            <td style=\"\">3<\/td>\n                            <td style=\"\">1,028.00<\/td>\n                    <\/tr>\n                            <tr id=\"table_7_row_9\"\n            data-row-index=\"9\">\n                            <td style=\"\">10<\/td>\n                            <td style=\"\">Abdul L. Brewer<\/td>\n                            <td style=\"\">Borland<\/td>\n                            <td style=\"\">17\/01\/2018<\/td>\n                            <td style=\"\">Product Six<\/td>\n                            <td style=\"\">3<\/td>\n                            <td style=\"\">1,100.00<\/td>\n                    <\/tr>\n            <\/tbody>        <!-- \/Table body -->\n\n        <!-- Table footer -->\n        \n    <tfoot>\n                <tr >\n                            <td\n                class=\"wdtheader sort numdata integer \"\n                style=\"\">id<\/td>                <td\n                class=\"wdtheader sort \"\n                style=\"\">Name<\/td>                <td\n                class=\"wdtheader sort \"\n                style=\"\">Company<\/td>                <td\n                class=\"wdtheader sort \"\n                style=\"\">Order Date<\/td>                <td\n                class=\"wdtheader sort \"\n                style=\"\">Product<\/td>                <td\n                class=\"wdtheader sort numdata integer \"\n                style=\"\">Amount<\/td>                <td\n                class=\"wdtheader sort numdata float \"\n                style=\"\">Total<\/td>        <\/tr>\n                            <\/tfoot>\n        <!-- \/Table footer -->\n    <\/table>\n\n<\/div><style>\n\n#table_1 > tbody > tr > td.column-total:not(:empty):before,\n                                       \n#table_1 > tbody > tr.row-detail ul li.column-total span.columnValue:before\n                                            { content: '$' }\n#wdt-md-modal div.column-total:not(:empty):before{ content: '$' }table.wpDataTable { table-layout: fixed !important; }\ntable.wpDataTable td, table.wpDataTable th { white-space: normal !important; }\n.wpdt-c .wpDataTablesWrapper table.wpDataTable tr.odd td.grey,\n.wpdt-c .wpDataTablesWrapper table.wpDataTable td.grey{background-color: #dcdcdc !important;border-left: 1px solid #dcdcdc !important;}\n.wpdt-c .wpDataTablesWrapper table.wpDataTable tr.odd td.blue,\n.wpdt-c .wpDataTablesWrapper table.wpDataTable td.blue{background-color: #0083c2 !important;border-left: 1px solid #0083c2 !important;}\n.wpdt-c .wpDataTablesWrapper table.wpDataTable tr.odd td.red,\n.wpdt-c .wpDataTablesWrapper table.wpDataTable td.red{background-color: #d6181f !important;border-left: 1px solid #d6181f !important;}\n.wpdt-c .wpDataTablesWrapper table.wpDataTable tr.odd td.lightblue,\n.wpdt-c .wpDataTablesWrapper table.wpDataTable td.lightblue{background-color: rgb(91,192,222) !important;border-left: 1px solid rgb(91,192,222) !important;}\ntable.wpDataTable td.apple_column { font-size: 30px; font-weight: bold; font-family: Arial; padding: 5px; }li.circle {width: 3rem;\n    height: 3rem;\n    line-height: 3rem;\n    text-align: center;\n    background: #76766f;\n    color: #fff;\n    margin-right: .5rem;\n    border-radius: 100%;\n    display: inline-block;\n    vertical-align: middle;\n    font-size: 1.4rem;} li.win{background: #13cf00;}\n.badge-1 {\n    background-image: url(https:\/\/wpdatatables.com\/wp-content\/uploads\/2018\/12\/badges-25-sprite.png);\n    background-repeat: no-repeat;\n    width: 25px;\n    height: 25px;\n    display: block;\n    background-position: -50px -350px;\n    display: inline-block;\n    vertical-align: middle;\n    margin-right: .5rem;\n}\n\n.badge-1.t1 {\n    background-position: -250px -225px;\n}\n.badge-1.t2 {\n    background-position: -250px -250px;\n}\n.badge-1.t3 {\n    background-position: -275px -325px;\n}\n.badge-1.t4 {\n    background-position: -150px -150px;\n}\n.badge-1.t5{\n        background-position: 0 -50px;\n}\n.badge-1.t6{\n    background-position: -275px -200px;\n}\n.badge-1.t7 {\n      background-position: -350px -75px;\n}\n.badge-1.t8 {\n    background-position: -50px -125px;\n}\n.badge-1.t9 {\n    background-position: -250px -125px;\n}\n.badge-1.t10 {\n    background-position: -350px -250px;\n}\n.badge-1.t11 {\n    background-position: 0 -200px;\n}\n.badge-1.t12 {\n        background-position: -350px -125px;\n}\n.badge-1.t13 {\n    background-position: -100px -100px;\n}\n.badge-1.t14{\n        background-position: -50px -175px;\n}\n.badge-1.t15 {\n    background-position: -250px -225px;\n}\n.badge-1.t16 {\n    background-position: -325px -250px;\n}\n.badge-1.t17 {\n    background-position: -75px -150px;\n}\n.badge-1.t18 {\n    background-position: -25px -150px;\n}\n.badge-1.t19 {\n        background-position: -75px -225px;\n}\n.badge-1.t20 {\n    background-position: -225px -100px;\n    }\n.wpDataTablesWrapper table.wpDataTable td.aligncentarcell, \n.wpDataTablesWrapper table.wpDataTable th.aligncentarcell,\n.wpDataTablesWrapper table.wpDataTable td.numdata, \n.wpDataTablesWrapper table.wpDataTable th.numdata\n{ text-align: center !important; }\n.score-last-6 {\n    margin:0 auto;\n    border-collapse: separate;\n    display: table;\n    border-spacing: 3px 0;\nheight:11px;\nvertical-align: middle;\n}\n.score-last-one{\n    display: table-cell;\n    height: .7em;\n    width: .7em;\n}\n.win {background: #0083c2;}\n.lose{background: #d6181f;}\n.equal {background: #dcdcdc;}\n\n@media screen and (max-width: 380px) {\n .wpdt-c .wpDataTablesWrapper table.wpDataTable th.column-team{width:100px !important;}\n}\n.cripto-div {\n    vertical-align: middle;}\n.cripto-div span {font-size: 16px;font-weight: 600;margin-left: 5px;vertical-align: top !important;margin-top: 6px;}\n.cripto-sprite {display: inline-block;margin: 0 2px;background-image: url(https:\/\/wpdatatables.com\/wp-content\/uploads\/2018\/12\/cripto-sprite.png);width: 16px;height: 16px;}\n.cripto-1{background-position: -734px -207px;}\n.cripto-2{background-position: -176px -64px;}\n.cripto-3{background-position: -734px -48px;}\n.cripto-4{background-position: -416px -639px;}\n.cripto-5{background-position: -176px -96px;}\n.cripto-7{background-position: -16px -96px;}\n.cripto-8{background-position: -638px -557px;}\n.cripto-9{background-position: -238px -160px;}\n.cripto-10{background-position: -464px -623px;}\n.cripto-11{background-position: -638px -399px;}\n.cripto-12{background-position: -192px -655px;}\n.cripto-13{background-position: -16px -336px;}\n.cripto-14{background-position: -304px -639px;}\n.cripto-15{background-position: -400px -687px;}\n.cripto-16{background-position: -32px -80px;}\n.cripto-17{background-position: -480px -463px;}\n.cripto-18{background-position: -128px -687px;}\n.cripto-19{background-position: -718px -64px;}\n.cripto-20{background-position: -702px -395px;}\n.green-text{color: #009e73 !important;}\n.red-text{color: #d94040 !important;}\n.blue-text{color: #0083c2  !important;}\n.black-text{color: #000000 !important;}\n.white-text { color: #fff !important; }\n\n.dark-blue{color: #152E53 !important;}\n@media screen and (max-width: 768px) {\n  #home .wpdt-c .wpDataTablesWrapper table.has-columns-hidden tr.row-detail > td ul li span.columnValue {\n     left: 123px;\n font-size: 14px;\n  }\n.stars-container{\nfont-size:20px !important;\n}\n #home  .wpdt-c .wpDataTablesWrapper table.has-columns-hidden tr.row-detail > td ul li span.columnTitle {\n    max-width: 200px !important;font-size: 14px;\n  } \n.arrow-down:before,\n.arrow-up:before {\nleft:unset !important;\nright:0;\n}\n.wpdt-c .wpDataTablesWrapper table.wpDataTable th.column-column1{ \n    width:50% !important;\n  }\n}\n\n@media screen and (max-width: 480px) {\n #home .wpdt-c .wpDataTablesWrapper table.wpDataTable {\n    font-size: 14px !important;\n  }\n}\n@media screen and (max-width: 380px) {\n .wpdt-c .wpDataTablesWrapper table.wpDataTable th.column-team,\n .wpdt-c .wpDataTablesWrapper table.wpDataTable th.column-column1{\n   width:100px !important;\n  }\n#home .wpdt-c .wpDataTablesWrapper .dataTables_paginate .paginate_button {\nmargin:0 !important;\n }\n}\n.modal-backdrop{ z-index: 0 !important; }\n\n.cripto-sprite{\n background-image: url(https:\/\/wpdatatables.com\/wp-content\/uploads\/2019\/02\/Artboard.png);\n    background-repeat: no-repeat;\n    background-size:160px;\n    width: 32px;\n    height: 32px;\nmargin-left:0 !important;\n}\n.cripto-1 {\nbackground-position: 0 0;\n}\n.cripto-2 {\nbackground-position: -32px 0;\n}\n.cripto-3 {\nbackground-position: -64px 0;\n}\n.cripto-4 {\nbackground-position: -96px 0;\n}\n.cripto-5 {\nbackground-position: -128px 0;\n}\n.cripto-6 {\nbackground-position: 0 -32px ;\n}\n.cripto-7 {\nbackground-position: -32px -32px;\n}\n.cripto-8 {\nbackground-position:  -64px -32px;\n}\n.cripto-9 {\nbackground-position: -96px -32px;\n}\n.cripto-10 {\nbackground-position:-128px -32px;\n}\n.cripto-11 {\nbackground-position: 0 -64px;\n}\n.cripto-12 {\nbackground-position: -32px -64px;\n}\n.cripto-13 {\nbackground-position: -64px -64px;\n}\n.cripto-14 {\nbackground-position:  -96px -64px;\n}\n.cripto-15 {\nbackground-position:  -128px -64px;\n}\n.cripto-16 {\nbackground-position: 0 -96px;\n}\n.cripto-17 {\nbackground-position:  -32px -96px;\n}\n.cripto-18 {\nbackground-position:  -64px -96px;\n}\n.cripto-19 {\nbackground-position: -96px -96px;\n}\n.cripto-20 {\nbackground-position: -128px -96px;\n}\n.arrow-down,\n.arrow-up {position:relative;}\n.arrow-down:before {\nfont-family: 'wpDataTablesIcons';\n    display: inline-block;\nposition:absolute;\nleft:15px;\n    content: '\\f309';\n    padding-right: 5px;}\n.arrow-up:before \n{font-family: 'wpDataTablesIcons';\n    display: inline-block;\nposition:absolute;\nleft:15px;\n    content: '\\f30c';\n    padding-right: 5px;}\n#home .wpdt-c .wpDataTablesWrapper .wdt-checkbox-filter.btn {\nbackground-color: #ffffff !important;\n    border-color: #dcdfe6 !important;\n    color: #606266 !important;\n}\ntable.wpDataTable:not(.wpdtSimpleTable) tbody td span {\n    margin-left: 10px;\n    display: inline-block;\n    vertical-align: middle;\n}\n.wpDataTablesWrapper table.wpDataTable td.column-column2 {padding: 17px 10px !important;}\n#home table.wpDataTable  tfoot  tr  td span.filter-option.pull-left {margin-top:-1px !important;}\n\n#home div.dt-button-collection a.dt-button.buttons-columnVisibility, #home div.dt-button-collection a.dt-button.buttons-excel, #home div.dt-button-collection a.dt-button.buttons-csv, #home div.dt-button-collection a.dt-button.buttons-pdf, #home div.dt-button-collection a.dt-button.buttons-copy {\nheight: 23px !important;\n}\n#home div.dt-button-collection a.dt-button.buttons-columnVisibility {margin:0 !important;}\n#home div.dt-button-collection a.dt-button:hover:not(.buttons-columnVisibility) { border-bottom: 1px solid #ebeef5 !important;}\n#home .demo .image-chart, #home .demo .image-table {\n       box-shadow: 0 6px 28px 0 rgba(35,36,49,.1) !important;\npadding-top: 16px;\n    background-color: white;\n}\n#home .wpdt-c .wpDataTablesWrapper .DTTT_button:before, .wpdt-c .wpDataTablesWrapper .wdt-checkbox-filter.btn:before {margin-top:2px;}\n.star-ratings-css {\n    color: grey;\n    font-size: 25px;\n    height: 25px;\n    width: 100%;\nmargin:0 auto;\n  position: relative;\n    padding: 0;\n   }\n.yellow {color: gold; position: relative;}\n.half-yellow45,.half-yellow46,.half-yellow44,.half-yellow42{color: grey;}\n.half-yellow45::after {\ndisplay: inline-block;\n    color: gold;\n    content: '\\2605';\n    position: absolute;\nmargin-left: -1em;\n    width: 12px;\n    overflow: hidden;\n}\n.half-yellow46::after {width: 13px;\n   color: gold;\nmargin-left: -1em;\n    content: '\\2605';\n    position: absolute;\n overflow: hidden;}\n.half-yellow44::after {width: 10px;\nmargin-left: -1em;\n   color: gold;\n    content: '\\2605';\n    position: absolute;\n overflow: hidden;}\n.half-yellow42::after {width: 8px;\n   color: gold;\nmargin-left: -1em;\n    content: '\\2605';\n    position: absolute;\n overflow: hidden;}\n.star-ratings-css-top {\n   color: #ffe234;\n    padding: 0;\n    position: absolute;\n    z-index: 1;\n    display: block;\n    top: 0;\n    left: 0;\n    overflow: hidden;\n}\n.star-ratings-css-bottom {\npadding: 0;\n    display: block;\n    z-index: 0;\n}\n.star-ratings-css-bottom span,.star-ratings-css-top span {margin-left:0 !important;}\n.flag {\n    width: 100px;\n    height: 50px;\n    overflow: hidden;\n    border: 1px solid #efefef;\n}\n.france {\n    background: linear-gradient(to right, #002395 calc(100% \/ 3), white calc(100% \/ 3), white calc(100% \/ 3 * 2), #ED2939 calc(100% \/ 3 * 2));\n}\n.germany {\n    background: linear-gradient(to bottom, black calc(100% \/ 3), #DD0000 calc(100% \/ 3), #DD0000 calc(100% \/ 3 * 2), #FFCE00 calc(100% \/ 3 * 2));\n}\n.italy {\n    background: linear-gradient(to right, #009246 calc(100% \/ 3), white calc(100% \/ 3), white calc(100% \/ 3 * 2), #CE2B37 calc(100% \/ 3 * 2));\n}\n.russia {\n    background: linear-gradient(to bottom, white calc(100% \/ 3), #0039A6 calc(100% \/ 3), #0039A6 calc(100% \/ 3 * 2), #D52B1E calc(100% \/ 3 * 2));\n}\n.colombia {\n    background: linear-gradient(to bottom, #FCD116 0%, #FCD116 50%, #003893 50%, #003893 75%, #CE1126 75%, #CE1126 100%);\n}\n.buy-now{\nbackground-color: #091d70 !important;\n    line-height: 1.75;\ncolor:#fff !important;\n    padding: .75rem 2rem;\nmargin:2px;\nfont-size:18px;\n    border-radius: 28px;\n    box-shadow: 0 2px 6px 0 rgba(122,122,122,.5);\n    text-transform: none;\n    position: relative;\n    transition: all .3s ease;}\n.buy-now:hover{cursor:pointer; color:#fff !important;background: #008cff !important;}\n.centar{text-align: center !important;}\n.column-details #wpdatatables-buy-store-header-desktop{cursor:pointer;}\n.resize img{width:400px !important;}\n.md-button{\nbackground-color: #0083c2 !important;\n    line-height: 1.75;\nborder:1px solid transparent;\ncolor:#fff !important;\n    padding: .75rem 2rem;\nfont-size:18px;\n    border-radius: 28px;\n    box-shadow: 0 2px 6px 0 rgba(122,122,122,.5);\n    text-transform: none;\n    position: relative;\n    transition: all .3s ease;}\n.md-button:focus,.md-button:visited{color:#fff !important;background-color: #0083c2 !important;}\n.md-button:hover{cursor:pointer; color:#fff !important;background: #008cff !important;}\n@media only screen and (max-width: 600px) {\n .resize img{\n    width:250px !important;\nmargin-bottom:10px;\ndisplay: block;\n    margin: 0 auto;\n}\n}\n.stars-container {\n position: relative;\n display: inline-block;\n color: transparent;\n font-size: 50px;\nline-height:normal;\n}\n.stars-container::before{\n position: absolute;\n top: 0;\n left: 0;\n content: '\u2605\u2605\u2605\u2605\u2605';\n color:lightgray;\n}\n.stars-container::after {\n position: absolute;\n top: 0;\n left: 0;\n content: '\u2605\u2605\u2605\u2605\u2605';\n color: gold;\n overflow: hidden;\n}\n.stars-0::after { width: 0%; }\n.stars-10::after { width: 10%; }\n.stars-20::after { width: 20%; }\n.stars-30::after { width: 30%; }\n.stars-40::after { width: 40%; }\n.stars-50::after { width: 50%; }\n.stars-60::after { width: 60%; }\n.stars-70::after { width: 70%; }\n.stars-80::after { width: 80%; }\n.stars-85::after { width: 85%; }\n.stars-90::after { width: 90%; }\n.stars-96::after { width: 96%; }\n.stars-100::after { width: 100%; }\ntable.wpDataTable tbody td.redtext { color: #f00 !important; font-weight: bold; }\ntable.wpDataTable tbody td.greentext { color: #070 !important; font-weight: bold; }\n.checkmark {\n    display: inline-block;\n    transform: rotate(45deg);\n    height: 16px;\n    width: 10px;\n    border-bottom: 7px solid #78b13f;\n    border-right: 7px solid #78b13f;\n}\n\n.checkmark-blue {\n    margin-left: 20px;\n    border-bottom: 2px solid #091d70;\n    border-right: 2px solid #091d70;\n}\n\n.checkmark-white {\n    margin-left: 20px;\n    border-bottom: 2px solid #FFFFFF;\n    border-right: 2px solid #FFFFFF;\n}\n\n.checkmark-black {\n    margin-left: 20px;\n    border-bottom: 2px solid #000000;\n    border-right: 2px solid #000000;\n}table.wpDataTable td.numdata { text-align: right !important; }\n<\/style>\n<style>\n                    \n                                                                                            \/* table font size *\/\n    .wpdt-c.wpDataTablesWrapper table.wpdtSimpleTable,\n    .wpdt-c .wpDataTablesWrapper table.wpDataTable {\n        font-size: 13px !important;\n    }\n\n            \n                <\/style>\n<style>\n<\/style>\n<style>\n                            \n                                        \n                    \n<\/style>\n[vc_message message_box_style=&#8221;solid&#8221; style=&#8221;square&#8221; message_box_color=&#8221;warning&#8221; icon_fontawesome=&#8221;fas fa-exclamation-triangle&#8221; css=&#8221;.vc_custom_1675933368370{margin-top: 30px !important;}&#8221;]<span class=\"wdt-alert-subtitle\">If a MySQL query returns a lot of data (hundreds of thousands, or even millions of rows), and if the queries and tables are not appropriately optimized (with indexes and proper data types), the tables can still work slowly \u2013 but wpDataTables isn&#8217;t &#8220;responsible&#8221; for this since the delays are derived from the MySQL engine. Optimize the MySQL tables and query structure, and wpDataTables will also speed up!<\/span>[\/vc_message]<\/div><\/div> <!-- \/.card --><div class=\"card\" id=\"create_the_table\"><div class=\"card-header ch-alt\"><h2><span class=\"ez-toc-section\" id=\"Instructions_to_create_the_table\"><\/span><span>Instructions to create the table<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2><\/div> <!-- \/.card-header --><div class=\"card-body card-padding\">[vc_row_inner equal_height=&#8221;yes&#8221; content_placement=&#8221;middle&#8221;][vc_column_inner width=&#8221;1\/2&#8243;][vc_single_image image=&#8221;53832&#8243; img_size=&#8221;full&#8221; alignment=&#8221;center&#8221; style=&#8221;vc_box_border&#8221; onclick=&#8221;zoom&#8221;][\/vc_column_inner][vc_column_inner width=&#8221;1\/2&#8243;][vc_column_text]The first thing to be done is to prepare the data on the MySQL side. Normally, you would already have tables and the query but here we will assume that you use the same sample table as in the example on this page.<\/p>\n<p><a href=\"\/sample_files\/sample_large_table.sql\">Here&#8217;s the link<\/a> to download the SQL dump of this table.<\/p>\n<p>Go to your phpMyAdmin, choose the database that wpDataTables is configured to use, open the &#8220;<strong>Import<\/strong>&#8221; tab, go to &#8220;<strong>Choose file<\/strong>&#8220;, open the file that you just downloaded, and click &#8220;<strong>Go<\/strong>&#8221; so that phpMyAdmin will import the table.[\/vc_column_text][\/vc_column_inner][\/vc_row_inner][vc_row_inner equal_height=&#8221;yes&#8221; content_placement=&#8221;middle&#8221;][vc_column_inner width=&#8221;1\/2&#8243;][vc_single_image image=&#8221;53834&#8243; img_size=&#8221;full&#8221; alignment=&#8221;center&#8221; style=&#8221;vc_box_border&#8221; onclick=&#8221;zoom&#8221;][\/vc_column_inner][vc_column_inner width=&#8221;1\/2&#8243;][vc_column_text]You can then click on the &#8220;sample_large_table&#8221; in the tables browser on the left to verify if the data loaded correctly.<\/p>\n<p>Once the data is loaded, we need to prepare an SQL query that will fetch this data from MySQL. In this case, it&#8217;s simple: &#8220;<strong>SELECT * FROM sample_large_table<\/strong>&#8220;. You can try this query out in the <strong>SQL<\/strong>\u00a0tab of PHPMyAdmin to see that it returns the information we need.[\/vc_column_text][\/vc_column_inner][\/vc_row_inner]<\/div><\/div> <!-- \/.card --><div class=\"card\" id=\"create-wpdatatable\"><div class=\"card-header ch-alt\"><h2><span class=\"ez-toc-section\" id=\"Create_a_wpDataTable_with_server-side_processing_feature_enabled\"><\/span><span>Create a wpDataTable with server-side processing feature enabled<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2><\/div> <!-- \/.card-header --><div class=\"card-body card-padding\">[vc_row_inner][vc_column_inner][vc_column_text]Once the query is prepared, we can build a wpDataTable based on it.<\/p>\n<p>Please open your WordPress admin, and:[\/vc_column_text][\/vc_column_inner][\/vc_row_inner][vc_row_inner equal_height=&#8221;yes&#8221; content_placement=&#8221;middle&#8221;][vc_column_inner width=&#8221;1\/2&#8243;][vc_single_image image=&#8221;53836&#8243; img_size=&#8221;full&#8221; style=&#8221;vc_box_border&#8221; onclick=&#8221;zoom&#8221;][\/vc_column_inner][vc_column_inner width=&#8221;1\/2&#8243;][vc_column_text]1. Go to <strong>wpDataTables <\/strong>-&gt;\u00a0<strong>Create a Table,\u00a0<\/strong>and choose<strong> Create a table linked to an existing data source<\/strong>\u00a0option.[\/vc_column_text][\/vc_column_inner][\/vc_row_inner][vc_row_inner equal_height=&#8221;yes&#8221; content_placement=&#8221;middle&#8221;][vc_column_inner width=&#8221;1\/2&#8243;][vc_single_image image=&#8221;53839&#8243; img_size=&#8221;full&#8221; style=&#8221;vc_box_border&#8221; onclick=&#8221;zoom&#8221;][\/vc_column_inner][vc_column_inner width=&#8221;1\/2&#8243;][vc_column_text]2. Provide a name for your new table in the <strong>wpDataTable name\u00a0<\/strong>input to identify it among others.<br \/>\n3. Choose MySQL query in\u00a0the <strong>Input data source type<\/strong> select-box.<br \/>\n4. Put the SQL query prepared in the step 1 in the <strong>MySQL Query<\/strong>\u00a0editor (&#8220;<strong>SELECT * FROM sample_large_table<\/strong>&#8220;).<br \/>\n5. Make sure that\u00a0<strong>Server-side processing<\/strong> checkbox is enabled.<br \/>\n6. Click <strong>Save Changes,<\/strong>\u00a0so that wpDataTables will initialize the table and columns metadata from the results of this query.[\/vc_column_text][\/vc_column_inner][\/vc_row_inner]<\/div><\/div> <!-- \/.card --><div class=\"card\" id=\"optional\"><div class=\"card-header ch-alt\"><h2><span class=\"ez-toc-section\" id=\"Define_additional_table_and_columns_settings_Optional\"><\/span><span>Define additional table and columns settings (Optional)<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2><\/div> <!-- \/.card-header --><div class=\"card-body card-padding\">[vc_column_text]At this point table is already prepared. But to improve usability, we need to define some additional settings\u00a0for the table and for its columns.<\/p>\n<p>1. Enabled <strong>Limit table width<\/strong>\u00a0and <strong>Word Wrap<\/strong>\u00a0checkboxes.<br \/>\n2. Disabled the <strong>Visible<\/strong>\u00a0checkbox for &#8220;<em>id<\/em>&#8221; column.<br \/>\n3. Defined\u00a0additional informative and readable <strong>Displayed headers<\/strong>\u00a0for the columns &#8211; &#8220;<em>Name<\/em>&#8221; instead of &#8220;<em>name<\/em>&#8220;, &#8220;<em>Order Date<\/em>&#8221; instead of &#8220;<em>order_date<\/em>&#8220;, &#8220;<em>Product<\/em>&#8221; instead of &#8220;<em>product<\/em>&#8220;, &#8220;<em>Amount<\/em>&#8221; instead of &#8220;<em>amount<\/em>&#8220;, &#8220;<em>Total<\/em>&#8221; instead of &#8220;<em>total<\/em>&#8220;.<br \/>\n4. Set the <strong>Filter type<\/strong> for &#8220;<em>Company<\/em>&#8221; as <strong>&#8220;Select box&#8221;<\/strong>.<br \/>\n5. Set the <strong>Filter type<\/strong> for &#8220;<em>Order Date<\/em>&#8221; column as <strong>&#8220;Date Range&#8221;<\/strong>.<br \/>\n6. Set the <strong>Filter type<\/strong> for &#8220;<em>Product<\/em>&#8221; as <strong>&#8220;Select box&#8221;<\/strong>.<br \/>\n7. Set the <strong>Filter type<\/strong> for &#8220;<em>Amount<\/em>&#8221; as a <strong>&#8220;Number Range&#8221;<\/strong>, set the <strong>Width<\/strong> to &#8220;<strong>10%&#8221;<\/strong><br \/>\n8. Set the <strong>Filter type<\/strong> for &#8220;<em>Total<\/em>&#8221; as <strong>&#8220;Number Range&#8221;<\/strong>, <strong>Column type<\/strong>\u00a0to <strong>&#8220;Float&#8221;<\/strong>, <strong>Display text before<\/strong>\u00a0as <strong>&#8220;$&#8221;<\/strong> so that currency sign would be displayed, and <strong>Width<\/strong> to &#8220;<strong>10%<\/strong>&#8220;.[\/vc_column_text]<\/div><\/div> <!-- \/.card --><div class=\"card\" id=\"insert-wpdatatable\"><div class=\"card-header ch-alt\"><h2><span class=\"ez-toc-section\" id=\"Insert_the_wpDataTable_in_WordPress_post_or_Page\"><\/span><span>Insert the wpDataTable in WordPress post or Page<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2><\/div> <!-- \/.card-header --><div class=\"card-body card-padding\">[vc_row_inner equal_height=&#8221;yes&#8221; content_placement=&#8221;middle&#8221;][vc_column_inner width=&#8221;1\/2&#8243;][vc_single_image image=&#8221;53841&#8243; img_size=&#8221;full&#8221; alignment=&#8221;center&#8221; style=&#8221;vc_box_border&#8221; onclick=&#8221;zoom&#8221;][\/vc_column_inner][vc_column_inner width=&#8221;1\/2&#8243;][vc_column_text]<\/p>\n<div class=\"wpb_text_column wpb_content_element \">\n<div class=\"ewf-wrapper\">\n<p>When you\u00a0finish preparing your MySQL-based wpDataTable, you simly need to insert it into your post or page.<\/p>\n<p>1. Create or open\u00a0a WordPress post or page,<br \/>\n2. Place the cursor in the position where you want to insert your table.<br \/>\n3. Click the \u201c<strong>Insert a wpDataTable<\/strong>\u201d button in\u00a0the MCE editor panel.<br \/>\n4. Choose the MySQL-based table that you prepared from the list and click <strong>OK<\/strong>.<\/p>\n<\/div>\n<\/div>\n<p>If you are using Gutenberg editor, Elementor, or WPBakery page builder, you can check out the section for <a href=\"https:\/\/wpdatatables.com\/documentation\/general\/wpdatatables-shortcodes\/\">Adding wpDataTables shortcodes on the page<\/a>.[\/vc_column_text][\/vc_column_inner][\/vc_row_inner]<\/div><\/div> <!-- \/.card --><div class=\"card\" id=\"additional-info\"><div class=\"card-header ch-alt\"><h2><span class=\"ez-toc-section\" id=\"Read_more\"><\/span><span>Read more<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2><\/div> <!-- \/.card-header --><div class=\"card-body card-padding\">[vc_column_text]<\/p>\n<ul>\n<li><a href=\"https:\/\/wpdatatables.com\/documentation\/creating-wpdatatables\/creating-mysql-based-wpdatatables-with-server-side-processing\/\">Full information on Server-side processing<\/a><\/li>\n<li><a href=\"https:\/\/wpdatatables.com\/documentation\/creating-new-wpdatatables-with-table-constructor\/building-and-filling-in-the-tables-manually\/\">Creating editable tables manually<\/a><\/li>\n<li><a href=\"https:\/\/wpdatatables.com\/documentation\/creating-wpdatatables\/creating-mysql-based-wpdatatables\/\">MySQL-based tables basics<\/a><\/li>\n<li><a href=\"https:\/\/wpdatatables.com\/documentation\/front-end-editing\/creating-editable-tables\/\">Making MySQL tables editable<\/a><\/li>\n<li><a href=\"https:\/\/wpdatatables.com\/documentation\/creating-wpdatatables\/creating-wpdatatables-from-excel\/\">Creating non-editable tables based on Excel files\u00a0<\/a><\/li>\n<li><a href=\"https:\/\/wpdatatables.com\/documentation\/creating-wpdatatables\/creating-wpdatatables-from-google-spreadsheets\/\">Creating non-editable tables based on Google Spreadsheeets<\/a><\/li>\n<li><a href=\"https:\/\/wpdatatables.com\/documentation\/creating-new-wpdatatables-with-table-constructor\/generating-wordpress-db-queries-with-table-constructor\/\">Creating editable tables by importing Excel, CSV of Google Spreadsheet data<\/a><\/li>\n<\/ul>\n<p>[\/vc_column_text]<\/div><\/div> <!-- \/.card -->[\/vc_column][\/vc_row][vc_row][vc_column][\/vc_column][\/vc_row]<\/p>\n<\/section>","protected":false},"excerpt":{"rendered":"<p>[vc_row][vc_column][vc_column_text] Creating MySQL-based tables with server-side processing [\/vc_column_text][\/vc_column][\/vc_row][vc_row][vc_column][\/vc_column][\/vc_row]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":244,"menu_order":4,"comment_status":"open","ping_status":"open","template":"","meta":{"_acf_changed":false,"footnotes":""},"class_list":["post-202","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Creating MySQL-based tables with server-side processing - wpDataTables<\/title>\n<meta name=\"description\" content=\"Create MySQL tables with server side processing using wpDataTables plugin.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/wpdatatables.com\/documentation\/creating-wpdatatables\/creating-mysql-based-wpdatatables-with-server-side-processing\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Creating MySQL-based tables with server-side processing - wpDataTables\" \/>\n<meta property=\"og:description\" content=\"Create MySQL tables with server side processing using wpDataTables plugin.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/wpdatatables.com\/documentation\/creating-wpdatatables\/creating-mysql-based-wpdatatables-with-server-side-processing\/\" \/>\n<meta property=\"og:site_name\" content=\"wpDataTables - Tables and Charts WordPress Plugin\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/wpdatatables\/\" \/>\n<meta property=\"article:modified_time\" content=\"2024-11-26T14:21:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2019\/02\/wpDT-1200x628.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@wpdatatables\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/wpdatatables.com\\\/documentation\\\/creating-wpdatatables\\\/creating-mysql-based-wpdatatables-with-server-side-processing\\\/\",\"url\":\"https:\\\/\\\/wpdatatables.com\\\/documentation\\\/creating-wpdatatables\\\/creating-mysql-based-wpdatatables-with-server-side-processing\\\/\",\"name\":\"Creating MySQL-based tables with server-side processing - wpDataTables\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/wpdatatables.com\\\/#website\"},\"datePublished\":\"2015-05-29T15:39:46+00:00\",\"dateModified\":\"2024-11-26T14:21:59+00:00\",\"description\":\"Create MySQL tables with server side processing using wpDataTables plugin.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/wpdatatables.com\\\/documentation\\\/creating-wpdatatables\\\/creating-mysql-based-wpdatatables-with-server-side-processing\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/wpdatatables.com\\\/documentation\\\/creating-wpdatatables\\\/creating-mysql-based-wpdatatables-with-server-side-processing\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/wpdatatables.com\\\/documentation\\\/creating-wpdatatables\\\/creating-mysql-based-wpdatatables-with-server-side-processing\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/wpdatatables.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Documentation\",\"item\":\"https:\\\/\\\/wpdatatables.com\\\/documentation\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Creating wpDataTables from existing data sources\",\"item\":\"https:\\\/\\\/wpdatatables.com\\\/documentation\\\/creating-wpdatatables\\\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Creating MySQL-based tables with server-side processing\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/wpdatatables.com\\\/#website\",\"url\":\"https:\\\/\\\/wpdatatables.com\\\/\",\"name\":\"wpDataTables - Tables and Charts WordPress Plugin\",\"description\":\"Tables and Charts Creator\",\"publisher\":{\"@id\":\"https:\\\/\\\/wpdatatables.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/wpdatatables.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/wpdatatables.com\\\/#organization\",\"name\":\"wpDataTables\",\"url\":\"https:\\\/\\\/wpdatatables.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/wpdatatables.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/wpdatatables.com\\\/wp-content\\\/uploads\\\/2019\\\/02\\\/wpDataTable-Horizontal.png\",\"contentUrl\":\"https:\\\/\\\/wpdatatables.com\\\/wp-content\\\/uploads\\\/2019\\\/02\\\/wpDataTable-Horizontal.png\",\"width\":4120,\"height\":756,\"caption\":\"wpDataTables\"},\"image\":{\"@id\":\"https:\\\/\\\/wpdatatables.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/wpdatatables\\\/\",\"https:\\\/\\\/x.com\\\/wpdatatables\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCR-VfulTsxPa41S1D7fFKqg\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Creating MySQL-based tables with server-side processing - wpDataTables","description":"Create MySQL tables with server side processing using wpDataTables plugin.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/wpdatatables.com\/documentation\/creating-wpdatatables\/creating-mysql-based-wpdatatables-with-server-side-processing\/","og_locale":"en_US","og_type":"article","og_title":"Creating MySQL-based tables with server-side processing - wpDataTables","og_description":"Create MySQL tables with server side processing using wpDataTables plugin.","og_url":"https:\/\/wpdatatables.com\/documentation\/creating-wpdatatables\/creating-mysql-based-wpdatatables-with-server-side-processing\/","og_site_name":"wpDataTables - Tables and Charts WordPress Plugin","article_publisher":"https:\/\/www.facebook.com\/wpdatatables\/","article_modified_time":"2024-11-26T14:21:59+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/wpdatatables.com\/wp-content\/uploads\/2019\/02\/wpDT-1200x628.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_site":"@wpdatatables","twitter_misc":{"Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/wpdatatables.com\/documentation\/creating-wpdatatables\/creating-mysql-based-wpdatatables-with-server-side-processing\/","url":"https:\/\/wpdatatables.com\/documentation\/creating-wpdatatables\/creating-mysql-based-wpdatatables-with-server-side-processing\/","name":"Creating MySQL-based tables with server-side processing - wpDataTables","isPartOf":{"@id":"https:\/\/wpdatatables.com\/#website"},"datePublished":"2015-05-29T15:39:46+00:00","dateModified":"2024-11-26T14:21:59+00:00","description":"Create MySQL tables with server side processing using wpDataTables plugin.","breadcrumb":{"@id":"https:\/\/wpdatatables.com\/documentation\/creating-wpdatatables\/creating-mysql-based-wpdatatables-with-server-side-processing\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/wpdatatables.com\/documentation\/creating-wpdatatables\/creating-mysql-based-wpdatatables-with-server-side-processing\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/wpdatatables.com\/documentation\/creating-wpdatatables\/creating-mysql-based-wpdatatables-with-server-side-processing\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/wpdatatables.com\/"},{"@type":"ListItem","position":2,"name":"Documentation","item":"https:\/\/wpdatatables.com\/documentation\/"},{"@type":"ListItem","position":3,"name":"Creating wpDataTables from existing data sources","item":"https:\/\/wpdatatables.com\/documentation\/creating-wpdatatables\/"},{"@type":"ListItem","position":4,"name":"Creating MySQL-based tables with server-side processing"}]},{"@type":"WebSite","@id":"https:\/\/wpdatatables.com\/#website","url":"https:\/\/wpdatatables.com\/","name":"wpDataTables - Tables and Charts WordPress Plugin","description":"Tables and Charts Creator","publisher":{"@id":"https:\/\/wpdatatables.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/wpdatatables.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/wpdatatables.com\/#organization","name":"wpDataTables","url":"https:\/\/wpdatatables.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/wpdatatables.com\/#\/schema\/logo\/image\/","url":"https:\/\/wpdatatables.com\/wp-content\/uploads\/2019\/02\/wpDataTable-Horizontal.png","contentUrl":"https:\/\/wpdatatables.com\/wp-content\/uploads\/2019\/02\/wpDataTable-Horizontal.png","width":4120,"height":756,"caption":"wpDataTables"},"image":{"@id":"https:\/\/wpdatatables.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/wpdatatables\/","https:\/\/x.com\/wpdatatables","https:\/\/www.youtube.com\/channel\/UCR-VfulTsxPa41S1D7fFKqg"]}]}},"_links":{"self":[{"href":"https:\/\/wpdatatables.com\/wp-json\/wp\/v2\/pages\/202","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wpdatatables.com\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/wpdatatables.com\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/wpdatatables.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wpdatatables.com\/wp-json\/wp\/v2\/comments?post=202"}],"version-history":[{"count":99,"href":"https:\/\/wpdatatables.com\/wp-json\/wp\/v2\/pages\/202\/revisions"}],"predecessor-version":[{"id":53843,"href":"https:\/\/wpdatatables.com\/wp-json\/wp\/v2\/pages\/202\/revisions\/53843"}],"up":[{"embeddable":true,"href":"https:\/\/wpdatatables.com\/wp-json\/wp\/v2\/pages\/244"}],"wp:attachment":[{"href":"https:\/\/wpdatatables.com\/wp-json\/wp\/v2\/media?parent=202"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}