Mostlikers Programming Blog, Related codeigniter jquery, php, mysql and more things
Showing posts with label Database. Show all posts
Showing posts with label Database. Show all posts

03 October, 2020

Bulk Product Data Insert,Update CSV File into Database Using PHP and Mysqli

In this article, we will discuss how to efficiently insert and update data from CSV files into a database using PHP and MySQL. This process can save a significant amount of time, especially for eCommerce websites that require bulk product information updates in the database.  

Bulk Product Data Insert,Update CSV File into Database Using PHP and Mysqli


28 March, 2020

Product Ajax Search Filter with Infinite Scroll more Using PHP and Mysqli

Recently I have posted Product Brand, Size, Material Checkbox Search Filtering Using PHP And Jquery. This search filter script doesn't have any pagination. Now i have created search filter with pagination. In this tutorial, we will discuss Product Ajax Search Filter with Infinite Scroll more Using PHP and MySQL. Load more it's user-friendly without refreshing the page user can get the filter products.

Product Ajax Search Filter with Infinite Scroll more Using PHP and Mysqli

11 July, 2017

Mysql Stored Procedure and Get Procedure Data From PHP

Hi guys, Today we are going to see How to create a stored procedure and get call data from a stored procedure by using PHP. Before going to the topic let see What is stored procedure? and Why we need use stored procedure?. A stored procedure is a group of SQL statements that form a logical unit and perform a particular task, and they are used to encapsulate a set of operations or queries to execute on a database server.


08 December, 2015

Fetch Random rows records from Database Using Mysqli and PHP

In this tutorial, you will learn various techniques to how to Fetch Random rows records from Database. Using this code you can display random gallery profile, Online examination random questions, multiple choice quiz system. I used following simple query for retrieving random records from database table.

Fetch Random rows records from Database Using Mysqli and PHP

02 November, 2015

New User Registration With Email Verification Using PHP and Mysqli

In this tutorial, we are going to see how to implement New user registration with email verification script. if you're using register form in a website, you need to use email verification because it will reduce spam register user and make sure you will get a correct registered user on your website.

New User Registration With Email Verification Using PHP and Mysqli

18 August, 2015

Convert PHP data to JSON API url

Today I have discussed Convert PHP result array to JSON API URL. JSON is a lightweight data-interchange format. The current trend to develop the app and web app server side exchanging data between their servers  XML or JSON format. JSON is the easiest way to translate a JavaScript object into a PHP associative array.

Convert PHP data to JSON API url

03 March, 2015

PDO basic insert,view,update,delete with php function

The mysql extension is deprecated due to the some sql injunction issue. I would suggest to use mysqli or PDO. mysqli based on object oriented process (OOPS). The PHP Data Objects (PDO) extension defines a lightweight, consistent interface for accessing databases in PHP. it seem how we are using mysql same for PDO.

PDO-add