nicnicnic
11-14-2008, 03:45 AM
hi all, im new here and im new to php javascript also
i would need a help
what i want to do is to put a image and text from database so it can be like a news
with a button play it show the next news
i have trouble to display the image like it show below
http://img219.imageshack.us/my.php?image=testjf6.jpg
PROBLEM WITH DIV position is resolve
<html>
<head>
<title>Bibliothèque</title>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
<script type="text/javascript">
var page_courante=1;
var nb_pages=1;
//Show previous page
function pagePrecedente() {
if (page_courante==1) {
alert("Vous êtes déjà sur la première page !");
} else {
affichePage(page_courante-1);
}
}
//show Next Page
function pageSuivante() {
if (page_courante==nbpages) {
alert("Vous êtes déjà sur la dernière page !");
} else {
affichePage(page_courante+1);
}
}
//show next page image text news and with a settimeout it change the news every 5 seconds
function play() {
if (page_courante==nbpages)
{
alert("Vous êtes déjà sur la dernière page !");
} else {
affichePage(page_courante+1);
}
setTimeout(play(),5000);
}
//Show Page Function
function affichePage (page){
document.getElementById("page"+page_courante).style.display = "none";
document.getElementById("lienpage"+page_courante).style.fontWeight = "normal";
document.getElementById("page"+page).style.display = "block";
document.getElementById("lienpage"+page).style.fontWeight = "bold";
page_courante=page;
}
</script>
</head>
<body>
<?php
//connect to the database
$connection = mysql_connect("localhost","root","") or die("impossible de se connecter au serveur mysql.<p>Veuillez réessayer plus tard");
$res = mysql_select_db("test") or die("impossible de sélectionner la base de données <b>ecole</b>.<p>Veuillez réessayer plus tard");
//request path textNouvelle Fields with a select
$requeteStr = "SELECT path,textNouvelle from upload2";
$resultatRequete = mysql_query($requeteStr) or die("la requete de sélection a échoué.<p>Veuillez réessayer plus tard");
$resultat=mysql_query($requeteStr);
$cpt = mysql_num_rows($resultat);//number of result from the request
$rpp = 1;//Nombre de résultats à afficher par page
$nbpages = ceil($cpt / $rpp);//calculate numbers of page
$cpt2 = 0;//limit the number of results per page
$cpt3 = 0;//tell us when all data has been view
$cpt4 = 1;//send an id for every div id=\"page".$cpt4."\"
for ($i=1; $i<=$nbpages; $i++) {
echo " <a href=\"#\" id=\"lienpage".$i."\"></a>";
}
//Show divs
while($ligne=mysql_fetch_array($resultat)){
if ($cpt2 == 0) {
if ($cpt4 == 1) //Lors de la requète, on affiche les premiers enregistrements
echo "<div id=\"page1\" style=\"display: inline;\">";
else //Ensuite, les enregistements suivants sont cachés
echo "<div id=\"page".$cpt4."\" style=\"display: none; position:absolute; top:100; left:140;\">";since the div contains the table i would like to put the div in a certain position on the page, but this aint working atm with the top left...
echo "<table border=\"1\"><tr><td><b>Titre</b></td></tr>";//affichage de la légende
$cpt4++;
}
$cpt2++;
$cpt3++;
echo "<tr><td>".$ligne["textNouvelle"]."<img src=".$ligne["path"]."></td></tr>";//Affichage des enregistrements]
if ($cpt2 == $rpp || $cpt3 == $cpt) {//Lorsque l'on affiché rpp enregistrements ou que tous les enregistrements ont été affichés, on ferme le calque
echo "</table></div>";
$cpt2 = 0;
}
}
?>
<button onClick="pagePrecedente()">Page précédente</button>
<button onClick="pageSuivante()">Page suivante</button>
<button onClick="play()">Play</button>
<script type="text/javascript">
var nbpages=<?php echo $nbpages;?>
</script>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
</body>
</html>
this is the table im working with
CREATE TABLE upload2 (
id INT NOT NULL AUTO_INCREMENT,
name VARCHAR(30) NOT NULL,
type VARCHAR(30) NOT NULL,
size INT NOT NULL,
path VARCHAR(60) NOT NULL,
textNouvelle VARCHAR(120) NOT NULL,
PRIMARY KEY(id)
);
http://img219.imageshack.us/my.php?image=imagescv5.jpg
the path in the database is all fine
so i dunno why the image aint showing right
ty for the help in advance hope someone will help me out
p.s. i know my english aint the best lol so if im not clear let me know so we can discuss about it
i would need a help
what i want to do is to put a image and text from database so it can be like a news
with a button play it show the next news
i have trouble to display the image like it show below
http://img219.imageshack.us/my.php?image=testjf6.jpg
PROBLEM WITH DIV position is resolve
<html>
<head>
<title>Bibliothèque</title>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
<script type="text/javascript">
var page_courante=1;
var nb_pages=1;
//Show previous page
function pagePrecedente() {
if (page_courante==1) {
alert("Vous êtes déjà sur la première page !");
} else {
affichePage(page_courante-1);
}
}
//show Next Page
function pageSuivante() {
if (page_courante==nbpages) {
alert("Vous êtes déjà sur la dernière page !");
} else {
affichePage(page_courante+1);
}
}
//show next page image text news and with a settimeout it change the news every 5 seconds
function play() {
if (page_courante==nbpages)
{
alert("Vous êtes déjà sur la dernière page !");
} else {
affichePage(page_courante+1);
}
setTimeout(play(),5000);
}
//Show Page Function
function affichePage (page){
document.getElementById("page"+page_courante).style.display = "none";
document.getElementById("lienpage"+page_courante).style.fontWeight = "normal";
document.getElementById("page"+page).style.display = "block";
document.getElementById("lienpage"+page).style.fontWeight = "bold";
page_courante=page;
}
</script>
</head>
<body>
<?php
//connect to the database
$connection = mysql_connect("localhost","root","") or die("impossible de se connecter au serveur mysql.<p>Veuillez réessayer plus tard");
$res = mysql_select_db("test") or die("impossible de sélectionner la base de données <b>ecole</b>.<p>Veuillez réessayer plus tard");
//request path textNouvelle Fields with a select
$requeteStr = "SELECT path,textNouvelle from upload2";
$resultatRequete = mysql_query($requeteStr) or die("la requete de sélection a échoué.<p>Veuillez réessayer plus tard");
$resultat=mysql_query($requeteStr);
$cpt = mysql_num_rows($resultat);//number of result from the request
$rpp = 1;//Nombre de résultats à afficher par page
$nbpages = ceil($cpt / $rpp);//calculate numbers of page
$cpt2 = 0;//limit the number of results per page
$cpt3 = 0;//tell us when all data has been view
$cpt4 = 1;//send an id for every div id=\"page".$cpt4."\"
for ($i=1; $i<=$nbpages; $i++) {
echo " <a href=\"#\" id=\"lienpage".$i."\"></a>";
}
//Show divs
while($ligne=mysql_fetch_array($resultat)){
if ($cpt2 == 0) {
if ($cpt4 == 1) //Lors de la requète, on affiche les premiers enregistrements
echo "<div id=\"page1\" style=\"display: inline;\">";
else //Ensuite, les enregistements suivants sont cachés
echo "<div id=\"page".$cpt4."\" style=\"display: none; position:absolute; top:100; left:140;\">";since the div contains the table i would like to put the div in a certain position on the page, but this aint working atm with the top left...
echo "<table border=\"1\"><tr><td><b>Titre</b></td></tr>";//affichage de la légende
$cpt4++;
}
$cpt2++;
$cpt3++;
echo "<tr><td>".$ligne["textNouvelle"]."<img src=".$ligne["path"]."></td></tr>";//Affichage des enregistrements]
if ($cpt2 == $rpp || $cpt3 == $cpt) {//Lorsque l'on affiché rpp enregistrements ou que tous les enregistrements ont été affichés, on ferme le calque
echo "</table></div>";
$cpt2 = 0;
}
}
?>
<button onClick="pagePrecedente()">Page précédente</button>
<button onClick="pageSuivante()">Page suivante</button>
<button onClick="play()">Play</button>
<script type="text/javascript">
var nbpages=<?php echo $nbpages;?>
</script>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
</body>
</html>
this is the table im working with
CREATE TABLE upload2 (
id INT NOT NULL AUTO_INCREMENT,
name VARCHAR(30) NOT NULL,
type VARCHAR(30) NOT NULL,
size INT NOT NULL,
path VARCHAR(60) NOT NULL,
textNouvelle VARCHAR(120) NOT NULL,
PRIMARY KEY(id)
);
http://img219.imageshack.us/my.php?image=imagescv5.jpg
the path in the database is all fine
so i dunno why the image aint showing right
ty for the help in advance hope someone will help me out
p.s. i know my english aint the best lol so if im not clear let me know so we can discuss about it