RE: [PHP-DB] collaborating on a document

2003-02-12 Thread Baumgartner Jeffrey
  1-Since he's posting to a PHP-DB list, I think we can assume he plans
  to implement it in PHP using a database to capture and store the
  comments/ideas. 
 
 Correct, thank you.
 
  Jeff - Do you have a plan in place for your DB schema or the backend
  processing that might take place?
 
 No, I'm still at the thinking stage. Since I'm new to PHP + databases, I
 was hoping to get expert feedback at the earliest stage, rather than
 discovering too late that my idea wasn't the best approach. 
 
 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[PHP-DB] Oracle errors not returning w 4.30

2003-02-12 Thread Steve Farmer
Hi all,

We recently upgraded to php 4.30 and now our oracle errors are not 
returning.. This used to work

$errmsg = ocierror($err_curs);
   ocirollback($err_conn);
   $errtext = $errmsg['message'];

TIA
Steve
--
-
Nearly all men can stand adversity, but if you want to test a man's 
character, give him power.
-Abraham Lincoln, U.S. president (1809-1865)
Support free speech; visit http://www.efa.org.au/

Heads Together Services Pty Ltd http://www.hts.com.au
Email: [EMAIL PROTECTED] Tel: 612 9982 6767 Fax: 612 9981 3081 

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP-DB] Re: Flash/PHP Resources

2003-02-12 Thread Massimo Foti
Bruce Levick [EMAIL PROTECTED] wrote in message
004701c2d1c2$a9424b70$4a2a8aca@viva">news:004701c2d1c2$a9424b70$4a2a8aca@viva...
 Bruce Levick - VivamotionWhere can I find some good resources for
tutorials
 to pass php queries into flash??

http://www.sephiroth.it/tutorials/flashPHP/

Massimo



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[PHP-DB] BinaryWrite in PHP?

2003-02-12 Thread Ohlson Stefan
Hi!
I want to let the user to be able to open or save a textdocument with 
text that I create on the fly with some select-statements. 
You know when you click on a button or a link and you get a question
if you what to Open the file or or Save it.

In ASP I can use Response.BinaryWrite, how can I do it in PHP?

Thanks!

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




RE: [PHP-DB] BinaryWrite in PHP?

2003-02-12 Thread George Pitcher
Stefan,

This works for me.

Some of my users (and me on some PCs) get a message alerting them about an
Active-X component, but if you ignore it, it has no affect,

?php
$fpd = path2file . $fp . .pdf;
$len = filesize($fpd);
header(Content-Type: application/pdf); // change to suit your file type
header(Content-Disposition: inline; filename=$fpd);
header(Content-Title: $fpd);
header(Content-Length: $len);
readfile($fpd);
?

George

 -Original Message-
 From: Ohlson Stefan [mailto:[EMAIL PROTECTED]]
 Sent: 12 February 2003 10:05 am
 To: [EMAIL PROTECTED]
 Subject: [PHP-DB] BinaryWrite in PHP?


 Hi!
 I want to let the user to be able to open or save a textdocument with
 text that I create on the fly with some select-statements.
 You know when you click on a button or a link and you get a question
 if you what to Open the file or or Save it.

 In ASP I can use Response.BinaryWrite, how can I do it in PHP?

 Thanks!

 --
 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] Oracle errors not returning w 4.30

2003-02-12 Thread Thies C. Arntzen
On Wed, Feb 12, 2003 at 07:43:48PM +1100, Steve Farmer wrote:
 Hi all,
 
 We recently upgraded to php 4.30 and now our oracle errors are not 
 returning.. This used to work
 
 $errmsg = ocierror($err_curs);
ocirollback($err_conn);
$errtext = $errmsg['message'];

works for me - could you send a _short_ selfcontained script
that shows your problem?

re,
tc

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[PHP-DB] Post without user hitting submit button

2003-02-12 Thread Alberto Grájeda C.
The problem:
register.php {objetive: Validate users in email server}
register.php has form1 (take email and emailpassword), with this 
information and validating to the user in email server, I search in 
database other information (user_cod, password2), 
this information must be sent to a cgi via post to data.cgi(not php file). 

How can I send a form2 (user_cod, password2), without user hitting submit 
button??. or what method can I use??

I will appreciate any help.

Thanks all.




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




RE: [PHP-DB] Post without user hitting submit button

