Re: [PHP-DB] PDF Implementation

2003-07-17 Thread Pierre-Alain Joye
On Thu, 17 Jul 2003 09:01:53 -0500 [EMAIL PROTECTED] wrote: > > > Good Morning All , > > Has anyone successfully implemented PDF functionality within their PHP > / MySQL projects? My needs are very basic, so I'd like to use > something like ezPDF creation to avoid buying a license. But I haven

Re: [PHP-DB] Page Use

2003-06-23 Thread Pierre-Alain Joye
On Mon, 23 Jun 2003 10:33:59 -0300 Tim Winters <[EMAIL PROTECTED]> wrote: > Interesting Pierre, > > Is this something you have ever used? I have tested it for a few weeks ago (and starting to translate the doc to fr ;). I use it in a current project. However be sure this is really something good

Re: [PHP-DB] Page Use

2003-06-23 Thread Pierre-Alain Joye
Hello, something really good: http://www.phpopentracker.de/ hth pierre -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] MySQL editor

2003-06-19 Thread Pierre-Alain Joye
Hello, Not really the same purpose, but so powerfull :) http://www.fabforce.net/dbdesigner4/ pierre -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] PHP Paging

2003-06-12 Thread Pierre-Alain Joye
On Thu, 12 Jun 2003 16:45:00 -0500 "Sallee, Helen" <[EMAIL PROTECTED]> wrote: > If you are on UNIX, you could just use a cgi script and use sendmail > command. paging datas (Page 1 fo 3 << 1 2 3 >>), not send a msg to a pager :) pierre -- PHP Database Mailing List (http://www.php.net/) To unsu

Re: [PHP-DB] PHP Paging

2003-06-12 Thread Pierre-Alain Joye
On 12 Jun 2003 16:01:01 -0500 Cory Hicks <[EMAIL PROTECTED]> wrote: > FAW, > > I would look at PEAR and then run, don't walkand get the > DB_Pager > > It smokes anything else I have tried... little tutorial on: http://www.pearfr.org/index.php/en/article/db_pager hth pierre -- P

Re: [PHP-DB] efficient next/prev page generation

2003-02-14 Thread Pierre-Alain Joye
Hello, See http://www.pearfr.org/docs/dbpager.php?lang=en, a tutorial about PEAR::DB_Pager, which paging datas, from a DB result or a simple array. It can help you to find a good method. hth pierre -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/uns

Re: [PHP-DB] Re: Images-weird!!

2003-02-02 Thread Pierre-Alain Joye
On Sun, 02 Feb 2003 15:29:44 -0800 (PST) Mihail Bota <[EMAIL PROTECTED]> wrote: > Yeah, I had the idea with truecolor, but I do not have GD2 installed. > I have to install it, first. > Still, I do not understand! I only have 13 colors, why is allocating > only 255? I am not using the indexes in th

Re: [PHP-DB] Re: Images-weird!!

2003-02-02 Thread Pierre-Alain Joye
On Sun, 02 Feb 2003 14:36:38 -0800 (PST) Mihail Bota <[EMAIL PROTECTED]> wrote: > No, this is not the problem. $i and $j start from 0, anyway. The real > problem, as I see it, is the following: > I have a big loop, to create something like a checkerboard, but with > 13 or so colors. If the loop it

Re: [PHP-DB] Re: Images-weird!!

2003-02-02 Thread Pierre-Alain Joye
On Sun, 02 Feb 2003 14:36:38 -0800 (PST) Mihail Bota <[EMAIL PROTECTED]> wrote: > No, this is not the problem. I did not test your code but a color channel start at 0 and finished at 255, corresponding to 256 possibilities. pierre -- PHP Database Mailing List (http://www.php.net/) To unsubscri

Re: [PHP-DB] Concatenate two strings

2003-01-15 Thread Pierre-Alain Joye
On Wed, 15 Jan 2003 14:47:59 - "Bruno Pereira" <[EMAIL PROTECTED]> wrote: > How can i join two strings. > My code is something like: > $valor1="bruno"; > $valor2="Pereira"; > $valor=$valor1 + " " + $valor2 $valor=$valor1 . " " . $valor2; See http://www.php.net/manual/pt_BR/language.operato

Re: [PHP-DB] php oop books

2003-01-12 Thread Pierre-Alain Joye
On Sun, 12 Jan 2003 14:58:36 -0500 "Michael Scappa" <[EMAIL PROTECTED]> wrote: > I know this is a bit off topic, can anyone recommend a good php / oop > book? I've been through php.net's library and nothing really on there. > Thanks I do Not a good book about OO&php, but a good site: http://www.

Re: [PHP-DB] Warning message

2002-11-07 Thread Pierre-Alain Joye
On Thu, 7 Nov 2002 13:37:49 -0500 "Anderson, Jerrad" <[EMAIL PROTECTED]> wrote: > I'm using PHP on apache that's sitting on a Windows 2k server. When I > don't define a variable i'm getting a warning message on the screen.. > anyway to suppress these errors? > > > Warning: Undefined variable: ya

Re: [PHP-DB] Variable won't be passed from HTTP address bar

2002-10-18 Thread Pierre-Alain Joye
On Fri, 18 Oct 2002 13:26:20 +0200 "Michel Bakkenes - bakkenes.net" <[EMAIL PROTECTED]> wrote: > Ok.. I'm not a newbie I thought.. I do have experience with PHP, but I > never suffered from this error. > > I used on my own redhat 8.0 server the following test-script: > > if($action=="test"){ e

Re: [PHP-DB] Getting POSTed values

2002-10-04 Thread Pierre-Alain Joye
On Fri, 04 Oct 2002 20:13:57 -0700 Shoulder to Shoulder Farm <[EMAIL PROTECTED]> wrote: > Hi all, > Sorry, but I REALLY don't want to subscribe to the PHP general list, > it's so high volume, so here goes. --T > > How can I get values that were posted from a form to a PHP document > turned int

Re: [PHP-DB] Register Globals Question

2002-09-30 Thread Pierre-Alain Joye
On Mon, 30 Sep 2002 18:41:13 -0400 "MET" <[EMAIL PROTECTED]> wrote: > It is deprecated as it creates a massive security hole. For bad and horrible codes, php itself never got security holes with that :-). pa -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.

Re: [PHP-DB] Valid IP

2002-09-26 Thread Pierre-Alain Joye
On Thu, 26 Sep 2002 11:39:40 -0500 "Wilmar Perez" <[EMAIL PROTECTED]> wrote: > Hello guys > > I know this should be asked in another list but don't want to subcribe just > for a simple question. I apologise in advance if that bothers anyone. > > I'm trying to check valid IPs that come from a

Re: [PHP-DB] Need help urgent!!

2002-09-26 Thread Pierre-Alain Joye
On Thu, 26 Sep 2002 19:48:31 +0300 "Thomas \"omega\" Henning" <[EMAIL PROTECTED]> wrote: > I'm using PHP4.2.2 Win with MySQL 3.2.52 Win and PHP doesn't pass vars from > 1 php to the other how i fix it? Read the documentation, register_globals is SET to off by default. http://www.php.net/manual/e

Re: [PHP-DB] Using a variable as a variable name

2002-09-04 Thread Pierre-Alain Joye
hello, You can find syntax description in the documentation (variable variables section) $myvar1 = "MYVAR1 CONTENT"; $myvar2 = "MYVAR2 CONTENT"; $i = 0; $myvar = 'myvar'.++$i; echo "\n"; echo $$myvar; echo "\n"; $myvar = 'myvar'.++$i; echo "\n"; echo $$myvar; echo "\n"; can do it hth pa

Re: [PHP-DB] Indepth Tutorial... need help.

2002-09-03 Thread Pierre-Alain Joye
On Tue, 03 Sep 2002 08:56:43 -0400 Matt Zur <[EMAIL PROTECTED]> wrote: > Can someone point me in the direction of an online tutorial for php > mysql that covers the following: http://www.phpbuilder.com http://www.devshed.com http://www.devarticles.com Well, if you do not find something here :-

Re: [PHP-DB] form variables not beeing passed to next page

2002-08-30 Thread Pierre-Alain Joye
On Fri, 30 Aug 2002 12:09:22 +0200 "simon" <[EMAIL PROTECTED]> wrote: > Worked fine in 4.06? > > Have I missed something? REGISTER_GLOBAL is set to OFF from 4.2.x, code should be: if(isset($_POST['sumbit'])) pa -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http:/

Re: [PHP-DB] how to display tree structure from database???

2002-08-28 Thread Pierre-Alain Joye
On Wed, 28 Aug 2002 18:02:09 -0700 "leo g. divinagracia iii" <[EMAIL PROTECTED]> wrote: > and you have a 90-98% accurate translation. handy site to keep around... My kind of 'bible' ;-). Seriously think to buy his book :) pa -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

