Bootstrap carousel e immagini da database MySql

[moncicci]

Ciao a tutti!

ho uno slideshow (carousel) in bootstrap con link alle immagini e dati statici; vorrei però caricare i vari dati da database.
Ho creato un codice php che da solo funziona ma che, inserito nel codice html, non mi visualizza niente.

Vi posto in primis il codice html senza php:

<div id="myCarousel" class="carousel slide carousel-fade">


    <ol class="carousel-indicators">
        <li data-target="#myCarousel" data-slide-to="0" class="" contenteditable="false"></li>
        <li data-target="#myCarousel" data-slide-to="1" class="active" contenteditable="false"></li>
        <li data-target="#myCarousel" data-slide-to="2" class="" contenteditable="false"></li>
        <li data-target="#myCarousel" data-slide-to="3" class="" contenteditable="false"></li>
        <li data-target="#myCarousel" data-slide-to="4" class="" contenteditable="false"></li>

    </ol>
<div class="carousel-inner">

        <div class="item" style="">
            <img src="images/slide/slide-1.jpg" alt="" class="">
            <div class="carousel-caption">
                <h4 class="">First Slide Title</h4>
                <p class="">
                   Description for First Slide, this First Slide.
                </p>
            </div>
        </div>

 <div class="item active">
            <img src="images/slide/slide-2.jpg" alt="" class="">
            <div class="carousel-caption">
                <h4 class="">Second Slide Title</h4>
<p class="">
                   Description for Second Slide, this is Second Slide.
                </p>
            </div>
        </div>


        <div class="item" style="">
            <img src="images/slide/slide-3.jpg" alt="" class="">
            <div class="carousel-caption">
                <h4 class="">Third Slide Title</h4>

                            <p class="">
                   Description for Third Slide, this is Third Slide.
                </p>
            </div>
        </div>


         <div class="item" style="">
            <img src="images/slide/slide-4.jpg" alt="" class="">
            <div class="carousel-caption">
                <h4 class="">Third Slide Title</h4>

                            <p class="">
                   Description for Third Slide, this is Third Slide.
                </p>
            </div>
        </div>


         <div class="item" style="">
            <img src="images/slide/slide-5.jpg" alt="" class="">
            <div class="carousel-caption">
                <h4 class="">Third Slide Title</h4>

                            <p class="">
                   Description for Third Slide, this is Third Slide.
                </p>
            </div>
        </div>


    </div> 


    <a class="left carousel-control" href="#myCarousel" data-slide="prev">
        <span class="glyphicon glyphicon-chevron-left"></span>
    </a>

    <a class="right carousel-control" href="#myCarousel" data-slide="next">
        <span class="glyphicon glyphicon-chevron-right"></span>
    </a>


</div>

Questo è il codice html + php integrato:

<divid="myCarousel"class="carousel slide carousel-fade">


    <olclass="carousel-indicators">
        <lidata-target="#myCarousel"data-slide-to="0"class=""contenteditable="false"></li>
        <lidata-target="#myCarousel"data-slide-to="1"class="active"contenteditable="false"></li>
        <lidata-target="#myCarousel"data-slide-to="2"class=""contenteditable="false"></li>
        <lidata-target="#myCarousel"data-slide-to="3"class=""contenteditable="false"></li>
        <lidata-target="#myCarousel"data-slide-to="4"class=""contenteditable="false"></li>

    </ol>



    <divclass="carousel-inner">


       <?php


$servername ="xxxxxxxxxxxx";
$username ="xxxxxxxxxxx";
$password ="xxxxxxxxxxxx";
$dbname ="xxxxxxxxxxx";

// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if(!$conn){
    die("Connection failed: ". mysqli_connect_error());
}

$sql ="SELECT id AS id, title AS title, imagename AS imagename, description AS description, status AS status FROM uploadslide ORDER BY id";

 $result = mysqli_query($conn, $sql);

 while($row = mysqli_fetch_assoc($result)){



?>

        <divclass="item"style="">
            <divclass="carousel-caption">
            <?php echo '<img src="uploads/slide/'.$row['imagename'].'" alt="" class="" /> '?>
                <h4class=""><?php echo $row['title']?></h4>
                <pclass="">
                   <?php echo $row['description']?>
                </p>
            </div>
        </div>

        <?php 

}
    mysqli_close($conn);

?>


    </div> 

    <aclass="left carousel-control"href="#myCarousel"data-slide="prev">
        <spanclass="glyphicon glyphicon-chevron-left"></span>
    </a>

    <aclass="right carousel-control"href="#myCarousel"data-slide="next">
        <spanclass="glyphicon glyphicon-chevron-right"></span>
    </a>


</div>

Grazie in anticipo a chi mi risponderà.

Buona giornata

[Alhazred]

Prima di tutto visualizza il codice della pagina, vedi se i percorsi inseriti nei vari src sono corretti.

P.S.
I vari AS li puoi togliere, non hanno senso se ci metti lo stesso nome che ha già il campo

$sql ="SELECT id AS id, title AS title, imagename AS imagename, description AS description, status AS status FROM uploadslide ORDER BY id";

// diventa
$sql ="SELECT id, title, imagename, description, status FROM uploadslide ORDER BY id"; 

[moncicci]

Ciao, ho fatto "Visualizza Sorgente" ed i percorsi sono giusti (se clicco sul link mi apre la foto correlata). Forse il problema ha a che fare con "item active"? Grazie

[moncicci]

Ho trovato la soluzione. Grazie lo stesso