<?php
//Titolo
echo "<div align='center'><font size=4>Trova Dati</font><p>Tabella selezionata: $table<p>";
include("mysql_data.txt");
include("extras.txt");
echo "$input_style";
echo "<head><title>Ricerca Dati nel Database $database</title></head>";
or
die("Non riesco a connettermi al server <b>$db_host");
//Visualizza la prima riga di esempio
$all="SELECT * FROM $table";
or
die("Non riesco ad eseguire la richiesta $all");
$count_fields=0;
echo "<div align='center'><table border=1><tr>";
while($count_fields<$colonne){
$count_fields++;
}
echo "</tr></table><p>";
//Crea una Textbox per ogni campo...
$count_fields=0;
echo "<form><input type='hidden' name='table' value='$table'>";
while($count_fields<$colonne){
echo "<input type='text' name='txtdata$count_fields'>";
$count_fields++;
}
echo "<p><input type='submit' value='Cerca'>";
echo "</form><p>";
//Crea la stringa SQL per la ricerca dei dati
$sql_string="";
$count=0;
while(list($key,$val)=each($HTTP_GET_VARS)){
if ($count<>0){
if ($val<>''){
$sql_string=$sql_string."$campox LIKE '$val' AND ";
}
}
$count++;
}
//Toglie gli ultimi caratteri dalla string SQL
$x_string=$sql_string;
$sql_string="";
for ($x=0;$x<($len_sql-$count_less);$x++){
$sql_string=$sql_string.$x_string[$x];
}
//Ricercare un Record
$select="SELECT * FROM $table WHERE $sql_string";
or
die("Non riesco a trovare niente con il comando $select");
//Tabella per ordinare la ricerca...
//Titoli
echo "<table border=1><tr>";
$count_fields=0;
while($count_fields<$colonne){
echo "<td><div align='center'><b>".mysql_field_name($query,$count_fields)."</b></td>";
$count_fields++;
}
echo "</tr>";
//Dati trovati
$count_fields=0;
echo "<tr>";
$x=0;
while ($x<$colonne){
echo "<td><div align='center'>$row[$rowname]</td>";
$x++;
}
echo "</tr>";
$count_fields++;
}
echo "</table><p>";
}
}
echo "<input type='button' name='cmdexit' value='Go to $main' onclick=\"location.href='$main'\"><hr>";
//Ricerca le tabelle e le manda sullo schermo
$i=0;
echo "<form><div align='center'>";
echo "<select name='table'>";
while($i<mysql_num_rows($result)){
echo "<option>$tb_names[$i]";
$i++;
}
echo "</select><p>";
echo "<input type='submit' value='Seleziona la Tabella'>";
echo "</form><p>";
?>
<html>
<body>
</body>
</html>