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

How to write connection class to mysql database using php

Hello! In this post, you will learn to how to write and test the OOP based connection class to mysql database using php. see below..how to do it.. connection.php

Now you have create the database connection class let’s see how to call this connection class inside your project. To test the connection we will create another php file and create a object from my existing connection class.. see below..how to do it.. >test.php

Read More

Gravity Forms Woocommerce Product Add-on not sending notifications

Gravity form woocommerce

By default, Gravity Forms Add-Ons does not send email notifications when they are assigned to a product. The change below will enable Gravity Forms to send the notification. Woocommerce Gravity Form add-on Fix: gravityforms-product-addons.php, line: 567  

Read More

How to create pagination using PHP and MYSQL

Paging (Pagination) means showing Database results in multiple pages instead of one long page. if we have more than 100 records in database and we want to show all results but not in a single page, so we can devide this results into many pages. MySQL helps to generate paging by using LIMIT clause which will take two arguments. First argument as OFFSET and second argument how many records should be returned from the database. Below is a simple code to fetch records using LIMIT clause to generate paging.

Read More

How to create line chart in php and my sql

Line chart graph is very usefull to show sell and purchase graph layout of monthly, weekly, yearly as we want. To create line graph: first ,we create a index.php file to show garph and second, create get_line_chart.php to  get data fron my sql database. index.php 

get_line_chart.php

Result:

Read More