eval() is flerting with me

[redzzzon]

Thanks for the direction but maybe I can get help before I figure it out.

Well I dont understand the code within the eval() statement.

("\$str = \"$str\";")

<?php

$string = 'cup';
$name = 'coffee';
$str = 'This is a $string with my $name in it.';
echo $str. "\n<p></P>";
eval("\$str = \"$str\";");
echo $str. "\n";

?>

What is the best way, in your opiuon to build one page template with form values that need to change according to the language of the browser. The way I worked it out is to have a table named formid = 123 and langid = portuguses then each column has the value needed pasted via mysql_array_fetch to the page. I am now created a cell that holds the string similar to $a = array('first Name','Last Name'); which is held in the row where langid = english. Similar I have $a = array('Primera Nome', 'Sobre nome'); for when langid = portuguse.

Now I have $a = ($row["fname"], $row["lname"]); and works with a tabel that just deals with one form instance. Its tiresome becaouse I will have many forms. I feel its easier write a array php string and store it into a cell. Then call it when needed.

Any suggestion and help understanding the problem above.

Thanks
Tom

[tsinka]

Hi,

are these values rather static or do you need to change them often ?

Thomas

[redzzzon]

hi tsinka

The values of the form only depented on the users chioce of language.

Due to human factors issues I may want to change a value if a question for the text field is not understood in a translation or the basic construct of the question.

I feel the best way is to have php code in a cell for a particular formid and call it in the eval() function

+----------------+-----------------------------------------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------+-----------------------------------------------------+------+-----+---------+----------------+
formid int(10) unsigned | | PRI | form_name varchar(30) | YES | pageid | varchar(30) | YES | type enum SELECT','SEARCH','INSERET','UPDATE','NON_DB') | | form_values blob | YES | | | description | text

form_values cell contains the array code 🙂

I will try to pose this question the best I can.
do I lose prossesing speed with eval() compared with having the script written without eval() ?

Thanks
Tom

:p :p :p :p

[tsinka]

Seems like unserialize being three to four times faster than eval. So I think that it might be faster to serialize the array before saving it in the table and using unserialize to get it back.

Example (shortened):

$arr = Array('First name','last name');
$arr = mysql_escape_string(serialize($arr));
mysql_query("INSERT INTO .... VALUES (...,'$arr',....)");
//then store the array in the table. 
/-------------
// to get it back
$res = mysql_query("SELECT form_values FROM .....");
$row = mysql_fetch_array($res);
$arr = unserialize($row['form_values']);

I also tested the speed compared to a solution wher I defined all the values in an include script instead of storing them in a table. The require_once took (about two times) longer than the unserialize itself.

I didn't measure the time it takes to get the data itself out of the table. Just play around a little bit yourself. Use eval, serialize/unserialize and try to use includes instead of the database and use the solution you like more.

So unserialize won the little contest, eval was second and require_once/require/include was slowest.

I used test data. Depending on the data you have the results could look a little bit different in your case.

Thomas