Slideshow

[Tursiops]

Hi everybody!

I am trying to make a slideshow with 2 pics, one moves the central pic forward and one backward.
When I am in the first central pic and I click on the backward pic I want the last central pic to appear.
And when I am on the last central pic and I click on the forward pic I want the first central pic to appear.

My first problem is that I don't see how to make a forward or backward request on my MySql database with PHP.

If you want to see better, there is a javascript only exemple on my website at www.t-d-e.org

Thanks for your help!

[TTT]

you have some id for those pics ?!

so here is few function that should help you:

function ArrayToList($inArray, $inDelim = ",") {
$outList = join($inDelim, $inArray);
return $outList;
}

function ListAppend($inList, $inValue, $inDelim = ",") {
$aryList = _listFuncs_PrepListAsArray($inList, $inDelim);
array_push($aryList, $inValue);
$outList = join($inDelim, $aryList);
return $outList;
}

function ListChangeDelims($inList, $inNewDelim, $inDelim = ",") {
$aryList = _listFuncs_PrepListAsArray($inList, $inDelim);
$outList = join($inNewDelim, $aryList);
return $outList;
}

function ListContains($inList, $inSubstr, $inDelim = ",") {
$aryList = _listFuncs_PrepListAsArray($inList, $inDelim);
$outIndex = 0;
$intCounter = 0;
foreach($aryList as $item) {
$intCounter++;
if(preg_match("/" . preg_quote($inSubstr) . "/", $item)) {
$outIndex = $intCounter;
break;
}
}
return $outIndex;
}

function ListContainsNoCase($inList, $inSubstr, $inDelim = ",") {
$aryList = _listFuncs_PrepListAsArray($inList, $inDelim);
$outIndex = 0;
$intCounter = 0;
foreach($aryList as $item) {
$intCounter++;
if(preg_match("/" . preg_quote($inSubstr) . "/i", $item)) {
$outIndex = $intCounter;
break;
}
}
return $outIndex;
}

function ListDeleteAt($inList, $inPosition, $inDelim = ",") {
$aryList = _listFuncs_PrepListAsArray($inList, $inDelim);
array_splice($aryList, $inPosition-1, 1);
$outList = join($inDelim, $aryList);
return $outList;
}

function ListFind($inList, $inSubstr, $inDelim = ",") {
$aryList = _listFuncs_PrepListAsArray($inList, $inDelim);
$outIndex = 0;
$intCounter = 0;
foreach($aryList as $item) {
$intCounter++;
if(preg_match("/^" . preg_quote($inSubstr, "/") . "$/", $item)) {
$outIndex = $intCounter;
break;
}
}
return $outIndex;
}

function ListFindNoCase($inList, $inSubstr, $inDelim = ",") {
$aryList = _listFuncs_PrepListAsArray($inList, $inDelim);
$outIndex = 0;
$intCounter = 0;
foreach($aryList as $item) {
$intCounter++;
if(preg_match("/^" . preg_quote($inSubstr, "/") . "$/i", $item)) {
$outIndex = $intCounter;
break;
}
}
return $outIndex;
}

function ListFirst($inList, $inDelim = ",") {
$aryList = _listFuncs_PrepListAsArray($inList, $inDelim);
$outItem = array_shift($aryList);
return $outItem;
}

function ListGetAt($inList, $inPosition, $inDelim = ",") {
$aryList = _listFuncs_PrepListAsArray($inList, $inDelim);
$outItem = $aryList[$inPosition-1];
return $outItem;
}

function ListInsertAt($inList, $inPosition, $inValue, $inDelim = ",") {
$aryList = _listFuncs_PrepListAsArray($inList, $inDelim);
if($inPosition < 1){ $inPosition = 1; }
array_splice($aryList, $inPosition-1, 0, $inValue);
$outList = join($inDelim, $aryList);
return $outList;
}

function ListLast($inList, $inDelim = ",") {
$aryList = _listFuncs_PrepListAsArray($inList, $inDelim);
$outItem = array_pop($aryList);
return $outItem;
}

function ListLen($inList, $inDelim = ",") {
$aryList = _listFuncs_PrepListAsArray($inList, $inDelim);
$outInt = (strlen($inList)>0)?count($aryList):0;
return $outInt;
}

function ListPrepend($inList, $inValue, $inDelim = ",") {
$aryList = _listFuncs_PrepListAsArray($inList, $inDelim);
array_unshift($aryList, $inValue);
$outList = join($inDelim, $aryList);
return $outList;
}

function ListQualify($inList, $inQualifier, $inDelim = ",") {
$inCharAll = (func_num_args() == 4)?func_get_arg(3):"ALL";
$aryList = _listFuncs_PrepListAsArray($inList, $inDelim);
$intCounter = 0;
foreach($aryList as $item) {
if(strtoupper($inCharAll) == "ALL" || (strtoupper($inCharAll) == "CHAR" && preg_match("/\D/", $item))) {
$aryList[$intCounter] = $inQualifier . $item . $inQualifier;
}
$intCounter++;
}
$outList = join($inDelim, $aryList);
return $outList;
}

function ListRest($inList, $inDelim = ",") {
$aryList = _listFuncs_PrepListAsArray($inList, $inDelim);
array_shift($aryList);
$outList = join($inDelim, $aryList);
return $outList;
}

function ListSetAt($inList, $inPosition, $inValue, $inDelim = ",") {
$aryList = _listFuncs_PrepListAsArray($inList, $inDelim);
$aryList[$inPosition-1] = $inValue;
$outList = join($inDelim, $aryList);
return $outList;
}

function ListSort($inList, $inSortType, $inSortOrder = "ASC") {
//a bit buggy yet...
$inDelim = (func_num_args() == 4)?func_get_arg(3):",";
$aryList = _listFuncs_PrepListAsArray($inList, $inDelim);
if(strtoupper($inSortType) == "NUMERIC") {
sort($aryList, "SORT_NUMERIC");
} elseif(strtoupper($inSortType) == "TEXT") {
sort($aryList, "SORT_REGULAR");
} elseif(strtoupper($inSortType) == "TEXTNOCASE") {
sort($aryList, "SORT_STRING");
}
if(strtoupper($inSortOrder) == "DESC") {
array_reverse($aryList);
}
$outList = join($inDelim, $aryList);
return $outList;
}

function ListToArray($inList, $inDelim = ",") {
$outArray = _listFuncs_PrepListAsArray($inList, $inDelim);
return $outArray;
}

function ListValueCount($inList, $inValue, $inDelim = ",") {
$aryList = _listFuncs_PrepListAsArray($inList, $inDelim);
$outInt = 0;
foreach($aryList as $item) {
if($item == $inValue){ $outInt++; }
}
return $outInt;
}

function ListValueCountNoCase($inList, $inValue, $inDelim = ",") {
$aryList = _listFuncs_PrepListAsArray($inList, $inDelim);
$outInt = 0;
foreach($aryList as $item) {
if(strtolower($item) == strtolower($inValue)){ $outInt++; }
}
return $outInt;
}

//private function
function listFuncs_PrepListAsArray($inList, $inDelim) {
$inList = trim($inList);
$inList = preg_replace("/^" . preg_quote($inDelim, "/") . "+/", "", $inList);
$inList = preg_replace("/" . preg_quote($inDelim, "/") . "+$/", "", $inList);
$outArray = preg_split("/" . preg_quote($inDelim, "/") . "+/", $inList);
if(count($outArray) == 1 && $outArray[0] == "") {
$outArray = array();
}
return $outArray;
}
//private function
function listFuncs_PrepListAsList($inList, $inDelim) {
$inList = trim($inList);
$inList = preg_replace("/^" . preg_quote($inDelim, "/") . "+/", "", $inList);
$inList = preg_replace("/" . preg_quote($inDelim, "/") . "+$/", "", $inList);
$outList = preg_replace("/" . preg_quote($inDelim, "/") . "+/", $inDelim, $inList);
return $outList;
}

[Tursiops]

There is my PHP/Mysql code:
The biggest problem now is that I don't know how to call a function on a "affiche.inc" file with a "Onclick" event.

Thanks in advance!

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Dolphin's Encyclopaedia Slideshow of Atlantic Hump-backed Dolphins</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body bgcolor="#FFFFFF" text="black" link="blue" vlink="green" alink="red">
<div align="center">
<p><img src="titre.png" alt="Title" width="440" height="72"></p>
<p><img src="slideAtlantichump-backed.png" width="790" height="72" alt="Slideshow"></p>
<p>Last update :
<script language="PHP">
filemtime("slideAtlantichump-backed.php");
echo date("l dS of F Y G:i:s");
</script>
</p>
<p><img src="bar07.png" width="565" height="30" alt="The sea"></p>
<center>
<script language="PHP">
include "../affiche.inc";
$partie="ID";
affiche($partie);
</script>
</center>
<form name="slide" action="">
<table border="1">
<tr>
<td>
<script language="PHP">
$partie="url";
$pic = affichepic($partie);

    echo "<img src=\"chin01.png\" width=\"58\" height=\"50\" align=\"middle\" onClick=\"$pic = rotateinv($partie);\" alt=\"Previous\"></td>\n";
    echo "<td>\n";
    echo "<p><img name=\"pic\" src=\"$pic\" alt=\"Atlantic hump-backed dolphin\"></p>\n";
    echo "</td>\n";
    echo "<td><img src=\"chin02.png\" width=\"58\" height=\"50\" align=\"middle\" onClick=\"$pic = rotate($partie);\" alt=\"Next\"></td>\n";
    </script>
  </tr>
</table>

</form>
<script language="PHP">
$partie="copyrith";
affichecopy($partie);
</script>
<p> <a href="http://validator.w3.org/check/referer"><img border="0" src="valid-html401.png" alt="Valid HTML 4.01!" height="31" width="88"></a>
</p>
<p>&nbsp;</p>
</div>
</body>
</html>