This short course will show you how to integrate a database using the MySQLi extension for PHP. The developers of the PHP programming language recommend using MySQLi when dealing with MySQL server versions 4.1.3 and newer (takes advantage of new functionality).
Benefits of MySQLi
- An object-oriented interface
- Support for prepared statements
- Support for multiple statements
- Support for transactions
- Enhanced debugging support
- Embedded server support
A knowledge of PHP and MySQL is recommended for this course.
Your Instructor
At Stone River eLearning, we call ourselves the Online Technology Bootcamp because technology is all we teach. Whatever you're interested in from programming to web and mobile development to graphic and web design - we have it covered.
Check out our huge catalog of courses and join the over 250,000 students currently taking Stone River eLearning courses. We currently offer over 150 different technology training courses on our Stone River eLearning website and are adding 5-10 new courses per month. A subscription option is available for those with a real passion for learning.
Course Curriculum
-
StartConnecting To A Database (7:55)
-
StartConnecting Using PHP (9:42)
-
StartCreating a Database Table (3:38)
-
StartPulling Single Records (4:43)
-
StartPulling Multiple Records (9:11)
-
StartDifferent Result Types (5:26)
-
StartFree Result (2:48)
-
StartCounting Results (9:25)
-
StartUpdating and Affected Rows (4:46)
-
StartEscaping (12:33)
-
StartPrepared Statements for Inserting (8:14)
-
StartSelecting Prepared Statements (5:42)
-
StartClosing the Database Connection (2:14)