Shared lock is, when more than one transaction is granted read access to a given record. One transaction gets shared lock on a record. lockForUpdate You can use it, when reading to prevent the rows from being modified or from being selected with another shared lock. Or you can lock some row(s) until your transaction […]
The orderBy method is used to sort the result-set in ascending or descending order. The first argument to the orderBy method should be the column you wish to sort by, while the second argument controls the direction of the sort and may be either asc or desc. latest / oldest The latest and oldest methods […]
A newsletter opt-in form using jQuery, PHP, and MySQL. An alternative version using html5 form validation is included in this package. See it here. This is a newsletter sign-up for your website so visitors can subscribe to your newsletter. The visitor is required to enter a name and a valid email. PHP and HTML Code
You just have to create a Facebook App and get your Access Token and need a Facebook PHP SDK to help to post on Facebook. You may also like to log in with Facebook using PHP. Before creating Facebook App you need to download Facebook PHP SDK Get access token https://developers.facebook.com/docs/facebook-login/permissions/v2.2 PHP Code
Sitemaps prefer to be in XML format, but that does not mean that you have to write XML code for each page manually. Let’s build a XML sitemap together with PHP. sitemap is very play very important role in SEO it represent all URL website. it help to increase ranking of website. PHP Code
To perform a “cross join” use the crossJoin method with the name of the table you wish to cross join to. Cross joins generate a Cartesian product between the first table and the joined table. Let’s create a crossJoin method in laravel 5
Google is providing free of cost Currency Converter API to convert one currency into another currency type. Google Currency Converter API can implement any programming language. I am using PHP to create a currency converter application to convert real-time currency value from one currency type to another currency type. HTML Code PHP Code
In this tutorial, we will show you how to prevent multiple and duplicate form submissions using PHP and MySQL. Below you will find two simple tricks for preventing duplicate submissions, you can use either of these or a combination of both. HTML Code PHP Code
In this simple article, we will show you how to convert bytes Into KB, MB, and GB using PHP. This is a simple PHP code that converts bytes Into KB, MB, and GB HTML Code PHP Code
codeigniter scripts CodeIgniter select query function is used to fetch the result from one table but, one or more table data fetch to use join query. SELECT operation is also called as READ and one among the database CRUD process. The following functions allow you to build SQL SELECT statements. Let’s create a get method […]