Makitweb Posts

In PHPMyAdmin you can import data in the database table in various formats e.g. SQL, CSV XML, etc. formats.

While import CSV file in PHPMyAdmin need to make sure that it should be the valid format like – the number of columns, data.

Similar functionality can be implemented with PHP where read the uploaded file and insert the record in the MySQL database table.

It is possible to check for duplicate entry with PHP while import but it is not possible in PHPMyAdmin.

Import CSV file data to the MySQL using PHP

DataBase PHP

If you want to add records sorting with header click on your existing pagination code then you need to write some extra code for it.

This improves the user experience while traversing on the long list of paginated records.

The user can easily sort a column and view the list e.g. sorting employee list by its salary, age, etc.

Table sort on header click in the pagination using PHP

PHP

One of the good thing about Chrome is it allows you to customize its appearance by using themes and add new features to it using custom extensions. The Chrome Web store is filled with lots and different types of extensions, you can also create your own extension and upload it to the Web store.

Themes are a type of an extension, which doesn’t contain JavaScript or HTML files. It has a manifest JSON file which contains all information about an extension and few images. It does not totally change the whole interface, instead, it defines how its interface looks.

If you are using a theme on your Chrome browser by downloading and installing it, sometimes you may want to convert your favorite wallpaper to a theme.

In this tutorial, we will create a new custom theme, which has a manifest JSON file and collection of images. And learn how to set in Browser.

chrome_theme

How To

AngularJS

SlideShare is a one of the popular web service where user view,upload and share their content. It support multiple formats e.g. ppt,pdf,doc,etc.

You can find content on the wide range of topics.

Member chooses its upload content is available publicly or privately. After uploading, it is available for the community, where member interact with it by like, share on various social media, comment on it, embed your content and even they download it.

To embed SlideShare Presentation to the website or personal blog there are two ways –

  • Without Plugin
  • With Plugin

In this tutorial, we check out both of these ways of embedding.

Within this tutorial, I am assuming you have SlideShare account, if not you can signup for it.

How to embed SlideShare Presentation in WordPress

How To

Chrome extension are the program which adds new functionality to Chrome browser. It takes little space in the toolbar for instant access.

It uses only HTML,CSS, and JavaScript to building a Chrome extension, except them no other web technologies.

From this tutorial, you get an overview on Chrome extension and How you can build your own.

What is the Chrome extension and How to build one

How To

It gives more flexibility to the user by allowing them to hide and show those columns which they don’t want to see on the list.

You can do this with jQuery by toggling the specific columns according to the selection.

In the demonstration, I am creating a table layout for listing the employee details and use check boxes to hide and show the table columns using jQuery.

How to Hide and Show the Table column using jQuery

Jquery PHP

Jquery PHP

You can send JavaScript Array as data in the AJAX request which generally require when need to send a group of related values e.g. pass all checked checkboxes values.

In the demonstration, I will initialize JavaScript Array with all checked checkboxes values and send it as AJAX data.

How to Send JavaScript Array to the AJAX using jQuery and PHP

AJAX Jquery PHP

JSON stands for JavaScript Object Notation, it is a data interchange format which is also been used to passing data from the server.

It is best and effective way to return data when you want to return multiple values as a response from AJAX.

You couldn’t directly return an array from AJAX, it must have converted in the valid format.

In this case, you can either use XML or JSON format.

In the tutorial demonstration, I will return an array of users from AJAX, while return converts the array into JSON format using the json_encode() function in the PHP.

On the basis of response show data in tabular format.

Return JSON response from AJAX using jQuery and PHP

AJAX Jquery PHP