Inserting updating and deleting data to mysql through php

The returned array holds the strings fetched from database, where the column names will be the key used to access the internal data.

As you can see below, data is displayed in an HTML table.

is a simple PHP class for doing standard My SQL actions, such as selecting, inserting, updating and deleting database rows.

It also includes some nice functionality, like auto-escaping to protect your database from malicious code and automatic serializing of arrays.

Prepared Statements significantly improves performance on larger table and more complex queries.

The queries are parsed separately by the server, making it resilient to malicious code injection.

The procedural style is much similar to old My Sql and it may be helpful to users who are just switching to My Sqli, but should keep away altogether.

Another important feature of My Sqli is the Prepared Statements, it allows us to write query just once and then it can be executed repeatedly with different parameters.In linux too when you install php5 mysql package, My SQLi automatically gets installed, more details about installation in Linux and Windows can be found here.My Sqli offers two ways to connect to the database, procedural and object oriented, the recommended way to open a database connection is object oriented way, because it is secure, faster and efficient.Initiate a database connection using by creating a // Global scope $db = new Database($database_name, $username, $password, $host); // Function scope function something(){ // We could simply use `global $db;`, but using globals is bad.


and remove comment (semi-colon) from the start of the line extension=php_The code below uses Prepared statement to fetch records from the database.


  1. Pingback:

  2. eric   •  

    You agree that You are solely responsible for Your interactions with other users, both on and off the Site.

  3. eric   •  

    After several nasty dating surprises, instantaneous HR executive Sarah compiles a 'complete' list of potential partner requirements.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>