Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I know you say you don't want this advice, but don't write your own. The first thing I've done at every single job I've ever worked at is picked up some existing code or framework, often commercial but highly modified, and begun maintaining it. You'll seldom get the option to write your own, and doing so is a bad idea. It's hard, expensive, and somebody else has already written a better MVC PHP framework than you're likely to write.</p> <p>There are literally dozes of <a href="https://en.wikipedia.org/wiki/Comparison_of_web_frameworks#PHP" rel="nofollow noreferrer">mature PHP frameworks</a>, most of which have been around for over a decade. Choose one of them. It doesn't matter which one - they're all maintained by a dozen people at least as smart as you who've been writing MVC frameworks a lot longer, and have spent months or years refining their frameworks and listening to user input.</p> <p>All that said, if you want to write your own on your own time, as a hobby, so you're not wasting your boss's money, then by all means. There's a huge variety of interpretations of MVC. Some frameworks view views as basically templates. I personally think you can throw as much raw PHP in there as you'd like, so long as it's purpose is display, and you do the usual smart things like distilling out shared code into functions. Some frameworks have virtually no business logic in the models (where it belongs IMO) but have very heavy controllers. The best thing you can do is try other frameworks and see how they work, and which you like best, and decide what you'd like to see changed. Then, set out to change it in your own.</p> <p>You say you're almost ready to consider yourself a professional? The hardest lesson I had to learn was that professionals don't write their own low-level libraries. They don't reinvent the wheel on the company buck. They use off-the-shelf components and get the job done today, rather than a month from now. You don't want to use a slab of unfamiliar code? That's the biggest part of your life to come as a programmer - get used to it.</p>
    singulars
    1. This table or related slice is empty.
    1. POMVC as best practice for professional level programming?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USmeagar
    1. USmeagar
    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
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. CO+1 the last paragraph is simply beautiful it made my day!
      singulars
      1. PO
      1. USLukman
    2. COThanks, I wasn't lying. I love writing low level code. *Love* it. But doing so is absolutely wasting company time, and it'll get you fired.
      singulars
      1. PO
      1. USmeagar
    3. CO"I know you say you don't want this advice, but don't write your own." Fair call in all that you said-but I guess my plan isn't to go and build some gigantic beast that would take 12 months to write. I'm doing a lot of similar jobs at the moment - custom CMS systems, minisites with multiple galleries & forms and next month I have a CRM with time management facilities. I wanted to start consolidating my work into something re-usable even if it's piece by piece. "professionals don't write their own low-level libraries." Agreed - I use several 3rd party classes if they exist and do the job :-)
      singulars
      1. PO
      1. USniggles
 

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