Databases
StackOverflow2013
Postsdbo
POBest way to edit my CMS content
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POBest way to edit my CMS content
    primarykey
    data
    text
    <p>Hi I've built a php and mysql CMS, it's just for some news articles on my site. Currently I have a page which contains form fields and you change the content and it adds it to my database. I've not yet worked out how to add images or which method is the best. Is it easy to create an edit page where you can add images and change content on the one page.</p> <p>I've put together the following code and was thinking of adding jQuery to show form fields but would this meaning saving at each time to change any part of content.</p> <pre><code>&lt;div class="articleWrap"&gt; &lt;p&gt;2012&lt;span id="editYear"&gt;Edit&lt;/span&gt;&lt;/p&gt; &lt;h2&gt;Article title&lt;span id="editTitle"&gt;Edit&lt;/span&gt;&lt;/h2&gt; &lt;h4&gt;&lt;em&gt;Date&lt;/em&gt;&lt;span id="editDate"&gt;Edit&lt;/span&gt;&lt;/h4&gt; &lt;p&gt;bfewg uerwgiw h uih ui huihuihui huihui jio jio gtf ffti huoh uh fr f huih uh uifdijoj j ifodijo fdjioj iofdjio hfs hu ofhuop ogjdo ifho fhudohu fisj iojigji gpdjiodj fjido joijd jido jdoi dji fojgido jifodifhdh ud hugodhu ohuh uh ugodh uduhoh uoh oh u hudo giojfpj gipjipfjigdip gji hhuidh uihfudih ufhiudhu idhu idhuih udi hu hugreih ghe g rehuigeh gh ge hgurieh ghruei ghu eihgur ehg e g ghuriehg hr ghru eihg ruii ehghr hoej dsojfewio iehfj-i gvjl vjdsl hv h vhdjsih v.&lt;span id="editContent"&gt;Edit&lt;/span&gt;&lt;/p&gt; &lt;p&gt;&lt;span class="articleImage"&gt;images here&lt;span id="editImage"&gt;Edit&lt;/span&gt;&lt;/span&gt; &lt;span class="articleImage"&gt;images here&lt;span id="editImage"&gt;Edit&lt;/span&gt;&lt;/span&gt; &lt;span class="articleImage"&gt;images here&lt;span id="editImage"&gt;Edit&lt;/span&gt;&lt;/span&gt; &lt;/p&gt; &lt;/div&gt; </code></pre> <p>Any help or advise on tutorials would be very helpful. Many thanks</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USjtbandes
    1. UShuddds
    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. POBest way to edit my CMS content
      1. This table or related slice is empty.
      1. VTDownMod
    2. VO
      singulars
      1. POBest way to edit my CMS content
      1. This table or related slice is empty.
      1. VTDownMod
    3. VO
      singulars
      1. POBest way to edit my CMS content
      1. This table or related slice is empty.
      1. VTUpMod
    1. COIs there a reason you're building your own when there are so many good ones out there?
      singulars
      1. POBest way to edit my CMS content
      1. USddrace
    2. COThis was built as a quick way to edit articles, rather than impliment a whole CMS system which I don't currently want I made a simple one that does what I want. I login, can add email subscribers or edit my articles. I looked into Joomla and some other CMS systems but they do so much more than I need right now I just want something super simple. I just need a push in the direction of a good method for doing it this way.
      singulars
      1. POBest way to edit my CMS content
      1. UShuddds
    3. COThere are millions of ways to do this. One way--think [CRUD](http://en.wikipedia.org/wiki/Create,_read,_update_and_delete). Add button and form to add image, checkboxes and button to remove images, button and form to edit image properties.
      singulars
      1. POBest way to edit my CMS content
      1. USMarcus Adams
 

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