[PHP] ADOdb db abstraction library moved to sourceforge

important news http://lists.sourceforge.net/lists/listinfo/adodb-news adodb-general: for general postings http://lists.sourceforge.net/lists/listinfo/adodb-general Bugs should still be reported at the existing forums at http://phplens.com/lens/lensforum/topics.php?id=4 Thank you. John Lim -- PHP

[PHP] A Date and Time Library for all seasons

Download: http://php.weblogs.com/adodb_date_time_library PHP native date functions use integer timestamps for computations. Because of this, dates are restricted to the years 1901-2038 on Unix and 1970-2038 on Windows due to integer overflow for dates beyond those years. This has been frustrating

[PHP] Re: Cold Fusion conversion issues: app vars and cached queries

Hi Steve, "Steve W" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > My company is looking to move our site away from Cold Fusion due to > the cost. We had talked about JSP, but I would highly prefer PHP. > After evaluation, with the generic database functions n

Re: [PHP] I'm in need of a PHP web host recommendation

I would recommend http://futurequest.net Good, reliable, and very skilled technical people, who know linux and web-hosting inside out. "John Kenyon" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > > Jason Reid wrote: > > >I suggest paying a visit to www.webho

Re: [PHP] ODBC

Have a look at http://php.weblogs.com/adodb_csv "Bob Lockie" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > >Can PHP be used on an Apache server (linux) to connect to a (remote) MS > >Access server (NT) through ODBC? > > Yes. > > > > If so, does anyone

[PHP] Re: BREAK into the DB

Also see wordwrap( ). "Blue Presley" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > the function you are looking for is called nl2br(). Translated it means > 'new line to .' when you pull you text from your database run it > through this and it will be corr

Re: [PHP] Re: Re: PHP 4.2

I use http://php.net/strnatcasecmp since version_compare is only available since 4.1.0, which is rather self-defeating :-) "Rasmus Lerdorf" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > You mean like php.net/version_compare ? > > On Mon, 24 Jun 2002, Dreamriv

[PHP] Re: srand thought

