If you read the MySQL manual you might have seen the ORDER BY RAND() to randomize the the rows and using the LIMIT 1 to just take one of the rows. The reason that ordering by RAND() can be slow is that you’re forcing the database to actually sort the whole table before returning anything. […]
JavaScript is a lightweight, interpreted, object-oriented language with first-class functions, and is best known as the scripting language for Web pages, but it’s used in many non-browser environments as well. Today we will discuss about creating theme using javascript. JavaScript runs on the client side of the web, which can be used to design / […]
CodeIgniter is a powerful PHP framework with a very small footprint, and very useful for website. Today I am going to introduce you the Magic function for CI like CakePHP. What is Magic Functions As the name “Magic function” there are some magic with its library which you can download from here . By using […]
This is an extremely common interview question. It’s surprising since an abstract class is rarely used in solutions compared to other things. Many junior developers make the mistake of thinking of interfaces, abstract and concrete classes as slight variations of the same thing, and choose one of them purely on technical grounds: Do I need […]
In this post we will discuss to reset an array after add or delete an index. If there are an array $a Now we updates this array and delete index 2, so the new array is – Index 2 has been removed from array and we have to re-arrange all indexes of array. So its […]
For the websites it is common to manage articles, products and much more thing by categories. And these categories have child categories and these child also have child and so in. So this article will show you that how to manage the Multi-level categories tree in PHP and MySql. First of all we need a […]
This is very common problem in huge database to handle the duplicate data. Tables or result sets sometimes contain duplicate records. Sometimes, it is allowed but sometimes it is required to stop duplicate records. Sometimes, it is required to identify duplicate records and remove them from the table. This chapter will describe how to prevent […]
The words are not opposed to each other but rather describes two possible aspects of a subroutine. An attempt to define the words follows: Subroutine: A set of instructions that can be used several times in the same program. Function: A subroutine that returns a value. Derived from functions in mathematics. Method: A subroutine that […]
To handle the large number of records in database pagination is most important part to view records. This article will teach you how to create pagination in PHP with mysql database results. I have created a pagination class which holds the mysql results and html for generated links. This is very simple and secure to […]
login-with-facebook-php create login with facebook in core php First of all create a new facebook app and get the APP_ID and APP_SECRET_KEY. Now time to install facebook sdk directly or by composer By composer create a file in your directory composer.json { “require” : { “facebook/php-sdk-v4” : “~5.0” } } and run command composer install […]
Powered by Minmarks.com | A Coding blog by By Jitendra.
