Php search problema

**Murderess** · 20-01-2013, 23:28

Salve ragazzi ho un problema per quanto riguarda un codice in php. Il codice è molto semplice e sicuramente io sono ancora poco esperto per arrivare a modificare il codice in modo tale che faccia ciò che voglio.

In breve, sto lavorando su uno script in php che prende i record da un database e li stampa all'interno di una tabella e fin qui ci siamo. Il tutto poi è correlato da una serie di ulteriori controlli che permettono d'effettuare una ricerca attraverso i vari record.

Lo script funziona come vorrei se non per un particolare aspetto. Quando la ricerca è a zero(esempio dopo aver cliccato "reset") vorrei che non si visualizzassero tutti i record presenti all'interno del db. I record richiesto si deve vedere solo quando si effettua la ricerca specifica.

codice:

<?php



error_reporting(0);
include("config.php");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>MySQL table search</title>
<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.0/jquery.min.js"></script>
<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jqueryui/1.8.16/jquery-ui.min.js"></script>
<link href="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8/themes/base/jquery-ui.css" rel="stylesheet" type="text/css"/>
<style>
BODY, TD {
	font-family:Arial, Helvetica, sans-serif;
	font-size:12px;
}
</style>
</head>


<body>

<form id="form1" name="form1" method="post" action="search.php">
<label for="from">From</label>
<input name="from" type="text" id="from" size="10" value="<?php echo $_REQUEST["from"]; ?>" />
<label for="to">to</label>
<input name="to" type="text" id="to" size="10" value="<?php echo $_REQUEST["to"]; ?>"/>
 <label>Name or Email:</label>
<input type="text" name="string" id="string" value="<?php echo stripcslashes($_REQUEST["string"]); ?>" />
<label>City</label>
<select name="city">
<option value="">--</option>
<?php
	$sql = "SELECT * FROM ".$SETTINGS["data_table"]." GROUP BY city ORDER BY city";
	$sql_result = mysql_query ($sql, $connection ) or die ('request "Could not execute SQL query" '.$sql);
	while ($row = mysql_fetch_assoc($sql_result)) {
		echo "<option value='".$row["city"]."'".($row["city"]==$_REQUEST["city"] ? " selected" : "").">".$row["city"]."</option>";
	}
?>
</select>
<input type="submit" name="button" id="button" value="Filter" />
  </label>
  <a href="search.php"> 
  reset</a>
</form>



<table width="700" border="1" cellspacing="0" cellpadding="4">
  <tr>
    <td width="90" bgcolor="#CCCCCC">From date</td>
    <td width="95" bgcolor="#CCCCCC">To date</td>
    <td width="159" bgcolor="#CCCCCC">Name</td>
    <td width="191" bgcolor="#CCCCCC">Email</td>
    <td width="113" bgcolor="#CCCCCC">City</td>
  </tr>
<?php
if ($_REQUEST["string"]<>'') {
	$search_string = " AND (full_name LIKE '%".mysql_real_escape_string($_REQUEST["string"])."%' OR email LIKE '%".mysql_real_escape_string($_REQUEST["string"])."%')";	
}
if ($_REQUEST["city"]<>'') {
	$search_city = " AND city='".mysql_real_escape_string($_REQUEST["city"])."'";	
}

if ($_REQUEST["from"]<>'' and $_REQUEST["to"]<>'') {
	$sql = "SELECT * FROM ".$SETTINGS["data_table"]." WHERE from_date >= '".mysql_real_escape_string($_REQUEST["from"])."' AND to_date <= '".mysql_real_escape_string($_REQUEST["to"])."'".$search_string.$search_city;
} else if ($_REQUEST["from"]<>'') {
	$sql = "SELECT * FROM ".$SETTINGS["data_table"]." WHERE from_date >= '".mysql_real_escape_string($_REQUEST["from"])."'".$search_string.$search_city;
} else if ($_REQUEST["to"]<>'') {
	$sql = "SELECT * FROM ".$SETTINGS["data_table"]." WHERE to_date <= '".mysql_real_escape_string($_REQUEST["to"])."'".$search_string.$search_city;
} else {
	$sql = "SELECT * FROM ".$SETTINGS["data_table"]." WHERE id>0".$search_string.$search_city;
}

