I am creating a game with random variables. In the game I have created a dialogue exchange to players. I have set up a table with various returns and I inserted {$fields} to represent various random variables. When I call on the requested fields, I only see the field text and my field names. Am I supposed to parse something and call it back another way?

ie:

myfield is: "You have won {$random1} silver! <br />{$wi['gender'] majesty rewards you well."

the code I am using to call that field is:

if($wi['wsex']=="Male")
{$gender=his;}
else if($wi['wsex']!="Male")
{$gender=her;}
$random1=rand(6,34);
print $wi['myfield'];

It would have been better to copy the code used for assigning myfield a value verbatim instead of describing it. Also please use PHP tags around PHP code.

I assume this is what you did:


You have to enclose {$wi['gender']} in curly braces. The right one is missing in your code.

jlinkels

Sorry about the long description, and the missing curly bracket was only made in my post.

You might want to reconsider what you put into the $wi[] array referencing with $wi['name'], and what you put directly into the variable $name. You have been mixing up those two.

jlinkels

My apologies again, the actual text "You have won $random1 silver! <br />{$wi['gender']} majesty rewards you well." is stored in a field from my database. Depending on a random result, the text will be different each time in the fields ocsuc1, ocsuc2, ocsuc3, ocfail1, and ocfail2.
This is the actual code I am working on:

$sq=$db->query("SELECT wk.*,un.*,oc.* FROM worker wk LEFT JOIN occupation oc ON wk.wkoc=oc.ocid LEFT JOIN unemp un ON wk.wkitm=un.wid WHERE wk.wkid={$_GET['ID']} AND wk.wkuid=$userid");
$wi=$db->fetch_row($sq);
if($wq['wkaction']>$wi['ocaction'])
{
die("Sorry, {$wi['wname']} is just too tired to work again this day, try again tomorrow.<br />
<a href='worker.php'>&gt; Back</a>");
}
$db->query("UPDATE worker SET wkaction=wkaction+1 WHERE wkid={$_GET['ID']} AND wkuid=$userid");
if($wi['wsex']=="Male"){$gen=his;}else if($wi['wsex']!="Male"){$gen=her;}
if($wi['wsex']=="Male"){$gend=him;}else if($wi['wsex']!="Male"){$gend=her;}
if($wq['wkdom']<=rand(1,100))
{
$numb=rand(1,4);
$upkeep=($wi['ocup']*$numb)*$wq['wkrk'];
$gain=($wi['ocpay']*$numb)*$wq['wkrk'];
$num=rand(1, 5);
switch($num)
{
case 1:
print $wi['ocsuc1'];
break;
case 2:
print $wi['ocsuc2'];
break;
case 3:
print $wi['ocsuc3'];
break;
case 4:
print $wi['ocfail1'];
break;
case 5:
print $wi['ocfail2'];
break;
}
}

In each 'case' I have a different script requiring the different $gen, $gend, & $numb arrays (and their calculated results in $gain and $upkeep). I was tying to describe what I was actually trying to do without throwing a bunch of code that, to me, would have been confusing

I suggest that you insert some statements to print out the values of $wi and $wq.

It should become clear soon enough what is in those arrays as compared to what you expect.

From your code I see you are giving $gen and $gend a value, but you don't use it at any further point in the code.

jlinkels

That is because they are in the text of the fields of ocsuc1, ocsuc2, ocsuc3, ocfail1, and ocfail2.

No they are not. You didn't put them there, so they ain't there.

jlinkels

For example, as I have many rows in my data table occupation, the content I have in the field ocsuc1 is:"{$wi['wname']} picks {$numb} pockets and gains {$gain} silver for {$gen} coffer." Where on a different row, ocsuc1 may say: "Your worker {$wi['wname']}, has found {$gain} silver."

The expected result should look like this "Boris picks 2 pockets and gains 12 silver for his coffer." Instead I get "{$wi['wname']} picks {$numb} pockets and gains {$gain} silver for {$gen} coffer."

That doesn't work.

This is simply a string which you retrieve from the database. It is a string with {}, [], $ and '' characters, which are part of the string and don't mean anything for PHP.

If you want to substitute the correct values in the string, you have to build the string inside your php code.

will correctly build the string for you, whereas retrieving this string:
from the database will print out "you won $numb"

But you said that.

You could try to use the eval() function to evaluate the string you get back from MySQL which does what your intend to do. However, you are entering quote and escape hell, and you'll completely loose track about what is string and what is a variable, let alone if you insert array fields with literal names as well. I advice against it, you'd better try to compose the string from the fields you get returned from the database as I explained above.

jlinkels

Thanks, I was afraid of what I was trying to do was not possible or worse yet, taking me to quote and escape hell.

Of course it is possible. As you were told, the eval() function is what you want to use. It does exactly what you are trying to do: takes a string and evaluates it as PHP code.

http://us2.php.net/manual/en/function.eval.php