Re: [PHP-DB] !!!NO!!! IBM DB2 connectction problems !!!

HI! mea culpa... I didn't check it previously but now... I included . /usr/IBMdb2/V7.1/db2profile in /etc/init.d/httpd NOW IT WORKS!!! It was all about environment. THANKS ALL for advices/inspiration!!! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTE

RE: [PHP-DB] Using text files instead of a DB

ah ... apologies i was confused by the 'i want to pay by check' on an otherwise blank page. following the link does indeed give the offers you suggested. shame i'm in the uk ... once again, apologies abound. Steve -Original Message- From: Rick Emery [mailto:[EMAIL PROTECTED]] Sen

[PHP-DB] loading csv file into database located in a local server using phpadmin ! Bug or What!

Using phpadmin, when I try to import a csv file into a database table, I get the following mysql errorcode:2 error which says the following file is not found: c:windowstempphp48.. Appreciate any help... Thanks. Geetha -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

Re: [PHP-DB] mysql data into array

Hello Scott, Tuesday, 13 March 2001, you wrote: SK> I fairly new to php and have a question about mysql and arrays. SK> What I am trying to do is pull multiple rows of data out of a mysql database SK> and I need to use that data as input for another table. I have tried to use SK> mysql_fetch

[PHP-DB] log in script // php-auth_user php_auth-pw

Hi 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? I have a script that adds the info to database, but what I need to do: 1. is if the info is

[PHP-DB] Apache + PHP4

Mario Henrique Cruz Torres wrote: > Hello people, I have an Apache server running with PHP3, yesterday I > installed PHP4, and changed httpd.conf to run php4 scripts, but when I try to > see a php page, my browser asks if I want to download the file. I´m want know > how a httpd.conf file wo

Re: [PHP-DB] Apache + PHP4

Mario: Ensure you have the following written similarly to this and UNCOMMENTED! # AddType allows you to tweak mime.types without actually editing it, or to # make certain files to be certain types. # # For example, the PHP3 module (not part of the Apache distribution) # will typically use: #

Re: [PHP-DB] log in script // php-auth_user php_auth-pw

