Creating the Input Forms and Scripts
| Before you can add any posts, you must add a topic to the forum. It is common practice in forum creation to add the topic and the first post in that topic at the same time. From a user's point of view, it doesn't make much sense to add a topic and then go back, select the topic, and add a reply. You want the process to be as smooth as possible. Listing 21.1 shows the form for a new topic creation, which includes a space for the first post in the topic. Listing 21.1. Form for Adding a Topic
Seems simple enoughthe three fields shown in the form, which you can see in Figure 21.1, are all you need to complete both tables; your script and database can fill in the rest. Save Listing 21.1 as something like addtopic.html and put it in your web server document root so that you can follow along. Figure 21.1. The topic creation form. To create the entry in the forum_topics table, you use the values from the $_POST["topic_title"] and $_POST["topic_owner"] variables from the input form. The topic_id and topic_create_time fields will be automatically incremented and added via the now() MySQL function, respectively. Similarly, in the forum_posts table, you use the values of $_POST["post_text"] and $_POST["topic_owner"] from the input form, and the post_id, post_create_time, and the topic_id fields will be automatically incremented or otherwise supplied. Because you need a value for the topic_id field to be able to complete the entry in the forum_posts table, you know that query must happen after the query to insert the record in the forum_topics table. Listing 21.2 creates the script to add these records to the table. Listing 21.2. Script for Adding a Topic
Lines 36 check for the three required fields we need to complete both tablesthe topic owner, a topic title, and some text for the post. If any one of these fields is not present, the user is redirected to the original form. Line 9 contains the database connection, which should be familiar to you by now. Lines 1216 create and insert the first query, which adds the topic to the forum_topics table. Note that the first field is left blank, so the automatically incrementing value is added by the system per the original table definition. The MySQL now() function is used to time stamp the record with the current time, at insertion. The other fields in the record are completed using values from the form. Line 19 shows the use of a handy function: mysqli_insert_id(). This function retrieves the primary key ID of the last record inserted into the database by this script. In this case, mysqli_insert_id() gets the id value from the forum_topics table, which will become the entry for the topic_id field in the forum_posts table. Lines 2227 create and insert the second query, again using a mixture of information known and supplied by the system. The second query adds the text of the user's post to the forum_posts table. Lines 3334 simply create a display string for the user, and the rest of the script rounds out the display. Save this listing as do_addtopic.phpthe name of the action in the previous scriptand place it in the document root of your web server. Complete the form and then submit it, and you should see the New Topic Added message. Figures 21.2 and 21.3 show the sequence of events. Figure 21.2. Adding a topic and first post. Figure 21.3. Successful addition of a topic and first post. In the next section, you'll put together two more pieces of the puzzle: displaying the topics and posts, and replying to a topic. |
EAN: 2147483647
Pages: 327