Using OOP PHP to select, update, and insert data in a mysql database -- Part 2

Mythriel23 Says:

May 11, 2011 - mysqli is not object oriented....PDO is... nice tut, but I advice you to use PDO in your projects

HuotMediaDesigns Says:

May 12, 2011 - I have looked into PDO in the past but never really got around to implementing it into a project. Most of the frameworks I have used (projects others have started) were using the regular mysql connect or mysqli. Its going to be a bit before I can get more vids on here, just so swamped with work at the moment. Ill let you know once I get some videos up on OOP php.

naijatell Says:

Oct 5, 2011 - i have this error an I can't even debug itFatal error: Non-abstract method database::loadObjectList() must contain body in C:\xampp\htdocs\class_lessons\database.class.php on line 45 public function doQuery($sql) { $this->results = mysqli_query($this>connnection, $sql); $this->numRows = $this->results->num_rows; } public function loadObjectList(); { $obj = "No Results"; if ($this->results) { $obj = mysqli_fetch_assoc($this->results); } return $obj; }all codes d same

HuotMediaDesigns Says:

Oct 6, 2011 - Try changing public function loadObjectList();topublic function loadObjectList() -- No semicolon.The semicolon at the end tells php to stop that function there and it never sees the body of the function even though it is there. Give that a try and let me know if you have any other problems.Best,Nick

toxck Says:

Dec 6, 2011 - what software you are using?

HuotMediaDesigns Says:

Dec 6, 2011 - I am using zends PDT (php developer tools) version of eclipse for development. I have since changed to Aptana studio. I feel aptana is better suited for website development out of the box. For recording, its Camtasia Studio, and running XAMPP for a local webserver. I have vidoes on setting up xampp if you would like.

toxck Says:

Dec 7, 2011 - thanks i just want to know what php editor so its eclipse. thanks again!

HuotMediaDesigns Says:

Dec 7, 2011 - If you decide to use Eclipse for php. Go to Zend.com and you will see "Eclipse Php Development Tools" under the Community menu item. Download this as it is more configured for php development. I would recommend aptana over Eclipse (they are both eclipse based), because it is more configured for web development out of the box (ie. code hinting for css, what is compatible in different browsers, etc). Aptana still as access to the eclipse repositories as well if needed. Best, Nick

91KKiran Says:

Apr 10, 2012 - Dude, nice video but upload the code!

xound101 Says:

Apr 23, 2012 - is here any video which will basic about delte and edit msql from query plz

HuotMediaDesigns Says:

Apr 30, 2012 - I have a crash course video on mysql that introduces the basics but I need to expand upon it in the future. Watch my Mysql Crash Course video. It should get you started, jump to 11:00 in the video to avoid all the intro stuff!Best,Nick