User Tag List

Page 1 of 2 1 2 LastLast
Results 1 to 10 of 11

Thread: [Request] Online mySQL Extension

  1. #1
    Clicker Fusion 2.5 Developer

    Join Date
    Jan 2007
    Location
    USA
    Posts
    691
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    [Request] Online mySQL Extension

    I don't know if this can be accomplished, but I would like to be able to use the MySQL query commands from within MMF connecting to an online mySQL server. I know all of the current sql extensions can only do this locally.

  2. #2
    Clicker Fusion 2.5 DeveloperAndroid Export ModuleiOS Export ModuleSWF Export Module

    Join Date
    Jul 2006
    Location
    England
    Posts
    820
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: [Request] Online mySQL Extension

    You could use the Live Receiver object to connect to a php script?

  3. #3
    Clicker Fusion 2.5 DeveloperHTML5 Export Module

    Join Date
    Jun 2006
    Posts
    1,461
    Mentioned
    10 Post(s)
    Tagged
    0 Thread(s)

    Re: [Request] Online mySQL Extension

    Try this link?

    http://www.devarticles.com/c/a/MySQL/Using-MyODBC-to-Connect-to-a-Remote-Database/

  4. #4
    Clicker Fusion 2.5 Developer

    Join Date
    Jan 2007
    Location
    USA
    Posts
    691
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: [Request] Online mySQL Extension

    Quote Originally Posted by Steven
    You could use the Live Receiver object to connect to a php script?
    How would I be able to use the "SELECT * FROM table" query straight from MMF with this extension?

  5. #5
    No Products Registered

    Join Date
    Dec 2006
    Posts
    1,332
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: [Request] Online mySQL Extension

    You would have to have a PHP script uploaded to your server that has that command in it. You access the script using the Live Receiver.

  6. #6
    Forum Moderator Fusion 2.5 DeveloperHTML5 Export ModuleiOS Export ModuleSWF Export Module
    DavidN's Avatar
    Join Date
    Jun 2006
    Location
    Boston, MA, USA
    Posts
    4,044
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: [Request] Online mySQL Extension

    The trouble with trying to query a database directly from MMF is that most MySQL servers block connection attempts from anything but the local host, so it's a problem on that end rather than the existing extensions.

  7. #7
    No Products Registered

    Join Date
    Dec 2006
    Posts
    1,332
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: [Request] Online mySQL Extension

    Quote Originally Posted by DavidN
    The trouble with trying to query a database directly from MMF is that most MySQL servers block connection attempts from anything but the local host, so it's a problem on that end rather than the existing extensions.
    But if the PHP file is directly on the server, why not just use localhost. That's what I do and it works fine.

  8. #8
    Clicker Fusion 2.5 Developer

    Join Date
    Jan 2007
    Location
    USA
    Posts
    691
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: [Request] Online mySQL Extension

    That is usually true, however, on the webserver that I use, the database is on a different server name.

    I'll try to use the live receiver object, but can you receive variables from that?

  9. #9
    Clicker Fusion 2.5 DeveloperAndroid Export ModuleiOS Export ModuleSWF Export Module

    Join Date
    Jul 2006
    Location
    England
    Posts
    820
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: [Request] Online mySQL Extension

    It just picks up the output, so just echo the stuff you want and split it up with a unique character like ';' and then use the string parser object to get the stuff you want.

  10. #10
    Clicker Fusion 2.5 DeveloperAndroid Export ModuleHTML5 Export ModuleSWF Export ModuleInstall Creator ProPatch Maker
    Fusion 2.5 (Steam)Fusion 2.5 Developer (Steam)Fusion 2.5+ DLC (Steam)Android Export Module (Steam)HTML5 Export Module (Steam)iOS Export Module (Steam)Universal Windows Platform Export Module (Steam)
    DJFuego's Avatar
    Join Date
    Jul 2006
    Location
    UK
    Posts
    1,411
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Re: [Request] Online mySQL Extension

    On MYSQL You can use odbc connecter it's an odbc driver so you can use this to connect directly to the DB over the network/internet. Only problem is you have to allow your IP address from the DB side.
    The PHP way is the only other way unless the DB is Local.

    You may be able to use the MSOffice SDK and connect to a ms access database over ODBC.

Page 1 of 2 1 2 LastLast

Similar Threads

  1. MMF2 Extension Request : OE-Cake Fluid extension
    By pyromane in forum Extension Development
    Replies: 5
    Last Post: 1st July 2013, 04:51 AM
  2. Online Scores using PHP/mySQL - Choosing what number to submit?
    By Xeeko in forum Multimedia Fusion 2 - Technical Support
    Replies: 2
    Last Post: 2nd November 2011, 12:11 AM
  3. [Extension Request] MySQL flash
    By NeoMonkey in forum SWF/Flash Export Module Version 2.0
    Replies: 6
    Last Post: 9th August 2011, 07:34 AM
  4. [REQUEST] MySQL database
    By Dynamite in forum Extension Development
    Replies: 2
    Last Post: 10th March 2010, 06:08 AM
  5. [Request] MySQL Object
    By dingdong in forum Extension Development
    Replies: 9
    Last Post: 15th December 2008, 04:16 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •