Re: [PHP-DB] Manipulate an image automatically

2006-04-13 Thread Anthony Lee
What is the quickest way to manipulate an image? With ImageMagick from PHP: Lot's of good examples here: http://www.cit.gu.edu.au/~anthony/graphics/imagick/annotating/#watermarking -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] flash/php problem

2006-03-10 Thread Anthony Lee
Actually, I don't see why either method would work: The SWF is in a static HTML page. It requests an mp3, and loads it without having to refresh. So it needs an mp3 returned, not another SWF. Updating the DB from the SWF call sounds cool, but serverside wise requires the .htaccess updated to

Re: [PHP-DB] flash/php problem

2006-03-08 Thread Anthony Lee
query("update hitcounter set plays = plays+1 where file = {$_GET['file']}"); header("Location: play.swf?file={$_GET['file']}"); Sorry I didn't read this thread thoroughly enough. This looks like a good solution to me. You just need to have the swf make the request and return the mp3 to the swf

Re: [PHP-DB] flash/php problem

2006-03-08 Thread Anthony Lee
On second thoughts you probably better off with load variables. Flash: var info:String = "YoMama"; var id:Number = 12; loadVariables("http://myserver.com/my_db_update_page.php?id="+id+"&info="+info+"";, this); PHP [my_db_update_page.php]: The function for checking the result is in the flash ma

Re: [PHP-DB] flash/php problem

2006-03-08 Thread Anthony Lee
how can i update my DB through Flash, using PHP. The easy way... Flash: var info:String = "YoMama"; var id:Number = 12; getURL("http://myserver.com/my_db_update_page.php";, "_self", "GET"); PHP [my_db_update_page.php]: This won't tell you if there has been an error during the update. If you

Re: [PHP-DB] flash/php problem

2006-03-08 Thread Anthony Lee
This question isn't really a PHP-DB thang is it? Anyway, it sounds like you have a lot of swfs on the page. One for each song, is that right? In that case your best bet would be something like what you already have: i.e. push the variable into flash from the page that contains it. If you on

Re: [PHP-DB] Sybase CALL statement problems

2005-03-29 Thread Anthony Robins
mum and maximum values for various lookups and calculations that the CALLed statement does... Anthony Robins Original Message From: [EMAIL PROTECTED] To: php-db@lists.php.net Subject: Re: [PHP-DB] Sybase CALL statement problems Date: Tue, 29 Mar 2005 09:33:53 -0600 >Anthony Robins wrote

[PHP-DB] Sybase CALL statement problems

2005-03-29 Thread Anthony Robins
buffering and send the contents of the buffer to a file before the end of the script, all of the data makes it into the file, but still not to the browser. Trying to free the odbc resource or close the connection results in no output at all. ANY thoughts on this matter would be appreciated. Anthony

[PHP-DB] ODBC Column Name Truncation

2004-09-09 Thread Anthony Robins
When retrieving ODBC results from Sybase SQL Anywhere 6 and 9, the column names are being truncated to 31 characters. -- Result: 1: key - 4 2: a_really_long_name_that_is_long - 5 3: longer_name - 6 I expected #2 to have the name: a_really_long_name_that_is_longer_than_31_characters -- This hap

[PHP-DB] Inserting a large number of rows into mySQL

2003-07-18 Thread Anthony
at is the best way to insert the rows individually, yet still have this ability? The rows will be inserted by looping though an array in PHP. Thanks. - Anthony -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Oracle/PHP question...

2002-12-17 Thread Anthony Carlos
Yes, you need to recompile PHP: ./configure --with-oci8=[your_oracle_home] -Original Message- From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 1:58 PM To: '[EMAIL PROTECTED]' Subject: [PHP-DB] Oracle/PHP question... I am now trying to setup conne

Re: [PHP-DB] upload data to MySql

