I've got a REALLY weird thing! For some reason, when executing this code PHP CRASHES! I'm on Win 98 with PHP 4.0.6 (upgrading soon). It says the error was a 'stack' problem. Mean anything to anyone? :-|
The code is;
Thanks for any help you can offer.
Andy
The code is;
Code:
<?php
// see if they passed an ID number along...
if ($action == "install") { do_install(); } else { show_setup(); }
/* ######################################## */
/* DIVIDER */
/* ######################################## */
function show_setup() {
echo <<<TEMPLATE
<html>
<head>
<meta http-equiv="Content-Language" content="en-gb">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Install</title>
</head>
<body>
<font FACE="Arial" size="2"><b>
<p align="center">Install Script</p>
</b>
<p align="center">This script will set up the tables and some sample data in
your desired MySQL database. Please complete the form below and click on
'Continue'. </p>
<form method="POST">
<p align="center">SQL Host :
<input type="text" size="20" name="sql_host" value="localhost"></p>
<p align="center">SQL Database :
<input type="text" size="20" name="sql_database"></p>
<p align="center">SQL Username :
<input type="text" size="20" name="sql_username"></p>
<p align="center">SQL Password :
<input type="text" size="20" name="sql_password"></p>
<p align="center"><input type="submit" value="Continue" name="B1"></p>
<input type="hidden" name="action" value="install">
</form>
</font>
</body>
</html>
TEMPLATE;
}
/* ######################################## */
/* DIVIDER */
/* ######################################## */
function do_install() {
global $sql_host, $sql_username, $sql_password, $sql_database;
// connect to mySQL and if not pass back an error
$connection = mysql_connect($sql_host, $sql_username, $sql_password); $error = mysql_error();
if (!$connection) { sql_error_report("Unable to connect with your login info for MySQL. Reason: $error", $connection); }
if ($debug) { echo "Host connection established....<BR>"; } //a little something for debugging
// now we need to connect the database
$db = mysql_select_db($sql_database, $connection); $error = mysql_error();
if (!$db) { sql_error_report("Unable to connect to database. Reason: $error", $connection); }
if ($debug) { echo "Database connection established....<BR>"; } // a little debugging info if needed...
// run the query to update the 'sales' column...
$query = <<<QUERY
DROP TABLE IF EXISTS Ace_Mailing;
CREATE TABLE Ace_Mailing (
SetID int(11) NOT NULL auto_increment,
PersonName text NOT NULL,
PersonEmail text NOT NULL,
SendHTML text NOT NULL,
UNIQUE KEY SetID (SetID)
) TYPE=MyISAM;
#
# Dumping data for table `Ace_Mailing`
#
INSERT INTO Ace_Mailing VALUES (1,'Test Person','webmaster@test.com.inc','html');
INSERT INTO Ace_Mailing VALUES (2,'Test Person Again','webmaster@somewhere.com.inc','html');
QUERY;
$result = mysql_query($query); $error = mysql_error();
if (!$result) { error("Unable to execute query to setup database tables! Reason: $error", $connection); }
mysql_close($connection); // exit the connection so we dont clog up MySQL
echo "MySQL Data seems to have been installed successfully. Now edit settings.inc.php (or do it via the admin panel) and set up the MySQL info there. Then you can login at admin.php with admin/1234.";
} // end function for redirect page.
/* ######################################## */
/* DIVIDER */
/* ######################################## */
// hopefully catch those nasty errors!
function error($error) {
$template_read = @file("errortemplate.htm");
if (!$template_read) { error("Unable to read tempalte file. Please double check it is there."); }
foreach ($template_read as $line) {
// do some preg_matches to replace the tags...
$return = ereg_replace("::ERROR::", "$error", $line);
echo $return;
} // end the foreach
exit;
}
/* ######################################## */
/* DIVIDER */
/* ######################################## */
// error sub in case we get problems with SQL queries etc.
function sql_error_report($error, $connection) {
echo $error;
mysql_close($connection); // exit the connection so we dont clog up MySQL
exit; // exit from the script...we can't do anything now...
}
?>Thanks for any help you can offer.
Andy