MYSQL PDO CONNECTION TO DATABASE IN PHP

PHP 5 and later can work with a MySQL database using:

  • MySQLi extension (the "i" stands for improved)
  • PDO (PHP Data Objects)

Earlier versions of PHP used the MySQL extension. However, this extension was deprecated in 2012.


Should I Use MySQLi or PDO?

If you need a short answer, it would be "Whatever you like".

Both MySQLi and PDO have their advantage

Read More

DIFFERENCE BETWEEN SOAP AND REST WEB SERVICES

Difference between SOAP and REST Web Services

SOAP – SOAP is a protocol which was designed before REST and came into the picture. The main idea behind designing SOAP was to ensure that programs built on different platforms and programming languages could exchange data in an easy manner.

REST – This was designed specifically for working with components such as media components, files, or even objects on a particular

Read More

OFF PAGE SEO:

Off-page SEO will help make your website popular on the internet, so you can get more visibility. With the on-page techniques we can get visibility in search engines. But only off page SEO techniques will help improve your website position in SERP. Take a look at the list of top 13 best off page SEO techniques now in trend.

1. Creating Shareable Content

Amazing content is always the KING in search engine optimization. Creating amazing and shareable content is a smart way

Read More

ON-PAGE SEO TECHNIQUES: 50 BEST SEO STRATEGIES FOR 2018

What is Search Engine Optimization?

Search Engine Optimization is nothing but the process of bringing our website or blog on to the top of the search engine result pages (SERPs). This optimization is basically classified into two types.

  • On-Page Optimization
  • Off-page Optimization

What is On-Page SEO Techniques?

The process of updating elements such as coding, text, images etc within our website or blog is called on-page opt

Read More

DIFFERENCE BETWEEN PHP AND NODE.JS

PHP

PHP is the Hypertext Preprocessor scripting language for making scalable, dynamic web applications. It is released in 1995 and considered as a number one backend development language for over past 20 years.

Node.JS

Node.JS is a platform built on Chrome’s v8 Javascript for easily building fast, scalable, network applications rather than the traditional approach of threading. It is released in 2009 and considered as a pop

Read More

DIFFERENCE BETWEEN PRIMARY KEY VS FOREIGN KEY IN TABLE – SQL DATABASE TUTORIAL

The main difference between Primary key and Foreign key in a table is that it’s the same column which behaves as primary key in the parent table and as a foreign key in a child table. For example in Customer and Order relationship, customer_id is the primary key in Customer table but a foreign key in Order table. By the way, what is a foreign key in a table and difference between Primary and Foreign key are some of the popular SQL interview questions, much like truncate vs delete in SQL

Read More

AJAX IMAGE UPLOAD USING PHP AND JQUERY

In this blog post we have covered one of the topic of ajax i.e. to upload images using Ajax and php without page refresh.

Short Description : 

In this process the image is selected first and previewed before storing it in to any location . Then using  jQuery Ajax, it is send to php script on submit button event.

PHP script stores the image in a defined location and returns the message of the success

Read More

HOW TO DYNAMICALLY ADD AND REMOVE FORM FIELDS USING JAVASCRIPT

In the last Blog, we have shown you how to dynamically add form fields to create form. This blog post tells about how to add and remove fields dynamically with the help of JavaScript codes. So while creating your form, you can easily add fields in a click and if you don’t want it, you can easily delete it in a click

Here are the following code snippets for it.

HTML File – getform.html

Here, you can view HTML coding for the blog. It

Read More

SUBMIT FORM USING AJAX, PHP AND JQUERY

AJAX (Asynchronous JavaScript and XML) is the art of exchanging data with a server, and updating parts of a web page – without reloading the whole page.

We have already post a blog which explains about submitting form without page refresh, but it was done by using PHP and jQuery only. Now we will show how you can do the same with ajax, PHP and jQuery.

For this you must have a database in MY-SQL . Here, we have database named “mydba” which consis

Read More

DIFFERENCES BETWEEN MYSQL AND MYSQLI IN PHP

MySQL MySQLi Difference

There are too many differences between these PHP database extensions. These differences are based on some factors like performance, library functions, features, benefits, and others.

MySQL

1. MySQL extension added in PHP version 2.0. and deprecated as of PHP 5.5.0.
2. Does not support prepared statements.
3. MySQL provides the procedural interface.
4. MySQL extension does not support stored procedure.
5. MySQL

Read More

WHAT ARE THE MAJOR DIFFERENCE BETWEEN PHP 5 AND PHP 7

PHP 5 vs PHP 7

PHP is a server side scripting language designed for web development by Rasmus Lerdorf in 1994. Since its launch in 1994 PHP has become an industry standard supporting almost 80% of the websites ( 79.8% to be precise) with its closest competitor being ASP.Net at 19.8% and others like Ruby, Java trailing far behind.

The PHP development team released the latest version of PHP: PHP 7 claiming it to be twice as fast as its predecessor PHP 5. So, is migrating t

Read More

DIFFERENCE BETWEEN ABSTRACT CLASS AND INTERFACE IN PHP

What is abstract Classes

As from name it seem like something that is hidden. Yes nature of the abstract classes are same. Abstract classes are those classes which can not be directly initialized. Or in other word we can say that you can not create object of abstract classes. Abstract classes always created for inheritance purpose. You can only inherit abstract class in your child class. Lots of people say that in abstract class at least your one metho

Read More

DIFFERENCE BETWEEN GET AND POST METHODS?

The GET Method

The GET method sends the encoded user information appended to the page request. The page and the encoded information are separated by the ?character.

http://www.test.com/index.htm?name1=value1&name2=value2
  • The GET method produces a long string that appears in your server logs, in the browser's Location: box.

  • The GET method is restricted to send upto 1024 characters only. Read More

WHAT IS THE DIFFERENCE BETWEEN SESSIONS AND COOKIES IN PHP?

Cookies

  • Cookies are stored in browser as text file format.
  • It is stored limit amount of data. It is only allowing 4kb[4096bytes]
  • It is not holding the multiple variable in cookies.
  • We can accessing the cookies values in easily. So it is less secure.
  • The setcookie() function must appear BEFORE the tag.

Destroy Cookies:

  • If we Closing the browsers at the time.
  • Read More

What is function overloading and overriding in php?

Overloading is defining functions that have similar signatures, yet have different parameters. Overriding is only pertinent to derived classes, where the parent class has defined a method and the derived class wishes to override that method.

In PHP, you can only overload methods using the magic method __call Read More

OBJECT-ORIENTED PROGRAMMING CONCEPTS IN PHP - PART 1

PHP is a server-side scripting language, mainly used for web development but also used as a general-purpose programming language. Object-Oriented Programming (PHP OOP),  is a type of programming language principle added to php5, that helps in building complex, reusable web applications.

In this blog, we will be explaining some of the Object-Oriented Programming concepts in PHP with some examples.

The  Object Oriented concepts in PHP are:

OBJECT-ORIENTED PROGRAMMING CONCEPTS IN PHP - PART 2

In the previous article of Object Oriented programming concepts in PHP,  we learned to create a class, define objects for the class and create methods. We also learned about different topics of object-oriented programming like inheritance, interface, and abstraction. Read More

NEWSLETTER

Subscribe and get the latest news and useful tips, advice and best offer.