Take Result Mysql assign PHP variables

Question

When I do a mysql select statement, I get the below when echo'ing $result;

echo $row['comment2'];

Gives me this:

$fullname = ddasdfd; 
$bacc = 324234234; 
$brouting = 23423434; 
$btype = checking; 
$btype2 = personal; 
$bankname = 234234234;

How do I use that result that I got when select a text field inside my mysql table and assign it to php variables so I can do:

echo $fullname;

Any kind of help I can get on this is greatly appreciated!

Current code:

$query = "select * FROM `store`.`oc_order` WHERE `order_status_id`='10' AND `achgroup`='' ORDER BY `date_added` LIMIT 10"; 
  $result = mysql_query($query,$db) or die(mysql_error());
  while($row = mysql_fetch_array($result)) {

  echo $row['comment2'];

I want when echo'ing ddasdfd:

paste your current code

cornelb
– cornelb

2014-02-27 06:58:18 +00:00
Commented Feb 27, 2014 at 6:58 — cornelb
– cornelb, Commented Feb 27, 2014 at 6:58

Alma Do · Accepted Answer · 2014-02-27 07:10:13Z

2

While most obvious way would be something that involves eval() - I strongly recommend you to avoid that. It's completely unsafe.

Thus, you can resolve your case with some regex stuff and extract() results:

$result='$fullname=ddasdfd; $bacc=324234234; $brouting=23423434; $btype=checking; $btype2=personal; $bankname=234234234;';
preg_match_all('/\$([a-zA-Z][a-zA-Z0-9]*)\s*\=\s*([^;]*);/ms', $result, $matches);
$matches = array_combine($matches[1], $matches[2]);
extract($matches); //now $fullname, $bacc and so on are in global scope

Note, that:

It will not check syntax. Yes, it will fail if syntax isn't correct
It will not check if variables have valid names
It will not check if values are "good" (so delimiter is ;)

And, in fact, it shouldn't do that (because regex isn't thing that may or should be used for such issues). To say more, as more correct way I see normalization of your initial data somehow that you will avoid things like this - i.e. dealing with parsing/executing PHP code.

edited Feb 27, 2014 at 7:10

answered Feb 27, 2014 at 7:03

Alma Do

37.4k10 gold badges81 silver badges106 bronze badges

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

2 Comments

thevoipman Over a year ago

Is there anyway we can remove any odd characters within the results... I noticed that if I have $fullname=dasdddf&adfsdfd - then the code acts up....

Alma Do Over a year ago

What characters are 'odd' and where?

Loïc · Accepted Answer · 2014-02-27 07:01:14Z

1

If your $result variable contains a string with var_name = value separated by \n then you can do :

$results = explode('\n', $results);
foreach ($results as $result){
    eval($result);
}

echo $fullname;

Pay attention though, eval can lead to important security issues. Don't eval untrusted data.

answered Feb 27, 2014 at 7:01

Loïc

12k2 gold badges35 silver badges52 bronze badges

Comments

user1710796 · Accepted Answer · 2014-02-27 07:01:22Z

0

Not having seen your code, it should look something like this:

$resultsArray = mysql_fetch_assoc($result);
$fullname = $resultsArray['fullname'];
$brouting = $resultsArray['brouting']; 
$btype = $resultsArray['btype']; 
$btype2 = $resultsArray['btype2']; 
$bankname = $resultsArray['bankname'];

From here you should be able to echo the variables freely.

answered Feb 27, 2014 at 7:01

user1710796

Collectives™ on Stack Overflow

Take Result Mysql assign PHP variables

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related