Solved

How to use a formula stored in mysql, eks: (A + B + C)/(E + F)

Posted on 2006-11-04
5
151 Views
Last Modified: 2010-04-06
How to use several formulas stored in a db?

I have several formulas, it's basic math operations, (AB + AC + AD + AE)/7 etc, the AB' is data has to replaced by values stored in different tables.

I tried to set a rule that each value has to be stored with a space and then split the function up in to a array and the use a loop and then create something like the c++ postfix expression and get the end value,

maybe this can be done easier? I don't like that the formula has to be entered with spaces, it could easily become problem.. I guess that the space thing can be solved by parsing it with regular expressions,

I have tried a bit, here's the start of that code:

sample Formula:( ( A1 + A2 ) + A3 + A4 + A5 + A6 + A7 )

$seperators = array('A1', 'A2','A3','A4','A5','A6', 'A7');

//just replacing the string with a sample number: 1
$str = str_replace($seperators,'1',$str);

$str = (preg_split('# #',$str));

for($i=0; $i<count($str); $i++){

        if( $str[$i] == '+' || $str[$i] == '-' || $str[$i] == '*' || $str[$i] == '/' ){
            //do something
       
        }else if( $str[$i] == ')' ){
            //do something
       
        }else
            //do something
    }
0
Comment
Question by:kkarumu
  • 3
  • 2
5 Comments
 
LVL 19

Accepted Solution

by:
VoteyDisciple earned 250 total points
ID: 17874328
I'm wary of trying to parse expressions by hand, when expressions like that are Context-Free (so a regular expression is insufficient to parse them).  Here's one approach that may be valid if you can carefully control formulas as they're entered:

$variables = array('A1' => 3, 'A2' => 3748.12, ....);
$expression = '((A1 +

foreach($variables as $var => $value) {
     str_replace($var, $value, $expression);
}
eval('$result = ' . $expression);
echo $result;


Instead of str_replace() you'd really have to do a preg_replace() to make sure you don't accidentally fill in the value for A1 in place of A11 and A111 and A1111 and leave a whole huge mess, but the principle is sound.

It's also a nasty way to expose the system if you allow through a formula that actually contains PHP code.  


Just an "out of the box" line of thinking to consider.
0
 
LVL 1

Author Comment

by:kkarumu
ID: 17876885
ok, thanx, that works,

Is it ok to use eval?

have problem as you said to se the differen between A1 and A11..
0
 
LVL 19

Expert Comment

by:VoteyDisciple
ID: 17876902
I'd suggest using preg_replace() instead of str_replace() so you could build a regexp like, perhaps '/\bA1\b/'

Perhaps
$expression = preg_replace('/\b' . $var . '\b/', $value, $expression);

Here note that \b is a "word boundary" in a regular expression, so "A1" followed by another "1" will not be considered an entire word, and will not get matched.  A1 followed by a + or a space or any other non-word character will get replaced.
0
 
LVL 1

Author Comment

by:kkarumu
ID: 17877441
That worked! thanx.

Is it possible to expand the formula with >< (bigger or smaller)?
0
 
LVL 19

Expert Comment

by:VoteyDisciple
ID: 17877661
Absolutely; that's why I suggested eval() -- it'll run absolutely any valid PHP code.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
XSLT 5 41
illegal characters in XML using UTF-8 8 37
I starting with php 12 114
Re-position sub-options beneath the TAB 7 75
Shoutout to Emily Plummer (http://www.experts-exchange.com/members/eplummer26.html) for giving me this article! She did most of it, I just finished it up and posted it for her :)    Introduction In a previous article (http://www.experts-exchang…
I found this questions asking how to do this in many different forums, so I will describe here how to implement a solution using PHP and AJAX. The logical flow for the problem should be: Write an event handler for the first drop down box to get …
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will learn the benefit of using external CSS files and the relationship between class and ID selectors. Create your external css file by saving it as style.css then set up your style tags: (CODE) Reference the nav tag and set your prop…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now