Databases
StackOverflow2013
Postsdbo
POPage Class Guidance
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POPage Class Guidance
    primarykey
    data
    text
    <p>I'm trying to figure out how to query a database and output the results in oop on multiple pages.</p> <p>The pages will have different queries and number of queries and some will have similar layouts whilst others will be completely different.</p> <p>Is this the right direction to go in to have classes for each page that hold the required sql fields and possibly the html for outputting the data? Or would a more experienced oop designer do it differently?</p> <p>e.g (apologies for the terrible pseudo code):</p> <pre><code>abstract class Page(){} class SearchPage extends Page() { private $sql; function output(){}; } class ProfilePage extends Page() { private $sql; private $sql2; function output(){}; ← dynamic method that can output both sql and sql2?? } class DatebaseFetch() { __construct($sql) { $this-&gt;$sql=$sql; } function results() { ...get db results...; return $results;} } } class PageFactory() { function getPage($page) { return new $page.Page(); } } $page=PageFactory::getPage($_SERVER['PHP_SELF']); $query=$page-&gt;sql; $db=new DatabaseFetch($query); $results=$db-&gt;results(); $page-&gt;output($results); </code></pre> <p>The whole point of the code is to get the oop equivalent of this procedural code:</p> <pre><code>Search Page: $db=new PDO("mysql:host=localhost;dbname=test;","test","test"); $db-&gt;query("select search items from table"); while($row=$db-&gt;fetch(PDO::FETCH_ASSOC)){ echo &lt;html&gt;....; } Profile Page: $db=new PDO("mysql:host=localhost;dbname=test;","test","test"); $db-&gt;query("select profile items from table"); while($row=$db-&gt;fetch(PDO::FETCH_ASSOC)){ echo &lt;html&gt;....; } </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USmrmryb
    1. USmrmryb
    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. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POPage Class Guidance
      1. This table or related slice is empty.
      1. VTClose
    2. VO
      singulars
      1. POPage Class Guidance
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    3. VO
      singulars
      1. POPage Class Guidance
      1. This table or related slice is empty.
      1. VTUpMod
    1. COIs it appropriate? I don't think there's a definition of "appropriate" here to decide with. Choose the approach that is 1) maintainable, and 2) productive.
      singulars
      1. POPage Class Guidance
      1. USWaleed Khan
    2. COWhat I'm trying to get across is whether this oop is well or badly designed. For example would it conflict with the principles of SOLID?
      singulars
      1. POPage Class Guidance
      1. USmrmryb
    3. COYou might want to look into MVC pattern. It has a distinct separation of concerns, which I think is the most 'appropriate' philosophy to go by (for myself).... it's all subjective
      singulars
      1. POPage Class Guidance
      1. USdanronmoon
 

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