Hello.
I have web page for my band and would like to make an admin page with form fields to update tourdates on the web page. This so my bandmates can update this as well.
The section looks like this:

Any thoughts on how to go about to make that?

    Hi there Ronny. It's very straightforward, I used to create an editable section of websites for my clients. There are a few sections we could break this down into:

    1) Authentication system: You want only approved people to be able to make changes.
    2) Content submission/storage: An edit form for the user and upon submission, a way to store the content, whether it be via a file or a MySQL table.
    3) Content retrieval/display: When the page loads, that portion of the page needs to retrieve and format the content to display to the visitor.

    I'd handle it in that order. Create your authentication portion, move on to back end submission then set the public page up to pull the data and display it.`

    schwim Thanks. Some of this I know how to do. For the rest, I will ask if I get stuck šŸ˜ƒ

      You'll probably end up making a choice between collecting highly structured data -- like having VERY specific inputs for each tour date (venue name, date, time, status, website link)

      OR

      Offering a more general-purpose editor that lets your bandmates enter more free-form text. This tends to be trickier, but if you pull it off for the tour dates, you can probably use the functionality for other parts of your site. You'll probably have to use something like TinyMCE.

      5 days later

      sneakyimp Hello. ItĀ“s just for tour dates in the format you see in the picture. Any other edits to the site will be done by me. I checked out TinyMCE and itĀ“s a lot more than I need.
      I would like to have a page with some input fields for venue, date ect and on submit it will publish on the site.

          In addition to creating new entries, you should allow existing entries to be edited, in case there is a typo or a change in the information, or deleted. This a typical CRUD (Create, Read, Update, Delete) application.

          You would store the entries in a database table. When the web page is requested, you would query to get any entries with a date greater than or equal to the current date, sorted by the date, then loop over the query result to produce the output.

          Is your goal to learn to program in PHP, and you're testing your knowledge on your website? Or, maybe you're looking for a quick form, with "point/click wizards" to help you get something up and running quickly? I used to be in a band, Ha!

          If you really want to learn it, check YouTube for tutorials on ā€œbasic php mysql scheduleā€, or look for tutorials where you'll have to learn by not watching a video.

          If you just want a quick bit of code to link to a database w/ HTML forms, you might try Googling keywords like "php mysql html form builder", etc.

          Some of the older IDE's had some pretty nice HTML form builders. I think WeBuilder/ Rapid PHP (Blumentals software) has it, and their free trial gives you 30 runs (not 30 days. heck, i still have runs left on versions for the 2010's, but.. i'm abnormal)

          Write a Reply...