Comment by nawaryoussef1 on February 11, 2012 at 1:04 am
very nice tutorial and I really hard to find such tutorials like this, I am almost finishing my frist book about php and databases, so after that I am gonna watch all video you are published here, I am sure all of them are powerful like this one, thanks
Comment by iceman11a on February 11, 2012 at 1:44 am
Hi! PHPClass, Thanks for the tutorial. I just have one question for you. I wanted the _DbConnect() to read values passed in from a config.php file. For some reason, I can’t get the class to read the values.
$settings['db_host']; $settings['db_name']; $settings['db_user']; and $settings['db_pass']; I have this at the top of the php script before the class. require_once ‘config.php’;
Thanks
Joe
Comment by notjustyeti on February 11, 2012 at 2:19 am
Thx. You should cap this example off by making the table-name and column-names as parameters to the functions — then people can actually re-use the code w/o modification for *any* db table.
Comment by mrtrippingballs on February 11, 2012 at 3:16 am
You have officially half opened up another world to me… Can you please keep this goin?
Comment by Ilija26 on February 11, 2012 at 3:56 am
Subscribed, -> Nice tut! You’re professional php developer. At what university have you been?
Comment by 7715z on February 11, 2012 at 4:12 am
Will the site be laggy becouse you are connecting to the DB every time you create new function..
Comment by wzazza on February 11, 2012 at 5:12 am
please – change keyboard!!
with some softer button pushing.
absolutely needed!
Comment by mariotejutub on February 11, 2012 at 5:51 am
To find out how many images have you uploaded isn’t enough mysql_num_rows()?
I think it would be more easy than the example that you gave. Nice tutorial though.
Comment by MrCaper58 on February 11, 2012 at 6:00 am
when do you close the connection to the DB?
Comment by YourGodAlmighty on February 11, 2012 at 6:06 am
@sachav1993 Yea it is a disadvantage =/. Oh, on your previous question the answer is yes. Using mysql_connection in the static class will create a unique connection each time it is called. I used mysql_connection in this tutorial in order to direct the focus on using a static class. In the next tutorial I am going to show how to create a single and reusable mysql connection throughout your scripts.
Comment by sachav1993 on February 11, 2012 at 6:16 am
@phpclass Yeah, the instanciation is the disadvantage :/
Comment by sachav1993 on February 11, 2012 at 6:27 am
@phpclass Well, yeah, but if you call mysql_connect twice, then 2 connections thus 2 links be made right (1 when you call DataManager::getUploadCount() and 1 for DataManager::getUploadImages())? Or will they just reference each other? (in which case, I’d have underesteemed PHP’s internal optimization)
Comment by sachav1993 on February 11, 2012 at 7:00 am
@phpclass Okay, thanks
Comment by phpclass on February 11, 2012 at 7:33 am
@sachav1993 There is also the problem of having to instantiate an object every time you want to connect to a database. It is conventionally approached that way, but as you start to learn more about OO PHP, you will realize that it is not a flexible approach. Remember, just because it OO PHP doesn’t mean that everything has to be an object. There are static, abstract, interfaces, etc that a lot of people do not know how to really use.
Comment by phpclass on February 11, 2012 at 8:10 am
@sachav1993 Also, the mysql connection automatically closes at the end of every script. So, the use of mysql_connect in this static class is no different if you were to use mysql_connect at the top of a script. Hence,there is no extra resources being used. The method used in the tutorial allows programmers to limit the amount of code duplication and increases code re-usability, efficiency, and simplicity.
Comment by phpclass on February 11, 2012 at 9:01 am
@sachav1993 Actually, this tutorial is a complement of another tutorial I will be releasing soon that has to do with the PDO connection class. I stated this in the tutorial at 0:50. It will be replacing the normal mysql_connect with a PDO class object. This object will check whether a connection has already been established. If so then return the connection reference. If not, then return a new connection.
Comment by sachav1993 on February 11, 2012 at 9:32 am
Nice tutorial, one thing though: why are you using static methods?
Because, isn’t calling self::_dbConnect() at every method going to use up a lot of resources, especially if the MySQL server is remote?
What I personally would do, is create a private attribute ($mysql_link for instance), and assign its value to a connection in __construct(), and use this connection link whenever I need it in the class.
Of course, I’d have to instanciate though, since I’d be using $this->mysql_link.
Comment by phpclass on February 11, 2012 at 9:35 am
@budarmstrong Hello, thank you for your question. Unfortunately, you cannot access dbConnect() function through a class object because it is a static function. Static functions are usually known as standalone class functions that do not depend on any class methods or class members. Static function are easier to access because you do not need to create a class object to access them. I hope that answered your question.
Comment by budarmstrong on February 11, 2012 at 9:36 am
First I want to say how helpful these tutorials are. It is very difficult to extrapolate information from books on OOP PHP. Hey, is “DataManager::_DBConnect” the same as say “$a = new DataManager(); $a->_DBConnect” or “self::_DBConnect” the same as “$this->DBConnect()”?
Comment by donadm on February 11, 2012 at 10:32 am
what I try to accomplish is:
how does that work with:
@new mysqli()… within the _dbConnect static function??
Comment by ndableg on February 11, 2012 at 11:10 am
you have great videos. Thanks!
Comment by phpclass on February 11, 2012 at 11:50 am
Try osCommerce. I heard its pretty decent.
Comment by Sensity1337 on February 11, 2012 at 12:26 pm
I will try joomla, btw you know a Opensource webshop?
Comment by phpclass on February 11, 2012 at 12:46 pm
Oh I see. I could help you but at some point you would probably get lost in the code. If your planning to start a very simple site (e.g. online blog) then I would recommend downloading joomla. Its a powerful content management system that does what your looking for, and can get you up and started in no time.
Comment by Sensity1337 on February 11, 2012 at 1:39 pm
@phpclass
so ppl can register and login ind and edit info.
Admin can ban and add others admin
Sorry for my bad english.
About this blog
This blog is dedicated to showcasing great web design as well as providing advice and tips to any aspiring web designers out there. Hopefully these articles will aid you in your design and development.
25 comments
Comment by nawaryoussef1 on February 11, 2012 at 1:04 am
very nice tutorial and I really hard to find such tutorials like this, I am almost finishing my frist book about php and databases, so after that I am gonna watch all video you are published here, I am sure all of them are powerful like this one, thanks
Comment by iceman11a on February 11, 2012 at 1:44 am
Hi! PHPClass, Thanks for the tutorial. I just have one question for you. I wanted the _DbConnect() to read values passed in from a config.php file. For some reason, I can’t get the class to read the values.
$settings['db_host']; $settings['db_name']; $settings['db_user']; and $settings['db_pass']; I have this at the top of the php script before the class. require_once ‘config.php’;
Thanks
Joe
Comment by notjustyeti on February 11, 2012 at 2:19 am
Thx. You should cap this example off by making the table-name and column-names as parameters to the functions — then people can actually re-use the code w/o modification for *any* db table.
Comment by mrtrippingballs on February 11, 2012 at 3:16 am
You have officially half opened up another world to me… Can you please keep this goin?
Comment by Ilija26 on February 11, 2012 at 3:56 am
Subscribed, -> Nice tut! You’re professional php developer. At what university have you been?
Comment by 7715z on February 11, 2012 at 4:12 am
Will the site be laggy becouse you are connecting to the DB every time you create new function..
Comment by wzazza on February 11, 2012 at 5:12 am
please – change keyboard!!
with some softer button pushing.
absolutely needed!
Comment by mariotejutub on February 11, 2012 at 5:51 am
To find out how many images have you uploaded isn’t enough mysql_num_rows()?
I think it would be more easy than the example that you gave. Nice tutorial though.
Comment by MrCaper58 on February 11, 2012 at 6:00 am
when do you close the connection to the DB?
Comment by YourGodAlmighty on February 11, 2012 at 6:06 am
@sachav1993 Yea it is a disadvantage =/. Oh, on your previous question the answer is yes. Using mysql_connection in the static class will create a unique connection each time it is called. I used mysql_connection in this tutorial in order to direct the focus on using a static class. In the next tutorial I am going to show how to create a single and reusable mysql connection throughout your scripts.
Comment by sachav1993 on February 11, 2012 at 6:16 am
@phpclass Yeah, the instanciation is the disadvantage :/
Comment by sachav1993 on February 11, 2012 at 6:27 am
@phpclass Well, yeah, but if you call mysql_connect twice, then 2 connections thus 2 links be made right (1 when you call DataManager::getUploadCount() and 1 for DataManager::getUploadImages())? Or will they just reference each other? (in which case, I’d have underesteemed PHP’s internal optimization)
Comment by sachav1993 on February 11, 2012 at 7:00 am
@phpclass Okay, thanks
Comment by phpclass on February 11, 2012 at 7:33 am
@sachav1993 There is also the problem of having to instantiate an object every time you want to connect to a database. It is conventionally approached that way, but as you start to learn more about OO PHP, you will realize that it is not a flexible approach. Remember, just because it OO PHP doesn’t mean that everything has to be an object. There are static, abstract, interfaces, etc that a lot of people do not know how to really use.
Comment by phpclass on February 11, 2012 at 8:10 am
@sachav1993 Also, the mysql connection automatically closes at the end of every script. So, the use of mysql_connect in this static class is no different if you were to use mysql_connect at the top of a script. Hence,there is no extra resources being used. The method used in the tutorial allows programmers to limit the amount of code duplication and increases code re-usability, efficiency, and simplicity.
Comment by phpclass on February 11, 2012 at 9:01 am
@sachav1993 Actually, this tutorial is a complement of another tutorial I will be releasing soon that has to do with the PDO connection class. I stated this in the tutorial at 0:50. It will be replacing the normal mysql_connect with a PDO class object. This object will check whether a connection has already been established. If so then return the connection reference. If not, then return a new connection.
Comment by sachav1993 on February 11, 2012 at 9:32 am
Nice tutorial, one thing though: why are you using static methods?
Because, isn’t calling self::_dbConnect() at every method going to use up a lot of resources, especially if the MySQL server is remote?
What I personally would do, is create a private attribute ($mysql_link for instance), and assign its value to a connection in __construct(), and use this connection link whenever I need it in the class.
Of course, I’d have to instanciate though, since I’d be using $this->mysql_link.
Comment by phpclass on February 11, 2012 at 9:35 am
@budarmstrong Hello, thank you for your question. Unfortunately, you cannot access dbConnect() function through a class object because it is a static function. Static functions are usually known as standalone class functions that do not depend on any class methods or class members. Static function are easier to access because you do not need to create a class object to access them. I hope that answered your question.
Comment by budarmstrong on February 11, 2012 at 9:36 am
First I want to say how helpful these tutorials are. It is very difficult to extrapolate information from books on OOP PHP. Hey, is “DataManager::_DBConnect” the same as say “$a = new DataManager(); $a->_DBConnect” or “self::_DBConnect” the same as “$this->DBConnect()”?
Comment by donadm on February 11, 2012 at 10:32 am
what I try to accomplish is:
how does that work with:
@new mysqli()… within the _dbConnect static function??
Comment by ndableg on February 11, 2012 at 11:10 am
you have great videos. Thanks!
Comment by phpclass on February 11, 2012 at 11:50 am
Try osCommerce. I heard its pretty decent.
Comment by Sensity1337 on February 11, 2012 at 12:26 pm
I will try joomla, btw you know a Opensource webshop?
Comment by phpclass on February 11, 2012 at 12:46 pm
Oh I see. I could help you but at some point you would probably get lost in the code. If your planning to start a very simple site (e.g. online blog) then I would recommend downloading joomla. Its a powerful content management system that does what your looking for, and can get you up and started in no time.
Comment by Sensity1337 on February 11, 2012 at 1:39 pm
@phpclass
so ppl can register and login ind and edit info.
Admin can ban and add others admin
Sorry for my bad english.