mysql remove single quotes and spaces from string

Started by khosango.com, February 22, 2018, 11:40:14 PM

Previous topic - Next topic

khosango.com

I like to remove single quotes from a mysql string but no luck so far.

It's javascript but it has to work for phpmyadmin database and I did not know where to place this.


Code:
   
<script type="text/javascript">
$(document).on("click",".item", function(e) {
var filename = $(this).text().toLowerCase() + '.php';

filename = filename.replace(/\s+/g, '').replace(''', ''); /* remove spaces and non-alpha characters from string */


$('#uitkomst').load(filename);
e.preventDefault();
});
</script>

____________

Advertisement: