[PHP-DB] oci functions

2002-11-07 Thread Maziar
Hi everybody What should I do for useing OCI functions of oracle 9i in PHP4. I think I should recompile PHP with somthing but I don't know with what and how should I do this. I installed oracle 9i on SUSE linux 8.0. Best Regards Maizar -- PHP Database Mailing List (http://www.php.net/) To

[PHP-DB] [Newbie Q] csv file upload via php to mysql tutorial request

2002-11-07 Thread kristina
Hello listers I am a complete newbie at this and I have searched for anything that could help me understand this, but I've had no luck. My reason for emailing is this - I want to know how to upload a csv file via php to a mysql database. I have found a few examples but they are all

RE: [PHP-DB] Archiving A Database

2002-11-07 Thread Josh Johnson
Thanks Peter! It turns out the people I work for don't care at all about this data, they were only using it to push clients to buy bigger packages and for bragging rights, so grand totals/totals per client/per period are all they need, the extra data I was logging *just in case* is totally

RE: [PHP-DB] [Newbie Q] csv file upload via php to mysql tutoria

2002-11-07 Thread Ruprecht Helms
Hi kristina, [...] I can see that phpMyAdmin does this, which is great but I need it for joe public to be able to use. so I don't want them using phpMyAdmin. If you can't use phpMyAdmin try to make it with SQL-Import or a similar function. For mysql you have documentation under

RE: [PHP-DB] sort by date

2002-11-07 Thread Josh Johnson
It's also a matter of time, I think a lot of people try to be the first to answer something, or are answering from work on a busy day... they just don't have time to write explanations, or to RTFM themselves to verify (I'm guilty of this one), but they want to help. This is especially frustrating

Re: [PHP-DB] MySQL password protection?

2002-11-07 Thread Adam Voigt
Make the include file (or wherever your page with the pass is) encrypted, see ioncube.com they charge by the amount of code you incrypt, for a simple database include file, I think it would be $1 or less. On Wed, 2002-11-06 at 16:04, William Trappeniers wrote: Hi all I was wondering if it is

[PHP-DB] [Newbie] Can't get MySQL working with PHP 4 under Apache 2

2002-11-07 Thread Matt Symes
Hello, I've got PHP 4 working under Apache 2 on Linux Redhat 8 using the packages that came with the Redhat 8 installation. I can't get PHP to work with MySQL however. myphpadmin says that it cannot load the MySQL extension. When I check my PHP settings with phpinfo I see that it was compiled

[PHP-DB] first Array value duplicating..

2002-11-07 Thread Aaron Wolski
Hi All, In a form I have checkboxes associated with order records. The checkboxes are for deleting order records (should a client choose to do so). It looks like this: form name=form action=process_bank.php method=POST input type=hidden name=order_index[0] value=1 td class=cartlink

[PHP-DB] regular expression and exact word search...

2002-11-07 Thread BAROILLER Pierre-Emmanuel
Hi! does someone know how to find an exact word in a content with html tags ? I'm using a regexp like this : $searchRegEx = '\b.$word_search.\b'msi; to get boundary word results, but... if the searched word is like 'word or word. or anything else, the regular expression doesn't work.. if I

Re: [PHP-DB] oci functions

2002-11-07 Thread .: B i g D o g :.
Compile php with the OCI configuration option. That will work with oracle9i. On Thu, 2002-11-07 at 08:32, Maziar wrote: Hi everybody What should I do for useing OCI functions of oracle 9i in PHP4. I think I should recompile PHP with somthing but I don't know with what and how should I do

Re: [PHP-DB] first Array value duplicating..

2002-11-07 Thread .: B i g D o g :.
I would suggest doing a var_dump of $order_index and see what is in there. Plus, you should take out the values in the form arrays... Just do: name=order_index[] On Thu, 2002-11-07 at 15:24, Aaron Wolski wrote: Hi All, In a form I have checkboxes associated with order records. The

[PHP-DB] calling sql script

2002-11-07 Thread Edward Peloke
I need to use a php page to run an .sql script against a mysql db. How do I simply call the script from php? I can take parts of it and execute the statements but I would like to just call the entire script. Thanks, Eddie -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

RE: [PHP-DB] calling sql script

2002-11-07 Thread Anderson, Jerrad
There is a shell command I remember reading on phpbuilder.com. do a quick search. .. I believe it is exec -Original Message- From: Edward Peloke [mailto:epeloke;echoman.com] Sent: Thursday, November 07, 2002 12:02 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] calling sql script I need to

RE: [PHP-DB] calling sql script

2002-11-07 Thread Anderson, Jerrad
http://www.phpbuilder.com/manual/function.exec.php -Original Message- From: Edward Peloke [mailto:epeloke;echoman.com] Sent: Thursday, November 07, 2002 12:02 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] calling sql script I need to use a php page to run an .sql script against a mysql db.

Re: [PHP-DB] calling sql script

2002-11-07 Thread Marco Tabini
You can use exec http://ca.php.net/manual/en/ref.exec.php You will probably need to call the mysql shell like so: /path_to_mysql/mysql -u user -p password [-h host] -D database -e \\. filename Marco -- php|architect - The magazine for PHP Professionals The first monthly

