Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Since you asked me to point out this,</p> <p>There are so many flaws in your architecture</p> <p><strong>First</strong>,</p> <p>When you do it like,</p> <p><code>class apiCall extends mainClass {</code></p> <p>you break the <strong>Single Responsibility Principle</strong> and <strong>Liskov Substitution principle</strong> at the same time</p> <p><strong>Second</strong>,</p> <p>A controller should <strong>never</strong> echo anything</p> <p>MVC itself looks like </p> <pre><code>$modelLayer = new ModelLayer(); $view = new View($modelLayer); $controller = new Controller($modelLayer); $controller-&gt;indexAction($request); echo $view-&gt;render(); </code></pre> <p>You actually implementing something that is close to <strong>Model-View-Presenter</strong>, not <strong>MVC</strong></p> <p><strong>Third</strong></p> <p>Since your class starts from <code>api..</code> then there's no need to include that name in methods.</p> <p><strong>Fourth</strong>,</p> <p>You don't have to tightly couple <code>json_encode()</code> with generation logic. That method should only return an array, then you'd <code>json_encode()</code> that array. Benefits? 1) Separation of Concerns 2) You can event convert that array to <code>YAML</code> or <code>XML</code>, not only <code>JSON</code></p> <p>And also, you should avoid inheritance in your case. Write singular class that deals with ApiCalls. So, it would look like as,</p> <pre><code>final class ApiCall { /** * I'd use a name that makes sense * * @param string $username * @return array on success, FALSE on failure */ public function fetchByUsername($username) { $return = $api_auth-&gt;request( 'GET', $api_auth-&gt;url( '/cms-plug' ), array('username' =&gt; $username) ); if ($response !== false){ return $response; } else { return false; } } } </code></pre> <p>And you would use it like,</p> <pre><code>if (isset($_GET['username'])){ $api = new ApiCall(); $result = $api-&gt;fetchByUsername($_GET['username']); if ($result !== false){ // Respond as JSON die(json_encode($result)); } else { die('Wrong username'); } } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POOOP PHP - Get vars from one class and into a class within another file
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USYang
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POOOP PHP - Get vars from one class and into a class within another file
      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. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COUsing your examples, rebuilt it and everything is working as expected! Really appreciate you taking the time to write this out and point out the flaws. Still have much to learn.
      singulars
      1. PO
      1. USRyan Palmer
    2. CO@RyanPalmer There are good tutorials for beginners : `www.phpmaster.com`
      singulars
      1. PO
      1. USYang
 

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