Today we will see how to create dynamic Slider in Bootstrap 4.
The dynamic slider of Bootstrap 4 is very useful, we can use it according to the requirements of the users and it is used a lot in dynamic website.
Table of Contents
Step 1: Create New Database and Table
Database name is abcd
— Database Name: abcd
— Table Name: slider
CREATE TABLE `slider` (
`slider_id` int(11) NOT NULL,
`slider_image` longtext NOT NULL,
`slider_title` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
Step 2: Create config.php File.
<?php
// Enter your Host, username, password, database below.
// I left password empty because i do not set password on localhost.
$connect=mysqli_connect('localhost','root','','abcd') or die("connection failed : ".mysqli_connect_error());
if ($connect) {
//echo "Connection Successfully";
}
else{
echo "Sorry Some Mistakes is";
}
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
?>Step 3: Create index.php File.
First add bootstrap 4 online CDN link ( js,css ).
<?php
include 'config.php';
function make_query($connect)
{
$query = "SELECT * FROM slider ORDER BY slider_id ASC";
$result = mysqli_query($connect, $query);
return $result;
}
function make_slide_indicators($connect)
{
$output = '';
$count = 0;
$result = make_query($connect);
while($row = mysqli_fetch_array($result))
{
if($count == 0)
{
$output .= '
<li data-target="#carouselExampleIndicators" data-slide-to="'.$count.'" class="active"></li>
';
}
else
{
$output .= '
<li data-target="#carouselExampleIndicators" data-slide-to="'.$count.'"></li>
';
}
$count = $count + 1;
}
return $output;
}
function make_slides($connect)
{
$output = '';
$count = 0;
$result = make_query($connect);
while($row = mysqli_fetch_array($result))
{
if($count == 0)
{
$output .= '<div class="carousel-item active">';
}
else
{
$output .= '<div class="carousel-item">';
}
$output .= '
<img src="'.$row["slider_image"].'" alt="'.$row["slider_title"].'" />
<div class="carousel-caption">
<h3>'.$row["slider_title"].'</h3>
</div>
</div>
';
$count = $count + 1;
}
return $output;
}
?>
<html lang="en">
<head>
<title>home</title>
<!-- Required meta tags -->
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css" integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm" 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.9/umd/popper.min.js" integrity="sha384-ApNbgh9B+Y1QKtv3Rn7W3mgPxhU9K/ScQsAP7hUibX39j7fakFPskvXusvfa0b4Q" crossorigin="anonymous"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/js/bootstrap.min.js" integrity="sha384-JZR6Spejh4U02d8jOt6vLEHfe/JQGiRRSQQxSfFWpi1MquVdAyjUar5+76PVCmYl" crossorigin="anonymous"></script>
</head>
<style type="text/css">
</style>
<body>
<div id="carouselExampleIndicators" class="carousel slide" data-ride="carousel">
<ol class="carousel-indicators">
<?php echo make_slide_indicators($connect); ?>
</ol>
<div class="carousel-inner">
<?php echo make_slides($connect); ?>
</div>
<a class="carousel-control-prev" href="#carouselExampleIndicators" role="button" data-slide="prev">
<span class="carousel-control-prev-icon" aria-hidden="true"></span>
<span class="sr-only">Previous</span>
</a>
<a class="carousel-control-next" href="#carouselExampleIndicators" role="button" data-slide="next">
<span class="carousel-control-next-icon" aria-hidden="true"></span>
<span class="sr-only">Next</span>
</a>
</div>
</body>
</html>Step 4: Create new Folder
Create a new folder named images which will upload the slider image o will store in this folder.
