If it helps, after posting this question, I did some searching, and I found an
installation script which creates a database and creates the tables using pure
sql statements in a php file. Here's the coding...
PHP Code:
<?php
$dbhost = '*****';
$dbuser = '*****';
$dbpass = '*****';
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to
mysql');
$dbname = '*****';
mysql_select_db($dbname);
// function create_tables() {
$filename = "core_sql.php";
$fd = fopen ($filename, "r");
$sql_data = fread($fd, filesize($filename));
fclose ($fd);
preg_match_all("/create(.*?)myisam;/si", $sql_data, $result );
foreach ($result[0] as $sql_table) {
preg_match("/CREATE TABLE\s(.*?)\s\(/si", $sql_table, $match);
$tablename = $match[1];
preg_match_all("/create(.*?)myisam;/si", $sql_data, $result );
$sql_table = preg_replace("/create table\s/si", "CREATE TABLE test_",
$sql_table);
}
?>
The file core_sql.php is a php file which opens and closes the PHP tags, and
then underneath is just sql statements you would use on a MySQL command line.
So this has to be possible. But the coding I have posted, I don't understand
it. And it doesn't work for me. Perhaps someone can see something there that is
not right. It was mostly built up of variables contained in the installation
script but I manadged to "translate" most of it!
Arena Servers - Web Hosting
http://www.arenasmithster.co.uk
