As I’m programming this database driven website, I’ve come into a few irritating little issues. Today I’ll talk about a few methods to access page content (images) from the back-end.
I’ve created a way to create and edit page content with a browser based WYSIWYG editor. The problem is after the first time the data is submitted to the server, all images are set with a path that now only works from the root directory of the website. So when a user tries to edit some page content with images in the WYSIWYG editor they see broken images (aka. “The dreaded Red X”).
I thought of a few ways to fix the problem. I’ll also mention which method I actually used in the end.
1. Have the PHP script handle the path conversions. This would mean two functions or so with a few replacements using regular expressions. So when the fetched data is sent to the user all of the html image tags are modified. When or if the user sends the data back they are remodified (excluding any new images the user is submitting). This is probably the safest bet.
2. Create a synaptic link if the server is on Linux/Unix. For example if the site root is www/, the site editor is in www/editor, and the content is in www/images. You would create the synaptic link in the www/editor directory linking to www/images directory. Probably the easiest solution by far, but I want my site to work on both Windows and Linux/Unix servers if possible. I’m developing the site on Windows, so I did not try this, but I’m pretty sure it would work. I also know that windows has a way to create similar links, but it seems like a pain to use so I didn’t bother.
3. Use JavaScript to handle the temporary conversion. This is the route I picked. I was just looking for something quick that worked and this was it. Well it wasn’t exactly quick because I spent a few minutes researching what function I needed to use and exactly how it works. The tutorials I saw were lacking…
Here is an example of the code that will do the initial edit, so the user can see the images in the WYSIWYG editor:
The KEY problem that took me a few minutes to figure out was that the first parameter (the regular expression) in the replace function can’t have any type of quotes around it. If you’ve never heard of regular expressions, I highly suggest that you read up on them. They are extremely useful in a multitude of applications. Anyways, what that function does is take data from a wysiwyg html textarea and search through the whole thing for img tags. When it finds one that has a src directory that starts with “images/” it replaces it with “/../images”, this gets the browser to jump back a directory to find the right path to the image folder.
I have this function execute on the body onload event. I’ll also have a second similar function execute on the form onsubmit event. This solution seemed a bit easer then the php one. Well that’s it for now!