$sql_result = mysql_query ($sql, $connection ) or die ('request "Could not execute SQL query" '.$sql);
if (mysql_num_rows($sql_result)>0) {
	while ($row = mysql_fetch_assoc($sql_result)) {
?>
  <tr>
    <td><?php echo $row["from_date"]; ?></td>
    <td><?php echo $row["to_date"]; ?></td>
    <td><?php echo $row["full_name"]; ?></td>
    <td><?php echo $row["email"]; ?></td>
    <td><?php echo $row["city"]; ?></td>
  </tr>
<?php
	}
} else {
?>
<tr><td colspan="5">No results found.</td>
<?php	
}
?>
</table>


<script>
	$(function() {
		var dates = $( "#from, #to" ).datepicker({
			defaultDate: "+1w",
			changeMonth: true,
			numberOfMonths: 2,
			dateFormat: 'yy-mm-dd',
			onSelect: function( selectedDate ) {
				var option = this.id == "from" ? "minDate" : "maxDate",
					instance = $( this ).data( "datepicker" ),
					date = $.datepicker.parseDate(
						instance.settings.dateFormat ||
						$.datepicker._defaults.dateFormat,
						selectedDate, instance.settings );
				dates.not( this ).datepicker( "option", option, date );
			}
		});
	});
	</script>

</body>
</html>

Riuscite a aiutarmi? Ringrazio in anticipo

n.b. Nello screen mostro come, con la ricerca a zero, i record vengono mostrati ugualmente.

**lucavizzi** · 21-01-2013, 00:19

codice:

<?php

error_reporting(0);
include("config.php");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>MySQL table search</title>
<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.0/jquery.min.js"></script>
<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jqueryui/1.8.16/jquery-ui.min.js"></script>
<link href="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8/themes/base/jquery-ui.css" rel="stylesheet" type="text/css"/>
<style>
BODY, TD {
	font-family:Arial, Helvetica, sans-serif;
	font-size:12px;
}
</style>
</head>


<body>

<form id="form1" name="form1" method="post" action="search.php">
<label for="from">From</label>
<input name="from" type="text" id="from" size="10" value="<?php echo $_REQUEST["from"]; ?>" />
<label for="to">to</label>
<input name="to" type="text" id="to" size="10" value="<?php echo $_REQUEST["to"]; ?>"/>
 <label>Name or Email:</label>
<input type="text" name="string" id="string" value="<?php echo stripcslashes($_REQUEST["string"]); ?>" />
<label>City</label>
<select name="city">
<option value="">--</option>
<?php
	$sql = "SELECT * FROM ".$SETTINGS["data_table"]." GROUP BY city ORDER BY city";
	$sql_result = mysql_query ($sql, $connection ) or die ('request "Could not execute SQL query" '.$sql);
	while ($row = mysql_fetch_assoc($sql_result)) {
		echo "<option value='".$row["city"]."'".($row["city"]==$_REQUEST["city"] ? " selected" : "").">".$row["city"]."</option>";
	}
?>
</select>
<input type="submit" name="button" id="button" value="Filter" />
  </label>
  <a href="search.php"> 
  reset</a>
</form>



<table width="700" border="1" cellspacing="0" cellpadding="4">
  <tr>
    <td width="90" bgcolor="#CCCCCC">From date</td>
    <td width="95" bgcolor="#CCCCCC">To date</td>
    <td width="159" bgcolor="#CCCCCC">Name</td>
    <td width="191" bgcolor="#CCCCCC">Email</td>
    <td width="113" bgcolor="#CCCCCC">City</td>
  </tr>
<?php
$showRecords=true;
if ($_REQUEST["string"]<>'') {
	$search_string = " AND (full_name LIKE '%".mysql_real_escape_string($_REQUEST["string"])."%' OR email LIKE '%".mysql_real_escape_string($_REQUEST["string"])."%')";	
}
if ($_REQUEST["city"]<>'') {
	$search_city = " AND city='".mysql_real_escape_string($_REQUEST["city"])."'";	
}

