[PHP-DB] Performance: why it take so long time?

Hi. I am using PHP4+Apache 1.3.14 (win32)+[Access-local | Oracle-remote] with very simple query on small tables. When I start the page.php it takes several second to display the results: it seems that it is waiting someting; if there are many rows, it displays a portion of it at time (in terms of

RE: [PHP-DB] parsing checkbox array without [] and selecting all boxes

Hi Olinux, U may want 2 try this js-code: function ToggleAllCheckboxes() { for( var x = 0; x < document.MYFORM.elements.length; x++ ) { var y = document.MYFORM.elements[x]; if( y.name != 'CHECKALL') y.checked = document.MYFORM.CHECKALL.checked; } } As U C, U have 2 setup a

[PHP-DB] Re: Performance: why it take so long time?

Hi Stefano I don't know if this is what you are looking for. Take a look at the flush() function which should bring output faster to the browser. Hope it help Cheers Soeren - Original Message - From: "Stefano" <[EMAIL PROTECTED]> > The question is: there are some variable configuration

[PHP-DB] problem with form

hello, hope anyone has an idea on how to fix this... even i click on the edit button, it will still go to submit.php page, why is that? thanks -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTE

[PHP-DB] finding out the result of an INSERT

Hi, this might be a stupid question but it's got me stumped today My setup: php, mysql, apache etc I'm inserting a record into a table that's got a primary key which is auto incrementing .. +---+---+--+-+-++ | Field | Type

RE: [PHP-DB] problem with form

The form header should specify which page you want to go to when you submit the form. If you require to go to diffent pages depending on which button is pressed you can set a hidden variable to specify the required page/action. Then include the correct action code using a switch statement.

[PHP-DB] How to use GnuPG to store data on MySQL

Hello, I'm trying to store some encrypted data on MySQL using GnuPG and eventually send this information via e-mail. Is somebody using this solution? Has somebody links on this topic where I can look and see how to do it? Regards, Tomás +-- --+ Tom

[PHP-DB] PHP4-ODBC-MSSQL7

Hello Everyone!! We are making on the project with PHP4 and MSSQL7. Everything is based on NT4 platform. Certainly, in this case we are operating by SQL stored procedures. The question is.. I found some problems while extracting data from database over ODBC which we need to use to make a bridge

RE: [PHP-DB] finding out the result of an INSERT

RTFM or search in the archive of this mailinglist !!! int mysql_insert_id ([int link_identifier]) Greetinx, Mike Michael Rudel - Web-Development, Systemadministration - Besuchen Sie uns am 20. und 21. August 2001 auf der online-marketing-düsseldorf in Halle 1 Stand E 16 _

AW: [PHP-DB] PHP4-ODBC-MSSQL7

Hi, I'm not sure about the probeme you have, but if the probleme is based on ODBC, why do use ODBC? You could also use the Sybase-Ct libs.. should work also with MSSQL... Greetings, Stefan -Ursprüngliche Nachricht- Von: Michael Yevdokimov [mailto:[EMAIL PROTECTED]] Gesendet: Dienstag,

Re: [PHP-DB] finding out the result of an INSERT

http://php.net/manual/en/function.mysql-insert-id.php < from the link above > Warning: mysql_insert_id() converts the return type of the native MySQL C API function mysql_insert_id() to a type of long. If your AUTO_INCREMENT column has a column type of BIGINT, the value returned by mysql_

[PHP-DB] Re: problem with form

Hi, > hope anyone has an idea on how to fix this... > > > OnClick="submit.php" class="button"> > class="button"> > you could give the form one action and then check on the following page wether $Submit or $Edit is set. form.php ... doit.php http://www.php.net/) To unsubscribe, e-mail: [E

[PHP-DB] Re: problem with form

Try setting form.action and using form.submit() to send it ('edit.php' is not valid javascript). Here: Note that this includes a fall-back: if JavaScript is not suppo

RE: [PHP-DB] How to use GnuPG to store data on MySQL

Yes :- http://www.alt-php-faq.org/#id65 Regards Darren http://www.php4hosting.com > -Original Message- > From: Tomas Garcia Ferrari [mailto:[EMAIL PROTECTED]] > Sent: 10 July 2001 12:02 > To: 'php-db' > Subject: [PHP-DB] How to use GnuPG to store data on MySQL > > > Hello, > > I'm trying

RE: [PHP-DB] PHP4-ODBC-MSSQL7

Micheal, If things work in Query but not PHP you can easily get an under-the-covers comparison of the ODBC calls by turning on Tracing in the ODBC Administrator (Driver Manager). Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Da

RE: [PHP-DB] testing ODBC + MSSQL connection locally

olinux, When you move to remote connections and want to compile ODBC support into PHP on a *nix box, you will need a Driver Manager in the mix as well as the ODBC Drivers. There is a HOWTO on compiling the iODBC Driver Manager with PHP at www.iodbc.org. Basically, it involves getting the iODBC

RE: [PHP-DB] IBM DB2 on Linux with PHP is very slow

Christian, Are you using an ODBC driver or just the unified-ODBC functions? If a driver, then I suggest changing vendors - that performance is in no way representative of ODBC in general. In addition, to improve performance even more when using similar queries, first use odbc_prepare to prepare a

[PHP-DB] TE INFORMAMOS

Jacarilla 8.7.2001.Publicidad/Enseñanza a Distancia Hola que tal: El motivo de la presente carta es informarte de la posibilidad de poder realizar algún curso a distancia de tu interés, cursos relacionados con tu trabajo inquietudes y ocio.ect.El conocimiento es el mayor patr

[PHP-DB] using ADODB db class

Not sure if this is really the right list to ask on, so please excuse me. I am trying to use the adodb db class with php4/mysql. On problem i have hit is that if i retrieve 2 tables with a join and the 2 tables both have a field of the same name, the command $result->fields("fieldname") always

[PHP-DB] Re: using ADODB db class

Hi Mark, You can access the column by index position instead, or use as column alias: "select a.col col1, b.col col2 from a,b where a.key = b.key" Then access using col1 and col2. Bye, John "Mark Newnham" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Not s

[PHP-DB] Re: Performance: why it take so long time?

Don't flush or print/echo too often. This generates many fragmented tcp-ip packets (causing the behaviour you observe). The fastest method is probably store the accumulated HTML data in a variable and print the variable every 100 rows or so. Regards, John "Soeren Nielsen" <[EMAIL PROTECTED]> wro

Re: [PHP-DB] PHP4-ODBC-MSSQL7

Hi Michael, The should not be any issues with the oder of the columns in the select using ODBC. I do have some questions for you. 1) What is the reson for using stored procedures for this. The procedure you are showing is just a wrapper arround a SQL statement. You could as easily generate the

