Undefined function in mysql and php

Question

This page will delete a post:

require_once ('db.php');
$db = new DB();
$db->deletePost($_GET['id'], $_GET['postType']);

db.php only contains a class which called DB and its functions.

this is a part of db.php:

public function deleteComment($post_id, $post_type)
{
    $query = "delete from t_comments where c_type = '$post_type' and c_id = '$post_id';";
    $this->execute($query);
}
public function deletePost($post_id, $post_type)
{
    deleteComment($post_id, $post_type);
    $query = "delete from t_news where n_id = '$post_id';";
    $this->execute($query);
}

Then mysql says: Fatal error: Call to undefined function deletecomment() in db.php on line 70

I defined deleteComment above the deletePost!So what's the problem?Can't I call another function of a class in that class?But in C++, I think it is possible!

Another side-note, don't use GET for your database manipulations; it might cause a search engine or a browser accelerator to wipe out your database. — jeroen
– jeroen, Commented Jan 12, 2012 at 12:20

greut · Accepted Answer · 2012-01-12 12:15:26Z

3

deleteComment(… -> $this->deleteComment(…

You should give PDO a try mate!

answered Jan 12, 2012 at 12:15

greut

4,4031 gold badge32 silver badges49 bronze badges

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

Comments

rkosegi · Accepted Answer · 2012-01-12 12:15:33Z

2

Use this:

$this->deleteComment($post_id, $post_type);

instead of

deleteComment($post_id, $post_type);

answered Jan 12, 2012 at 12:15

rkosegi

14.8k5 gold badges57 silver badges90 bronze badges

2 Comments

Milad R Over a year ago

thanks a lot! It worked! But why it is required to use $this->... ?does it mean execute the function which is in "THIS" class?

rkosegi Over a year ago

Because PHP does not know which context to use withou $this, so it will use global scope.In global scope you don't have function with this signature, so it will raise error.

Collectives™ on Stack Overflow

Undefined function in mysql and php

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related