MySQL Variable Question

JPT

Hey, lets say I have two rows in my MySQL database. I have it set up to grab both of them and put them into variables. The first has some information and has the variable for the second. The second also has some variables in it

Ex.

Row 1:
$Row[name1] <br /> text text text

Row 2:
$Row[blah] <br />
$Variable1

It is set up somewhat like that.

I set up an eval so that when I call for the first row it will correctly show the $Row[name1] as the information in that row.

The only problem as some of you probably have guessed is the variables in Row 2 do not show their values Row 2 is called by Row 1.

Is there any way to get Row 2s variable values to show up rather than the variables themselves?

mmilano

code samples would help everyone understand. not sure what you mean with your eval logic.

also, every row will have the same variable names. so if the key 'name1' is in row1, then it will be in row 2. likewise, if key (or column) 'blah' was in row1, it will be in row 2 as well.

anyway, here's a simple way to request and print 2 rows. maybe you can work with this:

<?php
$result = mysql_query("select * from table");

while ($row = mysql_fetch_array($result)) {
  echo $row['name1'] . " " . $row['name2'] . "<br>";
}

mysql_close();
?>

JPT

Shoot, I knew I didn't make much sense... :p

Ok what I am trying to say is I have variables inside variables inside variables.

ex.

$Variable1 = 'example';

$Variable2 = 'This is an $Variable1';

$str = '$Varable2.  I suck at describing things :)';

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

Essentially that is what I am trying to do, but some of the variables, $Variable1 and $Variable2, are pulled from the MySQL database (Which I can do just fine.). But the $Variable1 would remain $Variable1. It would not change to 'example'. While $Variable2 would work as expected.

So essentially the end result would be this:

This is an $Variable1. I suck at describing things 🙂

It needs to be like this:

This is an example. I suck at describing things 🙂

I've tried to run an eval (similar to the one above) on both the $str and the $Variable1 variables (One eval per thing), but I still get the same results

Is there any way to get it to work how I want it to?

wilku

It's simpler then you think:

$Variable1 = 'example'; 

$Variable2 = "This is an $Variable1"; 

$str = "$Variable2.  I suck at describing things :)"; 

echo $str;

Note the usage of double quotes.

JPT

As I have said the actual information I am gathering is from the database rather than me pre-defining the variables.

Think of the values in my example as information the code has gathered from the database rather than something I hard coded into the script.

cahva

It doesnt matter where you get the data. The principle is the same:

while ($row = mysql_fetch_array($result)) {
  $var1 = '$row[\'name1\'] = '.$row['name1'];
  $var2 = '$row[\'name2\'] = '.$row['name2'];
  $var3= "Here are {$var1} and {$var2}";
  $str = '$var3 contains: '.$var3;

  echo $str;
}

That might be the lamest example ever but it shows you different ways to define variables contents 🙂

JPT

The problem is the primary function for these variables is a template and phrase system. I have a function that grabs all of the templates and phrases and put them in variables (ex. $tpl['header'] & $phr['site_title']). Maybe I am going at this all wrong... If so please help 😃

So by the time I am done I will have hundreds. It would be kind of tedious to do something like that to all of them. Also I am trying to make it so it is as modifiable as possible so in some skins there may be 5 variables in a certain template but in another skin there may be 2 variables.

I probably should have explained this from the beginning... sorry

ex. of part of what I am doing.

$tpl['log_in'] contains:

$tpl[header]

Which works fine. It displays the value of $tpl[header].

However in $tpl[header] is:

<html code blah blah>
<title>$phr[site_title]</title>
<html blah blah>
<div id=header>
$phr[site_title]
</div>
blah blah w/e blah

Of course that is not the most accurate description of what is actually in there :p but I hope you get the point.

NogDog

Embedding PHP-style variable names within a string will mean nothing unless you use [man]eval[/man] to execute a command using that string. But using eval() is both a security risk and is really unnecessary in at least 99.9% of the cases where it's used. Instead I would recommend using something like [man]str_replace/man or [man]preg_replace/man to replace place-holders within your string with the desired value. E.g.:

$text = '<html code blah blah>
<title>[[site_title]]</title>
<html blah blah>
<div id=header>
[[site_title]]
</div>
blah blah w/e blah';
$site_title = "This is a test";
echo str_replace('[[site_title]]', $site_title, $text);

JPT

Edit: Wow... I got it to work! And it works beautifully! Only took me a day or so! LOL 😃

Thanks everyone for your help. str_replace works like a charm 😃