---

db_mysql.php

Go to the documentation of this file.

<?php
// $Header: /cvsroot/modphpcms/modphpcms/modules/db_mysql.php,v 1.6 2004/05/04 22:33:17 fred87 Exp $
function create_entry_table($name) // create a key-value table
//{{{
{
        $link = mysql_connect(
                config_db_host,
                config_db_user,
                config_db_password
                ) or die("Could not connect to database: " . mysql_error());
        
        mysql_select_db(config_db_dbname) or
                die("Could not select database: " . mysql_error());

        $query = 'CREATE TABLE `' . config_db_prefix . $name . '` (' .
                '`key` TINYTEXT NOT NULL ,' .
                '`value` LONGTEXT NOT NULL )';
        
        mysql_query($query);
        mysql_close($link);
}
//}}}
function drop_table($name)
//{{{
{
        $link = mysql_connect(
                config_db_host,
                config_db_user,
                config_db_password
                ) or die("Could not connect to database: " . mysql_error());
        
        mysql_select_db(config_db_dbname) or
                die("Could not select database: " . mysql_error());
        
        $query = 'DROP TABLE `' . config_db_prefix . $name . '`';

        mysql_query($query);
        mysql_close($link);
}
//}}}
function delete_entry($table, $key)
//{{{
{
        $link = mysql_connect(
                config_db_host,
                config_db_user,
                config_db_password
                ) or die("Could not connect to database: " . mysql_error());
        
        mysql_select_db(config_db_dbname) or
                die("Could not select database: " . mysql_error());
        
        $query = 'DELETE FROM `' . config_db_prefix . $table .
                'WHERE `key` = \'' . $key . '\'';
        
        mysql_query($query);
        mysql_close($link);
}
//}}}
function set_entry($table, $key, $value)
//{{{
{
        set_field($table, 'key', $key, 'value', $value);
}
//}}}
function get_entry($table, $key)
//{{{
{
        return get_field($table, 'key', $key, 'value');
}
//}}}
function get_module_list()
//{{{
{
        $link = mysql_connect(
                config_db_host,
                config_db_user,
                config_db_password
                ) or die("Could not connect to database: " . mysql_error());

        mysql_select_db(config_db_dbname) or
                die("Could not select database: " . mysql_error());
        
        $query = 'SELECT `name` FROM `' . config_db_prefix . 'modules`';
        
        $result = mysql_query($query) or die("SELECT failed: " . mysql_error());

        $output = '';
        
        while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
        {
                $output .= $row['name'] . ';';
        }

        $output = substr("$output", 0, -1); // remove the trailing/unwanted ';'

        mysql_free_result($result);
        mysql_close($link);
        
        return $output;
}
//}}}
function get_module_info($name)
//{{{
{
        return get_array('modules', 'name', $name);
}
//}}}
function set_module_info($info)
//{{{
{
        $link = mysql_connect(
                config_db_host,
                config_db_user,
                config_db_password
                ) or die("Could not connect to database: " . mysql_error());
        
        mysql_select_db(config_db_dbname) or
                die("Could not select database: " . mysql_error());
        
        // First see if the module exists
        $query = 'SELECT * FROM `' . config_db_prefix . 'modules` WHERE `name` ' .
                '= \'' . $info['name'] . '\'';
                
        $result = mysql_query($query) or die("SELECT failed: " . mysql_error());
        $num_rows = mysql_num_rows($result);
        mysql_free_result($result);

        if ($num_rows > 0)
        {
                // Already exists
                $query = 'UPDATE `' . config_db_prefix . 'modules` SET ' .
                        '`enabled` = \'' . $info['enabled'] . '\', ' .
                        '`has_admin` = \'' . $info['has_admin'] . '\', ' .
                        '`description` = \'' . $info['description'] . '\', ' .
                        '`title` = \'' . $info['title'] . '\' ' .
                        'WHERE `name` = \'' . $info['name'] . '\'';
                mysql_query($query) or die("UPDATE failed: " . mysql_error());
        }
        else
        {
                // Create the entry
                $query = 'INSERT INTO `' . config_db_prefix . 'modules` '.
                        '(`name`,`title`,`enabled`,`has_admin`,`description`) VALUES(' .
                        "'" . $info['name'] . "'," .
                        "'" . $info['title'] . "'," .
                        "'" . $info['enabled'] . "'," .
                        "'" . $info['has_admin'] . "'," .
                        "'" . $info['description'] .
                        "')";
                mysql_query($query) or die("INSERT failed: " . mysql_error());
        }
        mysql_close($link);
}
//}}}
function delete_module($name)
//{{{
{
        $link = mysql_connect(
                config_db_host,
                config_db_user,
                config_db_password
                ) or die("Could not connect to database: " . mysql_error());

        mysql_select_db(config_db_dbname) or
                die("Could not select database: " . mysql_error());

        $query = 'DELETE FROM `' . config_db_prefix . 'modules` WHERE `name` ' .
                ' = \'' . $name . '\'';
        mysql_query($query);
        mysql_close($link);

        module_installed(); // sorry, misnomer
}
//}}}
function optimize_table($name)
//{{{
{
        $link = mysql_connect(
                config_db_host,
                config_db_user,
                config_db_password
                ) or die("Could not connect to database: " . mysql_error());

        mysql_select_db(config_db_dbname) or
                die("Could not select database: " . mysql_error());

        $name = config_db_prefix . $name;
        $query = "OPTIMIZE TABLE `$name`";
        mysql_query($query);
        mysql_close($link);
}
//}}}
function add_field($table, $field, $type)
//{{{
{
        $link = mysql_connect(
                config_db_host,
                config_db_user,
                config_db_password
                ) or die("Could not connect to database: " . mysql_error());
        
        mysql_select_db(config_db_dbname) or
                die("Could not select database: " . mysql_error());
        
        $table = config_db_prefix . $table;
        $query = "ALTER TABLE `$table` ADD `$field` $type";
        mysql_query($query);
        mysql_close($link);
}
//}}}
function drop_field($table, $field)
//{{{
{
    $link = mysql_connect(
        config_db_host,
        config_db_user,
        config_db_password
        ) or die("Could not connect to database: " . mysql_error());

    mysql_select_db(config_db_dbname) or
        die("Could not select database: " . mysql_error());

    $table = config_db_prefix . $table;
    $query = "ALTER TABLE `$table` DROP `$field`";
    mysql_query($query);
    mysql_close($link);
}

