<?xml version="1.0" encoding="UTF-8" ?>
<rss version="2.0">
<channel>
	<title>PFZ.nl - PHP Forum</title>
	<description>PFZ.nl - PHP Community - PHP Forum feed</description>
	<link>http://www.pfz.nl/forum/index.php</link>
	<pubDate>Sun, 05 Feb 2012 16:03:04 +0000</pubDate>
	<ttl>5</ttl>
	<item>
		<title><![CDATA[$_GET werkt niet goed met true &#38; False]]></title>
		<link>http://www.pfz.nl/forum/topic/6786-get-werkt-niet-goed-met-true-false/</link>
		<description><![CDATA[Via het onderstaande script wil ik kijken of de $_GET['pagina'] in mijn database voorkomt, anders moet hij de pagina met de 404 melding weergeven.<br />
<br />
Maar hij geeft nu een witte veld weer op de plaats waar de tekst zou moeten verschijnen. De rest van de pagina laadt wel gewoon goed.<br />
<br />
Ik denk zelf dat het fout gaat met $maintekst=false; Maar kom er niet goed uit met de = tekens. Maar wat ik kan vinden op internet zou dit de goede manier moeten zijn.<br />
<br />
<table class="highlight source" cellspacing="0"><tr><td class="line-numbers">1<br/>2<br/>3<br/>4<br/>5<br/>6<br/>7<br/>8<br/>9<br/>10<br/>11<br/>12<br/>13<br/>14<br/>15<br/>16<br/>17<br/>18<br/>19<br/>20<br/>21<br/>22<br/>23<br/>24<br/>25<br/>26<br/>27<br/>28<br/>29<br/>30<br/>31<br/>32<br/>33<br/>34<br/>35<br/>36<br/>37<br/>38<br/>39<br/>40<br/>41<br/>42<br/>43<br/>44<br/>45<br/>46<br/>47<br/>48<br/>49<br/>50<br/>51<br/>52<br/>53<br/>54<br/>55<br/>56<br/>57<br/>58<br/>59<br/>60<br/>61<br/>62<br/>63<br/>64<br/>65<br/>66<br/>67<br/>68<br/>69<br/>70<br/>71<br/>72<br/>73</td><td><pre><span class="php"><span class="html"><span class="php"><span class="keyword">if</span><span class="symbol">(</span><span class="symbol">!</span><span class="keyword">isset</span><span class="symbol">(</span><span class="variable">$_GET</span><span class="symbol">&#91;</span><span class="string single">'pagina'</span><span class="symbol">&#93;</span><span class="symbol">)</span> <span class="symbol">|</span><span class="symbol">|</span> <span class="variable">$_GET</span><span class="symbol">&#91;</span><span class="string single">'pagina'</span><span class="symbol">&#93;</span> <span class="symbol">==</span><span class="string single">''</span><span class="symbol">)</span>
<span class="symbol">{</span>
<span class="variable">$pagina</span> <span class="symbol">=</span><span class="string single">'home'</span><span class="symbol">;</span>
<span class="symbol">}</span>
<span class="keyword">else</span>
<span class="symbol">{</span>
<span class="variable">$pagina</span> <span class="symbol">=</span><a href="http://www.php.net/mysql_real_escape_string" class="function">mysql_real_escape_string</a><span class="symbol">(</span><span class="variable">$_GET</span><span class="symbol">&#91;</span><span class="string single">'pagina'</span><span class="symbol">&#93;</span><span class="symbol">)</span><span class="symbol">;</span>
<span class="symbol">}</span>

<span class="comment">//mainsql
</span><span class="variable">$maintekst</span><span class="symbol">=</span>false<span class="symbol">;</span>
<span class="variable">$mainqry</span> <span class="symbol">=</span> <span class="string double">" 
                SELECT 
                        titel,
                        url,
                        tekst, 
                        link,
                        include,
                        taal,
                        taalbestand
                FROM 
                        jcsl
                INNER JOIN
                        jcsl_tekst
                ON
                        jcsl.id=jcsl_tekst.url
                WHERE
                        taal='"</span><span class="symbol">.</span><span class="variable">$lang</span><span class="symbol">.</span><span class="string double">"' 
                AND     
                        link = '"</span> <span class="symbol">.</span> <span class="variable">$pagina</span> <span class="symbol">.</span><span class="string double">"'
            "</span><span class="symbol">;</span>
            

    <span class="variable">$mainsql</span> <span class="symbol">=</span> <a href="http://www.php.net/mysql_query" class="function">mysql_query</a><span class="symbol">(</span><span class="variable">$mainqry</span><span class="symbol">,</span> <span class="variable">$connection</span><span class="symbol">)</span><span class="symbol">;</span> 
    
    <span class="keyword">if</span><span class="symbol">(</span><span class="variable">$mainsql</span> <span class="symbol">===</span> false<span class="symbol">)</span>
    <span class="symbol">{</span>
        <span class="keyword">echo</span> <span class="symbol">(</span><span class="string double">" Er gaat iets mis in ("</span><span class="symbol">.</span><span class="variable">$mainqry</span> <span class="symbol">.</span><span class="string double">")"</span><span class="symbol">.</span><a href="http://www.php.net/mysql_error" class="function">mysql_error</a><span class="symbol">(</span><span class="variable">$connection</span><span class="symbol">)</span><span class="symbol">)</span><span class="symbol">;</span>
    <span class="symbol">}</span>                
    <span class="keyword">else</span>
    <span class="symbol">{</span>
        <span class="variable">$maintekst</span> <span class="symbol">=</span> <a href="http://www.php.net/mysql_fetch_assoc" class="function">mysql_fetch_assoc</a><span class="symbol">(</span><span class="variable">$mainsql</span><span class="symbol">)</span><span class="symbol">;</span> 
    <span class="symbol">}</span>

            
<span class="keyword">if</span><span class="symbol">(</span><span class="variable">$maintekst</span><span class="symbol">==</span>false<span class="symbol">)</span>
<span class="symbol">{</span> 
    <span class="variable">$mainaltqry</span>    <span class="symbol">=</span> <span class="string double">" 
                        SELECT 
                               titel, 
                               tekst
                        FROM 
                               jcsl
                        INNER JOIN
                                jcsl_tekst
                        ON
                                jcsl.id=jcsl_tekst.url
                        WHERE 
                                taal='"</span><span class="symbol">.</span><span class="variable">$lang</span><span class="symbol">.</span><span class="string double">"' 
                        AND     
                               link= 'error404'
                               "</span><span class="symbol">;</span> 
        <span class="variable">$mainaltsql</span> <span class="symbol">=</span> <a href="http://www.php.net/mysql_query" class="function">mysql_query</a><span class="symbol">(</span><span class="variable">$mainaltqry</span><span class="symbol">,</span> <span class="variable">$connection</span><span class="symbol">)</span><span class="symbol">;</span> 
    
    <span class="keyword">if</span><span class="symbol">(</span><span class="variable">$mainaltsql</span> <span class="symbol">===</span> false<span class="symbol">)</span>
    <span class="symbol">{</span>
        <span class="keyword">echo</span> <span class="symbol">(</span><span class="string double">" Er gaat iets mis in ("</span><span class="symbol">.</span><span class="variable">$mainaltqry</span> <span class="symbol">.</span><span class="string double">")"</span><span class="symbol">.</span><a href="http://www.php.net/mysql_error" class="function">mysql_error</a><span class="symbol">(</span><span class="variable">$connection</span><span class="symbol">)</span><span class="symbol">)</span><span class="symbol">;</span>
    <span class="symbol">}</span>                
    <span class="keyword">else</span>
    <span class="symbol">{</span>
        <span class="variable">$maintekst</span> <span class="symbol">=</span> <a href="http://www.php.net/mysql_fetch_assoc" class="function">mysql_fetch_assoc</a><span class="symbol">(</span><span class="variable">$mainaltsql</span><span class="symbol">)</span><span class="symbol">;</span> 
    <span class="symbol">}</span>
<span class="symbol">}</span></span></span></span></pre></td></tr></table>]]></description>
		<pubDate>Sun, 05 Feb 2012 16:03:04 +0000</pubDate>
		<guid>http://www.pfz.nl/forum/topic/6786-get-werkt-niet-goed-met-true-false/</guid>
	</item>
	<item>
		<title>Update via invoerformulier</title>
		<link>http://www.pfz.nl/forum/topic/6785-update-via-invoerformulier/</link>
		<description><![CDATA[Hallo, met onderstaande kan ik gegevens wijzigen. Maar nu wil ik dit wijzigen via een invoerformulier met uitgangspunt de naam_kantinedienst. Ik heb diverse voorbeelden geprobeerd maar het lukt mij niet.<br />
Heeft iemand een voorbeeld die aansluit bij mijn script!<br />
<br />
<table class="highlight source" cellspacing="0"><tr><td class="line-numbers">1<br/>2<br/>3<br/>4<br/>5<br/>6<br/>7<br/>8<br/>9<br/>10<br/>11<br/>12<br/>13<br/>14<br/>15<br/>16</td><td><pre><span class="php"><span class="html"><span class="php"><span class="symbol">&#93;</span><span class="symbol">&#91;</span>&lt;?php
<span class="variable">$con</span> <span class="symbol">=</span> <a href="http://www.php.net/mysql_connect" class="function">mysql_connect</a><span class="symbol">(</span><span class="string double">"****"</span><span class="symbol">,</span><span class="string double">"****"</span><span class="symbol">,</span><span class="string double">"****"</span><span class="symbol">)</span><span class="symbol">;</span>
<span class="keyword">if</span> <span class="symbol">(</span><span class="symbol">!</span><span class="variable">$con</span><span class="symbol">)</span>
  <span class="symbol">{</span>  <span class="keyword">die</span><span class="symbol">(</span><span class="string single">'Could not connect: '</span> <span class="symbol">.</span> <a href="http://www.php.net/mysql_error" class="function">mysql_error</a><span class="symbol">(</span><span class="symbol">)</span><span class="symbol">)</span><span class="symbol">;</span>  <span class="symbol">}</span>
<a href="http://www.php.net/mysql_select_db" class="function">mysql_select_db</a><span class="symbol">(</span><span class="string double">"****"</span><span class="symbol">,</span> <span class="variable">$con</span><span class="symbol">)</span><span class="symbol">;</span>

<span class="variable">$query</span> <span class="symbol">=</span> <span class="string double">"UPDATE naamtabel
SET
 datum_kantinedienst = 'augustus' // nieuwe datum
WHERE
 naam_kantinedienst = 'Andre'"</span><span class="symbol">;</span> <span class="comment">// gewijzigd bij Andre
</span>
<a href="http://www.php.net/mysql_query" class="function">mysql_query</a><span class="symbol">(</span><span class="variable">$query</span><span class="symbol">)</span> <span class="keyword">or</span> <span class="keyword">die</span> <span class="symbol">(</span><a href="http://www.php.net/mysql_error" class="function">mysql_error</a><span class="symbol">(</span><span class="symbol">)</span><span class="symbol">)</span><span class="symbol">;</span>
<a href="http://www.php.net/mysql_close" class="function">mysql_close</a><span class="symbol">(</span><span class="variable">$con</span><span class="symbol">)</span><span class="symbol">;</span>

?&gt;</span></span></span></pre></td></tr></table>]]></description>
		<pubDate>Sun, 05 Feb 2012 16:00:55 +0000</pubDate>
		<guid>http://www.pfz.nl/forum/topic/6785-update-via-invoerformulier/</guid>
	</item>
	<item>
		<title>mysql filteren op array</title>
		<link>http://www.pfz.nl/forum/topic/6784-mysql-filteren-op-array/</link>
		<description><![CDATA[Beste,<br />
<br />
Ik staar me al even blind op een klein stukje code wat me niet wilt lukken.<br />
<br />
Wat ik wil doen is 1 resultaat ophalen uit de database welke niet voorkomt in $visited_array.<br />
<br />
<table class="highlight source" cellspacing="0"><tr><td class="line-numbers">1<br/>2<br/>3</td><td><pre><span class="php"><span class="html"><span class="php"><span class="variable">$visited_array</span> <span class="symbol">=</span> <span class="keyword">array</span><span class="symbol">(</span>1<span class="symbol">,</span>2<span class="symbol">,</span>3<span class="symbol">,</span>4<span class="symbol">,</span>5<span class="symbol">,</span>6<span class="symbol">,</span>7<span class="symbol">,</span>8<span class="symbol">,</span>9<span class="symbol">,</span>10<span class="symbol">)</span><span class="symbol">;</span>

<span class="variable">$id</span> <span class="symbol">=</span> <a href="http://www.php.net/mysql_result" class="function">mysql_result</a><span class="symbol">(</span><a href="http://www.php.net/mysql_query" class="function">mysql_query</a><span class="symbol">(</span><span class="string double">"SELECT id FROM sites WHERE id!='"</span><span class="symbol">.</span><span class="variable">$visited_array</span><span class="symbol">.</span><span class="string double">"' ORDER BY waarde DESC LIMIT 1"</span><span class="symbol">)</span><span class="symbol">,</span><span class="string double">"id"</span><span class="symbol">)</span><span class="symbol">;</span></span></span></span></pre></td></tr></table><br />
<br />
Foutmelding: <br />
Warning: mysql_result() expects parameter 2 to be long, string given in /opt/lampp/htdocs/test.php on line 50<br />
<br />
Alle hulp word zeer op prijs gesteld.]]></description>
		<pubDate>Sun, 05 Feb 2012 15:30:31 +0000</pubDate>
		<guid>http://www.pfz.nl/forum/topic/6784-mysql-filteren-op-array/</guid>
	</item>
	<item>
		<title>URL-detectie afkappen</title>
		<link>http://www.pfz.nl/forum/topic/6783-url-detectie-afkappen/</link>
		<description><![CDATA[Ik gebruik deze code om in een reactieformulier een URL te detecteren en aanklikbaar te maken:<br />
<br />
<table class="highlight source" cellspacing="0"><tr><td class="line-numbers">1<br/>2<br/>3<br/>4<br/>5<br/>6<br/>7<br/>8</td><td><pre><span class="php"><span class="html"><span class="php"><span class="variable">$m</span> <span class="symbol">=</span> <a href="http://www.php.net/preg_match_all" class="function">preg_match_all</a><span class="symbol">(</span><span class="string single">'/http:\/\/&#91;a-z0-9A-Z,-.&#93;+(?(?=&#91;\/&#93;)(.*))/'</span><span class="symbol">,</span> <span class="variable">$reactietxtstrip</span><span class="symbol">,</span> <span class="variable">$match</span><span class="symbol">)</span><span class="symbol">;</span>

<span class="keyword">if</span> <span class="symbol">(</span><span class="variable">$m</span><span class="symbol">)</span> <span class="symbol">{</span>
    <span class="variable">$links</span><span class="symbol">=</span><span class="variable">$match</span><span class="symbol">&#91;</span>0<span class="symbol">&#93;</span><span class="symbol">;</span>
    <span class="keyword">for</span> <span class="symbol">(</span><span class="variable">$j</span><span class="symbol">=</span>0<span class="symbol">;</span><span class="variable">$j</span><span class="symbol">&lt;</span><span class="variable">$m</span><span class="symbol">;</span><span class="variable">$j</span><span class="symbol">+</span><span class="symbol">+</span><span class="symbol">)</span> <span class="symbol">{</span>
        <span class="variable">$reactietxtstrip</span><span class="symbol">=</span><a href="http://www.php.net/str_replace" class="function">str_replace</a><span class="symbol">(</span><span class="variable">$links</span><span class="symbol">&#91;</span><span class="variable">$j</span><span class="symbol">&#93;</span><span class="symbol">,</span><span class="string single">'&lt;a href="'</span><span class="symbol">.</span><span class="variable">$links</span><span class="symbol">&#91;</span><span class="variable">$j</span><span class="symbol">&#93;</span><span class="symbol">.</span><span class="string single">'" target="_blank"&gt;'</span><span class="symbol">.</span> inkorten<span class="symbol">(</span><span class="variable">$links</span><span class="symbol">&#91;</span><span class="variable">$j</span><span class="symbol">&#93;</span><span class="symbol">,</span> 40<span class="symbol">)</span> <span class="symbol">.</span><span class="string single">'&lt;/a&gt;'</span><span class="symbol">,</span><span class="variable">$reactietxtstrip</span><span class="symbol">)</span><span class="symbol">;</span>
    <span class="symbol">}</span>
<span class="symbol">}</span></span></span></span></pre></td></tr></table><br />
<br />
Maar als ik typ:<br />
<br />
"<a href='http://www.pfz.nl/' class='bbc_url' title='Externe link ' rel='nofollow external'>http://www.pfz.nl/</a> Deze site is gaaf"<br />
<br />
Dan maakt hij de link &lt;a href="<a href='http://www.pfz.nl/' class='bbc_url' title='Externe link ' rel='nofollow external'>http://www.pfz.nl/</a> Deze site is gaaf"&gt;<br />
<br />
Hoe zorg ik dat hij de URL afkapt na de spatie?]]></description>
		<pubDate>Sun, 05 Feb 2012 13:38:30 +0000</pubDate>
		<guid>http://www.pfz.nl/forum/topic/6783-url-detectie-afkappen/</guid>
	</item>
	<item>
		<title>output imagejpeg</title>
		<link>http://www.pfz.nl/forum/topic/6781-output-imagejpeg/</link>
		<description><![CDATA[Ik heb een class gemaakt die kijkt wat voor plaatje het is (jpeg, png etc.) vervolgens resize ik het plaatje met een bepaald percentage. En daarna output ik het plaatje zonder het op te slaan. Dit werkt perfect. <br />
Maar wanneer ik het een tweede keer op de zelfde pagina probeer laat hij alleen nog steeds maar alleen plaatje 1 zien.<br />
Of als ik het plaatje in een tabel zet ook dan zie ik alleen het plaatje het tabel wordt niet ge-echot.<br />
<br />
Wat kan ik hier aan doen?? Hoe kan ik er voor zorgen dat het wel goed werkt. btw ik ben nieuw met classes en wil meteen van af het begin netjes proberen te werken dus opmerking/tips zijn altijd welkom.<br />
<br />
<table class="highlight source" cellspacing="0"><tr><td class="line-numbers">1<br/>2<br/>3<br/>4<br/>5<br/>6<br/>7<br/>8<br/>9<br/>10<br/>11<br/>12<br/>13<br/>14<br/>15<br/>16<br/>17<br/>18<br/>19<br/>20<br/>21<br/>22<br/>23<br/>24<br/>25<br/>26<br/>27<br/>28<br/>29<br/>30<br/>31<br/>32<br/>33<br/>34<br/>35<br/>36<br/>37<br/>38<br/>39<br/>40<br/>41<br/>42<br/>43<br/>44<br/>45<br/>46<br/>47<br/>48<br/>49<br/>50<br/>51<br/>52<br/>53<br/>54<br/>55<br/>56<br/>57<br/>58<br/>59<br/>60<br/>61</td><td><pre><span class="html"><span class="php">&lt;?php

<span class="keyword">class</span> SimpleImage <span class="symbol">{</span>
 
   <span class="keyword">var</span> <span class="variable">$image</span><span class="symbol">;</span>
   <span class="keyword">var</span> <span class="variable">$image_type</span><span class="symbol">;</span>
   <span class="keyword">var</span> <span class="variable">$orgWidth</span><span class="symbol">;</span>
   <span class="keyword">var</span> <span class="variable">$orgHeight</span><span class="symbol">;</span>
 
   <span class="keyword">function</span> __construct<span class="symbol">(</span><span class="variable">$filename</span><span class="symbol">)</span> <span class="symbol">{</span>
 
      <span class="variable">$image_info</span> <span class="symbol">=</span> <a href="http://www.php.net/getimagesize" class="function">getimagesize</a><span class="symbol">(</span><span class="variable">$filename</span><span class="symbol">)</span><span class="symbol">;</span>
      <span class="variable">$this</span><span class="symbol">-&gt;</span>image_type <span class="symbol">=</span> <span class="variable">$image_info</span><span class="symbol">&#91;</span>2<span class="symbol">&#93;</span><span class="symbol">;</span>
      
      <span class="keyword">if</span><span class="symbol">(</span> <span class="variable">$this</span><span class="symbol">-&gt;</span>image_type <span class="symbol">==</span> IMAGETYPE_JPEG <span class="symbol">)</span> <span class="symbol">{</span>
 
         <span class="variable">$this</span><span class="symbol">-&gt;</span>image <span class="symbol">=</span> <a href="http://www.php.net/imagecreatefromjpeg" class="function">imagecreatefromjpeg</a><span class="symbol">(</span><span class="variable">$filename</span><span class="symbol">)</span><span class="symbol">;</span>
      <span class="symbol">}</span> <span class="keyword">elseif</span><span class="symbol">(</span> <span class="variable">$this</span><span class="symbol">-&gt;</span>image_type <span class="symbol">==</span> IMAGETYPE_GIF <span class="symbol">)</span> <span class="symbol">{</span>
 
         <span class="variable">$this</span><span class="symbol">-&gt;</span>image <span class="symbol">=</span> <a href="http://www.php.net/imagecreatefromgif" class="function">imagecreatefromgif</a><span class="symbol">(</span><span class="variable">$filename</span><span class="symbol">)</span><span class="symbol">;</span>
      <span class="symbol">}</span> <span class="keyword">elseif</span><span class="symbol">(</span> <span class="variable">$this</span><span class="symbol">-&gt;</span>image_type <span class="symbol">==</span> IMAGETYPE_PNG <span class="symbol">)</span> <span class="symbol">{</span>
 
         <span class="variable">$this</span><span class="symbol">-&gt;</span>image <span class="symbol">=</span> <a href="http://www.php.net/imagecreatefrompng" class="function">imagecreatefrompng</a><span class="symbol">(</span><span class="variable">$filename</span><span class="symbol">)</span><span class="symbol">;</span>
      <span class="symbol">}</span>
   <span class="symbol">}</span>
         
   <span class="keyword">function</span> output<span class="symbol">(</span><span class="symbol">)</span> <span class="symbol">{</span>
 
      <a href="http://www.php.net/imagejpeg" class="function">imagejpeg</a><span class="symbol">(</span><span class="variable">$this</span><span class="symbol">-&gt;</span>image<span class="symbol">)</span><span class="symbol">;</span>

   <span class="symbol">}</span>
   
   <span class="keyword">function</span> scale<span class="symbol">(</span><span class="variable">$scale</span><span class="symbol">)</span> <span class="symbol">{</span>
      <span class="variable">$this</span><span class="symbol">-&gt;</span>orgWidth <span class="symbol">=</span> <a href="http://www.php.net/imagesx" class="function">imagesx</a><span class="symbol">(</span><span class="variable">$this</span><span class="symbol">-&gt;</span>image<span class="symbol">)</span><span class="symbol">;</span>
         <span class="variable">$this</span><span class="symbol">-&gt;</span>orgHeight <span class="symbol">=</span> <a href="http://www.php.net/imagesy" class="function">imagesy</a><span class="symbol">(</span><span class="variable">$this</span><span class="symbol">-&gt;</span>image<span class="symbol">)</span><span class="symbol">;</span>      
                    
      <span class="variable">$width</span> <span class="symbol">=</span> <span class="variable">$this</span><span class="symbol">-&gt;</span>orgWidth <span class="symbol">*</span> <span class="variable">$scale</span><span class="symbol">/</span>100<span class="symbol">;</span>
      <span class="variable">$height</span> <span class="symbol">=</span> <span class="variable">$this</span><span class="symbol">-&gt;</span>orgHeight <span class="symbol">*</span> <span class="variable">$scale</span><span class="symbol">/</span>100<span class="symbol">;</span>
      <span class="variable">$this</span><span class="symbol">-&gt;</span>resize<span class="symbol">(</span><span class="variable">$width</span><span class="symbol">,</span><span class="variable">$height</span><span class="symbol">)</span><span class="symbol">;</span>
   <span class="symbol">}</span>
 
   <span class="keyword">function</span> resize<span class="symbol">(</span><span class="variable">$width</span><span class="symbol">,</span><span class="variable">$height</span><span class="symbol">)</span> <span class="symbol">{</span>
      <span class="variable">$new_image</span> <span class="symbol">=</span> <a href="http://www.php.net/imagecreatetruecolor" class="function">imagecreatetruecolor</a><span class="symbol">(</span><span class="variable">$width</span><span class="symbol">,</span> <span class="variable">$height</span><span class="symbol">)</span><span class="symbol">;</span>
      <a href="http://www.php.net/imagecopyresampled" class="function">imagecopyresampled</a><span class="symbol">(</span><span class="variable">$new_image</span><span class="symbol">,</span> <span class="variable">$this</span><span class="symbol">-&gt;</span>image<span class="symbol">,</span> 0<span class="symbol">,</span> 0<span class="symbol">,</span> 0<span class="symbol">,</span> 0<span class="symbol">,</span> <span class="variable">$width</span><span class="symbol">,</span> <span class="variable">$height</span><span class="symbol">,</span> <span class="variable">$this</span><span class="symbol">-&gt;</span>orgWidth<span class="symbol">,</span> <span class="variable">$this</span><span class="symbol">-&gt;</span>orgHeight<span class="symbol">)</span><span class="symbol">;</span>
      <span class="variable">$this</span><span class="symbol">-&gt;</span>image <span class="symbol">=</span> <span class="variable">$new_image</span><span class="symbol">;</span>
   <span class="symbol">}</span>       
 
<span class="symbol">}</span>

      <span class="variable">$image</span> <span class="symbol">=</span> <span class="keyword">new</span> SimpleImage<span class="symbol">(</span><span class="string single">'http://smbjorklund.no/sites/smbjorklund.no/files/pictures/1/apple_mac_os_x_10.5_leopard_1024x768_1.jpg'</span><span class="symbol">)</span><span class="symbol">;</span>
       <span class="variable">$image</span><span class="symbol">-&gt;</span>scale<span class="symbol">(</span>50<span class="symbol">)</span><span class="symbol">;</span>
       <span class="variable">$image</span><span class="symbol">-&gt;</span>output<span class="symbol">(</span><span class="symbol">)</span><span class="symbol">;</span>
       <span class="keyword">unset</span> <span class="symbol">(</span><span class="variable">$image</span><span class="symbol">)</span><span class="symbol">;</span>
       
<span class="comment">// tweede plaatje, deze doet het niet
</span>
      <span class="variable">$image1</span> <span class="symbol">=</span> <span class="keyword">new</span> SimpleImage<span class="symbol">(</span><span class="string single">'http://smbjorklund.no/sites/smbjorklund.no/files/pictures/1/snow-leopard1.jpg'</span><span class="symbol">)</span><span class="symbol">;</span>
       <span class="variable">$image1</span><span class="symbol">-&gt;</span>scale<span class="symbol">(</span>50<span class="symbol">)</span><span class="symbol">;</span>
       <span class="variable">$image1</span><span class="symbol">-&gt;</span>output<span class="symbol">(</span><span class="symbol">)</span><span class="symbol">;</span>
       <span class="keyword">unset</span> <span class="symbol">(</span><span class="variable">$image1</span><span class="symbol">)</span><span class="symbol">;</span>
  ?&gt;</span></span></pre></td></tr></table>]]></description>
		<pubDate>Sun, 05 Feb 2012 12:50:18 +0000</pubDate>
		<guid>http://www.pfz.nl/forum/topic/6781-output-imagejpeg/</guid>
	</item>
	<item>
		<title><![CDATA[[opgelost] php/mysql: Selecteer de rij die het laatste is gebruikt]]></title>
		<link>http://www.pfz.nl/forum/topic/6777-opgelost-phpmysql-selecteer-de-rij-die-het-laatste-is-gebruikt/</link>
		<description><![CDATA[Goede middag,<br />
<br />
Is het volgende mogelijk (denk het haast wel) en zo ja hoe?<br />
<br />
Ik maak een tabel aan met:<br />
<br />
id<br />
tekst<br />
laatst gebruikt<br />
<br />
In het veld laatst gebruikt staat de datum in seconden vanaf 1970 (opgeslagen met de functie time)<br />
<br />
Nu wil ik met php mijn tabel aanroepen, kijken welk veld het laatste is gebruikt in het verleden en die dan tonen.<br />
<br />
Ik hen eigenlijk geen idee hoe ik dat voor elkaar moet krijgen dus hopelijk kunnen jullie me opweg helpen?<br />
<br />
Gr<br />
<br />
Marko]]></description>
		<pubDate>Sat, 04 Feb 2012 15:03:02 +0000</pubDate>
		<guid>http://www.pfz.nl/forum/topic/6777-opgelost-phpmysql-selecteer-de-rij-die-het-laatste-is-gebruikt/</guid>
	</item>
	<item>
		<title>Sessions werken niet meer in PHP5.3 nog wel in php5.1</title>
		<link>http://www.pfz.nl/forum/topic/6774-sessions-werken-niet-meer-in-php53-nog-wel-in-php51/</link>
		<description><![CDATA[Doorgeven van sessionvariabelen wat wel goed werkte onder php5.1 werkt niet meer onder php5.3. Heeft dat te maken met het default instellen van session_use_only_cookies in 5.3? <br />
<br />
Indien ja, hoe kan ik dat uitzetten zonder de php.ini te moeten wijzigen (want daar kan ik momenteel niet bij).]]></description>
		<pubDate>Fri, 03 Feb 2012 20:46:08 +0000</pubDate>
		<guid>http://www.pfz.nl/forum/topic/6774-sessions-werken-niet-meer-in-php53-nog-wel-in-php51/</guid>
	</item>
	<item>
		<title>Join op twee tabellen</title>
		<link>http://www.pfz.nl/forum/topic/6773-join-op-twee-tabellen/</link>
		<description><![CDATA[Goedenavond,<br />
<br />
Ik ben bezig met het maken van een klein eigen cms systeempje. In princiepe werkt alles, alleen bij het ophalen van gegevens uit de database loop ik tegen een probleem op.<br />
<br />
Zo ziet mijn database eruit: <br />
<br />
tabel portfolio:<br />
<br />
id<br />
titel<br />
tekst<br />
<br />
<br />
tabel images:<br />
<br />
id<br />
portid<br />
link<br />
<br />
Bij elke tekst in tabel portfolio zitten een of meerdere plaatjes. (De bedoeling is om deze in een slider te laden).<br />
<br />
Om de tekst met de daarbij behorende plaatjes uit de database te halen heb ik de volgende Sql statement geschreven:<br />
<br />
<table class="highlight" cellspacing="0"><tr><td class="line-numbers">1</td><td><pre><span style="color:#993333;font-weight:bold;">SELECT</span><span style="color:#000000;"> portfolio</span><span style="color:#008800;">.</span><span style="color:#000000;">titel</span><span style="color:#008800;">,</span><span style="color:#000000;"> portfolio</span><span style="color:#008800;">.</span><span style="color:#000000;">tekst</span><span style="color:#008800;">,</span><span style="color:#000000;"> images</span><span style="color:#008800;">.</span><span style="color:#000000;">link </span><span style="color:#993333;font-weight:bold;">FROM</span><span style="color:#000000;"> portfolio </span><span style="color:#993333;font-weight:bold;">INNER JOIN</span><span style="color:#000000;"> images </span><span style="color:#993333;font-weight:bold;">ON</span><span style="color:#000000;"> portfolio</span><span style="color:#008800;">.</span><span style="color:#000000;">id</span><span style="color:#008800;">=</span><span style="color:#000000;">images</span><span style="color:#008800;">.</span><span style="color:#000000;">portid</span></pre></td></tr></table><br />
<br />
Dit uitvoeren gaat prima. Het probleem treed op als een tekst meerdere plaatjes heeft.<br />
<br />
bijv:<br />
<br />
tabel portfolio:<br />
<br />
id =  2<br />
titel = titel van mijn tekst<br />
tekst = een heel verhaal over hoe leuk pfz is<br />
<br />
tabel images:<br />
<br />
id = 4 (autoincre)<br />
portid = 2 <br />
link = images/plaatje1.jpg<br />
<br />
id = 5 (autoincre)<br />
portid = 2 <br />
link = images/plaatje2.jpg<br />
<br />
als ik dit uit de BD haal krijg ik:<br />
<br />
titel = titel van mijn tekst<br />
tekst = een heel verhaal over hoe leuk pfz is<br />
link = images/plaatje1.jpg<br />
<br />
---------------------------------------------------------<br />
titel = titel van mijn tekst<br />
tekst = een heel verhaal over hoe leuk pfz is<br />
link = images/plaatje2.jpg<br />
<br />
<br />
Wat ik wil is: <br />
<br />
titel = titel van mijn tekst<br />
tekst = een heel verhaal over hoe leuk pfz is<br />
link = images/plaatje1.jpg<br />
link = images/plaatje2.jpg<br />
<br />
is dit mogelijk ? <br />
<br />
Alvast bedankt!<br />
<br />
Met vriendelijke groet,<br />
<br />
Mike]]></description>
		<pubDate>Fri, 03 Feb 2012 18:49:35 +0000</pubDate>
		<guid>http://www.pfz.nl/forum/topic/6773-join-op-twee-tabellen/</guid>
	</item>
	<item>
		<title>htaccess icm post waardes</title>
		<link>http://www.pfz.nl/forum/topic/6771-htaccess-icm-post-waardes/</link>
		<description><![CDATA[IK heb hier eerder al <a href='http://www.pfz.nl/forum/topic/6323-htaccess-blokeerd-mijn-post-waardes/' class='bbc_url' title='Externe link ' rel='nofollow external'>een topic</a> over gehad.<br />
Echter ben ik ondanks weer verder gegaan met dit project, en heb dit probleem nog steeds.<br />
<br />
<br />
"Ik ben momenteel bezig met een site waarin in htaccess gebruik.<br />
Echter blokeerd om een of andere rede de Rewrite Rule de POST data.<br />
Als ik bij een form op submit drukt geeft hij de waardes niet door, deze blijven leeg.<br />
Is er iemand hier die hier ervaring mee heeft, of die weet hoe dit mogelijk komt?<br />
<br />
.htaccess:<br />
<table class="highlight source" cellspacing="0"><tr><td class="line-numbers">1<br/>2<br/>3<br/>4<br/>5<br/>6</td><td><pre><span class="html">Options FollowSymLinks MultiViews

RewriteEngine On
RewriteCond %{REQUEST_URI} !style.css
RewriteCond %{REQUEST_URI} !/beheer
RewriteRule ^(&#91;^/&#93;+)$ index/$1 &#91;NC,L&#93;</span></pre></td></tr></table><br />
"<br />
<br />
<strong class='bbc'>Mod-edit</strong>: Voor de duidelijkheid en achtergrondinfo link naar vorige topic toegevoegd.]]></description>
		<pubDate>Fri, 03 Feb 2012 17:47:23 +0000</pubDate>
		<guid>http://www.pfz.nl/forum/topic/6771-htaccess-icm-post-waardes/</guid>
	</item>
	<item>
		<title>datum met tijd in de database opslaan als datum</title>
		<link>http://www.pfz.nl/forum/topic/6769-datum-met-tijd-in-de-database-opslaan-als-datum/</link>
		<description><![CDATA[ik krijg via een sql bestand een veld binnen als 19-1-2012 17:50 of 17-11-2012 0:00.<br />
Als datum + tijd dus.<br />
In de database heb ik een veld datum als jjjj-mm-dd.<br />
<br />
Nu wil ik 19-1-2012 17:50 opslaan als 2012-01-19.<br />
<br />
Hoe moet ik dat doen?????]]></description>
		<pubDate>Fri, 03 Feb 2012 17:25:43 +0000</pubDate>
		<guid>http://www.pfz.nl/forum/topic/6769-datum-met-tijd-in-de-database-opslaan-als-datum/</guid>
	</item>
	<item>
		<title>PHPMailer verstuurd teveel/onregelmatig mails</title>
		<link>http://www.pfz.nl/forum/topic/6768-phpmailer-verstuurd-teveelonregelmatig-mails/</link>
		<description><![CDATA[Ik gebruik voor een roostersysteem de PHPmailer class. Op een pagina wordt een ruilverzoek ingevuld, en als dat afgerond is dan wordt er 1 mail naar de afdelingsleider gestuurd. Deze kan dan het ruilverzoek accepteren. Als dit geaccepteerd wordt, dan klikt deze afdelingsleider op een andere link, en een andere pagina is dus verantwoordelijk voor het op de hoogte stellen van de betrokken gebruikers, om dus te vertellen dat het ruilverzoek geaccepteerd is.<br />
<br />
Het probleem is nu als volgt:<br />
In al mijn gegevens uit databases blijkt dat het ruilverzoek maar een keer is ingevoerd en is geaccepteerd. Toch heeft de afdelingsleider opeens twee mails ontvangen, met een tijdstip van een kwartier daartussen. Nog vreemder is dat de betrokken gebruikers beide vijf mails hebben ontvangen! Twee om 12:05, een om 12:45 en twee om 13:10.<br />
<br />
Dit terwijl de afdelingsleider maar 1 mail hoort te krijgen, en de betrokken gebruikers allen maar 1 mail.<br />
<br />
Ik ben het spoor bijster. Hoe kan het gebeuren dat de PHPMailer class meerdere en via een onregelmatig patroon een eigen leven leidt? Vreemd is dat dit nog maar 1 keer is voorgekomen, verder werkt alles prima en hoor ik geen klachten van de gebruikers. <br />
<br />
Alvast bedankt,<br />
Vriendelijke groet,<br />
Jon<br />
<br />
P.S. En misschien ontdek ik het probleem of de oorzaak nooit, maar is er dan misschien iets om dit te kunnen voorkomen?]]></description>
		<pubDate>Fri, 03 Feb 2012 15:23:18 +0000</pubDate>
		<guid>http://www.pfz.nl/forum/topic/6768-phpmailer-verstuurd-teveelonregelmatig-mails/</guid>
	</item>
	<item>
		<title>Zip bestand met wachtwoord via ziparchive</title>
		<link>http://www.pfz.nl/forum/topic/6766-zip-bestand-met-wachtwoord-via-ziparchive/</link>
		<description><![CDATA[Hallo mensen,<br />
<br />
We hebben nu uiteindelijk ziparchive online gekregen in Apache.<br />
De code werkt nu wel. Alleen nu staat er ook een wachtwoord in het zip bestand.<br />
Kun je dat ook in deze code kwijt?<br />
<br />
Dit werkt:<br />
<table class="highlight source" cellspacing="0"><tr><td class="line-numbers">1<br/>2<br/>3<br/>4<br/>5<br/>6<br/>7<br/>8<br/>9<br/>10</td><td><pre><span class="php"><span class="html"><span class="php">&lt;?PHP
<span class="variable">$zip</span> <span class="symbol">=</span> <span class="keyword">new</span> ZipArchive<span class="symbol">;</span>
<span class="keyword">if</span> <span class="symbol">(</span><span class="variable">$zip</span><span class="symbol">-&gt;</span>open<span class="symbol">(</span><span class="string single">'$file1'</span><span class="symbol">)</span> <span class="symbol">===</span> TRUE<span class="symbol">)</span> <span class="symbol">{</span>
    <span class="variable">$zip</span><span class="symbol">-&gt;</span>extractTo<span class="symbol">(</span><span class="string single">'../'</span><span class="symbol">)</span><span class="symbol">;</span>
    <span class="variable">$zip</span><span class="symbol">-&gt;</span>close<span class="symbol">(</span><span class="symbol">)</span><span class="symbol">;</span>
    <span class="keyword">echo</span> <span class="string single">'Gelukt!!'</span><span class="symbol">;</span>
<span class="symbol">}</span> <span class="keyword">else</span> <span class="symbol">{</span>
    <span class="keyword">echo</span> <span class="string single">'failed'</span><span class="symbol">;</span>
<span class="symbol">}</span>
?&gt;</span></span></span></pre></td></tr></table><br />
<br />
Dit mag niet wegens een beveiliging op onze server:<br />
<table class="highlight source" cellspacing="0"><tr><td class="line-numbers">1</td><td><pre><span class="php"><span class="html"><span class="php"><a href="http://www.php.net/system" class="function">system</a><span class="symbol">(</span><span class="string double">"`which unzip` -P Password $zipfile -d $des"</span><span class="symbol">,</span><span class="variable">$ret_val</span><span class="symbol">)</span></span></span></span></pre></td></tr></table><br />
Bron: <a href='http://php.net/manual/en/ref.zip.php' class='bbc_url' title='Externe link ' rel='nofollow external'>http://php.net/manual/en/ref.zip.php</a><br />
<br />
Hoe kunnen we wel een zip bestand openen met wachtwoord?]]></description>
		<pubDate>Fri, 03 Feb 2012 13:05:26 +0000</pubDate>
		<guid>http://www.pfz.nl/forum/topic/6766-zip-bestand-met-wachtwoord-via-ziparchive/</guid>
	</item>
	<item>
		<title>verwerken van een csv gaat fout als er een quote in de tekst voor komt</title>
		<link>http://www.pfz.nl/forum/topic/6765-verwerken-van-een-csv-gaat-fout-als-er-een-quote-in-de-tekst-voor-komt/</link>
		<description><![CDATA[Na veel zoeken heb ik een php programma gemaakt om de gegevens vanuit een csv bestand in te lezen en die te gaan verwerken in mijn database.<br />
Als er in een tekstveld een single quote (') voor komt dan loopt het programma in een abend.<br />
Weet iemand wat daar de oplossing voor is?<br />
 <br />
Voorbeeld van mijn php programma:<br />
&lt;?php<br />
include("config.php");<br />
<br />
$row = 0; <br />
if (($handle = fopen("bestand.csv", "r")) !== FALSE) <br />
{ <br />
  // eerst halen we de eerste regel op, daar staan de kopteksten en daar doen we niets mee: <br />
  $data = fgetcsv($handle, 10, ";"); <br />
 <br />
  // nu de detailregel(s) ophalen <br />
  while (($data = fgetcsv($handle, 1000, ";")) !== FALSE)<br />
  { <br />
    // tel hoeveel kolommen we hebben gekregen. <br />
    $num = count($data); <br />
    $row++; <br />
	   <br />
	$query = "UPDATE tabelnaam<br />
				SET tabelveld1 = '$data[4]',<br />
				      tabalveld2 = '$data[1]',<br />
				      tabelveld3 = '$data[0]',<br />
 				WHERE tabelveld4 = '$data[2]' ";<br />
	mysql_query($query) or die(mysql_error());<br />
     } <br />
  fclose($handle); <br />
} <br />
mysql_close();<br />
?&gt;]]></description>
		<pubDate>Fri, 03 Feb 2012 12:44:56 +0000</pubDate>
		<guid>http://www.pfz.nl/forum/topic/6765-verwerken-van-een-csv-gaat-fout-als-er-een-quote-in-de-tekst-voor-komt/</guid>
	</item>
	<item>
		<title>resize picture</title>
		<link>http://www.pfz.nl/forum/topic/6764-resize-picture/</link>
		<description><![CDATA[Ik zou graag het volgende willen. Ik heb een link dit plaatje moet kleiner gemaakt worden. Ik heb daarvoor deze code.<br />
<br />
<table class="highlight source" cellspacing="0"><tr><td class="line-numbers">1<br/>2<br/>3<br/>4<br/>5<br/>6<br/>7<br/>8<br/>9<br/>10<br/>11<br/>12<br/>13<br/>14<br/>15<br/>16<br/>17<br/>18<br/>19<br/>20<br/>21<br/>22<br/>23<br/>24<br/>25</td><td><pre><span class="html"><span class="php">&lt;?php
<span class="comment">// The file
</span><span class="variable">$filename</span> <span class="symbol">=</span> <span class="string single">'http://static.php.net/www.php.net/images/php.gif'</span><span class="symbol">;</span>
<span class="variable">$percent</span> <span class="symbol">=</span> 0<span class="symbol">.</span>5<span class="symbol">;</span>

<span class="comment">// Content type
</span><a href="http://www.php.net/header" class="function">header</a><span class="symbol">(</span><span class="string single">'Content-Type: image/jpeg'</span><span class="symbol">)</span><span class="symbol">;</span>

<span class="comment">// Get new dimensions
</span><span class="keyword">list</span><span class="symbol">(</span><span class="variable">$width</span><span class="symbol">,</span> <span class="variable">$height</span><span class="symbol">)</span> <span class="symbol">=</span> <a href="http://www.php.net/getimagesize" class="function">getimagesize</a><span class="symbol">(</span><span class="variable">$filename</span><span class="symbol">)</span><span class="symbol">;</span>
<span class="variable">$new_width</span> <span class="symbol">=</span> <span class="variable">$width</span> <span class="symbol">*</span> <span class="variable">$percent</span><span class="symbol">;</span>
<span class="variable">$new_height</span> <span class="symbol">=</span> <span class="variable">$height</span> <span class="symbol">*</span> <span class="variable">$percent</span><span class="symbol">;</span>

<span class="comment">// Resample
</span><span class="variable">$image_p</span> <span class="symbol">=</span> <a href="http://www.php.net/imagecreatetruecolor" class="function">imagecreatetruecolor</a><span class="symbol">(</span><span class="variable">$new_width</span><span class="symbol">,</span> <span class="variable">$new_height</span><span class="symbol">)</span><span class="symbol">;</span>
<span class="variable">$image</span> <span class="symbol">=</span> <a href="http://www.php.net/imagecreatefromgif" class="function">imagecreatefromgif</a><span class="symbol">(</span><span class="variable">$filename</span><span class="symbol">)</span><span class="symbol">;</span>
<a href="http://www.php.net/imagecopyresampled" class="function">imagecopyresampled</a><span class="symbol">(</span><span class="variable">$image_p</span><span class="symbol">,</span> <span class="variable">$image</span><span class="symbol">,</span> 0<span class="symbol">,</span> 0<span class="symbol">,</span> 0<span class="symbol">,</span> 0<span class="symbol">,</span> <span class="variable">$new_width</span><span class="symbol">,</span> <span class="variable">$new_height</span><span class="symbol">,</span> <span class="variable">$width</span><span class="symbol">,</span> <span class="variable">$height</span><span class="symbol">)</span><span class="symbol">;</span>

<span class="comment">// Output
</span>
<span class="comment">#echo 'hier wordt niet ge-echot';
</span>
<a href="http://www.php.net/imagejpeg" class="function">imagejpeg</a><span class="symbol">(</span><span class="variable">$image_p</span><span class="symbol">,</span> null<span class="symbol">,</span> 100<span class="symbol">)</span><span class="symbol">;</span>

?&gt;</span></span></pre></td></tr></table><br />
<br />
Hij doet het maar wanneer ik iet wil echo-en  waar  ‘#echo 'hier wordt niet ge-echot'; staat dan werkt mijn scriptje niet meer. Hoe kan ik dit oplossen. <br />
Dan heb ik nog een tweede vraag. Als ik het plaatje kleiner heb weer gegeven zo als ik wil op mijn pagina, moet de bezoeker die hem heeft ingevoerd,hem goed keuren zodat hij vervolgens wordt opgeslagen. Hoe kan ik het dan al verkleinde plaatje opslaan??]]></description>
		<pubDate>Fri, 03 Feb 2012 11:45:53 +0000</pubDate>
		<guid>http://www.pfz.nl/forum/topic/6764-resize-picture/</guid>
	</item>
	<item>
		<title>Sessie met meer informatie</title>
		<link>http://www.pfz.nl/forum/topic/6763-sessie-met-meer-informatie/</link>
		<description><![CDATA[Ik heb onderstaande sessie:<br />
<br />
<table class="highlight source" cellspacing="0"><tr><td class="line-numbers">1<br/>2<br/>3<br/>4<br/>5<br/>6<br/>7<br/>8<br/>9<br/>10<br/>11<br/>12<br/>13<br/>14</td><td><pre><span class="php"><span class="html"><span class="php">&lt;?php
<a href="http://www.php.net/session_start" class="function">session_start</a><span class="symbol">(</span><span class="symbol">)</span><span class="symbol">;</span>
<span class="variable">$sessionid</span> <span class="symbol">=</span> <a href="http://www.php.net/session_id" class="function">session_id</a><span class="symbol">(</span><span class="symbol">)</span><span class="symbol">;</span> 

<span class="comment">// Toevoegen
</span><span class="keyword">if</span> <span class="symbol">(</span> <span class="keyword">isset</span><span class="symbol">(</span><span class="variable">$_POST</span><span class="symbol">&#91;</span><span class="string single">'verzenden'</span><span class="symbol">&#93;</span> <span class="symbol">)</span> <span class="symbol">&</span><span class="symbol">&</span> <a href="http://www.php.net/preg_match" class="function">preg_match</a><span class="symbol">(</span><span class="string single">'^&#91;1-9&#93;&#91;0-9&#93;*$^'</span><span class="symbol">,</span> <span class="variable">$_POST</span><span class="symbol">&#91;</span><span class="string single">'aantal'</span><span class="symbol">&#93;</span><span class="symbol">)</span><span class="symbol">)</span> <span class="symbol">{</span>
<span class="variable">$_SESSION</span><span class="symbol">&#91;</span><span class="string single">'winkelwagen'</span><span class="symbol">&#93;</span><span class="symbol">&#91;</span><span class="variable">$_POST</span><span class="symbol">&#91;</span><span class="string single">'itemid'</span><span class="symbol">&#93;</span><span class="symbol">&#93;</span><span class="symbol">=</span> <span class="variable">$_POST</span><span class="symbol">&#91;</span><span class="string single">'aantal'</span><span class="symbol">&#93;</span><span class="symbol">;</span>
<span class="symbol">}</span>

<span class="comment">// Verwijderen 
</span><span class="keyword">if</span><span class="symbol">(</span> <span class="keyword">isset</span><span class="symbol">(</span> <span class="variable">$_GET</span><span class="symbol">&#91;</span><span class="string single">'DEL'</span><span class="symbol">&#93;</span> <span class="symbol">)</span> <span class="symbol">)</span> <span class="symbol">{</span> 
    <span class="keyword">unset</span><span class="symbol">(</span><span class="variable">$_SESSION</span><span class="symbol">&#91;</span><span class="string single">'winkelwagen'</span><span class="symbol">&#93;</span><span class="symbol">&#91;</span><span class="variable">$_GET</span><span class="symbol">&#91;</span><span class="string single">'DEL'</span><span class="symbol">&#93;</span><span class="symbol">&#93;</span><span class="symbol">)</span><span class="symbol">;</span> 
<span class="symbol">}</span> 
 ?&gt;</span></span></span></pre></td></tr></table><br />
<br />
Maar nu wil ik er nog de extra sessie "PRIJS" in hebben? hoe moet ik dat doen?]]></description>
		<pubDate>Fri, 03 Feb 2012 11:44:29 +0000</pubDate>
		<guid>http://www.pfz.nl/forum/topic/6763-sessie-met-meer-informatie/</guid>
	</item>
	<item>
		<title>Timestamp op basis van jaar, weeknummer en weekdag</title>
		<link>http://www.pfz.nl/forum/topic/6761-timestamp-op-basis-van-jaar-weeknummer-en-weekdag/</link>
		<description><![CDATA[Hallo,<br />
<br />
Voor een systeem wat ik bouw zou ik graag een functie willen maken die op basis van jaar, weeknummer en dag van de week (0-6) een timestamp ophaalt (die ik vervolgens weer kan converteren naar een datum.<br />
<br />
Ik weet dat het omgekeerde wel mogelijk is, maar kan dit ook?<br />
<br />
<table class="highlight source" cellspacing="0"><tr><td class="line-numbers">1<br/>2<br/>3</td><td><pre><span class="php"><span class="html"><span class="php">    <span class="keyword">public</span> <span class="keyword">function</span> weekdayToDate<span class="symbol">(</span><span class="variable">$year</span><span class="symbol">,</span> <span class="variable">$week</span><span class="symbol">,</span> <span class="variable">$day</span><span class="symbol">)</span><span class="symbol">{</span>
        <span class="comment">// Conversie hier
</span>    <span class="symbol">}</span></span></span></span></pre></td></tr></table>]]></description>
		<pubDate>Fri, 03 Feb 2012 09:29:48 +0000</pubDate>
		<guid>http://www.pfz.nl/forum/topic/6761-timestamp-op-basis-van-jaar-weeknummer-en-weekdag/</guid>
	</item>
	<item>
		<title><![CDATA[Operating System Mobile Phone's.]]></title>
		<link>http://www.pfz.nl/forum/topic/6760-operating-system-mobile-phones/</link>
		<description><![CDATA[He Jongens,<br />
<br />
Ben bezig met een nieuw project, en dat is zoals MyIP sites dat je alles kan zien. Alleen wil ik het verder uitbreiden dan alleen je IP.. Ik wil proberen zoveel mogelijk gegevens te achterhalen die alleen de bezoeker van de pagina kan zien uiteraard. Dit omdat ik een zoort helpdesk site wil gaan maken. Maar nu het probleem dus dat ik Mobile Phones niet correct krijg, aldus de Andriod word weer gegeven met Linux als Operating System. Weet iemand dat te veranderen?, en heb je toevalig de juiste code search term er voor?.<br />
<br />
Dit is momenteel mijn lijst met Operating Systems.<br />
<br />
<table class="highlight source" cellspacing="0"><tr><td class="line-numbers">1<br/>2<br/>3<br/>4<br/>5<br/>6<br/>7<br/>8<br/>9<br/>10<br/>11<br/>12<br/>13<br/>14<br/>15<br/>16<br/>17<br/>18<br/>19<br/>20<br/>21<br/>22<br/>23<br/>24<br/>25<br/>26<br/>27<br/>28<br/>29<br/>30<br/>31<br/>32<br/>33<br/>34<br/>35<br/>36<br/>37<br/>38<br/>39<br/>40<br/>41<br/>42<br/>43<br/>44<br/>45<br/>46<br/>47<br/>48<br/>49</td><td><pre><span class="php"><span class="html"><span class="php">    <span class="keyword">function</span> users_real_os<span class="symbol">(</span><span class="symbol">)</span>
        <span class="symbol">{</span>
            <span class="variable">$osList</span> <span class="symbol">=</span> <span class="keyword">array</span><span class="symbol">(</span> <span class="string single">'Windows 7'</span> <span class="symbol">=&gt;</span> <span class="string single">'windows nt 6.1'</span><span class="symbol">,</span>
                             <span class="string single">'Windows Vista'</span> <span class="symbol">=&gt;</span> <span class="string single">'windows nt 6.0'</span><span class="symbol">,</span>
                             <span class="string single">'Windows Server 2003'</span> <span class="symbol">=&gt;</span> <span class="string single">'windows nt 5.2'</span><span class="symbol">,</span>
                             <span class="string single">'Windows XP'</span> <span class="symbol">=&gt;</span> <span class="string single">'windows nt 5.1'</span><span class="symbol">,</span>
                             <span class="string single">'Windows 2000 sp1'</span> <span class="symbol">=&gt;</span> <span class="string single">'windows nt 5.01'</span><span class="symbol">,</span>
                             <span class="string single">'Windows 2000'</span> <span class="symbol">=&gt;</span> <span class="string single">'windows nt 5.0'</span><span class="symbol">,</span>
                             <span class="string single">'Windows NT 4.0'</span> <span class="symbol">=&gt;</span> <span class="string single">'windows nt 4.0'</span><span class="symbol">,</span>
                             <span class="string single">'Windows ME'</span> <span class="symbol">=&gt;</span> <span class="string single">'win 9x 4.9'</span><span class="symbol">,</span>
                             <span class="string single">'Windows 98'</span> <span class="symbol">=&gt;</span> <span class="string single">'windows 98'</span><span class="symbol">,</span>
                             <span class="string single">'Windows 95'</span> <span class="symbol">=&gt;</span> <span class="string single">'windows 95'</span><span class="symbol">,</span>
                             <span class="string single">'Windows CE'</span> <span class="symbol">=&gt;</span> <span class="string single">'windows ce'</span><span class="symbol">,</span>
                             <span class="string single">'Windows (Version Unknown)'</span> <span class="symbol">=&gt;</span> <span class="string single">'windows'</span><span class="symbol">,</span>
                             <span class="string single">'OpenBSD'</span> <span class="symbol">=&gt;</span> <span class="string single">'openbsd'</span><span class="symbol">,</span>
                             <span class="string single">'SunOS'</span> <span class="symbol">=&gt;</span> <span class="string single">'sunos'</span><span class="symbol">,</span>
                             <span class="string single">'Ubuntu'</span> <span class="symbol">=&gt;</span> <span class="string single">'ubuntu'</span><span class="symbol">,</span>
                             <span class="string single">'Linux'</span> <span class="symbol">=&gt;</span> <span class="string single">'(linux)|(x11)'</span><span class="symbol">,</span>
                             <span class="string single">'Mac OSX Beta(Kodiak)'</span> <span class="symbol">=&gt;</span> <span class="string single">'mac os x beta'</span><span class="symbol">,</span>
                             <span class="string single">'Mac OSX Cheetah'</span> <span class="symbol">=&gt;</span> <span class="string single">'mac os x 10.0'</span><span class="symbol">,</span>
                             <span class="string single">'Mac OSX Puma'</span> <span class="symbol">=&gt;</span> <span class="string single">'mac os x 10.1'</span><span class="symbol">,</span>
                             <span class="string single">'Mac OSX Jaguar'</span> <span class="symbol">=&gt;</span> <span class="string single">'mac os x 10.2'</span><span class="symbol">,</span>
                             <span class="string single">'Mac OSX Panther'</span> <span class="symbol">=&gt;</span> <span class="string single">'mac os x 10.3'</span><span class="symbol">,</span>
                             <span class="string single">'Mac OSX Tiger'</span> <span class="symbol">=&gt;</span> <span class="string single">'mac os x 10.4'</span><span class="symbol">,</span>
                             <span class="string single">'Mac OSX Leopard'</span> <span class="symbol">=&gt;</span> <span class="string single">'mac os x 10.5'</span><span class="symbol">,</span>
                             <span class="string single">'Mac OSX Snow Leopard'</span> <span class="symbol">=&gt;</span> <span class="string single">'mac os x 10.6'</span><span class="symbol">,</span>
                             <span class="string single">'Mac OSX Lion'</span> <span class="symbol">=&gt;</span> <span class="string single">'mac os x 10.7'</span><span class="symbol">,</span>
                             <span class="string single">'Mac OSX (Version Unknown)'</span> <span class="symbol">=&gt;</span> <span class="string single">'mac os x'</span><span class="symbol">,</span>
                             <span class="string single">'Mac OS (Classic)'</span> <span class="symbol">=&gt;</span> <span class="string single">'(mac_powerpc)|(macintosh)'</span><span class="symbol">,</span>
                             <span class="string single">'QNX'</span> <span class="symbol">=&gt;</span> <span class="string single">'QNX'</span><span class="symbol">,</span>
                             <span class="string single">'OS2'</span> <span class="symbol">=&gt;</span> <span class="string single">'beos'</span><span class="symbol">,</span>
                             <span class="string single">'Android'</span> <span class="symbol">=&gt;</span> <span class="string single">'android'</span><span class="symbol">,</span> <span class="comment">// Output = Linux
</span>                             <span class="string single">'BlackBerry'</span> <span class="symbol">=&gt;</span> <span class="string single">'blackberry'</span><span class="symbol">,</span> <span class="comment">// Output = Weet ik niet
</span>                             <span class="string single">'iPhone'</span> <span class="symbol">=&gt;</span> <span class="string single">'iphone'</span><span class="symbol">,</span> <span class="comment">// Output = Weet ik niet
</span>                             <span class="string single">'Palm'</span> <span class="symbol">=&gt;</span> <span class="string single">'palm'</span><span class="symbol">,</span> <span class="comment">// Output = Weet ik niet
</span>                             <span class="string single">'SearchBot'</span> <span class="symbol">=&gt;</span> <span class="string single">'(nuhk)|(googlebot)|(yammybot)|(openbot)|(slurp)|(msnbot)|(ask jeeves/teoma)|(ia_archiver)'</span><span class="symbol">)</span><span class="symbol">;</span>
            
            <span class="variable">$useragent</span> <span class="symbol">=</span> <span class="variable">$_SERVER</span><span class="symbol">&#91;</span><span class="string single">'HTTP_USER_AGENT'</span><span class="symbol">&#93;</span><span class="symbol">;</span>
            <span class="variable">$useragent</span> <span class="symbol">=</span> <a href="http://www.php.net/strtolower" class="function">strtolower</a><span class="symbol">(</span><span class="variable">$useragent</span><span class="symbol">)</span><span class="symbol">;</span>
            
            <span class="keyword">foreach</span><span class="symbol">(</span><span class="variable">$osList</span> <span class="keyword">as</span> <span class="variable">$os</span><span class="symbol">=&gt;</span><span class="variable">$match</span><span class="symbol">)</span> <span class="symbol">{</span>
                <span class="keyword">if</span><span class="symbol">(</span><a href="http://www.php.net/preg_match" class="function">preg_match</a><span class="symbol">(</span><span class="string single">'/'</span> <span class="symbol">.</span> <span class="variable">$match</span> <span class="symbol">.</span> <span class="string single">'/i'</span><span class="symbol">,</span> <span class="variable">$useragent</span><span class="symbol">)</span><span class="symbol">)</span> <span class="symbol">{</span>
                    <span class="keyword">break</span><span class="symbol">;</span>
                <span class="symbol">}</span> <span class="keyword">else</span> <span class="symbol">{</span>
                    <span class="variable">$os</span> <span class="symbol">=</span> <span class="string single">'Not automatically detected. '</span> <span class="symbol">.</span> <span class="variable">$useragent</span> <span class="symbol">.</span> <span class="string single">' '</span><span class="symbol">;</span>
                <span class="symbol">}</span>
            <span class="symbol">}</span>
            <span class="keyword">return</span> <span class="variable">$os</span><span class="symbol">;</span>
        <span class="symbol">}</span></span></span></span></pre></td></tr></table>]]></description>
		<pubDate>Fri, 03 Feb 2012 01:00:02 +0000</pubDate>
		<guid>http://www.pfz.nl/forum/topic/6760-operating-system-mobile-phones/</guid>
	</item>
	<item>
		<title>Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /checklogin.php on line 35</title>
		<link>http://www.pfz.nl/forum/topic/6759-warning-mysql-fetch-assoc-expects-parameter-1-to-be-resource-boolean-given-in-checkloginphp-on-line-35/</link>
		<description><![CDATA[Oke ik heb dus een login script... Het werkte eerst raargenoeg wel maar nu dus niet meer... En ik heb niets veranderd denk ik...<br />
Dit is mijn code:<br />
<table class="highlight source" cellspacing="0"><tr><td class="line-numbers">1<br/>2<br/>3<br/>4<br/>5<br/>6<br/>7<br/>8<br/>9<br/>10<br/>11<br/>12<br/>13<br/>14<br/>15<br/>16<br/>17<br/>18<br/>19<br/>20<br/>21<br/>22<br/>23<br/>24<br/>25<br/>26<br/>27<br/>28<br/>29<br/>30<br/>31<br/>32<br/>33<br/>34<br/>35<br/>36<br/>37<br/>38<br/>39<br/>40<br/>41<br/>42<br/>43<br/>44<br/>45<br/>46<br/>47<br/>48<br/>49<br/>50<br/>51<br/>52<br/>53<br/>54<br/>55<br/>56<br/>57<br/>58<br/>59<br/>60<br/>61</td><td><pre><span class="php"><span class="html"><span class="php">&lt;?php

<span class="variable">$host</span><span class="symbol">=</span><span class="string double">"188.138.79.5"</span><span class="symbol">;</span> <span class="comment">// Host name 
</span><span class="variable">$username</span><span class="symbol">=</span><span class="string double">"****"</span><span class="symbol">;</span> <span class="comment">// Mysql username 
</span><span class="variable">$password</span><span class="symbol">=</span><span class="string double">"****"</span><span class="symbol">;</span> <span class="comment">// Mysql password 
</span><span class="variable">$db_name</span><span class="symbol">=</span><span class="string double">"johan_Mysql"</span><span class="symbol">;</span> <span class="comment">// Database name 
</span><span class="variable">$tbl_name</span><span class="symbol">=</span><span class="string double">"Users"</span><span class="symbol">;</span> <span class="comment">// Table name
</span>
<span class="comment">// Connect to server and select databse.
</span><a href="http://www.php.net/mysql_connect" class="function">mysql_connect</a><span class="symbol">(</span><span class="string double">"$host"</span><span class="symbol">,</span> <span class="string double">"$username"</span><span class="symbol">,</span> <span class="string double">"$password"</span><span class="symbol">)</span><span class="keyword">or</span> <span class="keyword">die</span><span class="symbol">(</span><span class="string double">"cannot connect"</span><span class="symbol">)</span><span class="symbol">;</span> 
<a href="http://www.php.net/mysql_select_db" class="function">mysql_select_db</a><span class="symbol">(</span><span class="string double">"$db_name"</span><span class="symbol">)</span><span class="keyword">or</span> <span class="keyword">die</span><span class="symbol">(</span><span class="string double">"cannot select DB"</span><span class="symbol">)</span><span class="symbol">;</span>
<span class="comment">// username and password sent from form 
</span><span class="variable">$myusername</span><span class="symbol">=</span><span class="variable">$_POST</span><span class="symbol">&#91;</span><span class="string single">'myusername'</span><span class="symbol">&#93;</span><span class="symbol">;</span> 
<span class="variable">$mypassword</span><span class="symbol">=</span><span class="variable">$_POST</span><span class="symbol">&#91;</span><span class="string single">'mypassword'</span><span class="symbol">&#93;</span><span class="symbol">;</span>

<span class="comment">// To protect MySQL injection (more detail about MySQL injection)
</span><span class="variable">$myusername</span> <span class="symbol">=</span> <a href="http://www.php.net/stripslashes" class="function">stripslashes</a><span class="symbol">(</span><span class="variable">$myusername</span><span class="symbol">)</span><span class="symbol">;</span>
<span class="variable">$mypassword</span> <span class="symbol">=</span> <a href="http://www.php.net/stripslashes" class="function">stripslashes</a><span class="symbol">(</span><span class="variable">$mypassword</span><span class="symbol">)</span><span class="symbol">;</span>
<span class="variable">$myusername</span> <span class="symbol">=</span> <a href="http://www.php.net/mysql_real_escape_string" class="function">mysql_real_escape_string</a><span class="symbol">(</span><span class="variable">$myusername</span><span class="symbol">)</span><span class="symbol">;</span>
<span class="variable">$mypassword</span> <span class="symbol">=</span> <a href="http://www.php.net/mysql_real_escape_string" class="function">mysql_real_escape_string</a><span class="symbol">(</span><span class="variable">$mypassword</span><span class="symbol">)</span><span class="symbol">;</span>

<span class="variable">$sql</span><span class="symbol">=</span><span class="string double">"SELECT * FROM $tbl_name WHERE Name ='$myusername' and Password='$mypassword'"</span><span class="symbol">;</span>
<span class="variable">$result</span><span class="symbol">=</span><a href="http://www.php.net/mysql_query" class="function">mysql_query</a><span class="symbol">(</span><span class="variable">$sql</span><span class="symbol">)</span><span class="symbol">;</span>



<span class="comment">// Mysql_num_row is counting table row
</span><span class="variable">$count</span><span class="symbol">=</span><a href="http://www.php.net/mysql_num_rows" class="function">mysql_num_rows</a><span class="symbol">(</span><span class="variable">$result</span><span class="symbol">)</span><span class="symbol">;</span>
<span class="comment">// If result matched $myusername and $mypassword, table row must be 1 row
</span>
<span class="keyword">if</span><span class="symbol">(</span><span class="variable">$count</span><span class="symbol">==</span>1<span class="symbol">)</span><span class="symbol">{</span>
<span class="variable">$query</span><span class="symbol">=</span> <a href="http://www.php.net/sprintf" class="function">sprintf</a><span class="symbol">(</span><span class="string double">"SELECT Name, Password, Admin, Money, X, Y, Z, Rot, Score, Points, Accent, Paydays FROM $tbl_name WHERE Name ='$myusername'"</span><span class="symbol">)</span><span class="symbol">;</span>
<span class="variable">$result</span><span class="symbol">=</span><a href="http://www.php.net/mysql_query" class="function">mysql_query</a><span class="symbol">(</span><span class="variable">$query</span><span class="symbol">)</span><span class="symbol">;</span>
?&gt;</span>
<span class="tag">&lt;br&gt;</span>
<span class="tag">&lt;table width=<span class="string">"400"</span> border='1'&gt;</span>
    <span class="php">&lt;?php
<span class="keyword">while</span> <span class="symbol">(</span><span class="variable">$row</span> <span class="symbol">=</span> <a href="http://www.php.net/mysql_fetch_assoc" class="function">mysql_fetch_assoc</a><span class="symbol">(</span><span class="variable">$result</span><span class="symbol">)</span><span class="symbol">)</span>
<span class="symbol">{</span>
?&gt;</span>
    <span class="tag">&lt;tr&gt;</span><span class="tag">&lt;td&gt;</span><span class="tag">&lt;b&gt;</span>Name<span class="tag">&lt;/b&gt;</span> <span class="php">&lt;?php <span class="keyword">echo</span> <span class="variable">$row</span><span class="symbol">&#91;</span><span class="string single">'Name'</span><span class="symbol">&#93;</span><span class="symbol">;</span> ?&gt;</span><span class="tag">&lt;/td&gt;</span><span class="tag">&lt;/tr&gt;</span>
    <span class="tag">&lt;tr&gt;</span><span class="tag">&lt;td&gt;</span><span class="tag">&lt;b&gt;</span>Password<span class="tag">&lt;/b&gt;</span> <span class="php">&lt;?php <span class="keyword">echo</span> <span class="variable">$row</span><span class="symbol">&#91;</span><span class="string single">'Password'</span><span class="symbol">&#93;</span><span class="symbol">;</span> ?&gt;</span><span class="tag">&lt;/td&gt;</span><span class="tag">&lt;/tr&gt;</span>
    <span class="tag">&lt;tr&gt;</span><span class="tag">&lt;td&gt;</span><span class="tag">&lt;b&gt;</span>Admin level<span class="tag">&lt;/b&gt;</span> <span class="php">&lt;?php <span class="keyword">echo</span> <span class="variable">$row</span><span class="symbol">&#91;</span><span class="string single">'Admin'</span><span class="symbol">&#93;</span><span class="symbol">;</span> ?&gt;</span><span class="tag">&lt;/td&gt;</span><span class="tag">&lt;/tr&gt;</span>
    <span class="tag">&lt;tr&gt;</span><span class="tag">&lt;td&gt;</span><span class="tag">&lt;b&gt;</span>Money<span class="tag">&lt;/b&gt;</span> <span class="php">&lt;?php <span class="keyword">echo</span> <span class="variable">$row</span><span class="symbol">&#91;</span><span class="string single">'Money'</span><span class="symbol">&#93;</span><span class="symbol">;</span> ?&gt;</span><span class="tag">&lt;/td&gt;</span><span class="tag">&lt;/tr&gt;</span>
    <span class="tag">&lt;tr&gt;</span><span class="tag">&lt;td&gt;</span><span class="tag">&lt;b&gt;</span>X Pos<span class="tag">&lt;/b&gt;</span> <span class="php">&lt;?php <span class="keyword">echo</span> <span class="variable">$row</span><span class="symbol">&#91;</span><span class="string single">'X'</span><span class="symbol">&#93;</span><span class="symbol">;</span> ?&gt;</span><span class="tag">&lt;/td&gt;</span><span class="tag">&lt;/tr&gt;</span>
    <span class="tag">&lt;tr&gt;</span><span class="tag">&lt;td&gt;</span><span class="tag">&lt;b&gt;</span>Y Pos<span class="tag">&lt;/b&gt;</span> <span class="php">&lt;?php <span class="keyword">echo</span> <span class="variable">$row</span><span class="symbol">&#91;</span><span class="string single">'Y'</span><span class="symbol">&#93;</span><span class="symbol">;</span> ?&gt;</span><span class="tag">&lt;/td&gt;</span><span class="tag">&lt;/tr&gt;</span>
    <span class="tag">&lt;tr&gt;</span><span class="tag">&lt;td&gt;</span><span class="tag">&lt;b&gt;</span>Z Pos<span class="tag">&lt;/b&gt;</span> <span class="php">&lt;?php <span class="keyword">echo</span> <span class="variable">$row</span><span class="symbol">&#91;</span><span class="string single">'Z'</span><span class="symbol">&#93;</span><span class="symbol">;</span> ?&gt;</span><span class="tag">&lt;/td&gt;</span><span class="tag">&lt;/tr&gt;</span>
    <span class="tag">&lt;tr&gt;</span><span class="tag">&lt;td&gt;</span><span class="tag">&lt;b&gt;</span>Rot Pos<span class="tag">&lt;/b&gt;</span> <span class="php">&lt;?php <span class="keyword">echo</span> <span class="variable">$row</span><span class="symbol">&#91;</span><span class="string single">'Rot'</span><span class="symbol">&#93;</span><span class="symbol">;</span> ?&gt;</span><span class="tag">&lt;/td&gt;</span><span class="tag">&lt;/tr&gt;</span>
    <span class="tag">&lt;tr&gt;</span><span class="tag">&lt;td&gt;</span><span class="tag">&lt;b&gt;</span>Score<span class="tag">&lt;/b&gt;</span> <span class="php">&lt;?php <span class="keyword">echo</span> <span class="variable">$row</span><span class="symbol">&#91;</span><span class="string single">'Score'</span><span class="symbol">&#93;</span><span class="symbol">;</span> ?&gt;</span><span class="tag">&lt;/td&gt;</span><span class="tag">&lt;/tr&gt;</span>
    <span class="tag">&lt;tr&gt;</span><span class="tag">&lt;td&gt;</span><span class="tag">&lt;b&gt;</span>Points<span class="tag">&lt;/b&gt;</span> <span class="php">&lt;?php <span class="keyword">echo</span> <span class="variable">$row</span><span class="symbol">&#91;</span><span class="string single">'Points'</span><span class="symbol">&#93;</span><span class="symbol">;</span> ?&gt;</span><span class="tag">&lt;/td&gt;</span><span class="tag">&lt;/tr&gt;</span>
    <span class="tag">&lt;tr&gt;</span><span class="tag">&lt;td&gt;</span><span class="tag">&lt;b&gt;</span>Accent<span class="tag">&lt;/b&gt;</span> <span class="php">&lt;?php <span class="keyword">echo</span> <span class="variable">$row</span><span class="symbol">&#91;</span><span class="string single">'Accent'</span><span class="symbol">&#93;</span><span class="symbol">;</span> ?&gt;</span><span class="tag">&lt;/td&gt;</span><span class="tag">&lt;/tr&gt;</span>
    <span class="tag">&lt;tr&gt;</span><span class="tag">&lt;td&gt;</span><span class="tag">&lt;b&gt;</span>Paydays<span class="tag">&lt;/b&gt;</span> <span class="php">&lt;?php <span class="keyword">echo</span> <span class="variable">$row</span><span class="symbol">&#91;</span><span class="string single">'Paydays'</span><span class="symbol">&#93;</span><span class="symbol">;</span> ?&gt;</span><span class="tag">&lt;/td&gt;</span><span class="tag">&lt;/tr&gt;</span>
    
    <span class="php">&lt;?php
<span class="symbol">}</span>
<span class="keyword">echo</span> <span class="string single">'&lt;/table&gt;'</span><span class="symbol">;</span>
<span class="symbol">}</span>
<span class="keyword">else</span> <span class="symbol">{</span>
<span class="keyword">echo</span> <span class="string double">"Wrong Username or Password"</span><span class="symbol">;</span>
<span class="symbol">}</span>
?&gt;</span></span></span></pre></td></tr></table><br />
Alvast bedankt]]></description>
		<pubDate>Thu, 02 Feb 2012 20:15:08 +0000</pubDate>
		<guid>http://www.pfz.nl/forum/topic/6759-warning-mysql-fetch-assoc-expects-parameter-1-to-be-resource-boolean-given-in-checkloginphp-on-line-35/</guid>
	</item>
	<item>
		<title>Exploden/splitten op meerdere delimiters</title>
		<link>http://www.pfz.nl/forum/topic/6758-explodensplitten-op-meerdere-delimiters/</link>
		<description><![CDATA[Er bestaat een hele grote string, die ik op wil delen. Er staat bijvoorbeeld het volgende in;<br />
<br />
REPLACE Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer rhoncus risus ut metus placerat accumsan. Etiam sit amet ligula augue, imperdiet imperdiet sem. Vestibulum lectus nisi, convallis a porta sed, ullamcorper sed diam. Sed at eros gravida leo vulputate pharetra eu at enim. Nunc quis neque ut ipsum congue suscipit. Suspendisse libero orci, iaculis in facilisis varius, porttitor et sem. ALSO THIS feugiat varius mauris, sed bibendum tellus sodales in. Nunc urna velit, rhoncus a lobortis eu, AND THIS et augue.<br />
<br />
Aangezien het een "normale" tekst is (met eigenlijk ALLE karakters tussen teksten door), wil ik de delimiters behouden. Het moet echter wel in een array komen. REPLACE, ALSO THIS en AND THIS zullen dus als delimiters dienen, echter beschik ik niet over de vaardigheden om dit uit te voeren. Heb reeds verschillende dingen gevonden, maar het is meestal of een split met één karakter of een explode met meerdere delimiters maar niet met behoud van de delimiter zelf. Ik zoek dus een soort van combi hiervan, maar kom er zelf na uren nog niet uit..]]></description>
		<pubDate>Thu, 02 Feb 2012 19:15:04 +0000</pubDate>
		<guid>http://www.pfz.nl/forum/topic/6758-explodensplitten-op-meerdere-delimiters/</guid>
	</item>
	<item>
		<title>Gegeven antwoord van een vraag controleren.</title>
		<link>http://www.pfz.nl/forum/topic/6757-gegeven-antwoord-van-een-vraag-controleren/</link>
		<description><![CDATA[Het script bestaat uit een 10-tal vragen. De gekozen antwoorden worden steeds doorgegeven middels $_GET.<br />
De juiste antwoorden staan in een database en worden opgevraagd in antwoorden.php, waarin de variabelen ($juistantwoord1, $juistantwoord2, etc) staan gedefinieerd. Als de antwoorden overeenkomen een 1 vasthouden. Uiteindelijk de 1-tjes optellen en de score bekend maken. Probleem is dat de waarde voor $aantal leeg blijft.<br />
<br />
<table class="highlight source" cellspacing="0"><tr><td class="line-numbers">1<br/>2<br/>3<br/>4<br/>5<br/>6<br/>7<br/>8<br/>9<br/>10<br/>11<br/>12<br/>13<br/>14<br/>15<br/>16<br/>17<br/>18<br/>19<br/>20<br/>21<br/>22<br/>23<br/>24<br/>25<br/>26<br/>27<br/>28<br/>29<br/>30<br/>31<br/>32<br/>33<br/>34</td><td><pre><span class="php"><span class="html"><span class="php">&lt;?php
<span class="keyword">include</span><span class="symbol">(</span><span class="string single">'antwoorden.php'</span><span class="symbol">)</span><span class="symbol">;</span>
<a href="http://www.php.net/session_start" class="function">session_start</a><span class="symbol">(</span><span class="symbol">)</span><span class="symbol">;</span>

 <span class="keyword">include_once</span> <span class="symbol">(</span><span class="string single">'connect.php'</span><span class="symbol">)</span><span class="symbol">;</span>
  
    <span class="keyword">if</span> <span class="symbol">(</span><span class="keyword">empty</span><span class="symbol">(</span><span class="variable">$_POST</span><span class="symbol">)</span><span class="symbol">)</span> <span class="symbol">{</span>
<span class="variable">$antwoord1</span><span class="symbol">=</span> <span class="variable">$_GET</span><span class="symbol">&#91;</span><span class="string single">'antwoord1'</span><span class="symbol">&#93;</span><span class="symbol">;</span>
<span class="variable">$antwoord2</span><span class="symbol">=</span> <span class="variable">$_GET</span><span class="symbol">&#91;</span><span class="string single">'antwoord2'</span><span class="symbol">&#93;</span><span class="symbol">;</span>
<span class="variable">$antwoord3</span><span class="symbol">=</span> <span class="variable">$_GET</span><span class="symbol">&#91;</span><span class="string single">'antwoord3'</span><span class="symbol">&#93;</span><span class="symbol">;</span>
<span class="variable">$antwoord4</span><span class="symbol">=</span> <span class="variable">$_GET</span><span class="symbol">&#91;</span><span class="string single">'antwoord4'</span><span class="symbol">&#93;</span><span class="symbol">;</span>
<span class="variable">$antwoord5</span><span class="symbol">=</span> <span class="variable">$_GET</span><span class="symbol">&#91;</span><span class="string single">'antwoord5'</span><span class="symbol">&#93;</span><span class="symbol">;</span>
<span class="variable">$antwoord6</span><span class="symbol">=</span> <span class="variable">$_GET</span><span class="symbol">&#91;</span><span class="string single">'antwoord6'</span><span class="symbol">&#93;</span><span class="symbol">;</span>
<span class="variable">$antwoord7</span><span class="symbol">=</span> <span class="variable">$_GET</span><span class="symbol">&#91;</span><span class="string single">'antwoord7'</span><span class="symbol">&#93;</span><span class="symbol">;</span>
<span class="variable">$antwoord8</span><span class="symbol">=</span> <span class="variable">$_GET</span><span class="symbol">&#91;</span><span class="string single">'antwoord8'</span><span class="symbol">&#93;</span><span class="symbol">;</span>
<span class="variable">$antwoord9</span><span class="symbol">=</span> <span class="variable">$_GET</span><span class="symbol">&#91;</span><span class="string single">'antwoord9'</span><span class="symbol">&#93;</span><span class="symbol">;</span>
<span class="variable">$antwoord10</span><span class="symbol">=</span> <span class="variable">$_GET</span><span class="symbol">&#91;</span><span class="string single">'antwoord10'</span><span class="symbol">&#93;</span><span class="symbol">;</span>

<span class="keyword">if</span> <span class="symbol">(</span><span class="variable">$juistantwoord1</span> <span class="symbol">==</span> <span class="variable">$antwoord1</span><span class="symbol">)</span> <span class="symbol">{</span>
        <span class="keyword">echo</span> <span class="string double">"&lt;input type='hidden' name='$vraag1_goed' value='1'&gt;&lt;/input&gt;"</span><span class="symbol">;</span>
       <span class="symbol">}</span>
      <span class="keyword">else</span> <span class="symbol">{</span>
        <span class="keyword">echo</span> <span class="string double">"&lt;input type='hidden' name='$vraag1_fout' value='0'&gt;&lt;/input&gt;"</span><span class="symbol">;</span> <span class="symbol">}</span>

<span class="keyword">if</span> <span class="symbol">(</span><span class="variable">$juistantwoord2</span> <span class="symbol">==</span> <span class="variable">$antwoord2</span><span class="symbol">)</span> <span class="symbol">{</span>
        <span class="keyword">echo</span> <span class="string double">"&lt;input type='hidden' name='$vraag2_goed' value='1'&gt;&lt;/input&gt;"</span><span class="symbol">;</span>
       <span class="symbol">}</span>
      <span class="keyword">else</span> <span class="symbol">{</span>
        <span class="keyword">echo</span> <span class="string double">"&lt;input type='hidden' name='$vraag2_fout' value='0'&gt;&lt;/input&gt;"</span><span class="symbol">;</span> <span class="symbol">}</span>

<span class="variable">$aantal</span> <span class="symbol">=</span> <span class="string single">'$vraag1_goed + $vraag2_goed'</span><span class="symbol">;</span>
<span class="keyword">echo</span> <span class="symbol">(</span><span class="string double">"Je hebt $aantal van de 10 vragen goed!"</span><span class="symbol">)</span><span class="symbol">;</span>

<span class="comment">//...rest van de pagina...</span></span></span></span></pre></td></tr></table>]]></description>
		<pubDate>Thu, 02 Feb 2012 19:14:51 +0000</pubDate>
		<guid>http://www.pfz.nl/forum/topic/6757-gegeven-antwoord-van-een-vraag-controleren/</guid>
	</item>
</channel>
</rss>
