How to insert data using wpdb
Md Riyazuddin
Verified
You can insert your data via prepare method because prepare help to secure from SQL injection .
global $wpdb;
$tablename = $wpdb->prefix . "submitted_form";
$name = "Kumkum"; //string value use: %s
$phone = "3456734567"; //numeric value use: %d
$sql = $wpdb->prepare("INSERT INTO `$tablename` (`name , `phone`) values (%s, %d)", $name, $phone);
$wpdb->query($sql);
And this help to secure insert data in WordPress .
Comments
Leave a Comment