Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <ol> <li><p>If you use a controller named ApisController, you have to fill mapresource with api. Example: <code>Router::mapResources('api');</code></p></li> <li><p>These are the default routes created:</p> <ul> <li>GET /apis.format RecipesController::index()</li> <li>GET /apis/123.format RecipesController::view(123)</li> <li>POST /apis.format RecipesController::add()</li> <li>PUT /apis/123.format RecipesController::edit(123)</li> <li>DELETE/apis/123.format RecipesController::delete(123)</li> <li>POST /apis/123.format RecipesController::edit(123) </li> </ul></li> </ol> <p>So if your homepage is at: <code>http://localhost/FC/</code>, you can access the resources at <code>http://localhost/FC/apis.format</code> .</p> <p>You have to substitute format with json or xml. If you want to use XML or JSON you have to declare it in <code>routes.php</code> adding <code>Router::parseExtensions();</code></p> <ol> <li><p>You have to rename your controller in ApisController and change every occurence of $this->Recipe in $this->Api, also you have to create a Model for Api and a table on the db. For xml and json you have to create views in <code>/app/Views/Apis/xml/index.ctp</code> and so on.</p> <p>// app/View/Apis/xml/index.ctp // Do some formatting and manipulation on // the $recipes array. $xml = Xml::fromArray(array('response' => $apis)); echo $xml->asXML();</p></li> </ol> <p>Last answer, your server normally answer with a 200 when there are no errors.</p> <p>I suggest you to begin with something easier and to look to Cakephp conventions. <a href="http://book.cakephp.org/2.0/en/getting-started/cakephp-conventions.html" rel="nofollow">http://book.cakephp.org/2.0/en/getting-started/cakephp-conventions.html</a></p> <p>Good work!</p>
    singulars
    1. This table or related slice is empty.
    1. POWhat parameters to create REST API using CakePHP
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USIdipaolo
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThanks so much! So if I'm sending a JSON request with data containing username and password, what do I declare in the controller? Also, what does the 123 represent? I've declared json in Router::parseextensions('json'); I've created a view in apis/json/index.ctp which has this: <?php echo json_encode ($url); ?> What do i fill in $url? is it gotten from the controller? I want to send uid and pwd and check, then if authenticated send a json response message saying "user authenticated". Thanks!
      singulars
      1. PO
      1. USAnugrah Pandey
    2. CO123 is the id of the api. When in a controller you do $this->set('info',$user) in a view you can use a var $info with the value of the $user var. I think you need also login logic in the controller.
      singulars
      1. PO
      1. USIdipaolo
    3. COEdit in the answer is my current controller. Could you tell me how to modify that to send a json request back as a message? Does $user contain the message string?
      singulars
      1. PO
      1. USAnugrah Pandey
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload