Replace php echo output with certain variable

Question

I have a mysql data table with "itemLevels" (numbers). So if i echo the itemlevels out i want that they get replaced with a certain text.

itemLevels 1 => Text1; itemLevels 2 => Text2; itemLevels => Text3

At the moment i have the following code:

<?php
$con = mysqli_connect("localhost","XXXXXX","XXXXX","XXXXX");


// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }



/* change character set to utf8 */
if (!mysqli_set_charset($con, "utf8")) {
    printf("Error loading character set utf8: %s\n", mysqli_error($con));
    exit();
} else {

}

$sql = "SELECT * FROM TEST WHERE name=test";

$result = mysqli_query($con,$sql)or die(mysqli_error());

echo "<table>";


while($row = mysqli_fetch_array($result)) {
    $name= $row['name'];
    $itemLevel= $row['itemLevel'];


    echo
"<tr><td class='name'>".$name."</td></tr>
<tr><td class='name'>Gegenstandsstufe ".$itemLevel."</td></tr> 
</tr>";
}

echo "</table>";
mysqli_close($con);
?>

I´ve read about "php str_replace" but im not sure if it is the right idea and how to use it in my code.

Yes , use str_replace string function. See this manual: -- php.net/manual/en/function.str-replace.php — Jaydeep Baldaniya
– Jaydeep Baldaniya, Commented Dec 26, 2015 at 13:57

Lumen · Accepted Answer · 2015-12-26 13:58:14Z

1

You can just use an array

$itemLevelNames = [
    0 => 'Text0',
    1 => 'Text1',
    2 => 'Text2',
    42 => 'Text42',
    // and so on
];

And then output the text via

echo $itemLevelNames[$itemLevel];

answered Dec 26, 2015 at 13:58

Lumen

3,5842 gold badges22 silver badges33 bronze badges

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

2 Comments

Hertus Over a year ago

Where do i put in the array? Inside the while loop?

Lumen Over a year ago

@Hertus No, you can put it outside of the loop, because – I assume – the names of the item levels don’t change inside the loop.

Collectives™ on Stack Overflow

Replace php echo output with certain variable

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related