2003-02-12 Thread Hutchins, Richard
If I understood your question, you can use a JavaScript to take care of the
submission for you. Hitting Submit is a client side action, so you have to
handle it in the browser instead of on the server with PHP. Maybe something
like checking to make sure all fields are valid with an onBlur() script. Of
course, you'd have to force the onBlur() after a certain number of
characters are entered in the second field (kind of like autotabbing) in the
second field.

For example, if you have two fields, username and password for example, when
the user fills in the username field and attempts to leave the field, fire
an onBlur() to check the field. Require the password field to be a certain
number of characters and when that number of chars has been entered, set up
the field to autotab and you should be able to validate that field as well.

I haven't implemented anything like this myself, but it might do the trick.
As far as the autotab stuff, you should be able to find a really simple
script on javascript.com or someplace like that. Make sure you test in IE
and NN though just to make sure the code works both ways.

There may be other more elegant ways of handling it, but this simple
suggestion should do the trick.

Hope this helped.

 -Original Message-
 From: Alberto Grájeda C. [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, February 12, 2003 8:31 AM
 To: [EMAIL PROTECTED]
 Subject: [PHP-DB] Post without user hitting submit button
 
 
 The problem:
 register.php {objetive: Validate users in email server}
 register.php has form1 (take email and emailpassword), with this 
 information and validating to the user in email server, I search in 
 database other information (user_cod, password2), 
 this information must be sent to a cgi via post to 
 data.cgi(not php file). 
 
 How can I send a form2 (user_cod, password2), without user 
 hitting submit 
 button??. or what method can I use??
 
 I will appreciate any help.
 
 Thanks all.
 
 
 
 
 -- 
 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]

2003-02-12 Thread nikos
Hi List!

I'm trying to Drop a Table and aI get an error as follows:
Error on delete of './horceng/oikology.MYI' (Errcode: 13)

Does anybody know what is the error 13?
Thanks


Qbit
  - Gatsis Nikos
Web developer
tel.: 2108256721 - 2108256722
fax: 2108256712
email: [EMAIL PROTECTED]
http://www.qbit.gr 



Re: [PHP-DB]

2003-02-12 Thread Kurth Bemis (List Monkey)
At 03:40 PM 2/12/2003 +0200, nikos wrote:

I bet that google does...

or the search engine at mysql.com does

~kurth



Hi List!

I'm trying to Drop a Table and aI get an error as follows:
Error on delete of './horceng/oikology.MYI' (Errcode: 13)

Does anybody know what is the error 13?
Thanks


Qbit
ÃáôóÞò Íßêïò - Gatsis Nikos
Web developer
tel.: 2108256721 - 2108256722
fax: 2108256712
email: [EMAIL PROTECTED]
http://www.qbit.gr




--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[PHP-DB]

2003-02-12 Thread nikos
Hi List!

I'm trying to Drop a Table and aI get an error as follows:
Error on delete of './horceng/oikology.MYI' (Errcode: 13)

Does anybody know what is the error 13?
Thanks


Qbit
  - Gatsis Nikos
Web developer
tel.: 2108256721 - 2108256722
fax: 2108256712
email: [EMAIL PROTECTED]
http://www.qbit.gr 



Re: [PHP-DB]

2003-02-12 Thread Chris Ruprecht
On Wednesday 12 February 2003 08:40, nikos wrote:
 Hi List!

 I'm trying to Drop a Table and aI get an error as follows:
 Error on delete of './horceng/oikology.MYI' (Errcode: 13)

 Does anybody know what is the error 13?
 Thanks


This is OS dependant, but in general it meand 'Permission Denied'. 

-- Chris


 ---
- Qbit
   - Gatsis Nikos
 Web developer
 tel.: 2108256721 - 2108256722
 fax: 2108256712
 email: [EMAIL PROTECTED]
 http://www.qbit.gr


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




Re: [PHP-DB]

2003-02-12 Thread Adam Voigt




Very first result on google:



http://www.oreillynet.com/cs/user/view/cs_msg/7231



Look at the first reply.

(Next time go to google first.)



On Wed, 2003-02-12 at 08:40, nikos wrote:

Hi List!



I'm trying to Drop a Table and aI get an error as follows:

Error on delete of './horceng/oikology.MYI' (Errcode: 13)



Does anybody know what is the error 13?

Thanks





Qbit

  - Gatsis Nikos

Web developer

tel.: 2108256721 - 2108256722

fax: 2108256712

email: [EMAIL PROTECTED]

http://www.qbit.gr 




-- 
Adam Voigt ([EMAIL PROTECTED])
The Cryptocomm Group
My GPG Key: http://64.238.252.49:8080/adam_at_cryptocomm.asc








