CODEWITHSUNDEEP
phpjavascriptmysqlhtmldatabase
baptx
baptx

Reputation: 3896

Best way to load content into application

I have a project where I need to write text from a database into an HTML5 canvas / Javascript application.

To select this content, I've specified an attribute "reference" where I can ask the database with the content id, for example: index.php?reference=exercise1.

I have used AJAX because I need to get the text content into a Javascript variable in order to write data on canvas. My solution is working but I need to get the reference attribute value from Javascript document.URL and not PHP $_GET.

Here is the code:

var url = decodeURIComponent(document.URL);
var attr = "reference";
var attrPos = url.lastIndexOf(attr);
var referencePos = attrPos + attr.length + 1;
var reference = url.substr(referencePos,url.length);

What I'm doing seems not to be the clean way to me.

First, ?reference= should be used with PHP $_GET and not be hacked through Javascript.

Then, I have to use lastIndexOf() instead of the search() method in order to get the good value if my application is located in a folder named "reference".

Still, if I have my project in a folder named "reference" with a URI like localhost/reference/projectfolder/index.php and a reference named "projectfolder" in the database, it will load the content even if I have not asked for index.php?reference=projectfolder

From your experience, what is the best solution in my case: be able to get PHP/MySQL data to use with Javascript. Ajax seems to be the best way but as you can see it's not clean, at least my solution.

Thanks for your help.

Upvotes: 2

Views: 226

Answers (1)

Joelmob
Joelmob

Reputation: 1106

Still, if I have my project in a folder named "reference" with a URI like localhost/reference/projectfolder/index.php and a reference named "projectfolder" in the database, it will load the content even if I have not asked for index.php?reference=projectfolder

if you want the document to be empty when you are requesting just index.php, check if $_GET["reference"] is set and then return an empty body.

From your experience, what is the best solution in my case: be able to get PHP/MySQL data to use with Javascript. Ajax seems to be the best way but as you can see it's not clean, at least my solution.

Check this gist on how to return JSON in your body https://gist.github.com/2627924

Upvotes: 1

Related Questions