File: db_sql.php


<?php

include_once "database.php";
$PHP_SELF = $_SERVER['PHP_SELF'];

global $dconn;
if(!isset($dconn))
dbr_connect();

#############
## dir_insert
#############
function dir_insert ($parent_id, $path, $title, $css_url, $keywords_str)
{
    global $PHP_SELF;
    
    $sql = "insert into s_dir
         (dir_id, parent_id, path, title, css_url, keywords_str) 
         values (null, $parent_id, '$path', '$title', '$css_url', '$keywords_str')";
    dbr_query($sql);
    
    $sql = "select LAST_INSERT_ID() from s_dir";
    $stmt = dbr_query($sql);
    $row=dbr_fetch_row($stmt);
    $dir_id = $row[0];
    
    return($dir_id);
}

#############
## page_insert
#############
function page_insert ($dir_id, $page_title, $page_type, $layout, $dynamic_link, $static_link, $is_dirpage, $is_global)
{
    global $PHP_SELF;
    
    $sql = "insert into s_page
         (page_id, dir_id, page_title, page_type, layout, dynamic_link, static_link, is_dirpage, is_global) 
        values
          (null, $dir_id, '$page_title', '$page_type', '$layout', '$dynamic_link', '$static_link', $is_dirpage, $is_global)";
    
    //echo "<b>$sql</b>";
    dbr_query($sql);
    
    $sql = "select LAST_INSERT_ID() from s_page";
    $stmt = dbr_query($sql);
    $row=dbr_fetch_row($stmt);
    $page_id = $row[0];
    
    return($page_id);
}

#############
## update_s_page_dynamic_link
#############
function update_s_page_dynamic_link($page_id, $dynamic_link)
{
    $sql = "update s_page set dynamic_link='$dynamic_link' where page_id=$page_id";
    dbr_query($sql);
}


#############
## link_list_insert
#############
function link_list_insert ($page_id, $dir_id)
{
    if(!isset($page_id) || !isset($dir_id))
    {
        echo "bad link_list_insert input: $link_id, $page_id<br>";
        return;
    }
    dbr_query("insert into s_link_list (link_list_id, page_id, dir_id) values(null, $page_id, $dir_id)");
}

#############
## image_list_insert
#############
function image_list_insert ($image_id, $page_id)
{
    dbr_query("insert into s_image_list (image_list_id, image_id, page_id) values(null, $image_id, $page_id)");
}


#############
## textfile_insert
#############
function get_textfile_id($srcfile)
{
        $sql = "select textfile_id from s_textfile where srcfile='$srcfile'";    
        $stmt=dbr_query($sql);
    $row = dbr_fetch_row($stmt);
    $id = $row[0];
        return($id);
}
function textfile_insert ($srcfile)
{
        $id=get_textfile_id($srcfile);
        if(!isset($id))
        {
       $sql="insert into s_textfile(textfile_id, srcfile) values(null, '$srcfile')";
       dbr_query($sql);
       
       $stmt = dbr_query("select LAST_INSERT_ID() from s_textfile");
       $row = dbr_fetch_row($stmt);
       $id = $row[0];
       
       if(isset($stmt))
       dbr_free_result($stmt);
        }
    return ($id);
}

#############
## furl_insert
#############
function furl_insert ($url, $page_id)
{
    $sql="insert into s_furl(furl_id, url, page_id) values(null, '$url', $page_id)";
    dbr_query($sql);
    
    $stmt = dbr_query("select LAST_INSERT_ID() from s_furl");
    $row = dbr_fetch_row($stmt);
    $id = $row[0];
    if(isset($stmt))
    dbr_free_result($stmt);
    return ($id);
}

#############
## iframe_insert
#############
function iframe_insert ($url, $page_id)
{
    
    $sql="insert into s_iframe(iframe_id, url, page_id) values(null, '$url', $page_id)";
    dbr_query($sql);
    
    $stmt = dbr_query("select LAST_INSERT_ID() from s_iframe");
    $row = dbr_fetch_row($stmt);
    $id = $row[0];
    if(isset($stmt))
    dbr_free_result($stmt);
    return ($id);
}

#############
## htmlfile_insert
#############
function get_htmlfile_id($file, $srcpath)
{
        $sql = "select htmlfile_id from s_htmlfile where file='$file' and srcpath='$srcpath'";    
        $stmt=dbr_query($sql);
    $row = dbr_fetch_row($stmt);
    $id = $row[0];
        return($id);
}
function htmlfile_insert ($file, $srcpath)
{
        $id=get_htmlfile_id($file, $srcpath);
        if(!isset($id))
        {
    $sql = "insert into s_htmlfile(htmlfile_id, file, srcpath) values(null, '$file', '$srcpath')";
    dbr_query($sql);
    
    $stmt = dbr_query("select LAST_INSERT_ID() from s_htmlfile");
    $row = dbr_fetch_row($stmt);
    $id = $row[0];
    if(isset($stmt))
    dbr_free_result($stmt);
        }    
    return ($id);
}


#############
## htmlfile_list_insert
#############
function htmlfile_list_insert ($htmlfile_id, $page_id)
{
    dbr_query("insert into s_htmlfile_list (htmlfile_list_id, htmlfile_id, page_id) values(null, $htmlfile_id, $page_id)");
}

#############
## htmlfragment_insert
#############
function get_htmlfragment_id($srcpath)
{
        $sql = "select htmlfragment_id from s_htmlfragment where srcpath='$srcpath'";    
        $stmt=dbr_query($sql);
    $row = dbr_fetch_row($stmt);
    $id = $row[0];
        return($id);
}
function htmlfragment_insert ($srcfile)
{
        $id=get_htmlfragment_id($srcfile);
        if(!isset($id))
        {
    $sql = "insert into s_htmlfragment(htmlfragment_id, srcfile) values(null, '$srcfile')";
    dbr_query($sql);
    
    $stmt = dbr_query("select LAST_INSERT_ID() from s_htmlfragment");
    $row = dbr_fetch_row($stmt);
    $id = $row[0];
    if(isset($stmt))
    dbr_free_result($stmt);
        }    
    return ($id);
}


#############
## htmlfragment_list_insert
#############
function htmlfragment_list_insert ($htmlfragment_id, $page_id)
{
    dbr_query("insert into s_htmlfragment_list (htmlfragment_list_id, htmlfragment_id, page_id) values(null, $htmlfragment_id, $page_id)");
}

#############
## textfile_list_insert
#############
function textfile_list_insert ($textfile_id, $page_id)
{
    dbr_query("insert into s_textfile_list (textfile_list_id, textfile_id, page_id) values(null, $textfile_id, $page_id)");
}

#############
## image_insert
#############
function get_image_id($filename, $htmlpath)
{
        $sql = "select image_id from s_image where filename='$filename' and htmlpath='$htmlpath'";    
        $stmt=dbr_query($sql);
    $row = dbr_fetch_row($stmt);
    $id = $row[0];
        return($id);
}
function image_insert ($filename, $htmlpath, $image_title, $mime_type, $caption_file)
{
        $id=get_image_id($filename, $htmlpath);

        if(!isset($id))
        {
    $sql = "insert into s_image (image_id, filename, htmlpath, image_title, mime_type, caption_file)
values(null, '$filename', '$htmlpath', '$image_title', '$mime_type','$caption_file')";
    
    $rslt = dbr_query($sql);
    
    $stmt = dbr_query("select LAST_INSERT_ID() from s_image");
    $row = dbr_fetch_row($stmt);
    $id = $row[0];
    if(isset($stmt))
    dbr_free_result($stmt);
    
    //echo "image_insert returns $image_id <br>";
        }
    return ($id);
}

#############
## image_caption_insert
## image caption is text too big for image's 255 byte notes field?
#############
function image_caption_insert ($image_id, $page_id, $srcpath)
{
    //if(isset($image_id) && isset($page_id) && isset($file) && isset($srcpath))
    //{
    $insert = "insert into s_caption(caption_id, image_id, page_id, srcpath) values(null,$image_id, $page_id, '$srcpath')";
    
    dbr_query($insert);
    //}
}
?>
Copyright (c) Icontem 1999-2008	PHP Classes	- PHP Class Scripts
	PHP Book Reviews	- Reviews of books and other products
Contents:
