|
 |
| |
ถามเรื่องดึงข้อมูล จาก ฐานข้อมูลมาใส่ Featured content slider |
| |
 |
|
|
 |
 |
|
ผมไปเอามาจาก http://webdeveloperplus.com/jquery/featured-content-slider-using-jquery-ui/
อยากจะดึงข้อมูลจากฐานข้อมูลครับ
โดย ในฐานข้อมูลประกอบด้วย
Title_news
Detail_news
Pic_news
ไม่ทราบว่าต้องวนลูปเพื่อดึงข้อมูลมาใส่ยังงัยครับ
นี่โค๊ดต้นฉบับที่ไปโหลดมาครับ
Code
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" dir="ltr">
<head profile="http://gmpg.org/xfn/11">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Featured Content Slider Using jQuery - Web Developer Plus Demos</title>
<link rel="stylesheet" type="text/css" href="style.css" />
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js" ></script>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jqueryui/1.5.3/jquery-ui.min.js" ></script>
<script type="text/javascript">
$(document).ready(function(){
$("#featured > ul").tabs({fx:{opacity: "toggle"}}).tabs("rotate", 5000, true);
});
</script>
</head>
<body>
<h3>» Featured Content Slider Using jQuery</h3>
<div id="featured" >
<ul class="ui-tabs-nav">
<li class="ui-tabs-nav-item ui-tabs-selected" id="nav-fragment-1"><a href="#fragment-1"><img src="images/image1-small.jpg" alt="" /><span>15+ Excellent High Speed Photographs</span></a></li>
<li class="ui-tabs-nav-item" id="nav-fragment-2"><a href="#fragment-2"><img src="images/image2-small.jpg" alt="" /><span>20 Beautiful Long Exposure Photographs</span></a></li>
<li class="ui-tabs-nav-item" id="nav-fragment-3"><a href="#fragment-3"><img src="images/image3-small.jpg" alt="" /><span>35 Amazing Logo Designs</span></a></li>
<li class="ui-tabs-nav-item" id="nav-fragment-4"><a href="#fragment-4"><img src="images/image4-small.jpg" alt="" /><span>Create a Vintage Photograph in Photoshop</span></a></li>
</ul>
<!-- First Content -->
<div id="fragment-1" class="ui-tabs-panel" style="">
<img src="images/image1.jpg" alt="" />
<div class="info" >
<h2><a href="#" >15+ Excellent High Speed Photographs</a></h2>
<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nulla tincidunt condimentum lacus. Pellentesque ut diam....<a href="#" >read more</a></p>
</div>
</div>
<!-- Second Content -->
<div id="fragment-2" class="ui-tabs-panel ui-tabs-hide" style="">
<img src="images/image2.jpg" alt="" />
<div class="info" >
<h2><a href="#" >20 Beautiful Long Exposure Photographs</a></h2>
<p>Vestibulum leo quam, accumsan nec porttitor a, euismod ac tortor. Sed ipsum lorem, sagittis non egestas id, suscipit....<a href="#" >read more</a></p>
</div>
</div>
<!-- Third Content -->
<div id="fragment-3" class="ui-tabs-panel ui-tabs-hide" style="">
<img src="images/image3.jpg" alt="" />
<div class="info" >
<h2><a href="#" >35 Amazing Logo Designs</a></h2>
<p>liquam erat volutpat. Proin id volutpat nisi. Nulla facilisi. Curabitur facilisis sollicitudin ornare....<a href="#" >read more</a></p>
</div>
</div>
<!-- Fourth Content -->
<div id="fragment-4" class="ui-tabs-panel ui-tabs-hide" style="">
<img src="images/image4.jpg" alt="" />
<div class="info" >
<h2><a href="#" >Create a Vintage Photograph in Photoshop</a></h2>
<p>Quisque sed orci ut lacus viverra interdum ornare sed est. Donec porta, erat eu pretium luctus, leo augue sodales....<a href="#" >read more</a></p>
</div>
</div>
</div>
</div>
</body>
</html>
Tag : PHP, MySQL
|
|
|
 |
 |
 |
 |
| Date :
2011-09-16 16:10:34 |
By :
silmido |
View :
986 |
Reply :
4 |
|
 |
 |
 |
 |
|
|
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
ไม่มีคนตอบเลย แนะนำวิธีอื่นก็ได้นะครับ
|
| |
|
|
| |
| Date :
2011-09-16 21:10:53 |
By :
silmido |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
งงคำถามครับ
ต้องการจะลูปอะไร
และดึงข้อมูล จากไหน ไปใส่ตรงไหนครับ
|
| |
|
|
| |
| Date :
2011-09-16 21:32:15 |
By :
adaaugusta |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
ดึงจาก ฐานข้อมูลครับ mysql
|
| |
|
|
| |
| Date :
2011-09-16 21:35:53 |
By :
silmido |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
จัดให้ พยายามคิดดัดแปลงให้เป็นครับ
Code (PHP)
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" dir="ltr">
<head profile="http://gmpg.org/xfn/11">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Featured Content Slider Using jQuery - Web Developer Plus Demos</title>
<link rel="stylesheet" type="text/css" href="style.css" />
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js" ></script>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jqueryui/1.5.3/jquery-ui.min.js" ></script>
<script type="text/javascript">
$(document).ready(function(){
$("#featured > ul").tabs({fx:{opacity: "toggle"}}).tabs("rotate", 5000, true);
});
</script>
</head>
<body>
<h3>» Featured Content Slider Using jQuery</h3>
<div id="featured" >
<ul class="ui-tabs-nav">
<?php
ตรงนี้ query เอาเอง
$i=0;
while($rows = mysql_fetch_assoc($result)){
++$i;
$selected = ($i>1)? '':'ui-tabs-selected';
?>
<li class="ui-tabs-nav-item <?php echo $selected; ?>" id="nav-fragment-<?php echo $i?>"><a href="#fragment-<?php echo $i?>"><img src="images/<?php echo $rows['Pic_news']; //จริงๆ ควรจะมี thumbnail อีกฟิลด์นึงนะ ?>" alt="" /><span><?php echo $rows['Title_news']; ?></span></a></li>
<?php
}
?>
</ul>
<!-- First Content -->
<?php
ตรงนี้ query เอาเอง
$i=0;
while($rows = mysql_fetch_assoc($result)){
++$i;
?>
<div id="fragment-<?php echo $i?>" class="ui-tabs-panel" style="">
<img src="images/<?php echo $rows['Pic_news'];?>" alt="" />
<div class="info" >
<h2><a href="#" ><?php echo $rows['Title_news']; ?></a></h2>
<p><?php echo $rows['Detail_news']; ?></p>
</div>
</div>
<?php
}
?>
</div>
</div>
</body>
</html>
|
| |
|
|
| |
| Date :
2011-09-17 01:40:55 |
By :
ikikkok |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
| |
|
 Load balance : Server 01
|
