By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,836 Members | 2,028 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,836 IT Pros & Developers. It's quick & easy.

Insert data into MySQL from HTML Form using .psp script

P: n/a
I am attempting to insert data from a HTML form using a .psp script.
I can not find how to link the data that is inserted into the form to
the variables in the .psp script to then insert into the MySQL Insert
statement. I am familiar with PHP, where you would write
$_POST(['field']), however I can not find the equivalent in PSP. I
believe that this is the my missing piece. Technically, what is
occurring that that when I click the 'Submit' button, it is inserting
NULL field values into the db.

Sample code is below ::

HTML FORM CODE

<html>
<head>
<link rel="stylesheet" type="text/css" href="./styles/
projectpage.css">
</head>

<h2>PAGE</h2>
<form name="input_form" action="insert_go.psp" method="post">
Date:
<input type="text" name="date" id="date">
<br>
Time:
<input type="text" name="time" id="time">
<br>
Activity:
<input type="textarea" rows="20" cols="40" name="activity"
id="activity">
<br>
Next Steps:
<input type="textarea" rows="20" cols="40" name="notes" id="notes">
<br>
<input type="submit" value="Submit">
</form>
</html>

Below is the psp script

<%
import MySQLdb

host = 'localhost'
user = 'user'
passwd = 'somepass'
db = 'MyDB'

conn = MySQLdb.connect(host, user, passwd, db)
mysql = conn.cursor()

sql = ("""INSERT INTO activity VALUES (date,time,activity,notes);""");

mysql.execute(sql)

conn.commit()
mysql.close()
conn.close()
%>

<html>
<p>Sucess!</p>
</html>

Thanks for any assistance.

B
Nov 8 '08 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.