Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $conn = new mysqli('localhost', '**', '', 'test');
- if ($conn->connect_error) {
- die("Connection failed: " . $conn->connect_error);
- }
- $query = "select * from table01 ";
- $result = $conn->query($query);
- while($row2 = mysqli_fetch_assoc($result))
- {
- $arr2[]=$row2;
- }
- $row=count($arr2);
- for($i = 0; $i < $row; $i++) {
- $dat[$arr2[$i]['date1']]=1; //делаем уникальную дату(ключь не может повторятся)
- $name[$arr2[$i]['bluch_title']]=2;//делаем уникальное название(ключь не может повторятся)
- }
- echo '<table border="1">';
- echo '<tr>';
- echo '<td>Name';
- foreach ($dat as $key => $value) {
- echo'<td>'.$key;
- }
- echo '</td>';
- echo '</tr>';
- $set=count($dat);
- foreach ($name as $key1 => $value1) {
- foreach ($dat as $key => $value) {
- $query0 = "select * from table01 where date1='".$key."' and bluch_title='".$key1."'";
- $result2 = $conn->query($query0);
- while($row21 = mysqli_fetch_assoc($result2))
- {
- $arr21[]=$row21['bluch_views'];
- }
- }}
- $res=array_chunk($arr21, $set, TRUE); //разбиваем массив
- foreach ($res as $key6 => $value6) {
- # code...
- $fud[]=array_values($value6); //пересоздаём ключи во вложенном массиве
- }
- $k='-1';
- foreach ($name as $key1 => $value1) {
- $k++;
- echo'<tr><td>'.$key1;
- for($ii = 0; $ii < $set; $ii++) {
- echo '<td>'.$fud[$k][$ii];
- }
- echo '</td>';
- }
- echo '</table>';
- ?>
Advertisement
RAW Paste Data
Copied
Advertisement