Question: I have a feature on my site that allows my users to create a custom "web page". They can add HTML elements in there, CSS, and custom javascript code as they please.

I plan to store the entire web page (HTML, css, javascript, jquery) code in MySQL data with `TEXT` or `MEDIUMTEXT` (unless you have a better solution maybe?). Im also using PHP.

Here is a part of my insert code:

```
$stmt = prepare("INSERT INTO webpages (content) VALUES (:content));
...

```

How can i secure the content/web page code that is being inserted into the database, and/or secure the text when its displayed?

here is a part of the retrieval code:

```
$stmt = prepare("SELECT * FROM webpages WHERE id = :id");
...

```

thank you

Answer: 
**Try this**

1) File -> Invalidate Caches / Restart

2) Delete the build file under app (F:\gigHub\app\build)

3) Clean Project 

4) Rebuild Project
my problem was that when i used refactor to change one of my variables in class named "rating", it changed all the android:rating attributes to android:rate and that caused this problem.
for those who have this problem, check gradle build error exactly for more information. maybe that's because of your undefined xml attributes.