Categories
PHP / MySQL

How do i Query to Count Last 3 Days Recourds in MySQL?

One of my new Project, I need to Display Latest Updates of last 3 days. With MySQL’s date_add we can achieve result, see the below example. Note that I’m using a negative date value. You can use a positive date value to get tomorrow, next week, next month, etc..

Categories
PHP / MySQL

Image Data URIs with PHP

I often Use Image Data URIs for large-scale applications depending on client requirement(not supported in IE7 and below). Data URI: The data URI scheme is a URI scheme that provides a way to include data in-line in web pages as if they were external resources. This technique allows normally separate elements such as images and […]

Categories
PHP / MySQL

Uploading Images With PHP ?

This Tutorial takes you through How to make a PHP Image Uploading Script, rather than uploading images to a database this tutorial shows you how to upload images to your web server. Uploading images to a server can be broken down into two parts : As usually, we need an HTML form with browse option […]

Categories
CodeIgniter

How to Get Last inserted ID in CodeIgnier?

We often need last inserted ID for different reasons(for example when you need to store foreign key), Immediately after a record has been inserted into the database, you can get the id that was auto incremented(primary Key). Basic PHP MySQL Method simply call CodeIgniter method That’s it! Reference URL: http://codeigniter.com/user_guide/database/helpers.html

Categories
PHP / MySQL

List of top tutorials on how to create an API With PHP?

List of top tutorials on how to create an API With PHP? Creating a RESTful API with PHP(2013) Creating an API-Centric Web Application(2011) Create a RESTful API in less than 5 minutes(2010) Create a REST API with PHP(2009) How to Add An API to your Web Service(2009) Towards RESTful PHP – 5 Basic Tips(2008) Create […]