Example #1
0
function Fdbd_getRow($tbl, $where)
{
    try {
        Fcom_setLogInfo("debug", "where:" . $where);
        return Fdbd_getTableData($tbl, "*", $where);
    } catch (Exception $e) {
        throw new Exception('ERR(File:' . basename(__FILE__) . ',Line:' . __LINE__ . '):' . __FUNCTION__ . '()' . PHP_EOL . $e->getMessage());
    }
}
Example #2
0
function Fitm_search()
{
    try {
        $ret = "test";
        if (false === isset($_POST["key"])) {
            throw new Exception('ERR(File:' . basename(__FILE__) . ',Line:' . __LINE__ . '):invalid param');
        }
        $ttl = $_POST["key"];
        $ret = Fdbd_getTableData("tb_item", "*", "title='" . $ttl . "'");
        return $ret;
    } catch (Exception $e) {
        throw new Exception('ERR(File:' . basename(__FILE__) . ',Line:' . __LINE__ . '):' . __FUNCTION__ . '()' . PHP_EOL . $e->getMessage());
    }
}
Example #3
0
function Fitm_getConts($id)
{
    try {
        $item = Fdbd_getTableData("tb_item", "*", "id=" . $id);
        $type = Fdbd_getTableData("tb_itemtype", "*", "typeid=" . $item["typeid"][0]);
        $tagchk = Fdbd_getTableData("tb_itemtag", "*", "itemid=" . $id);
        $tag = array();
        foreach ($tagchk["tagid"] as $tagid) {
            $tag_buf = Fdbd_getTableData("tb_tag", "*", "tagid=" . $tagid);
            $tag[] = $tag_buf["tag"][0];
        }
        $ret_val = array("title" => $item["title"][0], "tag" => $tag, "type" => $type["type"][0], "conts" => $item["conts"][0], "desc" => $item["desp"][0]);
        return $ret_val;
    } catch (Exception $e) {
        throw new Exception('ERR(File:' . basename(__FILE__) . ',Line:' . __LINE__ . '):' . __FUNCTION__ . '() path:' . $path . PHP_EOL . $e->getMessage());
    }
}
Example #4
0
function Fitm_setItemTag($itemid)
{
    try {
        if (false === isset($_POST['tag'])) {
            return;
        }
        $ptag = $_POST['tag'];
        foreach ($ptag as $t_elm) {
            $tag = Fdbd_getRow(DITM_TBNAME_TAG, "tag=\"" . $t_elm . "\"");
            if (null === $tag) {
                Fdbd_insert(DITM_TBNAME_TAG, array("tag" => $t_elm));
                $max = Fdbd_getTableData(DITM_TBNAME_TAG, "max(tagid)", "tag=\"" . $t_elm . "\"");
                $tagid = $max["max(tagid)"][0];
            } else {
                $tagid = $tag["tagid"][0];
            }
            $t_dat = array("itemid" => $itemid, "tagid" => $tagid);
            Fdbd_insert(DITM_TBNAME_ITMTAG, $t_dat);
        }
    } catch (Exception $e) {
        throw new Exception('ERR(File:' . basename(__FILE__) . ',Line:' . __LINE__ . '):' . __FUNCTION__ . '()' . PHP_EOL . $e->getMessage());
    }
}
Example #5
0
<?php

require_once dirname(__FILE__) . "/Sdbd_mysql.php";
try {
    //$test = Fdbd_getTableData( "tb_itemtype" , "type=\"command\"" );
    //$test = Fdbd_getTableData( "tb_item" , "max(id)" , "title=\"fdsaf\" and typeid=3 and conts=\"fadsfd\"" );
    // $test = Fdbd_getRow( "tb_tag" , "tag=\"test\"" );
    $test = Fdbd_getTableData("tb_item", "distinct title", null);
    var_dump($test);
    $dat = array("title" => "test", "typeid" => 3, "conts" => "contents", "desp" => "test");
    //Fdbd_insert( "tb_item" , $dat );
} catch (Exception $e) {
    echo $e->getMessage();
}
Example #6
0
<?php

require_once dirname(__FILE__) . "/../com/dbd/Sdbd_mysql.php";
try {
    var_dump(Fdbd_getTableData("tb_item", "*", "id=1"));
} catch (Exception $e) {
    echo $e->getMessage();
}