[Request] MySQL Object

Well if anyone is going to make it, I'm pretty sure Byo will when he has some spare time. I asked a while ago. I think the MSSql server object would be more useful from a MMFDev point of view. I think a cash insentive would spur someone on to make it quicker

Hi, guys.

It's a great idea but I think I'm not up to the task since I've never used or seen MySql in action. SQL Server and SQLite3 were not a problem because I use them on a daily basis.

But yes, if I can find some time to study a little about deploying MySQL and connecting to it I will surely want to start working on it. You can count on me, of course. But I can't promise anything since work, study and wife are taking me away from what I like to do.

One of the problems with an mySQL object is you have to find a host or run mySQL so it accepts remote connections if you want your mySQL running on a webserver.

99% of the shared hosts run it so it only connects via "localhost" or scripts must reside inside the local network. So remote calls from outside won't work.

This is due because hackers love to hack into mySQL databases and with remote connections they can just sit back and hack away.

Long long long ago -- A person made a mySQL object for MMF 1.2 and this issue kept everyone from using it as no host runs in such an open hacker attracting environment.

I think what you will need is an object that also comes with a specially designed php script -- the object would communicate with the script -- The script would communicate with mySQL and return the result to the script.

I don't think you'll ever see anything that can communicate directly with mySQL on a webserver.

Quote

I think what you will need is an object that also comes with a specially designed php script -- the object would communicate with the script -- The script would communicate with mySQL and return the result to the script.

Perhaps a widget based on Live Receiver?

Right now my current project is able to connect with mySQL by use of the vitalize object.

It uses some tricky ajax allowing it to send info to php. The php sends a request then outputs it back into the program. If anyone asks I can send them my code and/or walk them through it.

Jakinbandw, just be careful that one cannot insert native SQL through one of the parameters in your PHP page.

Although, I use a similar approach at work... if many clients are to use the application, I make .aspx files to connect to instead, port 80 and parameters are very flexible and expandable.

Also, making different clients is now easy, I easily made other clients in BAT script (it's called that?), VBA, C#... Life's good now, lol!

normal XSS protection + a hash check to make sure that it was the cnn that sent the info is what I use.

Also I am not a great programmer, still in first year at university. I learned php to help a guy with his website. I don't even know html that well. ><

On the other hand I am good at finding things and making them work so that was how I got the ajax working.