str_replace help

Posted on 16th Feb 2014 07:03 pm by admin

I am thinking str_replace is my only option to filter outputs from my database to convert them to safe url variables.

I am working with a database with over 4million records, and apparently when the database was created no one though about database safety, or site safety or I don't think much in general.

So that said in the database I have characters like & ' " etc.. stuff that most people will sanitize in one way shape form or another and store as such. I guess with this post I am trying to find out what are the most important characters such as above mentioned that I should attempt to filter out, or filter differently. I am also using some of these variables within URL's so its important that I can pass them through URL variables.

The urls are being phased in 2 ways one, your standard long url (ie: index.php?a=var&b=var&c=var) and then a more SEO friendly version /a/var/b/var/ in either event I cant have ' " & other in the URLs they just dont work. For other reasons I cant have them just output in the code. So what ever characters i need to filter out and what I should filter them out as that as, as in what would you suggest to phase them as? Anything that could break code, or not work in a URL I need to know.

Also if anyone knows a better way to do it than str_replace("&", "What to replace"); ill take advice there too :-)

Your Answer:

Login to answer

Other forums

 formating when pulling data from a mysql database 
Ok so Im not to sure if this is the right thread to post in but here is my catch 22 issue.

I 
PHP url branch?? 
Functionally, using PHP, I'm doing a test of login input submitted by a user via an html form in a f
Generate PDF 
Hi guys,

I would like to know if there is a way to generate pdf when clicking on a link. In f
Place specific image in html page when specific name is typed. 
Hello,

Fairly new to PHP and was curious if someone might know how to solve a fairly simple r
Vertical Alligning - Not working in 1 cell? 
<?php

echo "<table id="valign" width="60%" style=
Users and Groups with PHP Classes 
Hi,

I have setup what I hope to be a good working User class. Now I want to introduce group m
present value of sequence? 
Hi



Please help me to find out the present value of sequence?



Thanks
RSS feed - FeedList for WordPress 
Hi,

I'm trying to alter the FeedList plugin for WordPress so that I can click on the title of
Change Age automatically 
hi guys . im new to php , is it possible to change age value in mysql automatically when year change
NOOB needs help with upload file 
The intent of this form is to create a folder for a client and upload an image into another folder '