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
in_array
IN_ARRAY(3) 1 IN_ARRAY(3)in_array - Checks if a value exists in an arraySYNOPSIS
bool in_array FALSE (mixed $needle, array $haystack, [bool $strict])
DESCRIPTION
Searches $haystack for $needle using loose comparison unless $strict is set.
PARAMETERS
o $needle
- The searched value.
Note
If $needle is a string, the comparison is done in a case-sensitive manner.
o $haystack
- The array.
o $strict
- If the third parameter $strict is set to TRUE then the in_array(3) function will also check the types of the $needle in the
$haystack.
RETURN VALUES
Returns TRUE if $needle is found in the array, FALSE otherwise.
EXAMPLES
Example #1
in_array(3) example
<?php
$os = array("Mac", "NT", "Irix", "Linux");
if (in_array("Irix", $os)) {
echo "Got Irix";
}
if (in_array("mac", $os)) {
echo "Got mac";
}
?>
The second condition fails because in_array(3) is case-sensitive, so the program above will display:
Got Irix
Example #2
in_array(3) with strict example
<?php
$a = array('1.10', 12.4, 1.13);
if (in_array('12.4', $a, true)) {
echo "'12.4' found with strict check
";
}
if (in_array(1.13, $a, true)) {
echo "1.13 found with strict check
";
}
?>
The above example will output:
1.13 found with strict check
Example #3
in_array(3) with an array as needle
<?php
$a = array(array('p', 'h'), array('p', 'r'), 'o');
if (in_array(array('p', 'h'), $a)) {
echo "'ph' was found
";
}
if (in_array(array('f', 'i'), $a)) {
echo "'fi' was found
";
}
if (in_array('o', $a)) {
echo "'o' was found
";
}
?>
The above example will output:
'o' was found
SEE ALSO array_search(3), isset(3), array_key_exists(3).
PHP Documentation Group IN_ARRAY(3)