Simple API class

Ok, so I’m trying to setup the API to allow requests that filter the results by using multiple “WHERE” conditions… However, I keep getting this 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 'AND AND' at line 1

Here’s the API setup call:

  $api = new Api($db);

  $api->register('quotes')
    ->setTable('quotes')
    ->setOutput(array(
      'xml'
    ))
    ->setKey(true)
    ->setColumns(array(
      'id',
      'author',
      'text',
      'category',
      'citation',
      'adult_lang',
      'release_ver'
    ))
    ->setWhere(array(
      'category' => array(
        'route'     => 'category',
        'connect'   => 'AND'
      ),
      'author' => array(
        'route' => 'author',
        'connect' => 'AND'
      )
    ))
    ->setLimit(200);

    $api->render($_GET);

Any ideas?

Nevermind, I’ve solved it…

What format is the read me file?

Nice class

Just wanted to let you know that you have quite a few typos in the class itself. Most are in regards to the Error message strings, but some are in the actual code itself which may inhibit some functionality of the class from working properly… (haven’t fully tested to verify that claim tho)

Here’s an example of one such typo I found:

$this->_namespaces[$this->_current_namaspace]['table'] = $table;

Whereas the correct version would be:

$this->_namespaces[$this->_current_namespace]['table'] = $table;

I found about 10 or more examples of “_namaspace” being used rather than “_namespace”. Fixed them on my end, but you may want to release another version with them fixed for everyone else.

Thanks for a great class though!

Hello, got this working but I wondered if someone could assist me with code—this is for a white page directory for the US, I have it working with the lastname but cannot get it to work with both This would be the code for SQL , which is un-related to this but it will give you a idea what I am trying to do

WHERE lastname = ’$lastname’ AND firstname LIKE ’%$firstname’

and this is for my API code

->setWhere(array(‘lastname’ => array(‘route’ => ‘lastname’))

how would I code this for first and last name?