Control the limit of database results on a php page using jquery

Question

Is there anyway to control the limit of entries from a database using jquery.

I have the PHP Data.php:

mysqli_query($con,"(select * from social order by id desc limit 30) order by id asc");

But I want to be able to edit the limit 30 and use $.get() to request the php again on calling a click function in jquery. Is this possible?

The $.get():

 $.get("Data.php", function (data3) {
     $(".data").html(data3);
 });

My code now looks like this:

`Data.php`:

$limit_amt = mysqli_real_escape_string($_GET['limit']);

$result = mysqli_query($con,"(select * from social order by id desc limit ".$limit_amt.") order by id asc");

while($row = mysqli_fetch_array($result))
  {
      echo "<tr class='border_bottom'>";
      echo "<th scope='col'>";
      echo "<div align='left'><span class='name'>".$row['name']."</span></div><br />";
      echo "<span class='text'>".$row['comunicate']."</span><br />";
      echo "<div align='right'><span class='time'>".$row['date']."</span></div>";
      echo "</th>";
      echo "</tr>";

  }

`Index.php`:

$.get("Data.php",{ limit: 40}, function (data3) { .
         $(".data").html(data3);

    });

Unclear, need more code. Do you mean you want a dynamic value in place of 30? Also what's your current $.get() code? — AyB
– AyB, Commented Feb 17, 2014 at 5:20

AyB · Accepted Answer · 2014-02-17 05:35:41Z

1

In your $.get():

//#btn would represent an HTML element like <input type="button" id="btn">
$("#btn").click(function(e){
    // I have given a static value here but you can change it to a variable or 
    // however you want to pass
    $.get("Data.php",{ limit: 40}, function (data3) { .
         $(".data").html(data3);
    });
}

In your Data.php:

//Fetching the value and saving into a variable
$limit_amt = mysqli_real_escape_string($_GET['limit']);
//Using the fetched value to change the limit amount
mysqli_query($con,"(select * from social order by id desc limit ".$limit_amt.") order by id asc");

answered Feb 17, 2014 at 5:35

AyB

11.6k4 gold badges34 silver badges49 bronze badges

Sign up to request clarification or add additional context in comments.

12 Comments

maxisme Over a year ago

There is also a Write-to.php page which sends the data (The data that Data.php receives) is that a problem?

AyB Over a year ago

Do you mean Write-to.php is also having a $.get() function call to Data.php? If so, that's not a problem, you can have multiple $.get() requests to the same file, just remember to use different parameter names.

AyB Over a year ago

Can you try $result = mysqli_query($con,"(select * from social order by id desc limit {$limit_amt}) order by id asc"); ? The second error is probably related to the first failed query. Also, this line: $limit_amt = mysqli_real_escape_string($con,$_GET['limit']);

AyB Over a year ago

Your query seems to be failing. Can you try echo mysqli_error($con); after mysqli_query? Alternatively you could try the actual query on your phpMyAdmin if you have access.

AyB Over a year ago

let us continue this discussion in chat

|

Sarath · Accepted Answer · 2014-02-17 06:57:53Z

0

I think there is some mistake in the query that you have used

please try

$result = mysqli_query($con,"(select * from social order by id desc limit ".$limit_amt.")");

instead of

$result = mysqli_query($con,"(select * from social order by id desc limit ".$limit_amt.") order by id asc");

answered Feb 17, 2014 at 6:57

Sarath

6085 silver badges12 bronze badges

Collectives™ on Stack Overflow

Control the limit of database results on a php page using jquery

My code now looks like this:

`Data.php`:

`Index.php`:

2 Answers 2

12 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

My code now looks like this:

Data.php:

Index.php:

2 Answers 2

12 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related

`Data.php`:

`Index.php`: