One more problem....I am pulling data into a text file but along with data a new line and tab is coming...
Eg:
But I want it to be like
so that can use it in a variable each separately as i need to send this in a tabular form as mail using script only.
Also please let me know how to assign same and then arrange it in table form, it will be around 20 or so numbers and aranged like this...
Dear friends,
please help me to solve following problem.
I'm running a frontend application from which i'll be invoking the shell script with arguments as given below
-driver -w -p "ABC XYZ" -S -ds con -dn "abc xyz"
i am getting
$1=-driver
$2=-w
$3=-p
$4="ABC
$5=XYZ"
$6=-S
$7=-ds... (3 Replies)
Hi guys,
I have searched all the forums and searched the net as much as possible, but I carn't find any tutorials about shell scripting with Oracle. Has anyone come across any?
Thanks for reading and in advance of posts,
B14... (2 Replies)
I have a file that has text in the format below
ABC
/ Some text /
ABC
/ Some text /
ABC
/ Some text /
ABC
/ Some text /
ABC
/ Some text /
How can I seperate the text between a pair of 'ABC' into seperate files ???
any information would be of great help. Thanks (8 Replies)
Dear All,
I have an input file like this
interface Serial10/0/7:11.1 point-to-point
description CLIENT:SA_INSTITUTO ANGLO MEXICANO Sitio Metepec 104452:0,165
bandwidth 64
ip vrf forwarding INSTITUTO-ANGLO
ip address 192.168.148.217 255.255.255.252
no ip directed-broadcast
frame-relay... (2 Replies)
Hi all,
i m new to Unix shell scripting(ksh)
i have a requirement, can anyone help me out in this..
spec:
i need to move all the files landing in "X" directory to "Y" directory automatically everyday at a particular time.. (5 Replies)
Hi All,
I need to split a flatfile based on it's first character, I am using the following script
awk '{print > "TEST_substr($0,1,1).txt"}' PROVIDER.txt
It is returning files
TEST_1 and
TEST_2
But I am not getting the .txt file extension.
I need the files like
TEST_1.txt and ... (1 Reply)
Can anyone please help me to create the output file based on the attached input files using ksh script.
I have 2 input files
1) inputfile1.txt
2) inputfile2.txt
The script should accept 2 parametes:
1. Inputfile2.txt with 1-10,000 values ( sample file contains only 4 records)
2. Script... (5 Replies)
Discussion started by: vinus
5 Replies
LEARN ABOUT PHP
maxdb_stmt_execute
MAXDB_STMT_EXECUTE(3) 1 MAXDB_STMT_EXECUTE(3)maxdb_stmt_execute - Executes a prepared Query
Procedural style
SYNOPSIS
bool maxdb_stmt_execute (resource $stmt)
DESCRIPTION
Object oriented style
bool maxdb_stmt::execute (void )
The maxdb_stmt_execute(3) function executes a query that has been previously prepared using the maxdb_prepare(3) function represented by
the $stmt resource. When executed any parameter markers which exist will automatically be replaced with the appropiate data.
If the statement is UPDATE, DELETE, or INSERT, the total number of affected rows can be determined by using the
maxdb_stmt_affected_rows(3) function. Likewise, if the query yields a result set the maxdb_fetch(3) function is used.
Note
When using maxdb_stmt_execute(3), the maxdb_fetch(3) function must be used to fetch the data prior to preforming any additional
queries.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
Object oriented style
<?php
$maxdb = new maxdb("localhost", "MONA", "RED", "DEMODB");
/* check connection */
if (maxdb_connect_errno()) {
printf("Connect failed: %s
", maxdb_connect_error());
exit();
}
$maxdb->query("CREATE TABLE temp.mycity LIKE hotel.city");
/* Prepare an insert statement */
$query = "INSERT INTO temp.mycity (zip, name, state) VALUES (?,?,?)";
$stmt = $maxdb->prepare($query);
$stmt->bind_param("sss", $val1, $val2, $val3);
$val1 = '11111';
$val2 = 'Georgetown';
$val3 = 'NY';
/* Execute the statement */
$stmt->execute();
$val1 = '22222';
$val2 = 'Hubbatown';
$val3 = 'CA';
/* Execute the statement */
$stmt->execute();
/* close statement */
$stmt->close();
/* retrieve all rows from myCity */
$query = "SELECT zip, name, state FROM temp.mycity";
if ($result = $maxdb->query($query)) {
while ($row = $result->fetch_row()) {
printf("%s (%s,%s)
", $row[0], $row[1], $row[2]);
}
/* free result set */
$result->close();
}
/* remove table */
$maxdb->query("DROP TABLE temp.mycity");
/* close connection */
$maxdb->close();
?>
Example #2
Procedural style
<?php
$link = maxdb_connect("localhost", "MONA", "RED", "DEMODB");
/* check connection */
if (maxdb_connect_errno()) {
printf("Connect failed: %s
", maxdb_connect_error());
exit();
}
maxdb_query($link, "CREATE TABLE temp.mycity LIKE hotel.city");
/* Prepare an insert statement */
$query = "INSERT INTO temp.mycity (zip, name, state) VALUES (?,?,?)";
$stmt = maxdb_prepare($link, $query);
maxdb_stmt_bind_param($stmt, "sss", $val1, $val2, $val3);
$val1 = '11111';
$val2 = 'Georgetown';
$val3 = 'NY';
/* Execute the statement */
maxdb_stmt_execute($stmt);
$val1 = '22222';
$val2 = 'Hubbatown';
$val3 = 'CA';
/* Execute the statement */
maxdb_stmt_execute($stmt);
/* close statement */
maxdb_stmt_close($stmt);
/* retrieve all rows from myCity */
$query = "SELECT zip, name, state FROM temp.mycity";
if ($result = maxdb_query($link, $query)) {
while ($row = maxdb_fetch_row($result)) {
printf("%s (%s,%s)
", $row[0], $row[1], $row[2]);
}
/* free result set */
maxdb_free_result($result);
}
/* remove table */
maxdb_query($link, "DROP TABLE temp.mycity");
/* close connection */
maxdb_close($link);
?>
The above example will output something similar to:
11111 (Georgetown,NY)
22222 (Hubbatown,CA)
SEE ALSO maxdb_prepare(3), maxdb_stmt_bind_param(3).
PHP Documentation Group MAXDB_STMT_EXECUTE(3)