Reputation: 63
I have a db of MySQL queries that I need to output in PHP. The queries include < and > in them and these are getting converted to html tags so the whole query is not outputting. How do I output it without the <> changing?
SELECT
(CASE WHEN measure_start IS NULL AND fy_month = 1 AND fy_day = 1
THEN YEAR(measure_date)
WHEN measure_start IS NULL AND MONTH(measure_date) > fy_month
THEN CONCAT(YEAR(measure_date), '' - '', YEAR(measure_date) + 1)
WHEN measure_start IS NULL AND MONTH(measure_date) > fy_month
THEN CONCAT(YEAR(measure_date) - 1, '' - '', YEAR(measure_date))
WHEN measure_start IS NULL AND MONTH(measure_date) = fy_month AND DAY(measure_date) >= fy_day
THEN CONCAT(YEAR(measure_date), '' - '', YEAR(measure_date) + 1)
WHEN measure_start IS NULL AND MONTH(measure_date) = fy_month AND DAY(measure_date) < fy_day
THEN CONCAT(YEAR(measure_date) - 1, '' - '', YEAR(measure_date))
WHEN measure_date IS NULL AND fy_month = 1 AND fy_day = 1
THEN YEAR(measure_start)
WHEN measure_date IS NULL AND MONTH(measure_start) > fy_month
THEN CONCAT(YEAR(measure_start), '' - '', YEAR(measure_start) + 1)
WHEN measure_date IS NULL AND MONTH(measure_start) < fy_month
THEN CONCAT(YEAR(measure_start) - 1, '' - '', YEAR(measure_start))
WHEN measure_date IS NULL AND MONTH(measure_start) = fy_month AND DAY(measure_start)d>=fy_day
THEN CONCAT(YEAR(measure_start), '' - '', YEAR(measure_start) + 1)
WHEN measure_date IS NULL AND MONTH(measure_start) = fy_month AND DAY(measure_start) < fy_day
THEN CONCAT(YEAR(measure_start) - 1, '' - '', YEAR(measure_start)) END) AS ''Year '',
amount AS amount,
cost AS cost
FROM data_operations
LEFT JOIN data_measure ON data_operations.measure = data_measure.id
INNER JOIN profile_locationmeta ON data_operations.loc_id = profile_locationmeta.loc_id
WHERE data_operations.id IN (SELECT MAX(id)
FROM data_operations
GROUP BY parent_id)
Upvotes: 0
Views: 54
Reputation: 1981
Use htmlspecialchars to echo it on your website.
Assuming that your query is inside the $query variable, that's how you print it
echo htmlspecialchars($query, ENT_QUOTES);
Upvotes: 1