Delete Blog Post
Firstly, I needed the blog page to display edit and delete buttons on each post but only whilst the admin is logged in. So within the php I wrote the html for the buttons in the blog post loop in blog.php - the pseudo code is basically if user is logged in, display these buttons. I wrapped the buttons in a form so I could use the method="post" attribute to provide information to the php script. The form includes a hidden input type, the value of which contains the $id variable of the post you want to delete. When the delete button is clicked it runs deletepost.php which simply executes an SQL query to delete the record from the table where the id=$id ($id is the variable which holds the id of the post you want to delete).
You can see on the image above that when logged in, there are options to logout, edit or delete in the head of each blog post.
Edit Blog Post
The edit button works in much the same way although the process is slightly different. When clicked, the edit button takes the user to editpost.php which features an html form reminiscent of the blog post form in the admin area. However this form is already filled in with the appropriate content by setting the field values to variables that contain data taken from the blog post you want to edit. This way, the form fields already have the existing blog post content ready for it to be edited by the user. When this form is submited, it then runs edit.php which executes an SQL query to update this particular record in the table with the new data.
In the image above you can see that when the edit button is clicked, it takes the user to the edit blog post page which features a form that is already populated with the existing blog post content ready to be edited.
Gigs Page
I have made the gigs page editable with PHP and MYSQL in exactly the same way as the blog page. The image below shows what the gigs page looks like when the admin is logged in.
The edit and delete options work in exactly the same way as I described for the blog.
The image below is the admin area page which fetaures forms to make a blog post and to add a gig.
Upload a File with Blog Post
The admin has the option to upload a file with their blog post. If they choose to do so, the file is uploaded to the /blogfiles directory and the file name (image.png or audio.mp3) is inserted into the database. Then in the blog post php script, the script reads; if the file name contains 'jpg', 'png', 'gif' or 'jpeg' then wrap it in <"img"> tags. If the file name contains 'mp3' then wrap it in <"a"> tags and show mp3image.png - when this image is clicked it goes to the audio file so it can be listened to.
