[FX.php List] MySQL and fx.php

[Stephe Pocock]

Thanks Steve

I think I will try and do it without the FX then as I am starting from scratch.  


Thanks for the advice, it is greatly appreciated.

S





________________________________
From: Steve Winter <steve at bluecrocodile.co.nz>
To: FX.php Discussion List <fx.php_list at mail.iviking.org>
Sent: Fri, 13 August, 2010 1:18:20 PM
Subject: Re: [FX.php List] MySQL and fx.php

Hi Stephen

Are you wanting to use FX.php simply because you're familiar with it...? In 
general I would say that the only good reason to use FX with MySQL is because 
you've got a (large) legacy site which used to use FMP and is being converted to 
work with MySQL.

If you're building something from scratch using MySQL, then you're better off 
(in my ever so humble view ;-) working directly with MySQL queries... there are 
heaps of tutorials all over the web that tell you how to get started with MySQL, 
and it's pretty straightforward for anyone with a moderate amount of PHP 
experience to get their head around...

That said, to answer your specific question. The $webCompanionPort listed below 
will need to be set to the port that MySQL is listening on (usually 3306, but 
check with your local install).

Cheers
Steve



On 13 Aug 2010, at 05:56, Stephe Pocock wrote:

Hi all
>
>After years of using FX and FMPS, I need to look at using mySQL as my database.
>
>I have a Wordpress site that has galleries of photos.  I want the visitors to be 
>able to select which photos they want to have printed.
>
>I have looked at a number of shopping cart solutions, but none fit the mold.
>
>So I thought I would give it a go.
>
>Does anyone have any example files for using FX and mySQL.
>
>From what I have seen I need to change the server info to 
>
>$serverIP = '192.168.2.3';
>$webCompanionPort = 80;       
>$dataSourceType = 'mysql'
>
>Do I still need the $webCompanionPort?  Are all the rest of the calls the same?
>
>Any advice would be greatly appreciated.
>
>Thanks
>
>Stephen
>
>ps.  I can't seem to find a way to search through the fx.php_list archive.  
>Considering the is a database list, I thought searching would be a great option 
>:)
>
>
>
> _______________________________________________
>FX.php_List mailing list
>FX.php_List at mail.iviking.org
>http://www.iviking.org/mailman/listinfo/fx.php_list
>

Steve Winter
steve at bluecrocodile.co.nz
m: +44 77 7852 4776
3 Calshot Court, Channel Way
Ocean Village, Southampton SO14 3GR 



      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.iviking.org/pipermail/fx.php_list/attachments/20100812/87912a25/attachment.html