[PHP-DB] Here is the code...

2001-05-24 Thread Anderson Sone
What´s wrong? I did it, but only 4Kb was inserted in a field... I used field like : NText, Text, Binary... in a Sql Server. See the code : __ UPLOAD Arquivo.: -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-m

[PHP-DB] RE: [PHP-WIN] Uploading Files

2001-05-24 Thread Asendorf, John
I had that same problem. It fixed itself when I changed directories and recreated the directories. I'm not certain if it had to do with the permissions on those folders or what, but that made all the difference. Have you double checked your php.ini file for the upload directory? John -

Re: [PHP-DB] PHP and Access

2001-05-24 Thread Johannes Janson
Hi, > I normally work PHP/MySQL but now I have a customer that is adamant > about keeping their data in an Access DB. you could work around it by using an odbc connection from Access to MySQL. So the administration is still done via Access but actually it is a MySQL DB. If you're interested see

Re: [PHP-DB] Uploading Files

2001-05-24 Thread Terry Romine
I've had problems enough with uploading files that I find the following checkpoints VERY important: 1) directory privileges (you indicate you have those set 777 2) the tag needs: a) enctype = "multipart/form-data" b) method = "post" HTH Terry On Thursday, May 24, 2001, at 12:1

Re: [PHP-DB] TEXTSIZE and TEXTLIMIT

