• Home
  • Archive
  • Tools
  • Contact Us

The Customize Windows

Technology Journal

  • Cloud Computing
  • Computer
  • Digital Photography
  • Windows 7
  • Archive
  • Cloud Computing
  • Virtualization
  • Computer and Internet
  • Digital Photography
  • Android
  • Sysadmin
  • Electronics
  • Big Data
  • Virtualization
  • Downloads
  • Web Development
  • Apple
  • Android
Advertisement
You are here: Home » MySQLi or MySQL Improved Extension

By Abhishek Ghosh March 29, 2013 12:50 am Updated on March 29, 2013

MySQLi or MySQL Improved Extension

Advertisement

MySQLi or MySQL Improved Extension, as the name implies, is an improved version of the conventional PHP MySQL driver, offering some extra benefits. Previously we wrote the basics on MySQL in What is MySQL, Why We Need MySQL.

 

MySQLi Basics

 

It is actually not possible to provide every details on MySQLi on this website. This is beyond the scope of this website. Our purpose is to provide the basic idea about any inquiry that might arise either in need or out of curiousness. That is what this website is for, what ever the topic is. If you are looking for titbits on MySQLi, then please consult php.net for the official reference. Common questions around MySQLi are (from various comments) :

 

  • Why we will use MySQLi instead of MySQL?
  • Are there situations where one should not use MySQLi?
  • Do server needs to be configured differently to use MySQLi?

 

MySQLi is object oriented, it enables most of the features of MySQL. MySQLi delivers prepared statements, transactions, multiple statements and possibly it is a safer way of exchanging data or running commands to the MySQL server and in turn it protects from SQL injection. This might be a reason for choosing MySQLi over MySQL. It is said that, the MySQL version 4.1.3 or later users must use the mysqli extension. Unfortunately, some functions are not yet included in MySQLi.

Advertisement

---

 

Notes on MySQLi

 

MySQLi or MySQL Improved Extension

 

It depends on the blogging software or CMS, whether it will support MySQLi or not. While many PHP MySQL CMS has started to offer MySQLi connectivity; like MyBB forum software; many including WordPress, does not have MySQLi support enabled out of the box. In that case, we need to modify the PHP codes manually. WordPress uses mysql_* functions.

When the question is around upgrading to MySQLi from MySQL, for long term, PDO seems to be superior over MySQLi. This is why people usually compares MySQLi with PDO, not MySQL versus MySQLi.

Some references are given below :

 

Vim
1
http://php.net/manual/en/book.mysqli.php

Vim
1
http://php.net/manual/en/class.mysqli.php

Vim
1
http://net.tutsplus.com/tutorials/php/why-you-should-be-using-phps-pdo-for-database-access/

 

Abhishek-Ghosh

This Article Has Been Shared 386 Times!

Facebook Twitter Pinterest
Abhishek Ghosh

About Abhishek Ghosh

Abhishek Ghosh is a Businessman, Surgeon, Author and Blogger. You can keep touch with him on Twitter - @AbhishekCTRL.

Here’s what we’ve got for you which might like :

Articles Related to MySQLi or MySQL Improved Extension

  • Server OS and Desktop OS : Prominent Differences

    Server OS and Desktop OS has differences. The same Operating System like Ubuntu is different on Server and on Desktop.Lets see Server OS and Desktop OS closely.

  • WordPress Compatibility Checking Script for Your Web Server

    WordPress Compatibility Checking Script for Your Web Server is a simple yet powerful script to test whether your web host to run WordPress smoothly.

  • Handwritten Fonts and Design : Needed Softwares and Resources

    Handwritten fonts and design looks not only attractive among the concrete of monotonous designs, it actually becomes a magnet if proper methods and softwares are used.

  • Adding Schema.org Structured Data in Genesis Theme

    Adding Schema.org Structured Data in Genesis Theme without using any plugin is quite easy as Genesis has great documentation and has excellent existing markups.

  • Markdown : Syntax and Editors

    Markdown is a simplified markup language, developed by John Gruber and Aaron Swartz. Markdown is easily readable even in plain Text without further conversion.

Additionally, performing a search on this website can help you. Also, we have YouTube Videos.

Take The Conversation Further ...

We'd love to know your thoughts on this article.
Meet the Author over on Twitter to join the conversation right now!

If you want to Advertise on our Article or want a Sponsored Article, you are invited to Contact us.

Contact Us

Subscribe To Our Free Newsletter

Get new posts by email:

Please Confirm the Subscription When Approval Email Will Arrive in Your Email Inbox as Second Step.

Search this website…

 

Popular Articles

Our Homepage is best place to find popular articles!

Here Are Some Good to Read Articles :

  • Cloud Computing Service Models
  • What is Cloud Computing?
  • Cloud Computing and Social Networks in Mobile Space
  • ARM Processor Architecture
  • What Camera Mode to Choose
  • Indispensable MySQL queries for custom fields in WordPress
  • Windows 7 Speech Recognition Scripting Related Tutorials

Social Networks

  • Pinterest (22.1K Followers)
  • Twitter (5.8k Followers)
  • Facebook (5.7k Followers)
  • LinkedIn (3.7k Followers)
  • YouTube (1.3k Followers)
  • GitHub (Repository)
  • GitHub (Gists)
Looking to publish sponsored article on our website?

Contact us

Recent Posts

  • Samsung Galaxy S22 Ultra: Long Term Review June 30, 2022
  • How to Make the Most of Your S Pen (S22 Ultra) June 29, 2022
  • Safe Chargers for Samsung Galaxy S22 Ultra June 27, 2022
  • How Telecoms Can Use The Cloud To Power Their 5G Network June 24, 2022
  • A Beginner Guide to Cloud Computing for Development June 22, 2022

About This Article

Cite this article as: Abhishek Ghosh, "MySQLi or MySQL Improved Extension," in The Customize Windows, March 29, 2013, July 1, 2022, https://thecustomizewindows.com/2013/03/mysqli-or-mysql-improved-extension/.

Source:The Customize Windows, JiMA.in

This website uses cookies. If you do not want to allow us to use cookies and/or non-personalized Ads, kindly clear browser cookies after closing this webpage.

Read Privacy Policy.

PC users can consult Corrine Chorney for Security.

Want to know more about us? Read Notability and Mentions & Our Setup.

Copyright © 2022 - The Customize Windows | dESIGNed by The Customize Windows

Copyright  · Privacy Policy  · Advertising Policy  · Terms of Service  · Refund Policy