title: Using Python CGI and MySQL to save the user inputed from a form into MySQL table
body: <p>I have two .cgi scripts as of right now.  I am trying to have a user input a keyword on one website (the first cgi script) and then it will send that data to the next cgi script.  It currently sends it to the next page fine but I also want to save the information the user types in to a MySQL table named "keywords".  I am having trouble figuring out how exactly to do that.  Here is my first cgi script that prompts the user for a keyword:</p>
  
  <pre><code>#!/usr/bin/env python
  import cgi
  import cgitb
  cgitb.enable()
  
  form = cgi.FieldStorage()
  keyword = form.getvalue('keyword')
  
  print 'Content-type: text/html\r\n\r'
  print '&lt;html&gt;'
  print '&lt;h1&gt;Please enter a keyword of your choice&lt;/h1&gt;'
  print '&lt;form action="results.cgi" method="post"&gt;'
  print 'Keyword: &lt;input type="text" name="keyword"&gt;  &lt;br /&gt;'
  print '&lt;input type="submit" value="Submit" /&gt;'
  print '&lt;/form&gt;'
  print '&lt;/html&gt;'
  </code></pre>
  
  <p>Here is my second .cgi file.  In this I am trying to print the keyword that was typed in from the previous page (that works fine) and also send it and save it my mysql table (thats where the problem is):</p>
  
  <pre><code>cgitb.enable()
  
  form = cgi.FieldStorage()
  
  keyword = form.getvalue('keyword')
  
  print 'Content-type: text/html\r\n\r'
  print '&lt;html&gt;'
  print keyword
  print '&lt;/html&gt;'
  
  db = MySQLdb.connect(host="", user="",   passwd="", db="")
  cursor = db.cursor()
  sql = """INSERT INTO keywords(keywords) VALUES (keywords)"""
  cursor.execute(sql)
  cursor.fetchall()
  db.close()
  </code></pre>
  
  <p>Basically I am new to MySQL in general and I'm pretty sure it comes down to my mysql code being all messed up and doing what I want it to do.  It doesn't fetch any errors, just doesn't add anything to the table.</p>