- Introduction
- Connecting to the Database
- Creating a Table
- Inserting Data
- Selecting Data
- Linking to the Calendar
- The Event Information Form
- Updating Data
- Next Steps
Like this article? We recommend
Like this article? We recommend
Like this article? We recommend
The Event Information Form
To administer the calendar system, we need to be able to add a new event. It's common for PHP forms to act as both form and action, so we'll add the actual form to the saveevent.php file that we created earlier, as shown in Listing 9.
Listing 9—The Event Information Form (saveevent.php)
<html>
<head><title>Event Information Form</title></head>
<body>
<h2>Event Information Form</h2>
<?php
import_request_variables('p', '');
if (isset($month)) {
// Connect to database.
$connection = mysql_connect ("localhost", "myusername", "mypassword")
|| die ( "Error connecting to database!" );
$insert_statement =
"insert into events ".
"(eventMonth, eventDay, eventYear, eventTitle, eventDesc)".
" values ".
"($month, $day, $year, '$title', '$description')";
if (mysql_db_query ( "mysql", $insert_statement)) {
echo("<p>Event '$title' added.</p>");
} else {
die ("Cannot add event.");
}
}
?>
<form action="saveevent.php" method="post">
Month: <input type="text" name="month" /><br />
Day: <input type="text" name="day" /><br />
Year: <input type="text" name="year" /><br />
Title: <input type="text" name="title" /><br />
Description:
<textarea name="description" cols="60" rows="4"></textarea><br />
<input type="submit" value="Save Event" />
</form>
</body>
</html>
When the page is loaded, it can be in one of two states:
Loaded for the first time, to add a new event
Loaded in response to submitting the form, to save an event
If the form has been submitted, each of the form variables (such as $month) will have been set by import_request_variables(), so the simplest way to check the state of the form is to use isset() to check for the presence of one of these variables.
If the form has been submitted, the page takes the information and enters it into the database, displaying a message showing that it has been added successfully, as shown in Figure 8. If not, the dynamic part of the page does nothing. In either case, the form is then displayed.
)
Figure 8 The page displays a message about the added event (if any) and
then the form itself.