I have 100's of files that access a field in a mySQL DataBase. I had to change the field name and now I have to update 100's of files. The files read:
$sql = 'SELECT user_id, username, user_colour, user_birthday FROM 'I need it to now read:
$sql = 'SELECT id, nick, user_colour, user_birthday FROM 'I know I could go through all files and execute a replace 'user_id' with 'id', but that would take forever. Does anyone know a program to do this easier?
Off the top of my head, Dreamweaver has a search and replace (CTRL-F) function that will allow you to batch replace an entire folder/website/etc.
While you are finding and replacing, you might consider replacing 100 instances of the same code with an include path to a single script to make future revisions less painful.
If you're on linux then grep is your friend. Also as Johnsquibb said, if you have probably over 5 instances of identical code, put it in one file then just include it.
Off the top of my head, Dreamweaver has a search and replace (CTRL-F) function that will allow you to batch replace an entire folder/website/etc.
While you are finding and replacing, you might consider replacing 100 instances of the same code with an include path to a single script to make future revisions less painful.
Hey..that sounds like a good idea. Do you have any advise on how to get started with something like that
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.