Form based table editing : Form « CGI « Perl






  1. Perl
  2. CGI
  3. Form

Form based table editing

     


#!c:/perl/bin
use Win32::OLE;
use Win32::OLE::Const 'Microsoft ActiveX Data Objects';

$table    = "employee";
$conn = Win32::OLE->new("ADODB.Connection");
$rs   = Win32::OLE->new("ADODB.Recordset");
$conn->Open("contact");

print "Content-Type:text/html\n\n";
print "Contact Database<br>";
print "<table>";
print "<tr>";
print "<th>ID</th>";
print "<th>First Name</th>";
print "<th>Last Name</th>";
print "<th>Town</th>";
print "<th>Edit?</th>";
print "</tr>";

$sql = "SELECT * FROM $table";
$rs->Open($sql, $conn, 1, 1);
while(!$rs->EOF){
   $id        = $rs->Fields('id')->value;
   $firstname = $rs->Fields('firstname')->value;
   $lastname  = $rs->Fields('lastname')->value;
   $town      = $rs->Fields('town')->value;
   print "<tr><td>$id</td><td>$firstname</td><td>$lastname</td><td>$town</td>";
   print "<form name=editrec" . $id . " method=post action=editcontact.pl>";
   print "<input type=hidden name=id value=$id>";
   print "<td><input type=Submit name=submit value=Edit></td>";
   print "</form>";
   print "</tr>";
   $rs->MoveNext;
  }
print "</table></div>";
$rs->Close;
$conn->Close;








Related examples in the same category

1.Form Input Types
2.Demonstrates GET method with HTML form.
3.Demostrates POST method with HTML form.
4.Demonstrates use of CGI.pm with HTML form.
5.Create HTML form with CGI
6.Get form submitted value
7.Using param() function to get parameter
8.Using CGI function to check the parameter
9.Create a form and set the method and action
10.Create a form with submit button
11.Process form with regular expression: first name and last name
12.Process form with regular expression: date
13.Process form with regular expression: time
14.Generate the HTML form
15.Printing the Name Input Using the CGI Module
16.Get form value with param
17.Generate and Process Forms
18.Form Mail
19.Create a form with Perl code
20.Code to Accept Input with the CGI Module
21.Capitalize the first letter of each parameter using ucfirst
22.A Form-Based Example
23.Learn about the current CGI request
24.Read the data for a CGI GET request
25.Read the data passed to a script on the command line?
26.Decoding the Input Data
27.The POST Method
28.Verifying a username and a password
29.Sample Database Query
30.Writing a cookie to the client computer
31.Add a New Phone Number
32.Sessions - Preserving State
33.Separate the form and perl script
34.Add form data to database
35.Passing parameter to perl CGI code
36.EMail sending form
37.Guest book form
38.Data-Entry Forms in Web Pages
39.Using LI
40.Using the option select box
41.Reading text in textarea
42.Querying all the parameters