mbga.txt

Part 1 

1. 30
2. 12Fizz4BuzzFizz78FizzBuzz11Fizz1314FizzBuzz1617Fizz19BuzzFizz2223FizzBuzz26Fizz2829FizzBuzz3132Fizz34BuzzFizz3738FizzBuzz41Fizz4344FizzBuzz4647Fizz49BuzzFizz5253FizzBuzz56Fizz5859FizzBuzz6162Fizz64BuzzFizz6768FizzBuzz71Fizz7374FizzBuzz7677Fizz79BuzzFizz8283FizzBuzz86Fizz8889FizzBuzz9192Fizz94BuzzFizz9798Fizz

<?php
$foo = range(0 ,100);
for($i=1;$i < 100;$i++){
    if($i % 3 == 0){
        $foo[$i]="Fizz";
    }
    if($i % 5 == 0){
        $foo[$i]="Buzz";
    }
    if(($i % 3 == 0) &&($i % 5 == 0)){
        $foo[$i]="FizzBuzz";
    }
    echo $foo[$i]; 
}
?>

3. Segitiga
        *
       * *
      * * *
     * * * *
    * * * * *

<?php
$n=5;
$k = 2 * $n - 2; 
for ($i = 0; $i < $n; $i++) 
{ 
    for ($j = 0; $j < $k; $j++) 
        echo '&nbsp'; 
    $k = $k - 1; 
    for ($j = 0; $j <= $i; $j++ ) 
    { 
        echo "* "; 
    } 
    echo "<br>"; 
} 
?>

Segitiga terbalik

    * * * * *
     * * * *
      * * *
       * *
        * 
        
for ($c = 5; $c >= 1; $c--) 
{ 
    for ($t = 2; $t <= 10 - $c; $t++) {
        echo '&nbsp'; 
    }
    for ($t = 1; $t <= $c; $t++ ) 
    { 
        echo "* "; 
    } 
    echo "<br>"; 
} 

Ketupat

        *
       * *
      * * *
     * * * *
    * * * * *
    * * * * *
     * * * *
      * * *
       * *
        *

$n=5;
$k = 2 * $n - 2; 
for ($i = 0; $i < $n; $i++) 
{ 
    for ($j = 0; $j < $k; $j++) 
        echo '&nbsp'; 
    $k = $k - 1; 
    for ($j = 0; $j <= $i; $j++ ) 
    { 
        echo "* "; 
    } 
    echo "<br>"; 
} 
for ($c = 5; $c >= 1; $c--) 
{ 
    for ($t = 2; $t <= 10 - $c; $t++) {
        echo '&nbsp'; 
    }
    for ($t = 1; $t <= $c; $t++ ) 
    { 
        echo "* "; 
    } 
    echo "<br>"; 
} 

Part 2 SQL

4. SELECT title,release_year FROM `film` 

5. SELECT * FROM `category` ORDER BY film DESC

6. SELECT * FROM `film` ORDER BY rental_rate DESC LIMIT 5

7. SELECT * FROM `category` ORDER BY film DESC LIMIT 3