if ($_REQUEST["from"]<>'' and $_REQUEST["to"]<>'') {
	$sql = "SELECT * FROM ".$SETTINGS["data_table"]." WHERE from_date >= '".mysql_real_escape_string($_REQUEST["from"])."' AND to_date <= '".mysql_real_escape_string($_REQUEST["to"])."'".$search_string.$search_city;
} else if ($_REQUEST["from"]<>'') {
	$sql = "SELECT * FROM ".$SETTINGS["data_table"]." WHERE from_date >= '".mysql_real_escape_string($_REQUEST["from"])."'".$search_string.$search_city;
} else if ($_REQUEST["to"]<>'') {
	$sql = "SELECT * FROM ".$SETTINGS["data_table"]." WHERE to_date <= '".mysql_real_escape_string($_REQUEST["to"])."'".$search_string.$search_city;
} else {
	$showRecords=false;
}
if($showRecords){
$sql_result = mysql_query ($sql, $connection ) or die ('request "Could not execute SQL query" '.$sql);
if (mysql_num_rows($sql_result)>0) {
	while ($row = mysql_fetch_assoc($sql_result)) {
?>
  <tr>
    <td><?php echo $row["from_date"]; ?></td>
    <td><?php echo $row["to_date"]; ?></td>
    <td><?php echo $row["full_name"]; ?></td>
    <td><?php echo $row["email"]; ?></td>
    <td><?php echo $row["city"]; ?></td>
  </tr>
<?php
	}
} else {
?>
<tr><td colspan="5">No results found.</td>
<?php	
}
}else{
?>
<tr><td colspan="5">Specify a search criteria.</td>
<?php
}
?>
</table>


<script>
	$(function() {
		var dates = $( "#from, #to" ).datepicker({
			defaultDate: "+1w",
			changeMonth: true,
			numberOfMonths: 2,
			dateFormat: 'yy-mm-dd',
			onSelect: function( selectedDate ) {
				var option = this.id == "from" ? "minDate" : "maxDate",
					instance = $( this ).data( "datepicker" ),
					date = $.datepicker.parseDate(
						instance.settings.dateFormat ||
						$.datepicker._defaults.dateFormat,
						selectedDate, instance.settings );
				dates.not( this ).datepicker( "option", option, date );
			}
		});
	});
	</script>

</body>
</html>

Ciao

**Murderess** · 21-01-2013, 00:26

Ciao ti ringrazio per la risposta e ti dico che funziona ma la ricerca funziona solo nei campi dove ci sono le date, se uno cerca per città o per nome non esce nulla

**lucavizzi** · 21-01-2013, 00:33

cosa mostra se cerchi?

**Murderess** · 21-01-2013, 00:38

Mi correggo, funziona la solo se cerchi per data. Se cerchi per nome o per nome della città non da alcun risultato dice "Specify a search criteria." Mentre prima anche se effettuavi la ricerca con il nome o con la città i risultati te li stampava ugualmente, naturalmente quelli con il nome richiesto o con la città richiesta

**lucavizzi** · 21-01-2013, 00:44

Vero, così dovrebbe andare:

codice:

<?php

error_reporting(0);
include("config.php");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>MySQL table search</title>
<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.0/jquery.min.js"></script>
<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jqueryui/1.8.16/jquery-ui.min.js"></script>
<link href="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8/themes/base/jquery-ui.css" rel="stylesheet" type="text/css"/>
<style>
BODY, TD {
	font-family:Arial, Helvetica, sans-serif;
	font-size:12px;
}
</style>
</head>


<body>

<form id="form1" name="form1" method="post" action="search.php">
<label for="from">From</label>
<input name="from" type="text" id="from" size="10" value="<?php echo $_REQUEST["from"]; ?>" />
<label for="to">to</label>
<input name="to" type="text" id="to" size="10" value="<?php echo $_REQUEST["to"]; ?>"/>
 <label>Name or Email:</label>
<input type="text" name="string" id="string" value="<?php echo stripcslashes($_REQUEST["string"]); ?>" />
<label>City</label>
<select name="city">
<option value="">--</option>
<?php
	$sql = "SELECT * FROM ".$SETTINGS["data_table"]." GROUP BY city ORDER BY city";
	$sql_result = mysql_query ($sql, $connection ) or die ('request "Could not execute SQL query" '.$sql);
	while ($row = mysql_fetch_assoc($sql_result)) {
		echo "<option value='".$row["city"]."'".($row["city"]==$_REQUEST["city"] ? " selected" : "").">".$row["city"]."</option>";
	}
?>
</select>
<input type="submit" name="button" id="button" value="Filter" />
  </label>
  <a href="search.php"> 
  reset</a>
</form>



<table width="700" border="1" cellspacing="0" cellpadding="4">
  <tr>
    <td width="90" bgcolor="#CCCCCC">From date</td>
    <td width="95" bgcolor="#CCCCCC">To date</td>
    <td width="159" bgcolor="#CCCCCC">Name</td>
    <td width="191" bgcolor="#CCCCCC">Email</td>
    <td width="113" bgcolor="#CCCCCC">City</td>
  </tr>
