Anyone done anywork with KM and MySql?

[dniezby]

My title says it all. Anyone have any samples blending KM and MySql?

I know Blanius was doing some work with MySql and 3dfa but KM is a whole new ball of wax.

[Chris_Seahorn]

My site is KM and SQL. The one I coded right after I bought Koolmoves was as well. KM and MySQL are the dynamic duo.

One of Wilberts components has an example (with included backside) to connect the KRecordSet to a SQL database and would be worth a look if that interests you. Should be in one of the examples subfolders.

[dniezby]

Thanks...I'll look through the Samples again...I must have missed it.

Is that the name of the file? KRecordSet

[blanius]

Not very different the PHP is the same for both. KM actually is way better at handling the data.

[dniezby]

I figured as much.
I just have to refresh my code memory on the steps.
I want to try and build an interface for phpwebsite because I love the way it works with the database, hate the way it interacts with the viewer.

Using the flash with MySql and php should allow me to make use of the current website's code without major coding...(If I'm right.)

My current site (mostly crap right now) is a phpwebsite.

[blanius]

Dave the big thing you have with KM that 3dfa lacked was the onData function....

Something I've done is to create an empty movieclip to hold the data that way it won't conflict with any root movie variables.

this.createEmptyMovieClip("myData", this.getNextHighestDepth());

myData.onData = function() {
    //this is exectuded when the data has actually loaded.
}

myData.loadVariables("getdata.php");

you can then always refer to the loaded variables as myData.variableName

[Chris_Seahorn]

that way it won't conflict with any root movie variables.

_lockroot helps with that as well

[blanius]

What I'm refering to is if you Use LoadVariables on the root movie it would overwrite any variables that might have the same name. I realize that this is not likely but also I think it's the only way to have access to the onData statement. I might be wrong on that point however.

[Chris_Seahorn]

Well, onData is an event handler and would not protect variables in the root or clip loaded in. It just notifies you the data is received.

_lockroot can be applied to the root or clip in these cases and would.

Dniezby's biggest challenge is to have his current pages converted to send in variables Flash can understand and will most likely become familiar with onData and _lockroot in the process. onData is also a large part of XML object usage as well as loadVars (the current defacto standard) objects.

_lockroot is handy, especially for loading movies that were meant to be the root themselves. If I load for instance my Radio Blog or *****.com's FlashChat( a hard coded swf meant to be loaded in a html page but not another flash movie) in my interface, it will fail unless I use _lockroot.

[blanius]

I used lockroot in my photo gallery as well for the same reason. If he coded the PHP he'll be fine it's not that hard to recode to send as vars instead.

[Chris_Seahorn]

If he coded the PHP he'll be fine it's not that hard to recode to send as vars instead.

Should be a breeze

[Chris_Seahorn]

I'm coding some flash graphing based on MySQL returns Dniezby and two are building online if you care to see them. They are in my "Modules" menu.

Depending on what field I tell the graphs to base their count on, they animate themselves into place creating a visual, color coded graph. Each pushes dynamic data into a mouseover specific to the graph bar which has Flash8 filtering applied.

They are realtime and if you go and read an article or download a file from a file blog, when you return to the graphs you will see the values have been added.

This is the kind of stuff I have coming down the road.

[dniezby]

Sorry guys...I was having connection problems. I just got these replies. I'll check out the information you're talking about and get back this thread.
Thanks for the input. I'm glad to see it's a topic of interest.
-Dave

[dniezby]

Wow Chris, you've been busy. Your site is really looking great.

I can only hope I will be able to learn server interaction to your level.

[Chris_Seahorn]

You will. It's gonna end up a download.

Right now I'm setting up satellites that will let users run my website from their desktop (kiosk). They include installer/uninstaller and I just tested one to make sure all the modules would fire ok. These will be made in all different colors and will most likely be set to timeout after 30 days so users are forced to stay current. I actually prefer the kiosk version so I think I'll be using it exclusively myself and I'll add some coding to Feedstar to show and track kiosk connections versus HTTP connections so it should be fun.

EDIT: Added first satellite. See file blog section.

[Chris_Seahorn]

I added screen capturing to the kiosks.

The kiosks allow me some extra benefits of activeX controls that can be tied into "draw directly to photoblog" routines or really anything you can imagine. I purposely designed the file blog structure to easily handle itself as a photoblog for this reason to save coding time.

I know a lot of users can't make kiosks or even want to and Feedstar as a download will be a web based interface. They can...if they have the extra software...make it any kiosk they want. I'm doing this for extra eye candy because if and when I get this admin panel built and drop this puppy on opensourcecms.com....there will be a lot of people going "hmmmm....what is Koolmoves " The owner asked me a year ago to offer one I made with Swishmax because users are always asking about it in his forum. The thing is...you're %^&* better be tight because these people are a tough crowd. I didn't think that Swishmax interface could make the grade. I think Koolmoves code can hold it's own. Time will tell. I just have to make it all work.