comparison recomplete.php @ 27:a34f2ff49097

add: editable title & description
author yoneda <epgrec@park.mda.or.jp>
date Sun, 26 Jul 2009 18:00:11 +0900
parents 95629ba1f043
children e5f9aa34d06f
comparison
equal deleted inserted replaced
26:82c1375ddb4a 27:a34f2ff49097
21 $sqlstr = "use ".DB_NAME; 21 $sqlstr = "use ".DB_NAME;
22 mysql_query( $sqlstr ); 22 mysql_query( $sqlstr );
23 // 別にやらなくてもいいが 23 // 別にやらなくてもいいが
24 $sqlstr = "set NAME utf8"; 24 $sqlstr = "set NAME utf8";
25 mysql_query( $sqlstr ); 25 mysql_query( $sqlstr );
26 $sqlstr = "update mt_cds_object set metadata='dc:description=".mysql_real_escape_string($rrec->description)."' where dc_title='".$rrec->path."'"; 26 $sqlstr = "update mt_cds_object set metadata='dc:description=".mysql_real_escape_string($rrec->description)."&epgrec:id=".$reserve_id."' where dc_title='".$rrec->path."'";
27 mysql_query( $sqlstr ); 27 mysql_query( $sqlstr );
28 $sqlstr = "update mt_cds_object set dc_title='".mysql_real_escape_string($rrec->title)."(".date("Y/m/d").")' where dc_title='".$rrec->path."'"; 28 $sqlstr = "update mt_cds_object set dc_title='".mysql_real_escape_string($rrec->title)."(".date("Y/m/d").")' where dc_title='".$rrec->path."'";
29 mysql_query( $sqlstr ); 29 mysql_query( $sqlstr );
30 } 30 }
31 } 31 }