Urgently Need Help

humayoo · October 9th, 2007, 05:05 AM

Dear All,

i want to make advance search engine in PHP.i have 7 fields and all fields are option.if user select only 4 filed,then search engine will display the result according to 4 selected field.?

how to do it ? if anybody have any idea or document or book or article please share with me? its very urgent.

thanks to all in advance

humayoo

cyber_kaley20 · October 10th, 2007, 12:54 AM

check box
//////////
data1
data2
data3
data4
data5
data6
data7
///////
search mytextbox >>>>

im going to select a 7 fields

$sql = "SELECT * FROM articles WHERE

if (data1 = "checkbox") //////find the data with selected
     {
          $sql .= "data1 LIKE '$mysearchtext'";/////// if the data1

                                                //////it selected
      }
if ($data2 = "checkbox")
      {
    $sql .= "data2 LIKE '$mysearchtext'";
       }
if($data3 ="checkbox")
     {
        $sql .= "data3 LIKE '$mysearchtext'";
     }
if($data4 = "checkbox")
     {
     $sql .= "data4 LIKE '$mysearchtext'";
     }

if($data5 = "checkbox")
     {
     $sql .= "data5 LIKE '$mysearchtext'";
     }

if($data6 = "checkbox")
     {
     $sql .= "data6 LIKE '$mysearchtext'";
     }

if($data7 = "checkbox")
     {
    $sql .= "data7 LIKE '$mysearchtext'";
     }

$query = mysql_query($sql) or die(mysql_error());
$row_sql = mysql_fetch_assoc($query);
$total = mysql_num_rows($query);

# if($total>0) {
# while ($row_sql = mysql_fetch_assoc($query)) {//echo out the results
# echo ''.$row_sql['title'].'<br />'.$row_sql['subtitle'].'';
# }
# } else
# {
# echo "No results to display";
# }

Escaler

ludigova · October 16th, 2007, 02:39 PM

Hello
Maybe you can use this Example

<!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=iso-8859-1" />
<title>Untitled Document</title>
</head>
<?Php
    extract($_GET);
    extract($_POST);
    $Sql= "Select * FROM MyTable WHERE ";
    if (isset($textfield1))
        $Sql.="MyTable.field1 = $textfield1 AND ";

    if (isset($textfield2))
        $Sql.="MyTable.field2 = $textfield2 AND ";

    if (isset($textfield3))
        $Sql.="MyTable.field3 = $textfield3 AND ";

    if (isset($textfield4))
        $Sql.="MyTable.field4 = $textfield4 AND ";

    if (isset($textfield5))
        $Sql.="MyTable.field5 = $textfield5 AND ";

    if (isset($textfield6))
        $Sql.="MyTable.field6 = $textfield6 AND ";

    if (isset($textfield7))
        $Sql.="MyTable.field7 = $textfield7 AND ";

        //You can change the WHERE part as you wish, in order to do what you want

    //$Rs = mysql_query($Sql);
    /*
    .Do everything you need with the RecordSet Rs
    .
    .
    etc*/
    echo $Sql;
?>
<body>
<p>Seach Filter:</p>
<FORM ENCTYPE="multipart/form-data" id="form1" name="form1" method="post" action="Prueba.php">
    <table border="1" width="100%">
        <tr>
            <th>textfield1</th>
            <th>textfield2</th>
            <th>textfield3</th>
            <th>textfield4</th>
        </tr>
        <tr>
            <td>
                <input type="text" name="textfield1" />
            </td>
            <td>
                <input type="text" name="textfield2" />
            </td>
            <td>
                <input type="text" name="textfield3" />
            </td>
            <td>
                <input type="text" name="textfield4" />
            </td>
        </tr>
    </table>
    <br/>
    <table border="1" width="100%">
        <tr>
            <th>textfield5</th>
            <th>textfield6</th>
            <th>textfield7</th>
        </tr>
        <tr>
            <td>
                <input type="text" name="textfield5" />
            </td>
            <td>
                <input type="text" name="textfield6" />
            </td>
            <td>
                <input type="text" name="textfield7" />
            </td>
        </tr>
    </table>
    <input name="Agregar" type="submit" />
</form>
</body>
</html>

Ludigova