Tips & Tutorials – SQL

MYSQL vs MYSQLI vs PDO in PHP (Which One To Use!?)

Welcome to a quick tutorial on the difference between MySQL, MySQLi, and PDO in PHP. So you may have just started working with MySQL in PHP, and noticed that there are 3 different extensions to work with the database. The main difference between the MySQL, MySQLi, and PDO extensions is: MySQL – The early PHP-MySQL …

MYSQL vs MYSQLI vs PDO in PHP (Which One To Use!?) Read More »

Pagination With PHP MySQL (Simple Step-By-Step Example)

Welcome to a tutorial on how to create simple pagination with PHP and MySQL. Yes, there are a lot of frameworks out there that deal with pagination, but some left people scratching their heads with an insanely long “how to use bible”. So here it is, let us walk through a simple “DIY pagination” example that …

Pagination With PHP MySQL (Simple Step-By-Step Example) Read More »

3 Steps To Save HTML Form Into Database In PHP MySQL

Welcome to a beginner’s tutorial on how to save an HTML form into the database with PHP and MySQL. So you have finally come to fight the boss stage of full-stack programming – Combining HTML, PHP, and MySQL to save a submitted form into the database. Saving an HTML form into the database is a …

3 Steps To Save HTML Form Into Database In PHP MySQL Read More »

2 Steps to Search and Display Results From Database (PHP MySQL)

Welcome to a tutorial on how to search and display results from the database using PHP and MySQL. Want to add a search box to your website? Well, it actually isn’t that difficult. In the simplest design, a “search and display results” only involves 2 steps. Create a simple HTML search form – With a …

2 Steps to Search and Display Results From Database (PHP MySQL) Read More »

How To Remove HTML Tags In PHP & MYSQL – Simple Example

Welcome to a tutorial on how to remove HTML tags in PHP and MySQL. So you have completed your comments system, forum, review, or whatever that accepts user feedback. But there is one problem – Bad guys are abusing it by adding all sorts of funky HTML and script tags. To remove HTML tags in …

How To Remove HTML Tags In PHP & MYSQL – Simple Example Read More »

4 Steps To Store & Retrieve Images In Database With PHP MySQL

Welcome to a tutorial on how to store and retrieve images in an MYSQL database with PHP. So for some reason, you have some images that just have to be stored in the database. Yes, it is possible to do so, and actually relatively easy. To store and retrieve images in the database with PHP …

4 Steps To Store & Retrieve Images In Database With PHP MySQL Read More »

2 Ways to Store & Retrieve Arrays Into Database With PHP MYSQL

Welcome to a tutorial on how to store and retrieve arrays into the database using PHP and MySQL. So you have an array in PHP and want to store it into the database? Well, bad news. MySQL only takes in flat strings, numbers, and timestamps. It does not accept arrays or objects. To store an …

2 Ways to Store & Retrieve Arrays Into Database With PHP MYSQL Read More »

4 Steps To Store & Retrieve HTML Code With PHP MySQL

Welcome to a quick tutorial on how to store and retrieve HTML code with PHP and MySQL. Are you trying to create a custom content management system (CMS), a template system, or maybe you want to accept code snippet contributions from users? HTML code can be stored in a database, into a regular text field. …

4 Steps To Store & Retrieve HTML Code With PHP MySQL Read More »