signature.asc
Description: This is a digitally signed message part


[PHP-DB] Re: php oops

2003-02-12 Thread David Eisenhart
An extensive article together with a few links is at:
http://www.php-mag.net/itr/online_artikel/show.php3?id=284nodeid=114

David


Rajesh Fowkar [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
 Hello,

 Is there any site which contains some tutors or some details regarding
 OOPS (Object Oriented Programming) using PHP ?

 Thanks in advance.

 Peace

 --
 Rajesh
 :
 [ GNU/Linux One Stanza Tip (LOST) ]###

 Sub : Console boot (debian systems)  LOST #045

 To boot into  console with  xdm/ gdm/ kdm installed, changing
 at /etc/inittab does not help.  Use the [update-rc.d] program
 meant for changing init parameters in Sys-V init process. All
 system startup links for /etc/init.d/xdm will be removed. viz

 #update-rc.d -f xdm remove(or gdm / kdm)

 [EMAIL PROTECTED]###
 :



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[PHP-DB] Red Hat 8 fresh install - postgres and PHP

2003-02-12 Thread Joel Lopez
Hi,

I have been trying to get postgres to work with php on my freshly installed
system.

You can see my info at:
http://134.173.134.141/phpinfo.php

I think it's ready for postgres.  Are there any initial steps that must be
taken to prepare the db?

Thanks,
Joel



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[PHP-DB] crypt help

2003-02-12 Thread Zach Davis
I have a question about the way I'm using the crypt function in a PHP/SQL
gradebook I'm building.

When I add a user to the users table, I also generate a encrypted version
of their password using the following statement:

   // Crypt the password
   $crypt_num = crypt($student_num, $salt);  
   // Crypt the password
   $crypt_pw = crypt($password, $salt);

Then, when the user tries to log on later, they enter their password, and
it gets encrypted in exactly the same way. The encrypted version of the PW
is then compared to the encrypted version stored in a passwords table --
if they match, then the script validates the user and prints out the
user's assignment scores.

However, I've noticed that if anything past the 8th character in the
password is irrelevant. So, if the password was 12345678910, and the
user entered 12345678, the user would be able to enter. In other words,
the encrypted version of 12345678910 would be the same as the encrypted
version of 12345678.

I think there must be something with my crypt statement -- any advice?

Best,
Zach

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




Re: [PHP-DB] crypt help

2003-02-12 Thread Jason Wong
On Thursday 13 February 2003 04:33, Zach Davis wrote:

 However, I've noticed that if anything past the 8th character in the
 password is irrelevant.

That is clearly explained in the manual.

-- 
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design  Hosting * Internet  Intranet Applications Development *
--
Search the list archives before you post
http://marc.theaimsgroup.com/?l=php-db
--
/*
Welcome to Utah.
If you think our liquor laws are funny, you should see our underwear!
*/


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




Re: [PHP-DB] Re: Something is fishy in my selection

2003-02-12 Thread Leo G. Divingracia III


Mathieu Dumoulin wrote:

Oh crap, someone mailed me about having nulls in my field compared...
you can no disregard this thread...its closed i got the culprit, it's a
stupid NULL i found in a column



reminds me of the time i had a query to look for 0 and 0.  i forgot 
some values where 0...   lol...

--
Leo G. Divinagracia III
[EMAIL PROTECTED]

z


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP-DB] RE: collaborating on a document

2003-02-12 Thread Matthew Collins

well, you COULD build the interface in flash with a php backend.  flash
allows for multi-user environments using a socket server, wherein the server
pushes any changes out to all active users.




