10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
when I try to redirect input and the command is described as a string within an array redirection does not work. why?
#!/bin/bash
dir=("tail < ./hello.txt")
tail < ./hello.txt #works
${dir} #does not work (2 Replies)
Discussion started by: heinzel
2 Replies
2. Shell Programming and Scripting
Hi,
#!/bin/bash
while ;
do
rm -f /tmp/pipe
mkfifo /tmp/pipe
./yuv4mpeg_to_v4l2 < /tmp/pipe &
mplayer tom_and_jerry.mp4 -vf scale=480:360 -vo yuv4mpeg:file=/tmp/pipe
sleep 65;
done
When I run this - after mplayer finishes playing video it says - Exiting... (End of... (2 Replies)
Discussion started by: ashokvpp
2 Replies
3. UNIX for Dummies Questions & Answers
Can someone please explain when input redirection is necessary?
For example, "cat filename" and "cat< filename" produce the same result. I was told that if I need to bunzip a file that I should type "bunzip2<filename.bz2." However, if I omit the "<" I still get the same result. Can someone... (4 Replies)
Discussion started by: PTcharger
4 Replies
4. UNIX for Dummies Questions & Answers
Hello,
I'm new to Unix (working with OS X 10.8.5) and therefore at the beginning of my adventure. If I ask something stupid, then this is not intentional, but simple nescience. :rolleyes:
I have a problem with the redirection of text file content to echo. I was experimenting with redirection... (6 Replies)
Discussion started by: pseudo
6 Replies
5. UNIX for Dummies Questions & Answers
Hi,
I am having issues with syntax when I am trying to send a job to the background after a input redirection.
I have this script which sends some files to different servers after zipping them. Once I execute it, it will ask for user input as of which server the files need to go to. (The... (3 Replies)
Discussion started by: grep_me
3 Replies
6. Shell Programming and Scripting
All,
I have a requirement to write a script where I check for Input redirection when the script was executed, based on which I handle my logic. Below is the example:
my.script
#! /bin/ksh
# Not sure how to frame the if condition below
if ; then
echo "Input Redirected from a file"
... (7 Replies)
Discussion started by: bharath.gct
7 Replies
7. Shell Programming and Scripting
Hello,
I need help with a bash script that I try to improve. I could not find answer so far, maybe because I'm not to familiar with the terminology so feel free to correct my language.
I have a script that looks like:
NODES="node_a node_b node_c"
for NODE in $NODES
do
... (4 Replies)
Discussion started by: pn8830
4 Replies
8. UNIX for Advanced & Expert Users
Hello,
I need to change user and run some commands by using a script.
lets say, I'm using
su - someuser << start
password required -----> how can I enter the password here
command 1
command 2
command 3
command 4
start
While trying to run this I got the following message:
"standard... (2 Replies)
Discussion started by: Alalush
2 Replies
9. Shell Programming and Scripting
while running a user inter-active program
how can we get the commands from a
file instead of the user?
is there anyway to permanently redirect content
of a file to standard input? (6 Replies)
Discussion started by: gfhgfnhhn
6 Replies
10. UNIX for Dummies Questions & Answers
Hi everybody, first of all i am a new member in UNIX.com and this is my first post.
I am impressed with the amount of information a person can ever have in this forum, it is really great having something similiar; anyways let me tell you about the problem I am having, hope you will answer me.... (6 Replies)
Discussion started by: majeed73
6 Replies
PG_EXECUTE(3) PG_EXECUTE(3)
pg_execute - Sends a request to execute a prepared statement with given parameters, and waits for the result.
SYNOPSIS
resource pg_execute ([resource $connection], string $stmtname, array $params)
DESCRIPTION
Sends a request to execute a prepared statement with given parameters, and waits for the result.
pg_execute(3) is like pg_query_params(3), but the command to be executed is specified by naming a previously-prepared statement, instead of
giving a query string. This feature allows commands that will be used repeatedly to be parsed and planned just once, rather than each time
they are executed. The statement must have been prepared previously in the current session. pg_execute(3) is supported only against Post-
greSQL 7.4 or higher connections; it will fail when using earlier versions.
The parameters are identical to pg_query_params(3), except that the name of a prepared statement is given instead of a query string.
PARAMETERS
o $connection
- PostgreSQL database connection resource. When $connection is not present, the default connection is used. The default connection
is the last connection made by pg_connect(3) or pg_pconnect(3).
o $stmtname
- The name of the prepared statement to execute. if "" is specified, then the unnamed statement is executed. The name must have
been previously prepared using pg_prepare(3), pg_send_prepare(3) or a PREPARE SQL command.
o $params
- An array of parameter values to substitute for the $1, $2, etc. placeholders in the original prepared query string. The number
of elements in the array must match the number of placeholders.
Warning
Elements are converted to strings by calling this function.
RETURN VALUES
A query result resource on success or FALSE on failure.
EXAMPLES
Example #1
Using pg_execute(3)
<?php
// Connect to a database named "mary"
$dbconn = pg_connect("dbname=mary");
// Prepare a query for execution
$result = pg_prepare($dbconn, "my_query", 'SELECT * FROM shops WHERE name = $1');
// Execute the prepared query. Note that it is not necessary to escape
// the string "Joe's Widgets" in any way
$result = pg_execute($dbconn, "my_query", array("Joe's Widgets"));
// Execute the same prepared query, this time with a different parameter
$result = pg_execute($dbconn, "my_query", array("Clothes Clothes Clothes"));
?>
SEE ALSO
pg_prepare(3), pg_send_prepare(3), pg_query_params(3).
PHP Documentation Group PG_EXECUTE(3)