Re: [PHP-DB] how to display tree structure from database???

2002-08-27 Thread Pierre-Alain Joye
Hello, http://membres.lycos.fr/sqlpro/Tree/SQL_tree.htm provides a good way to store trees in a DB, docs are in french, nut sql&images are universal. hth pa -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] form validation question - regex not working

2002-08-21 Thread Pierre-Alain Joye
On Thu, 22 Aug 2002 03:10:02 +0800 Jason Wong <[EMAIL PROTECTED]> wrote: > On Thursday 22 August 2002 02:54, [EMAIL PROTECTED] wrote: > As you can see, the list address ([EMAIL PROTECTED]), and my address > ([EMAIL PROTECTED]) would be treated as invalid. Not very clever is it? Well, anyway t

Re: [PHP-DB] Fw: Date Add

2002-08-04 Thread Pierre-Alain Joye
On Sun, 4 Aug 2002 17:42:17 +0200 Pierre-Alain Joye <[EMAIL PROTECTED]> wrote: > On Sun, 4 Aug 2002 17:30:31 +0200 > "John Fishworld" <[EMAIL PROTECTED]> wrote: > For a specific day, here the current day WHERE DAYOFMONTH(t_event_date)=DAYOFMONTH(NOW()) AND MONTH

Re: [PHP-DB] Fw: Date Add

