CODEWITHSUNDEEP
phpajaxjquery
matture
matture

Reputation: 297

Trouble with PHP success response via ajax - jquery

I am having a bit of trouble getting a search function working using ajax to bring up results as the user types in a name. This is the site in question (you can click view all to see what is searchable) http://ra-yon.com/beta/Test_sites/HFE/admin/contact.php The query in action http://ra-yon.com/beta/Test_sites/HFE/include/queryc.php?query=ra-yon&clause=email

The code in question

<html>
    <head>

<style type="text/css">
body
{
background:black;
color:black;
width:100%;

}
#center
{
width:90%;
height:110%;
background:white;
margin:0 auto;
text-align:center;
color:black;
}
#insert{
background:navy; color:white; font-family:impact; font-size:18px;width:170px; height:170px; border-radius:50%;
margin:0 auto;
float: left; margin-left: 100px;
top:200px;
position: relative;
}
#insert:hover

{
background:white;
color:navy;
}
label
{width:150px;}
td
{
    border:solid 2px black;
    max-width: 250px;
    text-align: center;
}
</style>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js"></script>
<script language="javascript" type="text/javascript">


function sendPHP(){

$('#table,#table2').css('display','none');
var query     = $('#searchname').attr('value');
var clause     = $('#searchclause').attr('value');
$.ajax({
    url: '../include/queryc.php?,
    type: 'POST',
  data: "query="+query+"&clause="+clause,
    dataType: 'html',
    success:
    function(data) {
        $(data).appendTo('#table');
    }
});
return false;
}



</script>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js"></script></head>

<body>
   <a href="index.php"> <h4 style="float:right; color:blue; position: relative; left:-100px;" id="goback"> Go back? </h4></a>
    <div id="center">
<div id="queryform1" >
    <a href="#" onclick="$('#table2').css('display','block');">View All?</a>
    <span style="color:black;">search</span> <input type='text' onKeyUp="sendPHP();" name='searchname' id="searchname" />

<span style="color:black;">search by</span> <select name="searchclause" id="searchclause">
    <option value="name">Name</option>
    <option value="email">Email Address</option>
    <option value="subject">Subject</option>
    <option value="date">Date</option>

</select>
<a href="../include/downloadcontact.php">Download file?</a>

<div id="table2" style="display: none; margin: 0 auto; position: relative; top:40px; max-width:700px;">
    <div id="viewall">
        <?php
        include '../include/include.php';
        $sql = 'select * from contactus' ;



//print_r($sql);
$result=mysql_query($sql);

        ?>
        <table>
<tbody>
<th>Name</th><th>Email</th><th>Subject</th><th style="width:200px;">Message</th><th>Date</th>
<tr>
<?php
while ($client = mysql_fetch_array($result, MYSQL_ASSOC)){
echo "
<tr>

<td >".$client[name]."</td>
<td >".$client[email]."</td>
<td >".$client[subject]."</td>
<td >".$client[message]."</td>
<td >".$client[date]."</td>




</tr>";
} ?>
</tbody></table>
</div></div><div id="table">TestTestTest</div>


</div></div>

</body>
</html>

Its a bit messy right now, I am planning on cleaning it up after I get it working. Thank you all so much!

Upvotes: 1

Views: 256

Answers (1)

Zak
Zak

Reputation: 7515

Checked your code in Console. Your function is failing. You are missing a single quote here:

    url: '../include/queryc.php?',

I use Google Chrome's Console as well as the Console found in the Firbug extension for Mozilla Firefox. They both are invaluable in helping sort out the minor issues

Upvotes: 2

Related Questions