我一直在堵塞这个简单的脚本,并认为是时候尝试获得一些帮助。我正在尝试使PHP脚本与我的数据库进行通信。我希望能够编写一个包含所有单词的数组,并将所有单词替换为它们。例:
数组(find_word1,replace_word1,find_word2,replace_word2 ....等)
我也希望能够指定表格进行查找,我也会手动更改。
我会手动填写所有的单词,但是我想使它变成动态的,以便在数组长度改变时不会中断。
我尝试了很多东西,到目前为止,
//set up variables and enter your credentials here
$dbname = "name";
$dbhost = "localhost";
$dbpass = "password";
$dbuser = "user";
$tbl_name = "Chairs";
//set up your master array! Array goes in this or
$mstr_array = array(
"find1", "replace1",
"find2", "replace2");
//connect to database
$con = mysql_connect($dbhost, $dbuser, $dbpass) or die('no connection:' . mysql_error());
$db = mysql_select_db($dbname) or die ('cant select db: ' . mysql_error());
// reteive each column
$sql = "SHOW COLUMNS FROM `{$tbl_name}`";
$res = mysql_query($sql) or die ('could not get columns: ' . mysql_error());
$find = 0;
$replace = 1;
while ($col = mysql_fetch_array($res)) {
$sql = "UPDATE `{$tbl_name}` SET `{$col[0]}` = REPLACE(`{$col[0]}`, '{$mstr_array[$find]}' , '{$mstr_array[$replace]}')";
$find = $find + 2;
$replace = $replace + 2;
}
?>任何帮助将不胜感激!谢谢