python database search with html

Question

I have created a database with python and the results are kept in a text file. I would like to create a simple html with a search button that looks through my database. My database would be accessible only on my computer.

My database looks something like this:

Reference | Name | Dimension
XXX         AAA     45

So, for example, if I search for a specific reference I would like to obtain their name or dimension obviously.

Is this even possible with python and where do I start ? I should mention I have basic skills in html and python.

Community · Accepted Answer · 2017-05-23 11:43:20Z

3

There are multiple ways to solve this:

Install a webserver on your local machine and write a full-fledged Python web application
Write a simple webserver and application in Python using BaseHTTPServer
Write an HTML/JavaScript application that doesn't use Python at all and parses the file for itself. Note that due to recently tightened restrictions, this may still require being served by a webserver.
Write a Python application that writes the database to a JavaScript file. While this is inflexible (you need to run it every time you want to update the database), it's also very simple - just encode your data with JSON and write it in a JavaScript file or element, like this.

htmlfile = open('database.html', 'w')
htmlfile.write('<html>...')
htmlfile.write('<script>var db = ' + json.encode(database) + ';</script>');

Either way, you're going to have to write HTML and JavaScript.

edited May 23, 2017 at 11:43

CommunityBot

11 silver badge

answered Sep 7, 2011 at 8:30

phihag

289k75 gold badges475 silver badges489 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Blair Over a year ago

Alternative to the first option: write a simple webserver in Python, using the HTTP server in the standard library. Examples are all over the web, for example, fragments.turtlemeat.com/pythonwebserver.php

phihag Over a year ago

@Balir Thanks - integrated into the answer.

JooMing · Accepted Answer · 2011-09-07 09:24:47Z

1

You have a very simple use case and if you already have a web server installed, then probably the simplest and quickest way is to use a CGI script written in python. Check out the cgi module: http://docs.python.org/library/cgi.html.

Basically you have to handle GET request to show a HTML form for asking the query string and the POST request to process the query and show the results.

answered Sep 7, 2011 at 9:24

JooMing

9322 gold badges7 silver badges14 bronze badges

Collectives™ on Stack Overflow

python database search with html

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related