<?php
$showRecords=false;
if ($_REQUEST["string"]<>'') {
	$search_string = " AND (full_name LIKE '%".mysql_real_escape_string($_REQUEST["string"])."%' OR email LIKE '%".mysql_real_escape_string($_REQUEST["string"])."%')";
      $showRecords=true;	
}
if ($_REQUEST["city"]<>'') {
	$search_city = " AND city='".mysql_real_escape_string($_REQUEST["city"])."'";
      $showRecords=true;	
}

if ($_REQUEST["from"]<>'' and $_REQUEST["to"]<>'') {
      $showRecords=true;
	$sql = "SELECT * FROM ".$SETTINGS["data_table"]." WHERE from_date >= '".mysql_real_escape_string($_REQUEST["from"])."' AND to_date <= '".mysql_real_escape_string($_REQUEST["to"])."'".$search_string.$search_city;
} else if ($_REQUEST["from"]<>'') {
      $showRecords=true;
	$sql = "SELECT * FROM ".$SETTINGS["data_table"]." WHERE from_date >= '".mysql_real_escape_string($_REQUEST["from"])."'".$search_string.$search_city;
} else if ($_REQUEST["to"]<>'') {
      $showRecords=true;
	$sql = "SELECT * FROM ".$SETTINGS["data_table"]." WHERE to_date <= '".mysql_real_escape_string($_REQUEST["to"])."'".$search_string.$search_city;
} 
if($showRecords){
$sql_result = mysql_query ($sql, $connection ) or die ('request "Could not execute SQL query" '.$sql);
if (mysql_num_rows($sql_result)>0) {
	while ($row = mysql_fetch_assoc($sql_result)) {
?>
  <tr>
    <td><?php echo $row["from_date"]; ?></td>
    <td><?php echo $row["to_date"]; ?></td>
    <td><?php echo $row["full_name"]; ?></td>
    <td><?php echo $row["email"]; ?></td>
    <td><?php echo $row["city"]; ?></td>
  </tr>
<?php
	}
} else {
?>
<tr><td colspan="5">No results found.</td>
<?php	
}
}else{
?>
<tr><td colspan="5">Specify a search criteria.</td>
<?php
}
?>
</table>


<script>
	$(function() {
		var dates = $( "#from, #to" ).datepicker({
			defaultDate: "+1w",
			changeMonth: true,
			numberOfMonths: 2,
			dateFormat: 'yy-mm-dd',
			onSelect: function( selectedDate ) {
				var option = this.id == "from" ? "minDate" : "maxDate",
					instance = $( this ).data( "datepicker" ),
					date = $.datepicker.parseDate(
						instance.settings.dateFormat ||
						$.datepicker._defaults.dateFormat,
						selectedDate, instance.settings );
				dates.not( this ).datepicker( "option", option, date );
			}
		});
	});
	</script>

</body>
</html>

**Murderess** · 21-01-2013, 00:54

Adesso se si effettua la ricerca tramite nome o città escono i record ma escono anche quelli che non sono richiesti. SI cerca i recordo di "london" esce anche "new york, paris, etc" se invece si cerca per "from date" allora escono i record precisi ovvero from date "2013-01-20" nome or email "Solomon S. Moreno" city, "london" non esce nulla come è giusto che sia. Se al posto di london inserisci "mario" allora esce il record specifico. Ma se uno effettua la ricerca o via nome o città escono anche gli altri record.

**lucavizzi** · 21-01-2013, 01:00

E' tardi, lo rivedo domani.

**Murderess** · 21-01-2013, 01:05

Ci mancherebbe, anzi ti ringrazio per l'aiuto, comunque io son qua. Notte

**lucavizzi** · 21-01-2013, 21:47

Ciao, prova così:

Codice PHP:


<?php







error_reporting(0);

include("config.php");

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<title>MySQL table search</title>

<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.0/jquery.min.js"></script>

<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jqueryui/1.8.16/jquery-ui.min.js"></script>

<link href="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8/themes/base/jquery-ui.css" rel="stylesheet" type="text/css"/>

<style>

BODY, TD {

    font-family:Arial, Helvetica, sans-serif;

    font-size:12px;

}

</style>

</head>





<body>



<form id="form1" name="form1" method="post" action="search.php">

<label for="from">From</label>

<input name="from" type="text" id="from" size="10" value="<?php echo $_REQUEST["from"]; ?>" />

<label for="to">to</label>

<input name="to" type="text" id="to" size="10" value="<?php echo $_REQUEST["to"]; ?>"/>

 <label>Name or Email:</label>

