dus hij ziet een van de volgende woorden
Link gekopieerd
Deze is nul: $showRecords
Link gekopieerd
enn.. hoe los ik het op? ligt daar ook het probleem dat hij de tabel niet goed uitleest (en daardoor de mappen)?
Link gekopieerd
Je geeft $showRecords nergens een waarde.
Link gekopieerd
Heb nu gezegd $showRecords = 1. Gevolg is dat de foutmelding weg is, maar volgens mij doe k het niet goed, want er worden nog steeds geen gegevens uit de tabel uitgelezen...
Link gekopieerd
Ik heb net even gekeken naar je huidige code, Er zit wel meer dan 1 fout in ben ik bang. Je bent ook nog een paar dingen vergeten / en er zitten een paar stukken code op de verkeerde plaats. Je ziet niks omdat je de resultaten wel ophaalt maar niet weergeeft " Je mist een while loop ". Als ik tijd heb kijk ik er vanavond misschien even naar.
Link gekopieerd
Dat zou top zijn! thnx voor de snelle scan alvast in iedergeval.
Link gekopieerd
Probeer onderstaande eens, Geen idee of het werkt ik kan het natuurlijk niet testen voor je. Ik heb geen tijd " en zin " om alles op te ruimen, het is me nogal een mengelmoes. Er moet nog fout afhandeling worden ingebouwd en commentaar toevoegen is ook wel handig.
Je hebt heel veel verschillende scripts door elkaar gegooid gok zo te zien. Je sloot ook verschillende div's niet goed af.
Let ook even op de volgorde van je code de volgende keer, Het aantal pagina's was veel eerder nodig dan jij ze berekende.
Anway hopelijk lukt het.
<?php
/*--------------------------------------------------------------------------------------------------------------------------
(§) Settings | MySQL database connection.
--------------------------------------------------------------------------------------------------------------------------*/
#| Database info.
$myServer = 'localhost';
$myDataBase = 'xxx';
$myUser = 'xxx';
$myPass = 'xxx';
/*--------------------------------------------------------------------------------------------------------------------------
(§) MySQL | Database connection.
--------------------------------------------------------------------------------------------------------------------------*/
$myConn = mysql_connect($myServer, $myUser, $myPass);
$select = mysql_select_db($myDataBase, $myConn);
// LET OP! Foutafhandeling inbouwen.
/*--------------------------------------------------------------------------------------------------------------------------
(§) Pagination | Settings.
--------------------------------------------------------------------------------------------------------------------------*/
/*---- INFO! ---->
Make sure the menu length is an uneven number.
*/
#| Results per page.
$results_per_page = 10;
#| Maximum length of the menu.
$menu_length = 5;
#| Menu's divider.
$menu_divider = ' | ';
/*--------------------------------------------------------------------------------------------------------------------------
(§) Pagination | Page count.
--------------------------------------------------------------------------------------------------------------------------*/
#| Totaal aantal resultaten tellen.
$query = 'SELECT * FROM dnp2 ORDER BY Datum DESC';
$results = mysql_query($query) or die(mysql_error());
$num_rows = mysql_num_rows($results);
// LET OP! Foutafhandeling inbouwen.
#| Aantal pagina's berekenen.
$page_count = ceil($num_rows / $results_per_page);
/*--------------------------------------------------------------------------------------------------------------------------
(§) Pagination | Validate the supplied current page. " $_GET['page'] "
--------------------------------------------------------------------------------------------------------------------------*/
#| Current page.
$current_page = (isset($_GET['page']) and in_array($_GET['page'], range(1, $page_count))) ? $_GET['page'] : 1 ;
/*--------------------------------------------------------------------------------------------------------------------------
(§) Pagination | Menu's range.
--------------------------------------------------------------------------------------------------------------------------*/
/*---- INFO! ---->
Calculate the menu's range.
*/
#| Calculate the menu's middle point.
$mid_point = floor($menu_length / 2 );
#| Calculate the menu's range.
if($page_count < $menu_length){
#| Not enough pages for the fancy stuff.
$menu_range = range(1, $page_count);
}
elseif($current_page > ($page_count - $mid_point)){
#| Last couple of pages.
$menu_range = range(($page_count - $menu_length) , $page_count);
}
elseif($current_page > $mid_point){
#| Middle pages.
$menu_range = range(($current_page - $mid_point), ($current_page + $mid_point));
}
else{
#| First couple of pages.
$menu_range = range(1, $menu_length);
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title> DNP.NU beta 3</title>
<LINK REL=StyleSheet HREF="style1.css" TYPE="text/css" MEDIA=screen>
<link rel="stylesheet" href="css/lightbox.css" type="text/css" media="screen" />
<SCRIPT>
<!-- PopUp Link JavaScript Code Provided By: http://www.DesignerWiz.com - Development Resource & JavaScript Public Archive Center -->
function popUp(page,PWidth,PHeight,id) {
eval("designerwiz"+id+"=window.open('"+page+"','designerwiz1','toolbar=0,scrollbars=1,location=0,status=1,menubars=0,resizable=0,width="+PWidth+",height="+PHeight+"')")
eval;("wiz"+id+".window.moveTo((screen.width/2)-(PWidth/2),(screen.height/2)-(PHeight/2))")
}
</SCRIPT>
<script type="text/javascript" src="js/prototype.js"></script>
<script type="text/javascript" src="js/scriptaculous.js?load=effects,builder"></script>
<script type="text/javascript" src="js/lightbox.js"></script>
</head>
<body>
<div class="container">
<div class="midden2">
<div class="midden">
<div class="header">
<img src="layout/img/header.png" alt="DNP.NU">
</div>
<div class="divmenu">
<A HREF="javascript:popUp('upload.php',500,250,1);"><img src="layout/img/uploadbutton.png" border=0 alt="Upload jouw video op DNP.NU" align="right"></a>
</div>
<?php
/*--------------------------------------------------------------------------------------------------------------------------
(§) Pagination | Previous page
--------------------------------------------------------------------------------------------------------------------------*/
if($current_page > 1){
echo '<a href="?page='.($current_page - 1).'"><<</a> ';
}
/*--------------------------------------------------------------------------------------------------------------------------
(§) Pagination | Numeric menu.
--------------------------------------------------------------------------------------------------------------------------*/
#| Set " $menu " array for storing all the menu's items.
$menu = array();
#| Create all the menu's items.
foreach($menu_range as $page){
$menu[] = ($page == $current_page) ? '(<a href="?page='.$page.'">'.$page.'</a>) ' : '<a href="?page='.$page.'">'.$page.'</a>' ;
}
#| Display the menu.
echo implode($menu_divider, $menu);
/*--------------------------------------------------------------------------------------------------------------------------
(§) Pagination | Next page.
--------------------------------------------------------------------------------------------------------------------------*/
if($current_page < $page_count){
echo ' <a href="?page='.($current_page + 1).'">>></a>';
}
/*--------------------------------------------------------------------------------------------------------------------------
(§) Alle resultaten ophalen en weergeven.
--------------------------------------------------------------------------------------------------------------------------*/
$query = 'SELECT * FROM dnp2 ORDER BY Datum DESC LIMIT '.mysql_real_escape_string((($current_page - 1) * $results_per_page)).', '.$results_per_page;
$results = mysql_query($query) or die(mysql_error());
// LET OP! Foutafhandeling inbouwen.
while($row = mysql_fetch_assoc($results)){
echo ' <div class="geheel">
<div class="linkerkolom">
<div class="bovenlinks">
<div class="titel"><div class="id">( '.$row['ID'].' ) </div> '.$row['Titel'].'</div>
<div class="datum">'.$row['Datum'].'</div>
</div><br>
<div class="onderlinks">
<div class="bericht"><br><b>'.$row['Plaats'].'</b> - '.$row['Bericht'];
$dirname = "dnpnieuw/items/".$row['ID']."/downloads";
$images = scandir($dirname);
$ignore = array(".", "..", ".txt", ".TXT");
foreach($images as $curimg){
if(!in_array($curimg, $ignore)) {
echo '<br><a href="dnpnieuw/items/'.$row['ID'].'/downloads/'.$curimg.'">Download '.$curimg.'</a><br>';
}
}
echo '</div>
</div>
</div>
<div class="rechterkolom"><img src="layout/img/balkvideo.png" alt="Bekijk onderstaande video">';
$dirname = "dnpnieuw/items/".$row['ID']."/flv/";
$images = scandir($dirname);
$ignore = array(".", "..", ".txt", ".TXT");
foreach($images as $curimg){
if(!in_array($curimg, $ignore)) {
echo '<object classid=clsid:d27cdb6e-ae6d-11cf-96b8-444553540000
codebase=http://fpdownload.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,0,0
width=381 height=216 id=fullscreen align=middle>
<param name="WMode" value="transparent"></param>
<param name=allowScriptAccess value=sameDomain/>
<param name=movie value="flvplayer.swf/>
<param name=quality value=high />
<param name=salign value=tl />
<param name=bgcolor value=#ffffff />
<param name="startimage" value="start_frame.jpg" />
<param name="autoplay" value="0" />
<param name="autoload" value="0" />
<param name="buffer" value="5" />
<param name="buffermessage" value="" />
<param name="buffercolor" value="ffffff" />
<param name="bufferbgcolor" value="858686" />
<param name="buffershowbg" value="0" />
<param name="title" value="20100214 Zwaag carnaval" />
<param name="titlesize" value="20" />
<param name="titlecolor" value="ffffff" />
<param name="margin" value="0" />
<param name="srt" value="0" />
<param name="srtcolor" value="ffffff" />
<param name="srtbgcolor" value="858686" />
<param name="srtsize" value="11" />
<param name="showstop" value="1" />
<param name="showvolume" value="1" />
<param name="showtime" value="1" />
<param name="showplayer" value="autohide" />
<param name="showloading" value="autohide" />
<param name="showfullscreen" value="1" />
<param name="showswitchsubtitles" value="0" />
<param name="showmouse" value="autohide" />
<param name="loop" value="0" />
<param name="startimage" value="start_frame.jpg" />
<param name="playercolor" value="858686" />
<param name="loadingcolor" value="dddddd" />
<param name="bgcolor" value="ffffff" />
<param name="bgcolor1" value="ffffff" />
<param name="bgcolor2" value="ffffff" />
<param name="buttoncolor" value="ffffff" />
<param name="buttonovercolor" value="c3c4c4" />
<param name="slidercolor1" value="ffffff" />
<param name="slidercolor2" value="cccccc" />
<param name="sliderovercolor" value="c3c4c4" />
<param name="loadonstop" value="0" />
<param name="onclick" value="playpause" />
<param name="onclicktarget" value="_blank" />
<param name="ondoubleclick" value="fullscreen" />
<param name="ondoubleclicktarget" value="_blank" />
<param name="playertimeout" value="1500" />
<param name="videobgcolor" value="000000" />
<param name="volume" value="100" />
<param name="shortcut" value="1" />
<param name="playeralpha" value="100" />
<param name="srturl" value="video.srt" />
<param name="top1" value="0" />
<param name="showiconplay" value="1" />
<param name="iconplaycolor" value="ffffff" />
<param name="iconplaybgcolor" value="dddddd" />
<param name="iconplaybgalpha" value="25" />
<param name="showtitleandstartimage" value="0" />
<param NAME=FlashVars VALUE="file=dnpnieuw/items/'.$row['ID'].'/flv/'.$curimg.'">
<embed wmode="transparent" src=flvplayer.swf FlashVars="file=dnpnieuw/items/'.$row['ID'].'/flv/'.$curimg.'" quality=high
salign=tl bgcolor=#ffffff width=381 height=216 name=fullscreen
align=middle allowScriptAccess=sameDomain type=application/x-shockwave-
flash pluginspage=http://www.macromedia.com/go/getflashplayer/>
</object>';
}
}
echo '
<br>
<img src="layout/img/balkfoto.png" alt="Bekijk onderstaande video">
<div class="fotoalbum"><div class="fotoalbumcenter">';
$dirname = "dnpnieuw/items/".$row['ID']."/foto/";
$images = scandir($dirname);
$ignore = array(".", "..", ".txt", ".TXT");
foreach($images as $curimg){
if(!in_array($curimg, $ignore)) {
echo '<a href="dnpnieuw/items/'.$row['ID'].'/foto/'.$curimg.'" rel="lightbox['.$row['ID'].']"><img img width=109 border=0 height=61 Hspace=5 Vspace=5 src="dnpnieuw/items/'.$row['ID'].'/foto/'.$curimg.'" alt="Foto: DNP.NU"></a>';
}
}
echo '
</div></div>
';
} // End of while loop.
?>
</div></div><br /></div>
</body>
</html>
Link gekopieerd
SUPER het werkt! Dankjewel! En ook andere reageerders bedankt!:)
http://81.30.70.233/~dnp/tester2.php
EDIT: er moest inderdaad 2 keer een div worden afgesloten, dat is nu gebeurd. Nogmaals bedankt!
Link gekopieerd
