update_1.10-1.20.php

来自「phpBook 是個建立於 PHP 及 MySQL 的留言板。 功能包括:」· PHP 代码 · 共 25 行

<?
#######################################################################################
#                                                                                     #
# File to upgrade phpBook from 1.10 to 1.20                                           #
#   Enter SQL Info to your Datebase below..                                           #
# DELETE THIS FILE AFTER UPDATING                                                     #
$host       = "localhost";                                                            #
$database   = "phpBook";                                                              #
$username   = "mysql_username";                                                       #
$password   = "mysql_password";                                                       #
#                                                                                     #
#######################################################################################


mysql_connect($host, $username, $password) or die ("Database connect Error");
    @mysql_select_db($database) or die ("Database select Error");

$result = mysql_query("ALTER TABLE guestbook ADD comment MEDIUMTEXT NOT NULL");
if (!$result) {
    echo "Alteration of guestbook table failed!<br>" .mysql_errno(). ": ".mysql_error(). "<br>";
    return;
}

echo "phpBook Tables Updated, Ok...";
?>