<input type="text" name="string" id="string" value="<?php echo stripcslashes($_REQUEST["string"]); ?>" />

<label>City</label>

<select name="city">

<option value="">--</option>

<?php

    $sql = "SELECT * FROM ".$SETTINGS["data_table"]." GROUP BY city ORDER BY city";

    $sql_result = mysql_query ($sql, $connection ) or die ('request "Could not execute SQL query" '.$sql);

    while ($row = mysql_fetch_assoc($sql_result)) {

        echo "<option value='".$row["city"]."'".($row["city"]==$_REQUEST["city"] ? " selected" : "").">".$row["city"]."</option>";

    }

?>

</select>

<input type="submit" name="button" id="button" value="Filter" />

  </label>

  <a href="search.php"> 

  reset</a>

</form>





<table width="700" border="1" cellspacing="0" cellpadding="4">

  <tr>

    <td width="90" bgcolor="#CCCCCC">[b]From date[/b]</td>

    <td width="95" bgcolor="#CCCCCC">[b]To date[/b]</td>

    <td width="159" bgcolor="#CCCCCC">[b]Name[/b]</td>

    <td width="191" bgcolor="#CCCCCC">[b]Email[/b]</td>

    <td width="113" bgcolor="#CCCCCC">[b]City[/b]</td>

  </tr>

<?php

if(count($_POST)>0){//se ci sono dati post

    if ($_REQUEST["string"]<>'') {

        $search_string = " AND (full_name LIKE '%".mysql_real_escape_string($_REQUEST["string"])."%' OR email LIKE '%".mysql_real_escape_string($_REQUEST["string"])."%')";    

    }

    if ($_REQUEST["city"]<>'') {

        $search_city = " AND city='".mysql_real_escape_string($_REQUEST["city"])."'";    

    }

    

    if ($_REQUEST["from"]<>'' and $_REQUEST["to"]<>'') {

        $sql = "SELECT * FROM ".$SETTINGS["data_table"]." WHERE from_date >= '".mysql_real_escape_string($_REQUEST["from"])."' AND to_date <= '".mysql_real_escape_string($_REQUEST["to"])."'".$search_string.$search_city;

    } else if ($_REQUEST["from"]<>'') {

        $sql = "SELECT * FROM ".$SETTINGS["data_table"]." WHERE from_date >= '".mysql_real_escape_string($_REQUEST["from"])."'".$search_string.$search_city;

    } else if ($_REQUEST["to"]<>'') {

        $sql = "SELECT * FROM ".$SETTINGS["data_table"]." WHERE to_date <= '".mysql_real_escape_string($_REQUEST["to"])."'".$search_string.$search_city;

    } else {

        $sql = "SELECT * FROM ".$SETTINGS["data_table"]." WHERE id>0".$search_string.$search_city;

    }

    

    $sql_result = mysql_query ($sql, $connection ) or die ('request "Could not execute SQL query" '.$sql);

    if (mysql_num_rows($sql_result)>0) {

        while ($row = mysql_fetch_assoc($sql_result)) {

    ?>

      <tr>

        <td><?php echo $row["from_date"]; ?></td>

        <td><?php echo $row["to_date"]; ?></td>

        <td><?php echo $row["full_name"]; ?></td>

        <td><?php echo $row["email"]; ?></td>

        <td><?php echo $row["city"]; ?></td>

      </tr>

    <?php

        }

    } else {

    ?>

    <tr><td colspan="5">No results found.</td>

    <?php    

    }

}else{

    ?>

    <tr><td colspan="5">Please specify a search criteria.</td>

    <?php    

}

    ?>

</table>





<script>

    $(function() {

        var dates = $( "#from, #to" ).datepicker({

            defaultDate: "+1w",

            changeMonth: true,

            numberOfMonths: 2,

            dateFormat: 'yy-mm-dd',

            onSelect: function( selectedDate ) {

                var option = this.id == "from" ? "minDate" : "maxDate",

                    instance = $( this ).data( "datepicker" ),

                    date = $.datepicker.parseDate(

                        instance.settings.dateFormat ||

                        $.datepicker._defaults.dateFormat,

                        selectedDate, instance.settings );

                dates.not( this ).datepicker( "option", option, date );

            }

        });

    });

    </script>



</body>

</html>

Fammi sapere

Discussione: Php search problema

Strumenti discussione

Ricerca discussione

Visualizza

Php search problema

Re: Php search problema

Re: Re: Php search problema

Permessi di invio