找一个对php跟mysql很熟悉的人

:34:有些问题搞不懂想问一下。。如果有人会麻烦联系一下我:35:谢谢

应该不少人吧？ 呵呵 有什么事请问好了。Developer here....

Info	name	time
BEGIN: X-LIC-LOCATION:Europe/Paris SUMMARY:Test Subject 1 DATESTART：Test DS 1 DATEEND：Test DE 1 LOCATION: Test Location 1 TIMEZONE: Test TZ 1 DESCRIPTION:Test Description 1 END	Test	１１：４０：００
BEGIN: X-LIC-LOCATION:Europe/Paris SUMMARY:Test Subject 2 DATESTART：Test DS 2 DATEEND：Test DE 2 LOCATION: Test Location 2 TIMEZONE: Test TZ 2 DESCRIPTION:Test Description 2 END	Test	１２：３０：００
BEGIN: X-LIC-LOCATION:Europe/Paris SUMMARY:Test Subject 3 DATESTART：Test DS 3 DATEEND：Test DE 3 LOCATION: Test Location 3 TIMEZONE: Test TZ 3 DESCRIPTION:Test Description 3 END	Test	１２：４０：００

上面是
table1的data我想提出table1里面叫info那个column的数据然后输入到table2里面(用php来insert) 当判断info里面第一行是SUMMARY：的时候就把后面的内容都输入到table2里面的subject里第二行就输入location



像这样

name	subject	location	description	time
Test	Test Subject 1	Test Location 1	Test Description 1	１１：４０：００
Test	Test Subject 2	Test Location 2	Test Description 2	１２：３０：００
Test	Test Subject 3	Test Location 3	Test Description 3	１２：４０：００

[ 本帖最后由 saimun 于 2011-4-12 14:52 编辑 ]

都不会吗？？？

。。。这不能着急，这点该上学的上学，该上班的上班。。。 等会儿给你个答复

require_once 'db_config.php';
//转换到string
$sql = "SELECT * FROM [tablename1]";
$res = mysql_query($sql));
while($row = mysql_fetch_assoc($res))
{
  $name = $row['name'];
  $time = $row['time'];
  $info = $row['Info'];
  $description = strstr(info, "DESCRIPTION:");
  $info = strstr(info, "DESCRIPTION:", true);
  $location = strstr(info, "LOCATION:");
  $info = strstr(info, "DESCRIPTION:", true);
  $summary = strstr(info, "SUMMARY:");
  $sql = "INSERT INTO [tablename2] (name, subject, description, time, location) VALUES ('$name', '$summary','$description','$time', '$location')";
  $res_insert = mysql_query($sql));

}

i got this error Notice: Use of undefined constant info - assumed 'info'

$description = strstr(info, "DESCRIPTION:"); ==> $description = strstr($info, "DESCRIPTION:");

原帖由 lowpostz 于 2011-4-12 13:17 发表
require_once 'db_config.php';
//转换到string
$sql = "SELECT * FROM [tablename1]";
$res = mysql_query($sql);
while($row = mysql_fetch_assoc($res))
{
  $name = $row['name'];
  $time = $row['time'];
  $info = $row['Info'];
  $description = strstr($info, "DESCRIPTION:");
  $info = strstr($info, "DESCRIPTION:", true);
  $location = strstr($info, "LOCATION:");
  $info = strstr($info, "DESCRIPTION:", true);
  $summary = strstr($info, "SUMMARY:");
  $info = strstr($info, "SUMMARY:", true);
  $sql = "INSERT INTO [tablename2] (name, subject, description, time, location) VALUES ('$name', '$summary','$description','$time', '$location')";
  $res_insert = mysql_query($sql);

}

修改一下,


不过出来的答案还是有点不对哦

我修改一下我的table1给你看看

如果我是用现在这个table1
用你给我的方法。。那在table2出现的结果有不对了 （这是你给我的方法得出的结果）

[tr]

name	subject	location	description	time
Test	SUMMARY:Test Subject 1 DATESTART：Test DS 1 DATEEND：Test DE 1	LOCATION: Test Location 1 TIMEZONE: Test TZ 1		１１：４０：００
Test	SUMMARY:Test Subject 2 DATESTART：Test DS 2 DATEEND：Test DE 2	LOCATION: Test Location 2 TIMEZONE: Test TZ 2		１２：３０：００
Test	SUMMARY:Test Subject 3 DATESTART：Test DS 3 DATEEND：Test DE 3	LOCATION: Test Location 3 TIMEZONE: Test TZ 3		１２：４０：００

[/tr]我只要 SUMMARY：后面的 不过不包括LOCATION：前面的 （就是只要红色那部分， 另外description没显示）

[ 本帖最后由 saimun 于 2011-4-12 14:29 编辑 ]