12-18-2009
Thanks very much now the task begin to be easy but sorry i will have questions while i am going ahead with that.( as really it is the first time for me to use perl)
About the connection with mysql this is the perl function as i wrote it in a notebad and saved it begin.pl and i went to command prompt and i wrote
C:\Perl\eg\begin.pl
the code in the begin.pl is
PHP Code:
#!/usr/bin/perl
BEGIN {
# PERL MODULES WE WILL BE USING
use DBI;
use DBD::mysql;
$dbh = DBI->connect('DBI:mysql:db1', 'person') || die "Could not connect to database: $DBI::errstr";}
# (insert query examples here...)
$sth = $dbh->prepare('SELECT describtion FROM protein_names where gene_name=AMELY');
$sth->execute();
$result = $sth->fetchrow_hashref();
print "Value returned: $result->{description}\n";
end{
$dbh->disconnect();
}
but the code don't work and when i type the path
C:\Perl\eg\begin.pl in the command prompt the answer is :
is not recognized as internal or external command
Note: i made sure that the perl has the modules which i used above
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hi, Can anyone please let me know, how to extract two lines at the same time. In specific,I have a file containing list of devices, such as router1 and switch2 below. I want to get all the lines which has "#" and all the lines which has "down"
router1#sh ip int br
Interface ... (6 Replies)
Discussion started by: Aejaz
6 Replies
2. Shell Programming and Scripting
I have data as follow in the txt file.
I want to skip line starting with '#' sign.
#command program
abc defmt
exp refmt
... ...
I want to store abc exp .... in a array.
I want to store defmt refmt in a array
I need command to read each line in the file.
I need... (6 Replies)
Discussion started by: ekb
6 Replies
3. UNIX for Dummies Questions & Answers
I need to extract all the p-value numbers and the rho numbers from a .txt file and write them as coma separated values in a new file. Ideally I would get two files in the end, one for p- values and one for rho. Any suggestions? I appreciate your help!!!
The .txt file looks essentially like this... (5 Replies)
Discussion started by: eggali
5 Replies
4. UNIX for Dummies Questions & Answers
Hi there, Unix Gurus
Working with big listings of english sentences for my pupils, of the type:
1. If the boss's son had been , someone would have asked for money by now.
2. Look, I haven't a crime, so why can't you let me go?
....
I wondered how to extract the words between brackets in... (7 Replies)
Discussion started by: eldeingles
7 Replies
5. Shell Programming and Scripting
Hello,
Currently, I have this output from my application :
-------------------------------------------------
Log viewer/Tmp1 (Jun 29 2011 09:48)
-------------------------------------------------
BlalbalbaBlalbalba..Blalbalba..Blalbalba..Blalbalba..Blalbalba..Blalbalba..Blalbalba....... (3 Replies)
Discussion started by: acidoangel
3 Replies
6. Shell Programming and Scripting
Queue on node in domain
description :
type : local
max message len : 104857600
max queue depth : 5000
queue depth max event : enabled
persistent msgs : yes
backout threshold : 0
msg delivery seq :... (4 Replies)
Discussion started by: Daniel Gate
4 Replies
7. Shell Programming and Scripting
I'm new to this forum and also to UNIX scripting.
I need a command to extract the filename from the path and write to .txt file.
Thanks in advance for your guidance. (23 Replies)
Discussion started by: Ram Kumar_BE
23 Replies
8. Shell Programming and Scripting
I have a sample text file with file name: sample.txt
The text file has the following text.
this is an example text where we have to extract certain words before and after certain word these words can be used later to get more information
I want to extract n (a constant) words before and... (2 Replies)
Discussion started by: shoaibjameel123
2 Replies
9. UNIX for Beginners Questions & Answers
Hi there, Unixers
I need to extract ALL the words from a text which aresurrounded by square brackets. I am using this piece of code
sed 's/.*\.*/\1/g' inputfile > outputfile
but I only get one word for every paragraph, why?
Please use CODE tags as required by forum rules! (7 Replies)
Discussion started by: eldeingles
7 Replies
10. Shell Programming and Scripting
Hi dears
i have text file like this:
INPUT.txt
001_1_173 j nuh ]az
001_1_174 j ]esma. nuh ]/.xori
.
.
. and have another text
like this
TABLE.txt
j j
nuh word1... (6 Replies)
Discussion started by: alii
6 Replies
LEARN ABOUT PHP
phar.extractto
PHAR.EXTRACTTO(3) 1 PHAR.EXTRACTTO(3)
Phar::extractTo - Extract the contents of a phar archive to a directory
SYNOPSIS
public bool Phar::extractTo (string $pathto, [string|array $files], [bool $overwrite = false])
DESCRIPTION
Note
This method requires the php.ini setting phar.readonly to be set to 0 in order to work for Phar objects. Otherwise, a PharException
will be thrown.
Extract all files within a phar archive to disk. Extracted files and directories preserve permissions as stored in the archive. The
optional parameters allow optional control over which files are extracted, and whether existing files on disk can be overwritten. The sec-
ond parameter files can be either the name of a file or directory to extract, or an array of names of files and directories to extract. By
default, this method will not overwrite existing files, the third parameter can be set to true to enable overwriting of files. This method
is similar to ZipArchive.extractTo(3).
PARAMETERS
o $pathto
- Path within an archive to the file to delete.
o $files
- The name of a file or directory to extract, or an array of files/directories to extract
o $overwrite
- Set to TRUE to enable overwriting existing files
RETURN VALUES
returns TRUE on success, but it is better to check for thrown exception, and assume success if none is thrown.
ERRORS
/EXCEPTIONS
Throws PharException if errors occur while flushing changes to disk.
EXAMPLES
Example #1
A Phar.extractTo(3) example
<?php
try {
$phar = new Phar('myphar.phar');
$phar->extractTo('/full/path'); // extract all files
$phar->extractTo('/another/path', 'file.txt'); // extract only file.txt
$phar->extractTo('/this/path',
array('file1.txt', 'file2.txt')); // extract 2 files only
$phar->extractTo('/third/path', null, true); // extract all files, and overwrite
} catch (Exception $e) {
// handle errors
}
?>
SEE ALSO
PharData.extractTo(3).
PHP Documentation Group PHAR.EXTRACTTO(3)