In this post we are going to learn how to use Marquee tag with PHP and Mysql. Marquee tag is used to display scrolling text in up and down, right and left direction on web page. With the help of PHP programming language and Mysql database we can scrolling dynamic text in marquee tag. For stopping moving text we can write this code - onmouseover="this.stop();" and suppose friends If you want to again start moving text you can use this code - onmouseout="this.start();". You can also set the scrolling speed in attribute like scrollamout by entering number in this attribute. By using php and mysql we can easily fetch data from database table and display under marquee tag. Here we can display latest post or news by writing proper sql query. Implementation of this things is very easy and it is easy to understand.
Source Code
marquee.php
<?php
$connect = mysqli_connect("localhost", "root", "", "test_db");
$sql = "SELECT * FROM tbl_video ORDER BY video_id LIMIT 5";
$result = mysqli_query($connect, $sql);
?>
<html>
<head>
<meta name="viewport" content="initial-scale=1.0, user-scalable=no">
<meta charset="utf-8">
<title>Webslesson Tutorial</title>
<script src="jquery.js"></script>
<script src="js/bootstrap.js"></script>
<link href="css/bootstrap.css" rel="stylesheet" />
</head>
<body>
<div class="container" style="width:500px; border:1px solid #ccc;">
<br />
<marquee behavior="scroll" direction="up" onmouseover="this.stop();" onmouseout="this.start();">
<?php
if(mysqli_num_rows($result) > 0)
{
while($row = mysqli_fetch_array($result))
{
echo '<label><a href="'.$row['video_link'].'" target="_blank">'.$row['video_title'].'</a></label>';
}
}
?>
</marquee>
<br />
</div>
</body>
</html>
Are you robot?....the way you talk bro ...but thank for your nice tutolia
ReplyDeleteLovely tutorial, but I really would like it to have the lately published last five titles (headings) of the news. I am getting all the old ones only.
ReplyDeletecan you help me out?
ReplyDeleteOutput is not uploaded
ReplyDeletethank you
ReplyDelete