Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I would follow this <a href="http://www.yiiframework.com/wiki/175/how-to-create-a-rest-api/" rel="nofollow">guide</a> on creating a REST API in Yii. After modifying the config urlManager entries, all of your API requests will use the APIController. You can then place the following code in the beforeAction of your APIController to return nothing if the user is a guest (Or an error message) </p> <pre><code>protected function beforeAction($event) { if (Yii::app()-&gt;user-&gt;isGuest) { echo "Invalid credentials"; Yii::app()-&gt;end(); } } </code></pre> <p>Note: The code above works for my purposes because all REST requests are sent via the same browser. (Which is already logged in and has a login cookie) </p> <p>If you replace that behavior with a new base controller placed in <code>protected/controllers</code> to force login, it will only apply to your pages that require a login and not your APIController. Here is an example of mine:</p> <pre><code>//Make sure all Controllers which require a login inherit from this class ControllerLoginRequired extends CController { public function runAction($action) { if (Yii::app()-&gt;user-&gt;isGuest &amp;&amp; 'site' != $this-&gt;route) { Yii::app()-&gt;user-&gt;returnUrl = $this-&gt;route; parent::redirect(array('site/login')); } else { parent::runAction($action); } } } </code></pre> <p>Everything explained will work for REST requests via the same browser in which the user has logged onto Yii. If you will have the need to expose your REST service to consumers that are not a browser logged into Yii, I believe you would have to come up with a custom authentication/token scheme.</p>
    singulars
    1. This table or related slice is empty.
    1. POYii RESTful authentication
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USMatt K
    1. USMikt25
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POYii RESTful authentication
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COYes I have already gathered some code from that tutorial, it's pretty much the only one out there explaining REST APIs in Yii and EVERYONE refers you to it. The problem still stands that my extension of CBehavior which forces guest login will override anything in this API controller because it's executed before it.
      singulars
      1. PO
      1. USMatt K
    2. COInstead of using a behavior to redirect to login I use a LoginRequiredController that is inherited by all controllers that require a login. If you do it this way, you could solve that problem at least. The APIController for REST would not inherit from that one.
      singulars
      1. PO
      1. USMikt25
    3. COExcellent! That works perfectly. If you can update your answer I will mark as accepted.
      singulars
      1. PO
      1. USMatt K
 

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