Well a rather simple solution is: $R_Check=mysql_query("select email from table where email='$email' and password='$password'"); if(mysql_num_rows($R_Check)) { header("Location: log_in.php"); } else { $Error=""; $R_Check=mysql_query("select email from table where email='$email'"); if

Re: [PHP-DB] Variable variables ! - help

I've got a loop which includes the following coming from mySQL if ($art_nr1 != '') { $i++; echo " "; I've now got the following art_nr_1=12456 quant1="" or 1 or so And now comes the bit which doesn't work ! for ($i=1; $i<50; $i++) : $varid = "quant".$i ; if

Re: [PHP-DB] Variable variables ! - help

Hi there: Not sure this'll work but it's some way towards it I would think: (Note all occurances of the variable: '$display_this' //Start off the display item outside the loop $display_this = ""; if ($art_nr1 != '') { $i++; $display_this .= " "; I've no

Re: [PHP-DB] Variable variables ! - help

sorry I don't think I explained that very clearly ! The first loop's on a page which works fine, and it's in a form with article numbers and then an input field for quantites ! It's the next page that's giving me headaches ! The user submitted the form with all article numbers and some with a quan

Re: [PHP-DB] parse error

On Tue, Mar 13, 2001 at 07:56:31PM +0100, paauwe wrote: > what is a parse error? A simple search on dictionary.com came up with this definition for parse: Of fish, to have to remove the bones yourself. "I object to parsing fish", means "I don't want to get a whole fish, but a sliced one is oka

Re: [PHP-DB] Variable variables ! - help

driving me up the bloody wall ! I'm sure it's something simple ! This works fine for ($i=1; $i<50; $i++) : $varid = "quant".$i ; if ($$varid != "") { echo " "; } but the moment I change it to $art_nr_$i it doesn't ??? > sorry I don't think I explained that very clearly ! > The first loop's

[PHP-DB] Re: Interbase INSERTION error?

>>hey all.. >> >>I really don't get why I am getting this error.. Can somebody help me >>out? what does a parse error mean? >>Error: >>Parse error: parse error in /home/httpd/html/test/php-test/CVzenden.php >>on line 35 >> >>CVzenden.php: >> >>$conn=ibase_connect("localhost:/home/httpd/html/test/

Re: [PHP-DB] Re: Interbase INSERTION error?

Technically, he shouldn't have to list the fields he is inserting into if he is inserting into the fields in order. Unless that's some funky Interbase requirement. A parse error is usually a PHP syntactical error. Can you post the whole of line "35" so we can see? :) ---

[PHP-DB] File Optimisation

I have a calendar system that details the appointments for various departments in the company and am having problems with the sheers size of the html docs that are returned. One department insists that they nned to see all the users in one go (approx 110) and the calendars for 3 months. This cau

[PHP-DB] what is connection id?

1. What is connection id? We will see this like "your mysql connection id is 12" when you enter into the mysql client programme. 2. Why will the connection id in mysql increase when you exit the mysql and login again? But I think the connection id should be cleared when user exit mysql. Thank yo

RE: [PHP-DB] File Optimisation

The first thing I would look at ( having had the same issue ) is whats actually in the document. I managed to reduce the size of data delivered by 60% by 2 methods. 1. Ruthless use of css in table formatting. 2. Creating javascript functions for even the smallest inline feature such as mouseover

RE: [PHP-DB] File Optimisation

Hi Steve, if your users have all JavaScript enabled, you could generate the HTML-Doc clientside, using things like document.write or document.writeln. Hope this helps. Greetinx, Mike Michael Rudel - Web-Development, Systemadministration - _

RE: [PHP-DB] what is connection id?

AFAIK the connection id is a used by the server to identify the correct connection. if it reset itself there would be duplicate connections. e.g. user 1 connects and gets connection 1. user 2 connects and gets connection 2. then disconnects. if the connection index was reset user 2 would get c

RE: [PHP-DB] File Optimisation

i've used both already. not so ruthless with the css and there is no java at all in there. just html. the db produces 15 sessions per working week for 100 users for 12 weeks so there is a fair chunk of data there ... -Original Message- From: Mark Newnham [mailto:[EMAIL PROTECTED]] Sent:

[PHP-DB] Text Searches on MySQL

Hi, I'm putting together a db with articles in it. Would it be better to have two tables with the main text of the articles in it linked to a main article table or just chuck it all in together in one table. I want to be able to do a full text search on the articles. Any help please, Cheers,

Re: [PHP-DB] File Optimisation

Steve, look at the output buffering/filtering methods in PHP (ob_) In particular, you can enable the gzip filter to automatically zip your html server side, assuming your user's browsers support auto gzip deflation, which the newer browsers seem to "Steve Brett" <[EMAIL PROTECTED]> w

[PHP-DB] How to connect PHP with Oracle?

I have two machines: the first one runs Red Hat 7.0 with php 4.0.1pl2 (as it came in Red Hat 7.0 installation) and the other one runs Red Hat 7.0 with Oracle 8.1.6. I need to connect PHP with Oracle but when I run something like 'OCILogon(...)' I got a 'Call to undefined function:

RE: [PHP-DB] File Optimisation

I wouldn't know about flushing the buffer. Another approach would be changing to ADO. This being an intranet, i'd assume that you could force users to use IE on windows (or provide a IE specific page but keep the current page for other brwosers). This way you either connect direct to the database

[PHP-DB] Any word about PHP and PROGRESS?

Hi all, Any news about connecting PHP to PROGRESS? I'm using PHP+APACHE+MYSQL and I'm curious. Thanks, == Hector M Banda Voice: (949) 784-3143 Progress Programmer/Analyst Fax: (425) 790-6379

[PHP-DB] Multiple rows returned ?. . .

Hi I have little tiny script like so.. - --- no I know there has to be a more efficient way of returning the $row and $row1 without writing it down like so.. anyone one can throw me a clue? :) Thank Andre -- PHP Database Mailing List (http://www.php.net/)

RE: [PHP-DB] Any word about PHP and PROGRESS?

Hi Hector, You may use OpenLink's ODBC drivers to do this. The drivers are available at http://www.openlinksw.com and a HOWTO on ODBC and PHP is at www.iodbc.org. Best regards, Andrew -- Andrew Hill - OpenLink Software Director Technology Evangelism eBusiness

[PHP-DB] Evaluating T/F.

Hi-- I'm trying to evaluate the following lines to see if "$myrow" is false or true, can you help? - $sql = "SELECT * FROM Employees WHERE ID=$id"; $result = pg_exec($db, $sql) or die(include("../sqlerror.inc")); $myrow = pg_

[PHP-DB] Evaluating T/F (2)

Hi-- Sorry, but I didn't finish my previous e-mail :) >Hi-- >I'm trying to evaluate the following lines to see if "$myrow" is false or true, can you help? - $sql = "SELECT * FROM Employees WHERE ID=$id"; $result = pg_exec($db,

[PHP-DB] Evaluting T/F (3)

HI-- Sorry again...aggg... Hi-- I'm trying to evaluate the following lines to see if "$myrow" is false or true, can you help? - $db .; $sql = "SELECT * FROM Employees WHERE ID=$id"; $result = pg_exec($db, $sql); $myro

[PHP-DB] Javascript and PHP

Morning !!! experts Sorry its lil bit off list question but u r the experts remember ! Is there nething in php similar to javascript's following code ??>>: document.form1.text1.value =>> ? so that i can fetch the value of any textbox into php variable [$var] thx in advance. Viv

[PHP-DB] informix client sdk for linux

Hello Anybody know where i can get hold of this. Informix site at www.informix.com/evaluate..has for every OS other than Linux Thanks Marios -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To c

Re: [PHP-DB] loading csv file into database located in a local server using phpadmin ! Bug or What!

I get this too, but it's a problem thats only recently developed - import from cvs has worked fine previously. I had thought it may be connected with a recent upgrade to a newer version of the server I'm using (Omnihttpd Pro) which I think also came with a newer version of PHP (its now 4.04pl1)..

Re: [PHP-DB] Using text files instead of a DB

Does your ISP have XML and Sabloton support installed for PHP? If so it would be worth considering an XML solution. Alan Hale "David W. Fenton" wrote: > I'm very new to PHP, and don't know where to look to answer this > question. > > Is it possible to use a collection of delimited text files wi

Re: [PHP-DB] Text Searches on MySQL

At 05:05 PM 3/14/2001 +, you wrote: >I'm putting together a db with articles in it. Would it be better to have two >tables with the main text of the articles in it linked to a main article >table or just chuck it all in together in one table. >I want to be able to do a full text search on the

[PHP-DB] PHP how to compare?

Can somebody tell me what the proper statement is for this? I want two variables to match with eachother but this doesn't seems to work. Help please? THNX if ($PASS != $PASSNOG) { echo "password doesn't match! $back"; exit; } Duky -- PHP Database Mailing List (http://www.p

[PHP-DB] PHP and MySQL

Hi all, I have a few questions about PHP and databases : - how do you insert a character string into a database when it is stored in an array ? For example I have the name of a person in an array called "$name" and when I insert it into the field "name" in my table, I get a field with "array

RE: [PHP-DB] PHP how to compare?

Duky, Have you tried to use: if ($PASS == $PASSNOG) { # do whatever. } If you're taking data from a form, you might want to do a trim to remove any trailing spaces if ($PASS == trim($PASSNOG)) { # do whatever } There's also... http://www.php.net/manual/en/function.str

RE: [PHP-DB] PHP and MySQL

Laurent, Show us the code/statements you are using. It is easier to help you that way. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 14, 2001 1:43 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] PHP and MySQL Hi all, I have a few questions

RE: [PHP-DB] PHP how to compare?

I'm assuming these are strings you are comparing, correct? If so, try this: if(strcmp($PASS, $PASSNOG)) { echo "password doesn't match! $back"; exit; } http://www.php.net/manual/en/function.strcmp.php Josh Hoover KnowledgeStorm, Inc. [EMAIL PROTECTED] Searching for a new IT s

Re: [PHP-DB] PHP how to compare?

Ànd what statement for not matching? this maybe? if ($PASS !== $PASSNOG) { # do whatever. } Duky Duky wrote: > > Can somebody tell me what the proper statement is for this? I want two > variables to match with eachother but this doesn't seems to work. Help > please? THNX > >if

RE: [PHP-DB] PHP how to compare?

Duky, Did you check if you have named correctly your variables in your form? Your statement is more than corret. Try "echoing" your variables before making the comparision to verify if they are set. If not probabily you have a spelling problem on the form variables. BR, Fábio Ottolini P.S.:

Re: [PHP-DB] Javascript and PHP

Well, No and Yes. If the form is posted, whichever page that it was posted too will have $HTTP_POST_VARS["text1"] set to whatever was in the textbox. $text1 may also be a global variable, depending on your php.ini settings for register_globals and also variable_order. It took me a while to feel

RE: [PHP-DB] Javascript and PHP

Assume in HTML file is: http://my_site.com/do_form.php3"> Then, in do_form.php3: $text1 refers to the name of the field in the HTML form. This convention applies to all fields in the form, including checkboxes, radio buttons, submit buttons, etc. -Original Message- From: vivek

Re: [PHP-DB] PHP how to compare?

The variables are the right ones... "Fabio Ottolini (EDB)" wrote: > > Duky, > > Did you check if you have named correctly your variables in your form? Your >statement is more than corret. Try "echoing" your variables before making the >comparision to verify if they are set. If not probabily y

Re: [PHP-DB] PHP how to compare?

Hi Duky Try to add this before if statement echo("$PASS$PASSNOG"); it will show you whether your vars are correct and whether there is something in at all! if ($PASS != $PASSNOG) { echo "password doesn't match! $back"; exit; } Good luck Ivo "Duky" <[EMAIL PROTECTED]> w

Re: [PHP-DB] PHP and MySQL

Hi, my exact problem is the following. Here is my form : login : group : password : when I put the data

Re: [PHP-DB] Variable variables ! - help

Seems like you need to try curly braces. ${art_nr}_${i} ""Keith Whyman"" <[EMAIL PROTECTED]> wrote in message 024d01c0ac8f$1a6373c0$0b64a8c0@server">news:024d01c0ac8f$1a6373c0$0b64a8c0@server... > > driving me up the bloody wall ! > I'm sure it's something simple ! > This works fine > > > for ($i

Re: [PHP-DB] PHP how to compare?

At 10:21 PM 3/14/2001 +0100, Ivo Stoykov wrote: >Try to add this before if statement >echo("$PASS$PASSNOG"); A more accurate way to tell this would be to do the following: echo "\"".$PASS."\",\"",$PASSNOG,"\"\n"; This was you will see embedded spaces and carriage returns which will not be

Re: [PHP-DB] Evaluting T/F (3)

Try if($myrow = pg_fetch_array($result,0)) { do whatever } else { or die(include("../sqlerror.inc")); } and it will work accordingly Ivo ""Julio Cuz, Jr."" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > HI-- Sorry again...aggg... > > Hi-- >

Re: [PHP-DB] Multiple rows returned ?. . .

Why don't you try wqith cicle? ""Mrvball008"" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi I have little tiny script like so.. > > - > $dbName = "somedb"; > $dbPass = "somepass"; > $dbUserName = "someuser"; > $host = "localhost"; > $db = mysql_

RE: [PHP-DB] Sure it's simple but.............

I don't understand. What is your question? Robert Zwink -Original Message- From: Keith Whyman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 11:32 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Sure it's simple but. I've got a several links(each with a seperate arti

RE: [PHP-DB] classes and & operator

You are going to need to post more information. Maybe send part of the script that is having the problem. I'm sure there are quite a few people familiar with classes on this list, but unfortunatly your question may not have enough information. Also: You posted this question to the php-db list.

RE: [PHP-DB] SHOW COLUMNS

Use: echo mysql_field_name($result, $i); Like this: Robert Zwink DISCLAIMER This is not my syntax, it is taken from the original poster's message. -Original Message- From: Mike [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 7:31 PM To: [EMAIL PROTECTED] Subject: [PHP-DB]

Re: [PHP-DB] PHP how to compare?

even better to use: echo("\$PASS = $PASS\$PASSNOG = $PASSNOG"); which will show the variable name whether it has anything defined or not. Terry On Wednesday, March 14, 2001, at 03:21 PM, Ivo Stoykov wrote: > Hi Duky > > Try to add this before if statement >echo("$PASS$PASSNOG");

[PHP-DB] Help w/ displaying return vals

Here's my php program, I think $result never gets assigned a value, staying null or whatever. $link = mysql_connect("host"); mysql_select_db("dbname"); $result = mysql_query ("SELECT * FROM table"); $fields = mysql_num_fields ($result); $rows = mysql_num_rows ($result); $table = mysql_field_t

[PHP-DB] Showing source code with phps

On my Linux RH 6.2 computer, when working with Apache, mySQL and PHP, there is no problems showing the source code to my code developing friends. If I rename the php-file to phps it works just well. BUT, when doing the very same thing on my W98 or W2k machines, the source code will not show. T

RE: [PHP-DB] Using text files instead of a DB

This following script might help. It assumes you are reading in a file with the following format: 0;this is line zero 1;this is a line one 2;this is a line two 3;this is a line three 4;this is a line four 5;this is a line five http://www.yoursite.com/index.phtml?method=id&product_id=123 if($met

Re: [PHP-DB] Help w/ displaying return vals

Use or die( mysql_error()) on every mysql function or command you're performing, this will tell you what is going wrong . HTH Jayme. -Mensagem Original- De: <[EMAIL PROTECTED]> Para: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Enviada em: quarta-feira, 14 de março de 2001 19:47 Assun

Re: [PHP-DB] PHP how to compare?

Hmm.. maybe I wasn't clear enough... what I want is to check is WHEN the two passwords aren't the same, then it should echo "password doesn't match!". So when NOT the same, then echo. What to use for the NOT?? should it then be something like this with the exlamationmark? if ($PASS !== $P

Re: [PHP-DB] PHP how to compare?

use just one = sign. So, if ($PASS != $PASSNOG) {... At 01:41 AM 3/15/01 +0100, Duky wrote: >Hmm.. maybe I wasn't clear enough... what I want is to check is WHEN the >two passwords aren't the same, then it should echo "password doesn't >match!". So when NOT the same, then echo. What to use for

[PHP-DB] 2 while loops - 2 tables

I am trying to display info from 2 tables in a search result format. My problem is... how do I get the variables to display together? for example: A user selects a city to search apartments in. $sql = "SELECT * FROM $table_name WHERE apt_city = \"$apt_city\" "; $result = mysql_query($sql, $co

[PHP-DB] What is the life time of mysql connection if I use pconnect()

>From the document, the connection opened by pconnect() will not close after you use. And it will store it and reuse at next time. I would like to ask, it is keep open until I shutdown apache? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For addi

Re: [PHP-DB] 2 while loops - 2 tables

If the tables have a one to many relationship you can use nested while loops: while(1st loop){ // display header - master table while(2nd loop){ // display features - detail table } } HTH Jayme. -Mensagem Original- De: olinux <[EMAIL PROTECTED]> Para: PHP-DB <[EM

[PHP-DB] i want to join

hi there __ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. http://auctions.yahoo.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL P

[PHP-DB] Load file

I'm trying to read a text file into a blob field in a database with the following code: $cvfile=".txt"; $exist = file_exists($cvfile); echo "File exists $exist"; $result1=mysql_query("select * from $TA"); $rows=mysql_num_rows($result1); echo "$rows"; $result=mysql_query("update $TA set P1desc

RE: [PHP-DB] How to connect PHP with Oracle?

Check out : http://www.weberdev.com/index.php3?GoTo=ViewArticle.php3?ArticleID=17 Sincerely berber Visit http://www.weberdev.com Today!!! To see where PHP might take you tomorrow. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 14,

[PHP-DB] SELECT * vs. SELECT field, field, field

A quick question, which executes faster ? Suppose i have a table with 6 fields and I need to use all of the info in the table, SELECT * FROM $table_name WHERE id = \"$id\" or SELECT field1, field2, field3, field4, field5, field6 FROM $table_name WHERE id = \"$id\" I understand that they do t