Nameless Posted October 25, 2014 Share Posted October 25, 2014 Hi there, Just a quick question. Is it still okay to use MySQL - Or is it absolutely required to upgrade and use MySQLi? Thanks. Quote Link to comment Share on other sites More sharing options...
KyleMassacre Posted October 25, 2014 Share Posted October 25, 2014 I would use mysqli because mysql is being or has been deprecated depending on your set up. Plus it's a tad bit more secure than mysql Quote Link to comment Share on other sites More sharing options...
Nameless Posted October 25, 2014 Author Share Posted October 25, 2014 I would use mysqli because mysql is being or has been deprecated depending on your set up. Plus it's a tad bit more secure than mysql Ah okay, Well I've been creating a game for the past 10/11 months. It uses MySQL. And I've recently been told "I must" use MySQLi, So not to release the game... Quote Link to comment Share on other sites More sharing options...
KyleMassacre Posted October 25, 2014 Share Posted October 25, 2014 Ah okay, Well I've been creating a game for the past 10/11 months. It uses MySQL. And I've recently been told "I must" use MySQLi, So not to release the game... Well no one can really tell you what you can or cannot use unless it's a client. Can I ask if your using a particular engine? Or is this all custom from scratch. The reason I ask is because a lot of people here use MCC and it's just a simple 1 letter change to enable mysqli but if not then I'm sorry, there will be no easy way to change what you have done. Quote Link to comment Share on other sites More sharing options...
Nameless Posted October 25, 2014 Author Share Posted October 25, 2014 Well no one can really tell you what you can or cannot use unless it's a client. Can I ask if your using a particular engine? Or is this all custom from scratch. The reason I ask is because a lot of people here use MCC and it's just a simple 1 letter change to enable mysqli but if not then I'm sorry, there will be no easy way to change what you have done. It's using MCCodes V2.0.5b Quote Link to comment Share on other sites More sharing options...
KyleMassacre Posted October 25, 2014 Share Posted October 25, 2014 Ok then if you use the $db class just go to config.php and chula gd where it says mysql to mysqli Quote Link to comment Share on other sites More sharing options...
Nameless Posted October 25, 2014 Author Share Posted October 25, 2014 Ok then if you use the $db class just go to config.php and chula gd where it says mysql to mysqli Oh wow, It's as simple as that? Quote Link to comment Share on other sites More sharing options...
KyleMassacre Posted October 25, 2014 Share Posted October 25, 2014 Pretty much :p Quote Link to comment Share on other sites More sharing options...
Nameless Posted October 25, 2014 Author Share Posted October 25, 2014 Pretty much :p Thank you, Kyle. Quote Link to comment Share on other sites More sharing options...
lucky3809 Posted October 25, 2014 Share Posted October 25, 2014 You should not only change the class to Myqli you should also start coding using mysqli so you are familiar with it and use to using it. x10hosting just changed their php I noticed last month which now gives errors when you use mysql in the error.php because it's all deprecated, but my main host has not upgraded yet to it. Guess it also depends on your host. Quote Link to comment Share on other sites More sharing options...
Zettieee Posted October 25, 2014 Share Posted October 25, 2014 You might run into some errors with just changing the the config. I'm not 100% how mcc works anymore. But if it uses a lib for mysql/i_* then what kyle said should work. If not you could always just make a simple mysqli lib yourself :) Quote Link to comment Share on other sites More sharing options...
Script47 Posted October 25, 2014 Share Posted October 25, 2014 It will be worth it in the end to change now, seeing as you'll have to at some point so you might as well do it now. Quote Link to comment Share on other sites More sharing options...
SRB Posted October 25, 2014 Share Posted October 25, 2014 Warning: - any custom pages which directly calls mysql_ functions will break. This is because the class will call a mysqli connection, rendering mysql_ functions with no connection info. So, in short, if you have any pages that do not use the database class ($db->query() etc), they need updating to run through the class. Quote Link to comment Share on other sites More sharing options...
Nameless Posted October 25, 2014 Author Share Posted October 25, 2014 I would like to thank everyone that has replied to this thread, You've all been very helpful. I will now remember to only use $db->query() Thank you all! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.