Untitled

   <html>
<head>
    <link rel="stylesheet" type="text/css" href="style2.css"/>
</head>
<body>

	<?php include 'menu.php'; ?>

	<form name="frmSearch" method="post" action="test2.php">
  <table border="0">
    <tr>
      <th>Artikel :
      <input name="var1" type="text" id="var1">
      <input type="submit" value="Search"></th>
    </tr>
  </table>
</form>

<?php
$nameofdb = 'db';
$dbusername = 'root';
$dbpassword = '';


// Connect to MySQL via PDO
try {
$dbh = new PDO("mysql:dbname=$nameofdb;host=localhost", $dbusername, $dbpassword);
$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
echo 'Connection failed: ' . $e->getMessage();
}

$var1 = str_replace(array('%','_'),'',$_POST['var1']);
if (!$var1)
{
    exit('Invalid form value: '.$var1);
}


$query = 'SELECT
    t1.`BSTKATNR`,
    t1.`BSTLIEFBST`,
	t1.`BSTLIEFTXT`,
    t1.`BSTARTBES1`,
    t1.`BSTANF`,
    t1.`BSTSTLIO`,
    t1.`BSTLIEFMIN`,
    t1.`BSTMIND`,
    t1.`BSTARTMASS`,
    t1.`BSTKUMST`,
    t1.`BSTKUMVK`,
    t1.`BSTKUMER`
    FROM `elebest` AS t1 WHERE
    ( t1.`BSTLIEFBST` LIKE :search ) OR
    ( t1.`BSTKATNR` LIKE :search ) OR
    ( t1.`BSTLIEFTXT` LIKE :search ) OR
    ( t1.`BSTARTBES1` LIKE :search)';


$stmt = $dbh->prepare($query);
$stmt->bindValue(':search', '%' . $var1 . '%', PDO::PARAM_INT);
$stmt->execute();

/* Fetch all of the remaining rows in the result set */
print(" ");


$result = $stmt->fetchAll();

foreach( $result as $row ) {

	echo "<div id='uberschrift'>" ;
	echo 'Artikelnummer : ' ;
    echo $row["BSTKATNR"];
	echo '<br>' ;
	echo 'LF. Nr. : ' ;
	echo $row["BSTLIEFBST"];
	echo '<br>' ;
	echo '<br>' ;
	echo 'Beschreibung : ' ;
	echo $row["BSTARTBES1"];
	echo "</div>" ;

	echo "<div id='links'>" ;
	echo '<br>' ;
	echo 'Bestand : ' ;
	echo $row["BSTANF"];
	echo '<br>' ;
	echo 'Verf&uuml;gbar : ' ;
	echo $row["BSTSTLIO"];
	echo '<br>' ;
	echo '<br>' ;
	echo 'Verkaufszahlen Aktuelles Jahr : ' ;
	echo '<br>' ;
	echo '<br>' ;
	echo 'St&uuml;ck : ' ;
	echo $row["BSTKUMST"];
	echo '<br>' ;
	echo 'Umsatz : ' ;
	echo $row["BSTKUMVK"];	echo ' &euro;' ;
	echo '<br>' ;
	echo 'Ertrag : ' ;
	echo $row["BSTKUMER"];	echo ' &euro;' ;
	echo '<br>' ;
	echo '<br>' ;
	echo "</div>" ;
}

?>

</body>
</html>