[Xerte-dev] Re: PHP compatibility

[David Goodwin]

On 15 Oct 2013, at 17:56, Pat @ Pgogy <xerte at pgogywebstuff.com> wrote:

> this is sort of why I think we needed a bigger set of goals for stuff
> 

Indeed.

> This has been coming for ages, but everyone at the moment is sort of solving their own problems (so to speak), and so this wasn't ever going to become a big deal, but is eventually going to stop everything.
> 

Yes.

> Most of the XOT code is heading to being almost 5 years old now, stuff like was always going to happen without a sort of core development thread going on
> 


Yes.


I added 'db_query', 'db_query_one' function calls ages ago (see https://github.com/thexerteproject/xerteonlinetoolkits/blob/develop/website_code/php/database_library.php )  which do try to allow for the migration away from direct use of the PHP mysql driver (i.e. you could swap to use mysqli / mysqlnd or PDO or whatever easily enough). However, the last time I looked there was plenty of the codebase which still had 'mysql_query()' calls (or other mysql_ calls).

In an ideal world, the SQL which is embedded everywhere would be living in some sort of model class/library and be portable (or different files would be used for different databases) - so the project could run on SQLite/PostgreSQL/MSSQL etc but I suspect this would be difficult to achieve.

thanks,
David.



Pale Purple Ltd.  (Company No: 5580814)
'Web and Mobile Application Development for Business'

http://www.palepurple.co.uk   
Office: 0845 0046746     Mobile: 07792380669 

Follow us on Twitter: @PalePurpleLtd

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nottingham.ac.uk/pipermail/xerte-dev/attachments/20131015/7cf6500a/attachment.html>