i don't think the relative path is the problem, because if i run the php script with shell_exec('sh /var/www/directory/script.sh');
with script.sh being :
the echo command works, it will display "This script is working"
but the sql query does not run...it clearly shows that the php is not the problem, and i believe the problem is in the permission apache server user has to use sqlplus unix command.
I did not found enough information on the internet about this command (in oracle doc it really is looking for a needle in a haystack)...
I have a ksh script that connects to sqlplus and dumps the query results into a file. The script works file when I run it from the command line, however, when I call it from PHP using system(), exec(), or shell_exec() commands, the script doesn't seem to run the query. It will create the text file... (7 Replies)
Can someone tell me how to execute sqlplus command.
I`m Executing:
sqlplus user/pasw @/report/output/new/PlatformOut_Cdrs.sql
the error is:
SQL*Plus: Release 9.2.0.5.0 - Production on Wed Aug 9 15:37:44 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
ERROR:... (3 Replies)
hi,
i need bash shell script run on the crontab(Unix tru64).
i have write my shell. it's using sqlplus command and connect to oracle db.
execute cron job when i have error messege: "sqlplus: command not found"
have you any suggestion? (4 Replies)
HI,
Does anybody know if its possible to execute a command through exec,
shell exec, system and if the program doesn't terminate in N seconds
returns control to PHP ?
reg,
research3
---------- Post updated 10-16-09 at 12:20 AM ---------- Previous update was 10-15-09 at 11:03 PM... (1 Reply)
Hi, I've been working on a PHP script which is "supposed" to find an individuals weather based on their geolocation. This script uses "shell_exec".
I have checked my syntax and it is correct, but there is still something missing; for when I call on the script using:
<form action='/weather.php'... (15 Replies)
I installed Oracle 10.2.1.0 in Ubuntu 10.10..my installation was well,i could even open isqlplus( http://ubuntu.ubuntu-domain:5560/isqlplus/workspace.uix ) and execute some queries..But,back in terminal when i try to login to sqlplus i am getting error (20 Replies)
Hey guys i've recently been getting into php programming and i became thinking was it possible to create a php script that would allow you to run a terminal from the browser page?
All i've pretty much got so far is:
$var = $_GET;
$output = php shell_exec($var);
echo $output;
... (4 Replies)
Hi ,
i am new to unix i need a small clarification regarding this
sqlplus -s $USER_NAME/$PASSWD@$ORA_SID<< EOF >> SQL_CONN_LOG.log
In the above command what is the meaning of <<EOF>>
Thanks,
krishna. (2 Replies)
i am using bash shell
Whenever i declare an array, and then using sqlplus, i am getting sqlplus error and return code 127.
IFS=","
declare -a Arr=($Variable1);
SQLPLUS=sqlplus -s "${DBUSER}"/"${DBPASS}"@"${DBASE}
echo "set head off ; " > ${SQLCMD}
echo "set PAGESIZE 0 ;" >> ${SQLCMD}... (6 Replies)
Hi all,
i face an error related to my server ""it's running server"" when i use sqlplus command
$ sqlplus
bash: sqlplus: command not found
the data base is up and running i just need to access the sqlplus to import the dump file as a daily backup.
i already check the directory... (4 Replies)
Discussion started by: clerck
4 Replies
LEARN ABOUT PHP
stristr
STRISTR(3) 1 STRISTR(3)stristr - Case-insensitivestrstr(3)SYNOPSIS
string stristr (string $haystack, mixed $needle, [bool $before_needle = false])
DESCRIPTION
Returns all of $haystack starting from and including the first occurrence of $needle to the end.
PARAMETERS
o $haystack
- The string to search in
o $needle
- If $needle is not a string, it is converted to an integer and applied as the ordinal value of a character.
o $before_needle
- If TRUE, stristr(3) returns the part of the $haystack before the first occurrence of the $needle (excluding needle).
$needle and $haystack are examined in a case-insensitive manner.
RETURN VALUES
Returns the matched substring. If $needle is not found, returns FALSE.
CHANGELOG
+--------+-----------------------------------------------+
|Version | |
| | |
| | Description |
| | |
+--------+-----------------------------------------------+
| 5.3.0 | |
| | |
| | Added the optional parameter $before_needle. |
| | |
| 4.3.0 | |
| | |
| | stristr(3) was made binary safe. |
| | |
+--------+-----------------------------------------------+
EXAMPLES
Example #1
stristr(3) example
<?php
$email = 'USER@EXAMPLE.com';
echo stristr($email, 'e'); // outputs ER@EXAMPLE.com
echo stristr($email, 'e', true); // As of PHP 5.3.0, outputs US
?>
Example #2
Testing if a string is found or not
<?php
$string = 'Hello World!';
if(stristr($string, 'earth') === FALSE) {
echo '"earth" not found in string';
}
// outputs: "earth" not found in string
?>
Example #3
Using a non "string" needle
<?php
$string = 'APPLE';
echo stristr($string, 97); // 97 = lowercase a
// outputs: APPLE
?>
NOTES
Note
This function is binary-safe.
SEE ALSO strstr(3), strrchr(3), stripos(3), strpbrk(3), preg_match(3).
PHP Documentation Group STRISTR(3)