PHP - mysqli_num_rows oraz mysqli_fetch_assoc()

pytanie zadane 6 marca 2018 w PHP przez kingkushlee Gaduła (3,960 p.)
zamknięte 6 marca 2018 przez kingkushlee
Witam, mam taki kod sklepu gry internetowej:
<?php
    session_start();
    require_once("skrypty/config.php");
    require_once("skrypty/getBills.php");
    if (!isset($_SESSION['zalogowany'])){
        header('Location: zaloguj-sie');
        exit();                    
    }
    if(isset($_GET['unset'])){
            unset($_SESSION['popup']);
    }
?>
<!DOCTYPE html>
<html lang="en">
<head>   
    <meta charset="UTF-8">
    <title><?= $tytulSerwer?></title>
    <link href="https://fonts.googleapis.com/css?family=Bungee|Ubuntu" rel="stylesheet">
    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0-beta.2/css/bootstrap.min.css" integrity="sha384-PsH8R72JQ3SOdhVi3uxftmaW6Vc51MKb0q5P2rRUpPvrszuE4W1povHYgTpBfshb" crossorigin="anonymous">
    <script src="https://code.jquery.com/jquery-3.2.1.slim.min.js" integrity="sha384-KJ3o2DKtIkvYIK3UENzmM7KCkRr/rE9/Qpg6aAZGJwFDMVNA/GpGFF93hXpG5KkN" crossorigin="anonymous"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.12.3/umd/popper.min.js" integrity="sha384-vFJXuSJphROIrBnz7yo7oB41mKfc8JzQZiCq4NCceLEaO4IHwicKwpJf9c9IpFgh" crossorigin="anonymous"></script>
    <script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0-beta.2/js/bootstrap.min.js" integrity="sha384-alpBpkh1PFOepccYVYDB4do5UnbKysX5WZXm3XxPqe5iKTfUKjNkCk9SaVuEZflJ" crossorigin="anonymous"></script>
    <link rel="stylesheet" href="style.css">
    <style>
        article {
            width: 1000px;
        }
        .content {
            margin-left: auto;
            margin-right: auto;
        }
        
        .item {
            padding: 20px;
            transition: all .3s;
            -ms-transition: all .3s;
            -webkit-transition: all .3s;
        }
        
        .item:hover {
            margin-bottom: 20px;
            transform: scale(1.2);
            -ms-transform: scale(1.2);
            -webkit-transform: scale(1.2);
            box-shadow: 0 0 20px #888;
        }
        .popup {
            z-index: 9999;
            background-color: white;
            color: black;
            text-align: center;
            padding: 15px;
        }
    </style>
</head>
<body>
    <header>
        SKLEP
    </header>
    <nav>
        <ol>
            <li><a style="text-decoration: none; color: #fff;" href="strona-glowna">Strona główna</a></li>
            <li><a style="text-decoration: none; color: #fff;" href="sklep">Sklep</a></li>
            <li><a style="text-decoration: none; color: #fff;" href="zglos-cheatera">Zgłoś cheatera</a></li>
            <li><a style="text-decoration: none; color: #fff;" href="stan-konta">Stan konta</a></li>
        </ol>
    </nav>
    <article class="content">      
      <h2><?php if(isset($_SESSION['tranzakcja'])){echo $_SESSION['tranzakcja']; unset($_SESSION['tranzakcja']);} if(isset($_SESSION['error'])){echo '<div class="popup"><span style="color: red;">Nie masz tyle żetonów!</span></div>'; unset($_SESSION['error']);} if(isset($_SESSION['e_online'])){echo $_SESSION['e_online']; unset($_SESSION['e_online']);}?></h2>
       <h2>Twój nick: <?php echo $_SESSION['nick']; ?></h2>
        <h2>Twoje $: <?php $money = getBills(); echo $money; ?></h2>
        <?php
            //ini_set("display_errors", 0);
            $polaczenie = new mysqli($host, $dbuser, $dbpass, $dbname);
            $sql = "SELECT * FROM uslugi";
            if(isset($_SESSION['popup'])){
                    echo '<div class="popup">Masz już wykupioną rangę! Jeśli wykupisz usługę, Twoja ranga zniknie, a pojawi się nowa. Mimo to chcesz kontunuować?<br /><br /><a href="kup.php?accept=true&id='.$_SESSION['id'].'"><button style="cursor: pointer;" class="btn btn-success">Kup mimo to</button></a>                             <a href="sklep?unset=true"><button style="cursor: pointer;" class="btn btn-danger">Wstrzymaj transakcję</button></a></div>';    
                    unset($_SESSION['popup']);
            }
                $divcounter = 5;
                for ($i = 0; $i <= $ile; $i++){
                    if($i == $ile){
                        echo '    </article>    
                         <footer>&copy; <a class="link" target="_blank" href="https://www.youtube.com/">&copy; JA</a>. Wszelkie prawa zastrzeżone.</footer>
                        </body>
                        </html>  '; exit();}
                    if($i%3 == 0){
                        echo '<div class="row">';
                        $divcounter = 1;
                    }
                    
                    echo '<div class="col-md-4 item">
                        <img width="300px" height="300px" src="'.$row['image'].'"><br />
                        <span style="font-size: 24px;">'.$row['name'].'</span><br />Cena: '.$row['price'].' $<br /><a href="kup?id='.$row['id'].'"><button style="cursor: pointer; border-radius: 30px;" class="btn btn-primary">Wykup</button></a>
                    </div>';
                    
                    if($divcounter == 3){
                        echo '</div>';
                    }
                    $divcounter++;
                    }                
            
        ?>
komentarz zamknięcia: Przepraszam, nie stworzyłem tabeli w mysql, a co do braku pytania to kapnąłem się przed edycją :D