Page 22 – Technical Blogs and Discussion Board

Deleting records before a certain date in Mysql

Hi, I was looking for a query to delete the records up to certain date from my MySql table. It’s pretty simple. Here is the MySql table: We have a Delete button in our web page. By clicking on it, it asks for the Date up to which user can delete the data. Once user…

Integrating QR/Bar code Scanner to Android Application

Greetings of the Day!!! While we were working on a project to develop an android app, we had a requirement to integrate a QR or bar code reader with this app. I was wondering how to do it. Barcode or QR Code scanning is a pretty complex and non-trivial task in itself, it could be overwhelming…

Create A Simple Login Form On Popup Box Using jQuery.

Greetings of the day!!! While I was working on a web project with PHP and MySQL. There was a requirement to create a LOGIN form in the Pop up box instead of creating a login page separately. This provides a great user experience by not redirecting to another login page. This write up will help you to…

How to find the next set of records after a specified one in MYSQL

Greetings Of The Day! While we were working with web services using PHP and Mysql for an android application, we had a use case to retrieve and show a set of data to one user and remaining set of data to other user based on the login details. Application had Master and Partner users. Consider…

Android Splash Screen using Android Studio

Most of the Android apps uses splash screen before launching their application activity. You can see that with most popular apps such as Skype, Facebook, Dropbox etc. While I was developing an Android APP POC for one of my customer, the requirement was to create a splash screen with their logo which stays on the…

Sorting Multi-Dimensional Arrays in PHP

I was working on a project. I had to do lot of interaction between mysql server and my android app. In that case I got a situation where I get the raw data from database which I need to sort and show on the fly. This data is in multi dimensional array. I use to…