Re: [PHP-DB] MySQL or Postgres

2003-03-24 Thread Lester Caine
There are other open-source databases besides MySQL and Postgres. My experience has pointed me towards firebird / interbase: http://firebird.sourceforge.net/ Same here - 24/7 operation and Windows or Linux servers -- Lester Caine - L.S.Caine Electronic Services

Re: [PHP-DB] generating sequence without AUTO_INCREMENT

2003-06-27 Thread Lester Caine
something - I've only ever used Interbase/Firebird, and never had a problem with this sort of ident. -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] No MySQL Support in PHP5 - Uh oh!

2003-07-01 Thread Lester Caine
of PHP, and just install that :) -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] hmmm

2003-07-01 Thread Lester Caine
To unsubscribe, visit: http://www.php.net/unsub.php It is a little daunting if you are having trouble with your nappy ;) -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

Re: [PHP-DB] hmmm

2003-07-01 Thread Lester Caine
remembering WHAT button to use for each list to reply to the list :) -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] No MySQL Support in PHP5 - Uh oh!

2003-07-03 Thread Lester Caine
in code that lots of people do not want anyway. -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] apache and php extensions

2003-07-14 Thread Lester Caine
php.ini config (extension dir is set to ./extensions) do i need to setup or apache config I need to change? ? different / and \ Windows needs \, and I normally set the full path to extensions. -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List

Re: [PHP-DB] MySQL connection

2003-07-15 Thread Lester Caine
the php_mysql module in PHP5, it is not included by default now. -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] PHP5.0, MySQL4.1, Apache2 on WinXP

2003-07-23 Thread Lester Caine
on database packages, and is totally free. www.firebirdsql.org -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] PHP Warning: InterBase: I/O error for file File too large.

2003-07-24 Thread Lester Caine
-php?yguid=70215863 -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] sobig virus

2003-08-20 Thread Lester Caine
scanners are up to date - 2 day old Norton virus definitions did not pick it up. Personally. I remove IE from the machines and just run Mozilla. None of my customers have had a problem for some time now - only the one who insisted that IE was essential - he has Mozilla running now :) -- Lester

[PHP-DB] All this spam crap

2003-09-08 Thread Lester Caine
as well, but that is actually less of a problem :) -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Free php-based mysql browser/query tool available for download...

2003-09-18 Thread Lester Caine
and otherwise). I have never run mysql, being a long time Interbase/Firebird user. ibWebAdmin is an alternative for that, but I know that a number of ADOdb based front end's are being built. Perhaps the dropping of mysql integration in PHP5 will help open the market up again :) -- Lester Caine

Re: [PHP-DB] mySQL vs pgSQL | php vs others

2003-09-24 Thread Lester Caine
! ) while other sites work fine without needing any downloads ( AlianceLeicester Personal ) Why waste time re-inventing the wheel - use what you are used to :) -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe

Re: [PHP-DB] PHP-Mysql speed

2003-10-12 Thread Lester Caine
database on ( Linux ), and keep Apache/PHP on the first machine. It will be 5-6 times faster, so you may still need to speed up on or other machine depending on where the bottleneck is. -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http

Re: [PHP-DB] Querying tables on multiple hosts in a single query

2003-10-15 Thread Lester Caine
in it's own 'master' copy. The only alternative would be a middle layer that would have heavy access to the database files, and might even reduce performance. -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] Re: crosstab (was Re: [PHP-DB] Using two colomns ...)

2003-10-20 Thread Lester Caine
a 2 b 3 c 4 d and changing it to 1 2 3 4 a b c d or such? I'm certainly confused. More or less, yes. exactly that. ADOdb - PivotTableSQL() and it works with any database engine. -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http

Re: [PHP-DB] Apache 2

2003-11-03 Thread Lester Caine
running PHP5 on a test rig - again no problems coming up. If it's not getting tested how will we know anyway? -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Root-Server Firebird PHP

2003-12-11 Thread Lester Caine
dont now what i must do. Can anybody help me? Thank you. Frank -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: How to simplify DB creation?

