[PHP-DB] assoc arrays
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 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] assoc arrays
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 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 array for them, or do they go in the post_vars array? -- 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] -- Beau Lebens - Web Master Insurance My Way, Your Friendly Online Broker (08) 9226 5888 http://www.insurancemyway.com.au/ -- 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] assoc arrays
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 array for them, or do they go in the post_vars array? $HTTP_GET_VARS[] -- CC -- 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] SQL Server 2000, annoying msg : Changed database context to 'xxx'.
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 additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] number_format bug?
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] http://tabasoft.ancitel.it [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] members page / email and password
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 members login, do i have to make a member page for each member or can i get the info from the database of the person whom logged in and put it on the members page You could make individual pages for each member, but it's a lot easier to make a single PHP page and read the data from a database -- | Disclaimer:| Timothy Aslat [EMAIL PROTECTED] | | The sender of this email is a figment | http://www.goodiesruleok.com | | of a deranged imagination and leaves it| Spyderweb Consulting | | to your own devices to decide whose... | P: 82270800M: 0401088479 | -- 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] retrieval of NEXT, PREV records
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 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.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]
Re: [PHP-DB] retrieval of NEXT, PREV records
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 database that states a row was found. Peter -Original Message- From: Adv. Systems Design [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Tuesday, February 20, 2001 9:41 AM Subject: [PHP-DB] retrieval of NEXT, PREV records 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 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.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] number_format bug?
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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] password / email
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 http://www.chescolawyers.com/BB "Chester County Legal Services" - "For All Your Legal Needs" http://www.bloody100th.com "WWII 101st Airborne Division" http://www.petercatalano.com "Soul of An Italian Artist" -- 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] number_format bug?
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 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] I call: ? $a = 13.8; $b = number_format($a, 2, ",", "."); print($b); ? the output is "13,00" !! any idea? Is it a bug? -- == Valerio FerrucciTabasoft Sas [EMAIL PROTECTED] http://tabasoft.ancitel.it [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] flexible variables
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 object, i need to write: echo $obj-ID; echo $obj-TOWN; echo $obj-PHONE; but i cannot figure how? I tried to use variable variables, but it don't work. Thanks. Mircea
[PHP-DB] ORACLE dbms_sql - problems with select
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 :=DBMS_SQL.EXECUTE(CURSOR1); DBMS_SQL.CLOSE_CURSOR(CURSOR1); END PROC_CAT_SEL_EMPRESAS_TEMP; $cursor_1 = $dbase-newcursor(); $busca = $dbase-parse("BEGIN TESTE1.PROC_CAT_SEL_EMPRESAS_TEMP ('$emp_codigo','$razao_social','$cgc_empresa','$cat_pai','$cep','$cidade','$ estado','$sel_homologado_mol','$sel_homologado_emp','$ramo','$inicio',:resul t);END;"); $dbase-bind_cursor("result",$cursor_1); $dbase-execute(); $dbase-exec($cursor_1); $result_1 = $dbase-query_cursor($cursor_1); $codigo_emp = $result_1["EMP_CODIGO"]; $emp_razao = $result_1["EMP_RAZAO"]; $homologado_empresa = $result_1["HOMOLOGADO_EMPRESA"]; $homolgado_mol = $result_1["HOMOLOGADO_USEMOL"]; $catalogo = $result_1["CATALOGO"]; unset ($cursor_1); Thanks for any help, Ravage -- 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] flexible variables
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 within your object that contains your result set, then it could look like this: echo $obj-data[ID]; echo $obj-data[TOWN]; echo $obj-data[PHONE]; It would probably be better as a 2-dim array actually like this: echo $obj-data[$i][ID]; echo $obj-data[$i][TOWN]; echo $obj-data[$i][PHONE]; That way you would know what row to fetch from the database, and could cycle through the results. I think the way it should be done from an OOP design perspective is: echo $obj-write($i, ID); echo $obj-write($i, TOWN); echo $obj-write($i, PHONE); Because the value of properties should only be accessed by and objects methods. Programming references like: echo $obj-variable_name; Should really be: echo $obj-someMethod(variable_name); that returns the desired information. Regardless I don't see how you can do what you want with an object. You have to declare all of your variable (property) names at the begining of the object's definition, so they really can't be variable. Use an array, or a seperate method. I suppose you might be able to have the constructor handle variable names that you pass, but it still would not look like your example, and would require that you create a new object everytime. I probably just made things more confusing. If you really need help, repost with more info and I'm sure you will find help. Robert Zwink http://zwink.levitate.org -Original Message- From: Mircea Romanitan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 20, 2001 11:42 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] flexible variables 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 object, i need to write: echo $obj-ID; echo $obj-TOWN; echo $obj-PHONE; but i cannot figure how? I tried to use variable variables, but it don't work. Thanks. Mircea -- 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] PHP security
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 variables inside a separate script that is then called via and 'include' statement (which should then be read-only to 'root' if memory server me right -its been a long time since I ran PHP this way!). Ben Stoneham Technical Director - FCP Internet LTD. ___ FCP Internet LTD - 'Making the Web Work for You' 70 Smithbrook Kilns, Cranleigh, Surrey, GU6 8JJ, UK. Tel. 01483 272 303 Fax. 01483 272 303 mail: [EMAIL PROTECTED] http://www.fcpl.com ___ This message is confidential; Any unauthorised disclosure, use or dissemination, either whole or partial, is prohibited. If you are not the intended recipient of the message, please notify the sender immediately. -Original Message- From: Doug Schasteen [mailto:[EMAIL PROTECTED]] Sent: 20 February 2001 19:51 To: Don; php-db list Subject: Re: [PHP-DB] PHP security 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. I don't know how frontpage works, but it would probably have to call on the server to parse the php script before downloading it. There is no way to download a PHP script as a "nobody" user without it being parsed by PHP first. - Original Message - From: "Don" [EMAIL PROTECTED] To: "php-db list" [EMAIL PROTECTED] Sent: Tuesday, February 20, 2001 1:24 PM Subject: [PHP-DB] PHP security I am writing aome PHP scripts to connect to a MySQL database. In order to connect, I have found the following documented code: $dbLink = mysql_connect("localhost", "my_user", "my_password") Here, the password is plain text. This does not seem very secure to me. What is to prevent someone using a program like Frontpage to download my web and discover my password? -- 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] PHP security
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 (especially under Unix), the Front Page server extensions are notoriously poorly written and in most cases leave massive security holes wide open. Try doing a Google search for "hacking frontpage" to see some examples. The real solutions are: do not host with a provider that supports Front Page do not use Front Page as your HTML editor If you do decide to use Front Page as your editor make sure that you do not let it (or immediately remove them) the "shadow" directories of _vti_cnf (there are others too which I forget) that it likes to include with uploads. As long as you avoid that pitfall and the server does not have the server extensions installed you should be safe. You should also place your sensitive values in a separate file that is located in a non-web accessible directory or if you are running under "safe mode", in a protected sub-directory. Under Apache you would just have to create a directory called something like "./include" and in it place a .htaccess file with the following line: deny from all This makes it so that the only way to access the file is via an include command within PHP. This won't save you from local users viewing the file but that is a different sack of nuts. Cheers - Island Net AMT Solutions Group Inc. Telephone: 250 383-0096 1412 Quadra Toll Free:1 800 331-3055 Victoria, B.C. Fax:250 383-6698 V8W 2L1 E-Mail:[EMAIL PROTECTED] Canada WWW: http://www.islandnet.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]
Re: [PHP-DB] retrieval of NEXT, PREV records
"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] retrieval of NEXT, PREV records 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 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.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] Is there a PHP equivalent of DATE_FORMAT ?
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 variable in md (month and day as integers) format. Any help greatly appreciated... Tim ::: ::: ::: ::: Timothy Wright::: ::: mailto:[EMAIL PROTECTED] ::: ::: Digital Network Enterprises ::: ::: http://www.01network.com ::: ::: ::: ::: secure e-mail by request ::: ::: (PGP signature and/or encryption) ::: ::: -- 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] Yes. Take a look at http://www.php.net/manual/en/function.date.php You're Welcome DM -- 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] Simple Fail-Safe E-Business Opportunity!
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 of the Internet with our free tools and see your group grow fast! Guaranteed monthly Checks! You can earn $400 - $14,565+/month! We're Exploding! JOIN NOW and Succeed! Simply click below to request more Information About this great opportunity! mailto: [EMAIL PROTECTED]?subject=Send-Info It will ONLY take a minute to find out. You will be glad that you did! I received your e-mail as someone interested in Internet Business Opportunities. If I received your e-mail in error, or you are no longer interested, click here to be removed. Be sure REMOVE is in the Subject Title and you will not be contacted again: mailto:[EMAIL PROTECTED] ?subject=Remove Thank you! Dana -- 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] overall db solution anyone?
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 collected on and served to the web site (in online sales, user data, product information,etc.) with the other depts. As this is already untenable and cannot scale any further, we are looking to use one integrated database system to hold all the data we need. As we also need to completely redesign the db to scale to the current and soon-to-be size of the company, we are certain there must be a product or service out there that has somewhat ready-made designs or templates for a mid-size company like ours with the ability to service sales, marketing, web, accounting, etc., hopefully with some extensibility so that we can direct it as it and the company grows. The reason I ask this here is that our Web site has been built almost completely in PHP and we are very happy with it. Therefore we prefer to find a product that can work with it otherwise we would need to rebuild the entire site. I know Oracle is one popular solution but considering the price of licensing, running and administering Oracle, we really dread having to go that route. Ditto for using SQLServer, SiteServer, ASP and a Microsoft solution. Are there products or environments that PHP can work with other than MySQL that have the above capabilities or are we pretty much stuck with looking into Oracle and/or MS? We are not looking for OpenSource solutions necessarily, just something that is not as closed end and expensive as these two. Maybe we are a bit naive Feel free to respond off-line, if you prefer. 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] Take a look at http://www.jonesautomation.com They deal with Oracle a lot but are open to other scenarios. Dan -- 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] Oracle 8i Client URL
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 client, etc..) It may ask you for a log on and password. Apparently the membership is free, just sign up and you will have no troubles. Hope this helps, Randall Barber P.S. - I previously posted that the client was under the 8i personal edition, that is false, it was found under the 8i Enterprise Edition.
Re: [PHP-DB] overall db solution anyone?
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 systems sustaining 8000 concurrent database hits. Virtuoso also works great with PHP; I'd be happy to speak with you about the details of a migration project and how Virtuoso could fit your needs. Best regards, Andrew --- Andrew Hill - OpenLink Software Director Technology Evangelism eBusiness Infrastructure Technology http://www.openlinksw.com On 2/15/01 7:23 PM, "Kevin McCarthy" [EMAIL PROTECTED] 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 collected on and served to the web site (in online sales, user data, product information,etc.) with the other depts. As this is already untenable and cannot scale any further, we are looking to use one integrated database system to hold all the data we need. As we also need to completely redesign the db to scale to the current and soon-to-be size of the company, we are certain there must be a product or service out there that has somewhat ready-made designs or templates for a mid-size company like ours with the ability to service sales, marketing, web, accounting, etc., hopefully with some extensibility so that we can direct it as it and the company grows. The reason I ask this here is that our Web site has been built almost completely in PHP and we are very happy with it. Therefore we prefer to find a product that can work with it otherwise we would need to rebuild the entire site. I know Oracle is one popular solution but considering the price of licensing, running and administering Oracle, we really dread having to go that route. Ditto for using SQLServer, SiteServer, ASP and a Microsoft solution. Are there products or environments that PHP can work with other than MySQL that have the above capabilities or are we pretty much stuck with looking into Oracle and/or MS? We are not looking for OpenSource solutions necessarily, just something that is not as closed end and expensive as these two. Maybe we are a bit naive Feel free to respond off-line, if you prefer. 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] Drop-down menu selection
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 holds all buildings for 'campus3'. If the user selects "campus 1" from a drop-menu, how can I select "buildings for campus 1" on a second drop-down menu? In other words, how do I select the corresponding "building's table" when any "campus" is selected? Thanks! P.S. I have tried the 'onChange' command, but I guess I got the syntax wrong: = // $campus: ?php echo("SELECT onChange='building.value = building.this.value' NAME='campus'"); $cmlist = @pg_exec($db, "SELECT * FROM \"Campus\"") or die(include("../sqlerror.inc")); $i = 0; $x = pg_numrows($cmlist); while ($i $x): $clist = pg_fetch_array($cmlist,$i); echo "OPTION VALUE='".$clist["Campus"]."'".$clist["Campus"]."/OPTION"; $i++; endwhile; echo("/SELECT"); ? $building: ?php echo("SELECT NAME='building'"); $cmlist = @pg_exec($db, "SELECT * FROM building_$campus") or die(include("../sqlerror.inc")); $i = 0; $x = pg_numrows($cmlist); while ($i $x): $clist = pg_fetch_array($cmlist,$i); echo "OPTION VALUE='".$clist["Building"]."'".$clist["Building"]."/OPTION"; $i++; endwhile; echo("/SELECT"); ? = Julio Cuz, Jr. Riverside Community College [EMAIL PROTECTED]
Re: [PHP-DB] advice
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 develop this as i know that there are alot of packages that do this, but i would like to know if any of you as experience with this kind of software. thank you all folks! *** Pedro Miguel Silva Oliveira Cell Phone: +351 96 5867227 SMS: [EMAIL PROTECTED] Email: [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] -- Beau Lebens - Web Master Insurance My Way, Your Friendly Online Broker (08) 9226 5888 http://www.insurancemyway.com.au/ -- 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] Array element as object.
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 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] Lets Fly
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 5th March. To launch the site they are offering the chance to join free of charge if you sign up before the 5th March (after that it will cost $200). It works on a pyramid selling basis ie everyone that signs up after you and quotes your e-mail address earns air miles for you. The web site is http://www.thepayline.com Once you've logged on just click on the right hand side where it says FREE MEMBERSHIP and follow the instructions. Then send it on to all your mates and when they sign up, you get the air miles. You need to enter my e-mail address to join [EMAIL PROTECTED] Apparently a friend of a friend of a friend received enough air miles in one day for a free trip around the world for six ! I have already earned over 33 thousand miles in a week. It now ads credibility and is even more exciting since Fitness Age Inc (owners of MP3.com) have bought this site late last week. sounds sweet as __,,_ ___/ / /-' /___/ Peter Burgess m2o Designs 151 Greville Street Prahran 3181 Melbourne Australia Ph: 03 9521 2553 Fx: 03 9529 4712 EM: [EMAIL PROTECTED] URL:http://www.m2o.com.au
[PHP-DB] testing list configuration
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: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] close posting to non-subscribers please
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 lists is evil and this little step would stop 99% of it. Cheers - Island Net AMT Solutions Group Inc. Telephone: 250 383-0096 1412 Quadra Toll Free:1 800 331-3055 Victoria, B.C. Fax:250 383-6698 V8W 2L1 E-Mail:[EMAIL PROTECTED] Canada WWW: http://www.islandnet.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]
Re: [PHP-DB] Drop-down menu selection
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 arrays and refresh the select boxes using JavaScript scripts. Otherwise you must reload the page and process the values posted by the form. 2) Reload the same page (window.location="self.php?campus=value") and run your php script to fill up the "buildings" drop-down menu. HTH. Jayme. -Mensagem Original- De: Julio Cuz, Jr. [EMAIL PROTECTED] Para: [EMAIL PROTECTED] Enviada em: tera-feira, 20 de fevereiro de 2001 21:44 Assunto: [PHP-DB] Drop-down menu selection 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 holds all buildings for 'campus3'. If the user selects "campus 1" from a drop-menu, how can I select "buildings for campus 1" on a second drop-down menu? In other words, how do I select the corresponding "building's table" when any "campus" is selected? Thanks! P.S. I have tried the 'onChange' command, but I guess I got the syntax wrong: = // $campus: ?php echo("SELECT onChange='building.value = building.this.value' NAME='campus'"); $cmlist = @pg_exec($db, "SELECT * FROM \"Campus\"") or die(include("../sqlerror.inc")); $i = 0; $x = pg_numrows($cmlist); while ($i $x): $clist = pg_fetch_array($cmlist,$i); echo "OPTION VALUE='".$clist["Campus"]."'".$clist["Campus"]."/OPTION"; $i++; endwhile; echo("/SELECT"); ? $building: ?php echo("SELECT NAME='building'"); $cmlist = @pg_exec($db, "SELECT * FROM building_$campus") or die(include("../sqlerror.inc")); $i = 0; $x = pg_numrows($cmlist); while ($i $x): $clist = pg_fetch_array($cmlist,$i); echo "OPTION VALUE='".$clist["Building"]."'".$clist["Building"]."/OPTION"; $i++; endwhile; echo("/SELECT"); ? = Julio Cuz, Jr. Riverside Community College [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] Drop-down menu selection
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: Tuesday, February 20, 2001 5:29 PM To: [EMAIL PROTECTED]; Julio Cuz, Jr. Subject: Re: [PHP-DB] Drop-down menu selection 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 arrays and refresh the select boxes using JavaScript scripts. Otherwise you must reload the page and process the values posted by the form. 2) Reload the same page (window.location="self.php?campus=value") and run your php script to fill up the "buildings" drop-down menu. HTH. Jayme. -Mensagem Original- De: Julio Cuz, Jr. [EMAIL PROTECTED] Para: [EMAIL PROTECTED] Enviada em: tera-feira, 20 de fevereiro de 2001 21:44 Assunto: [PHP-DB] Drop-down menu selection 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 holds all buildings for 'campus3'. If the user selects "campus 1" from a drop-menu, how can I select "buildings for campus 1" on a second drop-down menu? In other words, how do I select the corresponding "building's table" when any "campus" is selected? Thanks! P.S. I have tried the 'onChange' command, but I guess I got the syntax wrong: = // $campus: ?php echo("SELECT onChange='building.value = building.this.value' NAME='campus'"); $cmlist = @pg_exec($db, "SELECT * FROM \"Campus\"") or die(include("../sqlerror.inc")); $i = 0; $x = pg_numrows($cmlist); while ($i $x): $clist = pg_fetch_array($cmlist,$i); echo "OPTION VALUE='".$clist["Campus"]."'".$clist["Campus"]."/OPTION"; $i++; endwhile; echo("/SELECT"); ? $building: ?php echo("SELECT NAME='building'"); $cmlist = @pg_exec($db, "SELECT * FROM building_$campus") or die(include("../sqlerror.inc")); $i = 0; $x = pg_numrows($cmlist); while ($i $x): $clist = pg_fetch_array($cmlist,$i); echo "OPTION VALUE='".$clist["Building"]."'".$clist["Building"]."/OPTION"; $i++; endwhile; echo("/SELECT"); ? = Julio Cuz, Jr. Riverside Community College [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] Is there a PHP equivalent of DATE_FORMAT ?
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 "12" "j" - day of the month without leading zeros; i.e. "1" to "31" ... so echo date("Y-n-j") would give me the output in the right format, but I need to convert the input to a valid timestamp first. Any ideas?? Am I missing something really obvious...it's late and my brain is tired.. Thanks, Tim Wright ::: ::: ::: ::: Timothy Wright::: ::: mailto:[EMAIL PROTECTED] ::: ::: Digital Network Enterprises ::: ::: http://www.01network.com ::: ::: ::: ::: secure e-mail by request ::: ::: (PGP signature and/or encryption) ::: ::: -Original Message- From: dmalcolm [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 20, 2001 4:56 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Is there a PHP equivalent of DATE_FORMAT ? 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 variable in md (month and day as integers) format. Any help greatly appreciated... Tim ::: ::: ::: ::: Timothy Wright::: ::: mailto:[EMAIL PROTECTED] ::: ::: Digital Network Enterprises ::: ::: http://www.01network.com ::: ::: ::: ::: secure e-mail by request ::: ::: (PGP signature and/or encryption) ::: ::: -- 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] Yes. Take a look at http://www.php.net/manual/en/function.date.php You're Welcome DM -- 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]
FW: [PHP-DB] authentication
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 complicated. ronnie -Original Message- From: Pankaj Ahuja [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 21, 2001 2:27 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] authentication Hi all I need to authenticate a user and on successful login he is redirected to a page. This works fine. However, this is not secure as the page to which the user is redirected can be accessed directly as well. What I need is when someone tries to access the page without logging in first, he should be taken to the login page 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] authentication
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 PROTECTED]] Sent: Wednesday, February 21, 2001 8:27 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] authentication Hi all I need to authenticate a user and on successful login he is redirected to a page. This works fine. However, this is not secure as the page to which the user is redirected can be accessed directly as well. What I need is when someone tries to access the page without logging in first, he should be taken to the login page 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] authentication
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 PROTECTED]