3 replies to this topic

[woocha]

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?

[v0id]

Some text-editors has this function as a built-in feature. You should check out if your text-editor has it. You'll probably find the feature under the name of "replace," or something similar.

[woocha]

Thanks man...I'll check my editor:)

[ETbyrne]

You could use PHP if you copied the source code to a normal text file first:

<?php

$content = file_get_contents("myscript.txt"); // not the PHP file

$content = str_replace("user_id", "id", $content)
// And so on and so forth...

// Then you would have to have it write the new code in to the
// text file
?>