View database data from

Question

I have a bunch of data with information from various bands, however I would like to pull them to my front page.

bank name: dados

Call table : Artists

where I have the information :

• imagem_small ( in this case use url stored of band images )
• Name - band name
• spotify_popularity - band popularity

The idea would be to show the image above and the artist’s name below in a column with 7 artists and that only bands with popularity below 20 appear in the random column.

would look like this site http://pipocaplayfm.com/site/

That code is what I’m using to pull the content. localhost I am using, so do not have password the database.

I want to know if there is something wrong or I have to put something else ... since the code does not work.

ps. I copied exactly like this one .

 $servername = "localhost";
    $username = "root";
    $password = "";
    $dbname = "dados";
    //conexão ao banco de dados
    $conn = new mysqli($servername, $username, $password, $dbname);
    //consulta a tabela Artistas onde spotify_popularity é menor que 20 no total de 7 registros
    $consulta = "SELECT * FROM artists WHERE spotify_popularity < 20 limit 7";

    $result = $conn->query($consulta);

    $i=1;
    echo '<div id="container">';

    while($dados = $result->fetch_array()){
        echo "<div id='box-".$i."' class='box'>";
        echo "<img src=". $dados["imagem_small"]. ">";
        echo "<br>";
        echo "<span>". $dados["Name"]. "</span>"; 
        echo "</div>";
        $i++;
    }

    echo '</div>';

Answer 1

What is right is you provide a code to help us help you. But follow an example basico how to do.

<?php
    try {
       $pdo = new PDO('mysql:host=localhost;dbname= dados', 
       'root', '');
       $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    } catch(PDOException $e) {
       echo 'ERROR: ' . $e->getMessage();
    }

    $sql = $pdo->prepare("SELECT * FROM Artists");
    $sql->execute();

    while($ln = $sql->fetchObject()){
       echo '<h1>'.$ln->Name.'</h1>';
       echo '<img src="'.$ln->imagem_small.'">';

    }

With this, you will already display the band name and image, and can change the code to suit you better.

Answer 2

CSS:

• Centralizes the div container with a width of 100%.
• Features the Divs class box side by side with 10px margin

CSS

<style>
    #container {
       width: 100%;
       text-align: center;
    }

    .box {
      display: inline-block;
      margin: 10px 10px;
    }
</style>

PHP

PHP: with Mysqli

<?php

    $imagem_small="";
    $Name="";

    $servername = "localhost";
    $username = "USUARIO";
    $password = "SENHA";
    $dbname = "NOME_DB";
    //conexão ao banco de dados
    $conn = new mysqli($servername, $username, $password, $dbname);
    //consulta a tabela Artistas onde spotify_popularity é menor que 20 no total de 7 registros
    $consulta = "SELECT * FROM artists WHERE spotify_popularity < 20 limit 7";

    $result = $conn->query($consulta);

    $i=1;
    echo '<div id="container">';

    while($dados = $result->fetch_array()){
        echo "<div id='box-".$i."' class='box'>";
        echo "<img src=". $dados["imagem_small"]. ">";
        echo "<br>";
        echo "<span>". $dados["Name"]. "</span>"; 
        echo "</div>";
        $i++;
    }

    echo '</div>';
?>

The name of the table is not Artists as stated in the question and yes artists as set out in https://snag.gy/6eBbAK.jpg