http://www.fsf.org/ or write
* to the Free Software Foundation, Inc., 59 Temple Place - Suite 330, Boston,
* MA 02111-1307, USA.
*
*/
// Mysql Checking routines
function db_connect ($db_server, $db_user, $db_password) { // Connect to the database
global $error;
$link = @mysql_connect($db_server, $db_user, $db_password);
if ($link === false) { // Problems connecting to mysql
$error = mysql_error();
return false;
} else {
//echo 'Connected successfully
';
return $link;
}
return false;
}
function db_select ($db_handle, $db_name) { // Select database
global $error;
$dbh = @mysql_select_db($db_name, $db_handle);
if ($dbh === false) { // Problems selecting DB
$error = mysql_error();
return false;
} else {
//echo 'DB selected correctly
';
return true;
}
return false;
}
function db_create_sampletable ($db_handle) { // Create sample table
global $error;
// Drop sample table if any
@db_drop_sampletable ($db_handle);
$query = "create table tabletest (id integer not null)";
$result = @mysql_query($query, $db_handle);
if ($result === false) {
$error = mysql_error();
return false;
} else {
return true;
}
return false;
}
function db_insert_sampletable ($db_handle) { // Insert test row
global $error;
// Delete sample rows
@db_delete_sampletable ($db_handle);
$query = "insert into tabletest values (2)";
$result = @mysql_query($query, $db_handle);
if ($result === false) {
$error = mysql_error();
return false;
} else {
return true;
}
return false;
}
function db_drop_sampletable ($db_handle) { // Drop sample table
global $error;
$query = "drop table tabletest";
$result = @mysql_query($query, $db_handle);
if ($result === false) {
$error = mysql_error();
return false;
} else {
return true;
}
return false;
}
function db_delete_sampletable ($db_handle) { // Empty sample table
global $error;
$query = "delete from tabletest";
$result = @mysql_query($query, $db_handle);
if ($result === false) {
$error = mysql_error();
return false;
} else {
return true;
}
return false;
}
function db_execute_query ($db_handle, $query) { // Execute a Mysql Query
global $error;
$result = @mysql_query($query, $db_handle);
if ($result === false) {
$error = mysql_error();
return false;
} else {
return true;
}
return false;
}
function db_create_cmsdam_structure ($db_handle) { // Create cmsdam Structure
global $error;
global $step;
require ("mysql_import_dump.php");
// Import cmsdam DB skeleton
$result = mysql_import_dump("cmsdam_install.ddl.dat");
if ($result === false) {
$error = mysql_error();
return false;
} else {
return true;
}
return false;
}
/*
// Performing SQL query
$query = 'SELECT * FROM my_table';
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
// Printing results in HTML
echo "\n";
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
echo "\t\n";
foreach ($line as $col_value) {
echo "\t\t| $col_value | \n";
}
echo "\t
\n";
}
echo "
\n";
// Free resultset
mysql_free_result($result);
// Closing connection
mysql_close($link);
*/
?>