-Original Message-
From: Baumgartner Jeffrey [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 11, 2003 10:13 AM
To: [EMAIL PROTECTED]
Subject: collaborating on a document


I'm thinking about making a little tool where people can contribute ideas in
real time. Thus far, the best way I can see to do this is via 2 frames

Frame 1: for entering data - which is inserted into a table.

Frame 2: would select from the table.  It would also refresh frequently -
say every 30 seconds.

But perhaps you have a more elegant solution?

Thanks,

Jeffrey Baumgartner

eBusiness Consultant - ITP Europe
http://www.itp-europe.com
[EMAIL PROTECTED]
+32 2 721 51 00



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[PHP-DB] upload again

2003-02-12 Thread Ryan Holowaychuk
I have an upload set up, and now I need to do another one that will go
to an other server.  I can find how I can get the script to login to
another server with a user and pass if needed and then carry on and send
the file.
 
This is what I have for a local one now
 
$copied1 =
/location/on/server/.basename($HTTP_POST_FILES['userfile1']['name']);
 
Is this possible?? That I want it to go to another server?
 
Thanks
Ryan



[PHP-DB] [Import text file]

2003-02-12 Thread RG
Hi

I try to do an import text file into a mysql table with the php 
script provided with Manucorp Easyphp, but it does not work.

The message is :

Erreur 
requête SQL: 

LOAD DATA LOCAL INFILE 'C:\WINDOWS\TEMP\phpC255.TMP'  INTO TABLE 
abonnes FIELDS TERMINATED BY ';' ESCAPED BY '\\' LINES TERMINATED BY 
'\r\n' (dp_indpri,dp_nom,dp_ville)
MySQL a répondu:File 'c:windowstempphpc255.tmp' not found 
(Errcode:2)

The path above seems to be incorrect, but i have not found where to 
modify it.


Environment is :

Apache 1.3.17 win32
PHP 4.0.5-dev
MySQL client API version 3.23.32

An idea ??
RG
[EMAIL PROTECTED]


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[PHP-DB] CDB

2003-02-12 Thread TheGoodTheBadTheUgly
Dear PHP Gurus

Is there anybody who use CDB(Constant Database) with PHP?
Please hint me ,how to install,how to use it and is there any other
better [speedy] way to handle Read Only data than CDB?




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




Re: [PHP-DB] PHP 4.3.0 + MSSQL database authenticationproblem?

2003-02-12 Thread Frank M. Kromann
Hi Alan,

If this is a problem with PHP it's in the Sybase extension. I hvae not
tried working with that since I made it possible to use --with-mssql (and
I'm not the maintainer).

Can you compile the cli version (--disable-cgi
--with-mssql=path/to/freetds ...) and test a small comanndline script
using the mssql_*() functions ? This should work with php 4.3.0, but I
have made a few changes to the code in CVS and I can send you the latest
files if you need them.

This configuration is tested on sevral different Linux configurations and
I use it every day so I know it works :-)

- Frank

 Hi Frank,
 
 --- Frank M. Kromann [EMAIL PROTECTED] wrote:
  This should be ok. --with-tdsver=4.2 sets the
  default.
 
 I figured as much, since I think the default can be
 overridden in the 'freetds.conf' and/or $TDSVER
 environment variable, no?
  Have you tried the tsql tool to see if you can
  connect ?
 
 Yes, and connected was made successfully.  I used the
 name of the connection in 'freetds.conf'.  I was able
 to confirm successful connection earlier by posting
 some logs to the FreeTDS list.
 
 I am starting to to think it is more and more a PHP
 issue.  The only thing I haven't tried yet is
 downgrading the PHP version to that which is on the
 current server (4.1.2; an attempted upgrade to v4.2.3
 just before Xmas resulted ina very similar problem)
 
  If you plan to use stored procedures I would make
 
 Not as far as I know.  Right now, it is only used to
 pull information from tables.
 
 Alan
 
 
 __ 
 Post your free ad now! http://personals.yahoo.ca
 
 -- 
 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] Oracle errors not returning w 4.30

2003-02-12 Thread Steve Farmer
Hey Thies,

Weird problem..  I have just discovered that it is not working on 
only some machines.  does it depend on certain environment variables 
being set either at run time or during compile?

Most likely it can't find the ora_messages I would imagine.

Regards
Steve

At 12:41 PM +0100 12/2/03, Thies C. Arntzen wrote:
On Wed, Feb 12, 2003 at 07:43:48PM +1100, Steve Farmer wrote:

 Hi all,

 We recently upgraded to php 4.30 and now our oracle errors are not
 returning.. This used to work

 $errmsg = ocierror($err_curs);
ocirollback($err_conn);
$errtext = $errmsg['message'];


works for me - could you send a _short_ selfcontained script
that shows your problem?

re,
tc

--
-
Nearly all men can stand adversity, but if you want to test a man's 
character, give him power.
-Abraham Lincoln, U.S. president (1809-1865)
Support free speech; visit http://www.efa.org.au/

Heads Together Services Pty Ltd http://www.hts.com.au
Email: [EMAIL PROTECTED] Tel: 612 9982 6767 Fax: 612 9981 3081 

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP-DB] Full text search of mysql

2003-02-12 Thread Hardik Doshi
Hello,

I want to use mysql's full text search capabilities
with two different tables. Can i join tables using
full text search? I am using mysql 3.23.55

thanks

Hardik

__
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day
http://shopping.yahoo.com

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php