2002-08-04 Thread Pierre-Alain Joye
On Sun, 4 Aug 2002 17:30:31 +0200 "John Fishworld" <[EMAIL PROTECTED]> wrote: Why not simply does the where clause like : for a whole month, here is july: WHERE YEAR(t_event_date)='2002' AND MONTH(t_event_date)='7' For a specific day, here the current day WHERE t_event_date=NOW() That means yo

Re: [PHP-DB] fiscal week??

2002-07-31 Thread Pierre-Alain Joye
On Wed, 31 Jul 2002 21:19:00 +0800 Jason Wong <[EMAIL PROTECTED]> wrote: > On Wednesday 31 July 2002 20:56, Dib, Walid (MED, Stagiaire GEMS) wrote: > > How can i print the fiscal week number on a web page?? > > 1) Work out an algorithm to calculate the fiscal week > 2) Implement algorithm in php

Re: [PHP-DB] Re: PicoSQL!

2002-07-24 Thread Pierre-Alain Joye
On Thu, 25 Jul 2002 09:27:04 +0200 "Pentothal" <[EMAIL PROTECTED]> wrote: > > Last but not least: it distributed under GPL ! AFAIK, that may causes problems. We cannot link GPL with non GPLized codes. pa -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.

Re: [PHP-DB] DAO implementations

2002-07-17 Thread Pierre-Alain Joye
Update your vacation message, we are the 17th :) pa -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] DAO implementations

2002-07-17 Thread Pierre-Alain Joye
On Wed, 17 Jul 2002 10:06:11 +0200 Ulf Wendel <[EMAIL PROTECTED]> wrote: > Hi, > > are there some DAO pattern implementations available for PHP to query > MySQL, Postgres and/or DB2? Which one do you preferr? > What mean DAO ? It can be confused (dao, ado, ...). Did you try PEAR::DB_DataObj

