Wordpress Plugin Development tutorial from scratch (Part 17) Wordpress Update/Delete to Database

In this video session i have explained about,
1. Update data of wordpress table in wordpress, 2. Delete data from wordpress table in wordpress

#WordpressTutorialsPoint
#WordpressLearnersHub
#WordpressCustomizations
#LearnWordpressStepbyStep
#WordpressBySanjay

All we have seen in 2 different ways by using core function as well as by running direct query.

Steps to do Update data of Wordpress table:
#1: wpdb::update( string $table, array $data, array $where, array|string $format = null, array|string $where_format = null )
#2: wpdb::query and wpdb::prepare

Steps to do Delete data from Wordpress table:
#1: wpdb::delete( string $table, array $where, array|string $where_format = null )
#2: wpdb::query and wpdb::prepare

By Step $wpdb::update,
===============
1. wpdb::update( ‘table’, array( ‘column’ = ‘foo’, ‘field’ = ‘bar’ ), array( ‘ID’ = 1 ) )
2. wpdb::update( ‘table’, array( ‘column’ = ‘foo’, ‘field’ = 1337 ), array( ‘ID’ = 1 ), array( ‘%s’, ‘%d’ ), array( ‘%d’ ) )

‘table’: table_name of wordpress database

By Step $wpdb::delete,
===============
1. wpdb::delete( ‘table’, array( ‘ID’ = 1 ) )
2. wpdb::delete( ‘table’, array( ‘ID’ = 1 ), array( ‘%d’ ) )

‘table’: table_name of wordpress database

By Step $wpdb::query,
=================
We have to use $wpdb::prepare to make Safe Execution of MySql Query
$wpdb-query(
$wpdb-prepare(
"Update wp_custom_plugin set email = '%s' where id = %d",'profotech1234@gmail.com',4
)
);

$wpdb-query(
$wpdb-prepare(
"Delete from wp_custom_plugin where id = %d",4
)
);

An array of formats to be mapped to each of the value in $data. If string, that format will be used for all of the values in $data. A format is one of '%d', '%f', '%s' (integer, float, string).

Documenation Study Notes:
===============
https://developer.wordpress.org/refer...
https://developer.wordpress.org/refer...
https://developer.wordpress.org/refer...

Create database table dynamically by Wordpress Plugin,
===============
Click here to watch:    • Wordpress Plugin Development tutorial from...  

How we add custom javascript code to wordpress plugin page:
==============================
Click here to watch:    • Wordpress Plugin Development tutorial from...  

SOCIAL :
===============
Subscribe :    / @onlinewebtutor  
FACEBOOK :   / onlinewebtutorhub  
TWITTER:   / owthub  
BLOG: https://onlinewebtutorhub.blogspot.in/

RECOMMENDATION:
===============
1. Some knowledge of PHP, HTML for this video series
2. How to Install Wordpress:    • Wordpress Theme Development tutorial from ...  

Also you can learn Wordpress Custom
===============
Theme Development:    • Wordpress Theme Development tutorial from ...  
Widget Development:    • Wordpress Widget Development tutorial from...  

Tags
===============
online web tutor,
profotech solutions,
wordpress plugin development from scratch in hindi,
wordpress plugin development from scratch in easy steps,
wordpress plugin development,
wordpress plugin development in easy steps,
plugin development in wordpress from scratch in hindi,
plugin development in wordpress by online web tutor,
plugin development in wordpress tutorials from scratch in hindi,
plugin theme development tutorials in hindi,
plugin development tutorials in hindi,
owt tuts,
online web tutorials,

Thanks
Online Web Tutor
Keep learning and Sharing :)

~-~~-~~~-~~-~
Please watch: "Learn backbone.js tutorial from scratch"
   • Learn backbone.js tutorial from scratch(Pa...  
~-~~-~~~-~~-~