Sample Database Query

 

<HTML>
<HEAD>
<TITLE>Sample Database Query</TITLE>
</HEAD>
<BODY>
   <STRONG>Querying an ODBC database.</STRONG>
   
   <FORM METHOD = "POST" ACTION = "index.pl">
      <INPUT TYPE = "TEXT" NAME = "QUERY" SIZE = 40 VALUE = "SELECT * FROM Authors"><BR><BR>
      <INPUT TYPE = "SUBMIT" VALUE = "Send Query">
   </FORM>
</BODY>
</HTML>

#!perl

use Win32::ODBC;
use CGI qw( :standard );

$queryString = param( "QUERY" );
$dataSourceName = "Products";

print header, start_html( "Search Results" );

if ( !( $data = new Win32::ODBC( $dataSourceName ) ) )
{
   print "Error connecting to $dataSourceName: ";
   print Win32::ODBC::Error();
   exit;
}

if ( $data->Sql( $queryString ) )
{
   print "SQL failed. Error: ", $data->Error();
   $data->Close();
   exit;
}

print "Search Results";
print "<TABLE>";

for ( $counter = 0; $data->FetchRow(); $counter++ )
{
   %rowHash = $data->DataHash();
 
   print <<End_Row;
   <TR>
   <TD>$rowHash{'ID'}</TD>
   <TD>$rowHash{'FirstName'}</TD>
   <TD>$rowHash{'LastName'}</TD>
   <TD>$rowHash{'Phone'}</TD>
   </TR>
End_Row
}

print <<End_Results;
</TABLE>
<BR>Your search yielded <B>$counter</B> results.<BR><BR>
<FONT SIZE = 2>
Please email comments to
<A href = "mailto:d\@d.com">Associates, Inc.</A>.
End_Results

print end_html;
$data->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.	Form based table editing
20.	Create a form with Perl code
21.	Code to Accept Input with the CGI Module
22.	Capitalize the first letter of each parameter using ucfirst
23.	A Form-Based Example
24.	Learn about the current CGI request
25.	Read the data for a CGI GET request
26.	Read the data passed to a script on the command line?
27.	Decoding the Input Data
28.	The POST Method
29.	Verifying a username and a password
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

Sample Database Query : Form « CGI « Perl

Related examples in the same category