Actually I am creating a database by the help of perl and mysql, part of retrieving has been done through perl but now I can't understand how to display it's output on a webpage.So can anyone tell me how to do this?
code is: - # PERL MODULES WE WILL BE USING
-
use DBI;
-
use DBD::mysql;
-
-
-
# CONFIG VARIABLES
-
$platform = "mysql";
-
$database = "purchase";
-
$port = "3306";
-
$host = "localhost";
-
$user = "root";
-
$pw = "";
-
-
#DATA SOURCE NAME
-
$dsn = "dbi:mysql:$database:localhost:3306";
-
-
-
# PERL DBI CONNECT
-
$DBIconnect = DBI->connect($dsn, $user, $pw)or die "unable to connect:$DBI::errstr\n";
-
-
#PREPARE THE QUERY
-
$query = "SELECT * FROM naipone WHERE Fileno = '4-56/2008-09/AG(S)'";
-
$query_handle = $DBIconnect->prepare($query);
-
-
#EXECUTE THE QUERY
-
$query_handle->execute();
-
-
#BIND TABLE COLUMNS TO VARIABLES
-
$query_handle->bind_columns(\$Sanctionamt, \$Availableamt, \$Dateoffirstrelease, \$Amtoffirstrelease, \$Dateofsecondrelease, \$Amtofsecondrelease, \$Netamt, \$Fileno, \$fileinitiation, \$nameofindenter, \$materialreceivedpurchasedandpaymentreleased, \$nameoffirm, \$completeaddressoffirm, \$head, \$subhead, \$sanctioneddate, \$sanctionedamt, \$progressivebal, \$sanctionedbal, \$billdate, \$billamt, \$billbal);
-
-
-
#LOOP THROUGH RESULTS
-
while($query_handle->fetch())
-
{
-
print"$Sanctionamt,$Availableamt,$Dateoffirstrelease,$Amtoffirstrelease,$Dateofsecondrelease,$Amtofsecondrelease,$Netamt,$Fileno,$fileinitiation,$nameofindenter,$materialreceivedpurchasedandpaymentreleased,$nameoffirm,$completeaddressoffirm,$head,$subhead,$sanctioneddate,$sanctionedamt,$progressivebal,$sanctionedbal,$billdate,$billamt,$billbal <br>";
-
}
1 2051 Sign in to post your reply or Sign up for a free account.
Similar topics
by: Drydo |
last post by:
In short, is it possible to swap/change the display output of a laptop
to a CRT programmatically?
The scenario is that we have a laptop that at the startup of a
specific application would...
|
by: radnoraj |
last post by:
Hi,
I am sucessfull in redirecting console output to a file. but in this
case nothing is displayed on the console, cout output is written to
file without display.
how do write the output to...
|
by: robin9876 |
last post by:
In an asp.net (VB) web page I have created a HTML table that has some
server side labels which has information populated to at runtime from
code. This works for when there is only one recorded...
|
by: Rich |
last post by:
Hi,
I'm very, very new to javascript, so please bear with me if this is a
silly question.
My problem is this.
I would like to some javascript connect to a URL on the same webserver
and...
|
by: Luke Herbert |
last post by:
I am very new to C# and have been trying to get to grips with it by
writing a small tool to detect a USB key being inserted and then backup
user specified files to the key.
I have written some...
|
by: netventuresmarketing |
last post by:
Ok so you have already figured out with a name like netventuresmarketing that Im a Internet marketing type trying to teach myself some simple PHP. I purchased a turnkey program to set up a free...
|
by: lokeshrajoria |
last post by:
Hello Everyone,
I am running Perl in Linux 9.0 but after writing simple hello program not getting output. despite of compile sucessfully and i set path of perl.
Please do...
|
by: gmtheodore |
last post by:
I am using PDF::Create to dynamically create PDF on the fly.
That works.
I end my code with the $pdf->close;
and the pdf file is created.
I now want to display it in a browser. Here is the...
|
by: Guna Raj |
last post by:
How can we access the database field using PHP and display it in web page. Suppose there is a text box where the user can enter thier ID. All the corresponding field related to that ID should be...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
| |