2001-05-24 Thread Anderson Sone
ye... i had already done it "Miles Thompson" <[EMAIL PROTECTED]> escreveu na mensagem [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Haven't the foggiest idea -- but php.ini would be a good place to start, or search the manual for these terms. Miles At 12:32 PM 5/24/01 -0300, Anderson Sone wrote

[PHP-DB] Uploading Files

2001-05-24 Thread Randall Barber
I have a NAGGING file upload problem. Details: Win2k, IIS5, PHP v4.0.4 As I understand this system, PHP uploads all files to a temporary place on disk. From there you can move them anywhere you want to. Well here's the scenario: Users are allowed to upload PRN files. Once uploaded I have a

Re: [PHP-DB] TEXTSIZE and TEXTLIMIT

2001-05-24 Thread Miles Thompson
Haven't the foggiest idea -- but php.ini would be a good place to start, or search the manual for these terms. Miles At 12:32 PM 5/24/01 -0300, Anderson Sone wrote: >Where can i configure it? >The defult value is 4096 bytes (4Kb). > >I´m using php + Sql Server > >Tks. > >Anderson > > > >-- >PHP

[PHP-DB] TEXTSIZE and TEXTLIMIT

2001-05-24 Thread Anderson Sone
Where can i configure it? The defult value is 4096 bytes (4Kb). I´m using php + Sql Server Tks. Anderson -- 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 administrators, e-mail

Re: [PHP-DB] characters - URGENT!!!

2001-05-24 Thread Stig Sæther Bakken
["Selvin Sakal" <[EMAIL PROTECTED]>] > Hi, > i have a mysql database, can anyone tell me any characters that cannot > be entered into mysql (like !@#$%, etc). > > Also i have a string and i would like to remove html tags, characters > (like ~!@#$%^&*()_+|`-=\{}[]:"<>?;',./ ) out of it, so basical

[PHP-DB] order by clause

2001-05-24 Thread luc raymond
I have the following warning message on the client web page when I use an order by in my query. If I remove it, the message dissapear. Warning: SQL error: [Micr

[PHP-DB] order by clause

2001-05-24 Thread luc raymond
I have the following warning message on the client web page when I use an order by in my query. If I remove it, the message dissapear. I have the following code odbc_close_all(); $sql=odbc_connect("informatique","userinfo","userinfopswd"); $statement = odbc_prepare($sql, "select piece_d

RE: [PHP-DB] characters - URGENT!!!

2001-05-24 Thread Steve Brett
i'm sure this is taken car od in the php string handling functions. couldn't you 'clean' them up prior to when you insert them ? steve > -Original Message- > From: Selvin Sakal [mailto:[EMAIL PROTECTED]] > Sent: 24 May 2001 12:44 > To: [EMAIL PROTECTED] > Subject: [PHP-DB] characters -

[PHP-DB] characters - URGENT!!!

2001-05-24 Thread Selvin Sakal
Hi, i have a mysql database, can anyone tell me any characters that cannot be entered into mysql (like !@#$%, etc). Also i have a string and i would like to remove html tags, characters (like ~!@#$%^&*()_+|`-=\{}[]:"<>?;',./ ) out of it, so basically i want the string to be just left with wor

Re: [PHP-DB] Insert File in a Database

2001-05-24 Thread Anderson Sone
Didn´t work... i already changed the "upload_max_file". It isn´t inserting large string in a DB... Only 4Kb! ""Miguel Loureiro"" <[EMAIL PROTECTED]> escreveu na mensagem 006501c0e42c$aa66c650$[EMAIL PROTECTED]">news:006501c0e42c$aa66c650$[EMAIL PROTECTED]... I think that to upload a bigger

RE: [PHP-DB] Am I missing something important here ?

2001-05-24 Thread Mats Remman
Oh my.. seems i didnt see the reference of $queryresult. ignore my comment :) but the first mysql_query is useless. ;Mats > -Original Message- > From: Mats Remman [mailto:[EMAIL PROTECTED]] > Sent: Thursday, May 24, 2001 12:35 PM > To: annabelle.imray; [EMAIL PROTECTED] > Subject: RE:

Re: [PHP-DB] Am I missing something important here ?

2001-05-24 Thread Darren
"annabelle.imray" <[EMAIL PROTECTED]> wrote in message 9ehff1$jda$[EMAIL PROTECTED]">news:9ehff1$jda$[EMAIL PROTECTED]... > I have been given an example of how to use php & mysql from a hosting > company. They have the following function: > > # > function ExecuteQuery ($linkd

RE: [PHP-DB] Am I missing something important here ?

2001-05-24 Thread Mats Remman
Your problem here is simply that the $queryresult gets lost in the function. It is never returned. change return true; into return $queryresult; Mats Remman > -Original Message- > From: annabelle.imray [mailto:[EMAIL PROTECTED]] > Sent: Thursday, May 24, 2001 1:02 AM > To: [EMAIL PR

Re: [PHP-DB] Help With Getting Values Please!

2001-05-24 Thread Russ Michell
mysql_result() is used when you know the row number of the item you want to retrive from your table. mysql_query() is used to get all results from a query, so you can loop thru an array of them or something. Russ On Wed, 23 May 2001 18:47:22 +0200 Johannes Janson <[EMAIL PROTECTED]> wrote:

Re: [PHP-DB] Insert File in a Database

2001-05-24 Thread Miguel Loureiro
I think that to upload a bigger files you must change in php.ini the value referent of upload_max_file. Maybe it solve your problem... Este e' portugues. Felicidades... Good luck, good codeCARPE DIEM   Best Regardsmailto:[EMAIL PROTECTED]t 

RE: [PHP-DB] newbie

2001-05-24 Thread Steve Brett
php needs to be recompiled and add the line --with-pgsql or install mysql. out of the two (i work with postgresql so i am pretty biased) i would def go with postgresql. steve > -Original Message- > From: Chadwick Rolfs [mailto:[EMAIL PROTECTED]] > Sent: 23 May 2001 22:33 > To: [EMAIL PR

[PHP-DB] Re:Cookie Values being Displayed

2001-05-24 Thread Miguel Loureiro
Hello, cookie values are only available after a refresh, its a "cookie thing", you can check that in php tuturials ("Common Pitfalls:   Cookies will not become visible until the next loading of a page that the cookie should be visible for.  

RE: [PHP-DB] User Permissions

2001-05-24 Thread Steve Brett
we use sessions and then include a general script to check they are logged in and then in individual areas use an if ($seclevel == 1) approach. obviously register $seclevel and any other security levels , codes etc. or, depending on the db, have a look at grant and revoke and set permissions at

[PHP-DB] Re:Am I missing something important here ?

2001-05-24 Thread Miguel Loureiro
Hello, in my opinion, could be important make a check to database and the first condition should be that ( if ($mysql_result = mysql_query($query, $linkdb)) {  ) ... its my opinion, because sometimes I use something like that , make certain actions depending data in database (we all do.

Re: [PHP-DB] Limiting # of connections to remote Oracle

2001-05-24 Thread Remigiusz Sokolowski
Stig Sćther Bakken wrote: > > ["Larry Osborn" <[EMAIL PROTECTED]>] > > Greetings all, > > We are having serious issues with PHP4.0.5 using OCI8 and Apache 1.3.17. > > > > We have 4 webservers that handle our various needs for oracle. Each server > > has its MaxSpareServers in the httpd.conf set t

[PHP-DB] headers

2001-05-24 Thread Sharmad Naik
How do I eanble headers in php3.ini file -Thanks -- The secret of the universe is @*&í!'ñ^#+ NO CARRIER ___ _ _ _ |_|_||_||_||\/||_|| \ _|| || || \| || ||_/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail:

Re: [PHP-DB] Insert File in a Database

2001-05-24 Thread Stig Sæther Bakken
["Anderson Sone" <[EMAIL PROTECTED]>] > How can i insert a file in a Database? > I´m using PHP + MSSQL 2k > > I´m trying to insert a .doc file in a db. I read the file and put it in a > db. > I´m having a lot of problem... like: > _ > Warning: MS SQL message: Unclosed quotation mark b

Re: [PHP-DB] Limiting # of connections to remote Oracle

2001-05-24 Thread Stig Sæther Bakken
["Larry Osborn" <[EMAIL PROTECTED]>] > Greetings all, > We are having serious issues with PHP4.0.5 using OCI8 and Apache 1.3.17. > > We have 4 webservers that handle our various needs for oracle. Each server > has its MaxSpareServers in the httpd.conf set to 100. So that turns out to > be 400 con