PHP Contact Form with Database Connection to SQLite: Process contact forms storing details using SQLite

This package can process contact forms storing details using SQLite.

It provides a class that implements functions to execute SQL queries to manage information of user contacts in an SQLite database.

Currently, it can:

- Create the database tables to store user messages and banned user IP addresses

- Add, update, and delete user messages

- Check, ban, and unban user computer IP addresses

- Search user messages by keyword

- Get submitted messages by the date

- Get the count of the total number of messages

Instructions:

class php_sqlite3_contact_form extends SQLite3
Functions:
- create_tables() // creates the tables if they don't exist
- get_sanitized_input($input) // sanitize input
- check_banned($ip) // check if an IP is banned
- ban_ip($ip) // add an IP to the banned table
- unban_ip($ip) // remove an IP from the banned table
- get_banned_ips() // get a list of banned IPs
- add_message($email, $subject, $message, $ip) // add a message
- update_message($id, $email, $subject, $message, $ip) // update a message
- delete_message($id) // delete a message
- get_messages() // get all messages
- get_message($id) // get a message by ID
- search_messages($keyword) // search messages by keyword
- get_messages_by_date_range($start_date, $end_date) // get messages in a date range
- count_messages() // count the total number of messages

Create:
//See an example for more detailed usage... but the basics are:
$cform = new php_sqlite3_contact_form('contact_form.db');
$cform->create_tables();

function show_messages_list($messages)
{
$the_str = "";
// as divs
while($row = $messages->fetchArray(SQLITE3_ASSOC))
$the_str .= show_message_row($row);
return $the_str;
} // end show_messages_list

echo show_messages_list($cform->get_messages());