Re: [PHP-DB] first Array value duplicating..

2002-11-07 Thread Terry Romine
An Real World example of how I do a similar thing might help: My list with checkboxes (since this is dynamic, I don't know what numbers are assigned) $itemID is the id of the record from the mysql table, so the check box name is 'chk_12' for id=12. $checkAll is a flag if the user selected the

Re: [PHP-DB] first Array value duplicating..

2002-11-07 Thread Adam Voigt
Ok, here's how I do it: =) Delete checkbox's (assuming this is being called recursively, once for each row in the db): input type=checkbox name=delete[] value=$row[id] And on submition: foreach($_POST[delete] AS $row) mysql_query(DELETE FROM tablename WHERE id = '$row';); Adam Voigt

Re: [PHP-DB] oci function

2002-11-07 Thread Maxim Maletsky
you need to compile it with oci8 extension: http://uk.php.net/manual/it/ref.oci8.php -- Maxim Maletsky [EMAIL PROTECTED] Maziar [EMAIL PROTECTED] wrote... : Hi everybody What should I do for useing OCI functions of oracle 9i in PHP4. I think I should recompile PHP with somthing but I

[PHP-DB] Structure Question...

2002-11-07 Thread Doug Coning
Hi everyone, I'd like to know how you would set up the following: I've set up a MySQL database with 600 products. I set it up where each product belongs to a category. However, now we want to take it further where different products can now belong to more than 1 category. How would you create

Re: [PHP-DB] Structure Question...

2002-11-07 Thread Ignatius Reilly
You have to create a table: CREATE TABLE product_categ ( FK_productID definition, FK_categID definition ) and list all relationships productID belongs to categID Ignatius - Original Message - From: Doug Coning [EMAIL PROTECTED] To: [EMAIL

Re: [PHP-DB] Structure Question...

2002-11-07 Thread Miles Thompson
Third choice, definitely. And aren't you glad your data is sufficiently normalized that this is a no-brainer! Cheers - Miles Thompson At 12:51 PM 11/7/2002 -0600, Doug Coning wrote: Hi everyone, I'd like to know how you would set up the following: I've set up a MySQL database with 600

RE: [PHP-DB] Warning message

2002-11-07 Thread Anderson, Jerrad
I'm using PHP on apache that's sitting on a Windows 2k server. When I don't define a variable i'm getting a warning message on the screen.. anyway to suppress these errors? Warning: Undefined variable: yaddayaddaydaadda thanks for any info jerrad -- PHP Database Mailing List

Re: [PHP-DB] Warning message

2002-11-07 Thread Pierre-Alain Joye
On Thu, 7 Nov 2002 13:37:49 -0500 Anderson, Jerrad [EMAIL PROTECTED] wrote: I'm using PHP on apache that's sitting on a Windows 2k server. When I don't define a variable i'm getting a warning message on the screen.. anyway to suppress these errors? Warning: Undefined variable:

[PHP-DB] session variables

2002-11-07 Thread kevin myers
I have a question: I have a site, http://www.darkrpg.ionichost.com, and htp://www.mail.ionichost.com. I'm trying to find a way of passing the session varible from darkrpg to mail that way they need not log in again. Is it possiable with out cookies? And another question i have is on

RE: [PHP-DB] Warning message

2002-11-07 Thread Anderson, Jerrad
Logging them may work better. Thank you -Original Message- From: Pierre-Alain Joye [mailto:paj;pearfr.org] Sent: Thursday, November 07, 2002 1:41 PM To: Anderson, Jerrad Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Warning message On Thu, 7 Nov 2002 13:37:49 -0500 Anderson, Jerrad [EMAIL

Re: [PHP-DB] Structure Question...

2002-11-07 Thread Brent Baisley
You would want 2 3. You should create 3 tables, one for products, one for categories and one to relate the two. You should only store ID numbers that relate to products and categories. On Thursday, November 7, 2002, at 01:51 PM, Doug Coning wrote: Hi everyone, I'd like to know how you would

Re: [PHP-DB] session variables

2002-11-07 Thread Maxim Maletsky
kevin myers [EMAIL PROTECTED] wrote... : I have a question: I have a site, http://www.darkrpg.ionichost.com, and htp://www.mail.ionichost.com. I'm trying to find a way of passing the session varible from darkrpg to mail that way they need not log in again. Is it possiable with out

Re: [PHP-DB] [Newbie Q] csv file upload via php to mysql tutoria

2002-11-07 Thread Maxim Maletsky
Basically, you would have to receive a CSV data to then pass it to the mysql via command prompt, just as if you would do it via shell. You should be using mysqlimport in shell. So, in PHP you'd get to use system command to accomplish this all automatically. Be aware of some security issues. --

RE: [PHP-DB] [Newbie Q] csv file upload via php to mysql tutoria

2002-11-07 Thread Anderson, Jerrad
Is Load-Data possible in mssql? -Original Message- From: Chris Boget [mailto:chris;wild.net] Sent: Thursday, November 07, 2002 2:48 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: kristina; [EMAIL PROTECTED] Subject: Re: [PHP-DB] [Newbie Q] csv file upload via php to mysql tutoria

Re: [PHP-DB] [Newbie Q] csv file upload via php to mysql tutoria

2002-11-07 Thread Chris Boget
Is Load-Data possible in mssql? I'm unsure but the original poster was asking about mysql. Chris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Argh!!!! Help with something o-f-f-t-o-p-i-c

2002-11-07 Thread Aaron Wolski
Sorry for the OT post y'all.. but I can't find this answer - well not without major major code information that I can't figure out! Basic? I have a series of checkbox arrays like: input type=checkbox name=delete[] value=$row[id] These are for different records in my DB. Now... I want

RE: [PHP-DB] Argh!!!! Help with something o-f-f-t-o-p-i-c

2002-11-07 Thread Josh Johnson
Check out www.devguru.com, they have a great javascript refrence Otherwise I have no idea :) -- Josh -Original Message- From: Aaron Wolski [mailto:aaronjw;martekbiz.com] Sent: Thursday, November 07, 2002 4:23 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Argh Help with something

Re: [PHP-DB] Argh!!!! Help with something o-f-f-t-o-p-i-c

2002-11-07 Thread .: B i g D o g :.
You need to get the element by name and then do the confirmation... On Thu, 2002-11-07 at 21:23, Aaron Wolski wrote: Sorry for the OT post y'all.. but I can't find this answer - well not without major major code information that I can't figure out! Basic? I have a series of checkbox

[PHP-DB] How do I list Oracle table names

2002-11-07 Thread smdief
I'm very new at this. Is there a way I can list all table names in an Oracle database? Sign Up for Juno Platinum Internet Access Today Only $9.95 per month! Visit www.juno.com -- PHP Database Mailing List

[PHP-DB] How to list Oracle table names

2002-11-07 Thread smdief
I'm very new at this. Can I list all the table names in an Oracle database? Sign Up for Juno Platinum Internet Access Today Only $9.95 per month! Visit www.juno.com -- PHP Database Mailing List (http://www.php.net/) To

RE: [PHP-DB] addition to uploading

2002-11-07 Thread Ryan Holowaychuk
How can I get the php page to email me after it has done and upload successfully. Do I use the mail()?? any thoughts Thanks [Ryan Holowaychuk] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] addition to uploading

2002-11-07 Thread Peter Beckman
Yep. http://www.php.net/manual/en/function.mail.php mail([EMAIL PROTECTED],Subject goes Here,Body of message and all that); Peter On Thu, 7 Nov 2002, Ryan Holowaychuk wrote: How can I get the php page to email me after it has done and upload successfully. Do I use the mail()?? any

Re: [PHP-DB] [Newbie Q] csv file upload via php to mysql tutorialrequest

2002-11-07 Thread Peter Beckman
1. learn how to do a file upload in PHP: http://www.php.net/manual/en/features.file-upload.php 2. Process the CSV file line by line in a loop. Not posting your CSV file format, I can only guess that it will be in proper form. If so: for loop { $csvline = 'column1,column2,column3';

Re: [PHP-DB] OCIBindByName with Oracle 8i17 problem ?!

2002-11-07 Thread Fabien JOSEPH
Thies C. Arntzen wrote: On Mon, Nov 04, 2002 at 06:16:04PM +0100, Fabien JOSEPH wrote: I discovered recently that it was impossible to bind an output placeholder plsql (an input work only). Configuration 1 : Suse + Oracle 8i17 + oci (oracle) + PHP4.2.3 Configuration 2 : HPUX11 + Oracle 8i17

[PHP-DB] Polls?

2002-11-07 Thread Leif K-Brooks
I'm working on a polling system, and I'm having a bit of a problem. I'm not sure how to store the questions. Storing them in a seperate table would require a query for each poll displayed - not good. I've also thought of storing them as a serialized array. Any thoughts on this? -- The

Re: [PHP-DB] Polls?

2002-11-07 Thread Leif K-Brooks
Thanks, but my problem is how to efficiently display a page with all of the polls with results. Also, I need a variable number of questions, which that tutorial doesn't provide. Thanks, though. Ignatius Reilly wrote: One possibility: table questions( questionID, question_text, ...) PRIMARY

[PHP-DB] Re: How do I list Oracle table names

2002-11-07 Thread Philippe Saladin
[EMAIL PROTECTED] a écrit dans le message news: [EMAIL PROTECTED] I'm very new at this. Is there a way I can list all table names in an Oracle database? I thinl you know how to connect to Oracle via php (simple tutorial : http://www.thickbook.com/extra/php_oracle.phtml) To obtain a list of the

[PHP-DB] Re: [Newbie] Can't get MySQL working with PHP 4 under Apache 2

2002-11-07 Thread Tjoumaidis
I had the same problem until i found out that the distribution itself did not installed the required package php-mysql.rpm. Find it in one of the cd's and install it. Matt Symes wrote: Hello, I've got PHP 4 working under Apache 2 on Linux Redhat 8 using the packages that came with the Redhat 8