dadamssg87 Posted April 22, 2011 Share Posted April 22, 2011 I'm using the codeigniter mvc framework and there's an escape function to use before adding the data to the database. This function adds single quotes around the string of data. Is there any already existing php function or does anyone know how to code a function that strips ONLY the surrounding single quotes? Quote Link to comment https://forums.phpfreaks.com/topic/234455-remove-surrounding-single-quotes-function/ Share on other sites More sharing options...
fugix Posted April 22, 2011 Share Posted April 22, 2011 Look into str_replace() or preg_replace() Quote Link to comment https://forums.phpfreaks.com/topic/234455-remove-surrounding-single-quotes-function/#findComment-1204941 Share on other sites More sharing options...
Pikachu2000 Posted April 22, 2011 Share Posted April 22, 2011 Why do you want to strip them? String data is supposed to be quoted in a query string. Quote Link to comment https://forums.phpfreaks.com/topic/234455-remove-surrounding-single-quotes-function/#findComment-1204942 Share on other sites More sharing options...
dadamssg87 Posted April 22, 2011 Author Share Posted April 22, 2011 it's just for displaying the data. I want it quoted like it should be in the database.Right now if a user inputs something like "phpfreaks" for their username then my welcome message says " Welcome 'phpfreaks'!" Quote Link to comment https://forums.phpfreaks.com/topic/234455-remove-surrounding-single-quotes-function/#findComment-1204949 Share on other sites More sharing options...
Pikachu2000 Posted April 22, 2011 Share Posted April 22, 2011 If the quotes are actually being inserted into the DB, then the strings are getting enclosed in quotes twice, and the inner set is being \escaped somehow. You need to find out why, and correct that problem instead of masking it. Quote Link to comment https://forums.phpfreaks.com/topic/234455-remove-surrounding-single-quotes-function/#findComment-1204953 Share on other sites More sharing options...
dadamssg87 Posted April 22, 2011 Author Share Posted April 22, 2011 hmm good point. thanks. Quote Link to comment https://forums.phpfreaks.com/topic/234455-remove-surrounding-single-quotes-function/#findComment-1204956 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.