Re: [PHP-DB] blob versus file

2002-07-02 Thread Pierre-Alain Joye
On Tue, 02 Jul 2002 12:57:56 +0200 Michael Bretterklieber <[EMAIL PROTECTED]> wrote: > Hi, > > one point that you should keeped in mind is, if you have a cluster of > webservers connecting to the same db-server, then you have to mount the > filesystems, where you store the images on all webser

Re: [PHP-DB] blob versus file

2002-07-02 Thread Pierre-Alain Joye
On Tue, 2 Jul 2002 05:45:40 +0200 "Andy" <[EMAIL PROTECTED]> wrote: > is the increase of the network traffic noticable? The query is pretty small > just text. Do u really think this might increase the traffic? Try to heavely charge a DB with images inside it. Do the same without DB, that depends

Re: [PHP-DB] Re: Unified DB Query function

2002-07-01 Thread Pierre-Alain Joye
On Mon, 01 Jul 2002 14:55:01 -0300 Manuel Lemos <[EMAIL PROTECTED]> wrote: > Hello, > > On 07/01/2002 06:46 AM, Casey Allen Shobe wrote: > > I'm trying to write a unified database query function for an application I > > have which currently accesses data from both DB2 and Microsoft SQL from a

Re: [PHP-DB] blob versus file

2002-07-01 Thread Pierre-Alain Joye
On Mon, 1 Jul 2002 14:17:53 +0200 "andy" <[EMAIL PROTECTED]> wrote: > Hi there, > > I am wondering if anybody has experiance in saving images to blob in mysql. > > I do save images with 1 K and 4 KB to blob fields while I used to save them > to file. It seams to me that this is much slower acce

Re: [PHP-DB] OSCON: anybody interested in my Oracle talk?

2002-06-26 Thread Pierre-Alain Joye
Hello, I m sure I will not be in OSCON, but if there is a possibily for you to go to International PHP Conf, you will make certainly a very good session there, not lost your job and certainly see me ;)). International PHP Conference 2002 call for papers : http://www.phpconference.de/2002/kt/i

Re: [PHP-DB] Why do these values not match?

2002-06-26 Thread Pierre-Alain Joye
On Wed, 26 Jun 2002 06:52:14 -0700 (PDT) Manuel <[EMAIL PROTECTED]> wrote: > Any idea why this problem does not manifest itself in Foxpro, Excel or Visual Basic? This problem happens also with VB. But later :), By example if you use decimal type, smallest non-zero number is +/-0.

Re: [PHP-DB] PHPed and DBG

2002-06-26 Thread Pierre-Alain Joye
On Wed, 26 Jun 2002 10:41:26 +0200 "Dib, Walid (MED, Stagiaire GEMS)" <[EMAIL PROTECTED]> wrote: > > > > Hello, > > I downloaded the application PHPEd and DBG, I need débugger but I cannot > bind the two applications is what somebody has an idea. Thank you in > advance the link to the

Re: [PHP-DB] Form not working...

2002-06-26 Thread Pierre-Alain Joye
On Wed, 26 Jun 2002 19:11:46 +1000 Adam Royle <[EMAIL PROTECTED]> wrote: > What you said (Mike) is mostly correct, although the GetSQLValueString() > function in Scott's code automatically puts the quotes around the values > if the datatype definition of "text" is passed to the function. > > A

Re: [PHP-DB] PHPed and DBG

2002-06-26 Thread Pierre-Alain Joye
On Wed, 26 Jun 2002 10:41:26 +0200 "Dib, Walid (MED, Stagiaire GEMS)" <[EMAIL PROTECTED]> wrote: > > > > Hello, > > I downloaded the application PHPEd and DBG, I need débugger but I cannot > bind the two applications is what somebody has an idea. Thank you in > advance I did not use DB

Re: [PHP-DB] Differences between two mySQL Databases