[PHP-DB] MySQL Error

Dear Experts When ever i try to run MySQL under linux it gives me following error ERROR 2002 : can't connect to local MYSQL server through socket '/var/lib/mysql.sock' (111) what could be possible remedy/rectification of the above ? million thx in advance Vivek Misra -- PHP Database Ma

[PHP-DB] Re: MySQL Error

Are you running as the admin setting it up or are you a user on the system getting the error? "Vivek Misra" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Dear Experts > > When ever i try to run MySQL under linux it gives me following error > > ERROR 2002 : ca

[PHP-DB] losing data from a mysql database field

Hi, I'm having an odd occurrence using mysql. If I insert into a varchar field with information like "This is the information", it works fine and I can retreive and display the data using a normal 'print' or 'echo' statement. However, if I try to display the data in a form field (so that I can

[PHP-DB] Re: MySQL Error

Hi, > Dear Experts > > When ever i try to run MySQL under linux it gives me following error > > ERROR 2002 : can't connect to local MYSQL server through socket '/var/lib/mysql.sock' (111) this is with PHP isn't it? can you log in the monitor and then type SHOW VARIABLES. A long list will be disp

[PHP-DB] Images from database

I have seen in several places the following line: Will this tag work in both IE and Netscape? What does myScript.php do? Does it find an image and pass the binary data back? Something like this-- Am I getting this, or am I missing the whole point? Thanks RDB

[PHP-DB] Re: Images from database

> "Randall Barber" <[EMAIL PROTECTED]> wrote >I have seen in several places the following line: > > > > Will this tag work in both IE and Netscape? Yes > What does myScript.php do? Does it find an image and pass the binary data back? Sure, that's one use; another is to dynamically generate an

[PHP-DB] Re: Images from database

Hi, >I have seen in several places the following line: > > > >Will this tag work in both IE and Netscape? > >What does myScript.php do? Does it find an image and pass the binary data back? sorry if this is not really answering your question. I'd think about storing only the path to the image i

Re: [PHP-DB] MySQL Error

ensure that your mysqld is actually running. Then try running 'mysql -hlocalhost -uroot' if it's a new install, or add '-p' at the end if you've set a root password. Alternately, specify another user after -u. That should help. I just figured this one out the other day... I had gone so far

Re: [PHP-DB] Images from database

Check out http://www.phpbuilder.com/columns/florian19991014.php3. It's a tutorial that explains getting images in and out of databases. It also describes what this myscript.php thingy does. Good luck, Ben >Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm >list-help:

[PHP-DB] Access Violation PLEASE HELP.

I have the following setup. PHP 4.04 running on windows 2000 using SQL Server 7.0 The script runs fine for sometime, then I get the following errors PHP has encountered Access Violation at 013A2466. So I have to reboot everytime. This happens almost every 2 to 3 hours or so. I have to use PHP on

[PHP-DB] PHP4 + interbase = bug?

Hello, I've used PHP4 + Interbase and I got a "PHP Program executed an ilegal operation" bla bla bla bla. in a very very simple php script. Then I switched back to PHP3 and everything is fine (well, everything for this only little script I've tested). Is this know? Is PHP4 + Interbase buggy? W

Re: [PHP-DB] IBM DB2 on Linux with PHP is very slow

Hi Andrew, thanks a lot for your help. Today we discovered what our real problem was: After "playing" a little bit with the php-scripts that try to connect to the IBM DB2, we set the optional parameter Cursortype when calling odbc_pconnect(). And the exciting thing: When we set the cursor t

[PHP-DB] PHP-ODBC-MSSQL (Text type fields)

Hello Did anybody have problems with retrieving data from the fields of type Text.. I can retrieve any other fields but not the field of type text.. What could be the problem? Thank you. Mike Michael Yevdokimov Web developer e-mail: [EMAIL PROTECTED] Globa

[PHP-DB] PHP-ODBC-MSSQL (Text type fields) PART II

