PHP replace a character in string fetched from mysql

Question

I'm trying to replace a string which contains value with operator : like "2456:72" to "2456.72" where data is fetched from mysql, I tried using str_replace which sucks. $row_loop3["Tot_minutes"] is the row which I should replace the character, please find my code:

$mysqli = new mysqli("172.16.10.102", "******", "RND@ISO-3306", "eTrans");
if (!$mysqli->multi_query("call sp_get_Android_Online_minutes_Chart ('2015-01-01','2016-01-30')")) {
    $response["success"] = 0;
}
do {
    if ($res_loop3 = $mysqli->store_result()) {
        $response_loop3["minutes"] = array();
        $find                      = ":";
        $re                        = ".";

        while ($row_loop3 = $res_loop3->fetch_assoc()) {
            $j                            = 5;
            $value_loop3                  = array();
            $value_loop3["File_Day"]      = $row_loop3["edit_date"];
            $value_loop3["File_Minutes"]  = $row_loop3["FileDay"];
            $val["Tot1_Minutes"]          = $row_loop3["Tot_minutes"];
            $value_loop3["Total_Minutes"] = str_replace($val, $find, $re); //value which I should replace : with .
            array_push($response_loop3["minutes"], $value_loop3);
            $response_loop3["success"] = 1;
        }

        echo $merger = json_encode(array_merge($response, $response_loop2, $response_loop3));

        $res->free();
    }
} while ($mysqli->more_results() && $mysqli->next_result());

please help me, thanks in advance

@Mr.Engineer No, am getting result as {"File_Day":"2015-01-02","File_Minutes":"2","Total_Minutes":"."}, where entire string is replaced by "." — Balaji Ravichandran
– Balaji Ravichandran, Commented Feb 3, 2016 at 7:50

Afsar · Accepted Answer · 2016-02-03 07:54:39Z

1

You are not making variable instead you are making associative array. change this

 $val["Tot1_Minutes"] = $row_loop3["Tot_minutes"];

to

 $val= $row_loop3["Tot_minutes"];

and also order in str function to

$val = $row_loop3["Tot_minutes"];
$value_loop3["Total_Minutes"]=str_replace($find,$re,$val);

edited Feb 3, 2016 at 7:54

answered Feb 3, 2016 at 7:50

Afsar

3,1242 gold badges27 silver badges35 bronze badges

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

Comments

Mr. Engineer · Accepted Answer · 2016-02-03 08:03:09Z

1

str_replace should be used in this way:

str_replace( mixed $search , mixed $replace , mixed $subject [, int &$count ] )

The function's argument are search, replace, and subject, so for your case should be like : str_replace($find,$re,$val)

edited Feb 3, 2016 at 8:03

Mr. Engineer

3,5254 gold badges19 silver badges34 bronze badges

answered Feb 3, 2016 at 7:53

Tan See Youu

747 bronze badges

Collectives™ on Stack Overflow

PHP replace a character in string fetched from mysql

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related