php mysql select statement with Limit

本文关键字：with Limit statement select mysql php | 更新日期: 2023-09-27

我一直得到这个错误，但这个sql语句在mysql中工作得很好，它可能是一些愚蠢的东西，但我整个周末都在工作。

select e.* 
, t.nombre
, c.compania 
, c.nombre 
, c.apellido 
, c.ruc 
, c.direccion 
from envio e 
inner join cliente c on e.cliente_id = c.id 
inner join transporte t on t.id = e.transporte_id 
limit 0, 10;
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'limit 0, 10' at line 11

下面是var_dump结果:

string(263) "select e.* , t.nombre as transporte_nombre , c.compania , c.nombre , c.apellido , c.ruc , c.direccion from envio e inner join cliente c on e.cliente_id = c.id inner join transporte t on t.id = e.transporte_id limit 0, 10" MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'limit 0, 10' at line 11

这是我的代码，现在我使用2个类这1是我的db连接工作良好(与其他页面测试)，另一个是返回选择的。

if(!empty($_REQUEST['page']))
    $page = $_REQUEST['page'];
else
    $page = "1";
$limit = 10;    
if($page)
    $start = ($page - 1) * $limit; 
else
    $start = 0; 
require_once("../class/sql.php");
$db = new MySQL();  
require_once("../class/envios.php");
$envios = new Envio();
var_dump($envios->BuscaEnvios("",$start,$limit));
if(is_array($conditions))
    $consulta = $db->consulta($envios->BuscaEnvios($conditions,$start,$limit));  
else
    $consulta = $db->consulta($envios->BuscaEnvios("",$start,$limit));  
if($db->num_rows($consulta) > 0)
    $total_pages = $db->num_rows($consulta);
else 
    $total_pages = 0;

在"Envios"类中:

public function BuscaEnvios($conditions, $start, $limit)
{
        $sql = "select 
              e.*
            , t.nombre as transporte_nombre 
            , c.compania
            , c.nombre
            , c.apellido
            , c.ruc
            , c.direccion
        from envio e 
        inner join cliente c on e.cliente_id = c.id
        inner join transporte t on t.id = e.transporte_id ";
        if($conditions != "")
            $sql .= ' where '. implode(' AND ', $conditions);
        $sql .= " limit $start, $limit";
        return $sql;
}

在函数

中试试这段代码

if(sizeof($conditions)>0)
          {
            $sql .= " where ".implode(' AND ', $conditions);
          }
        $sql .= " limit $start, $limit";