PHP SQL Limit

This example illustrates how to execute LIMIT operator of mysql in PHP.

In this example, we have created a limit.php page, in which we execute a query with LIMIT operator. In the LIMIT operator we put minimum and maximum limit of the table data. For example, the LIMIT 0,5 retrieves the row starting from row number 0 (the first one) to a maximum of 5 rows.

Table: emp

Source Code of limit.php


<?php

  $con = mysql_connect("localhost","root","root");

  if (!$con) {

  die('Could not connect: ' . mysql_error());

  }



  mysql_select_db("test", $con);

  $result = mysql_query("select * from emp limit 0,5");

  echo "<table border='1'>

  <tr>

  <th>id</th>

  <th>Name</th>

  </tr>";

  while($row = mysql_fetch_array($result)) {

  echo "<tr>";

  echo "<td>" . $row['emp_id'] . "</td>";

  echo "<td>" . $row['name'] . "</td>";

  echo "</tr>";

  }

  echo "</table>";

  

  mysql_close($con);

?>

Download Source Code

Output:

Related Tags for PHP SQL Limit:
php, sql, mysql, c, operator, exec, limit, this, opera, exe, example, execute, to, exam, e, il, it, li, mit, pe, im, in, m, tr, es, hp, how, rate, rates, cut, tor, xa, xamp, s, xe, at, my, is, ll, mpl, str, s, s, th, st, ple, pl, mi, o

«Previous Index Next»