Replace characters from string with database value

Question

I have string message $message = 'Dear $firstname$ $lastname$, your point of city is $city$'

I want to get value from Mysql data table for $firstname$, $lastname$ and $city$ and replace into message.

I have multiple user data selected from databases and New message stored into array.

$query = $ab->pquery("select firstname, lastname, city from tblaccount where country = $country";

$numOfrows = $db->num_rows($query);
for($i=0; $i<$numOfrows; $i++) {
    $toNumber = array();
    $toNumber['firstname'] = $db->query_result($result, $i, 'firstname');
    $toNumber['lastname'] = $db->query_result($result, $i, 'lastname');
    $toNumbers[] = $toNumber;
}

I want firstname, lastname and city replace dynamically for all user and store message into array.

How to Identify $firstname$ replace with result of database filed firstname?

Thomas G · Accepted Answer · 2018-05-14 14:09:11Z

1

An alternative is to let MySQL do the concatenation job, which will result in less PHP intsructions.

$messageSQL = "CONCAT('Dear ', firstname, ' ', lastname, ', your point of city is ', city)";

$query = $ab->pquery("select $messageSQL AS themessage from tblaccount where country = $country";

$numOfrows = $db->num_rows($query);
for($i=0; $i<$numOfrows; $i++) {
    $message =  $db->query_result($result, $i, 'themessage');
    $toNumbers[] = $message;
}

edited May 14, 2018 at 14:09

answered May 14, 2018 at 13:48

Thomas G

10.3k7 gold badges33 silver badges45 bronze badges

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

Comments

Pawel Szalucki · Accepted Answer · 2018-05-14 13:34:59Z

0

            $query = $ab->pquery("select firstname, lastname, city from tblaccount where country = $country";

    $numOfrows = $db->num_rows($query);
    for($i=0; $i<$numOfrows; $i++) {
        $toNumber = array();
$message = 'Dear $firstname$ $lastname$, your point of city is $city$';

        $toNumber['firstname'] = $db->query_result($result, $i, 'firstname');
$message=str_replace('$firstname$',$toNumber['firstname'],$message); ///something like that
        $toNumber['lastname'] = $db->query_result($result, $i, 'lastname');
  $toNumber['message'] = $message;

        $toNumbers[] = $toNumber;
    }

answered May 14, 2018 at 13:34

Pawel Szalucki

322 bronze badges

1 Comment

Andreas Over a year ago

Pawel You should include a description of what your code does in all your answers. I have seen that you are not including much more than the code in your answers and that may be fine on other pages but on SO all answers should have a description. Proper formating is also a good thing.

mighty_dev · Accepted Answer · 2018-05-14 16:37:38Z

0

Just create a new array called $messages and store each of them in this array.

$query = $ab->pquery("select firstname, lastname, city from tblaccount where country = $country";

$messages = array();

$numOfrows = $db->num_rows($query);
for($i=0; $i<$numOfrows; $i++) {
    $firstname  = $db->query_result($result, $i, 'firstname');
    $lastname   = $db->query_result($result, $i, 'lastname');
    $city       = $db->query_result($result, $i, 'city');
    $messages[] = "Dear $firstname $lastname, your point of city is $city";
}

answered May 14, 2018 at 16:37

mighty_dev

17.8k3 gold badges24 silver badges39 bronze badges

Collectives™ on Stack Overflow

Replace characters from string with database value

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related