PHP get string contain url from database

Question

I'm trying to get string from database which is url "http://www.google.com/"

but data I get changed to this http:\ /\ /www.google.com\ /

while($row = mysql_fetch_array($result)){
    // temporary array to create single category
    $tmp = array();
    $tmp["id"] = $row["id"];
    $tmp["name"] = $row["name"];
    $tmp["url"]= $row["url"];

    array_push($response["database"], $tmp);
}

how can I get the url without changed.

Please, don't use mysql_* functions in new code. They are no longer maintained and are officially deprecated. See the red box? Learn about prepared statements instead, and use PDO or MySQLi - this article will help you decide which. If you choose PDO, here is a good tutorial. — esqew
– esqew, Commented Dec 3, 2014 at 5:56
The problem is still there, I try to use both PDO and MySQLi not work.. actually I'm working in json and I put this array in json_encode(), do you think this problem is caused by array? — Alyas Hajri
– Alyas Hajri, Commented Dec 3, 2014 at 19:58

Andrew Fox · Accepted Answer · 2014-12-03 05:58:46Z

2

In your example the two pieces of data are identical, did StackOverflow reformat your data? Your code looks fine to me, perhaps it is a problem with how the data is inserted into the database rather than how it is retrieved. Have you looked at the data in an SQL browser like phpMyAdmin or SQLyog Community Edition to confirm the data is stored as you expect?

answered Dec 3, 2014 at 5:58

Andrew Fox

1067 bronze badges

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

1 Comment

Alyas Hajri Over a year ago

The problem is still there, I try to use both PDO and MySQLi not work.. actually I'm working in json and I put this array in json_encode(), do you think this problem is caused by array?

RichardBernards · Accepted Answer · 2014-12-03 07:10:05Z

1

the stripslashes() builtin function would seem to do the trick.

edited Dec 3, 2014 at 7:10

RichardBernards

3,0971 gold badge24 silver badges30 bronze badges

answered Dec 3, 2014 at 6:48

James Anderson

27.5k7 gold badges55 silver badges81 bronze badges

Comments

Alyas Hajri · Accepted Answer · 2014-12-04 04:30:11Z

I solve this problem actually I want to create .json file, but when we use array and show data like url in php page .php the data will change because it's read as an html code, in json case we have to create another file with in file managment generated after getting data from database

 $response = array(); $response["feed"] = array();

foreach($db->query('SELECT * FROM table') as $row) {

    $tmp = array();
    $tmp['id'] = $row['id'];
    $tmp['name'] = $row['name'];
    $tmp['url']= $row['url'];
    array_push($response['table'], $tmp);          }

//here the data posted into php page so the url change
 echo json_encode($response);
//here create .json data and write data in data.json
$fp = fopen('data.json', 'w');
fwrite($fp, json_encode($response));
fclose($fp);

Collectives™ on Stack Overflow

PHP get string contain url from database

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related