Archive for the Category MySQL

 
 

Extending mysqli class with example

PHP’s mysqli extension is a great starting point for your OOP type access to MySQL server. Here’s a simple example and some possible features for you to explore using base mysqli class provided by PHP and extending it to suite your needs.

DELETE with JOIN

This article will explain how to delete data from one table based on data in another table – how to use JOIN in DELETE queries.


| Read more …

MySQL JOIN Explained

While selecting data from MySQL server, we can join tables in three basic ways. Using JOINLEFT JOIN and/or RIGHT JOIN. In this post, I’ll try to put all those three in practice.

| Read more …

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close