não consigo colocar o slideshow no meu site
Bom galera, não consigo colocar o slideshow no meu site,
e tbm não consigo puxar o o titulo da noticia no banco de dados,
Me ajudem" por favor preciso disso pra hj '-'
vou disponibilizar os codigos
pagina header
<?php require_once "configuration.php"; ?>
<!DOCTYPE html>
<html lang="py-br">
<head>
<meta charset="utf-8" />
<title>Esportes Geral</title>
<link rel="stylesheet" type="text/css" href="css/default.css" media="screen" />
<script src="js/jquery-2.1.4.js" type="text/javascript"></script>
<script type="text/javascript" src="js/bjqs-1.3.js"></script>
<script type="text/javascript">
jQuery(document).ready(function($) {
$('#banner-fade').bjqs({
height : 270,
width : 690,
responsive : true
});
});
</script>
<link href="../css/bjqs.css" rel="stylesheet" type="text/css"/>
<link href="../css/demo.css" rel="stylesheet" type="text/css"/>
</head>
<body>
<header>
<div id="topo">
<div id="logo">
<a href="index.php">
<img src="imagens/Logo.png" alt="Esportes Geral Logo" />
</a>
</div>
<div id="topo-right">
<p>Olá, Seja Bem Vindo <a href="paineldecontrole/index.php">Faça login</a> </p>
<form action="busca.php" method="GET">
<input type="text" name="busca-organica" id="busca-organica" />
<p><embed quality="high" src="http://www.cryd.com.br/relogios-feitos-em-flash/swf/01-10/481.swf" type="application/x-shockwave-flash" width="300" height="20" wmode="transparent"></embed></p>
</form>
</div>
</div>
</header>
<div id="menu">
<nav>
<ul id="menu-screen">
<li>Categorias do site
<ul>
<?php
$SQL = mysql_query("SELECT * FROM categoria");
while($ln = mysql_fetch_assoc($SQL)){
?>
<li><a href="categoria.php?id=<?php echo $ln["id_categoria"]; ?>"><?php echo $ln["nome_categoria"]; ?></a></li>
<?php } ?>
</ul>
</li>
<li>Publicidade</li>
<li>Quem somos</li>
<li>Parceiros</li>
<li>atendimento</li>
</ul>
</nav>
</div>
e essa pag é onde vou puxar as minhas imagens que é a Index:
<?php require_once 'includes/header.php';?>
<main>
<section id="content">
<section id="conteudo">
<section id="publicidade-conteudo"></section> <!--publicidade conteudo --->
<section id="slider" class="bjqs">
<ul class="bjqs">
<?php
$SQL_B = mysql_query("SELECT id_noticia, titulo, imagem, status FROM noticias WHERE status=1 ORDER BY id_noticia DESC LIMIT 5");
while($bn = mysql_fetch_array($SQL_B)){
?>
<li><a href="noticia.php?id=<?php echo $bn['id_noticia']; ?>"><img src="paineldecontrole/imagens/imgnoticia/<?php echo $bn['imagem']?>" title="<?php echo $bn['titulo'] ?>"></a></li>
<?php } ?>
</ul>
</section> <!--Banner-->
<section id="artigos">
<?php
$SQL_F = mysql_query("SELECT * FROM categoria WHERE nome_categoria='Vitoria'");
while($ft = mysql_fetch_array($SQL_F)){
$id_ft = $ft['id_categoria'];
}
$SQL_FN = mysql_query("SELECT * FROM noticias WHERE categoria='$id_ft' ORDER BY id_noticia DESC LIMIT 1");
while($ftn = mysql_fetch_array($SQL_FN)){
?>
<article>
<h1><a href="categoria.php?id=<?php echo $id_ft; ?>">Vitória</a></h1>
<img src="paineldecontrole/imagens/imgnoticia/<?php echo $ftn['imagem'];?>" alt="<?php echo $ftn['titulo']; ?>" />
<h2><a href="noticia.php?id=<?php echo $ftn['id_noticia']; ?>"><?php echo $ftn['titulo']; ?></a></h2>
<?php } ?>
</article>
<?php
$SQL_F = mysql_query("SELECT * FROM categoria WHERE nome_categoria='Bahia'");
while($ft = mysql_fetch_array($SQL_F)){
$id_ft = $ft['id_categoria'];
}
$SQL_FN = mysql_query("SELECT * FROM noticias WHERE categoria='$id_ft' ORDER BY id_noticia DESC LIMIT 1");
while($ftn = mysql_fetch_array($SQL_FN)){
?>
<article>
<h1><a href="categoria.php?id=<?php echo $id_ft; ?>">Bahia</a></h1>
<img src="paineldecontrole/imagens/imgnoticia/<?php echo $ftn['imagem'];?>" alt="<?php echo $ftn['titulo']; ?>" />
<h2><a href="noticia.php?id=<?php echo $ftn['id_noticia']; ?>"><?php echo $ftn['titulo']; ?></a></h2>
</article>
<?php } ?>
<?php
$SQL_F = mysql_query("SELECT * FROM categoria WHERE nome_categoria='Brasileirão Serie A'");
while($ft = mysql_fetch_array($SQL_F)){
$id_ft = $ft['id_categoria'];
}
$SQL_FN = mysql_query("SELECT * FROM noticias WHERE categoria='$id_ft' ORDER BY id_noticia DESC LIMIT 1");
while($ftn = mysql_fetch_array($SQL_FN)){
?>
<article>
<h1><a href="categoria.php?id=<?php echo $id_ft; ?>">Brasileirão Serie A</a></h1>
<img src="paineldecontrole/imagens/imgnoticia/<?php echo $ftn['imagem'];?>" alt="<?php echo $ftn['titulo']; ?>" />
<h2><a href="noticia.php?id=<?php echo $ftn['id_noticia']; ?>"><?php echo $ftn['titulo']; ?></a></h2>
</article>
<?php } ?>
<?php
$SQL_F = mysql_query("SELECT * FROM categoria WHERE nome_categoria='Esporte de Camaçari'");
while($ft = mysql_fetch_array($SQL_F)){
$id_ft = $ft['id_categoria'];
}
$SQL_FN = mysql_query("SELECT * FROM noticias WHERE categoria='$id_ft' ORDER BY id_noticia DESC LIMIT 1");
while($ftn = mysql_fetch_array($SQL_FN)){
?>
<article>
<h1><a href="categoria.php?id=<?php echo $id_ft; ?>">Esporte de Camaçari</a></h1>
<img src="paineldecontrole/imagens/imgnoticia/<?php echo $ftn['imagem'];?>" alt="<?php echo $ftn['titulo']; ?>" />
<h2><a href="noticia.php?id=<?php echo $ftn['id_noticia']; ?>"><?php echo $ftn['titulo']; ?></a></h2>
</article>
<?php } ?>
<?php
$SQL_F = mysql_query("SELECT * FROM categoria WHERE nome_categoria='Brasileirão Serie B'");
while($ft = mysql_fetch_array($SQL_F)){
$id_ft = $ft['id_categoria'];
}
$SQL_FN = mysql_query("SELECT * FROM noticias WHERE categoria='$id_ft' ORDER BY id_noticia DESC LIMIT 1");
while($ftn = mysql_fetch_array($SQL_FN)){
?>
<article>
<h1><a href="categoria.php?id=<?php echo $id_ft; ?>">Brasileirão Serie B</a></h1>
<img src="paineldecontrole/imagens/imgnoticia/<?php echo $ftn['imagem'];?>" alt="<?php echo $ftn['titulo']; ?>" />
<h2><a href="noticia.php?id=<?php echo $ftn['id_noticia']; ?>"><?php echo $ftn['titulo']; ?></a></h2>
</article>
<?php } ?>
<?php
$SQL_F = mysql_query("SELECT * FROM categoria WHERE nome_categoria='Seleção Brasileira'");
while($ft = mysql_fetch_array($SQL_F)){
$id_ft = $ft['id_categoria'];
}
$SQL_FN = mysql_query("SELECT * FROM noticias WHERE categoria='$id_ft' ORDER BY id_noticia DESC LIMIT 1");
while($ftn = mysql_fetch_array($SQL_FN)){
?>
<article>
<h1><a href="categoria.php?id=<?php echo $id_ft; ?>">Seleção Brasileira</a></h1>
<img src="paineldecontrole/imagens/imgnoticia/<?php echo $ftn['imagem'];?>" alt="<?php echo $ftn['titulo']; ?>" />
<h2><a href="noticia.php?id=<?php echo $ftn['id_noticia']; ?>"><?php echo $ftn['titulo']; ?></a></h2>
</article>
<?php } ?>
</section> <!--Artigos -->
</section> <!-- conteúdo -->
<section id="sidebar"><?php require_once 'includes/sidebar.php'; ?></section>
</section> <!--content -->
</main>
<footer>
<div id="center-ft">
<img id="logo2" src="imagens/Logo.png" alt="Esportes Geral" />
<p> Todos os direitos reservados - Esportes Geral 2015. </p>
</div>
</footer>
</body>
</html>
Pagina de exemplo do Plugin: pra vc's terem uma ideia:
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Basic jQuery Slider - Demo</title>
<!-- bjqs.css contains the *essential* css needed for the slider to work -->
<link rel="stylesheet" href="bjqs.css">
<!-- some pretty fonts for this demo page - not required for the slider -->
<link href='[http://fonts.googleapis.com/css?family=Source+Code+Pro|Open+Sans:300'](http://fonts.googleapis.com/css?family=Source+Code+Pro%7COpen+Sans:300) rel='stylesheet' type='text/css'>
<!-- demo.css contains additional styles used to set up this demo page - not required for the slider -->
<link rel="stylesheet" href="demo.css">
<!-- load jQuery and the plugin -->
<script src="http://code.jquery.com/jquery-1.7.1.min.js"></script>
<script src="js/bjqs-1.3.min.js"></script>
</head>
<body>
<div id="container">
<h2>Fade Example</h2>
<!-- Outer wrapper for presentation only, this can be anything you like -->
<div id="banner-fade">
<!-- start Basic Jquery Slider -->
<ul class="bjqs">
<li><img src="img/banner01.jpg" title="Automatically generated caption"></li>
<li><img src="img/banner02.jpg" title="Automatically generated caption"></li>
<li><img src="img/banner03.jpg" title="Automatically generated caption"></li>
</ul>
<!-- end Basic jQuery Slider -->
</div>
<!-- End outer wrapper -->
<script class="secret-source">
jQuery(document).ready(function($) {
$('#banner-fade').bjqs({
height : 320,
width : 620,
responsive : true
});
});
</script>
</body>
</html>Discussão (3)
Carregando comentários...