Forum PHP.pl

[PHP] pobierz, plaintext 
if($mysql->rows())
{
  $zespoly = array();
  $wyscigi = array();
  while ($data = $mysql->dbarray())
  {
    $wyscig_name = explode(",", $data['wyscig_name']); 
    $wyscig_pkt = explode(",", $data['wyscig_pkt']);  
    $zespoly[] = array_combine($wyscig_name, $wyscig_pkt);
    $wyscigi = array_merge($wyscigi, $wyscig_name);
  }
  $wyscigi = array_unique($wyscigi);
  for ($i = 0;isset($wyscigi[$i]);++$i) {
    for ($j = 0;isset($zespoly[$j]);++$j) {
      if (!isset($zespoly[$j][$wyscigi[$i]])) {
        $zespoly[$j][$wyscigi[$i]] = 0;
      }
    }
  }
}
[PHP] pobierz, plaintext 

Cytat(arzach @ 2.08.2010, 17:35:49 )

[PHP] pobierz, plaintext 
$zespoly = array(
    array('GP Mazowsza' => 25, 'GP Lodzi' => 15, 'GP Stanów Zjednoczonych' => 15),
    array('GP Stanów Zjednoczonych' => 18, 'GP Lodzi' => 25),
    array('GP Lodzi' => 0, 'GP Mazowsza' => 18),
    array('GP Lodzi' => 0),
);
$wyscigi = array('GP Mazowsza', 'GP Lodzi', 'GP Stanów Zjednoczonych');
$wyscigi = array_unique($wyscigi);
  for ($i = 0;isset($wyscigi[$i]);++$i) {
    for ($j = 0;isset($zespoly[$j]);++$j) {
      if (!isset($zespoly[$j][$wyscigi[$i]])) {
        $zespoly[$j][$wyscigi[$i]] = 0;
      }
    }
  }
header('Content-type: text/plain');
print_r($zespoly);
exit;
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
if($mysql->rows())
{
  $zespoly = array();
  $wyscigi = array();
  while ($data = $mysql->dbarray())
  {
    $id = $data['wynik_id']; 
    $zespoly[$id] = array('zespol_name' => $data['zespol_name'], 'pkt' => $data['pkt'], 'wyscig_name' => array());
    $wyscig_name = explode(",", $data['wyscig_name']); 
    $wyscig_pkt = explode(",", $data['wyscig_pkt']); 
    $zespoly[$id]['wyscig_name'] = array_combine($wyscig_name, $wyscig_pkt);
    $wyscigi = array_merge($wyscigi, $wyscig_name);
  }
  $wyscigi = array_values(array_unique($wyscigi)); 
  for ($i = 0;isset($wyscigi[$i]);++$i) {
    foreach ($zespoly as $id => $dane) {
      if (!isset($dane['wyscig_name'][$wyscigi[$i]])) {
        $zespoly[$id]['wyscig_name'][$wyscigi[$i]] = 0;
      }
    }
  }
}
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
  /* ... */
  $wyscigi = array_values(array_unique($wyscigi)); 
  foreach ($zespoly as $id => $dane) {
    for ($i = 0;isset($wyscigi[$i]);++$i) {
      if (!isset($dane['wyscig_name'][$wyscigi[$i]])) {
        $zespoly[$id]['wyscig_name'][$wyscigi[$i]] = 0;
      }
    }
    ksort($zespoly[$id]['wyscig_name']);
  }
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
$zespoly = array();
$wyscigi = array();
if($mysql->rows())
{
  while ($data = $mysql->dbarray())
  {
    $id = $data['wynik_id']; 
    $zespoly[$id] = array('zespol_name' => $data['zespol_name'], 'pkt' => $data['pkt'], 'wyscig_name' => array());
    $wyscig_name  = explode(",", $data['wyscig_name']);
    $wyscig_pkt   = explode(",", $data['wyscig_pkt']);
 
    /*   tablica z ID wyscigow */
    $wyscig_id    = explode(",", $data['wyscig_id']);
 
    /* zamiast array_combine() */
    $zespoly[$id]['wyscigi'] = array();
    for ($i = 0;isset($wyscig_name[$i]);++$i) {
      if (isset($zespoly[$id]['wyscigi'][$wyscig_name[$i]])) {
        $zespoly[$id]['wyscigi'][$wyscig_name[$i]] += $wyscig_pkt[$i];
      } else {
        $zespoly[$id]['wyscigi'][$wyscig_name[$i]]  = $wyscig_pkt[$i];
      }
    }
    /* koniec zamiast array_combine() */
    $wyscigi = array_merge($wyscigi, array_combine($wyscig_name, $wyscig_id));
  }
  $wyscigi = array_unique($wyscigi);
  ksort($wyscigi);
  foreach ($zespoly as $id => $dane) {
    foreach ($wyscigi as $wyscig_name) {
      if (!isset($dane['wyscigi'][$wyscig_name])) {
        $zespoly[$id]['wyscigi'][$wyscig_name] = 0;
      }
    }
    ksort($zespoly[$id]['wyscigi']);
  }
}
 
/* Wyswietlanie */
$lp      = 1;
$colspan = count($wyscigi);
echo "<table border='1'align='center'>
<tr>
	<td rowspan='2'align='center'>Pozycja</td>
	<td rowspan='2'align='center'>Zespoł</td>
	<td rowspan='2 align='center'>Punkty</td> 
	<td colspan='" . $colspan . "' align='center'>Wyscigi</td>
</tr>
<tr>";
foreach ($wyscigi AS $wyscig_name => $wyscig_id) { 
    echo "<td><a href='wyscig.php?wyscig_id=".$wyscig_id."'></a>".$wyscig_name."</td>";    
}
echo "</tr>";
 
foreach ($zespoly AS $zespol){
    echo "<tr>
        <td align='center'>".$lp."</td>
        <td align='center'>".$zespoly['zespol_name']."</td>
        <td align='center'>".$zespoly['pkt']."</td>"; 
        foreach ($zespol['wyscigi'] as $pkt) {
            echo "<td align='center'>{$pkt}</td>";
        }
 
    echo "</tr>";
    $lp++;
}
echo "</table>";
[PHP] pobierz, plaintext