<?php

$servername = "localhost";
$username = "root";
$password = "";
$db = "artikel";

mysql_connect($servername, $username, $password);
mysql_select_db($db);
$search = '';

if (array_key_exists('search', $_GET)) {

    $search = $_GET['search'];
    $sql = "SELECT * FROM artikel WHERE * LIKE '%" . $search . "%'";
    $result = mysql_query($sql);

    // var_dump($result);

    if ($result->num_rows > 0) {
        while ($row = mysql_fetch_object($result)) {
            echo $row->product_id;
			echo $row->d_prijs;
			echo $row->c_prijs;
        }
    } else {
        echo "niets gevonden";
    }
}
mysql_free_result($result);
$conn->close();
?>