//}}}
function get_array($table, $searchfield, $searchvalue)
//{{{
{
        $link = mysql_connect(
                config_db_host,
                config_db_user,
                config_db_password
                ) or die("Could not connect to database: " . mysql_error());
        
        mysql_select_db(config_db_dbname) or
                die("Could not select database: " . mysql_error());
        
        $table = config_db_prefix . $table;
        $query = "SELECT * FROM `$table` WHERE `$searchfield` = " .
                "'$searchvalue'";
        $result = mysql_query($query) or die("SELECT failed: " . mysql_error());

        $found = mysql_fetch_array($result, MYSQL_ASSOC);

        mysql_free_result($result);
        mysql_close($link);
        return $found;
}               
//}}}
function set_field($table, $searchfield, $searchvalue, $field, $value)
//{{{
{
        $link = mysql_connect(
                config_db_host,
                config_db_user,
                config_db_password
                ) or die("Could not connect to database: " . mysql_error());
        mysql_select_db(config_db_dbname) or
                die("Could not select database: " . mysql_error());

        $table = config_db_prefix . $table;
        
        // First see if the entry exists
        $query = "SELECT `$field` FROM `$table` WHERE `$searchfield` = '$searchvalue'";
        $result = mysql_query($query) or die("SELECT failed: " . mysql_error());
        $numrows = mysql_num_rows($result);
        mysql_free_result($result);

        if ($numrows > 0)
        {
                // Already exists
                $query = "UPDATE `$table` SET `$field` = '$value' WHERE " .
                        "`$searchfield` = '$searchvalue'";
                mysql_query($query) or die("UPDATE failed: " . mysql_error());
        }
        else
        {
                // Create the entry
                $query = "INSERT INTO `$table` " .
                        "(`$searchfield`, `$field`) VALUES " .
                        "('$searchvalue', '$value')";
                mysql_query($query) or die("INSERT failed: " . mysql_error());
        }
        mysql_close($link);
}
//}}}
function get_field($table, $searchfield, $searchvalue, $field)
//{{{
{
        $found = get_array($table, $searchfield, $searchvalue);
        return $found[$field];
}
//}}}
function get_reccount($table)
//{{{
{
        $link = mysql_connect(
                config_db_host,
                config_db_user,
                config_db_password
                ) or die("Could not connect to database: " . mysql_error());
        mysql_select_db(config_db_dbname) or
                die("Could not select database: " . mysql_error());
        
        $table = config_db_prefix . $table;

        $query = "SELECT * FROM `$table`";
        $result = mysql_query($query) or die("SELECT failed: " . mysql_error());
        $numrows = mysql_num_rows($result);
        mysql_free_result($result);
        mysql_close($link);
        return $numrows;
}
//}}}
function get_array2($table, $recnum)
//{{{
{
        $link = mysql_connect(
                config_db_host,
                config_db_user,
                config_db_password
                ) or die("Could not connect to database: " . mysql_error());
        
        mysql_select_db(config_db_dbname) or
                die("Could not select database: " . mysql_error());
        
        $table = config_db_prefix . $table;
        $query = "SELECT * FROM `$table`";
        $result = mysql_query($query) or die("SELECT failed: " . mysql_error());
        
        $i = 0;
        while ($found = mysql_fetch_assoc($result))
        {
                $i++;
                if ($i == $recnum)
                        break;
        }

        mysql_free_result($result);
        mysql_close($link);
        return $found;
}
//}}}
function get_field2($table, $field, $recnum)
//{{{
{
        $found = get_array2($table, $recnum);
        return $found[$field];
}
//}}}
?>

---