API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Mar 21st, 2014
143
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 9.64 KB | None | 0 0
raw download clone embed print report
  1. Pagina 1 die dus wel werkt:
  2.  
  3. <?php
  4. header('Content-Type: text/html; charset=iso-8859-1');
  5. // Als het niet goed is dan moet je overzicht5.php hernoemen naar overzicht.php
  6.  
  7. if (!session_id()) { session_start(); };
  8. $isal=$_SESSION['ingelogd'];
  9. $oldsql=$_SESSION['sqletje'];
  10. $admin=$_SESSION['admin'];
  11. if (!$isal=="ja") { echo "<h3>Jij mag niet kom hier via die weg nie neah neah neah .... <br> Lekker Puh....<img src='images/lekkerpuh.jpg'>" ; die(); }
  12.  
  13. if ($_POST['nieuweopdracht']=="ja") {
  14. $_SESSION['zoek']=$_POST;
  15. }
  16.  
  17. if(!$_POST['nieuweopdracht']=="ja") {
  18. $_POST=$_SESSION['zoek'];
  19.  }
  20.  
  21.         if ($_POST['titel'] !="") { $sql.=" AND titel like '%".$_POST['titel']."%'";}
  22.         if ($_POST['genre'] !="") { $sql.=" AND genre like '%".$_POST['genre']."%'";}
  23.         if ($_POST['waardering'] !="") { $sql.=" AND waardering like '%".$_POST['waardering']."%'";}
  24.         if ($_POST['studio'] !="") { $sql.=" AND studio like '%".$_POST['studio']."%'";}
  25.         if ($_POST['spelers'] !="") { $sql.=" AND spelers like '%".$_POST['spelers']."%'";}
  26.         if ($_POST['jaar'] !="") { $sql.=" AND jaar like '%".$_POST['jaar']."%'";}
  27.         if ($_POST['regiseur'] !="") { $sql.=" AND regiseur like '%".$_POST['regiseur']."%'";}
  28.         if ($_POST['land'] !="") { $sql.=" AND land like '%".$_POST['land']."%'";}
  29.     include('ps_pagination.php');
  30.         $conn = mysql_connect('localhost','***','***');
  31.     if(!$conn) die("Failed to connect to database!");
  32.         $status = mysql_select_db('chatboy_id', $conn);
  33.     if(!$status) die("Failed to select database!");
  34.         $sql2="select * from films";
  35.         $sql2.=" where cover_v like '%jpg%' ".$sql;    
  36.         $sql2.=" order by id ";
  37.         $pager = new PS_Pagination($conn, $sql2, 4, 15);
  38.         //$pager->setDebug(true);
  39.         $rs = $pager->paginate();
  40.     if(!$rs) { include("filmverzoek.php") ;die(mysql_error());}
  41.     // Dit is de zelfde functie als do { ... } while while($row = mysql_fetch_assoc($rs))
  42.     include("tboven");
  43.     echo "<br><center><span style=\"border: 1px solid black;\">".$pager->renderFullNav()."</span></center>";
  44.         echo "<center>";
  45.         echo '<table class="postmetadata" style="text-align:left"><tbody><tr class="lijst0">';
  46.         $max_hor = 2;
  47.         $hor=0;
  48.         while($row = mysql_fetch_assoc($rs)) { // Per Item  een Regel in de Tabel toevoegen.
  49.         $omschrijving=substr($row['omschrijving'],0,130)."......";
  50.         $datum=date("d-m-Y \~ H:i:s",$row['toegevoegd']);
  51.         $rec_nr=sprintf("[%'05s]\n",  $row['id']);
  52.         $prefix="dvd-covers/";
  53.         $prafix="dvd-overzicht/";
  54.  
  55.         $openkiek="<a href=\"javascript:contentbackup(1);ajax1.run('kiekkiek.php?id={$row[id]} ','content');\">";
  56.         if ($admin=="1") {
  57.         $editknopje="<a href=\"javascript:ajax3.run('wijzigwijzig.php?id={$row[id]}','content');\"><img src=\"images/b_edit.png\" height=12 border=\"0\">";
  58.         }
  59.         // Nieuwe Table voor foto / detiails
  60.         echo '<td valign="right" style="border: 1px dotted SnowWhite;"><table width=560 class="postmetadata" cellSpacing=9 cellPadding=2 border=0 style="text-align:left;"><tbody><tr class="lijst0">';
  61.         echo '<td width="200" valign="top" style="border-right:2px dotted SnowWhite;">';
  62.         echo '<div class="highslide-gallery">';
  63.         echo '<A class="highslide" href="'.$prefix.$row['cover_v'].'" onclick="return hs.expand(this, { slideshowGroup: '. $row[ 'id'].' } )" >';
  64.  
  65.         $cv=$prefix.'tn/tn_'.$row['cover_v'];
  66.         $ca=$prefix.'tn/tn_'.$row['cover_a'];
  67.        
  68.         echo '<img border=0 src="'.$cv.'" height="220" ></A>';
  69.         echo '<div class="hidden-container">';
  70.         echo '<A class="highslide" href="'.$prefix.$row['cover_a'].'" onclick="return hs.expand(this, { slideshowGroup: '.$row['id']. ' })"></a>';
  71.         echo '<A class="highslide" href="'.$prafix.$row['id'].'.jpg" onclick="return hs.expand(this, { slideshowGroup: '.$row['id']. ' })"></a>';
  72.         echo '</div></div>';
  73.         echo '</td><td valign="top">';
  74.        // Film Details
  75.        
  76.         echo '<table class="postmetadata2" width="100%" cellSpacing=3 cellPadding=0 style="text-align:left"><tbody><tr class="lijst0">';
  77.             echo '<tr class="lijst1"><td><span class="numrood" >'.$rec_nr. '</span>'.$editknopje.'</td><td valign="top"><span float:left>'.$openkiek.''.$row[titel].'</a></td></tr>';
  78.             echo '<tr class="lijst2"><td>Omschrijving:</td><td>'.$omschrijving.'</td></tr>';
  79.             echo '<tr class="lijst1"><td>Spelers:</td><td>'.$row[spelers].'&nbsp;</td></tr>';
  80.             echo '<tr class="lijst2"><td>Studio:</td><td>'.$row[studio].'</td></tr>';
  81.             echo '<tr class="lijst1"><td>Speelduur:</td><td>'.$row[speelduur].'&nbsp;Minuten</td></tr>';
  82.             echo '<tr class="lijst1"><td>Waardering:</td><td valign="top"><span style="float:left">'.$row[waardering].'</span><span style="float:right;" class="numrood" >&nbsp;&nbsp;['.$datum. ']</span></td></tr>';
  83.             echo '<tr class="lijst1"><td>Land:</td><td>'.$row[land].'&nbsp;</td></tr>';
  84.             echo '</td></tr></table>';
  85.             echo "</td></tr></table></td>";
  86.                     $hor++;
  87.                     if ($hor==$max_hor) { $hor=0; echo "</tr>\n".'<tr class="lijst0">'; }
  88.     }
  89.     // @ renderFullNav() Toont de < 1 2 3 [4] 5 6 7....>
  90.    
  91.     echo "</tbody></table><center><span style=\"border: 1px solid black;\">".$pager->renderFullNav()."</span></center>";
  92.     include("tonder");
  93.    
  94. ?>
  95.  
  96. Pagina 2, tabel zie je wel, alleen hij pakt de gegevens dus niet :
  97.  
  98. <?
  99. header('Content-Type: text/html; charset=iso-8859-1');
  100.  
  101. $db = mysql_connect('localhost','***', '****');
  102. if(!$db) die("Failed to connect to database!");
  103. $status = mysql_select_db('chatboy_id', $db);
  104. if(!$status) die("Failed to select database!");
  105.  
  106. if (!session_id()) { session_start(); };
  107. $isal=$_SESSION['ingelogd'];
  108. $oldsql=$_SESSION['sqletje'];
  109. if (!$isal=="ja") { echo "<h3>Jij mag niet kom hier via die weg nie neah neah neah .... <br> Lekker Puh....<img src='images/lekkerpuh.jpg'>" ; die(); }
  110.  
  111. $etime=time();
  112. // $result = mysql_query("SELECT id FROM films WHERE hidden=0 AND $field like '%$zoek%' order by login_tijd DESC",$db);
  113. $result = mysql_query("SELECT * FROM films where id='$id'",$db);
  114. $myrow = mysql_fetch_array($result);
  115.  
  116.         $ddate=date("d-m-Y",$myrow['toegevoegd']);
  117. if ($myrow['scene']) {
  118.         $delen=split(",",$myrow['scene']);
  119.         foreach ($delen as $dummy) {
  120.         $info=getIt($dummy);
  121.         $ccmd="javascript:popUpC('http://www.mijnsite.nl/movie/Kijk_Film.php?filmpje=". preg_replace("/\.flv/","",$info['best']) . "')";
  122.         $nffo.="<a href=".$ccmd. ">".$info['oms']."</a><br />";
  123.         }
  124. }
  125.  
  126. if ($myrow['bestandsnaam']) {
  127.         $ccmd="javascript:popUpC('http://www.mijnsite.nl/movie/Kijk_Film.php?filmpje=". preg_replace("/\.flv/","",$myrow['bestandsnaam']) . "')";
  128.         $nffo="<a href=".$ccmd. ">Bekijk Film</a><br />";
  129.  
  130. }
  131. ?>
  132.  
  133. <LINK media=screen href="div_form.css" type=text/css rel=stylesheet>
  134. <br />
  135. <table width="90%">
  136. <tr><td align=left><h1 align=center class=rood><? echo $myrow['titel'] ?></h1></td><td></td><td align=right><a href="javascript:contentrestore();"><img src="images/arrow_left_green_48.png" border=0 style="width:50px; height:50px;"></a></td></td></tr>
  137. </table>
  138. <br>
  139.  
  140. <TABLE id=topnav cellSpacing=0 cellPadding=0  border=1 width="90%">
  141.  
  142. <TBODY>
  143. <tr><td valign="top">
  144. <table class="postmetadata" cellSpacing=4 cellPadding=2 border=0 width="100%">
  145.  
  146. <TBODY>
  147. <tr></tr>
  148.  
  149. <tr class="lijst2"><td width=120 nowrap>Studio</td><td ><? echo $myrow['studio']  ?> </td></tr>
  150. <tr class="lijst2"><td width=120 nowrap>Genre</td><td ><? echo $myrow['genre']  ?> </td></tr>
  151. <tr class="lijst2"><td width=120 nowrap valign=top>Spelers</td><td ><? echo $myrow['spelers'] ?></td></tr>
  152. <tr class="lijst2"><td width=120 nowrap>Land</td><td ><? echo $myrow['land']  ?> </td></tr>
  153. <tr class="lijst2"><td width=120 nowrap>Jaar</td><td ><? echo $myrow['jaar']  ?> </td></tr>
  154. <tr class="lijst2"><td width=120 nowrap>Regiseur</td><td ><? echo $myrow['regiseur']  ?> </td></tr>
  155. <tr class="lijst2"><td width=120 nowrap>Speelduur</td><td ><? echo $myrow['speelduur']  ?> Minuten</td></tr>
  156. <tr class="lijst2"><td width=120 nowrap>Waardering</td><td ><? echo $myrow['waardering']  ?> </td></tr>
  157. <tr class="lijst2"><td width=120 nowrap>Datum Toegevoegd</td><td ><? echo $ddate ?></td></tr>
  158. <tr class="lijst2"><td width=120 nowrap valign=top>Omschrijving</td><td ><? echo $myrow['omschrijving'] ?></td></tr>
  159. <tr class="lijst2"><td width=120 nowrap valign=top>Bekijk<center><img src="images/filmrol.png" border=0 style="width:90px; height:90px;"></center></td><td ><h1><? echo $nffo ?></td></tr>
  160.  
  161. </table>
  162. </td><td width="200" align="center">
  163. <img src="/movie/dvd-covers/tn/tn_<? echo $myrow['cover_v'] ?>" name="myimage" width="140"><br><br>
  164. <img src="/movie/dvd-covers/tn/tn_<? echo $myrow['cover_a'] ?>" name="myimage" width="140">
  165. </td>
  166. </tr>
  167. <tr class="lijst1"><td colspan=2 align=center><a style="text-decoration: none;" href="javascript:popUpC('http://www.mijnsite.nl/movie/MakeAlbum2.php?g=<? echo $myrow['id'] ?>')"><br>
  168.  
  169. <?
  170. $g=$myrow['id'];
  171. $teller=1;
  172. $teller2=1;
  173. $aap=exec("identify MovieBase/pix/$g/tn/tn_*.jpg",$noot);
  174. $aantal=count($noot);
  175. foreach($noot as $i=>$inhoud) {
  176. $inhoud=preg_replace("/\[.*\]/","",$inhoud);
  177. // $inhoud=ereg_replace("..","",$inhoud);
  178. list($bestand,$type,$resolutie) = explode(" ",$inhoud);
  179. $resolutie=ereg_replace("/x/",",",$resolutie);
  180. echo <<< EOT
  181. <img src="http://www.mijnsite.nl/movie/$bestand" width="100" border=0>&nbsp;
  182. EOT;
  183. $teller++;
  184. $teller2++;
  185. if ($teller2==9) {
  186. echo "<br>";
  187. $teller2=1; }
  188. }
  189.  
  190. ?>
  191. <br></a></td></tr>
  192.  
  193.  
  194.  
  195. </table>
  196.  
  197. <?
  198.  
  199. function getIt($aap) { // Deze functie haalt uit de maat/kleur de meerprijs bijv. "Blauw XXL [10.00]" en stuurt deze terug.
  200.     $res=array();
  201.     $b=strpos($aap,"[");
  202.     if($b==0) return;
  203.     $e=strpos($aap,"]");
  204.     $w=substr($aap,$b+1,strlen($aap)-$e-2);
  205.     $w=preg_match(" /i","",$w);
  206.     $w=preg_match("\+/i","",$w);
  207.     $w2=substr($aap,0,$b);
  208.     $w2=trim($w2);
  209.     $res['oms']=$w2;
  210.     $res['best']=$w;
  211.     return $res;
  212. }?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!