Web Development

SELECT customers_address.customer_address_id, address_category.address_category_name, customers_address.address_name,
address_details.address_details_id,
address_details.address_details_text
FROM customers_address
JOIN address_category ON address_category.address_category_id = customers_address.address_category_id
LEFT JOIN address_details ON address_details.customer_address_id = customers_address.customer_address_id
WHERE customer_id = param_customer;

CustomerAddress:
     {
        customer_address_id
        address_category_name
        address_name
     }
     Details:
         {
            address_details_id
            address_details_text
         }

$mysql_query = $mysql_connection->prepare('CALL sp_populate_customer_addresses(:param_customer)');
$mysql_query->bindParam(':param_customer', $customer_id, PDO::PARAM_STR);
$mysql_query->execute();

if ($mysql_query->rowCount() <= 0) { echo "false"; }
else
{
  $jsonData = array();

  while($mysql_row = $mysql_query->fetch())
  {
      $jsonData[] = $mysql_row;
  }

    echo json_encode($jsonData);
}

Two type provide adding a table in nopcommerce. One for Nop.Admin and second for Nop.web(Nop.admin used admin side  and if we are an add table in user side then used Nop.web)
so I want to add a new table in Nop.web interface (I mean to say we want integration in nopCommerce new tables in the User interface. Like  create form "CustomOrder" in  user side. )
Please anyone help.

.state("child.tab", {                          // State common for all tabs
                url: "/tab/{TableId:int}",
                cache: false,
                reloadOnSearch: true,
                params: { TableId: null },
                views: {
                    'filters@child.tab': {
                        templateProvider: ['$stateParams', '$templateFactory', function ($stateParams, $templateFactory) {
                            return $templateFactory.fromUrl('templates/user/abc.html');
                        }]
                    },
 
		   'list@child.tab': {
                        templateProvider: ['$stateParams', '$templateFactory', function ($stateParams, $templateFactory) {
                            return $templateFactory.fromUrl('templates/user/xyz.html');
                        }]
                    },
    
                   'form@child.tab': {
                        templateProvider: ['$stateParams', '$templateFactory', function ($stateParams, $templateFactory) {
                            return $templateFactory.fromUrl('templates/user/pqr.html');
                        }]
                    }
                }
})

<div id="headerLeft" style="position: relative; width:50%; float:left">

<pre>
<label>Show</label>
<div class="select-style">
    <select id="rowsperpage" name="rowsperpage" onchange="updateRowsPerPage(this.value)">
        <option value="10">10</option>
        <option value="25">25</option>
        <option value="50">50</option>
    </select>
</div>
<label>rows</label>

.select-style {
    border: 1px solid #ccc;
    width: 65px;
    border-radius: 3px;
    overflow: hidden;
    background: #fafafa url("img/icon-select.png") no-repeat 90% 50%;
}

.select-style select {
    padding: 5px 8px;
    width: 130%;
    border: none;
    box-shadow: none;
    background: transparent;
    background-image: none;
    -webkit-appearance: none;
}

.select-style select:focus {
    outline: none;
    }