Forum PHP.pl

function x($link, $num, $page){

  if(strpos($link, "?") == 0){

    return " <a href="".$link."?from=".$num."">".$page."</a> ";

  }else{

    return " <a href="".$link."&from=".$num."">".$page."</a> ";

  }

}



function GetPagesCount($options, $per_page){

  $mod = $options % $per_page;

  $a   = $options - $mod;



  $b   = $a / $per_page;



  if($mod > 0){

    $c = 1;

  }else{

    $c = 0;

  }



  return $b + $c;

}



function StartLastPage($options, $per_page){

  $mod = $options % $per_page;

  $a   = $options - $mod;



  $b   = $a / $per_page;



  if($mod > 0){

    return $a + 1;

  }else{

    return $a - ($per_page-1);

  }

}



function MakePages($options, $per_page, $active, $link){



  $mod = $options % $per_page;

  $a   = $options - $mod;

  

  $b   = $a / $per_page;

  



  if($mod > 0){

    $c = 1;

  }else{

    $c = 0;

  }

  

  $rt[0]  = $b + $c;

  

  if($b+$c > 5){

    $b = $b-1;

    $links = x($link, 1, 1);

    if($active > 3){

      $links .= "... ";

      $links .= x($link, $per_page*($active-1), $active-1);

      $links .= x($link, $per_page*$active, $active);

      if($active < $b + $c){

        $links .= x($link, $per_page*(1+$active), $active+1);

      }

    }else{

      $links .= x($link, $per_page, 2);

      $links .= x($link, $per_page*2, 3);

      $links .= x($link, $per_page*3, 4);

    }

    if($active < $b + $c-1){

      $links .= "... ";

      $links .= x($link, $per_page * ($b + $c), $b + $c);

    }

  }else{

    for($i = 1; $i <= $b+$c; $i++){

      $link_num = $per_page*($i-1);

      if($i == 1){

        $link_num++;

      }else{

        $link_num++;

      }

      $links .= x($link, $link_num, $i);

    }

  }

  

  $rt[1] = $links;

  return $rt;

}

    $cnt = count($tablica_wynikow);

    $buf = $cnt;

    

    if(!isset($from)){

      $from = 1;

    }

    

    if($cnt > $tpp){

      $limit = $cnt - $from;

      if($limit > $tpp){

        $limit = $tpp;

      }elseif($limit < $tpp){

         $limit++;

      }

    }else{

      $limit = $cnt;

    }

  /* A potem wywołanie pętli FOR wyświetlającej wyniki, jeśli pierwszy element tabeli wyników ma indeks 1: */

    if($cnt > 0){

      // Gdy są jakieś wyniki

      for($i = $from; $i <= $from+$limit-1; $i++){

   // Kod wyświetlający wyniki

     }

   }else{

  // Gdy nie ma wyników

   }

  

function mysql_create_table($table,$fields){

   $columns = count($fields);         # Ile jest kolumn do dodania

   $newtable = 0;

   if($fields[$columns][1]=="primary key"){

     $query = "CREATE TABLE $table (".$fields[1][1]." ".$fields[1][2]." ".$fields[1][3].",

                                  ".$fields[$columns][1]." (".$fields[$columns][2]."))";

     $dec = 1;

   }else{

     $query = "CREATE TABLE $table (".$fields[1][1]." ".$fields[1][2]." ".$fields[1][3].")";

     $dec = 0;

   }

   if(mysql_query($query)){

     $newtable = 1;

     $howmany++;

   }

   for($counter=2; $counter <=$columns-$dec; $counter++){

     if($fields[$counter][1]!="primary key" && $fields[$counter][1]!="key"){

       $query = "ALTER TABLE $table ADD ".$fields[$counter][1]." ".$fields[$counter][2];

       if($fields[$counter][3]!=""){

         $query .= " ".$fields[$counter][3];

       }

       $query .= " AFTER ".$fields[$counter-1][1];

     }

     if($fields[$counter][1]=="primary key" || $fields[$counter][1]=="key"){

       if(!$newtable){

         $query = "ALTER TABLE $table DROP INDEX ".$fields[$counter][1]."  ADD ".$fields[$counter][1]." (".$fields[$counter][2].")";

       }else{

         $query = "ALTER TABLE $table ADD ".$fields[$counter][1]." (".$fields[$counter][2].")";

       }

     }

     if(mysql_query($query)){

       $howmany++;

     }else{

       die("MySQL error: error in adding column $fields[$counter][1] to table $table.");

     }

   }

   return $howmany;

}

$tabela = array(1=> array(1=>"id", "int(10)", "NOT NULL auto_increment"),

                    array(1=>"pole_textowe", "varchar(128)", ""),

                    array(1=>"blobek", "blob", "not null"),

                    array(1=>"primary key", "id"));