[PHP-DB] PHP MOUNT
hello everybody, can anyone tellme how i can do a "mount" in a server from php script?, "system(mount * * *)" doesn't work! marco eyzaguirre Lima - Peru
RE: [PHP-DB] Join Sentences
No, I know how manage the functions I said for exemple : If I need insert or delete data in two tables, and one of them returns error, the data stay inconsistent. I know that languages like Oracle have sentences ROLLBACK, but I work in Mysql and I think this not works very well. A acuse of it, I ask me if PHP can control this for a group of sentences, in other situations, like add un global array element, or similar. If the function starts, modify this global variable, and after returns error, it's necessary rollback the actions made. You understand now ?? Thank you a lot. Gaby http://www.atrivia.com - Original Message - From: Jorge Santos [EMAIL PROTECTED] To: Gaby [EMAIL PROTECTED] Cc: PHP-DB [EMAIL PROTECTED] Sent: Friday, February 09, 2001 2:17 PM Subject: Re: [PHP-DB] Join Sentences Hi Gaby, Your best bet is to probably place the statements you want into a function. Then, when the function is called if any one statement fails you simply return from the function with an error code. Hope this answer helps you... -- (No Espanol mas Portugues) O melhor a fazer e para por as declaracoes numa funcao. Depois quando chamar a funcao, se alguma declaracao erra, regresse da funcao com um codico proprio. Espero que esta resposta lhe pode ajudar. Later, Jorge [EMAIL PROTECTED] - Original Message - From: Gaby [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, February 09, 2001 7:59 AM Subject: [PHP-DB] Join Sentences Hi, ( Excuse me for my english ) I wish execute in PHP some consecutives sentences , but if one of them returns un error, the program must'n execute anyone. I need one set of sentences that executes the code like one. I don't know if I explain ... Thanks a lot. --- Por si acaso alguien me entiende mejor en espaol : Lo que me gustaria es ejecutar un grupo de sentencias como si fueran solo una -- PHP Database 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]
RE: [PHP-DB] Can you recommend a development tool?
On the contrary... I use Dreamweaver for layouts and then use either it's integrated editor for PHP or fire it up in Textpad. No code reofmatting and it works seamlessly. Sean -Original Message- From: Daniel Rezny [SMTP:[EMAIL PROTECTED]] Sent: Friday, February 09, 2001 11:01 AM To: John Coonrod Cc: (php-db list) Subject:Re: [PHP-DB] Can you recommend a development tool? Hello John, Thursday, February 08, 2001, 5:12:21 PM, you wrote: JC Can anyone out there recommend a graphical development tool (like FrontPage) JC that you find useful for developing php-based web pages? I'm looking at how JC to empower my staff who are a bit new to all this. JC JC Dr. John Coonrod, Vice President, [EMAIL PROTECTED] JC The Hunger Project, 15 East 26th Street, NY, NY 10010 www.thp.org www.allaire.com and theirs HOMESITE editor. In my opinion this is the best editor and my favourite. So try it. Do not try any WYSIWYG editors. Generating plain code is the best. -- Best regards, Daniel -- PHP Database 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] -- PHP Database 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]
Re: RE: [PHP-DB] Can you recommend a development tool?
When you say integral editor of DW, do you mean, the 'hit F10' editor? I use EditPlus, (www.editplus.com) it is preconfigured to recognise and highlight php code as well as javascript etc and what have you.. Russ #---# "Believe nothing - consider everything" Russ Michell Anglia Polytechnic University Webteam http://gertrude.sipu.anglia.ac.uk/webteam [EMAIL PROTECTED] +44 (0)1223 363271 ext 2331 www.theruss.com #---# -- PHP Database 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]
[PHP-DB] Can you recommend a development tool?
Dreamweaver 4, now has the ability to display both the WYSIWYG GUI and the source-code in the same window, I like that as you can see what DW is doing as you place objects etc into the WYSIWYG section. whimper I don't like the fact that they changed all the keyboard shorcuts around F8 behaviours, F6 library etc - sadly no longer.. /whimper Russ #---# "Believe nothing - consider everything" Russ Michell Anglia Polytechnic University Webteam http://gertrude.sipu.anglia.ac.uk/webteam [EMAIL PROTECTED] +44 (0)1223 363271 ext 2331 www.theruss.com #---# -- PHP Database 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]
[PHP-DB] Dreamweaver rant OT was(RE: [PHP-DB] Can you recommend a development tool?)
Dreamweaver 4, now has the ability to display both the WYSIWYG GUI and the source-code in the same window, I like that as you can see what DW is doing as you place objects etc into the WYSIWYG section. whimper I don't like the fact that they changed all the keyboard shorcuts around F8 behaviours, F6 library etc - sadly no longer.. /whimper Why do they do this. They've done it with every new version. As though not confusing enough learning the new stuff,you have to relearn the old stuff. I especially don't like having to press Ctrl + A 10 times trying to select the whole table. And this doesn't always work with nested tables. g M@ -- PHP Database 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]
Re: [PHP-DB] PHP4/Apache on Win95 to remote Oracle
Hi Steve,
I can successfully connect to Oracle using SQL Plus. In addition, when I
call phpinfo() all the variables are set properly and OCI is enabled...
I also changed ORACLE_HOME=D:\PROGRA~1\ORAWIN95 to have a full path name
(program files) but the problem still exists...
Later,
Jorge
[EMAIL PROTECTED]
- Original Message -
From: Steve Farmer [EMAIL PROTECTED]
To: Mark Farver [EMAIL PROTECTED]; Jorge Santos [EMAIL PROTECTED]
Cc: PHP-DB [EMAIL PROTECTED]
Sent: Thursday, February 08, 2001 10:36 PM
Subject: Re: [PHP-DB] PHP4/Apache on Win95 to remote Oracle
Hi Guys,
Not sure what your problem is since i haven't run apache on WIN32
but tnsping only tells you that the listeners is running, not that
you can connect to the database...
Use sql*plus to connect and then you can be sure your Oracle client
is installed and configured correctly.
If you have all you environment variables set it should work OK..
BTW i'm not sure if putenv("ORACLE_HOME=D:\PROGRA~1\ORAWIN95"); is
ok, i think you should put the full path name in without any ~
or try installing oracle directly on the C: drive so you get a path
with no spaces in it
Otherwise it must be something to do with the way php has been compiled
...
if you do a phpinfo() do all the environment variables look OK and
is OCI8 support complied ?
I have connected remotely from linux/apahe to a variety of oracle
DB's on a variety of remote platforms
HTH
Steve Farmer
At 4:39 PM -0600 8/2/01, Mark Farver wrote:
Please help. I'm going maaddd trying to figure this out. I've pretty
much
read all of the online docs and spend countless hours reading through
the
archives..
I'm running PHP4 and Apache on my Win95 computer.
I'm trying to connect to a remote Oracle database.
I had the same problem last week. Every suggestion I got was about
environment variables. However since a tnsping from within PHP
(using passthru) works fine I know better. From examining the sqlnet
files and watching the resource allocations I came to the conclusion that
PHP is hardcoded to connect only to a database located on the same
machine (using BEQLOCAL). Oracle never even bothers to read the
tnsnames.ora file when its called from PHP. This seems to be only a
problem in Windows and possibly only with the Oracle8 drivers.
My postings to the dev lists went unanswered but at the time I was unsure
if it was a Windows only problem. It might be worth reposting this info
to the PHP-WIN list.
My boss was very unhappy when I told him my code had to run on a Unix
box.. I basically sold him on PHP due to is cross-paltform nature.
ODBC might work instead, although it never did for me. Use ADODB or
another abstraction layer.. this way you can switch back and forth
easier.
Let me know if you figure anything else out.
Mark Farver
[EMAIL PROTECTED]
On Thu, 8 Feb 2001, Jorge Santos wrote:
Hi all,
I'm getting a "Warning: _oci_open_server: ORA-12203: TNS:unable to
connect to destination ..." error message. Yet I know the
environment is ok because I can tnsping the database name and I can
connect using SQL Plus to the database.
Here's the php code:
?php
putenv("ORACLE_SID=MDC6");
putenv("ORACLE_HOME=D:\PROGRA~1\ORAWIN95");
putenv("TNS_ADMIN=D:\PROGRA~1\ORAWIN95\NET80\ADMIN");
$tns = "(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL
=TCP)(HOST = njnwkora15.db.pseg.com)(PORT = 1527))) (CONNECT_DATA
= (SID =MDC6) ) )";
$connect=OCIPLogon("MDC","MDC",$tns) or die("It's not possible to
connect");
$sql = "select * from district";
$result =OCIParse($connect,$sql);
OCIExecute($result) or die("It's not possible to query");
echo("TABLE");
while(OCIFetch($result)) {
$CC = OCIResult($result,1);
$CCNome = OCIResult($result,2);
echo('TRTD' . $CC . '/TDTD' . $CCNome . '/TD/TR');
}
echo("/TABLE");
?
I shouldn't need to declase $tns above but I've tried with and
without it. I'm also including the ORACLE_SID, ORACLE_HOME and
TNS_ADMIN variables in the autoexec.bat so that they are declared
as of machine bootup. I also added them to the httpd.conf for
Apache configuration like this:
SetEnv ORACLE_SID MDC6
SetEnv ORACLE_HOME D:\PROGRA~1\ORAWIN95
SetEnv TNS_ADMIN D:\PROGRA~1\ORAWIN95\NET80\ADMIN
Please help Before I switch to ASP...
Later,
Jorge
[EMAIL PROTECTED]
--
"The greatest dangers to liberty lurk in insidious enroachment by mean of
zeal, well-meaning but without understanding."
-- Justice Louis O. Brandeis, Olmstead vs. United States
--
PHP Database 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]
--
---
"Minds are like parachutes, they work best when open"
Support
RE: [PHP-DB] Can you recommend a development tool?
Doesn't DW4/Ultradev now support PHP? regards, jaxon -Original Message- From: Alarion [mailto:[EMAIL PROTECTED]] Sent: Friday, February 09, 2001 4:20 AM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Can you recommend a development tool? Yeah, I just downloaded the DW4 trial last night, and haven't had a chance to use it yet, but I read that that was one of the new features - It's about time :) I don't know why they would change the keyboard shortcuts around in version FOUR.. *sigh* Sean -Original Message- From: Russ Michell [SMTP:[EMAIL PROTECTED]] Sent: Friday, February 09, 2001 2:14 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: [PHP-DB] Can you recommend a development tool? Dreamweaver 4, now has the ability to display both the WYSIWYG GUI and the source-code in the same window, I like that as you can see what DW is doing as you place objects etc into the WYSIWYG section. whimper I don't like the fact that they changed all the keyboard shorcuts around F8 behaviours, F6 library etc - sadly no longer.. /whimper Russ #---# "Believe nothing - consider everything" Russ Michell Anglia Polytechnic University Webteam http://gertrude.sipu.anglia.ac.uk/webteam [EMAIL PROTECTED] +44 (0)1223 363271 ext 2331 www.theruss.com #---# -- PHP Database 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] -- PHP Database 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]
Re: [PHP-DB] Can you recommend a development tool?
Yes only ASP,JSP and CF, I did read on the Macromedia newsgroup that someone is developing a PHP plugin for Ultradev. - Original Message - From: "Alarion" [EMAIL PROTECTED] To: [EMAIL PROTECTED] , e-mail: [EMAIL PROTECTED] -- PHP Database 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]
[PHP-DB] the SET datatype
I have a little MySQL related problem... The column A.1 is using the SET datatype. I want the possible values of A.1 to be any value(s) of column B.1 I could of cause manually enter the values of B.1 when I create A.1, but I want the possible values of A.1 to change as table B changes. Is there anyway of doing this? Please help? [EMAIL PROTECTED] -- PHP Database 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]
[PHP-DB] reading dbfs from remote server
I have an NT web server with php an I'm trying to read dbf files that are in an other NT server, but I get an error saying I have no permission to the files. looking at the files they have reading writing permission for everione so there should be no problem Any Idea? Jose Guridi -- PHP Database 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]
Re: [PHP-DB] reading dbfs from remote server
You'll need to tell us more about how you are accessing these files. Over a Windows share? (Off topic) Or are you using php's url/file read functions to access them right off the webserver. Code we see a small code snippit? Mark On Fri, 9 Feb 2001, Guridi, Jose wrote: I have an NT web server with php an I'm trying to read dbf files that are in an other NT server, but I get an error saying I have no permission to the files. looking at the files they have reading writing permission for everione so there should be no problem Any Idea? Jose Guridi -- "The greatest dangers to liberty lurk in insidious enroachment by mean of zeal, well-meaning but without understanding." -- Justice Louis O. Brandeis, Olmstead vs. United States -- PHP Database 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]
[PHP-DB] PHP MOUNT
hello everybody, can anyone tellme how i can do a "mount" in a server from php script?, "system(mount * * *)" doesn't work! marco eyzaguirre Lima - Peru -- PHP Database 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]
[PHP-DB] php client -- informix-se
Dear all, I have a question for you. Given the following configuration: - One NT machine with Apache 3.14 and php4 (from www.php4.de) installed (the one that should act like client) - One Sco_SV system Release 3.2v5.0.5 with INFORMIX-SE Version 5.10.UD1 (the server) Are my SCO-UNIX Release and INFORMIX-SE Version suitable for use with PHP4 ? I would like to create php4 scripts that connect from the NT machine to the Informix Server, execute query, etc to diplay formatted data throught Apache. PHP has been configured to use the php_ifx.dll but when I execute a simple script with only phpinfo() to see php configuration I receive the following message: "can't find the dinamyc library isqlt09a.dll in the specified path" and as a consegunce "cant load php_ifx.dll..." the fact is that there isn't the file isqlt09a.dll on the NT system. what file is it ? What are the pieces I need to complete the puzzle and where can I get them ? a great thanks in advance to everyone that can give me an help. bye, Luigi Casiraghi [EMAIL PROTECTED] Italy -- PHP Database 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]
[PHP-DB] delete records by a column with date
there is a column in a mysql database called expires that has type date and i was wondering what php code would be needed to delete all records that have dates that have expired something like delete from expires where curdate expires; something like that. -- PHP Database 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]
Re: [PHP-DB] the SET datatype
I have a little MySQL related problem... The column A.1 is using the SET datatype. I want the possible values of A.1 to be any value(s) of column B.1 I could of cause manually enter the values of B.1 when I create A.1, but I want the possible values of A.1 to change as table B changes. Is there anyway of doing this? Please help? [EMAIL PROTECTED] No sir. The members of the SET have to be entered as constant values in the column definition. Bob Hall Know thyself? Absurd direction! Bubbles bear no introspection. -Khushhal Khan Khatak -- PHP Database 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]
