array from MySQL question

[dazzathedrummer]

Hi,

 

I have an array that I've set up as a JSON feed API. The array pulls data from a MySQL query, one of the fields in the query ('description') contains text with escape characters.

 

I'm just wondering how I change either the query to remove the escape characters (ie can you strip escape chars in MYSQL?) - or change the array to strip the escape chars??

 

//Run query
$result = mysql_query('
SELECT 
DATE_FORMAT(gl_date,"%d-%m-%Y")as "date",
gl_venue as "venue",
gl_city as "city",
gl_postcode as "postcode",
gl_text as "description",
concat(DAYOFMONTH(gl_date), MONTHNAME(gl_date),".png") AS "imageName"
FROM tg_gig_list 
where
gl_date >= curdate()
and gl_publish = 1
order by gl_date

');



$array = array();
$array['gigs'] = array();
while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
{ 
  $array['gigs'][] = $row;
}
$output = json_encode($array);

}

 

[fugix]

You could u a preg_replace() to get the results that you want

[dazzathedrummer]

You could u a preg_replace() to get the results that you want

 

Thanks for your input, I'm ok on how to remove the escape characters, I'm just wondering what the most efficient way of getting the array would be?

 

[fugix]

if you want the values and/or keys of the array, you can use a foreach() {} loop

[Pikachu2000]

If you have escape characters actually inserted into the database along the data, then you have a problem when the data is being inserted. It is somehow being double-escaped, either by having magic_quotes_gpc on and not handling it with stripslashes, or you're using more than one escaping routine. The escape characters should not end up in the database.

[dazzathedrummer]

If you have escape characters actually inserted into the database along the data, then you have a problem when the data is being inserted. It is somehow being double-escaped, either by having magic_quotes_gpc on and not handling it with stripslashes, or you're using more than one escaping routine. The escape characters should not end up in the database.

 

just having a look at my data,  I'm using mysql_real_escape_string to put the text into the database, the only characters that are coming out of (stored in) the database are "\r\n" for line breaks, these get processed fine in HTML but come through as they are when I take them into an Xcode textarea.

 

Thinking about this I could probably leave them where they are and find/replace them in a method in Xcode - sound like a question for the iOS dev forum!

 

Thanks anyway everyone - for helping me to get to that conclusion!