Showing posts with label Database. Show all posts
Showing posts with label Database. Show all posts
03 October, 2020
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.
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.
02 November, 2015
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.
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.