Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I personally have a core framework (MVC/CodeIgniter) which I use for even the simplest static sites - Because someone will always say "Oh and can we have a shop" or a contact us form or ...</p> <p>The overhead of the frameworks themselves is negligible if they're not doing any work - so why not put them in?</p> <p>Another bonus is that you now know exactly what environment your modules will be in - you don't need to worry about maintaining one versions for sites with the framework and one for those without (One other benefit of using a framework is that it makes if far easier to maintain code in general - especially in multiple-developer environments.)</p> <p>Th templating engines provided by most frameworks (or easy extensions to them) are often useful even for static sites (custom controls like a news ticker or custom markup/js validation for certain controls)</p> <p>In short, unless you have extremely limited server resources (mobile device?) use a framework</p> <p>Edit: I'd add a note of caution - PHP is a very flexible, powerful language and when used well can create some truly fantastic sites. When used poorly, however, it is easy to make insecure websites.</p> <p>From your post, you seem relatively new to PHP/Frameworks. Can I suggest you make sure that the framework you pick enforces good behavior (as much as possible) </p> <p>CodeIgniter removes unsafe <code>$_POST</code> and <code>$_GET</code> variables, replacing them with safe equivalents. It also provides a parameterised mechanism for querying the database which helps avoid SQL inection attacks. These are important things to consider when comparing frameworks.</p> <p>I personally found CodeIgniter to be a good balance of maintainability, security, extensibility and functionality.</p>
    singulars
    1. This table or related slice is empty.
    1. POPHP is a framework the best choice for basic CMS websites
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USBasic
    1. USBasic
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POPHP is a framework the best choice for basic CMS websites
      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. COHi basiclife. it seems that you are on the same page as me. I have plenty of regular code, but have been wanting to make everything more efficient. What I envisage seems the same as what you describe. Ideally, I would have one set of code, which would have everything and the kitchen sink, which I can then merely turn on when requested so I have a massive advantage on other people offering to build new features from scratch. A further thing I have been researching is the possibility of using GIT or similar to push out all the new code to all users, so that they are ready if they need enabling.
      singulars
      1. PO
      1. USBen
    2. COAll of the above is in early stages, but it seems stack overflow might prove very useful along the way
      singulars
      1. PO
      1. USBen
    3. COYeah i'm new to frameworks. I have been trying to encompass all the security features from a lot of research, which I have since noticed codeigniter take care of with ease, as does fuel from first impressions. Ill try using the 404 override to route regular pages for the moment building the core system.
      singulars
      1. PO
      1. USBen
 

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