Skip to main content

PHP PDO OOP CRUD Class with Bootstrap

In this Article we are going to learn about PHP PDO class, which can perform Create, Read, Update and Delete (CRUD). If you don’t know about PDO please refer to the PDO reference link before heading to this article.

Download

File Structure

Our File Structure will be as following:

File structure

Database Schema

Create Database named pdocrud and import the following table. Use following mysql query which will create a User table with 4 fields. id, firstname , lastname, and email.

Configuration

In the file structure you can see the config.php, which is our configuration file. This file is responsible for our database connection, and we also include our CRUD class here like include_once 'class.php-crud.php'; use the following code for the config.php file.

IOS Push Notification PHP class using Apple Push Notification Service (APNs)

Apple Push Notification Service (APNs) is the center peace of the remote notification features. It is quick and highly efficient service for receiving notification throw-out the IOS devices. Apple Push Notification service sends and routes remote notifications for your apps from your provider to each user’s device. You can send notifications through APNs to many devices on which the client apps are installed. You can find more about APNs on official Apple developer site at https://developer.apple.com/. This tutorial is dedicated to Ankit Kansara who submitted a request throw our Request a Tutorial page for Ios PUSH NOTIFICATION PHP Class

Installing PHP 7 on WAMP server (For windows)

The PHP community has released major update over a decade as PHP 7. PHP 5 brings many exited features like support of Object oriented programming and many related with that.

You guys may wonder why PHP community released PHP 7 just after PHP 5 why there is no PHP 6? Well requirement for PHP 6 were not defined clearly and most of the people not agreed with, so the project ground to the halt. Almost all the features defined for PHP 6 were already implemented in PHP 5.3 and it’s later versions of PHP 5. So we almost got everything, which was documented for PHP 6, when features set for a major release community decided to avoid confusion with dead project and skip to PHP version 7 with the major updates.

Android Push Notification PHP class using Google Cloud Messaging (GCM)

Google cloud Messaging (GCM) is a service that helps developer to send push notification data to any Android devices. With help of this feature developer can send push message to Android device whenever new data or promotion offers arrives in Android application.

Today lots of Android applications using Google cloud Messaging service to send multiple push messages to multiple Android devices. You can find more at it’s official document at https://developers.google.com/cloud-messaging/

Push Notification flow with PHP Web Server APP and GCM

android_push

  1. Android device send Sender Id and application Id to GCM server.
  2. GCM server generates unique registration Id and sends them back to Android device.
  3. Android device sends registration Id to PHP web server application.
  4. PHP web server stores registration Id to Database for later use.
  1. When server needs to send Push Message, It fetch previously stored registration Id from Database
  2. And send them to the GCM server along with the push message data.
  3. GCM server will send that message to particular Android device using device registration Id

Google Map with Multiple color Markers PHP – JavaScript/jQuery

In this tutorial We will learn how to display responsive Google Map with multiple color marker, It is also dedicated to one requester who submitted a request throw our Request a Tutorial page for Making Google map area to fit all markers inside map we also cover that point here.

Try Demo

Google Map Api

We will use gmaps JavaScript to display Google map with multiple Latitudes and longitudes data to show our different color marker pins. We will also use Google Map Geocode Api to fetch Lat and lng from location name.

PHP array for Multiple Location

Fetching Lat, Lng and address information from above array with the help of Google Map Geocode API

SkaDate / Oxwall : How to create simple widget in Skadate X / Oxwall ?

What is widget in Skadate / Oxwall ?

Widgets are an essential part of the web software. You can call widgets as an extension block of that software or the theme. In Skadate / Oxwall widgets are components that can be attached to the widget panels. Lets dig little deep into Skadate / Oxwall widgets.

Skadate / Oxwall available Widget Panels

There are three panels in Skadate / Oxwall which currently used for widgets to attached with.

  1. Index page
  2. Dashboard
  3. Profile page

Here in our example we will create a Custom status widget, which will be used in Dashboard panel. You can use one widgets to all panel there are no limits.

Skadate / Oxwall : Console Items / Console menu

Console Items or Console menu are the interactive controls of the Skadate X / Oxwall software. It helps users to get real time notification with notification read / unread counter. Console item have different type of behaviors it depends on the use of that particular console item.

Console Item Button

Console item buttons are usually a simple button but you can set different type of layout using css options. You can set different behaviors like some can set to open a popup window and some can open link. Simple examples of Console item buttons are sign in, and sing up/Join buttons.

Customize Skadate X Oxwall Landing page / Home page

Why do we need to update Landing page / Home page?

A well-designed landing page or Home page can boost your site traffic and also reduce bounce rate. This page is what you used for email newsletters marketing, campaign, most of your site’s call to actions button and recent post.

Landing page refers to how good we think user’s experience will be when they get on our site first time. I regularly visit many socials and bloggers websites where I found that every successful websites updating their landing page regularly and that rise a question in my mind why they need to update their landing page so frequently? The simple answer lies in human nature. We always attract to the thing, which we find different or new, If we see same thing every time we will not spend time for it even if its in our need.

Resize Image Dynamically in PHP with TimThumb

PHP TimThumb

TimThumb is simple, flexible yet powerful php script that resizes images dynamically. Every website or blog uses thumbnail images, it’s a very useful part of the website.If you don’t see any images or thumbnail you quickly skip the website or article. You wont read it in deep but if you find few thumbnails between or in start of the News or article you would like to read and stay more on the page or article. It’s human nature visual images attracts mind rather than just bunch of words, isn’t it?