📄 install_2.php
字号:
<?php
/*
$Id: install_2.php,v 1.1.1.1 2004/10/09 14:29:27 cvsadmin Exp $
osCommerce, Open Source E-Commerce Solutions
http://www.oscommerce.com
Copyright (c) 2003 osCommerce
Released under the GNU General Public License
*/
?>
<p class="pageTitle">New Installation</p>
<p><b>Database Import</b></p>
<?php
if (isset($HTTP_POST_VARS['DB_SERVER']) && !empty($HTTP_POST_VARS['DB_SERVER']) && isset($HTTP_POST_VARS['DB_TEST_CONNECTION']) && ($HTTP_POST_VARS['DB_TEST_CONNECTION'] == 'true')) {
$db = array();
$db['DB_SERVER'] = trim(stripslashes($HTTP_POST_VARS['DB_SERVER']));
$db['DB_SERVER_USERNAME'] = trim(stripslashes($HTTP_POST_VARS['DB_SERVER_USERNAME']));
$db['DB_SERVER_PASSWORD'] = trim(stripslashes($HTTP_POST_VARS['DB_SERVER_PASSWORD']));
$db['DB_DATABASE'] = trim(stripslashes($HTTP_POST_VARS['DB_DATABASE']));
$db_error = false;
osc_db_connect($db['DB_SERVER'], $db['DB_SERVER_USERNAME'], $db['DB_SERVER_PASSWORD']);
if ($db_error == false) {
osc_db_test_create_db_permission($db['DB_DATABASE']);
}
if ($db_error != false) {
?>
<form name="install" action="install.php?step=2" method="post">
<table width="95%" border="0" cellpadding="2" class="formPage">
<tr>
<td>
<p>A test connection made to the database was <b>NOT</b> successful.</p>
<p>The error message returned is:</p>
<p class="boxme"><?php echo $db_error; ?></p>
<p>Please click on the <i>Back</i> button below to review your database server settings.</p>
<p>If you require help with your database server settings, please consult your hosting company.</p>
</td>
</tr>
</table>
<?php
reset($HTTP_POST_VARS);
while (list($key, $value) = each($HTTP_POST_VARS)) {
if (($key != 'x') && ($key != 'y') && ($key != 'DB_TEST_CONNECTION')) {
if (is_array($value)) {
for ($i=0; $i<sizeof($value); $i++) {
echo osc_draw_hidden_field($key . '[]', $value[$i]);
}
} else {
echo osc_draw_hidden_field($key, $value);
}
}
}
?>
<p> </p>
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td align="center"><a href="index.php"><img src="images/button_cancel.gif" border="0" alt="Cancel"></a></td>
<td align="center"><input type="image" src="images/button_back.gif" border="0" alt="Back"></td>
</tr>
</table>
</form>
<?php
} else {
$script_filename = getenv('PATH_TRANSLATED');
if (empty($script_filename)) {
$script_filename = getenv('SCRIPT_FILENAME');
}
$script_filename = str_replace('\\', '/', $script_filename);
$script_filename = str_replace('//', '/', $script_filename);
$dir_fs_www_root_array = explode('/', dirname($script_filename));
$dir_fs_www_root = array();
for ($i=0, $n=sizeof($dir_fs_www_root_array)-1; $i<$n; $i++) {
$dir_fs_www_root[] = $dir_fs_www_root_array[$i];
}
$dir_fs_www_root = implode('/', $dir_fs_www_root) . '/';
?>
<form name="install" action="install.php?step=3" method="post">
<table width="95%" border="0" cellpadding="2" class="formPage">
<tr>
<td>
<p>A test connection made to the database was <b>successful</b>.</p>
<p>Please continue the installation process to execute the database import procedure.</p>
<p>It is important this procedure is not interrupted, otherwise the database may end up corrupt.</p>
<p>The file to import must be located and named at:</p>
<p><?php echo $dir_fs_www_root . 'install/oscommerce.sql'; ?></p>
</td>
</tr>
</table>
<?php
reset($HTTP_POST_VARS);
while (list($key, $value) = each($HTTP_POST_VARS)) {
if (($key != 'x') && ($key != 'y') && ($key != 'DB_TEST_CONNECTION')) {
if (is_array($value)) {
for ($i=0; $i<sizeof($value); $i++) {
echo osc_draw_hidden_field($key . '[]', $value[$i]);
}
} else {
echo osc_draw_hidden_field($key, $value);
}
}
}
?>
<p> </p>
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td align="center"><a href="index.php"><img src="images/button_cancel.gif" border="0" alt="Cancel"></a></td>
<td align="center"><input type="image" src="images/button_continue.gif" border="0" alt="Continue"></td>
</tr>
</table>
</form>
<?php
}
} else {
?>
<form name="install" action="install.php?step=2" method="post">
<p><b>Please enter the database server information:</b></p>
<table width="95%" border="0" cellpadding="2" class="formPage">
<tr>
<td width="30%" valign="top">Database Server:</td>
<td width="70%" class="smallDesc">
<?php echo osc_draw_input_field('DB_SERVER'); ?>
<img src="images/layout/help_icon.gif" onClick="toggleBox('dbHost');"><br>
<div id="dbHostSD">Hostame or IP-address of the database server</div>
<div id="dbHost" class="longDescription">The database server can be in the form of a hostname, such as db1.myserver.com, or as an IP-address, such as 192.168.0.1</div>
</td>
</tr>
<tr>
<td width="30%" valign="top">Username:</td>
<td width="70%" class="smallDesc">
<?php echo osc_draw_input_field('DB_SERVER_USERNAME'); ?>
<img src="images/layout/help_icon.gif" onClick="toggleBox('dbUser');"><br>
<div id="dbUserSD">Database username</div>
<div id="dbUser" class="longDescription">The username used to connect to the database server. An example username is 'mysql_10'.<br><br>Note: Create and Drop permissions <b>are required</b> at this point of the installation procedure.</div>
</td>
</tr>
<tr>
<td width="30%" valign="top">Password:</td>
<td width="70%" class="smallDesc">
<?php echo osc_draw_password_field('DB_SERVER_PASSWORD'); ?>
<img src="images/layout/help_icon.gif" onClick="toggleBox('dbPass');"><br>
<div id="dbPassSD">Database password</div>
<div id="dbPass" class="longDescription">The password is used together with the username, which forms the database user account.</div>
</td>
</tr>
<tr>
<td width="30%" valign="top">Database Name:</td>
<td width="70%" class="smallDesc">
<?php echo osc_draw_input_field('DB_DATABASE'); ?>
<img src="images/layout/help_icon.gif" onClick="toggleBox('dbName');"><br>
<div id="dbNameSD">Database Name</div>
<div id="dbName" class="longDescription">The database used to hold the data. An example database name is 'osCommerce'.</div>
</td>
</tr>
<tr>
<td width="30%" valign="top">Persistent Connections:</td>
<td width="70%" class="smallDesc">
<?php echo osc_draw_checkbox_field('USE_PCONNECT', 'true'); ?>
<img src="images/layout/help_icon.gif" onClick="toggleBox('dbConn');"><br>
<div id="dbConnSD"></div>
<div id="dbConn" class="longDescription">Enable persistent database connections.<br><br>Note: Persistent connections should be disabled for shared servers.</div>
</td>
</tr>
<tr>
<td width="30%" valign="top">Session Storage:</td>
<td width="70%" class="smallDesc">
<?php echo osc_draw_radio_field('STORE_SESSIONS', 'files', true); ?> Files <?php echo osc_draw_radio_field('STORE_SESSIONS', 'mysql'); ?> Database
<img src="images/layout/help_icon.gif" onClick="toggleBox('dbSess');"><br>
<div id="dbSessSD"></div>
<div id="dbSess" class="longDescription">Store user session data as files on the server, or in the database.<br><br>Note: Due to security related issues, database session storage is recommended for shared servers.</td></div>
</td>
</tr>
</table>
<p> </p>
<table border="0" width="100%" cellspacing="0" cellpadding="0" align="center">
<tr>
<td align="center"><a href="index.php"><img src="images/button_cancel.gif" border="0" alt="Cancel"></a></td>
<td align="center"><input type="image" src="images/button_continue.gif" border="0" alt="Continue"></td>
</tr>
</table>
<?php
reset($HTTP_POST_VARS);
while (list($key, $value) = each($HTTP_POST_VARS)) {
if (($key != 'x') && ($key != 'y') && ($key != 'DB_SERVER') && ($key != 'DB_SERVER_USERNAME') && ($key != 'DB_SERVER_PASSWORD') && ($key != 'DB_DATABASE') && ($key != 'USE_PCONNECT') && ($key != 'STORE_SESSIONS') && ($key != 'DB_TEST_CONNECTION')) {
if (is_array($value)) {
for ($i=0; $i<sizeof($value); $i++) {
echo osc_draw_hidden_field($key . '[]', $value[$i]);
}
} else {
echo osc_draw_hidden_field($key, $value);
}
}
}
echo osc_draw_hidden_field('DB_TEST_CONNECTION', 'true');
?>
</form>
<?php
}
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -