MySQL and PHPEXE - Some info for the group

148 views
Skip to first unread message

Miike

unread,
Jan 21, 2010, 6:38:26 PM1/21/10
to ZZEE PHPExe
Hi everyone,

I thought that I would share something with the group.

As you are aware, using MySQL with ZZEE works as it should but when it
comes to supplying files for customers has its disadvantages due to
having to install MySQL separately (for licencing and technical
reasons)...

However, I may have some exciting new for you. An incredible solution
that I have been using for a while now is called FSQL. It mimics the
functionality of MySQL, its free and its only one php file to include
(fSQL.php).

The functionality as I mentioned mimics MySQL so much that you can
convert your MySQL queries to FSQL queries in no time (no changes to
the query are necessary).

The only change is that instead of using:

$query=mysql_query(" YOUR QUERY HERE ");
$result=mysql_fetch_object($query);

You would use:

$query=query(" YOUR QUERY HERE ");
$result=fetch_object($query);

Spot the difference?

Kind regards to all and respect to Paul for such an awesome, industry
changing developers solution!!

Paul (ZZEE)

unread,
Jan 22, 2010, 11:22:56 AM1/22/10
to php...@googlegroups.com
> The only change is that instead of using:
>
> $query=mysql_query(" YOUR QUERY HERE ");
> $result=mysql_fetch_object($query);
>
> You would use:
>
> $query=query(" YOUR QUERY HERE ");
> $result=fetch_object($query);

Thank you Miike, very good news. FSQL can really help many people.

For the easiest of conversions I have developed a library where most of
mysql_xxx functions are rewritten as calls to FSQL functions, kind of a
drop-in replacement for MySQL. So you need to change virtually nothing in
your code if you want to adapt your code from MySQL to FSQL. Also the
index.php file illustrates how this works - you will see a familiar MySQL
stuff.

Download here:
http://www.zzee.com/phpexe/fsql.zip

FSQL Project home:
http://fsql.sourceforge.net/index.html
FSQL Download is here:
http://sourceforge.net/projects/fsql/


Miike

unread,
Jan 22, 2010, 3:39:16 PM1/22/10
to ZZEE PHPExe
Thanks for your kind comment Paul and for your library that mimics
mysql better than I could ever have imagined. You never cease to
amaze me.

Time for me to test it out!

Cheers
Mic

skylark....@gmail.com

unread,
Oct 5, 2015, 7:28:53 AM10/5/15
to ZZEE PHPExe
hello miike
can you provide any sample demo using ZZEE and FSQL
thanks

Mike:Hewitt

unread,
Oct 6, 2015, 6:10:12 AM10/6/15
to php...@googlegroups.com

I have no access to my files because I'm in hospital. That said, if you search this group for fsql then you should find some prepared downloads that should help.

--
--
You received this message because you are subscribed to the Google
Groups "ZZEE PHPExe" group.
To post to this group, send email to php...@googlegroups.com
To unsubscribe from this group, send email to
phpexe+un...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/phpexe?hl=en
---
You received this message because you are subscribed to the Google Groups "ZZEE PHPExe" group.
To unsubscribe from this group and stop receiving emails from it, send an email to phpexe+un...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

ZZEE Groups

unread,
Oct 6, 2015, 6:24:31 AM10/6/15
to php...@googlegroups.com
Mike,

Hopefully you get better soon.
--
Regards,
Paul.
Reply all
Reply to author
Forward
0 new messages