Problem with relative url when linking to external site

Question

I recently installed Grocery CRUD to manage my site. The site is written in php and using mariadb to store the content. I have also activated the CKeditor. Everything works well and i can write an article and "upload" this to my DB. In the articles i often want to link to another sites, this should be straight forward, but its not. When the article is displayed on my website, the URL format is wrong, relative??

Example: Inputs <a href="https://www.test.com">https://www.test.com</a> Expect to see https://www.test.com as a clickable link. This is the result now when looking at the code: <a href="\"https://www.test.com\"">https://www.test.com</a> When hoovering over the link i see https://www.my_domain.com/"https://www.test.com/ I am used to correct this in some situations by adding https://, but this doesnt work in this case.

Im not sure where the error/mistake can be found. Is it the DB that needs some adjustment, is it the CRUD software and particularly the CKeditor that generates this? Maybe some PHP issue somewhere?

I need some advice/help on this please. Does anyone have an idea on how to fix this?

Answer 1

Too many quotes:

<a href="\"https://www.test.com\"">https://www.test.com</a>

The pair of \" is an escaped quotes, as if it is inside some other pair of ". The plain pair of " are ok, too. HTML needs either pair, not both. MariaDB does not care, it is just a string.

MariaDB will not cause that to happen. However, the code that does the INSERT may be screwed up. Let's see that code in Grocery.