slide show using javascript using php variable -
i trying fellow member photos sql , show slide. trying dhtml slideshow script- © dynamic drive dhtml code library (www.dynamicdrive.com) check basic code here basic code
now alter code image url mysql using php
my code :
here html , script code. <html> <head> <script type="text/javascript"> /*********************************************** * dhtml slideshow script- © dynamic drive dhtml code library (www.dynamicdrive.com) * notice must remain intact legal utilize * visit http://www.dynamicdrive.com/ total source code ***********************************************/ var photos = new array() <?php $mid=$_post['mid']; //echo $mid; $mid=$_post['mid']; require_once("datacon.php"); $result = $data->query("select * tempregist id= $mid "); $row = mysqli_fetch_array($result) or die(mysqli_error()); $folde= "uploads/thumb/"; $folder=utf8_encode($folde); //echo $folder; $mid1 =$row['mid']; require_once("datacon.php"); $result = $data->query("select image_name tbl_images mid= '$mid1' "); $phparray = array(); $count = mysqli_num_rows($result); if($count>=1) { while($crow = mysqli_fetch_array($result)) { $i=0; $phparray[$i] = $folder. $crow['image_name']; $i++; ?> photos<?php echo"[".$i."]" ;?> = <?php echo '"'. implode( $phparray) . '"'."\n" ; } } ?> var photoslink = new array var x x =<?php echo json_encode($count) ?>; var which=0 / //specify whether images should linked or not (1=linked) var linkornot=0 set corresponding urls above images. define if variable linkornot equals "1" photoslink[0]="" photoslink[1]="" photoslink[2]="" //do not edit pass line var preloadedimages=new array() (i=0;i<photos.length;i++){ preloadedimages[i]=new image() preloadedimages[i].src=photos[i] } function applyeffect(){ if (document.all && photoslider.filters){ photoslider.filters.revealtrans.transition=math.floor(math.random()*23) photoslider.filters.revealtrans.stop() photoslider.filters.revealtrans.apply() } } function playeffect(){ if (document.all && photoslider.filters) photoslider.filters.revealtrans.play() } function keeptrack(){ window.status="image "+(which+1)+" of "+photos.length } function backward(){ if (which>0){ which-- applyeffect() document.images.photoslider.src=photos[which] playeffect() keeptrack() } } function forward(){ if (which<photos.length-1){ which++ applyeffect() document.images.photoslider.src=photos[which] playeffect() keeptrack() } } function transport(){ window.location=photoslink[which] } </script> </head> <body> <div align="center"> <img src="images/logo.jpg" border = "2" align="center" alt="no logo"> </div> <table border="0" cellspacing="0" cellpadding="0"> <tr> <td width="100%" colspan="2" height="22"><center> <script> if (linkornot==1) document.write('<a href="javascript:transport()">') document.write('<img src="'+photos[0]+'" name="photoslider" style="filter:revealtrans(duration=2,transition=23)" border=0>') if (linkornot==1) document.write('</a>') </script> </center></td> </tr> <tr> <td width="50%" height="21"><p align="left"><a href="#" onclick="backward();return false">previous slide</a></td> <td width="50%" height="21"><p align="right"><a href="#" onclick="forward();return false">next slide</a></td> </tr> </table> <p align="center"><font face="arial" size="-2">free dhtml scripts provided by<br> <a href="http://dynamicdrive.com">dynamic drive</a></font></p> </body> </html> now getting out set follows var photos = new array()
photos[0] = "uploads/thumb/220816_1412135472.jpeg" photos[0] = "uploads/thumb/312840_1412135511.jpeg" photos[0] = "uploads/thumb/589453_1412135511.jpeg" photos[0] = "uploads/thumb/467341_1412135630.jpeg" photos[0] = "uploads/thumb/800658_1412135790.jpeg" photos[0] = "uploads/thumb/366793_1412135826.jpeg" but need out set this
photos[0] = "uploads/thumb/220816_1412135472.jpeg" photos[1] = "uploads/thumb/312840_1412135511.jpeg" photos[2] = "uploads/thumb/589453_1412135511.jpeg" photos[3] = "uploads/thumb/467341_1412135630.jpeg" photos[4] = "uploads/thumb/800658_1412135790.jpeg" photos[5] = "uploads/thumb/366793_1412135826.jpeg" i tried much. please 1 help.
while($crow = mysqli_fetch_array($result)) { $i=0;
you're resetting $i in loop
javascript php mysql
No comments:
Post a Comment