how to execute function retrieve from database in php with mysql..?

Question

I have a database table with the name of validation that contains data like

 vNo    Chkvalidate
   1    Check_Value ('Category_Code', '', '', '1', '', '1')=1
   2    Check_Value ('Category_Code', '', '', '2', '', '')=1 AND Check_Value ('Subject_Code', '', '', '1', '', '1')=1

The function definitions written in validation.php file like this:

 function Check_Value($col_name, $to_range, $from_range, $list_value, $stat, $counter)
    {
      // Some definition here...
    }

How can I invoke the function Check_Value when I fetch record row by row from validation table...?

I'm not sure I understand what your problem is exactly? Fetching the records, or something else? — Pekka
– Pekka, Commented Jan 9, 2011 at 10:13
It seems you not only want to invoke it but also compare against a value (=1)? The function that shall not be named seems to be the easiest way.... but its evil! — Felix Kling
– Felix Kling, Commented Jan 9, 2011 at 10:15
Please show us your real database schema and data. Is this the same Check_Value function as in your last question? stackoverflow.com/questions/4615468/… — mario
– mario, Commented Jan 9, 2011 at 10:25
PEkka: my problem is that when i fetch the records from database can i invoke the function on the basis of the record...? — saint
– saint, Commented Jan 9, 2011 at 11:33
mario: Check_Value function is a function store in a table but its definition store in validation.php file. — saint
– saint, Commented Jan 9, 2011 at 11:38

John Parker · Accepted Answer · 2011-01-09 10:15:02Z

0

You simply need to use PHP's eval function to evaluate the string you obtain from the database.

That said, I'd be very tempted to re-factor the offending part of the application, as storing (and subsequently evaluating) functions that reside in a database gives off such a strong code smell that a gas mask is required.

answered Jan 9, 2011 at 10:15

John Parker

54.5k11 gold badges133 silver badges131 bronze badges

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

Collectives™ on Stack Overflow

how to execute function retrieve from database in php with mysql..?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related