PHP - Crear Tabla de forma dinamica con PHP y SQL SERVER

procedure [dbo].[tabla_productos_redistribucion_estilo]

@estilo as nvarchar(100)

as

begin

select colorname as Color, sizecode as Talla, STORE.StoreNo, cast(onhandqty as int) as 'onhandqty'

into #tmpResumen

from _retaildata..product

inner join _retaildata..product_style on product.stylecode = product_style.stylecode

inner join _retaildata..product_store on product.sku = product_store.sku

inner join _retaildata..color on product.colorcode = color.colorcode

inner join _retaildata..store on product_store.storeno = store.storeno

where onhandqty <>0

and store.activestatus=1

and store.warehouse =0

and stylename = @estilo

declare @tiendas varchar (max)

DECLARE @SQLString nvarchar(500)

set @tiendas =''

select @tiendas = coalesce(@tiendas+'['+CAST(STORE.StoreNo AS varchar(100))+'],','') from _retaildata..product

inner join _retaildata..product_style on product.stylecode = product_style.stylecode

inner join _retaildata..product_store on product.sku = product_store.sku

inner join _retaildata..color on product.colorcode = color.colorcode

inner join _retaildata..store on product_store.storeno = store.storeno

where onhandqty <>0

and stylename = @estilo

and store.activestatus=1

and store.warehouse =0

group by STORE.StoreNo

set @tiendas = left(@tiendas, len(@tiendas)-1)

set @SQLString = N'

select Color, Talla, '+@tiendas+' from #tmpResumen

pivot(

sum(onhandqty) for [storenO] in ('+@tiendas+')) as P;'

EXECUTE sp_executesql @SQLString

end

<?php

//la conexion a la base de datos

$mysqli = new mysqli("localhost", "usuario", "contraseña", "basedatos");

$mysqli->set_charset('utf8');

//la consulta sql

$consulta = "SELECT * FROM nombretabla";

//guarda el resultado

$result = $mysqli->query( $consulta );

//verifica si obtuviste resultados 

if ( $result ) {

?>

<table>

<?php

//un while que recorre cada resultado y luego lo colocas en las casillas de la tabla   

while ($row = mysqli_fetch_assoc($result )){

?>

  <tr>

    <th>$row['campo1']</th>

    <th>$row['campo2']</th>

    <th>$row['campo3']</th>

  </tr>

<?php

}

?>

</table>

<?php

}else{

   throw new Exception( $mysqli->error );

}

<tr>

    <th>$row[0]</th>

    <th>$row[1]</th>

    <th>$row[2]</th>

</tr>

global

$texto ="<table>

                <thead>

                  <tr>

                  <th>COLOR</th>

                  <th>TALLA</th>";

    $sql_preg = "{CALL tabla_productos_redistribucion_estilo_columna(?)}";

    $params = array(

        array( &$dato, SQLSRV_PARAM_IN )

    );

    $registros = sqlsrv_query($conexion, $sql_preg, $params);

if( $registros === false) {

    die( print_r( sqlsrv_errors(), true) );

}

$total_col=0;

do {

    while ($row = sqlsrv_fetch_array($registros))

    {

        $texto .= "<th width=10 class ='lineal'>".$row['storeno']."</th>" ;

        $total_col++;

    }

}  while (sqlsrv_next_result($registros));

$conteo_col = $total_col;

$texto.="</tr>

        </thead>

        <tbody>";

    $sql_preg = "{CALL tabla_productos_redistribucion_estilo(?)}";

    $params = array(

        array( &$dato, SQLSRV_PARAM_IN )

    );

    $registros = sqlsrv_query($conexion, $sql_preg, $params);

if( $registros === false) {

    die( print_r( sqlsrv_errors(), true) );

}

do {

    while ($row = sqlsrv_fetch_array($registros))

    {

        $texto .="<tr>";

        for($y=0;$y<$conteo_col+2;$y++) {

            $texto .='<td width=10>'.$row[$y].'</td>';

        }

        $texto .="</tr>";

    }

}  while (sqlsrv_next_result($registros));

$texto .="</tbody> </table>";

echo $texto;