PHP Mysql does not accept table name as variable

Question

mysql does not recognize the name of my table in a variable in a function, what can it be?

My PHP Code:

$TableMaster = "table_name";
function recursiveDelete($id,$db,$table){
    $db_conn = $db;
    $query = $db->query("SELECT * FROM ".$table." WHERE Padre = '".$id."' ");
    if ($query->rowCount()>0) {
        while($current=$query->fetch(PDO::FETCH_ASSOC)) {
            recursiveDelete($current['id'],$db_conn);
        }
    }
    $db->exec("DELETE FROM ".$table." WHERE id = '".$id."' ");
}
recursiveDelete($_POST['id'],$db,$TableMaster);

ERROR PHP LOG:

PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE Father = '99'' at line 1' in

Note: But when I write the name of my mysql table directly in the statement there is no problem.

Whats happen?

You're not passing $table in recursiveDelete() when you do the call recursiveDelete($current['id'],$db_conn); — user10957435
– user10957435, Commented Feb 16, 2019 at 3:16
@RenatoRamosPuma Well, you could try as a debug test echo "SELECT * FROM ".$table." WHERE Padre = '".$id."' " (optional . "<br>\n"); and that should be insightful. — user10957435
– user10957435, Commented Feb 16, 2019 at 3:20

Barmar · Accepted Answer · 2019-02-16 03:24:16Z

3

You left out the $table argument when making the recursive call.

There's also no need for the $db_conn variable, you can just use $db.

function recursiveDelete($id,$db,$table){
    $query = $db->query("SELECT * FROM ".$table." WHERE Padre = '".$id."' ");
    if ($query->rowCount()>0) {
        while($current=$query->fetch(PDO::FETCH_ASSOC)) {
            recursiveDelete($current['id'],$db,$table);
        }
    }
    $db->exec("DELETE FROM ".$table." WHERE id = '".$id."' ");
}

answered Feb 16, 2019 at 3:24

Barmar

789k57 gold badges555 silver badges669 bronze badges

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

3 Comments

user10957435 Over a year ago

What I don't get is why doesn't it throw an error for not having enough arguments?

Renato Ramos Over a year ago

Master you have found the solution, thank you very much. :)

Barmar Over a year ago

@Chipster PHP is permissive about incorrect argument number. I prints a warning, but doesn't throw an error.

Collectives™ on Stack Overflow

PHP Mysql does not accept table name as variable

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related