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

make: *** [all-recursive] Error 1 i see an error, but i 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?

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

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

ns are well worth having. -- 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] Mysql not receiving the data

found 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 "'&q

[PHP-DB] Re: content managment systems

ou will be able 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?

[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

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()

tives ;) -- 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

as 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

e 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 unsubs

Re: [PHP-DB] Re: LAMP

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

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

database I use 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

database I use 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

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.

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

mport 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. -- Le

[PHP-DB] Re: Dear php experts

ne give me 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 unsubscri

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

ilable that use 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 ?

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,

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

roblems they were quickly 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

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

other packages 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 ?

irebird installs and runs 24/7 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 ?

gainst Firebird, 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

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

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 probl

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

straction layers. 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 Ma

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

_php 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 unsubsc

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

is one of the major 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

http://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

p.net/manual/en/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

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

nect : Client does not support authentication protocol 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 -

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

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

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 Ma

Re: [PHP-DB] MySQL or Postgres

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

res. Or am I missing 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!

L-less build 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

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

isation ;) Just like 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!

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

ot; Any ideas? What 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 D

Re: [PHP-DB] MySQL connection

? Have you installed 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] MySQL connection

good for those of use who do not bother with MySQL at all. Take a look at Firebird :) -- 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

many of the add 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.

ixing bugs in the php module ;) http://groups.yahoo.com/group/firebird-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

virus 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 :) -- L

[PHP-DB] All this spam crap

et onto the list 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...

27;s baggage (ui 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

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

amp;Leicester Commercial ! ) while other sites work fine without needing any downloads ( Aliance&Leicester Personal ) Why waste time re-inventing the wheel - use what you are used to :) -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing L

Re: [PHP-DB] PHP-Mysql speed

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

en managed 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

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

sults 1 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 Mai

Re: [PHP-DB] Apache 2

now 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] Re: paginating : optimising queries

pgsql driver in ADOdb supports LIMIT so it's only 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

e.net/ 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

[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 Servi

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

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

scripts 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 Enginee

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

y also limit your options. 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.

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

/contact record. 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 -

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

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

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

ow 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 - Contact - http://lsces.co.uk/lsces/wiki/?page=co

Re: [PHP-DB] php 5.2.9 and Postgres 8.3.7

lem using the same build with php 5.2.8 and Postgres 8.3.4, so I ended up using the mod_php5.so module for apache build with these versions, but would like to get to the bottom of it. The obvious question would have to be was postgres actually listed in phpinfo? It would need to have been anab

Re: [PHP-DB] PgSql PDO

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 ---

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

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

will provide these additional 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/

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

you can't 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://e

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

, and basically data 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 hav

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

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 that they will be

Re: [PHP-DB] Upgrading PHP Version 5.1.6

is 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.

Re: [PHP-DB] Re: ezmlm warning

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

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 = "SELEC

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

se ... 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 En

Re: [PHP-DB] Listing parent ids

jacked all the top spots. http://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/ Mo

Re: [PHP-DB] Oracle NClobs

t 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.

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

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

ted 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 my

Re: [PHP-DB] Abstraction library

ing PDO drivers if you want ;) ). It even includes it's 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

Re: [PHP-DB] Abstraction library

David McGlone wrote: On Fri, 2011-12-30 at 11:23 -0500, David McGlone wrote: > On Fri, 2011-12-30 at 12:27 +0000, Lester Caine wrote: > > David McGlone wrote: > > > Hi everyone I got a quick question. I'm wondering if anyone is using a > > > DB abstrac

Re: [PHP-DB] isError ADODB

k > Hoping that fixes it for you. > 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 Servic

Re: [PHP-DB] php & adodb book suggestins

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 ...

Re: [PHP-DB] php & adodb book suggestins

x27;t have much to do with the code itself, 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 t

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

the local machine name 'rdm2' with the same 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 -

Re: [PHP-DB] PDO user question

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 ?

duced 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 L.S.C

Re: [PHP-DB] Firebird return wrong value

s be -1.0, so once we know 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 Engin

Re: [PHP-DB] Firebird return wrong value

ldwide and is a much better alternative to many later database engines. Many Oracle 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 EnquiryS

Re: [PHP-DB] Firebird return wrong value

ommits cross database, and I know that others have 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 Serv

Re: [PHP-DB] Re: mysql query

provides pop-up 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/?pa

Re: [PHP-DB] Re: mysql query

Firebird, 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. -- Leste

Re: [PHP-DB] Bluefish for PHP

ng HTML so 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://ls

Re: [PHP-DB] Bluefish for PHP

g 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 Enginee

Re: [PHP-DB] Re: mysql query

wrong. 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 Electroni

Re: [PHP-DB] Subject Matter

y 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 Ra

Re: [PHP-DB] Subject Matter

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

'nextdue' based on the last payment 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 ma

Re: [PHP-DB] Workout Schedule Calendar

directly accessible. Legally, the 'Data 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 wil

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

l question :) 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://enquir

Re: [PHP-DB] Query does not work

of a program? This is not showing 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 mo

Re: [PHP-DB] MySQLi

clear all of those problems before moving forward. Unless you caa ensure 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 ---

  1   2   >