Hi I found an interesting thing.. But it will just make my work much harder.. comparing to ASP... :o (which I already am not able to use in the project we should deliver to our customer in a few weeks :o This code will not retrieve the data from col_subj_content.. But!! If I replac

[PHP-DB] PHP-ODBC-MSSQL PartII

The error which occures during the call of stored procedure is: Warning: SQL error: [Microsoft][ODBC SQL Server Driver]Invalid Descriptor Index, SQL state S1002 in SQLGetData in d:\Inetpub\wwwroot\local_test\test.php on line 43 Michael Yevdokimov Web developer e-mail: [EMAIL PROTECTED] ---

[PHP-DB] PHP-ODBC-MSSQL (NT) PART 3

Ok.. I discovered also that everything will work pretty good.. But!! The field on type text should be ALWAYS the LAST in the model of the table.. Otherwise, it will not work what happens in my case.. Good night! Mike Michael Yevdokimov Web developer e-mail: [EMAIL PROTECTED] -

[PHP-DB] Delete file

Hello php-db, How to delete file using PHP ? and how to set it's permission ? ,,, (@-@) +==---o00(_)00o-==+ "It is better to be defeated on principle than to win on lies." --Arthur Calwell -- Best regards, andRie

RE: [PHP-DB] Delete file

http://www.php.net/manual/en/ref.filesystem.php -Original Message- From: andRie Is [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 3:28 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Delete file Hello php-db, How to delete file using PHP ? and how to set it's permission ?

[PHP-DB] MySQL Database Locking - needed?

Hi The company I work for has recently developed a Car Dealer type site, which acts as a large on-line used car yard. Currently the MySQL database holding the cars is added too / edited / deleted by one person employed for the job - but we hope to expand to allow the Dealers themselves admin

[PHP-DB] HTML question

Hello, pure HTML server question: images like (backgroundimage.jpg) stored on server at: /htdocs/www/img util.showpic.html is stored at : /htdocs/util/ How to use backgroundimage.jpg as background in util.showpic.html ? does not work.. what if anything will work? Thnaks Ken -- PHP D

[PHP-DB] Re: MySQL Database Locking - needed?

Hello, Tom Peck wrote: > > Hi > > The company I work for has recently developed a Car Dealer type site, which > acts as a large on-line used car yard. Currently the MySQL database > holding the cars is added too / edited / deleted by one person employed for > the job - but we hope to expand to

[PHP-DB] image mapping

Hello, pure HTML server question: images like (backgroundimage.jpg) stored on server at: /htdocs/img util.showpic.html is stored at : /htdocs/util/ How to use backgroundimage.jpg as background in util.showpic.html ? does not work.. what if anything will work? Thnaks Ken -- PHP Dat

[PHP-DB] php/interbase ibase_trans()

The following sequence appears to hang the webpage... ... $dbht = ibase_trans($dbh); ... insert... if($dbht) { ibase_commit($dbht); } any thoughts to how to overcome this? David Miles -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For addi

Re: [PHP-DB] HTML question

Is /htdocs/ your web root? If it isn't the browser loading up the page would not have access to /www/img/backgroundimage.jpg. If it is - try removing the space after the .jpg in your body tag. Tom At 15:51 10/07/2001 -0700, you wrote: >Hello, pure HTML server question: > >images like (back

Re: [PHP-DB] Re: MySQL Database Locking - needed?

Thanks for the reply Manual. The updating IS done with one single query - but the problem is that if two people are editing the same car, the second update will overwrite the first. Not a huge problem - and the chance of it happening is almost nil - but there is still the possibility.. Chang

Re: [PHP-DB] HTML question

HI, thanks not sure what the web root is. first dir I see on FTP is / so is that the root? and it contains a whole bunch of dirs including htdocs htdocs contains dirs: img (pics) util (utility html pages) www (main html pages) is there a way to refer to images in imgfrom html pages in

Re: [PHP-DB] Re: MySQL Database Locking - needed?

Tom Peck wrote: > > Thanks for the reply Manual. > > The updating IS done with one single query - but the problem is that if two > people are editing the same car, the second update will overwrite the > first. Not a huge problem - and the chance of it happening is almost nil - > but there is st

Re: [PHP-DB] HTML question

when you load up your web page in your browser, what folder do you see? It is most likely the contents of the www/ folder. If this is the case, then all of your files which you want accessible to the web (ie html and images) need to be somewhere under this. Try putting both the background im

Re: [PHP-DB] HTML question

I Looked up the root..sorry it is DOCUMENT_ROOT .. /htdocs/www so I guess browsers think they are starting out at /htdocs/www and can't go below to get anything? so if I have phtml pages at /htdocs/util/ like www.util.consumergrapevine.org/showdatabases.php and images at /htdocs/www/img can

Re: [PHP-DB] Re: MySQL Database Locking - needed?

So what you mean is: If someone clicks on a car to edit, a txt file is written (maybe called the carID.txt). Then if someone else clicks on that car to edit it, it says that it is already being edited by someone else because the txt file exists? So what happens if that person who clicked fir

Re: [PHP-DB] HTML question

The php file placed in your /util/ directory will not be accessible by the web.. everything you want accessible to the web has to be placed in the /www/ folder.. so place the php file in the /www/ folder (or /www/util/ if you like) and the images in the /www/img/ folder, and use the body tag

Re: [PHP-DB] HTML question

to get to the img directory you need to go up one directory ( "../" ) and then into the img directory hope that helps nick At 04:38 10/07/01 -0700, Ken Sommers wrote: >I Looked up the root..sorry > it is DOCUMENT_ROOT .. /htdocs/www >so I guess browsers think they are s

Re: [PHP-DB] Re: MySQL Database Locking - needed?

Tom Peck wrote: > > > >How about writing a text file that would be your "lock" file, rather > >than depending upon MySQL to do it for you? > > > >-- > >Raquel > > So what you mean is: > > If someone clicks on a car to edit, a txt file is written (maybe called the > carID.txt). Then if someone e

Re: [PHP-DB] Re: MySQL Database Locking - needed?

Ahhh, ok a good idea. I will think about it some more. Thanks Tom At 16:55 10/07/2001 -0700, you wrote: >Tom Peck wrote: > > > > > >How about writing a text file that would be your "lock" file, rather > > >than depending upon MySQL to do it for you? > > > > > >-- > > >Raquel > > > > So what yo

[PHP-DB] Sub domain image referencing

Hello again, DOCUMENT_ROOT is.. /htdocs/www I have a php file ( showdatabases.php) in my subdomain area /htdocs/util/ it loads up just fine: and if you click it, you will see my database structure if you like..:) www.util.consumergrapevine.org/showdatabases.php I have images stored in /h

[PHP-DB] RE: trash last message ,this ones right I think

Hello again, DOCUMENT_ROOT is.. /htdocs/www I have a php file ( showdatabases.php) in my subdomain area /htdocs/util/ it loads up just fine: and if you click it, you will see my database structure if you like..:) http://util.consumergrapevine.org/showdatabases.php I have images stored in

Re: [PHP-DB] RE: trash last message ,this ones right I think

