Evo ti kad vec neses sa phpmyadminom!
instalacija.php
Code:
<?
$title = "PHP Fajl za instalaciju .SQL";
if(!$file) $dump_file = "nuke.sql"; else $dump_file = $file;
$host_name = "localhost"; // ovde samo podesi host adresu
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE><?=$title?></TITLE>
<BODY leftMargin=0 topMargin=0 MARGINWIDTH="0" MARGINHEIGHT="0">
<? if($submit and $db){
//---------------------------------
$error = "";
$dbconn = mysql_connect($host, $user, $pass) or $error="Can not connect to database server";
if(!$error){
if($create)
mysql_query("create database $db") or $error="Can not create database <font color=red>$db</font>";
if(!$error)
mysql_select_db($db) or $error="Can not select database";
if(!$error){
$dump = addslashes(fread(fopen($dump_file, "r"), filesize($dump_file)));
if(!$dump) $error="Can not read dumping file";
else{
$queries = split_sql($dump,$drop);
for($i=0;$i<count($queries);$i++){
$query = stripslashes(trim($queries[$i]));
if(!empty($query) && $query!="#")
mysql_db_query ($db, $query) or $error="Data dumping failed";
if($error) break;
}
}
}
}
if($error)
echo "<span class=textblack>$error</span>";
else
echo "<span class=textblack><b>Baza instalirana</b></span>";
mysql_close($dbconn);
//---------------------------------
}else{?>
<form action="<?=$SCRIPT_NAME?>" method=post>
<input type=hidden name=file value="<?=$dump_file?>">
<TABLE width="371" border=0 cellPadding=0 cellSpacing=0>
<TBODY>
<TR>
<TD vAlign=top align=left width=517>
<TABLE cellSpacing=0 cellPadding=8 width=84% border=0>
<TBODY>
<TR>
<TD class=textblack rowSpan=2 valign=top><br>
<br>
<p> Ime baze<br>
<input size=15 class=textfield name=db value="<?=$db?>"><br>
<br>
</TD>
<TD class=textblack valign=top> Host Adresa<br>
<input size=20 class=textfield name=host value="<?=$host_name?>"><br>
Korisnk<br>
<input size=20 class=textfield name=user><br>
sifra<br>
<input size=20 class=textfield type=password name=pass><br>
</TD>
</TR>
<TR>
<TD class=textblack valign=top>
<input class=formbutton type=submit name=submit value=" start ">
</TD>
</TR>
</TBODY>
</TABLE>
</TD>
</TR>
</TBODY>
</TABLE>
</form>
<?
}
//---------------------------------
function split_sql($sql,$drop=false)
{
$sql = trim($sql);
$sql = ereg_replace("#[^\n]*\n", "", $sql);
if(!$drop){
$sql = ereg_replace("drop table[^\n]*\n", "", $sql);
$sql = ereg_replace("DROP TABLE[^\n]*\n", "", $sql);
}
$buffer = array();
$ret = array();
$in_string = false;
for($i=0; $i<strlen($sql)-1; $i++)
{
if($sql[$i] == ";" && !$in_string)
{
$ret[] = substr($sql, 0, $i);
$sql = substr($sql, $i + 1);
$i = 0;
}
if($in_string && ($sql[$i] == $in_string) && $buffer[0] != "\\")
{
$in_string = false;
}
elseif(!$in_string && ($sql[$i] == "\"" || $sql[$i] == "'") && (!isset($buffer[0]) || $buffer[0] != "\\"))
{
$in_string = $sql[$i];
}
if(isset($buffer[1]))
{
$buffer[0] = $buffer[1];
}
$buffer[1] = $sql[$i];
}
if(!empty($sql))
{
$ret[] = $sql;
}
return($ret);
}
?>
</BODY>
</HTML>
Znaci samo kopiraj ovaj kod i napravi fajl instalacija.php i stavi u direktorijum instal isto u taj direktorijum stavi u nuke.sql
Videces gore gde mozes da namestis svoj host obavezno unesi tu svoju adresu
$host_name = "localhost"; // ovde samo podesi host adresu
Kasnije samo pokrenes Fajl
www.tvoj_sajt.com/instal/instalacija.php
I popunis formular tj uneses ime baze podataka korisnicko ime i sifru!
I ako ti ispise poruku Baza instalirana Znaci da je uspesno odradjen posao!
Scripta 100 % radi jer sam je ja za nesto koristio dok sam ucio programiranje i php jezik!
Pozzzzzzzzzzzzz
[Ovu poruku je menjao sale83 dana 29.06.2005. u 14:12 GMT+1]
Sto mozes danas ne ostavljaj za sutra!