van Mysql naar PDO

	<form name="bgcolorForm">Welke kleur wil je
			<select onChange="if(this.selectedIndex!=0)
				Color=this.options[this.selectedIndex].value">
				<option value="choose">Kies hier uw kleur 
				

				<?php
				mysql_connect('localhost', 'root', '');
				mysql_select_db('kleuren');

				$sql = "SELECT * FROM Kleur";
				$result = mysql_query($sql);

					while ($row = mysql_fetch_array($result)) {
					echo "<option value='".$row['Hexkleur']."'> ".$row['kleurnaam']."";
				}
						?> 
	</select>
  </form>

	<form name="bgcolorForm">Welke kleur wil je
			<select onChange="if(this.selectedIndex!=0)
				Color=this.options[this.selectedIndex].value">
				<option value="choose">Kies hier uw kleur 
				

				<?php
				$hostname='localhost';
				$username='root';
				$password='';

				try {
				    $dbh = new PDO("mysql:host=$hostname;dbname=kleuren",$username,$password);

				    $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
				    echo 'Connected to Database<br/>';

				    $sql = "SELECT * FROM Kleur";
				    $result = mysql_query($sql);
				    
				while ($row = mysql_fetch_array($result)) {
					echo "<option value='".$row['Hexkleur']."'> ".$row['kleurnaam']."";
				}

				    $dbh = null;
				    }
				catch(PDOException $e)
				    {
				    echo $e->getMessage();
				    }
				?> 
			</select>

    </form>

$result = mysql_query($sql);

  $sth = $dbh->prepare("SELECT * FROM Kleur");
				    $sth->execute();
					$result = $sth->fetchAll();

$sql = "SELECT * FROM Kleur";
				    $result = mysql_query($sql);