remysucre/gb.cgi

## gb.cgi
#!/usr/bin/env python

import cgi
import sqlite3

# Create or connect to the SQLite database
conn = sqlite3.connect('gb.db')
cursor = conn.cursor()

# Create a table to store guestbook entries if it doesn't exist
cursor.execute('''
    CREATE TABLE IF NOT EXISTS entries (
        id INTEGER PRIMARY KEY AUTOINCREMENT,
        message TEXT
    )
''')

# Function to fetch and display guestbook entries
def display_guestbook_entries():
    cursor.execute('SELECT * FROM entries ORDER BY id DESC')
    entries = cursor.fetchall()

    print("<h2>Guestbook Entries:</h2>")
    print("<ul>")
    for entry in entries:
        print(f"<li>{entry[1]}</li>")
    print("</ul>")

# Handle form submission
form = cgi.FieldStorage()

if "message" in form:
    message = form["message"].value

    # Insert user input into the database
    cursor.execute("INSERT INTO entries (message) VALUES (?)", (message,))
    conn.commit()

# Print the HTML content
print("Content-type: text/html\n")
print("<html>")
print("<head>")
print("<title>Guestbook</title>")
print("</head>")
print("<body>")
print("<h1>Guestbook</h1>")
print("<form method='post' action='gb.cgi'>")
print("<label for='message'>Leave a message:</label>")
print("<input type='text' name='message' id='message' required>")
print("<input type='submit' value='Submit'>")
print("</form>")
display_guestbook_entries()
print("</body>")
print("</html>")

# Close the database connection
conn.close()
	#!/usr/bin/env python

	import cgi
	import sqlite3

	# Create or connect to the SQLite database
	conn = sqlite3.connect('gb.db')
	cursor = conn.cursor()

	# Create a table to store guestbook entries if it doesn't exist
	cursor.execute('''
	CREATE TABLE IF NOT EXISTS entries (
	id INTEGER PRIMARY KEY AUTOINCREMENT,
	message TEXT
	)
	''')

	# Function to fetch and display guestbook entries
	def display_guestbook_entries():
	cursor.execute('SELECT * FROM entries ORDER BY id DESC')
	entries = cursor.fetchall()

	print("<h2>Guestbook Entries:</h2>")
	print("<ul>")
	for entry in entries:
	print(f"<li>{entry[1]}</li>")
	print("</ul>")

	# Handle form submission
	form = cgi.FieldStorage()

	if "message" in form:
	message = form["message"].value

	# Insert user input into the database
	cursor.execute("INSERT INTO entries (message) VALUES (?)", (message,))
	conn.commit()

	# Print the HTML content
	print("Content-type: text/html\n")
	print("<html>")
	print("<head>")
	print("<title>Guestbook</title>")
	print("</head>")
	print("<body>")
	print("<h1>Guestbook</h1>")
	print("<form method='post' action='gb.cgi'>")
	print("<label for='message'>Leave a message:</label>")
	print("<input type='text' name='message' id='message' required>")
	print("<input type='submit' value='Submit'>")
	print("</form>")
	display_guestbook_entries()
	print("</body>")
	print("</html>")

	# Close the database connection
	conn.close()