Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>If you're not familiar with the Model-View-Controller pattern, reading up on it might be prudent. MVC is frequently the right starting place for high-level design of web applications.</p> <p>Also, a CMS is a big enough project you should consider using a PHP framework like CodeIgniter, Symfony, Zend, etc. to make your life easier. It removes a lot of the drudge work and common tasks.</p> <p><strong>Dynamic Page Creation and Display</strong></p> <p>I think you want to split it into two things: the text content (basically what you put in the forms) and the HTML templating surrounding that content.</p> <p>When you make a page or blog post, you would want to store the actual content (what you type into the creation form) in a database of some sort (not necessarily an RDBMS, but if you're trying to build MySQL skills it's a reasonable choice).</p> <p>Then you would use a separate function to bind that content into an HTML template and present it to the user when they load a given page.</p> <p><strong>URL Routing</strong></p> <p>To get nicer-looking URLs you can use something like apache's mod_rewrite. You can use that to convert a URL like this:</p> <p><code>posts/how-to-make-a-cms</code></p> <p>to this:</p> <p><code>posts.php?title=how-to-make-a-cms</code></p> <p>Then you can have posts.php read from GET as normal. How you choose to do the conversion is pretty open-ended.</p> <p>To avoid getting really complicated rewrites, people often just structure everything to go to a central routing script which figures out what class and method to call and what arguments to pass it. So it would rewrite the URL above to:</p> <p><code>main.php?a=posts/how-to-make-a-cms</code></p> <p>Then main.php would parse out the segments of that argument from GET and figure out where to send them. Like it might take <code>posts/show/how-to-make-a-cms</code> and do something like:</p> <pre><code>$o = new Posts(); $o-&gt;show("how-to-make-a-cms"); </code></pre> <p>If you do it that way, I think you can avoid mod_rewrite entirely as long as you're willing to accept only slightly pretty URLs, like this:</p> <p><code>mysite.com/main.php?/posts/show/how-to-make-a-cms</code></p> <p>I haven't done this type of thing before (because the frameworks do it so beautifully already), so I might be missing some minor details.</p>
    singulars
    1. This table or related slice is empty.
    1. POphp dynamically create new pages in custom cms
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USFoolishSeth
    1. USFoolishSeth
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POphp dynamically create new pages in custom cms
      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
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COIm not sure, that MVC is for someone who is not experienced in PHP.
      singulars
      1. PO
      1. USKamil
    2. CO@Kamil, MVC isn't specific to PHP so I don't know why you would say that. It's a broad design pattern that's important to understand for anyone at the level of designing something like a CMS.
      singulars
      1. PO
      1. USFoolishSeth
    3. CO@FoolishSeth, you said "Then you would use a separate function to bind that content into an HTML template and present it to the user when they load a given page." i know i need to put my title, subhead, content, etc ... in a template but how do i make each blog url be for example "www.sitename.com/this-is-post-1" or www.sitename.com/about.php" instead of www.sitename.com/?post_id=12 ? Is that possible or should i create every page with that url structure and then use a url rewrite to make the url actually be "pretty"?
      singulars
      1. PO
      1. USheyjohnmurray
 

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