2002-06-25 Thread Pierre-Alain Joye
On Tue, 25 Jun 2002 14:29:08 -0700 "Michael Robbins" <[EMAIL PROTECTED]> wrote: > I'm looking for a utility that can compare two database structures and > generate a SQL statement that will duplicate the differences. > > I'm using mySQL and I have both live and development databases. While > w

Re: [PHP-DB] foreach

2002-06-03 Thread Pierre-Alain Joye
On Mon, 3 Jun 2002 12:48:47 -0400 "James Kupernik" <[EMAIL PROTECTED]> wrote: > > and I'm getting this: > Warning: Invalid argument supplied for foreach() > > Why is that? are you sure $cart is an array ? pa -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www

RE: [PHP-DB] Date problem

2002-05-12 Thread Pierre-Alain Joye
> i get $postdate from my mysql database,the problem is that i want > to increase that date by 6 months?? > its stored in mysql as date field http://www.mysql.com/doc/D/a/Date_and_time_functions.html check DATE_ADD :) hth pa -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

Re: [PHP-DB] Which "select " is fast,thanks....... ?

2002-03-16 Thread Pierre-Alain Joye
On Sat, 16 Mar 2002 23:03:48 +0800 ±i®p»Ê <[EMAIL PROTECTED]> wrote: > Hi,all friends: > > Would you please tell me which script in MySQL is fast? > - > 1. select count(*) from bk_data Never use * > 2. select count(book_name) from bk_dat

Re: [PHP-DB] a Count() ?

2002-03-16 Thread Pierre-Alain Joye
On Sat, 16 Mar 2002 11:50:11 - "DL Neil" <[EMAIL PROTECTED]> wrote: > Hi Dave, > SELECT * FROM tblNm; > SELECT * FROM tblNm GROUP BY Catid1; > SELECT Catid1, count(*) FROM tblNm GROUP BY Catid1; > > As I said 'follow your instincts' and take it one step at a time: Code > the simplest quer

Re: [PHP-DB] a Count() ?

2002-03-16 Thread Pierre-Alain Joye
On Sat, 16 Mar 2002 10:46:38 - "Dave Carrera" <[EMAIL PROTECTED]> wrote: > Hi All > > I am trying to count how many product names in my db have the same > category id and then show it ie: > > Catid 1 Product 1 > Catid 1 Product 2 > Catid 2 Product 3 > Catid 3 Product 4 > Catid 3 Product 5

Re: [PHP-DB] Checkboxes, PHP, and MySQL

2001-12-20 Thread Pierre-Alain Joye
Only one link should solve your problem :) http://www.w3.org/TR/html401/interact/forms.html#h-17.4 HTH pa -- Pierre-Alain Joye Freelance Developpements et Services web/intranet [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED

Re: [PHP-DB] :: Alternating Rows :: Script With More Explaining ::

2001-12-07 Thread Pierre-Alain Joye
echo "".$email."\n"; > echo "\n"; > > $i++; > } > } $aBgColors = array("#99","#FF"); while(whateveryouwant){ $i = $iCpt++ % 2; echo "\n"; } or more generall

Re: [PHP-DB] Re: [PEAR-DEV] Re: Common DB Abstraction Layer: Re: [PEAR-DEV] Adoption of Metabase

2001-11-21 Thread Pierre-Alain Joye
> I probably used a bad choice of words. What I really meant was: What is > the objective of PEAR::DB as a database abstraction library ? To abstract > as much as possible like Metabase already does, or to provide a unified > API to databases and leave the implementation related to database specif

Re: [PHP-DB] Re: Common DB Abstraction Layer: Re: [PEAR-DEV] Adoption of Metabase

2001-11-21 Thread Pierre-Alain Joye
On Wed, 21 Nov 2001 16:14:04 +0100 (MET) Luc Saint-Elie <[EMAIL PROTECTED]> wrote: > En réponse à Pierre-Alain Joye <[EMAIL PROTECTED]>: > > > > This definition defines more a common interface to connect to a db, > > execute queries, fetch the result an

