How can I initialize wpdb class in a php file?

Question

i am new in wordpress. i want to run a sql from a php file and this file is calling from a plugin file. my plugin file code is:

if (confirm('Are You Sure You Want to Delete?')){ 
window.location.href = '../wp-content/plugins/delete_data.php?id=<?php echo $db_data['dynamicmenu_id']; ?>';
} else{
}

and this code is running from script. my delete_data.php file code is given below:

dlt_opt();
function dlt_opt(){
    global $wpdb;
    var_dump($wpdb);
    $dlt_id = $_GET['id'];
    $result = $wpdb->query( $wpdb->prepare( "DELETE FROM ".$wpdb->prefix."dynamicmenu WHERE dynamicmenu_id=".$dlt_id ) );
}

but in delete_data.php is creating error because it is not finding $wpdb and is null. So wpdb is not initializing and it can't find wpdb class. how can i add wpdb class? Error message is:

Fatal error: Call to a member function query() on a non-object in ...\htdocs\wordpress\wp-content\plugins\delete_data.php on line 7

Need help

add the file wp-load.php, for example: require_once('../../wp-load.php'); — Rajat Singhal
– Rajat Singhal, Commented Jan 10, 2012 at 14:17

moffepoffe · Accepted Answer · 2012-01-10 14:35:13Z

5

Better to use require_once(ABSPATH . '/wp-load.php');

answered Jan 10, 2012 at 14:35

moffepoffe

3721 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Subail Sunny · Accepted Answer · 2012-01-10 14:25:57Z

2

I found my own answer. I need to include wp-load.php in that file.

require_once('../../wp-load.php');

although it's not a good practice to delete like this.

answered Jan 10, 2012 at 14:25

Subail Sunny

2874 silver badges11 bronze badges

Collectives™ on Stack Overflow

How can I initialize wpdb class in a php file?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related