PHP How do I display the search result in modal

[rmj091619]

This the code I used but but nothing happens

[CODE title="index"] <form method="POST" action="#">

<input type="text" name="id" placeholder="Enter query"/>

<input type="button" name="search" value="Search">

</form>







<script>

$.ajax({

type:"POST",

url: "search.php",

success: function(data)

{

debugger $('#mymodal').modal('toggle');

$('#mymodal:visible .modal-content .modal-body').html(e);

}

});

</script>



<div class="modal" id="mymodal">

<div class="modal-dialog">

<div class="modal-content">

<div class="modal-header">

<h4 class="modal-title">Modal Heading</h4>

<button type="button" class="close" data-dismiss="modal">&times;</button>

</div>

<!-- Modal body -->

<div class="modal-body">

</div>

<div class="modal-footer">

<button type="button" class="btn btn-danger" data-dismiss="modal">Close</button>

</div>

</div>

</div>

</div>[/CODE]



search.php


[CODE title="SQL"]<?php

if (isset($_POST['search']) && isset($_POST['id']) && ($_POST['id'] != ""))

{



$id=$_POST['id'];

$query="SELECT * FROM `upload` WHERE `keywords` LIKE '%$k%' ";



@mysql_connect("localhost","root","") or die("error");

mysql_select_db("lol") or die ("error");



$query= mysql_query($query);

$numrows=mysql_num_rows($query);

if($numrows >0)

{

while ($row =mysql_fetch_assoc($query))

{



$keywords=$row['keywords'];

$name2=$row['name2'];

$URL=$row['URL'];

echo "<h2><a href='$URL'>$name2</a></h2><br/><br/>";



}

}

else

echo "no result found";

}

else

{

echo "please enter some value in search";

}

?>[/CODE]

 

[Malcolm]

Hello,

Welcome to Code Forum!

Please place your code within </> feature. Click here for more information.

 

[Daniel]

There's quite a bit to unpack here, but you've got a couple things wrong with your form.

First of all, if you're using Ajax to get the search results, you don't need to actually use a form. Semantically it's right but it's unnecessary here. Secondly, your jQuery (from the looks of it) isn't actually doing much and won't run because it's not formatted correctly.

Here is your HTML:

<form>

    <input type="text" name="query" id="query" placeholder="Enter query" />

    <button type="button" id="searchButton">Search</button>

</form>

<div class="modal" id="searchModel" style="display: none;">

    <div class="modal-dialog">

        <div class="modal-content">

            <div class="modal-header">

                <h4 class="modal-title">Modal Heading</h4>

                <button type="button" class="close" data-dismiss="modal">&times;</button>

            </div>

            <!-- Modal body -->

            <div class="modal-body">

            </div>

            <div class="modal-footer">

                <button type="button" class="btn btn-danger" data-dismiss="modal">Close</button>

            </div>

        </div>

    </div>

</div>

Here is your JavaScript (jQuery):

[CODE lang="javascript" title="JavaScript"]$( '#searchButton' ).click(function() {

// Get the search term query.
var theQuery = $( '#query' ).val();

// Run an Ajax request to search.php.
$.ajax( {

url: 'search.php',
data: {
query: theQuery
},
success: function( data ) {

alert( data );

$( '#searchModel' ).show();

}

} );

} );[/CODE]

Here is your php:

<?php

// Catch empty post requests.
if ( ! isset( $_POST[ 'query' ] ) ) {

    return 0;

}

// Get the query from the post data.
$query = trim( $_POST[ 'query' ] );

// Return 0 if the query is empty.
if ( 1 > strlen( $query ) ) {

    return 0;

}

// Connect to the database.
@mysql_connect( 'locahost', 'root', 'root' ) or die();

// Select the database.
mysql_select_db( 'mydb' ) or die();

// Fetch the result from the database.
$response = mysql_query( 'SELECT * FROM tablename WHERE columnname LIKE %' . $query . '%'  );

// Count the rows.
$count = mysql_num_rows( $response );

if ( 0 < $count ) {

    // Return the response as JSON.
    return json_encode( $response );

} else {

    return 0;

}

I haven't tested this and you'll need to format the response, but it should get you on the right track to begin with though.