Translating a Mysql Database Record Value into a PHP command

Question

I have a field database record row that reads like this:

| id |  command  |
------------------
|  1 | getName() |

I also have a PHP entity that is User, and has the getName() function.

Assuming the database record is read and parsed into $record and I have $user, how do I concatenate $record with the $user command?

I tried $user-> . $record['command'] but obviously does not work. I want to avoid hardcoding as I need it to be dynamic if possible.

Example of code:

$record = DB::queryFirstRow("SELECT * from command_records WHERE id='1'");
$user = new User("Kenny");
// Here is where I'm trying to perform the $user->getName() 
// by reading $record['command']. $record['command'] is getName()
$user-> . $record['command'];

It of course fails. I'm thinking of eval from googling earlier but can't get it to work out too.

try posting relevant details of your code.

Sachin Bahukhandi
– Sachin Bahukhandi

2017-07-09 00:29:49 +00:00
Commented Jul 9, 2017 at 0:29 — Sachin Bahukhandi
– Sachin Bahukhandi, Commented Jul 9, 2017 at 0:29
ok, added the comment!

Kenneal
– Kenneal

2017-07-09 00:36:37 +00:00
Commented Jul 9, 2017 at 0:36 — Kenneal
– Kenneal, Commented Jul 9, 2017 at 0:36
what is the error you are facing?

Sachin Bahukhandi
– Sachin Bahukhandi

2017-07-09 00:40:14 +00:00
Commented Jul 9, 2017 at 0:40 — Sachin Bahukhandi
– Sachin Bahukhandi, Commented Jul 9, 2017 at 0:40

Alex Tartan · Accepted Answer · 2017-07-09 00:50:55Z

2

what you're looking for is PHP's variable variables

You can try something like:

class User
{
    public function getName()
    {
        return "SomeName";
    }
}

// assuming this is how your result looks like
$result = [
    'command' => 'getName()',
    // more data
];

$command = $result['command'];            // is "getName()"
$command = str_replace('()','',$command); // is "getName"
// you need to remove the '()'. just get the name of the method

$user = new User();
echo $user->{$command}();
// output: SomeName

See it here: https://3v4l.org/OVYAa

edited Jul 9, 2017 at 0:50

answered Jul 9, 2017 at 0:40

Alex Tartan

6,84410 gold badges37 silver badges47 bronze badges

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

2 Comments

user2864740 Over a year ago

I don't believe this is technically 'variable variables' ... anyway, stackoverflow.com/questions/251485/… shows several different methods.

Kenneal Over a year ago

thanks Alex Tartan and user2864740. Both your answers are very helpful. Learnt something new about PHP today. Have a great day ahead :))

Collectives™ on Stack Overflow

Translating a Mysql Database Record Value into a PHP command

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related