[PHP-DB] Re: [PEAR-DEV] Re: Common DB Abstraction Layer: Re: [PEAR-DEV] Adoption of Metabase

2001-11-21 Thread Pierre-Alain Joye
> Well I strongly need thoses $15 000 $ so > > What is the purpose ? > As a "average php user/developper" I don_t really care about the "pure cross > plateform/database issue" but I do care about a standard, clean, secure ("my- > bugs-free") and easy way to use a database, and PEAR::BD + T

Re: [PHP-DB] Re: [PEAR-DEV] Re: Common DB Abstraction Layer: Re: [PEAR-DEV] Adoption of Metabase

2001-11-21 Thread Pierre-Alain Joye
On Wed, 21 Nov 2001 09:19:44 -0500 (EST) Joao Prado Maia <[EMAIL PROTECTED]> wrote: > > On Wed, 21 Nov 2001, Manuel Lemos wrote: > > > > If we fixed these problems and more, we could talk about having > > > a unified API. Otherwise for the Oracle OCI_ASSOC, I would prefer > > > not to change it

Re: [PHP-DB] About Berkeley DB2 Databases

2001-11-14 Thread Pierre-Alain Joye
On Wed, 14 Nov 2001 16:56:47 -0400 (VET) Ricardo Núñez <[EMAIL PROTECTED]> wrote: > Mensaje citado por: Pierre-Alain Joye <[EMAIL PROTECTED]>: > > > > I just put '--with-db2'. I suppose it compiled its Berkeley db2 code. > > Other thing, I use

Re: [PHP-DB] About Berkeley DB2 Databases

2001-11-14 Thread Pierre-Alain Joye
> I just put '--with-db2'. I suppose it compiled its Berkeley db2 code. Other thing, I >use PHP 4.0.6. > me too ;) but php not... every others tools on my station recognizes the db,db2 and db3 support, php not. Which lib do you have ? any link ? (or email :) pa -- PHP Database Mailing List

Re: [PHP-DB] About Berkeley DB2 Databases

2001-11-14 Thread Pierre-Alain Joye
On Wed, 14 Nov 2001 16:27:20 -0400 (VET) Ricardo Núñez <[EMAIL PROTECTED]> wrote: > Mensaje citado por: "Gonzalez, Lorenzo" <[EMAIL PROTECTED]>: > > > I thought '--with-db2' meant you'd get a DB2 (IBM) driver... what has > > DB2 got to do with Berkeley? > > > > An I suffering a bit of confusio

Re: [PHP-DB] RE: [PHP-WIN] Can I rotate a gif with PHP

2001-11-02 Thread Pierre-Alain Joye
> that produce a gif and then calling that gif as part of the report. But > I need to rotate this gif 90 degrees CW. > > Can I do that with PHP? > > Platform > - > W2K > MySQL > PHP 4.04 > > Let me clarify this. The app is written in PHP and I cannot find > anything that references rot

Re: [PHP-DB] Ms-Access to Mysql converter

2001-11-01 Thread Pierre-Alain Joye
On Thu, 1 Nov 2001 16:17:38 +0550 [EMAIL PROTECTED] wrote: Most of them availalbe in the downloads section of mysql.com : http://www.mysql.com/downloads/contrib.html Look at the sections clients, converter and "using MySql with Other Products" hth pa -- PHP Database Mailing List (http://www.ph

Re: [PHP-DB] How to write errorhandling??

2001-10-21 Thread Pierre-Alain Joye
Hello, > Warning: Cannot add header information - headers already sent by (output > started at > e:\projects\globosapiens\07_production\actual\account\include\user.php:256) > in e:\projects\globosapiens\07_production\actual\account\include\user.php > on line 260 > Where is the problem??? I can'

[PHP-DB] DBM module

2001-10-19 Thread Pierre-Alain Joye
Hello, Currentlu testing the dbm functions (for a wrapper class), stopped with dbm. Configure does not recognize the dbm library (db-3.3.11). gdbm, db3 has been recognized. Wich library do I need to use the dbm function (with or without dba), any link ? thank's pa -- PHP Database Mailing