2002-11-14 Thread Anthony
I actualy store the files dirrectly in the databse in a longblob, it may be better to save the files in a folder (how I most people do it). Feel free to ask any questions you have. The app is in beta right now, it will go on www.supras.com when its done. HTH - Anthony /* add.php -- part o

Re: [PHP-DB] upload data to MySql

2002-11-14 Thread Anthony
I actualy store the files dirrectly in the databse in a longblob, it may be better to save the files in a folder (how I most people do it). Feel free to ask any questions you have. The app is in beta right now, it will go on www.supras.com when its done. HTH - Anthony /* add.php -- part o

Re: [PHP-DB] Multiple Inserts with mySQL

2002-11-14 Thread Anthony
, it doesn't look like mySQL supports this. Am I right here? So far it looks like your idea could be the most reliable suggestions I've gotten, so I'll start working on that for now. Thanks. - Anthony Peter Beckman wrote: Try this: $stack is an array of hashes: $sta

Re: [PHP-DB] Multiple Inserts with mySQL

2002-11-14 Thread Anthony
, it doesn't look like mySQL supports this. Am I right here? So far it looks like your idea could be the most reliable suggestions I've gotten, so I'll start working on that for now. Thanks. - Anthony Peter Beckman wrote: Try this: $stack is an array of hashes: $sta

Re: [PHP-DB] can i create an Access table or mdb with PHP?

2002-11-13 Thread Anthony
are better ideas, but this would work. - Anthony John A Davis wrote: I'm trying to supply our Contract Counties with mailing labels, already formatted. They log on to our website and PHP will hit our SQL Server and return a list of Public Water Systems for the County chosen. I would like a li

Re: [PHP-DB] Oracle problem

2002-10-16 Thread Anthony Carlos
ndByName(':empno', $empno, -1); OCIBindByName(':ename', $ename, -1); OCIExecute($stmt); Check out Thies' presentation: http://conf.php.net/pres/index.php?p=slides%2Foci&id=oci2 If you have questions, let us know. -Anthony > From: "Ford, Mike [LSS]&quo

[PHP-DB] Help MySQL server has gone away

2002-09-30 Thread Anthony
filename='{$_FILES['newfile']['name']}', uploaded=CURDATE(), category1='{$_POST['gen']}', category2='{$_POST['category']}' "; Please help. Thanks. - Anthony -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Need help getting record number off insert

2002-09-11 Thread Anthony
how to read it from an insert, odbc_result doesn't work. Anyone have any clue how I can do this? I'm kinda new to this, so please help me out. I'm running IIS/Win2k, PHP 4.2.1 using ODBC through Connex DataFlex driver 8.7. Thanks in advance for your help. - Anthony -- PHP D

[PHP-DB] Updating a CLOB-- OCI_INVALID_HANDLE

2002-07-15 Thread Anthony Carlos
the amount of data that can be stored in the CLOB using this method? My uploads have been truncated to a little less than 32K. And I thought using a CLOB was supposed to give me access to 4GB... Thanks for any insight! Anthony Carlos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Reset ODBC Results

2002-05-21 Thread Anthony
t the results, but it doesn't work. Please help me out, I'm in a real bind here! Thanks - Anthony [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: Question about ODBC databases

2002-05-21 Thread Anthony
need computer a to be able to query against computer B as if it were a SQL server. As far as I can tell, I can't make an NT server running ODBC respond to remote requests. If I am wrong though, PLEASE let me know. Thanks. - Anthony [EMAIL PROTECTED] Andrew Hill wrote: > Anthony,

[PHP-DB] Reset ODBC Results

2002-05-21 Thread Anthony
t the results, but it doesn't work. Please help me out, I'm in a real bind here! Thanks - Anthony [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Question about ODBC databases

2002-05-21 Thread Anthony
this helps. - Anthony [EMAIL PROTECTED] Gerardo Morales wrote: > I have a little problem. > > I must design a little system in a linux server, this should be in php. > The system must read a MS Access DB in a remote server (Win NT). After > a single process the system must

[PHP-DB] Re: Question about ODBC databases

2002-05-21 Thread Anthony
this helps. - Anthony [EMAIL PROTECTED] Gerardo Morales wrote: > I have a little problem. > > I must design a little system in a linux server, this should be in php. > The system must read a MS Access DB in a remote server (Win NT). After > a single process the system must

[PHP-DB] Re: Question about ODBC databases

2002-05-21 Thread Anthony
this helps. - Anthony [EMAIL PROTECTED] Gerardo Morales wrote: > I have a little problem. > > I must design a little system in a linux server, this should be in php. > The system must read a MS Access DB in a remote server (Win NT). After > a single process the system must

Re: [PHP-DB] Oracle Database procedures

2002-01-25 Thread Anthony Carlos
Sridhar, Sorry, it's available at: http://conf.php.net/pres/index.php?p=slides%2Foci&id=oci2 Good luck! --Anthony > From: Anthony Carlos <[EMAIL PROTECTED]> > Date: Fri, 25 Jan 2002 09:50:26 -0500 > To: <[EMAIL PROTECTED]> > Subject: Re: [PHP-DB] Oracle

Re: [PHP-DB] Oracle Database procedures

2002-01-25 Thread Anthony Carlos
Sridhar, Take a look at this documentation from Thies Arntzen. It's required reading for anyone using Oracle and PHP! I hope it gets you started. If not, ask for more help! Good luck, Anthony Carlos PS: It shows how to bind PHP variables to Oracle variables... > From: Sridhar

Re: [PHP-DB] Oracle client on linux

2002-01-25 Thread Anthony Carlos
There's a bunch of requirements that have to be met in order for the software installer to work. In case you're installing onto a remote machine, do you have XWindows running on your Linux machine? Does your terminal program support XWindows? > From: "aiQa" <[EMAIL PROTECTED]> > Date: Fri, 25 Jan

Re: [PHP-DB] Getting Oracle to work

2001-12-18 Thread Anthony Carlos
Chuck, Did you compile PHP with Oracle support? Also, make sure that you compiled the correct oracle functions. The function you quote is part of the older oracle functions. There are newer OCI8 functions available. -Anthony Carlos > From: Chuck Lidderdale <[EMAIL PROTECTED]> > D

Re: [PHP-DB] Re: Unable to Open ORACLE

2001-12-03 Thread Anthony Carlos
#146661 I suggest using this with stored procedures and bind variables. php.net has more info on using stored procedures bind variables. Good luck, Anthony Carlos > From: John Kolvereid <[EMAIL PROTECTED]> > Date: Mon, 03 Dec 2001 22:17:44 -0800 > To: [EMAIL PROTECTED], John Ko

Re: [PHP-DB] ORA-24365

2001-11-19 Thread Anthony Carlos
This might help... 24365, 0, "error in character conversion" // *Cause: This usually occurs during conversion of a multibyte // character data when the source data is abnormally terminated // in the middle of a multibyte character. // *Action: Make sure that all multibyte c

[PHP-DB] PHP Getting Variables from String

2001-10-29 Thread Anthony C. Yandell
I need help. Say I have a string coming from a page via a form $search_var. I need it split up into multiple variables... e.g $string="These are some words" I want it to turn into $var1=These, $var2=are, $var3=some, $var4=some I'm doing this for a search script. Want it to take the i

Re: [PHP-DB] problems with php and oracle ....

2001-10-26 Thread Anthony Carlos
o see ORACLE_HOME? 4. There is also some stuff about defining a php variable with the connect information from tnsnames.ora. I've never actually had to use this method; the above troubleshooting steps always took care of things for me. Good luck, Anthony Carlos > From: Rao Davide <[EMAIL PR

Re: [PHP-DB] help connecting to ODBC

2001-10-19 Thread Anthony
yes, I can use the source from other programs. The source is a System DSN, based on a file DSN for the driver. The I_USR_ user has the correct access rights to the files being accessed and to the file DSN driver. Andrew Hill wrote: > Anthony, > > Is the DSN usable from

[PHP-DB] help connecting to ODBC

2001-10-19 Thread Anthony
nnect to the data source I get "SQL error: , SQL state S1000 in SQLConnect". What does this mean? does anyone know where I can get a list of SQL errors and their meaning? Thanks to anyone that can lend their thoughts. - Anthony -- PHP Database Mailing List (http://www.php.net/) To

Re: [PHP-DB] php and Oracle database

2001-09-27 Thread Anthony Carlos
Georgina: Based on your 2 enclosures, it appears that you have an html file called search1.html. When the user hits the submit button, it calls search1.php4. My question, therefore, is do you have output from search1.php4? Do you see any error messages? Thanks, Anthony Carlos > From: GEORG

Re: [PHP-DB] USA Attacks

2001-09-11 Thread Anthony Carlos
Hello, Steve. Thank you for your sentiments. As an American who drives past the Pentagon everyday to work, it means a lot. Anthony Carlos > From: Steve Farmer <[EMAIL PROTECTED]> > Date: Wed, 12 Sep 2001 12:28:28 +1000 > To: [EMAIL PROTECTED] > Subject: [PHP-DB] USA Attack

Re: [PHP-DB] creating an Oracle variable...

2001-09-10 Thread Anthony Carlos
quot;; OCIExecute($stmt, OCI_DEFAULT); Please let me know if this makes sense, Anthony Carlos > From: [EMAIL PROTECTED] > Date: Mon, 10 Sep 2001 11:10:04 -0800 > To: [EMAIL PROTECTED] > Subject: [PHP-DB] creating an Oracle variable... > > Hi, > > I creat the variable

Re: [PHP-DB] [PHP-ORACLE] a lot of errors!!!

2001-08-24 Thread Anthony Carlos
Can you show us your OCIConnect statement? It returns a handle to a variable that you should use as your connection resource... > From: "Matteo" <[EMAIL PROTECTED]> > Date: Fri, 24 Aug 2001 10:03:46 +0200 > To: [EMAIL PROTECTED] > Subject: [PHP-DB] [PHP-ORACLE] a lot of errors!!! > > I have a s

RE: [PHP-DB] oracle (oci8) intro

2001-08-21 Thread Anthony Carlos
ynamic SQL in PL/SQL (which is even less arbitrary, I believe, than the code I wrote below), but what would happen if you built a PL/SQL table or array and bound that to a PHP variable? Have you ever tried this? It's nice to see someone with a lot of Oracle experience-- sometimes I think that th

RE: [PHP-DB] Photo Album Schema

2001-08-21 Thread Anthony Carlos
I vote for one directory to simplify the programming side of things. What do you guys recommend for the filename convention? Would you let users determine it or would you force them into something like a primary key? Anthony Carlos -Original Message- From: Rick Emery [mailto:[EMAIL

RE: [PHP-DB] oracle (oci8) intro

2001-08-20 Thread Anthony Carlos
anatory SELECT linenum, $field_list FROM (SELECT rownum AS linenum, $field_list FROM (SELECT $field_list FROM $table WHERE $where_clause ORDER BY $order_by)) WHERE linenum BETWEEN $min AND $max; I hope it helps, Anthony Carlos -O

RE: [PHP-DB] Oracle CLOBs and carriage returns

2001-08-09 Thread Anthony Carlos
Tom: I suspect that your problem is with the HTML, not the CLOB itself. Have you tried echoing $lob_data in between tags or using the nl2br function in PHP? It converts nl's to tags. Hope it helps, Anthony -Original Message- From: Tom Tsongas [mailto:[EMAIL PROTECTED]]

Re: [PHP-DB] long or LOBs in oracle ???

2001-08-01 Thread Anthony Carlos
ee). Good luck, Anthony > From: "Andreas Eckhoff" <[EMAIL PROTECTED]> > Date: Tue, 31 Jul 2001 15:09:52 +0200 > To: <[EMAIL PROTECTED]> > Subject: [PHP-DB] long or LOBs in oracle ??? > > Hi everybody, > > I have a little question. What is the best dataty

RE: [PHP-DB] Oracle Client Libraries?

2001-07-11 Thread Anthony Carlos
to call up Oracle for current pricing. Anthony Carlos -Original Message- From: Tom Tsongas [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 11, 2001 12:56 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Oracle Client Libraries? Hi all. Where can I get the Oracle client libraries for PHP4? I

Re: [PHP-DB] problems connecting to remote oracle database

2001-07-02 Thread Anthony Carlos
Phil, Perhaps I'm being nit-picky, but shouldn't it be OCILogon("$user", "$PASSWORD", "$connect_string"); ? Anthony > From: [EMAIL PROTECTED] > Date: Sat, 30 Jun 2001 09:39:11 -0700 > To: [EMAIL PROTECTED] > Subject: [PHP-DB] problem

RE: [PHP-DB] Oracle Client to connect to remote DB

2001-06-29 Thread Anthony Carlos
ver an ssh connection that forwards X-Windows packets. Therefore, I was able to use it remotely via an X-Windows terminal on my PC. Anthony -Original Message- From: Mindblender [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 27, 2001 10:58 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Ora

RE: [PHP-DB] error ORA-12699

2001-06-29 Thread Anthony Carlos
to resolve it into a protocol, address, and sid. In other words, ORCL is shorthand notation for all of the TCP/IP info and then some. I hope this makes sense, Anthony -Original Message- From: sang [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 27, 2001 9:32 AM To: [EMAIL PROTECTED] Subject: Re

Re: [PHP-DB] error ORA-12699

2001-06-27 Thread Anthony Carlos
d have a corresponding entry in your listern.ora file on your server. I suspect that your client machine is trying to access an Oracle database on itself, because no connect string was specified. Lemme know if this helps, Anthony > From: "sang" <[EMAIL PROTECTED]> > Date: W

RE: [PHP-DB] Oracle Client to connect to remote DB

2001-06-26 Thread Anthony Carlos
from technet.oracle.com. I have no idea how much it costs by itself. Anthony -Original Message- From: Mindblender [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 26, 2001 12:35 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Oracle Client to connect to remote DB I read a post on faqt.com that

RE: [PHP-DB] Oracle and PHP

2001-06-26 Thread Anthony Carlos
e the installation manual , and if you don't understand what they say, ask a more specific question. I'll be happy to help translate whatever I can. Anthony -Original Message- From: TathitSA [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 26, 2001 1:47 AM To: PHP General; PHP DB S