[PHP-DB] assoc arrays

2001-02-20 Thread Free Beachler
the form variables from an http post are stored in: http_post_vars[] - associative array containing form variables.. what about url parameters, such as:: http://www.mysite.com?param1=12 is there a corresponding array for them, or do they go in the post_vars array? -- PHP Database Mailing

Re: [PHP-DB] assoc arrays

2001-02-20 Thread Beau Lebens
hello again free those vars will automagically be created by php (sweet!) so in your example (notice i added "page.php"); http://www.mysite.com/page.php?param1=12 on that "page.php" you will have access to the variable $param1 which will have the value 12 At 01:21 AM 2/20/01 -0700, Free

Re: [PHP-DB] assoc arrays

2001-02-20 Thread CC Zona
In article [EMAIL PROTECTED], [EMAIL PROTECTED] ("Free Beachler") wrote: the form variables from an http post are stored in: http_post_vars[] - associative array containing form variables.. what about url parameters, such as:: http://www.mysite.com?param1=12 is there a corresponding

[PHP-DB] SQL Server 2000, annoying msg : Changed database context to 'xxx'.

2001-02-20 Thread Jeroen ten Berge
Hello people :) Anyone had problems with the annoying msg "Changed database context to 'xxx'." ? Running IIS5 with SQL Server 2000 on Win2K Adv. Svr. in CGI mode. Thanks in advance, Jeroen. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For

[PHP-DB] number_format bug?

2001-02-20 Thread Valerio Ferrucci
I call: ? $a = 13.8; $b = number_format($a, 2, ",", "."); print($b); ? the output is "13,00" !! any idea? Is it a bug? Thanks == Valerio FerrucciTabasoft Sas [EMAIL PROTECTED]

Re: [PHP-DB] members page / email and password

2001-02-20 Thread Marc Bragg
Does anyone have a simple php script for requiring entry of an email and password (settable by user) for access, that is logged in mysql for checking proper combination, and if new, creates new entry? Timothy Aslat wrote: Brandon Feldhahn wrote: im making a webdesign website that has a

[PHP-DB] retrieval of NEXT, PREV records

2001-02-20 Thread Adv. Systems Design
I have set up links to browse records one by one, using (ID+1) for NEXT and (ID-1) for PREV...the only problem is that if there is a hole in the ID sequence (as from DELETION), there is no record returned...How can I have it so that the 'holes' are paved over and not returned? TIA Luis

Re: [PHP-DB] retrieval of NEXT, PREV records

2001-02-20 Thread Peter J. Krawetzky
Check for a return code from the (I assume you are using a relational database) database stating a row was not found. If the condition is true, then re-execute the ID+1 or ID-1 code to select the next row in sequence. You can keep looping through this until you get a return code from the

Re: [PHP-DB] number_format bug?

2001-02-20 Thread Lennin Arriola
I was curious about it, so I tried it on my machine and I got "13,80" win2k+php4. I think is about settings in your php configuration, although I don't still find a reference for it. Lennin Arriola [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail:

[PHP-DB] password / email

2001-02-20 Thread Marc S. Bragg
Does anyone have a simple php script that requests a user to enter email and user name, which connects to database (mysql) to verify if existing, and if not, then to add as new user? -- Marc S. Bragg [EMAIL PROTECTED] Bialecki Bragg, PC p: 610-444-7508 f: 610-444-7548

Re: [PHP-DB] number_format bug?

2001-02-20 Thread Valerio Ferrucci
Does someone know which configuration to change to fix this? Lennin Arriola wrote: I was curious about it, so I tried it on my machine and I got "13,80" win2k+php4. I think is about settings in your php configuration, although I don't still find a reference for it. Lennin Arriola [EMAIL

[PHP-DB] flexible variables

2001-02-20 Thread Mircea Romanitan
Hello all. I have a question. How can i define some flexible variables? Suppose i have a table with (id, town, phone). In a file i have define ("ID", "id"); define ("TOWN", "town"); define ("PHONE", "phone"); and after i send a query( SELECT * FROM table) to that db and got the query into an

