I-Circle Forum

$rss = file_get_contents("http://feed250.photobucket.com/albums/gg268/castlecastle/computer_teach/feed.rss");

$p = explode("<item>", $rss);
$photo_num = count($p)-1;
for($i = 1;$i <= $photo_num;$i++){
$photo_url = explode('<guid>', $rss);
$photo_url[$i] = explode('</guid>', $photo_url[$i]);
$photo_title = explode('<media:title>', $rss);
$photo_title[$i] = explode('</media:title>', $photo_title[$i]);

$db->query("INSERT INTO photo (pid, alid, id, url, title, description, time, hits, able) VALUES ('', '1', '1', '{$photo_url[$i][0]}', '{$photo_title[$i][0]}', '{$photo_title[$i][0]}', '$time_now', '0', '1');");
}

SkyBread 寫:

$rss = file_get_contents("http://feed250.photobucket.com/albums/gg268/castlecastle/computer_teach/feed.rss");

$p = explode("<item>", $rss);
$photo_num = count($p)-1;
for($i = 1;$i <= $photo_num;$i++){
$photo_url = explode('<guid>', $rss);
$photo_url[$i] = explode('</guid>', $photo_url[$i]);
$photo_title = explode('<media:title>', $rss);
$photo_title[$i] = explode('</media:title>', $photo_title[$i]);

$db->query("INSERT INTO photo (pid, alid, id, url, title, description, time, hits, able) VALUES ('', '1', '1', '{$photo_url[$i][0]}', '{$photo_title[$i][0]}', '{$photo_title[$i][0]}', '$time_now', '0', '1');");
}

呢3個 { } 搞到我煩足成晚...
唔加會變哂Array[0]...

iamfreeman 寫:

SkyBread 寫:你中左Discuz!毒

代碼: 選擇全部

$db->query('INSERT INTO photo (pid, alid, id, url, title, description, time, hits, able) VALUES (\'\', \'1\', \'1\', \'' . $photo_url[$i][0] . '\', \'' . $photo_title[$i][0] . '\', \'' . $photo_title[$i][0] . '\', \'' . $time_now . '\', \'0\', \'1\');');

代碼: 選擇全部

$db->query("INSERT INTO photo (pid, alid, id, url, title, description, time, hits, able) VALUES ('', '1', '1', '{$photo_url[$i][0]}', '{$photo_title[$i][0]}', '{$photo_title[$i][0]}', '{$time_now}', '0', '1');");

代碼: 選擇全部

$db->query("INSERT INTO `photo` (`pid`, `alid`, `id`, `url`, `title`, `description`, `time`, `hits`, `able`) VALUES ('', '1', '1', '{$photo_url[$i][0]}', '{$photo_title[$i][0]}', '{$photo_title[$i][0]}', '{$time_now}', '0', '1');");

bananasims 寫:改咗回覆
加多啲乜？

代碼: 選擇全部

' . $variable . '

bananasims 寫:不過啲 \' 都幾煩下

代碼: 選擇全部

mysql_query('SELECT xxx
                   FROM yyy
                   WHERE zzz <> ' . $val . ');

bananasims 寫:Syntax Error
我指好似青山咁既 case
不過我會 prefer 全部 SQL 都用 double quotation mark，改起黎都方便

bananasims 寫:

iamfreeman 寫:

SkyBread 寫:你中左Discuz!毒

phpBB 都係咁寫
其實用 double quotation mark 開係好寫過用 single quotation mark 開（相信大家都知 string 用 double 同 single 有乜分別）
如果個 string 有好多 single quotation mark 同埋 variable 的話，double quotation mark 就慢少少，不過啲碼靚；single quotation mark 就快，不過啲碼亂

比個例子，好似 Skybread 啲碼

代碼: 選擇全部

$db->query('INSERT INTO photo (pid, alid, id, url, title, description, time, hits, able) VALUES (\'\', \'1\', \'1\', \'' . $photo_url[$i][0] . '\', \'' . $photo_title[$i][0] . '\', \'' . $photo_title[$i][0] . '\', \'' . $time_now . '\', \'0\', \'1\');');

啲 backward slash「\」同啲「' . $variable . '」睇到你頭都暈。
所以喺 SQL 層面，我會比較 prefer 用 double quotation mark。
以安全同標準計，不論 array 與否，我都會用大括號包住。
好似咁：

代碼: 選擇全部

$db->query("INSERT INTO photo (pid, alid, id, url, title, description, time, hits, able) VALUES ('', '1', '1', '{$photo_url[$i][0]}', '{$photo_title[$i][0]}', '{$photo_title[$i][0]}', '{$time_now}', '0', '1');");

不過我寫就當然會同 SQL 「包裝」一下

代碼: 選擇全部

$db->query("INSERT INTO `photo` (`pid`, `alid`, `id`, `url`, `title`, `description`, `time`, `hits`, `able`) VALUES ('', '1', '1', '{$photo_url[$i][0]}', '{$photo_title[$i][0]}', '{$photo_title[$i][0]}', '{$time_now}', '0', '1');");

跟標準、好睇之餘，用「`」LEFT JOIN 都好有用

iamfreeman 寫:

SkyBread 寫:

$rss = file_get_contents("http://feed250.photobucket.com/albums/gg268/castlecastle/computer_teach/feed.rss");

$p = explode("<item>", $rss);
$photo_num = count($p)-1;
for($i = 1;$i <= $photo_num;$i++){
$photo_url = explode('<guid>', $rss);
$photo_url[$i] = explode('</guid>', $photo_url[$i]);
$photo_title = explode('<media:title>', $rss);
$photo_title[$i] = explode('</media:title>', $photo_title[$i]);

$db->query("INSERT INTO photo (pid, alid, id, url, title, description, time, hits, able) VALUES ('', '1', '1', '{$photo_url[$i][0]}', '{$photo_title[$i][0]}', '{$photo_title[$i][0]}', '$time_now', '0', '1');");
}

呢3個 { } 搞到我煩足成晚...
唔加會變哂Array[0]...

你中左Discuz!毒

SkyBread 寫:insert有得left join咩...

SkyBread 寫:

iamfreeman 寫:

SkyBread 寫:

$rss = file_get_contents("http://feed250.photobucket.com/albums/gg268/castlecastle/computer_teach/feed.rss");

$p = explode("<item>", $rss);
$photo_num = count($p)-1;
for($i = 1;$i <= $photo_num;$i++){
$photo_url = explode('<guid>', $rss);
$photo_url[$i] = explode('</guid>', $photo_url[$i]);
$photo_title = explode('<media:title>', $rss);
$photo_title[$i] = explode('</media:title>', $photo_title[$i]);

$db->query("INSERT INTO photo (pid, alid, id, url, title, description, time, hits, able) VALUES ('', '1', '1', '{$photo_url[$i][0]}', '{$photo_title[$i][0]}', '{$photo_title[$i][0]}', '$time_now', '0', '1');");
}

呢3個 { } 搞到我煩足成晚...
唔加會變哂Array[0]...

你中左Discuz!毒

你指mysql個class定係explode??