fork download 
  1. <?php
  2.  
  3. $query="SELECT id, display, country FROM $table ";
  4. $stmt = $pdo->prepare($query);
  5. $stmt->execute();
  6. while ($row=$stmt->fetch()) {
  7. 	$data3[$row['country']]['display'][$row['display']][]=$row['id'];
  8. 	}
  9. }
  10.  
  11. $display=array(
  12. "0"=>"На рассмотрении",
  13. "1"=>"Утверждено",
  14. "2"=>"Отклонено"
  15. 	);
  16. ?>
  17.  
  18.  <strong> Сводная таблица из БД</strong>
  19. 	// <div class="tot_registered"> Всего зарегистрированных: <span> <?php //echo count($data3['rows']); ?></span> </div>
  20.     <div class="tot_countries"> Количество стран:   <span> <?php echo count($data['countries']); ?> </span> </div>
  21.     <table class="table">
  22.  
  23. <tr>
  24. 	<th> Страна </th>
  25. 	<th> Всего </th>
  26.  
  27. 			<?php foreach ($display as $key => $value): ?>
  28. 	<th> <?php echo $value;?> </th>
  29. 			<?php endforeach; ?>
  30. </tr>
  31.  
  32.     <?php foreach ($data3 as $key => $country_data): ?> 
  33.     	<tr> 
  34.     		<td><? echo $key; ?> </td>
  35.     		<td><? echo (count($country_data['display'],COUNT_RECURSIVE)-count($country_data['display'])); ?> </td>
  36.     		<?php foreach ($display as $key => $value) { 
  37.  
  38.     			if (isset($country_data['display'][$key])) {
  39.     				$amount=count($country_data['display'][$key]);
  40.     			}else {
  41.     				$amount=0;
  42.     			}
  43.     			?>
  44.     			<td><?php echo $amount; ?> </td>
  45.  
  46.     		<?php	} ?>
  47.     	</tr>	
  48.     <?php endforeach; ?>
  49. </table>
Runtime error #stdin #stdout #stderr 0.03s 52480KB
comments (?)
stdin 
Standard input is empty
stdout 
Standard output is empty
stderr 
PHP Parse error:  syntax error, unexpected '}' in /home/o82QAe/prog.php on line 9
https://ideone.com/Xcdshl
language:
PHP (php 7.3.5)
created:
10 years ago
visibility:
secret

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!