[PHP-DB] ORACLE dbms_sql - problems with select

2001-02-20 Thread Fernando Ferreras
Please , I canĀ“t show the results of this procedure... STR_SELECT := STR_SELECT || ' AND EMP.EMP_CODIGO ' || INICIO || ' AND ROWNUM (SELECT PAR_VALOR FROM PAR WHERE PAR_DESCRICAO = ' || VALOR || ')'; CURSOR1 :=DBMS_SQL.OPEN_CURSOR; DBMS_SQL.PARSE(CURSOR1,STR_SELECT,2); ROW_PROC

RE: [PHP-DB] flexible variables

2001-02-20 Thread Robert V. Zwink
In Reply to: Hello all. I have a question. How can i define some flexible variables? You would have to have a method in your object that echoed passed variable names. So it would look like this instead: echo $obj-write(ID); echo $obj-write(TOWN); echo $obj-write(PHONE); Or create an array

RE: [PHP-DB] PHP security

2001-02-20 Thread Ben - FCP
Absolutely correct! Having said all of this, it is still a bad idea (certainly on UNIX systems, I can't speak for Micro$oft) to keep passwords embedded in scripts in this way, particularly if you are running PHP as a CGI process, it is a better idea to have the appropriate passwords stored as

Re: [PHP-DB] PHP security

2001-02-20 Thread Ron Brogden
At 01:50 PM 2/20/2001 -0600, you wrote: As far as I know, you can not download PHP programs without access to download them. Meaning you need an account on the webserver, so they would need your account user and pass before they could steal your mysql user and pass. The main issue is that

Re: [PHP-DB] retrieval of NEXT, PREV records

2001-02-20 Thread JJeffman
"SELECT * FROM Table WHERE Rec_id $recid LIMIT 1" always bring you the next record no matter the Rec_id is. HTH Jayme. -Mensagem Original- De: Adv. Systems Design [EMAIL PROTECTED] Para: [EMAIL PROTECTED] Enviada em: tera-feira, 20 de fevereiro de 2001 11:41 Assunto: [PHP-DB]

Re: [PHP-DB] Is there a PHP equivalent of DATE_FORMAT ?

2001-02-20 Thread dmalcolm
Timothy Wright wrote: Just wondering... DATE_FORMAT($datevariable, \"%Y%c%e\") works great in a query but I only need to list the date once on the page (as opposed to in each row of the query result) and I don't want to use a second query to MySQL. The date is passed to the page as a

[PHP-DB] Simple Fail-Safe E-Business Opportunity!

2001-02-20 Thread dbcarolina
Does a "Self-Run" Business interest you? CASH IN on a virtual Money Machine! Let the World's First Online Recruiter help build your group! FREE Marketing Tools (Self-Replicating Web Pages, Autoresponders, Fax-On-Demand, ...) bring you the EASIEST plan to achieve wealth. Tap into the speed/power

Re: [PHP-DB] overall db solution anyone?

2001-02-20 Thread dmalcolm
Kevin McCarthy wrote: I am working for a company is experiencing severe growing pains. We are currently using FileMaker as the db to service the accounting and sales departments and using MySQL for the web back-end. As we have ecommerce capabilities, we are saddled with exchanging data

[PHP-DB] Oracle 8i Client URL

2001-02-20 Thread Randall Barber
Here is the URL for the Oracle 8i client (Sometimes I wish they would put things in easily found locations). http://download.oracle.com/otn/nt/oracle8i/oracle816client.zip It is 200 Megs (rounded up). This includes all possible varients of the client install (administrator, programmer, base

Re: [PHP-DB] overall db solution anyone?

2001-02-20 Thread Andrew Hill
Kevin, You may wish to examine Virtuoso: http://www.openlinksw.com/virtuoso It has all the functionality you mention, plus some, and is much cheaper to purchase and maintain. It also is optimized for seamless (non-disruptive) multiple database integration projects, and is in use in production

[PHP-DB] Drop-down menu selection

2001-02-20 Thread Julio Cuz, Jr.
Hi-- I hope all of you are having a great long weekend! Let's say I have four (4) tables: - "campus" that holds all my campuses' names (only 3), - "building_campus1" that holds all buildings for 'campus1', - "building_campus2" that holds all buildings for 'campus2', - "building_campus3" that

Re: [PHP-DB] advice

2001-02-20 Thread Beau Lebens
imp is really good, developed by the guys at horde http://www.horde.org/imp/ uses php and a mysql db. At 11:29 PM 2/20/01 -0800, Pedro M. S. Oliveira wrote: i need to set up a web mail service. i use pop, mysql, php and pearl. does anyone knows a program that would do the trick? i don't need to

[PHP-DB] Array element as object.

2001-02-20 Thread JJeffman
I've already made an object which had a property that was an array. Now I need to have an array that can hold objects as its elements is It possible ? I didn't get it the expression array[$i]-Object gave me syntax error. Any tips ? []'s Jayme. http://www.conex.com.br/jjeffman -- PHP

[PHP-DB] Lets Fly

2001-02-20 Thread Peter Burgess
This will take one minute and is worth it! You don't get nothing for nothing. Or so they say. But sources say that this one is the real McCoy so we're trying to wangle some free fly buys to do the world tour: oz-fiji-hawaii-tahiti The site below (owned by Air France and Qantas) now launches on

[PHP-DB] testing list configuration

2001-02-20 Thread testing
This is a test to see if this list is misconfigured. If you are reading this on the list it has not been closed to non-subscribers which is why we are receiving SPAM. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail:

[PHP-DB] close posting to non-subscribers please

2001-02-20 Thread Ron Brogden
At 12:29 PM 2/21/2001 +1100, you wrote: This will take one minute and is worth it! Arrgh. I just sent a test message as a non subscriber to see if this list was misconfigured, which it is. Whoever is the list admin, please please please close posting to non-subscribers. SPAM on mailing

Re: [PHP-DB] Drop-down menu selection

2001-02-20 Thread JJeffman
You need mix JavaScript and PHP. Write an "OnChange" event handler for the "campus" selection list and fill up the "buildings" drop-down menu in two ways: 1) If the amount of data is not very large you can get all data needed to run the "application" client side, load the data into JavaScript

RE: [PHP-DB] Drop-down menu selection

2001-02-20 Thread Thor M. Steindorsson
If he's reloading the same page, he doesn't even need javascript. but to do this without reloading the page, he can have php populate a javascript array, that can be used to re-populate the drop-down menu on the fly. -Original Message- From: JJeffman [mailto:[EMAIL PROTECTED]] Sent:

RE: [PHP-DB] Is there a PHP equivalent of DATE_FORMAT ?

2001-02-20 Thread Timothy Wright
The only problem is I'm not starting with a Unix timestamp. The variable is passed from a form as md (or 2001223... no leading zeros in the month or day). The PHP date function allows these characters in the string... "Y" - 4-digit year, "n" - month without leading zeros; i.e. "1" to

FW: [PHP-DB] authentication

2001-02-20 Thread Ronnie Esguerra
why not use sessions? on the first page do the login and start the session. throw the login to every other page using session variable. therefore when a user browses on the next page without the required variable you kick the page out. or you can use a database to track the user but it is more

RE: [PHP-DB] authentication

2001-02-20 Thread Boaz Yahav
Check this out : http://www.weberdev.com/index.php3?GoTo=search.php3%3Fsearch%3Dauthenticatio n%26searchtype%3Dtitle Sincerely berber Visit http://www.weberdev.com Today!!! To see where PHP might take you tomorrow. -Original Message- From: Pankaj Ahuja [mailto:[EMAIL

Re: [PHP-DB] authentication

2001-02-20 Thread Uioreanu Calin
then use phplib Otherwise, you need to define a session class (or use a free one from the web). -- 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