[PHP-DB] Re: [Newbie] Can't get MySQL working with PHP 4 under Apache 2
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 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 with the '--with-mysql=shared,/usr' option. I've tried uncommenting the extension=mysql.so line in php.ini but that doesn't work. Any ideas. I'm quite new to this game (although an IT professional in other areas) so it's quite possible I'm missing something trivial. Thanks in anticipation, - Matt Symes -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: How do I list Oracle table names
<[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 tables, just execute this query : select table_name from sys.all_tables where owner = 'http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Polls?
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 KEY( questionID) table answers( FK_questionID, individualID, answer_code, ...) PRIMARY KEY( FK_questionID, individualID) For very simple online polls, there is a nice tutorial in Devshed: http://www.devshed.com/Server_Side/PHP/PHPDemocracy HTH Ignatius - Original Message - From: "Leif K-Brooks" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, November 08, 2002 8:15 AM Subject: [PHP-DB] Polls? 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 above message is encrypted with double rot13 encoding. Any unauthorized attempt to decrypt it will be prosecuted to the full extent of the law. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- The above message is encrypted with double rot13 encoding. Any unauthorized attempt to decrypt it will be prosecuted to the full extent of the law.
Re: [PHP-DB] Polls?
One possibility: table questions( questionID, question_text, ...) PRIMARY KEY( questionID) table answers( FK_questionID, individualID, answer_code, ...) PRIMARY KEY( FK_questionID, individualID) For very simple online polls, there is a nice tutorial in Devshed: http://www.devshed.com/Server_Side/PHP/PHPDemocracy HTH Ignatius - Original Message - From: "Leif K-Brooks" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, November 08, 2002 8:15 AM Subject: [PHP-DB] Polls? > 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 above message is encrypted with double rot13 encoding. Any unauthorized attempt to decrypt it will be prosecuted to the full extent of the law. > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Polls?
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 above message is encrypted with double rot13 encoding. Any unauthorized attempt to decrypt it will be prosecuted to the full extent of the law. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] OCIBindByName with Oracle 8i17 problem ?!
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 + oci(oracle) + PHP4.2.3 Configuration 3 : HPUX11 + Oracle 8i17 + oci(oracle) + PHP4.2.2 With script : inoutdemo.sql CREATE OR REPLACE PROCEDURE inoutdemo (par_in IN VARCHAR2, par_in_out IN OUT VARCHAR2, par_out OUT VARCHAR2) IS BEGIN par_out:=par_in; par_in_out:=par_in||' '||par_in_out;END; $db=OCILogon("toto","titi"); $stmt=OCIParse($db,"BEGIN inoutdemo(:in,:inout,:out);END;"); OCIBindByName($stmt,":in",$in,32); OCIBindByName($stmt,":inout",$inout,32); OCIBindByName($stmt,":out",$out,32); $in="Hello "; $inout="World!"; OCIExecute($stmt); echo $in."\n".$inout."\n".$out."\n"; //Result Warning: OCIStmtExecute: ORA-06550: line 1, column 17: PLS-00553: character set name is not recognized ORA-06550: line 0, column 0: i'd say you have a problem with your NLS_LANG setting. re, tc PL/SQL: Compilation unit analysis terminated in /opt/apache/htdocs/fab.php4 on line 58 Hello World! I tested this script with the 3 configurations but it's the same error I changed $in, &inout , &out into $&in, $&out, $&inout but it's the same error Please help me !!! Fabien JOSEPH -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php Thank you for your help but finally I resolved my problem. It was my compilation of php. Before my compilation of phpI, forgot to set LD_LIBRARY_PATH to $ORACLE_HOME/lib. Recently, I compiled again my php but this time I set LD_LIBRARY_PATH before the compilation. And finally when I finished to compile my php, I test my script again and it's work. Fabien JOSEPH -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] [Newbie Q] csv file upload via php to mysql tutorialrequest
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"'; $r = mysql_query("insert into table values ($csvline)"); } This assumes the data in your CSV file is the same as your DB structure. If not, do this: $r = mysql_query("insert into table (column1,column2,column3) values ($csvline)"); Peter On Thu, 7 Nov 2002, kristina wrote: > 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 > much to advanced for > my needs. I just want the bear basics > so I can understand > it. > > 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. > > Just a few links to some tutorials would > be marvellous. > > ;o) > > -- > tia as always > > bfn > .kristina > > [EMAIL PROTECTED] > kfxdesign.net > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > --- Peter BeckmanSystems Engineer, Fairfax Cable Access Corporation [EMAIL PROTECTED] http://www.purplecow.com/ --- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] addition to uploading
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 thoughts > > Thanks > [Ryan Holowaychuk] > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > --- Peter BeckmanSystems Engineer, Fairfax Cable Access Corporation [EMAIL PROTECTED] http://www.purplecow.com/ --- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] addition to uploading
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
[PHP-DB] How to list Oracle table names
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 unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] How do I list Oracle table names
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 (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Argh!!!! Help with something o-f-f-t-o-p-i-c
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 arrays like: > > > > These are for different records in my DB. > > > Now... I want to check (javascript - this is the off topic part :P) if > one of them checkboxes HAS been selected and if so display a confirm > message. > > This is what I have: > > function checkform(f) { > > var el, e = 0, firstBox, msg = 'You are about to delete something'; > > while (el = f.elements[e++]) > >if (el.type == 'checkbox' && el.checked) { > return confirm(msg); > return false; >} > > return true; > > } > > Now... this DOES work but with one problem.. I have another checkbox > within the form that does something different but the confirm() will > display if EITHER checkboxes are selected and it SHOULD ONLY be on the > delete[] checkbox. > > I know.. waaay off topic but I don't know how to reference the names > that are arrays in javascript :( > > Sorry again all. > > Aaron -- .: B i g D o g :. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Argh!!!! Help with something o-f-f-t-o-p-i-c
Can you not filter the checkboxes by name? Just add one more condition to the if statement: if (el.type == 'checkbox' && el.checked && el.name != 'theothercheckbox') etc. Marco -- php|architect - The magazine for PHP Professionals The first monthly worldwide magazine dedicated to PHP programmer Come visit us at http://www.phparch.com! --- Begin Message --- 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: These are for different records in my DB. Now... I want to check (javascript - this is the off topic part :P) if one of them checkboxes HAS been selected and if so display a confirm message. This is what I have: function checkform(f) { var el, e = 0, firstBox, msg = 'You are about to delete something'; while (el = f.elements[e++]) if (el.type == 'checkbox' && el.checked) { return confirm(msg); return false; } return true; } Now... this DOES work but with one problem.. I have another checkbox within the form that does something different but the confirm() will display if EITHER checkboxes are selected and it SHOULD ONLY be on the delete[] checkbox. I know.. waaay off topic but I don't know how to reference the names that are arrays in javascript :( Sorry again all. Aaron --- End Message --- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Argh!!!! Help with something o-f-f-t-o-p-i-c
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 o-f-f-t-o-p-i-c 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: These are for different records in my DB. Now... I want to check (javascript - this is the off topic part :P) if one of them checkboxes HAS been selected and if so display a confirm message. This is what I have: function checkform(f) { var el, e = 0, firstBox, msg = 'You are about to delete something'; while (el = f.elements[e++]) if (el.type == 'checkbox' && el.checked) { return confirm(msg); return false; } return true; } Now... this DOES work but with one problem.. I have another checkbox within the form that does something different but the confirm() will display if EITHER checkboxes are selected and it SHOULD ONLY be on the delete[] checkbox. I know.. waaay off topic but I don't know how to reference the names that are arrays in javascript :( Sorry again all. Aaron -- 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
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: These are for different records in my DB. Now... I want to check (javascript - this is the off topic part :P) if one of them checkboxes HAS been selected and if so display a confirm message. This is what I have: function checkform(f) { var el, e = 0, firstBox, msg = 'You are about to delete something'; while (el = f.elements[e++]) if (el.type == 'checkbox' && el.checked) { return confirm(msg); return false; } return true; } Now... this DOES work but with one problem.. I have another checkbox within the form that does something different but the confirm() will display if EITHER checkboxes are selected and it SHOULD ONLY be on the delete[] checkbox. I know.. waaay off topic but I don't know how to reference the names that are arrays in javascript :( Sorry again all. Aaron
Re: [PHP-DB] [Newbie Q] csv file upload via php to mysql tutoria
> 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
RE: [PHP-DB] [Newbie Q] csv file upload via php to mysql tutoria
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 > 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. Actually, you don't even need to do that. Since you are uploading the file via PHP, PHP has the relevant information regarding that file. Particularly, where it's located. Using that, you can just do a LOAD DATA INFILE query in mySQL. You can find more information about there here: http://www.mysql.com/doc/en/LOAD_DATA.html I'm doing exactly what you are - accepting a csv file as upload - and I'm using the above query command to get it into the DB. It's been working for me for the last 2 years. :p hth Chris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] [Newbie Q] csv file upload via php to mysql tutoria
> 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. Actually, you don't even need to do that. Since you are uploading the file via PHP, PHP has the relevant information regarding that file. Particularly, where it's located. Using that, you can just do a LOAD DATA INFILE query in mySQL. You can find more information about there here: http://www.mysql.com/doc/en/LOAD_DATA.html I'm doing exactly what you are - accepting a csv file as upload - and I'm using the above query command to get it into the DB. It's been working for me for the last 2 years. :p hth Chris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] [Newbie Q] csv file upload via php to mysql tutoria
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. -- Maxim Maletsky [EMAIL PROTECTED] Ruprecht Helms <[EMAIL PROTECTED]> wrote... : > 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 http://www.mysql.com in English > and http://www.mysql.de for German. > > Regards, > Ruprecht > > -- > Ruprecht Helms IT-Service und Softwareentwicklung > > Tel/Fax.: +49[0]7621 16 99 16 > Homepage: http://www.rheyn.de > email: [EMAIL PROTECTED] > -- > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] session variables
"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 cookies? Are they on the same server? If yes, then you can still share the data within session if you pass session ID in get while linking between the sites. It is up to your logic how to do so. Though, i discourage you doing it as this is a HUGE security hole. > And another question i have is on > http://www.darkrpg.ionichost.com/login/, i have it set up where after you > suvmit your log in information it displays you session information. Every > time I log in it says that the mysql result is not valid yet it still logs > me and my user in. Is there any way to remove this message from the screen? > Is it possiable that it is the way i have my query set up? It can be mySQL's bug. To get rid of that error just add at-mark (@) infront of the function call: @mysql_connect(... or whatever -- Maxim Maletsky [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Structure Question...
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 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 this? 1. Would you duplicate the records for items that belong to more than 1 category and change the categories in those duplicated records? 2. Would you enter multiple categories into 1 column? 3. Would you create a different database that tracks categories and creat a many to many relationship? Thanks, Doug Coning -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Warning message
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 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: yaddayaddaydaadda You may better to fix all warnings/errors instead of hiding them :-) Changes the error reporting level (see error_reporting() in the manual). Nota Bene: If you need to hide php messages in your production environment, you may disable output messages in php.ini, and log them. hth pa -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] session variables
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 http://www.darkrpg.ionichost.com/login/, i have it set up where after you suvmit your log in information it displays you session information. Every time I log in it says that the mysql result is not valid yet it still logs me and my user in. Is there any way to remove this message from the screen? Is it possiable that it is the way i have my query set up? thanks Kevin Myers _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Warning message
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: yaddayaddaydaadda You may better to fix all warnings/errors instead of hiding them :-) Changes the error reporting level (see error_reporting() in the manual). Nota Bene: If you need to hide php messages in your production environment, you may disable output messages in php.ini, and log them. hth pa -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Warning message
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 (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Structure Question...
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 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 this? 1. Would you duplicate the records for items that belong to more than 1 category and change the categories in those duplicated records? 2. Would you enter multiple categories into 1 column? 3. Would you create a different database that tracks categories and creat a many to many relationship? Thanks, Doug Coning -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Structure Question...
You have to create a table: CREATE TABLE product_categ ( FK_productID , FK_categID ) and list all relationships "productID belongs to categID" Ignatius - Original Message - From: "Doug Coning" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, November 07, 2002 7:51 PM Subject: [PHP-DB] Structure Question... > 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 this? > > 1. Would you duplicate the records for items that belong to more than 1 > category and change the categories in those duplicated records? > > 2. Would you enter multiple categories into 1 column? > > 3. Would you create a different database that tracks categories and creat a > many to many relationship? > > Thanks, > > Doug Coning > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Structure Question...
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 this? 1. Would you duplicate the records for items that belong to more than 1 category and change the categories in those duplicated records? 2. Would you enter multiple categories into 1 column? 3. Would you create a different database that tracks categories and creat a many to many relationship? Thanks, Doug Coning -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] oci function
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 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 unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] first Array value duplicating..
Ok, here's how I do it: =) Delete checkbox's (assuming this is being called recursively, once for each row in the db): And on submition: foreach($_POST[delete] AS $row) mysql_query("DELETE FROM tablename WHERE id = '$row';"); Adam Voigt [EMAIL PROTECTED] > > 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: > > > > > > > > > name="delete[0]" value="1"> > > > > > name="delete[1]" value="1"> > > > > > name="delete[2]" value="1"> > > > > > name="delete[3]" value="1"> > > > > > > Now.. when the process button is pressed the information is carried off > > to the process_bank.php script. > > > > Lets assume for this example.. I selected the checkbox delete[0] (which > > equals value 1) and delete[3] (which equals value 12). > > > > In the script I have this code: > > > > for ($i=0;$i > > >$orderQuery = db_query("SELECT id FROM TestOrderTable WHERE > > id=".$order_index[$i]); > >$orderResult = db_fetch($orderQuery); > > > >if ($delete[$i] == 1) { > > > > $ids .= $orderResult["id"]; > > > > echo $ids; > > > > > >} > > } > > > > The echo'd value that I get is 1,1,12 when it should be 1,12. > > > > When only ONE checkbox is selected I just get the one value displayed > > (i.e. if I selected the first checkbox the echo'd value would be 1). > > > > Does anyone know why the first value is being duplicated on a multiple > > select but not on a single select? > > > > Sorry if this sounds confusing :( > > > > Aaron > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] first Array value duplicating..
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 "Check All" button, echos("selected") to check all the checkboxes. The in my process code I switch the submit button and test for delete. $maxID is the max(id) from the list of items. I walk through the possible list of items and see if any were checked and if so append them to my list of deletes. Note that I use "where id in ()" to gather all the items at once. case "Delete Selected Records": for($x=0;$x<=$maxID;$x++){ $varname="chk_$x"; $value=$$varname; if($value) { $events[] = $value; } } if($events) $events_IDs = implode("','", $events); $sql= "delete from $tableName where id in ('$events_IDs')"; mysql_query($sql) or die($sql . mysql_error()); $message_str="Record(s) deleted"; break; HTH Terry On Thursday, November 7, 2002, at 09:24 AM, Aaron Wolski wrote: 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: Now.. when the process button is pressed the information is carried off to the process_bank.php script. Lets assume for this example.. I selected the checkbox delete[0] (which equals value 1) and delete[3] (which equals value 12). In the script I have this code: for ($i=0;$i -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] calling sql script
Well, either use PHPMyAdmin, or if this is a recursive thing like, you need to have this done one the fly, and you have shell (SSH) access to your host, connect your host and do "which mysql" in the console and this will probably give you the path. Adam Voigt [EMAIL PROTECTED] On Thu, 2002-11-07 at 12:13, Edward Peloke wrote: > But I am not sure where my hosting companies mysql is so I do not know the > path > > -Original Message- > From: Marco Tabini [mailto:marcot@;inicode.com] > Sent: Thursday, November 07, 2002 11:31 AM > To: Edward Peloke > Cc: [EMAIL PROTECTED] > Subject: Re: [PHP-DB] calling sql script > > > 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 worldwide magazine dedicated to PHP programmer > > Come visit us at http://www.phparch.com! > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] calling sql script
But I am not sure where my hosting companies mysql is so I do not know the path -Original Message- From: Marco Tabini [mailto:marcot@;inicode.com] Sent: Thursday, November 07, 2002 11:31 AM To: Edward Peloke Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] calling sql script 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 worldwide magazine dedicated to PHP programmer Come visit us at http://www.phparch.com! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] calling sql script
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 worldwide magazine dedicated to PHP programmer Come visit us at http://www.phparch.com! --- Begin Message --- 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, visit: http://www.php.net/unsub.php --- End Message --- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] calling sql script
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. 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, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] calling sql script
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 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, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] calling sql script
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, visit: http://www.php.net/unsub.php
Re: [PHP-DB] first Array value duplicating..
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 > checkboxes are for deleting order records (should a client choose to do > so). > > It looks like this: > > > > name="delete[0]" value="1"> > > name="delete[1]" value="1"> > > name="delete[2]" value="1"> > > name="delete[3]" value="1"> > > > Now.. when the process button is pressed the information is carried off > to the process_bank.php script. > > Lets assume for this example.. I selected the checkbox delete[0] (which > equals value 1) and delete[3] (which equals value 12). > > In the script I have this code: > > for ($i=0;$i >$orderQuery = db_query("SELECT id FROM TestOrderTable WHERE > id=".$order_index[$i]); >$orderResult = db_fetch($orderQuery); > >if ($delete[$i] == 1) { > > $ids .= $orderResult["id"]; > > echo $ids; > > >} > } > > The echo'd value that I get is 1,1,12 when it should be 1,12. > > When only ONE checkbox is selected I just get the one value displayed > (i.e. if I selected the first checkbox the echo'd value would be 1). > > Does anyone know why the first value is being duplicated on a multiple > select but not on a single select? > > Sorry if this sounds confusing :( > > Aaron -- .: B i g D o g :. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] oci functions
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 this. I installed oracle 9i on SUSE linux 8.0. > Best Regards > Maizar > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- .: B i g D o g :. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] regular expression and exact word search...
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 remove the \b , I've got all words ( but without bound...) Any idea? (the big problem is I'm higlighting found sentences, and .. if the searched word is part of an html tag, it's very auwfull... ) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] first Array value duplicating..
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: Now.. when the process button is pressed the information is carried off to the process_bank.php script. Lets assume for this example.. I selected the checkbox delete[0] (which equals value 1) and delete[3] (which equals value 12). In the script I have this code: for ($i=0;$i
[PHP-DB] [Newbie] Can't get MySQL working with PHP 4 under Apache 2
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 with the '--with-mysql=shared,/usr' option. I've tried uncommenting the extension=mysql.so line in php.ini but that doesn't work. Any ideas. I'm quite new to this game (although an IT professional in other areas) so it's quite possible I'm missing something trivial. Thanks in anticipation, - Matt Symes -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] MySQL password protection?
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 possible to protect my password to the MySQL-server > from being in a PHP-script. Now I can't do that, so everybody who gets to > see my php-sourcecode also can see my (not protected/not encrypted) > password. > How can I change this? > > Thanks, > > William > > --- > William Trappeniers > mail at: [EMAIL PROTECTED] > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] sort by date
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 when sometimes people are asking for things that aren't obvious, and it takes 2 or 3 posts of them saying "no that won't work because..." before what they're *really* trying to do comes out. You write a long, descriptive post and they really are just trying to do something that won't work the way they want it to. :) I try to be polite, and apologize when I've been proven wrong. I think people get too easily frustrated answering the same question over and over, especially when it's something they've known for a long time. I learned almost everything I know (especially in regards to php) from experience and lots of reading, as I'm sure most of us on this list have, and it's just natural to quote a manual page or point someone there to give them a chance to learn on their own. An then sometimes a question is so obvious and has been asked so many times (by people in the list, by most people as they're learning) that the answer is very simple, and automatic. It's easier to say "try [this code]" than to risk insulting someone by saying "hey you should know better that's all wrong, look here and here and here and find the answer". Like I said, I try to be polite, and I'm very patient with people, but honestly, if they're writing a php script and using a database to back it, they're not newbies, or at the very least, they *should* be able to read a manual. -- Josh -Original Message- From: Lisi [mailto:lists@;shemeshdirectory.co.il] Sent: Thursday, November 07, 2002 2:23 AM To: Snijders, Mark; 'Marco Tabini'; Terry Romine Cc: [EMAIL PROTECTED] Subject: RE: [PHP-DB] sort by date There is a difference between a general, "how do I do this" question and a specific "here's my code, I can't find the bug" question. Sometimes people just need a quick answer specific to their code. Also, unfortunately, many times when people want to point to a resource they give the standard "RTFM". Believe it or not, many newbies don't always know how to do this!! A polite "it's too long to go into on the list, but you can read more about this here" with a link is much more helpful. -Lisi At 04:22 PM 11/6/02 +0100, Snijders, Mark wrote: >why does everybody always gives the answers?? why not a hint, or where to >search that they can learn something about it??? > > > > > >-Original Message- >From: Marco Tabini [mailto:marcot@;inicode.com] >Sent: woensdag 6 november 2002 16:08 >To: Terry Romine >Cc: [EMAIL PROTECTED] >Subject: Re: [PHP-DB] sort by date > > >Ok, going out on a limb here... have you tried something like > >select e.id, title, location, address, contact, category, event_time, >urllink, descript, min(event_date) from eventTable e inner join >dateTable d on e.id = d.id group by e.id > >? > > >Marco > >-- > >php|architect - The magazine for PHP Professionals >The first monthly worldwide magazine dedicated to PHP programmer > >Come visit us at http://www.phparch.com! > > > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] [Newbie Q] csv file upload via php to mysql tutoria
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 http://www.mysql.com in English and http://www.mysql.de for German. Regards, Ruprecht -- Ruprecht Helms IT-Service und Softwareentwicklung Tel/Fax.: +49[0]7621 16 99 16 Homepage: http://www.rheyn.de email: [EMAIL PROTECTED] -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Archiving A Database
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 useless to them, so they pushed for the quickest solution. I ended up implementing a scheme to just sort of "condense" the data by a common factor (the client's username), and record totals (see my post: [PHP-DB] Query Help for more info). I'm using cron jobs to run SQL on the database periodically to "move" the data around, and I used table locking in an attempt to keep the data sound. I'm still weary of the huge number (ok, its only like 5, but still) of queries and loops I'm using to gather the data for display, but it seems to be working ok (any suggestions would be greatly appreciated). I'll definitely keep your suggestions in mind for more serious archiving of data in the future. Thanks again! -- Josh -Original Message- From: Peter Beckman [mailto:beckman@;purplecow.com] Sent: Thursday, November 07, 2002 12:05 AM To: Josh Johnson Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Archiving A Database Do you need to archive it forever? Do you need live access to it? If you just need to archive it, read the man page for mysqldump. You can dump specific rows to a file, rename that file dump.2002.05.24, compress it with gzip, and voila, you have all of your data readily available, easily reinserted into your existing live DB. After the dump is complete, just delete those rows out of the DB. Now you have to be sure that the file contains 100% of the data and is accurate. You'll have to figure out how to do that yourself! One way I did it with WWW log files was to make a tmp copy, run a program on it, see if the output had the same number of lines in it, and if it did, delete the tmp copy and replace the original copy with the new copy (IP->DNS translation). In this case you could write a script that parses the newly created dump file in the standard format and, heck, using perl or PHP parse the thing for ),( and see how many you get. If the mysql select gets X rows, and the "),(" or ");" occurs X-1 times, then you know you got all the rows. (OK, it will be more complex than this, but you get the idea.) One record per file could get ugly real quick, both on the filesystem side and the maintenance side. Doing it by day will allow you to repopulate an entire day back into the DB as needed for billing questions or what not. MySQL will keep the unique ID (assuming it is a number auto_incremented) unique and only use ever higher IDs, not use old ones that no longer exist in the DB at the moment. Once you are done with that Day (or days) of data, you just delete it from the DB, knowing you have a copy of that day on file. I would also advise you to have 2-4 copies of all your backups on both physically different computers as well as physically different locations. I kept a copy of my live DB, backed up every 6 hours, at the data center on other computer, on my computer file server at home, and another one 7 states over. Sure, it's a bit of a pain in the ass, but if the data center goes up in smoke and my file server is hacked on the same day, I still have a copy 7 states over. I just used scp (secure-shell copy) and/or rsync + ssh to keep copies current and up to date on remote machines. Peter On Tue, 29 Oct 2002, Josh Johnson wrote: > Does anyone know of speedy methods of periodically archiving and > retrieving a database table? I've got a table I'm using to log > statistical data, and it's getting 10k+ entries per day. Entries are > only logged in the database if the user is authenticated for access, and > only once per access session (the user is authenticated, a cookie is > set, and the entry is logged. From that point the user is authenticated > by verifying the cookie, which expires when the user's browser closes) > > The data is critical (used for billing and such), but the log viewing > script I've written runs slower and slower with each passing day, and at > one point the entire table was corrupted due to neglect on our system > admin's part (I warned them about the default setting of > mysql_max_connections being too low for a site that relied on the DB so > heavily and had so much traffic.). The script is a simple front end to > several MySQL queries, that retrieve totals for the past hour, day, > week, month and grand totals for all clients or a given client. The rest > of the site has been unaffected by the log issues. > > My current approach is to log the data as XML, one record per file, and > create a log file that is an index of refrences to each record. I then > empty previous data n the database. This works, but is very hard/slow to > retrieve specific groups of information, and dumping the database takes > a long time as well, which adds the difficulty of ensuring no records >
[PHP-DB] [Newbie Q] csv file upload via php to mysql tutorial request
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 much to advanced for my needs. I just want the bear basics so I can understand it. 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. Just a few links to some tutorials would be marvellous. ;o) -- tia as always bfn .kristina [EMAIL PROTECTED] kfxdesign.net -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] oci functions
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 unsubscribe, visit: http://www.php.net/unsub.php