<?php

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

$conn = new mysqli($servername, $username, $password, $db);

$search = '';

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

    $search = $_GET['search'];
    $sql = "SELECT * FROM artikel WHERE * LIKE '%" . $search . "%'";
    $result = $conn->query($sql);
var_dump($result);
    if ($result->num_rows > 0) {
        // print data
        while ($row = $result->fetch_assoc()) {
            echo $row["d_prijs"] . "<br>";
            echo $row["c_prijs"] . "<br>";
            echo $row["code"] . "<br>";
            echo $row["artikelNL"] . "<br><br>";
        }
    } else {
        echo "niets gevonden";
    }
}
$conn->close();
?>


<form method="get" action="">
    <input id="search" name="search" type="text" placeholder="search">
    <input type="submit" name="submit">
</form>