Re^3: How to bind html page with PERL script to accept user input to Mysql database (eg. Phonebook)

[poj]

Adjust your form tag to location of cgi script like this <form method="post" action="/cgi-bin/subfolder/sqlconfig.cgi">. Put the html page in the htdocs folder.

In your cgi script I suggest to keep the database/sql processing separate and put all the cgi at the end of the script like this

my $message;
if ($rv == 1){
  $message =  q(Record has been successfully updated !!!);
}else{
  $message =  q(<b style="color:red">Error!!while inserting records</b
+>);
##  exit;
}

# return to html page
my $URL = '/contactsform.html';
my $refresh = 5;
print $q->header( 
 -type=>"text/html", -expires=>"-1m" , -refresh=>"$refresh ; URL=$URL"
+);

print $q->start_html,
$q->p($message),
$q->p( qq!This page returns to $URL in $refresh seconds,
Click <a href="$URL">here</a> to return now! ),
$q->end_html;

It would be advisable to add use strict but you will need declare all your variables with my. I can't see any reason to our

Also, whilst testing you might find it useful to add use CGI::Carp 'fatalsToBrowser' but remove it when the script is working.

poj

[newtoperl101]

It worked. Very cool. Thanks.