본문 바로가기
정보기술/웹&데이터베이스

Alfresco Database 직접 접근 - mysql

by fermi 2010. 12. 6.
/opt/alfresco-3.4.1/mysql/bin/mysql --user=root -p

mysql>show databases;
mysql>use alfresco;
mysql>show tables;
mysql>show columns from tablename;

<?php

$connect = mysql_connect("127.0.0.1:3306", "root", "censamci") or
         die("Could not connect: " . mysql_error());
mysql_select_db("alfresco");
$query = "select content_url from alf_content_url where id = (select content_url_id from alf_content_data where id = (select long_value from alf_node_properties where long_value != 0 and node_id = (select id from alf_node where uuid = '".$node->id."')))";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
    $content_url = $row["content_url"];
}
mysql_free_result($result);
mysql_close($connect);

$content_path = str_replace("store://", "/opt/alfresco-3.4.a/alf_data/contentstore/", $content_url);

?>