Sfrgttk

I am trying to query a mongodb collection using php and a dropdown menu to provide the options for actually querying the database. However, this does not return anything. The dropdown menus allow users to query the database according to their needs and then they can view that data in the table below the dropdown menu.

I have tried tweaking certain fields and ensure that the fields match of that stored in mongodb but with no luck. I tried using a nested $or statement but I may not have implemented that correctly.

Also, if somebody could provide me with the context of how to use multiple drop-downs to query data from mongodb that would also be helpful or sample code structure where I can code this again.

Below is the code for the drop downs to query the database accordingly:

$host = "localhost:27017";

$userdb = "WestCrime";

$database = $userdb . ".WestCrime";

$manager = new MongoDB Driver Manager( "mongodb://{$host}/{$userdb}" );

$db = '';



if ( isset( $_POST[ 'submit' ] ) ) {



    $CrimeType = addslashes (strip_tags( $_POST['crimetype'] ));

    $month = addslashes (strip_tags( $_POST['month'] ));

    $reportedby = addslashes (strip_tags( $_POST['reportedby'] ));

    $fallswithin = addslashes (strip_tags( $_POST['fallswithin'] ));

    $loc = addslashes (strip_tags( $_POST['out'] ));

    $sort = addslashes (strip_tags( $_POST['sort'] ));

    $location = addslashes (strip_tags( $_POST['lsoa'] ));

    $limit = addslashes (strip_tags( $_POST['limit'] ));



    $filter = [

        ["CrimeID" => $CrimeType],

        ["Month" => $month],

        ["ReportedBy" => $reportedby],

        ["FallsWithin" => $fallswithin],

        ["LastOutcome" => $loc],

        ["LSOAname" => new MongoDBBSONRegex($location)]

    ];



    $option = ['limit' => [$limit]];

    $db = new MongoDB Driver Query( $filter, $option );



}

?>





<form action="query.php" method="POST">



  <select name="crimetype">

    <option value="Burglary"> Burglary </option>

    <option value="Other theft"> Other theft </option>

    <option value="Vehicle crime"> Vehicle crime </option>

    <option value="Violence and sexual offences"> Violence and sexual offences </option>

    <option value="Other crime"> Other crime </option>

    <option value="Criminal damage and arson"> Criminal damage and arson </option>

    <option value="Bicycle theft"> Bicycle theft </option>

    <option value="Public order"> Public order </option>

    <option value="Shoplifting"> Shoplifting </option>

    <option value="Drugs"> Drugs </option>

    <option value="Theft from the person"> Theft from the person </option>

    <option value="Anti-social behaviour"> Anti-social behaviour </option>

    <option value="Robbery"> Robbery </option>

    <option value="Possession of weapons"> Possession of weapons </option>

  </select>



  <select name="month">

    <option value=""> Month </option>

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

  </select>



  <select name="reportedby">

    <option value=""> Reported By </option>

    <option value="West Yorkshire Police"> West Yorkshire Police </option>

  </select>



  <select name="fallswithin">

    <option value=""> Falls Within </option>

    <option value="West Yorkshire Police"> West Yorkshire Police </option>

  </select>





  <select name="lsoa">

    <option> LSOA name </option>

    <option value="Bradford"> Bradford </option>

  </select>



  <select name="out">

                                    <option value="Investigation complete; no suspect identified"> Investigation complete; no suspect identified </option>

                                    <option value="Awaiting court outcome"> Awaiting court outcome </option>

                                    <option value="Under investigation"> Under investigation </option>

                                    <option value="Unable to prosecute suspect"> Unable to prosecute suspect </option>

                                    <option value="Local resolution"> Local resolution </option>

                                    <option value="Action to be taken by another organisation"> Action to be taken by another organisation </option>

                                    <option value="Further investigation is not in the public interest"> Further investigation is not in the public interest </option>

</select>



<select name="limit">

    <option> Limit </option>

    <option value="1"> 1 </option>

    <option value="2"> 2 </option>

    <option value="3"> 3 </option>

    <option value="4"> 4 </option>

    <option value="5"> 5 </option>

</select>



<select name="sort">

    <option> Sort </option>

    <option value="1"> Asc </option>

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

</select>

<br>

<br>



<button type="submit" name="submit"></span> Search</button>

Here the queried data is displayed into a table using the separate columns:

<table width="100%" cellspacing="0">



    <thead>

        <tr>

            <th>Reported by</th>

            <th>Falls within</th>

            <th>Longitude</th>

            <th>Latitude</th>

            <th>Location</th>

            <th>LSOA code</th>

            <th>LSOA name</th>

            <th>Crime type</th>

            <th>Last outcome category</th>

            <th>Context</th>

        </tr>

    </thead>





<?php

$cursor = $manager->executeQuery( $database, $db );



foreach ( $cursor as $doc ) {

?>

<tbody>

    <tr>

        <td>

            <?php echo $doc->ReportedBy;?> </td>

        <td>

            <?php echo $doc->FallsWithin;?> </td>

        <td>

            <?php echo $doc->Longitude;?> </td>