Search jQuery

jQuery Forum

Live mysql database querying to show number of rows

in Using jQuery • 12 years ago

Basically i have a form with jqueryui implemented (autocompletes) and I need the form to display the number of current results as the user fills the form, i.e. once the user has finished inputting data into one field, the form will query the database with the current form details and return just the number of results ($mysql_num_rows)

Does anyone know a solution to this?

Replies(2)

wavetydes..

Re: Live mysql database querying to show number of rows

12 years ago

zmastaa,

You could bind to the change event, but that might get to be too much, here is an example of binding to the blur event.

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>yourform</title>
<script type="text/javascript" src="./js/jquery.js"></script>
<script>
$(document).ready(function() {
$('.blurCapture').blur(function() {
returnNumRows()
});
});
function returnNumRows(){
var checkValues = "";
var delim = "";
$(".blurCapture").each(function(){
if ($(this).val() != ""){
checkValues += delim + $(this).attr('name') + '=' + $(this).val();
delim = "&";
}
});
$.post("checkNumRows.php", checkValues,
function(results){
$('#numrows').html("Number of Records: " + results);
});
}
</script>
</head>
<body>
<form action="yourfile.php" method="post" enctype="application/x-www-form-urlencoded">
<label for="fullname">Full Name</label>
<input class="blurCapture" type="text" name="fullname" value="">
<label for="address1">Address 1</label>
<input class="blurCapture" type="text" name="address1" value="">
<label for="address2">Address 2</label>
<input class="blurCapture" type="text" name="address2" value="">
</form>
<div id="numrows">Number of Records: 0</div>
</body>
</html>

Then your php file would parse that data like so:

<?php
// checkNumRows.php
$connection = mysql_connect('localhost', 'mysqluser', 'mysqlpass');
$db = mysql_select_db('database', $connection);
// build sql string
$sql="select * from yourtable where ";
$delim = "";
foreach ($_POST as $name => $value) {
if ($name != "undefined" && $value != ""){
$sql .= $delim.$name."='".$value."'";
$delim = " and ";
}
}
$results = mysql_query($sql);
$numrows = mysql_num_rows($results);
print $numrows;
?>

Cheers.

zmastaa

Re: Live mysql database querying to show number of rows

12 years ago

thanks for the reply, however i went a slightly different route i used jquery.ajax to simply query the database and return the value to the page

<p><tt id="results"></tt></p>
<script type="text/javascript">
function numRows() {
var querydb = $("form").serialize();
$.ajax({
url: "checkNumRow.php",
dataType: "text",
data: querydb,
error: $("#results").text(),
success: function(result){
$("#results").text(result);
},
});
}
// Recheck the database on each form change, on the autocompletes just add numRows to the Success function
$(":checkbox, :radio").click(numRows);
$("select").change(numRows);
$("input").blur(showValues);
$("input").focusout(showValues);
numRows();
</script>

in the checkNumRows.php

// build the sql string then....
$results = mysql_query($sql);
$numrows = mysql_num_rows($results);
if ($numrows=="1"){
echo $numrows . " results found";
} else {
echo $numrows . " results found";
}

Very easy after you do it once

Top Reply

Response title

Attachments

jQuery Forum

Live mysql database querying to show number of rows

Replies(2)

Re: Live mysql database querying to show number of rows

Re: Live mysql database querying to show number of rows

Statistics

Tags

Actions