Installation script help

viper · 13th August 2003, 03:37 PM

Hey guys i need some help creating a installation script to install the mysql tables into the database.

What i want it to do is create the tables then take the admin password,username and email address from the form i made and insert the admin username,password and email address into one of the tables and change the user level to admin.

if you need the code i have so far let me know and i'll post it.

Thanks

Viper

metguitarist · 14th August 2003, 06:18 AM

I think Mr. Tech, the greatest php wiz may know

**Mr. Tech** · 14th August 2003, 09:45 AM

Yes I do know:

Quote:

<?php

$db_host = "localhost";
$db_name = "dbname";
$db_user = "dbusername";
$db_pass = "dbpassword";

class DB_Sql {

var $Connect = false;
var $ReValue = false;
var $ReSelect = false;
var $Host;
var $Database;
var $User;
var $Password;
var $Value;
var $numrow = false;

function DB_Sql($host,$user,$pass,$dbname) {
$this->Host = $host;
$this->User = $user;
$this->Password = $pass;
$this->Database = $dbname;
}

function DBconnect() {
if (!$this->Connect) {
$this->Connect = @mysql_connect($this->Host, $this->User, $this->Password);
$this->ReSelect = @mysql_select_db($this->Database, $this->Connect);
}
}

function query($sql) {
$this->free();
$this->DBconnect();

if ($this->ReValue = mysql_query($sql, $this->Connect)) {
$this->numrow = @mysql_num_rows($this->ReValue);
}
}

function nrecord() {
$this->Value = mysql_fetch_array($this->ReValue);
return $this->Value;
}

function datadump ($table) {

$result .= "# Dump of $table table \n";
$result .= "# Created by Customized Scripts \n";
$result .= "# Dump DATE : " . date("Y-m-d") ."\n\n";

$this->query("select * from $table");
$num_fields = @mysql_num_fields($this->ReValue);
$numrow = $this->numrow;

for ($i =0; $i<$numrow; $i++) {
//if (!mysql_data_seek ($this->ReValue, $i)) continue;
if (!($row = $this->nrecord())) continue;
$result .= "INSERT INTO ".$table." VALUES(";
for($j=0; $j<$num_fields; $j++) {
$row[$j] = addslashes($row[$j]);
$row[$j] = ereg_replace("\n","\\n",$row[$j]);
if (isset($row[$j])) $result .= "\"$row[$j]\"" ; else $result .= "\"\"";
if ($j<($num_fields-1)) $result .= ",";
}
$result .= ");\n";
}
return $result . "\n\n\n";
}

function free() {
if ($this->ReValue) {
@mysql_free_result($this->ReValue);
$this->ReValue = false;
$this->numrow = false;
}
}

}

$db = new DB_Sql($db_host2,$db_user2,$db_pass2,$db_name2);
$db->DBconnect();
if (!$db->Connect) $errcode .= "<li>Cannot connect to the database!</li>\n";
if (!$db->ReSelect) $errcode .= "<li>Incorrct or non existing database name!</li>\n";

$dump = @file("install.sql");
$count = count($dump);

for ($i=0 ;$i<$count ;$i++) {

if (!trim($dump[$i])) continue;
if (ereg("^#",$dump[$i])) continue;
$content .= str_replace(";","",$dump[$i]);

if (ereg(";$",trim($dump[$i]))) {
$db->query($content);
$content = "";
}
}
?>

Replace install.sql with the .sql file you have the tables in.

Hope that helps

viper · 14th August 2003, 11:11 AM

thanks mr.tech i'll give that a try.

viper · 17th August 2003, 09:14 AM

sorry for the double post mr.tech but i'd thought i'd keep this in the same thread instead of making a new one for it. I got my installation script working good but now i want to check the two password fields to make sure the passwords match but i don't know how to. I know how to post them in the php file but i don't know how to set up th if statement to check both password fileds to make surethey match.

Any help would be appreciated

Thanks again.

**Mr. Tech** · 18th August 2003, 10:44 AM

Quote:

Originally Posted by viper

sorry for the double post mr.tech but i'd thought i'd keep this in the same thread instead of making a new one for it. I got my installation script working good but now i want to check the two password fields to make sure the passwords match but i don't know how to. I know how to post them in the php file but i don't know how to set up th if statement to check both password fileds to make surethey match.

Any help would be appreciated

Thanks again.

This should do it:

Code:

&lt;?php
if ($check) {
// If Passwords Match
if ($password1 == $password2) {
print "Passwords Match!!!";
// If Passwords Dont Match
} else {
print "Passwords Dont Match!!!";
}
// Fill Out Form
} else {
?>
&lt;form action="check.php" method="post">
&lt;input type="hidden" name="check" value="true">
Password1: &lt;input type="text" name="password1">&lt;br>
Password2: &lt;input type="text" name="password2">&lt;br>
&lt;input type="submit" value="Check!">
&lt;/form>
&lt;?php
}
?>