The problem is that they are completely different websites, from the web browser point of view - even though they are so close to each other on the server... You should have mentioned this was a sub domain site :-) If you REALLY don't want to copy the image from the www folder to the util fol

Re: [PHP-DB] RE: trash last message ,this ones right I think

Thanks Tom and sorry I didn't mention it properly at first,, I was trying to analyse the problem. is it becuz the first part of the referenece being the ../ in the ../ wants to take the browser into illegal territory above the root? because we are starting from /htdocs/util so the ../ woul

Re: [PHP-DB] RE: trash last message ,this ones right I think

Yes that is correct. Your main site root is: /htdocs/www/ And your sub site (util) root is /htdocs/util/ These are two different sites from the browser's point of view. Neither site will have access to anything below the root folder (from the browser). Tom At 18:02 10/07/2001 -0700, you wrot

Re: [PHP-DB] RE: trash last message ,this ones right I think

Thanks again, why couldn't the main root be /htdocs/ ? ken - Original Message - From: "Tom Peck" <[EMAIL PROTECTED]> To: "Ken Sommers" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, July 10, 2001 6:05 PM Subject: Re: [PHP-DB] RE: trash last message ,this ones right I think > Ye

[PHP-DB] Re: trash last message ,this ones right I think

Perhaps you could consider using the webserver config (in Apache it would be the httpd.conf file) to do the dirty work. Create and alias (in the /util/ domain) for "img" that points to the "/hdocs/www/img/" location - voila! YMMV HTH Tom Henry Ken Sommers wrote: > Hello again, > DOCUME

Re: [PHP-DB] RE: trash last message ,this ones right I think

Ken If the util site is going to be part of the main site, why don't you put it in the www folder? ie. /htdocs/www/util/ the idea for different site roots is so that you can keep different sites separate. If you had the root as /htdocs/ for all, then the website address would be: http://

[PHP-DB] LOAD DATA LOCAL ERROR

Every time I use the command LOAD DATA LOCAL INFILE "C:WINDOWS:Desktop:db.txt" INTO TABLE booktest; I get this error message... ERROR: File 'C:WINDOWS:Desktop:db.txt' not found (Errcode: 2) How can I load my file to the database??? --Will

Re: [PHP-DB] LOAD DATA LOCAL ERROR

I may be not understanding properly without checking your MySQL syntax, but should it not be "C:\WINDOWS\Desktop\db.txt"? Tom At 08:53 10/07/2001 -0500, you wrote: >Every time I use the command > >LOAD DATA LOCAL INFILE "C:WINDOWS:Desktop:db.txt" INTO TABLE booktest; > >I get this error messag

[PHP-DB] Fw: Referential Integrity

- Original Message - From: "Ken Sommers" <[EMAIL PROTECTED]> To: "pak" <[EMAIL PROTECTED]> Sent: Tuesday, July 10, 2001 10:29 PM Subject: Re: Referential Integrity > Ever play .,.Name that Code? > > I can delete those related rows in those 50 tables in about 5 lines.. > but first you go

[PHP-DB] Fw: Referential Integrity

- Original Message - From: "Ken Sommers" <[EMAIL PROTECTED]> To: "pak" <[EMAIL PROTECTED]> Sent: Tuesday, July 10, 2001 10:46 PM Subject: Re: Referential Integrity > I started learning PHP Mysql about 2 weeks ago. > I'm still reading the tutorials. > Hopefuly some experienced programmer

[PHP-DB] cookie problems

can anyone help me with this code? i cant believe it wont work, it seems pretty simple! "; print "$logged_user_name"; ?> brad -- 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 a

Re: [PHP-DB] cookie problems

HI, my guess is is that the cookies will be killed the NEXT time you run this script. Ken - Original Message - From: "Brad Lipovsky" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, July 10, 2001 11:24 PM Subject: [PHP-DB] cookie problems > can anyone help me with this code?

Re: [PHP-DB] PHP4 + interbase = bug?

Hi, What version of php4 you're running and on what OS. I had this problem too but when I switched to php 4.06 on win2000 the interbase dll worked just fine. Dobromir Velev -Original Message- From: Wagner R. Landgraf <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: T

Re: [PHP-DB] losing data from a mysql database field

Hi, did you try to use quotes around the field value or echo ""; Dobromir Velev -Original Message- From: Geoffrey Makstutis <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Tuesday, July 10, 2001 9:03 PM Subject: [PHP-DB] losing data from a mysql database field >H