form in php

[brodik]

form.html

<form name="test" action="parse.php" method="GET">
<input type="text" name="nome" value="Inserisci nome">
<input type="submit" value="Invia"> 

parse.php

<?php
$name = $_GET['nome'];

mysql_connect("host", "mysql_user", "mysql_password") or
die("Impossibile connettersi: " . mysql_error());
mysql_select_db("my_db");

$result = mysql_query("SELECT id, info FROM my_table WHERE name LIKE '%$name%'");
while($row = mysql_fetch_array($result, MYSQL_ASSOC)){
print $row["id"]." - ".$row["info"];
}

mysql_free_result($result);
?>

ovviamente scritto e non testato