Hello Gerard, The point is that we wanted adodb to work "out of the box" so that is why srand( ) is called. You can do it yourself if you want to (and comment out the srand) , or let adodb do it for you. Regards John "Gerard Samuel" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[

Re: [PHP] Re: Cross DB application

Hi Manuel, "Manuel Lemos" <[EMAIL PROTECTED]> wrote > > Most of the popular database abstraction packages support prepared > queries, except for your PHP ADODb. So, think about this before you keep > throwing sand to the eyes of the users that do not know better, may be > you understand the point

Re: [PHP] Re: Cross DB application

Manuel, > Prepared queries in practice are the same as what John Lim calls in this > document http://php.weblogs.com/portable_sql as "binding", except that > he doesn't seem to be aware that it is the same thing, so he says that > only some database can use it! :-

[PHP] Re: Performance question

I suggest using a html caching solution. Generate your html once, and store it in a file. I like http://0x00.org/php/phpCache/ "Mike Fifield" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Ok I have a performance question. I run a wallpaper site; this is the u

Re: [PHP] Re: Cross DB application

Thanks Richard, ADOdb is also dual licensed under a more open license - BSD too. You might also find interesting this article: http://php.weblogs.com/portable_sql Regards, John Lim "Richard Ellerbrock" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAI

[PHP] Re: ASP vs PHP

Hello Ciro, For database access and automatic generation of forms, see http://phplens.com/ You can create search/edit/new record forms automatically through the web user interface with little coding. It also has a low level PHP interface for deep coding. This is a commercial product, developed by

[PHP] Re: php 4.1.1 vs 4.0.6

Cc Zona <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > In article <[EMAIL PROTECTED]>, > [EMAIL PROTECTED] (Ezra Nugroho) wrote: > > > I am deciding between 4.0.6 and 4.1.1 (or maybe 4.1.2 if it's comming soon). > > I heard that there is some significant diff

[PHP] Re: Help on PHP vs JAVA

Hi Any consultant will tell you that all you need to do is define the comparison criteria and you can choose the winner easily. PHP: ease of use, low cost of ownership, etc. Java: scalability, choice of implementations, etc. I just hope you can live with your choices! Regards, John Berlina <[

[PHP] Re: Multi Threading in PHP

Hi Bart This can be simulated using non-blocking sockets. However this is one time when using Perl or Python might be a better solution (sigh). Bart Frackiewicz <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hi, a few days ago i saw here a thread about multi t

[PHP] Re: Adding 6 digits to a str?

Try http://php.net/str_pad Andy <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi guys, > > I am trying to force a int to be 8 digits. If it is only 3 dig filling the > first ones with 0. > > Anyhow I tryed it with type casting, but it does not matter what I t

Re: [PHP] Persistent Database Resources?

Hi, Both PEAR DB/Cache and ADOdb database libraries support cacahed recordsets. See the PEAR sources and http://php.weblogs.com/adodb Rgds, John Nick Wilson <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > >

[PHP] Re: Creating rich interfaces for web applications??

Hi Geoff, Have a look at phpLens at http://phplens.com/ It's a commercial php software that my company wrote that allows you to perform sort/filter/edit and validation too on your data. Many of our customers are using on Intranets/Extranets. Works well with NN 4/6 and IE browsers. Regards, John

[PHP] Re: Using persistent connection to database

I would recommend switching to the oci_* functions. More reliable. Bye, John Berlina <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi to everybody, > > first sorry for my poor english. > > im trying to use persistents connections to an Oracle Database throug

[PHP] Re: i get a warning after upgrading to 4.1.0 (repost)

This is a known bug with persistent database connections. Switching to non-persistent connections or ISAPI avoids this problem. Phillip Oertel <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > does anyone know what > > Warning: Unknown persistent list entry type

[PHP] Re: Unable to return object references from functions

Hi Yasuo, I seem to remember having similar problems understanding objects and references also and you guided me here. Manuel is a good programmer and if he also has problems, I'm a bit worried for novices. Objects and references are not intuitive :( Regards, John Yasuo Ohgaki <[EMAIL PROTECTED

Re: [PHP] Session storage and the --with-mm option

This doesn't explain why mm is causing such a memory bloat though. Mark, are you storing big arrays as session variables? I am using mm myself for sessions and never have these problems (I only store less than 1K of data in sessions anyway). Regards, John Jeremy Allen <[EMAIL PROTECTED]> wrote

Re: [PHP] PHPhish Logo

Hi Also see http://www.web-cards.de/create.php3?rubrik=29 P for Pachyderm! John Rasmus Lerdorf <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Not that I think PHP needs a mascot, but I have always liked the > mole/groundhog. Someone even drew up some logos

[PHP] Re: Version Contol for PHP site

Hi Jeff There is a Windows version of WinCVS (see http://wincvs.org/ ). John Jeff Bearer <[EMAIL PROTECTED]> wrote in message 1006195598.1407.7.camel@jbearer">news:1006195598.1407.7.camel@jbearer... > Hello, > I'm trying to come up with a workable solution to implement version > control for our

Re: [PHP] Advantages of php

See http://php.weblogs.com/php_vs_asp and http://php.weblogs.com/php_asp_7_reasons The articles need to be updated for Microsoft.Net though. Jason G. <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > You could check the list archives... This question flys by ev

[PHP] Re: ASP, ODBC, IIS 5, and PHP

Run in CGI mode. The ISAPI is still a bit unstable. Sigh. Kevin Pratt <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I appear to be having a problem where when I run a PHP script that uses ODBC > calls my ASP/ODBC driven pages stop functioning. When I run a P

[PHP] Re: Class for database-access doesn't work

Leave out the second $. Eg, $this->database is correct. Next time when debugging, set error_reporting(E_ALL); This will catch this error I believe. Bye, John Alexander Czernay <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi, > > I just tried to write a si

Re: [PHP] Re: Faking MS Access on MySQL linux box

u think? >mweb > > On Sat, Nov 10, 2001 13:02:14 at 01:02:14PM +0800, John Lim wrote: > > See http://php.weblogs.com/adodb_csv > > > > "ADODB also supports SQL communications through HTTP as a database proxy. In > > plain English

[PHP] Re: Associative Arrays Performance under Linux

This is just a suggestion. Rather than creating the associative array from scratch, prebuild one and just use copies of that associative array when you need it. I don't know whether it will be faster, but intutitively it should. This is analogous to pre-allocating structs in memory before using t

[PHP] Re: Design for Large OO poject

Hi Daniel, Most OOP projects contain multiple hierarchies, not just one. Normally DB is not made the base class. Think in terms of whether the objects have is-type-relationships or use-part-relationships. Eg. Boring_News uses-the-part MySQL_DB, so Boring_News uses the MySQL_DB object as a membe

[PHP] Re: Faking MS Access on MySQL linux box

See http://php.weblogs.com/adodb_csv "ADODB also supports SQL communications through HTTP as a database proxy. In plain English, if you have a FoxPro or Access database that you need to connect to from Unix, you can do so via HTTP (eg. Apache talking to IIS, which talks to a small PHP program [th

[PHP] phplib, pear db, metabase, adodb, and native mysql benchmarks

Someone asked me to benchmark PHPLib also. Here is the revised benchmarks, with some minor speedups for PEAR DB and Metabase. Benchmark was to select 82 rows from the products table 200 times. The tests were repeated 5 times. Connection times were excluded from the benchmark. Lower values are bet

[PHP] Re: something like alert (javascript)

Try LensDebug. Generates messages in a second window from PHP. http://phplens.com/lens/free_code/lensdebug.php "Eduardo Kokubo" <[EMAIL PROTECTED]> wrote in message 001801c14c18$07d4d7c0$a102a8c0@cttmar">news:001801c14c18$07d4d7c0$a102a8c0@cttmar... Is there any function in PHP that is similar t

[PHP] Re: MySQL Ability

Depends on what you want to do. For pumping out large amounts of data, it's a great tool. For forums and simple content management, it works fine for most web sites. For handling complex database transactions, not really. "Devin Pittman" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">ne

[PHP] oci8.max_links missing from php.ini

Hello, I checked the windows php.ini and i did not see any reference to oci8.allow_persistent=On ; allow or prevent persistent links oci8.check_persistent=On ; check that a connection is still validbefore reuse oci8.max_persistent=-1 ; maximum number of persistent links. -1 means no limit oci8.m

[PHP] Re: Zend Cache & cache_gui

I had that problem. Appeared to be some incompatibility with Zend Optimizer and Zend Cache. Upgrade to Zend Optimizer 1.1.0 and everything worked. Regards, John "Joseph Blythe" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hello all, > > I just installed Ze

[PHP] Re: caching madness

Hello Christian, Try this: Header("Cache-control: private, no-cache"); Header("Expires: Mon, 26 Jul 1997 05:00:00 GMT"); # Past date Header("Pragma: no-cache"); The explaination of how it works is here: http://php.weblogs.com/stories/storyReader$550 Let me if it works, or if you can improve o

[PHP] Re: odbc_connect w/connectstring instead of DSN

Yes it is. See http://php.weblogs.com/odbc Bye, John "Emile Bosch" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Is it possible to connect with odbc_connect with an connectstring instead of > an DSN? > > Warm regards, > Emile Bosch > > > > -- PHP General

[PHP] Re: PHP vs M$.NET C#?

I believe there is a beta dotnet extension that allows you to call MS.NET class libraries directly by Sam Ruby. Check http://lxr.php.net So its "extend and embrace" :-) Regards, John "Emile Bosch" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Could please t

[PHP] Re: Monitoring traffic

Use performance monitor or network monitor. Regards, John "Sed" <[EMAIL PROTECTED]> wrote in message 003b01c13d59$18710bd0$0d00a8c0@mamma">news:003b01c13d59$18710bd0$0d00a8c0@mamma... > Hi, > > This is kind of off topic but I need to monitor the traffic in > kilobytes/bits on my net card adapter

[PHP] Re: PHP versus ZOPE

Andrew Kuchling is a well known Zope/Python expert who switched to something simpler. Here's why... http://www.amk.ca/python/writing/why-not-zope.html "Carlos Fernando Scheidecker Antunes" <[EMAIL PROTECTED]> wrote in message 002101c13e50$021ac860$0a505ad1@Nando4">news:002101c13e50$021ac860

Re: [PHP] Homesite & php

Yep, As far as I know, it's not recommended by Allaire themselves to use Design mode with PHP/ASP unless you want it to muck around with your code, only for pure HTML. Bye, John "Hugh Danaher" <[EMAIL PROTECTED]> wrote in message 001901c138fe$31583ec0$c1fdb3d1@win95">news:001901c138fe$31583ec

Re: [PHP] Sterilize user input function

It really depends on what you use the user input for. If you are just storing into a database and splashing it out to a html page later, htmlspecialchars( ) is adequete protection. If this is a filename, then checks for the prefix "http://"; and '..' and quotes in the file name, and a base dire

[PHP] Re: Smarty + JavaScript

>From the smarty manual {literal}