[PHP-DB] Re: HTML or PHP?
you'll have to use wordwrap() ! the browser won't be able to brake it down unless it have spaces in it Jason Caldwell [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I have a problem that seems like it should be a snap to fix, but leaves me feeling frustrated to no end... I have a table (HTML) -- 2 Columns. In the right-hand column I store a URL (ie. http://someonesdomainname.com/path/anotherpath/file.html) The problem is -- when I pull the URL in -- it *pushes* my columns around and expands my table beyond the page -- I have my table hard set at 600 pixels (not 100%) -- How can I force the URL (or any text for that matter that doesn't have spaces in it) -- to *wrap*?? Can I do this with HTML (I hope) or do I need to write some PHP code to force break the string into workable sections? Thanks. [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] Check Boxes/UPDATE
-Original Message- From: Jason G. [mailto:[EMAIL PROTECTED]] Sent: 03 October 2001 12:12 To: Matt C; [EMAIL PROTECTED] Subject: Re: [PHP-DB] Check Boxes/UPDATE Matt, Assuming that you have a variable number of records being displayed out of the database: As you write out the HTML, give each checkbox a name containing the ID# of the record that is being written out. Ex: input type=check name=chkAuthStatus_1203 checked input type=check name=chkAuthStatus_1204 checked input type=check name=chkAuthStatus_1205 checked Note that you can use arrays when naming your form elements -- isn't PHP wonderful :). Thus you can have: input type=check name=chkAuthStatus[0] checked input type=check name=chkAuthStatus[1] checked input type=check name=chkAuthStatus[2] checked ...etc This simplifies the code somewhat as you can now loop through the elements of the array $chkAuthStatus to find out whether it is checked or not. regards -- Jason Wong Gremlins Associates www.gremlins.com.hk Tel: +852-2573-5033 Fax: +852-2573-5851 -- 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] MSSQL and ReturnCodes
Hi, Does anyone know how to obtain a returncode from a stored procedure in SQL Server? If possible, I would like to avoid making ODBC. If ODBC commands are the answer, can someone please post a sample? Thanks! -- 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] Bug in new PHP Version?
Hi there, I just downloaded the new 4.06 PHP Version and installed it on a new machine. My application does not work properly anymore, nor does mysqladmin. This are some warnings: Warning: mysql_db_query is deprecated; use mysql_select_db() and mysql_query() instead in c:\dokumente und einstellungen\administrator\desktop\my files\projects\globosapiens\07_production\actual\mysqladmin\lib.inc.php on line 506 Warning: Undefined variable: picture in c:\dokumente und einstellungen\administrator\desktop\my files\projects\globosapiens\07_production\actual\gallery\app_local\dsp_album .inc on line 273 Does anybody have an idea? Cheers Andy -- 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] Performance boosting
Hi there, my phpsite shows always a white page while accessing the db. Sometimes for seconds. How can I change it to a style like for example php.net does. While it is searching the db it shows the php logo and the header of the html site. It looks like that: http:www.globosapiens.net/gallery Cheers Andy -- 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] navigation...
Hi there deco: I'm trying to do the same thing myself (Indent posts for a message forum) Here is something I pulled off phpbuilder yesterday: Generally speaking, threading is evil. Nevertheless, I'll tell you how to do it. Store the comments in a table. Each comment should have a unique ID. One of the fields should be the ID of a parent. Any comment with a null parent is a root-level comment. Any comment with a parent, obviously, is a followup or child. To display: Write a function getlinks($parentid). If $parentid is not zero, increment a global indentation counter. Select for all comments where parentid=$parentid. For each returned object, loop from 0 to the indentation counter value, printing out an indentation character (a nonbreaking space will do). Then print out the link to the current item and call getlinks() with the current item's unique ID as an argument. At the end of the function, decrement the indentation counter and return. What you've just done is created a recursive function. Call it with an argument of zero: getlinks(0) and it will begin with all the root-level comments. It will follow each item's chain and print out a complete tree-structured set of links. Or type in indented into the phpbuilder search field to find the original thread. If you find a solid way of doing this, please let me know as I'm evaluating wether or not it's actually worth it. Cheers. Russ On Mon, 1 Oct 2001 22:47:30 +0100 deco [EMAIL PROTECTED] wrote: I'm trying to solve a problem... I have a site divided in areas. Each area has it's own id, and may have it's own sub-areas. Each sub-area has it's own sub-areas, etc... My will is to return the areas in some cascade order... I can do it recursively, but it generates too many queries. I was wondering how i could do this with only one query to the database. Here's the structure i have so far: AREAS (area_id INT; parent_id INT; root_id(??) INT; description VARCHAR(60)); Can anyone help?? Thanks in advance... PS: I think this would very similar to a threaded forum... -- 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] #---# Believe nothing - consider everything Russ Michell Anglia Polytechnic University Webteam Room 1C 'The Eastings' East Road, Cambridge e: [EMAIL PROTECTED] w: www.apu.ac.uk/webteam 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] PHP4 Compile using Informix Client SDK
Hi, I have SuSe Linux v7.2 with working versions of Apache and MySQL. The problem now is that I need to access an Informix Online v7.3 database running on a separate AIX server. This server has I-Net serving ODBC calls from Windows PC's. I've downloaded the Linux version of the Informix Client SDK and installed it. What happens next? From looking at the documentation (which isn't too clear), it looks as though I need to compile the ODBC libraries directly into PHP. How do I do that? Which libraries should I use? Could I use iODBC to act as a front end? I used this on a different site where I had Openlink ODBC installed. Could I use Openlink ODBC clients to go across I-Net? If anyone could help, I'd be most grateful. Thanks in advance. Regards, Paul -- 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] mysql - php DATE QUESTION...
Can someone offer some help...? Lets say i have a date collumn in a mysql table that includes dates that get stored each time i enter an entry... How can i check when i enter the page that displays the entries to delete all entries older than 30 days? thanks.
RE: [PHP-DB] mysql - php DATE QUESTION...
Check the MySQL manual DATE/TIME functions. try: DELETE FROM mytable WHERE date_column ( CURRDATE()-30 ) -Original Message- From: Koutsogiannopoulos Karolos [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 03, 2001 7:41 AM To: 'Php-Db (E-mail) Subject: [PHP-DB] mysql - php DATE QUESTION... Can someone offer some help...? Lets say i have a date collumn in a mysql table that includes dates that get stored each time i enter an entry... How can i check when i enter the page that displays the entries to delete all entries older than 30 days? thanks. -- 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] mysql - php DATE QUESTION...
sorry for misspelling: curdate() -Original Message- From: Rick Emery [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 03, 2001 8:23 AM To: 'Koutsogiannopoulos Karolos' Cc: [EMAIL PROTECTED] Subject: RE: [PHP-DB] mysql - php DATE QUESTION... Check the MySQL manual DATE/TIME functions. try: DELETE FROM mytable WHERE date_column ( CURRDATE()-30 ) -Original Message- From: Koutsogiannopoulos Karolos [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 03, 2001 7:41 AM To: 'Php-Db (E-mail) Subject: [PHP-DB] mysql - php DATE QUESTION... Can someone offer some help...? Lets say i have a date collumn in a mysql table that includes dates that get stored each time i enter an entry... How can i check when i enter the page that displays the entries to delete all entries older than 30 days? thanks. -- 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] Check Boxes/UPDATE
I am sorry but I still really don't get it :( How do I do the array thing? _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- 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] RE: CGI Urgent
I apologize for answering a day late, but I get only the digest version of this list. If you can use PHP instead of PERL, the following article will point you in the right direction. If you cannot use PHP, this article should provide you with the background knowledge you need to send the attachment through PERL. http://www.phpbuilder.com/columns/kartic2807.php3 === Subject: CGI Urgent From: elan [EMAIL PROTECTED] Date: Tue, 2 Oct 2001 12:37:58 +0530 X-Message-Number: 1 Hi list, How can i attach a file in mail program thru CGI? I did like that. === open(MAIL, |$mail -t) or die Can't open $mail\n; print MAIL From: $sender\n; print MAIL Date: $date\n; print MAIL To: $email\n; print MAIL Cc: $ccmail\n; print MAIL Attach: $path\n; print MAIL Subject: $subject\n\n; print MAIL $mailbody; close(MAIL); === Is there any think worng? Attachment is not coming. Thanks Elan -- 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] Check Boxes/UPDATE
for( $i=0; $i3; $i++ )
{
if( isset($chkAuthStatus[$i]) )
{
do something
}
}
-Original Message-
From: Matt C [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 03, 2001 10:17 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Check Boxes/UPDATE
I am sorry but I still really don't get it :(
How do I do the array thing?
-Original Message-
From: Jason G. [mailto:[EMAIL PROTECTED]]
Sent: 03 October 2001 12:12
To: Matt C; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Check Boxes/UPDATE
Matt,
Assuming that you have a variable number of records being displayed out of
the database:
As you write out the HTML, give each checkbox a name containing the ID# of
the record that is being written out. Ex:
input type=check name=chkAuthStatus_1203 checked
input type=check name=chkAuthStatus_1204 checked
input type=check name=chkAuthStatus_1205 checked
Note that you can use arrays when naming your form elements -- isn't PHP
wonderful :). Thus you can have:
input type=check name=chkAuthStatus[0] checked
input type=check name=chkAuthStatus[1] checked
input type=check name=chkAuthStatus[2] checked ...etc
This simplifies the code somewhat as you can now loop through the elements
of the array $chkAuthStatus to find out whether it is checked or not.
regards
--
Jason Wong
Gremlins Associates
www.gremlins.com.hk
Tel: +852-2573-5033
Fax: +852-2573-5851
--
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] Check Boxes/UPDATE
-Original Message- From: Matt C [mailto:[EMAIL PROTECTED]] Sent: 03 October 2001 23:17 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Check Boxes/UPDATE I am sorry but I still really don't get it :( How do I do the array thing? Please specify *which* part you don't understand -- the setting up of the form, or retrieving the info from the form? -- Jason Wong Gremlins Associates www.gremlins.com.hk Tel: +852-2573-5033 Fax: +852-2573-5851 -- 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] Cybercash? or Who?
I just recently started using Cardservice International for all my precessing. The only drawback was that I had to purchase an API wrapper, but it is a PHP wrapper. It was $95. It's extremely fast, and easy to use. Documentation isn't the best, but their support is awesome! Ricky -Original Message- From: Dan Harrington [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 9:14 PM To: Jason Caldwell; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Cybercash? or Who? Go payflow pro. Its awesome. Substantially the fastest processor out there in my opinion. I use it with PHP and its awesome. I've used Miva, Cybercash (before it was Verisign), and many others. -Original Message- From: Jason Caldwell [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 5:15 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Cybercash? or Who? Does anyone have any recommendations on a Credit Card Processing solution to use with PHP? I researched CyberCash's CashRegister deal about 6 months ago -- now Verisign has taken over CyberCash, and have replaced CashRegister with PayFlowPro -- Looking at the pricing, etc... don't know if it was a better deal than CashRegister... not that it matters anymore :-) I'm basically looking to not get raped with Merchant and Monthly fees... but still get a good, quick and reliable processing package. Thanks. Jason [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 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] Bug in new PHP Version?
Looks like you've got the answer to your question, right there use mysql_select_db() and mysql_query() instead. I use 4.06 and have never used the mysql_db_query function. -Original Message- From: Luditus [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 03, 2001 2:13 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Bug in new PHP Version? Hi there, I just downloaded the new 4.06 PHP Version and installed it on a new machine. My application does not work properly anymore, nor does mysqladmin. This are some warnings: Warning: mysql_db_query is deprecated; use mysql_select_db() and mysql_query() instead in c:\dokumente und einstellungen\administrator\desktop\my files\projects\globosapiens\07_production\actual\mysqladmin\lib.inc.php on line 506 Warning: Undefined variable: picture in c:\dokumente und einstellungen\administrator\desktop\my files\projects\globosapiens\07_production\actual\gallery\app_local\dsp_album .inc on line 273 Does anybody have an idea? Cheers Andy -- 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] Performance boosting
There is a certain amount of the script that the browser can display before the script is done loading. I'm not sure exactly how much that is, but I've seen this before. I wrote a script that pulls info out of a mssql DB, and it shows the top part of my script while pulling DB info. It's because I display a ton of stuff before the query is performed. If there's not enough stuff before the query is executed, it doesn't show anything. If there's too much, it shows up to a certain point. Ricky -Original Message- From: Luditus [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 03, 2001 2:27 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Performance boosting Hi there, my phpsite shows always a white page while accessing the db. Sometimes for seconds. How can I change it to a style like for example php.net does. While it is searching the db it shows the php logo and the header of the html site. It looks like that: http:www.globosapiens.net/gallery Cheers Andy -- 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] Performance boosting
You need to break up your web page into several independant html tables, not nested tables. Each independant table will be rendered progressively as it downloads. That's the effect you are seeing. -John Ricky Theil [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... There is a certain amount of the script that the browser can display before the script is done loading. I'm not sure exactly how much that is, but I've seen this before. I wrote a script that pulls info out of a mssql DB, and it shows the top part of my script while pulling DB info. It's because I display a ton of stuff before the query is performed. If there's not enough stuff before the query is executed, it doesn't show anything. If there's too much, it shows up to a certain point. Ricky -Original Message- From: Luditus [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 03, 2001 2:27 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Performance boosting Hi there, my phpsite shows always a white page while accessing the db. Sometimes for seconds. How can I change it to a style like for example php.net does. While it is searching the db it shows the php logo and the header of the html site. It looks like that: http:www.globosapiens.net/gallery Cheers Andy -- 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] Cybercash? or Who?
On Wed, 3 Oct 2001 09:49:20 -0600 Ricky Theil [EMAIL PROTECTED] wrote: I just recently started using Cardservice International for all my precessing. The only drawback was that I had to purchase an API wrapper, but it is a PHP wrapper. It was $95. It's extremely fast, and easy to use. Documentation isn't the best, but their support is awesome! Ricky Do you have a URL for them? -- Raquel There ain't nothin' I can do, or nothin' I can say, that folks don't criticize me. But I'm goin' to do just as I want to anyway. --Bessie Smith -- 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] Cybercash? or Who?
www.cardservice.com -Original Message- From: Raquel Rice [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 03, 2001 1:29 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Cybercash? or Who? On Wed, 3 Oct 2001 09:49:20 -0600 Ricky Theil [EMAIL PROTECTED] wrote: I just recently started using Cardservice International for all my precessing. The only drawback was that I had to purchase an API wrapper, but it is a PHP wrapper. It was $95. It's extremely fast, and easy to use. Documentation isn't the best, but their support is awesome! Ricky Do you have a URL for them? -- Raquel There ain't nothin' I can do, or nothin' I can say, that folks don't criticize me. But I'm goin' to do just as I want to anyway. --Bessie Smith -- 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]
[PHP-DB] Cgi Timeout
I just installed php in W2k I am getting this error: CGI Timeout The specified CGI application exceeded the allowed time for processing. The server has deleted the process. According to the readme file I added the .php extension in IIS. Anything else needed to be done? thanks ) (( ||-. | :|/' -`--'- -- 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] what's the current URL
Is there a way for PHP to know the current URL? I have am include file that a TOC, I want to change the color of a specific link in the TOC to ilustrate that that is the corrent page the user is at. Any sugestions? Thanks a bunch :-) Franky
[PHP-DB] Re: PHP and MS Access
This is absolutely not true. Although there isn´t a direct way to connect to Access from PHP (like you can do with PosgresSQL) you may connect to access using an ODBC connection. The only thing they have to do is Configure an ODBC DSN in their server pointing to your specific DB file and that´s it. I hope I understood your problem correctly and I hope this answer is satisfactory. -- 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] ODBC Security
Hi everyone. I need some help with configuring the ODBC to access an MS Access DB on a Windows NT server with . Can anyone tell me exactly how the Username and Password features work when configuring an ODBC System Connection? I tryed using this feature when configuring the System DSN for the database but when I include this parameters in the connection statement: $conn = odbc_connect (dns_name, user, pwd); nothing really happens. I tryed submitting the wrong values to see if there was a difference but it seems not to take into account this values. Can anyone help me giving me a step-by-step guide to configuring the ODBC correctly? Thanks -- == CARLOS AUGUSTO ABARCA B. Web Design Engineer Seguros Bolivar - TBF Sistemas Bogotá D.C., Colombia == -- 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] what's the current URL
Use the phpinfo(); function to show you all the environment variables. i.e. the current file URL w/o the query string on it is $PHP_SELF Ricky -Original Message- From: Francisco Carvalho [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 03, 2001 2:51 PM To: '[EMAIL PROTECTED]' Subject: [PHP-DB] what's the current URL Is there a way for PHP to know the current URL? I have am include file that a TOC, I want to change the color of a specific link in the TOC to ilustrate that that is the corrent page the user is at. Any sugestions? Thanks a bunch :-) Franky -- 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] what's the current URL
I don't think there is a predefined variable that actually contains the URL as it appears in the user's address bar, but it would be easy to make a URL from the Globals. Check the variables listed on your server in a phpinfo. It will probably be as simple as: $url = http://; . $HTTP_HOST . $SCRIPT_NAME; Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.com - Original Message - From: Francisco Carvalho [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, October 03, 2001 3:50 PM Subject: [PHP-DB] what's the current URL Is there a way for PHP to know the current URL? I have am include file that a TOC, I want to change the color of a specific link in the TOC to ilustrate that that is the corrent page the user is at. Any sugestions? Thanks a bunch :-) Franky -- 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] what's the current URL
$PHP_SELF returns the full URL of the current script. i.e. $PHP_SELF http://domain.com/script.php -Original Message- From: Sheridan Saint-Michel [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 03, 2001 3:30 PM To: Francisco Carvalho; [EMAIL PROTECTED] Subject: Re: [PHP-DB] what's the current URL I don't think there is a predefined variable that actually contains the URL as it appears in the user's address bar, but it would be easy to make a URL from the Globals. Check the variables listed on your server in a phpinfo. It will probably be as simple as: $url = http://; . $HTTP_HOST . $SCRIPT_NAME; Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.com - Original Message - From: Francisco Carvalho [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, October 03, 2001 3:50 PM Subject: [PHP-DB] what's the current URL Is there a way for PHP to know the current URL? I have am include file that a TOC, I want to change the color of a specific link in the TOC to ilustrate that that is the corrent page the user is at. Any sugestions? Thanks a bunch :-) Franky -- 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] what's the current URL
Thanks all. $PHP_SELF worked fine. -Original Message- From: Ricky Theil [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 03, 2001 2:37 PM To: Ricky Theil; 'Sheridan Saint-Michel'; Francisco Carvalho; [EMAIL PROTECTED] Subject: RE: [PHP-DB] what's the current URL I apologize... I'm wrong... $PHP_SELF is only the name of the current script... -Original Message- From: Ricky Theil [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 03, 2001 3:35 PM To: 'Sheridan Saint-Michel'; Francisco Carvalho; [EMAIL PROTECTED] Subject: RE: [PHP-DB] what's the current URL $PHP_SELF returns the full URL of the current script. i.e. $PHP_SELF http://domain.com/script.php -Original Message- From: Sheridan Saint-Michel [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 03, 2001 3:30 PM To: Francisco Carvalho; [EMAIL PROTECTED] Subject: Re: [PHP-DB] what's the current URL I don't think there is a predefined variable that actually contains the URL as it appears in the user's address bar, but it would be easy to make a URL from the Globals. Check the variables listed on your server in a phpinfo. It will probably be as simple as: $url = http://; . $HTTP_HOST . $SCRIPT_NAME; Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.com - Original Message - From: Francisco Carvalho [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, October 03, 2001 3:50 PM Subject: [PHP-DB] what's the current URL Is there a way for PHP to know the current URL? I have am include file that a TOC, I want to change the color of a specific link in the TOC to ilustrate that that is the corrent page the user is at. Any sugestions? Thanks a bunch :-) Franky -- 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]
[PHP-DB] Re: collecting a variable value from SQL*Plus
Bona, You are trying to perform an SQL*PLUS command. I think you can only perform SQL commands with OCI. You can print a ref cursor in SQL*PLUS but you have to handle it differently with OCI. Look at the PHP reference manual for ocinewcursor. Good Luck, Pat [EMAIL PROTECTED] wrote: Hi again. now I´m writing to solve another puzzle of my script... on the SQL*Plus I type the following code to get x value: print x; I trying to do it with PHP this way: ? $conn = OCILogon (SYSTEM,manager); $cursor = OCIParse ($conn, print x;end;); OCIBindByName ($cursor, :x, $x, 10); $result = OCIExecute ($cursor); echo $result; ? and this is my error message: Warning: OCIBindByName: ORA-01036:not valid name/number in c:\program files\apache group\apache\htdocs\apostila\testes\procedure01f.php on line 7 Warning: OCIStmtExecute: ORA-06550: line 1, row 14: PLS-00103: Found X when one of the followed were espected: := . ( @ % ; O símbolo := in c: \program files\apache group\apache\htdocs\apostila\testes\procedure01f.php on line 9 any sugestions??? thanks for all the help I having from you!!! Bona __ Visite http://www.trama.com.br -- 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]
