[PHP] Tour Guide around Jordan (Middle East) OFFER
Please note if you dont need it now you may will need it later so please save it for the future :) :) Message: Destination: Amman Season: January - December Languages: English, Arabic Minimum Cost: 50 US Dollar (USD) Per day Maximum Cost: 100 US Dollar (USD) Per day I have a 6 years experience in tourism and travel experince In love with tourism I will show the world how beauty my country is. I have been in this field with people from around the world and I guess they are all satisfied and happy for the service I offer. Some of my interests are: Trekking, Mountain-Biking, Geocaching; and places to see are: historic sites in Saarland, Rheinland-Pfalz and Northern France. The cities that I specialize in are the following: - SW Germany - Northern France - Luxembourg - Belgium - Saarbruecken - Strasbourg - Trier - Metz Have you ever heared about the roses city? I can show it to you. Would you like to figure out more about Roman theater? I can tell you. For More details please contact me at [EMAIL PROTECTED] PLEASE NOTE You can make money if you refer me a clients by having your own commission directly from the total price of the trip COST Contact me for more details Thankss -- This email is send by Demo Software -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Cascading delete in oracle and php
hi, i have 2 tables in oracle
create table Shop(
ordId NUMBER(7) NOT NULL PRIMARY KEY);
create table Customer(
ordId NUMBER(7) NOT NULL,
FOREIGN KEY (ordId) REFERENCES Orders(ordId) on delete cascade);
so, when i delete a row in shop, the corresponding row in customer will be
deleted.
so, i have created a function in php to execute the query
whereby $sqlStmt = Delete from Shop where ordId = $ordId;
function executeSql($sqlStmt) //line 524
{
//echo $sqlStmt;
$this-stmt = OCIParse($this-conn, $sqlStmt)or die
(Sorry, cannot parse the sql statement. Please inform the webmistress of
the error messages);
// verify that SQL is valid
$this-checkErrors();
OCIExecute($this-stmt, OCI_DEFAULT) or die //line 534
(Sorry, cannot execute the sql statement. Please inform the webmistress of
the error messages);
$this-checkErrors();
//commit to database
$this-commit();
}
however, when i tried to execute the sql stmt, an error stmt will occur :
Warning: Missing argument 1 for executesql() in
c:\apache\htdocs\project\ProcessSql.php on line 524
Warning: OCIStmtExecute: ORA-24337: statement handle not prepared in
c:\apache\htdocs\project\ProcessSql.php on line 534
Sorry, cannot execute the sql statement. Please inform the webmistress of
the error messages
This function works for tables that do not have cascading deletes.
How do i get round this problem? thanx :P
--
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Cascading delete in php and oracle
hi, i have 2 tables in oracle
create table Shop(
ordId NUMBER(7) NOT NULL PRIMARY KEY);
create table Customer(
ordId NUMBER(7) NOT NULL,
FOREIGN KEY (ordId) REFERENCES Orders(ordId) on delete cascade);
so, when i delete a row in shop, the corresponding row in customer will be
deleted.
so, i have created a function in php to execute the query
whereby $sqlStmt = Delete from Shop where ordId = $ordId;
function executeSql($sqlStmt) //line 524
{
//echo $sqlStmt;
$this-stmt = OCIParse($this-conn, $sqlStmt)or die
(Sorry, cannot parse the sql statement. Please inform the webmistress of
the error messages);
// verify that SQL is valid
$this-checkErrors();
OCIExecute($this-stmt, OCI_DEFAULT) or die //line 534
(Sorry, cannot execute the sql statement. Please inform the webmistress of
the error messages);
$this-checkErrors();
//commit to database
$this-commit();
}
however, when i tried to execute the sql stmt, an error stmt will occur :
Warning: Missing argument 1 for executesql() in
c:\apache\htdocs\project\ProcessSql.php on line 524
Warning: OCIStmtExecute: ORA-24337: statement handle not prepared in
c:\apache\htdocs\project\ProcessSql.php on line 534
Sorry, cannot execute the sql statement. Please inform the webmistress of
the error messages
This function works for tables that do not have cascading deletes.
How do i get round this problem? thanx :P
--
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Cascading delete in oracle
create table Shop(
ordId NUMBER(7) NOT NULL PRIMARY KEY);
create table Customer(
ordId NUMBER(7) NOT NULL,
FOREIGN KEY (ordId) REFERENCES Shop(ordId) on delete cascade);
so, when i delete a row in shop, the corresponding row in customer will be
deleted.
so, i have created a function in php to execute the query
whereby $sqlStmt = Delete from Shop where ordId = $ordId;
function executeSql($sqlStmt) //line 524
{
//echo $sqlStmt;
$this-stmt = OCIParse($this-conn, $sqlStmt)or die
(Sorry, cannot parse the sql statement. Please inform the webmistress of
the error messages);
// verify that SQL is valid
$this-checkErrors();
OCIExecute($this-stmt, OCI_DEFAULT) or die //line 534
(Sorry, cannot execute the sql statement. Please inform the webmistress of
the error messages);
$this-checkErrors();
//commit to database
$this-commit();
}
however, when i tried to execute the sql stmt, an error stmt will occur :
Warning: Missing argument 1 for executesql() in
c:\apache\htdocs\project\ProcessSql.php on line 524
Warning: OCIStmtExecute: ORA-24337: statement handle not prepared in
c:\apache\htdocs\project\ProcessSql.php on line 534
Sorry, cannot execute the sql statement. Please inform the webmistress of
the error messages
This function works for tables that do not have cascading deletes.
How do i get round this problem? thanx :P
--
--
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Removing ^M
why not just run tr -d \r htmlfile.htm - Original Message - From: Michael Hall [EMAIL PROTECTED] To: PHP List [EMAIL PROTECTED] Sent: Sunday, June 09, 2002 2:40 AM Subject: [PHP] Removing ^M I am trying remove ^M characters (some kind of newline character) from an HTML file. I've tried all sorts of ereg_replace and sed possibilities but the things just won't go away. Does anyone have a way of removing such characters? TIA Mick -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Tailing a log file {!?}
check directory rights.
If need be, passwd the user and give it a shell.
then try on the console as the webserver user
to tail the file.
- Original Message -
From: Liam MacKenzie [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; Tom Rogers [EMAIL PROTECTED]
Sent: Saturday, May 04, 2002 11:26 AM
Subject: Re: [PHP] Tailing a log file {!?}
That doesn't work either!
Something's going on here...
- Original Message -
From: Tom Rogers [EMAIL PROTECTED]
To: Liam MacKenzie [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Sunday, May 05, 2002 6:49 PM
Subject: Re: [PHP] Tailing a log file {!?}
Hi
The following works for me, give it a try with the correct path.
?
exec(tail -n 50 /usr/local/apache/logs/access_log,$result);
echo count($result). results returned. br;
if(count($result) 0){
foreach($result as $line){
echo $line.br;
}
}
?
Tom
At 06:25 PM 4/05/2002, Liam MacKenzie wrote:
$cmd = exec(tail -n $len /www/hosting/domains/lanolot/logs/$open,
$result);
echo $cmd;
Still returns nothing under the top text.
All log files are chmodded 644 and are owned by the web server.
The paths to the files are correct.
I've run out of ideas =(
Thanks
- Original Message -
From: Jason Wong [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, May 05, 2002 6:22 PM
Subject: Re: [PHP] Tailing a log file {!?}
On Saturday 04 May 2002 16:09, Liam MacKenzie wrote:
Sorry, I should have included this in the first email...
[snip]
When I call the page, I get the expected at the top:
Excecuting: tail -n 150 /www/hosting/domains/lanolot/logs/error.log
Displaying the last 150 lines of error.log...
But there's nothing underneath it.
1) Check that you have permissions to access the file
2) Add a 'return_var' to your exec() call. And check what this contains.
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development *
/*
DeVries' Dilemma:
If you hit two keys on the typewriter, the one you don't want
hits the paper.
*/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] php permissions
chown them to nobody. - Original Message - From: ROBERT MCPEAK [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, April 19, 2002 7:53 PM Subject: [PHP] php permissions php is running on our box as nobody:nogroup. I'm trying to write php code that will edit/delete files uploaded to the server by other users, and, obviously, I get a permissions error. My sysadmin is hesitant to give php more access until I do some research about the security issues involved, and I am a relative newbie and I'm not sure what the issues are or how to find out more about them. How do I give php permissions to delete files etc., without opening up an security hole? Is this an issue at all? Help! Thanks! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Rebooting
Hello all I need to reboot a FreeBSD 4.5-STABLE computer using php + apache. I have a small wrapper which runs the reboot command as root, but it freezes half way through and the box hangs. I'm thinking that the reboot process is killing apache, and in effect killing itself. How might I get around this? Thanks Dave Raven. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Newbie Question.
Hello to all. This is probably the most basic question of th PHP general list. I just installed PHP 4.0.5 on Apache 1.2.19. Could someone please explain a very basic test. I would like to write a Hello World page as a test. I have tried the following: And named the page: index.php and index.html html head titlePHP Testing Ground/title body ?php echo Hello World; ? /body /html index.php - Displays the html code index.html - displays blank - exept I see the title: PHP Testing Ground in the title header of the browser. So the pages are loading. Help? How do I test this to see that Apache is configured correctly. PS: I followed the PHP Manual instructions for installing PHP on php.net. Apache reported setting up correctly after running make install. Any help would be appreciated. Thanks in advance, Tom Bedell Newbie -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