2004-03-19 Thread Lester Caine
Michal Masa wrote: We plan to write a simple DB with app. 10 tables. Are there any tools that simplify and automatize the creation of PHP scripts for the database? Like automatic generation of PHP scripts that produce HTML input forms, generation of value lists, validation, sorting and searching?

[PHP-DB] Re: Firebird support

2004-03-19 Thread Lester Caine
about a conversion, and perhaps when PHP5 is stable that will form the basis. But in the meantime just use the Interbase one. -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

[PHP-DB] Re: Firebird

2004-03-31 Thread Lester Caine
it works perfectly with the interbase package. I do have a better Firebird1.5 abstraction for ADOdb, but it's not ready to be 'published' :) Most of us are waiting for PHP5 before producing a Firebird native build of the interbase package, as the extra functions are well worth having. -- Lester

Re: [PHP-DB] Mysql not receiving the data

2004-06-13 Thread Lester Caine
shot dead, Inspector Jacques Clouseau is the first off' at line 8 I would think it fairly obvious that the extra ' in the text you are loading is causing a problem, use an ` instead, or escape the single ' Not sure if MySQL uses '' or \' :) -- Lester Caine - L.S.Caine

[PHP-DB] Re: content managment systems

2004-06-16 Thread Lester Caine
to select which modules you want to load on the next version. www.tikipro.org -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Getting PHP for Windows to talk to MS SQL?

2004-07-25 Thread Lester Caine
[EMAIL PROTECTED] wrote: I discovered that PHP was not looking at C:\php\php.ini. Rather, somehow it was looking at C:\Windows\php.ini. Anyway, now all is well. Yep - that is the right place on windows. -- Lester Caine - L.S.Caine Electronic Services -- PHP Database

Re: [PHP-DB] Re: generating reports in php

2004-07-30 Thread Lester Caine
reports from FastReports ;) -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Call to undefined function mysql_connect()

2004-08-01 Thread Lester Caine
;) -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: LAMP

2004-08-03 Thread Lester Caine
to catch up with the better FREE database engines ;) -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: LAMP

2004-08-03 Thread Lester Caine
the engine takes care of the business rules of managing data. SQLite is a different matter and the obvious new base for beginners, but for real applications ... -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe

Re: [PHP-DB] Re: LAMP

2004-08-03 Thread Lester Caine
! And because of that other better engines do not get supported, and we get told - Move to MySQL if you want to host here. It is only the right tool for some jobs, otherwise why are they going hell for leather to add all these supposedly unnecessary features TO MySQL ;) -- Lester Caine

Re: [PHP-DB] Re: LAMP

2004-08-03 Thread Lester Caine
Gary Every wrote: The answer to that is SPEED. Nothing short of Oracle comes even close You must have a big cheque book. I get just as fast a system without having to pay a penny over the cost of the hardware ;) -- Lester Caine - L.S.Caine Electronic Services

Re: [PHP-DB] Re: LAMP

2004-08-03 Thread Lester Caine
can ask privately if they are interested ;) ) -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: LAMP

2004-08-03 Thread Lester Caine
can ask privately if they are interested ;) ) -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] retrieved data from mysql to be shown in spreadsheet

2004-08-23 Thread Lester Caine
driver? If so, then you can create the reports you want in OpenOffice and save them as OpenOffice documents. You can then just create a link to the document. Not the most efficient way of doing things, but it should work, I don't have any problem with Firebird via it's JDBC driver. -- Lester

[PHP-DB] Re: Lotus Notes DB to MySQL?

2004-08-28 Thread Lester Caine
her old data first. If memory serves me correctly, you can export from Notes as a CSV text file, and then import that. It's been some time since I had to do it, but I am sure that was the path I used to get the contacts data into an Interbase database. -- Lester Caine

[PHP-DB] Re: Dear php experts

2004-08-29 Thread Lester Caine
functional code for it? I'd probably start from one of the working systems ;) Have a look at the list at http://www.opensourcecms.com/ -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] Which Database Abstraction Layer ?

2004-09-02 Thread Lester Caine
ADOdb or have moved to it (or are moving) in later updates. -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Which Database Abstraction Layer ?

2004-09-02 Thread Lester Caine
, but they are a couple of years out of date. The ADOdb accelerator does make a difference if speed is a problem, but I don't have any major bottlenecks (YET) ;) -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit

Re: [PHP-DB] Which Database Abstraction Layer ?

2004-09-02 Thread Lester Caine
cleared. Unlike some of the other options I tried. Now *I* am happy with ADOdb and see no reason to change, so I don't keep up with other packages and can't contrast. So answering some of your questions is difficult. -- Lester Caine - L.S.Caine Electronic Services

Re: [PHP-DB] Which Database Abstraction Layer ?

2004-09-03 Thread Lester Caine
are simply MySQL wrappers with cobbled support for a couple of other engines. -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Which Database Abstraction Layer ?

2004-09-03 Thread Lester Caine
without DBA's or manual intervention. -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Which Database Abstraction Layer ?

2004-09-04 Thread Lester Caine
, but keeping track with the changes to MySQL has had to be dropped - which version/sub version etc. ... Of cause what is actually needed is a good standard XML SQL interface - hopefully before Microsoft patent it ;) -- Lester Caine - L.S.Caine Electronic Services -- PHP

Re: [PHP-DB] Which Database Abstraction Layer ?

2004-09-04 Thread Lester Caine
Lester Caine wrote: No, that's true; no Firebird yet. Drivers needed :) It's basically a slightly modified version of the JDBC API for PHP. Now THAT might be the correct way forward. I already use the Firebird-Jaybird interface when running plug-ins on Eclipse without any problems, but I

Re: [PHP-DB] Which Database Abstraction Layer ?

2004-09-30 Thread Lester Caine
. Interesting thing from my point of view - both done on Apache2 ADOdb is not giving me any problems, but this does show that a switch to raw ibase will give me a performance boost if I need it. -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http

[PHP-DB] Re: Apache 1.3.31, php 5.0.2 and firebird 1.5

2004-10-25 Thread Lester Caine
and there is a tikifirebird site which should be active next month running on Apache2, PHP5 and Firebird 1.5 watch on the firebird-php list for details ;) -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe

Re: [PHP-DB] Re: [EMAIL PROTECTED] November 2, 2004

2004-11-01 Thread Lester Caine
reasons the rest of the world gets p*d of Americans ;) -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Firebird and PHP

2004-11-19 Thread Lester Caine
://groups.yahoo.com/group/firebird-php You will get Firebird related help there. -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: PHP and Firebird

2004-12-01 Thread Lester Caine
/function.ibase-trans.php Just add a another pair of arguments for each connection you want to combine in a 2-phase commit. -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: PHP and Firebird

2004-12-01 Thread Lester Caine
is that file as it would be worth a look at. In any case, that IS the sort of thing we like to play with on the firebird-php list ;) -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

[PHP-DB] Re: PHP connect to mysql problem

2005-01-06 Thread Lester Caine
requested by server; consider upgrading MySQL client Which version of MySQL do you have loaded, and which version of the MySQL package have you installed in PHP. MySQL4.1 needs different combination to MySQL4 or earlier ? -- Lester Caine - L.S.Caine Electronic Services

[PHP-DB] Re: Integrating Interbase.so and PHP

2005-01-15 Thread Lester Caine
distributions in the archive, a starting point would be which distribution, and PHP4 or 5 -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] accessing mysql on non default port - windows

2005-02-05 Thread Lester Caine
Jeff wrote: thats no good. man if its something simple, i'm not seeing it. well it was something simple...and now i see it. old_passwords. Don't you just love informative error messages ;) -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List

Re: [PHP-DB] Re: paginating : optimising queries

2005-03-22 Thread Lester Caine
the calculation of COUNT(*) that needs replacing with a faster pre-calculated count. -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: adodb is slow

2005-06-06 Thread Lester Caine
/ Look for Speed Up Your PHP Code with the ADOdb extension -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Php 5 and Mysql on Windows

2006-10-04 Thread Lester Caine
[EMAIL PROTECTED] wrote: That solved it. Awesome. Thanks you so much. Brian - A 'phpinfo()' test page is almost essential. When you make changes to the php.ini file you can check they have taken ;) -- Lester Caine - G8HFL - L.S.Caine Electronic Services - http

Re: [PHP-DB] australian city db -lat/lon?

2007-08-15 Thread Lester Caine
Bastien Koert wrote: http://www1.auspost.com.au/postcodes/ The Australian postcode table does not have lat and lon - at least not on the copy I have, am I missing something? -- Lester Caine - G8HFL - Contact - http://home.lsces.co.uk/lsces/wiki/?page=contact

Re: [PHP-DB] databases and XML

2008-09-09 Thread Lester Caine
to dump it to various databases. So what large volume are you thinking about? -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/lsces/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital

Re: [PHP-DB] Performance (lots of tables / databases...)

2008-09-27 Thread Lester Caine
. Properly indexed tables will be fast and a single connection accessing that data will be faster than having to make multiple connections to different databases, and if it only has to manage a small number of table most links would probably be cached. -- Lester Caine - G8HFL

Re: [PHP-DB] When does using multiple tables make sense?

2008-10-20 Thread Lester Caine
. The type of info field flags things like primary phone. Address details often need the same treatment as well, but I use UK post code as a key for the bulk of that information so it just goes into a another info field. -- Lester Caine - G8HFL - Contact - http

Re: [PHP-DB] When does using multiple tables make sense?

2008-10-26 Thread Lester Caine
Liam Friel wrote: 2008/10/20 Lester Caine [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Jason Pruim wrote: So my question is... When is it best to use more tables? All the info will be related to each other, so I think I would be looking at either a many-to-many

Re: [PHP-DB] Strange string from MEMO field in FireBird

2008-12-13 Thread Lester Caine
the BLOB ID incorrectly. 5.2.6 should be OK. Also you do not say how you are creating the results. Which functions you are using. There is a support list for Firebird and PHP http://groups.yahoo.com/group/firebird-php/ which also has useful messages in the archive. -- Lester Caine - G8HFL

Re: [PHP-DB] PgSql PDO

2009-09-11 Thread Lester Caine
via pgsql_connect() pdo_pgsql::_construct() is throwing an PDO_Exception could not find driver am I missing something here ? pls help Perhaps you could show the code. You should be using =new rather than _construct() I think. -- Lester Caine - G8HFL - Contact

Re: [PHP-DB] Need help in PHP file Management System

2009-09-21 Thread Lester Caine
directory for each user, and stores all their files within their own base folder. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers

Re: [PHP-DB] PDO and PostgreSQL - RAISE NOTICE

2009-10-05 Thread Lester Caine
facilities. I use Firebird myself so can't comment on the 'fine detail' on postgres, but some of the Firebird options can't easily be supported in PDO ;) -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http

Re: [PHP-DB] Combing PDO with mysql_pconnect connections in one application -- will this degrade performance?

2009-12-10 Thread Lester Caine
connect two processes to the same connection. You would not know which process was accessing things. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com

Re: [PHP-DB] Combing PDO with mysql_pconnect connections in one application -- will this degrade performance?

2009-12-10 Thread Lester Caine
entered on on connection will not be visible on the other until properly committed. Having that activity hidden in the drivers can lead to a little 'confusion' as to what state data is actually in Even just opening two connections via the MySQL driver will have the same effect. -- Lester

Re: [PHP-DB] Combing PDO with mysql_pconnect connections in one application -- will this degrade performance?

2009-12-10 Thread Lester Caine
not be a problem. -Sara Lester Caine wrote: Sara Leavitt wrote: Hi Lester, Our application is not using php transactions (e.g., COMMIT, ROLLBACK etc.), so I think we are safe there. Are you saying that even if both the mysql_pconnect and PDO connection are persistent

Re: [PHP-DB] Upgrading PHP Version 5.1.6

2010-03-05 Thread Lester Caine
. If this is the case, then it is worth adding a PHPINIDir to the new httpd.conf pointing to a copy of php.ini in your new copy of PHP. http://php.net/manual/en/install.windows.apache2.php -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine

Re: [PHP-DB] Re: ezmlm warning

2010-11-05 Thread Lester Caine
sending more emails to that address. I had one for this list this morning as well ... -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers

[PHP-DB] Re: [PHP-WIN] Re: PHP Search DB Table

2010-12-14 Thread Lester Caine
Oliver Kennedy wrote: $query = SELECT * FROM clients WHERE clientid = '%.$term%'; $query = SELECT * FROM clients WHERE clientid = '%.$term.%'; Note missing '.' But that should be the same as $query = SELECT * FROM clients WHERE clientid LIKE '.$term.'; -- Lester Caine - G8HFL

Re: [PHP-DB] php_interbase.dll , PHP 5.3.x VC9 needed, which works with Embarcadero Interbase

2011-05-31 Thread Lester Caine
... not sure who is actually testing that, on the whole we have all moved over to Firebird so that we do not have any licensing problems. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve

Re: [PHP-DB] Listing parent ids

2011-07-28 Thread Lester Caine
://syntaxhelp.com/SQLServer/Recursive_CTE is a nice example of what you outlined ... -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop

Re: [PHP-DB] Oracle NClobs

2011-08-05 Thread Lester Caine
that it was not only Firebird that was affected by the problem. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://medw.co.uk

Re: [PHP-DB] Fatal Error - Undefined function mysqli_connect

2011-09-04 Thread Lester Caine
commented out in the php.ini. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://medw.co.uk// Firebird - http

Re: [PHP-DB] Fatal Error - Undefined function mysqli_connect

2011-09-04 Thread Lester Caine
extension for newer versions, so am trying to rewrite the code to use mysqli_connect. For what it's worth, mysqli_init() also produces Call to undefined function mysqli_init() in my error logs. That would explain the problem ;) Need the mysqli extension enabled instead of mysql ... -- Lester Caine

Re: [PHP-DB] Abstraction library

2011-12-30 Thread Lester Caine
own cache which can help with repetitive stuff. It is still actively supported, and is used by a number of large projects. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http

Re: [PHP-DB] Abstraction library

2011-12-30 Thread Lester Caine
David McGlone wrote: On Fri, 2011-12-30 at 11:23 -0500, David McGlone wrote: On Fri, 2011-12-30 at 12:27 +, Lester Caine wrote: David McGlone wrote: Hi everyone I got a quick question. I'm wondering if anyone is using a DB abstraction layer such as PEAR DB. I've used

Re: [PHP-DB] isError ADODB

2012-01-05 Thread Lester Caine
. Best, Thanks Karl. I finally got to try this and it wasn't the answer. I'll keep plugging to see what I can do. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http

Re: [PHP-DB] php adodb book suggestins

2012-01-26 Thread Lester Caine
David McGlone wrote: On Thu, 2012-01-26 at 08:45 +, Lester Caine wrote: David McGlone wrote: can anyone suggest any good up to date books out there on php adodb. The only documentation on ADOdb is the website http://adodb.sourceforge.net/#docs ... has ANYBODY seen

Re: [PHP-DB] php adodb book suggestins

2012-01-27 Thread Lester Caine
, it's more of that at home feel. I also have these thoughts that if PEAR went belly up, so could ADOdb. Scary thought indeed. :-/ I do my own mods to ADOdb ;) So it does not bother me, certainly a LOT less than having to cope with all the 'improvements' in PHP itself! -- Lester Caine - G8HFL

[PHP-DB] Nubbie pointers on MySQL users ...

2012-08-21 Thread Lester Caine
user names. Where am I going wrong? Is there something I'm missing setup wise? ( And I don't know who you manage with raw SQL for transfers, on Firebird I can backup and restore a 500Mb database in seconds ;) ) -- Lester Caine - G8HFL - Contact - http://lsces.co.uk

Re: [PHP-DB] PDO user question

2012-09-09 Thread Lester Caine
then always produce a full set of records except for the last page ... -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop

Re: [PHP-DB] Another PDO ?

2012-09-10 Thread Lester Caine
tables will give a reduced number of final fields in the result. Of cause it IS often better to work with named fields rather than using '*' which does allow better handing of the process anyway. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact

Re: [PHP-DB] Firebird return wrong value

2013-01-18 Thread Lester Caine
what IS in the database we can look at which end has gone wrong ;) -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop

Re: [PHP-DB] Firebird return wrong value

2013-01-18 Thread Lester Caine
users are porting over to Firebird to reduce costs. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://medw.co.uk

Re: [PHP-DB] Firebird return wrong value

2013-01-18 Thread Lester Caine
found the restrictions imposed by PDO prevent things working well in older style Firebird Applications. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com

Re: [PHP-DB] Re: mysql query

2013-08-22 Thread Lester Caine
crib sheets onthe parameters for a selected function, and of cause the auto complete can be configured to match your preferred way of working ... I'm still on tabs for indenting -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine

Re: [PHP-DB] Re: mysql query

2013-08-23 Thread Lester Caine
, and have always built the SQL using parameters, so that the SQL is pure text, and values are passed in an array. This is something MySQL was a lot later in catching onto, but many of the simple security problems are totally eliminated using that approach. -- Lester Caine - G8HFL

Re: [PHP-DB] Bluefish for PHP

2013-08-23 Thread Lester Caine
not as good when editing code. My Eclipse setup does a very similar job on the html/js and css so I've not used it in many years. I don't think the colour selections were very good if memory serves. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page

Re: [PHP-DB] Bluefish for PHP

2013-08-23 Thread Lester Caine
with the errors and warnings in the third party libraries - it flags them as well :) -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital

Re: [PHP-DB] Re: mysql query

2013-08-23 Thread Lester Caine
. I'm with him on the statement that MySQL should have returned an error. Certainly Firebird would have done and so identifying the problem might have been easier. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services

Re: [PHP-DB] Subject Matter

2013-08-23 Thread Lester Caine
the current threads are not that far off topic ;) -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://medw.co.uk Rainbow

Re: [PHP-DB] Subject Matter

2013-08-23 Thread Lester Caine
Matt Pelmear wrote: On 08/23/2013 04:36 PM, Lester Caine wrote: Matt Pelmear wrote: I am not sure who runs the list, whether they care about off-topic posts, or whether anyone else cares about it. The php lists are only loosely moderated, but comments like yours usually bring things under

Re: [PHP-DB] Billing Module in PHP

2014-01-09 Thread Lester Caine
which will show the period paid for, and even this is a little redundant since it is available from the last payment record, but I see no need for a third table? Just set the right 'relations' between the master record and payment list? -- Lester Caine - G8HFL

Re: [PHP-DB] Workout Schedule Calendar

2014-03-01 Thread Lester Caine
protection Act' comes into play here in the UK, but we have sites with over a million visits recorded over the past approaching 20 years, and the system still works as fast as when it was first installed :) ( I use Firebird but any of the options will handle your level of activity ) -- Lester Caine

Re: [PHP-DB] Re: Newbie Question $2

2014-06-17 Thread Lester Caine
:) The original post was fairly complete in what it was asking, and the answers reasonably worded ... -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model

Re: [PHP-DB] Query does not work

2014-07-02 Thread Lester Caine
that you have, only that you can't see the actual data returned. I prefer firebird to mysql, and the normal process is to use the mysqli_fetch_assoc style working so that the keys of the array are the returned field names in which case the print_r output gives more information ... -- Lester Caine

Re: [PHP-DB] MySQLi

2014-09-13 Thread Lester Caine
your server will always be switched bak to a compatible mode of working. And all that before even looking at MySQL ... I've never used it, so hopefully someone else will cover that side. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine

Re: [PHP-DB] MySQLi

2014-09-14 Thread Lester Caine
functions that have yet to appear in MySQL, some of those are exposed in MySQLi so you can ignore them when upgrading but it is always those fringe cases that take the most time to resolve? :( -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact

[PHP-DB] SQL injection attempt

2015-03-11 Thread Lester Caine
hack attempt ( bit lost on Firebird anyway ;) ) but the question as usual is it malicious in the content of MySQL, or just fishing? In my case it just white screens anyway so I don't know why they keep trying to send the same style of url thousands of times? -- Lester Caine - G8HFL

  1   2   >