GarrettW Posted May 14, 2009 Share Posted May 14, 2009 New member here! I've just started writing a CMS (more or less from scratch), and I'm at the point where I'm writing the database abstraction class. (Yes, I'm doing it in PHP 5 OOP.) I've done a search on here for "mysql vs mysqli" and gathered that the general opinion around here is that mysqli is the one to use. I'd agree, especially because I like the OO-ness of it -- but since what I'm writing will be used by people on all kinds of servers, I'm torn over whether I should use mysqli or the older mysql functions. How widespread is the mysqli extension? I have no qualms about requiring PHP 5 for my script, but if I'm correct, mysqli isn't compiled into PHP by default, so how likely would it be for any given user to have mysqli installed? Lastly, I've noticed that most big-name PHP packages (including Wordpress) use mysql - so again, is there a legitimate compatibility concern here? Quote Link to comment https://forums.phpfreaks.com/topic/158107-solved-usage-of-mysql-vs-mysqli/ Share on other sites More sharing options...
Mchl Posted May 14, 2009 Share Posted May 14, 2009 mysql isn't compiled into PHP by default either (used to be, but it is no longer). Go with mysqli. Most hostings support both extensions. Quote Link to comment https://forums.phpfreaks.com/topic/158107-solved-usage-of-mysql-vs-mysqli/#findComment-833982 Share on other sites More sharing options...
dgoosens Posted May 14, 2009 Share Posted May 14, 2009 I agree... mysqli is much better... but why are you writing an DB-abstraction class ?? have a look at PDO http://be.php.net/manual/en/book.pdo.php the job has been done already... Quote Link to comment https://forums.phpfreaks.com/topic/158107-solved-usage-of-mysql-vs-mysqli/#findComment-833987 Share on other sites More sharing options...
GarrettW Posted May 14, 2009 Author Share Posted May 14, 2009 well, maybe that's not what i was supposed to call it. it's technically not an interface (since it's a class), but "interface" is more of the idea. I'm writing the M in MVC. (MVC is what I'm trying to achieve - we'll see how close I end up getting ) and thanks for the recommendations. Quote Link to comment https://forums.phpfreaks.com/topic/158107-solved-usage-of-mysql-vs-mysqli/#findComment-833989 Share on other sites More sharing options...
dgoosens Posted May 14, 2009 Share Posted May 14, 2009 hi GarrettW, OK... in that case you might want to check out a framework... they come with a whole bunch of usefull classes, including classes for database abstraction... I personaly work with Zend Framework... but there are many others: ZF 1.8 : http://framework.zend.com/ the DB part : http://framework.zend.com/manual/en/zend.db.html Quote Link to comment https://forums.phpfreaks.com/topic/158107-solved-usage-of-mysql-vs-mysqli/#findComment-833994 Share on other sites More sharing options...
GarrettW Posted May 14, 2009 Author Share Posted May 14, 2009 I thought about going that route - but I'd rather write everything from the ground up, so that (1) I know the code intimately and have complete control over it, and (2) I end up learning more in the process. It is quite an ambitious project that I'm working on, but it'll be good for me. Also, this is my first real encounter with OO-PHP. Quote Link to comment https://forums.phpfreaks.com/topic/158107-solved-usage-of-mysql-vs-mysqli/#findComment-833999 Share on other sites More sharing options...
dgoosens Posted May 14, 2009 Share Posted May 14, 2009 in that case... you're damn right doing so... enjoy !! Quote Link to comment https://forums.phpfreaks.com/topic/158107-solved-usage-of-mysql-vs-mysqli/#findComment-834000 Share on other sites More sharing options...
GarrettW Posted May 14, 2009 Author Share Posted May 14, 2009 thanks I'm sure I'll be around here a good bit in the time to come. also, I was just thinking - I'm not familiar with any "big-name" pieces of PHP software that were built from one of those pre-made frameworks. Quote Link to comment https://forums.phpfreaks.com/topic/158107-solved-usage-of-mysql-vs-mysqli/#findComment-834003 Share on other sites More sharing options...
starphp Posted May 14, 2009 Share Posted May 14, 2009 Can you suggest any simple package for running the MySql functions instead of the mysql_functions ? I found in some packages, they re written the MySql function by their function names.. Which will give more security.. And also easy for error logging.. Quote Link to comment https://forums.phpfreaks.com/topic/158107-solved-usage-of-mysql-vs-mysqli/#findComment-834006 Share on other sites More sharing options...
GarrettW Posted May 14, 2009 Author Share Posted May 14, 2009 i'm not sure exactly what you're asking. Quote Link to comment https://forums.phpfreaks.com/topic/158107-solved-usage-of-mysql-vs-mysqli/#findComment-834010 Share on other sites More sharing options...
starphp Posted May 14, 2009 Share Posted May 14, 2009 Suppose, we need to run a query, then use the following: mysql_query() But most of the open source package, rewrite this with their MySql function, like this: code_mysql_query($sql); function code_mysql_query($sql) { mysql_query($sql); } I wish to find a package which has the complete list of MySql functions like this.. Quote Link to comment https://forums.phpfreaks.com/topic/158107-solved-usage-of-mysql-vs-mysqli/#findComment-834021 Share on other sites More sharing options...
Mchl Posted May 14, 2009 Share Posted May 14, 2009 What's the point of doing something like this? Complete list of ext/mysql functions is in manual mysql Quote Link to comment https://forums.phpfreaks.com/topic/158107-solved-usage-of-mysql-vs-mysqli/#findComment-834042 Share on other sites More sharing options...
starphp Posted May 14, 2009 Share Posted May 14, 2009 I don't know the advantages of this method. But some of them, I think: 1. Suppose, if I need to log the errors by using my own method during the query execution, then it is possibly by editing a single function. This will helps to time to open all pages which has the mysql code. 2. Escaping can be accomplished.. Quote Link to comment https://forums.phpfreaks.com/topic/158107-solved-usage-of-mysql-vs-mysqli/#findComment-834162 Share on other sites More sharing options...
Mchl Posted May 14, 2009 Share Posted May 14, 2009 I don't know the advantages of this method. But some of them, I think: 1. Suppose, if I need to log the errors by using my own method during the query execution, then it is possibly by editing a single function. This will helps to time to open all pages which has the mysql code. 2. Escaping can be accomplished.. You'd need a bit more sophisticated functions than the one you posted though... Quote Link to comment https://forums.phpfreaks.com/topic/158107-solved-usage-of-mysql-vs-mysqli/#findComment-834227 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.