<?php    
$sql = mysql_query("SELECT * FROM partners ORDER BY id");
$row = 0; //Teller voor het aantal rijen
while($row = mysql_fetch_array($sql))
{
	$link = $row['link'];
	$naam = $row['naam'];
	$afbeelding = $row['afbeelding'];
	$class = ""; // Lege container defineren voor elk item.
	
	if ($row % 5 == 0 || $row == 0) { $class .= " first"; } // Extra data aan de classe toevoegen.
	if ($row % 5 == 4) { $class .= " last"; } // Extra data aan de classe toevoegen.
	?>


	<div class="r<?php echo $class; ?>">            
		<div class="g g8 node node-sidebar-reference node-promoted node-teaser">
			<a href="<?php echo $row['link']; ?>" class="box island">        <img src="ontwikkel_admin/images/logos/partners/<?php echo $row['afbeelding']; ?>" alt="" />
		<span class="inset button-primary"><?php echo $row['naam']; ?></span></a></div>
	</div>
	<?
	$row++; //Optellen van een rij.
}
?>

/**
 * Humanize a string.
 */
function humanize($string, $separator = '_')
{
    return ucwords(preg_replace('/[' . $separator . ']+/', ' ', strtolower(trim($string))));
}


/**
 * Filter a valid UTF-8 string so that it contains only words, numbers,
 * dashes, underscores, periods, and spaces
 *
 * @param string $string String to clean.
 * @param boolean $spaces Whether to allow spaces.
 * @return string
 */
function sanitize($string, $spaces = true)
{
    $search = array(
        '/[^\w\-\. ]+/u', // Remove non safe characters
        '/\s\s+/', // Remove extra whitespace
        '/\.\.+/',
        '/--+/',
        '/__+/' // Remove duplicate symbols
            );


    $string = preg_replace($search, array(
        ' ',
        ' ',
        '.',
        '-',
        '_'), $string);


    if (!$spaces)
    {
        $string = preg_replace('/--+/', '-', str_replace(' ', '-', $string));
    }


    return trim($string, '-._ ');
}


/**
 * Filter a valid UTF-8 string to a SEO friendly URL.
 *
 * @param string $string String to clean.
 * @param boolean $spaces Whether to allow spaces.
 * @return string
 */
function sanitize_url($string)
{
    return urlencode(mb_strtolower(sanitize($string, false)));
}


/**
 * Filter a valid UTF-8 string to be file name safe.
 *
 * @param string $string String to clean.
 * @return string
 */
function sanitize_filename($string)
{
    return sanitize($string, false);
}

<?xml version="1.0" encoding="UTF-8"?>


<web-app xmlns="http://java.sun.com/xml/ns/javaee"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd"
         version="3.0">


    <!-- Setup servlet -->
    <servlet>
        <servlet-name>appServlet</servlet-name>
        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
        <init-param>
            <param-name>contextConfigLocation</param-name>
            <param-value>/WEB-INF/servlet-context.xml</param-value>
        </init-param>
        <load-on-startup>1</load-on-startup>
    </servlet>
   
    <servlet-mapping>
        <servlet-name>appServlet</servlet-name>
        <url-pattern>/</url-pattern>
    </servlet-mapping>
    
    <!-- Setup the timeout handler -->
    <session-config>
        <session-timeout>
            30
        </session-timeout>
    </session-config>  
    
    <!-- Welcome JSP -->
    <welcome-file-list>
        <welcome-file>redirect.jsp</welcome-file>
    </welcome-file-list>    
    
</web-app>

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:tx="http://www.springframework.org/schema/tx"


       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.2.xsd
          http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.2.xsd
          http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.2.xsd
">


    <!-- Map simple view name such as "test" into /WEB-INF/views/test.jsp -->
    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="prefix" value="/Views/" />
        <property name="suffix" value=".jsp" />
    </bean>
    
    <!-- Scan classpath for annotations (eg: @Service, @Repository etc) -->
    <context:component-scan base-package="com.socialacademy" />
    
    <!-- Load properties -->
    <context:property-placeholder location="classpath:socialacademy.properties" />
    
    <!-- JDBC Data Source. It is assumed you have MySQL running on localhost port 3306 with 
    username root and blank password. Change below if it's not the case -->
    <bean id="myDataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
        <property name="driverClassName" value="${jdbc.driverClassName}"/>
        <property name="url" value="${jdbc.url}" />
        <property name="username" value="${jdbc.user}" />
        <property name="password" value="${jdbc.pass}" />
        <property name="validationQuery" value="SELECT 1" />
    </bean>
    
    <!-- Hibernate Session Factory -->
    <bean id="mySessionFactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
        <property name="dataSource" ref="myDataSource" />
        <property name="packagesToScan" value="com.socialacademy.model" />
        <property name="hibernateProperties">
            <props>
                <prop key="hibernate.hbm2ddl.auto">${hibernate.hbm2ddl.auto}</prop>
                <prop key="hibernate.dialect">${hibernate.dialect}</prop>
            </props>
        </property>
    </bean>
  
    <!-- Hibernate Transaction Manager -->
    <bean id="transactionManager" class="org.springframework.orm.hibernate4.HibernateTransactionManager">
        <property name="sessionFactory" ref="mySessionFactory" />
    </bean>
  
    <!-- Activates annotation based transaction management -->
    <tx:annotation-driven transaction-manager="transactionManager" />    
    
</beans>