How to insert data using MySQLi query in php

How to insert data using MySQLi query in php

In this tutorial you will learn how to insert records in a table using MYSQLi query . Let’s start to create a INSERT INTO statement with values using MYSQLi Procedural and MYSQLi Object-oriented method. Here we are going to insert a record into user table by specifying coloum fields like: ‘ user_id’, ‘first_name’, ‘last_name’, ’email’, ‘phone’. Here ‘user_id’ is an  AUTO_INCREMENT PRIMARY KEY  coloum. Example: MYSQLi Query MYSQLi Procedural Method

  MYSQLi Object-oriented Method MySQLi Object-oriented method is more faster and secure than MYSQLi Procedural method. That’s the reason…

Read More

how to connect mysqli with php

how to connect mysqli with php

MYSQLi Tutorial for Beginners – how to create MySQLi connection with php in simple and easy steps starting from basic to advanced level. To create connection 4 parameter is required : “hostname” , “username“, “password” and “database name” see below..how to do it..  

if you are using xampp or wamp then by default username is root and password is blank. Also you can check our video tutorials:

Read More