CMS Made Simple Forums

Code: Select all

<?php

/* Проверка простого создания таблицы в MySQL-базе */

ini_set('display_errors', 1);
ini_set('error_reporting', E_ALL);
header('Content-type: text/plain');

$host = 'localhost';
$port = 3306;
$username = 'FILL';
$password = 'FILL';
$db_name = 'FILL';
$table_name = 'test_table';

// connect
$db_link = @mysql_connect("$host:$port", $username, $password) or die('Try db-connection error: ' . mysql_error());
echo "db connestion - success\n";

// select db
@mysql_select_db($db_name, $db_link) or die('Select db error: ' . mysql_error());
echo "Select db - success\n";

// find table
$query = "SHOW TABLES FROM $db_name LIKE '$table_name';";
$ret = @mysql_query($query) or die('SHOW TABLES error: ' . mysql_error());
echo "SHOW TABLES - success\n";
$tables = mysql_fetch_array($ret);
$table_exists = is_array($tables) && in_array($table_name, $tables, true);

// drop table if exist
if ($table_exists) {
	drop_table();
}

// create table
$field_name = 'test_field';
$query = "CREATE TABLE $table_name (id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY (id), $field_name VARCHAR(100));";
$ret = @mysql_query($query) or die('CREATE TABLE error: ' . mysql_error());
echo "CREATE TABLE - success\n";

// insert row
$test_value = 'bla-bla';
$query = "INSERT INTO $table_name($field_name) VALUES ('$test_value')";
$ret = @mysql_query($query) or die('INSERT VALUES error: ' . mysql_error());
echo "INSERT INTO - success\n";

// drop created table
drop_table();

echo "\nTest successfull!";
mysql_close($db_link);


function drop_table() {
	global $table_name;
	$query = "DROP TABLE $table_name";
	$ret = @mysql_query($query) or die('DROP TABLE error: ' . mysql_error());
	echo "DROP TABLE - success\n";
}

?>