[RESOLVED] need to no how to wright a install.php

[tommyc21]

need to no how to wright a install.php
so people can install my new social networking script when im finished

with input feilds like

prefix
admin username
admin password
admin e-mail
web adress
site name
host name
sql user name
sql password

and then installs the
data bases with the prfix_tablename
and changes
admin e-mail
web adress
site name
host name
sql user name
sql password

i no it can be done but how

becouse i esecialy need the perfix becouse im adding my own version off open social apps and dont want app makers to be able to get all user info and that cos i have writen every thing in basic php

[scrupul0us]

well basically you are looking at a few things:

1) you'll need a form to ask the pertinent questions (db location and creds, etc, etc)

2) you'll need to export a script from mysql that will create the tables and any preloaded data required by your application

3) some basic but good error checking to verify that the environment is setup properly (writable files/folders, appropriate DB creds, etc)

then tie it all together

gather data -> verify its correct -> verify environment is setup -> run install

[Randy_Jackson]

There are a number of open source projects out there that have installers like you are describing. It might be a good idea to look at those and see how they work.

[tommyc21]

ok here is my problem

header("Location: install.php")
<?
$u = strip_tags ($_POST['user']);
$p = strip_tags ($_POST['pass']);
$h = strip_tags ($_POST['host']);
$pf = strip_tags ($_POST['prefix']);
$sp = strip_tags ($_POST['url']);
$sm = strip_tags ($_POST['email']);
$dbn = strip_tags ($_POST['name']);
$myfile ="../config/config.php";
$fh = fopen($myfile, 'w') or die("file wont open");
$stringData = "<?PHP
$hostname = $h;
$user = $u;
$pass = $p;
$dbname = $dbn;
$prefix = $ph;
$sitepath = '$sp';
$sitemail = '$sm';
parse_str("$QUERY_STRING");

$db = mysql_connect(
              "$hostname",
              "$user",
              "$pass")
 or die("Could not connect.");
if(!$db)
	die("no db");
if(!mysql_select_db("$dbname",$db))
 	die("No database selected.");
if(!get_magic_quotes_gpc())
{
  $_GET = array_map('mysql_real_escape_string', $_GET);
  $_POST = array_map('mysql_real_escape_string', $_POST);
  $_COOKIE = array_map('mysql_real_escape_string', $_COOKIE);
}
else
{
   $_GET = array_map('stripslashes', $_GET);
   $_POST = array_map('stripslashes', $_POST);
   $_COOKIE = array_map('stripslashes', $_COOKIE);
   $_GET = array_map('mysql_real_escape_string', $_GET);
   $_POST = array_map('mysql_real_escape_string', $_POST);
   $_COOKIE = array_map('mysql_real_escape_string', $_COOKIE);
}

?>
";
fwrite($fh, $stringData);
fclose($fh)
?>

the probilem is it wont insert the script all veribles dont show and and i cant and comes up with error on line 21

it works if i remove the php code and put hello it will create the file and wright that any 1 no how i can get it to insert the php code in sted of text?

[dagon]

remove quotes on function arguments parse_str(),mysql_connect() theres also an extra php close ?>

[dagon]

my bad, i see what your doing, your syntax is of a little you want something like:

$stringData = '<?php 
$hostname = "'. $h. '";
?>'; 

you can fill in the rest :-)

[tommyc21]

done it and its working

<?php
header("Location: install.php")
?>
<?
include ('../userpic.php');
$u = strip_tags ($_POST['user']);
$p = strip_tags ($_POST['pass']);
$h = strip_tags ($_POST['host']);
$pf = strip_tags ($_POST['prefix']);
$sp = strip_tags ($_POST['url']);
$sm = strip_tags ($_POST['email']);
$dbn = strip_tags ($_POST['name']);
$myfile ="test.php";
$fh = fopen($myfile, 'w') or die("file wont open");
$stringData = '<?PHP
$hostname = '.$h.';
$user = '.$u.';
$pass = '.$p.';
$dbname = '.$dbn.';
$prefix = '.$ph.';
$sitepath = '.$sp.';
$sitemail = '.$sm.';
parse_str("$QUERY_STRING");

$db = mysql_connect(
              "$hostname",
              "$user",
              "$pass")
 or die("Could not connect.");
if(!$db)
	die("no db");
if(!mysql_select_db("$dbname",$db))
 	die("No database selected.");
include ("constrings.php")

?>';
fwrite($fh, $stringData);
fclose($fh)
?>

I aslo need to take data base strings out and include them in
constrings.php

if(!get_magic_quotes_gpc()) 
{ 
  $_GET = array_map('mysql_real_escape_string', $_GET); 
  $_POST = array_map('mysql_real_escape_string', $_POST); 
  $_COOKIE = array_map('mysql_real_escape_string', $_COOKIE); 
} 
else 
{ 
   $_GET = array_map('stripslashes', $_GET); 
   $_POST = array_map('stripslashes', $_POST); 
   $_COOKIE = array_map('stripslashes', $_COOKIE); 
   $_GET = array_map('mysql_real_escape_string', $_GET); 
   $_POST = array_map('mysql_real_escape_string', $_POST); 
   $_COOKIE = array_map('mysql_real_escape_string', $_COOKIE); 
}

🙂 thank you all for your help i fort id post wroking code incase any 1 needs it or wants to no hao its done 🙂