Parse error: syntax error, unexpected 'db_host'
Oi, eu estou querendo instalar este site já pronto para eu ir alterando de acordo com o que eu estiver estudando até ele ficar completamente diferente, segundo o blog que disponibiliza ele, bastava eu copiar os arquivos para a pasta do servidor e executar o link "localhost/install.php", assim, segundo o blog, iria aparecer um formulário para eu colocar informações como: nome da host, nome do usuário da db, senha e nome da DB, logo após só precisaria clicar em "instalar" e o site seria "instalado", então bastava eu apagar o "install.php" e poderia logar, adicionar/remover conteudos e etc, e claro, fazer minhas modificações com o site já funcionando
Mas o problema é que não consigo, e a única coisa que aparece é uma tela branca escrito "Parse error: syntax error, unexpected 'db_host' (T_STRING), expecting ')' in C:\xampp\htdocs\upload\install.php on line 267"
Arquivo INSTALL.PHP completo:
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>Flat manga - Installation</title>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<!-- Le styles -->
<link href="app/manga/themes/default/assets/css/flat.css" rel="stylesheet">
<style type="text/css">
body {
padding-top: 40px;
padding-bottom: 40px;
background-color: #f5f5f5;
}
.form-signin {
max-width: 450px;
padding: 19px 29px 29px;
margin: 0 auto 20px;
background-color: #fff;
border: 1px solid #e5e5e5;
-webkit-border-radius: 5px;
-moz-border-radius: 5px;
border-radius: 5px;
-webkit-box-shadow: 0 1px 2px rgba(0,0,0,.05);
-moz-box-shadow: 0 1px 2px rgba(0,0,0,.05);
box-shadow: 0 1px 2px rgba(0,0,0,.05);
}
.form-signin .form-signin-heading,
.form-signin .checkbox {
margin-bottom: 10px;
}
.form-signin input[type="text"],
.form-signin input[type="password"] {
font-size: 16px;
height: auto;
margin-bottom: 15px;
padding: 7px 9px;
width: 100%;
}
</style>
<!-- HTML5 shim, for IE6-8 support of HTML5 elements -->
<!--[if lt IE 9]>
<script src="../assets/js/html5shiv.js"></script>
<![endif]-->
</head>
<body>
<div class="container">
<? if($_POST){
$connect = mysql_connect($_POST['db_host'], $_POST['db_user'], $_POST['db_pw']);
if (!$connect) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully<br />';
$db_selected = mysql_select_db($_POST['db_name'], $connect);
if (!$db_selected) {
die ('Can\'t use database '.$_POST['db_name'].' : ' . mysql_error());
}
echo 'Connected to database '.$_POST['db_name'].'<br />';
// RUN DATABASE
mysql_query("CREATE TABLE ".$_POST['db_prefix']."h0_ratings (
`ID` int(11) NOT NULL auto_increment,
`slug` varchar(255) default NULL,
`vote_count` int(16) default NULL,
`total` int(16) default NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;");
mysql_query("CREATE TABLE `".$_POST['db_prefix']."manga_bookmark` (
`user` int(11) NOT NULL,
`manga` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;");
mysql_query("CREATE TABLE `".$_POST['db_prefix']."manga_chapters` (
`id` int(11) NOT NULL auto_increment,
`chapter` varchar(20) NOT NULL,
`name` varchar(150) NOT NULL,
`manga` varchar(100) NOT NULL,
`trans_group` int(11) NOT NULL,
`views` int(11) NOT NULL,
`submitter` int(11) NOT NULL,
`last_update` datetime NOT NULL,
`content` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;");
mysql_query("CREATE TABLE `".$_POST['db_prefix']."manga_chapters_q` (
`id` int(11) NOT NULL auto_increment,
`chapter` varchar(20) NOT NULL,
`name` varchar(150) NOT NULL,
`manga` varchar(100) NOT NULL,
`trans_group` int(11) NOT NULL,
`views` int(11) NOT NULL,
`submitter` int(11) NOT NULL,
`last_update` datetime NOT NULL,
`content` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;");
mysql_query("CREATE TABLE `".$_POST[db_prefix]."manga_count` (
`id` int(1) NOT NULL auto_increment,
`mangas` int(10) NOT NULL,
`chapters` int(10) NOT NULL,
`views` int(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;");
mysql_query("INSERT INTO `".$_POST[db_prefix]."manga_count` VALUES (1, 0, 0, 0);");
mysql_query("CREATE TABLE `".$_POST[db_prefix]."manga_groups` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(250) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;");
mysql_query("INSERT INTO `".$_POST[db_prefix]."manga_groups` VALUES (1, 'Updating');");
mysql_query("CREATE TABLE `".$_POST[db_prefix]."manga_mangas` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(250) NOT NULL,
`slug` varchar(150) NOT NULL,
`authors` varchar(250) NOT NULL,
`artists` varchar(150) NOT NULL,
`released` int(4) NOT NULL,
`other_name` varchar(250) NOT NULL,
`genres` varchar(250) NOT NULL,
`description` text NOT NULL,
`m_status` tinyint(1) NOT NULL,
`views` int(11) NOT NULL default '0',
`cover` varchar(250) NOT NULL,
`submitter` int(11) NOT NULL,
`last_update` datetime NOT NULL,
`last_chapter` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;");
mysql_query("CREATE TABLE `".$_POST[db_prefix]."manga_mangas_q` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(250) NOT NULL,
`slug` varchar(150) NOT NULL,
`authors` varchar(250) NOT NULL,
`artists` varchar(150) NOT NULL,
`released` int(4) NOT NULL,
`other_name` varchar(250) NOT NULL,
`genres` varchar(250) NOT NULL,
`description` text NOT NULL,
`m_status` tinyint(1) NOT NULL,
`views` int(11) NOT NULL default '0',
`cover` varchar(250) NOT NULL,
`submitter` int(11) NOT NULL,
`last_update` datetime NOT NULL,
`last_chapter` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;");
mysql_query("CREATE TABLE `".$_POST[db_prefix]."manga_notification` (
`id` int(11) NOT NULL auto_increment,
`user` int(11) NOT NULL,
`type` varchar(7) NOT NULL,
`url` varchar(250) default NULL,
`message` varchar(250) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
");
mysql_query("CREATE TABLE `".$_POST[db_prefix]."manga_submitter` (
`id` int(11) NOT NULL auto_increment,
`user` int(11) NOT NULL,
`m_count` int(11) NOT NULL,
`c_count` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;");
mysql_query("CREATE TABLE `".$_POST[db_prefix]."manga_views` (
`id` int(11) NOT NULL auto_increment,
`manga` int(11) NOT NULL,
`type` int(1) NOT NULL,
`value` varchar(3) NOT NULL,
`views` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;");
mysql_query("ALTER TABLE ".$_POST[db_prefix]."manga_views ADD year YEAR(4) AFTER views");
mysql_query("UPDATE ".$_POST[db_prefix]."manga_views set year = 2013");
mysql_query("
CREATE TABLE ".$_POST[db_prefix]."manga_grabChapterQ (
`id` int(11) NOT NULL auto_increment,
`manga` varchar(100) NOT NULL,
`url` varchar(200) NOT NULL,
`chapter_name` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;");
mysql_query("CREATE TABLE ".$_POST[db_prefix]."manga_grabQ (
`id` int(11) NOT NULL auto_increment,
`url` varchar(200) NOT NULL,
`site` varchar(10) NOT NULL,
`type` varchar(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;");
mysql_query("
CREATE TABLE ".$_POST[db_prefix]."manga_grabResult (
`id` int(11) NOT NULL auto_increment,
`content` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;");
mysql_query("INSERT INTO `manga_grabResult` VALUES (1, '');");
mysql_query("CREATE TABLE `".$_POST[db_prefix]."user` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(100) NOT NULL,
`email` varchar(320) NOT NULL,
`password` char(40) NOT NULL,
`role` tinyint(1) NOT NULL,
`register_ip` varchar(15) NOT NULL,
`register_date` datetime NOT NULL,
`last_login` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;");
$ad_pw = sha1($_POST['ad_pw']);
mysql_query("INSERT INTO `".$_POST[db_prefix]."user` VALUES (1, 'ADMIN', '$_POST[ad_email]', '$ad_pw', 2, '', NOW(), NOW());");
mysql_query("CREATE TABLE `".$_POST[db_prefix]."user_code` (
`email` varchar(320) NOT NULL,
`code` char(32) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;");
mysql_query("CREATE TABLE `".$_POST[db_prefix]."user_meta` (
`id` int(11) NOT NULL auto_increment,
`user` int(11) NOT NULL,
`avatar` varchar(250) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;");
mysql_query("INSERT INTO `".$_POST[db_prefix]."user_meta` VALUES (1, 1, 'haha.png');");
mysql_query("CREATE TABLE `".$_POST[db_prefix]."user_role` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;");
mysql_query("INSERT INTO `".$_POST[db_prefix]."user_role` VALUES (1, 'Unconfirmed');");
mysql_query("INSERT INTO `".$_POST[db_prefix]."user_role` VALUES (2, 'Administration');");
// RUN DATABASE SUCESSFULL
echo 'Database successfull created <br />';
$content = "<?php
/** MySQL hostname */
define('APP_DB_HOST', '".$_POST['db_host']."');
/** MySQL database username */
define('APP_DB_USER', '".$_POST['db_user']."');
/** MySQL database password */
define('APP_DB_PASSWORD', '".$_POST['db_pw']."');
/** MySQL database name */
define('APP_DB_NAME', '".$_POST['db_name']."');
/** MySQL table prefix */
define('APP_TABLES_PREFIX', '".$_POST['db_prefix']."');
/** Mail sender and config */
define('SMTP', '0'); // 1 for using SMTP, 0 for using mail();
/* IF SMTP = 1, define smtp config */
define('SMTP_HOST', 'smtp.gmail.com');
define('SMTP_PORT', '587');
define('SMTP_Secure', 'tls');
define('SMTP_Auth', 'true');
define('SMTP_Username', '');
define('SMTP_Password', '');
define('email_from', 'your_email@somewhere.com')
?>";
chmod ("includes/config.php", 0777);
$fp = fopen("includes/config.php", "w");
fwrite($fp, $content);
fclose($fp);
echo 'Database config successfull updated <br />';
echo 'Congratulation! Flat manga was installed successful!<br />';
echo 'Please delete file <b>install.php</b><br /><br />';
echo '<a href="index.html">View your site.</a>';
chmod ("includes/config.php", 0644);
?>
<? }else { ?>
<form class="form-signin" method="POST" action="install.php">
<h1>FRESH INSTALL</h1>
<h2 class="form-signin-heading">Insert database information</h2>
<input type="text" class="input-block-level" required placeholder="Database host" name="db_host">
<input type="text" class="input-block-level" required placeholder="Database username" name="db_user">
<input type="password" class="input-block-level" required placeholder="Database user's password" name="db_pw">
<input type="text" class="input-block-level" required placeholder="Database name" name="db_name">
<input type="text" class="input-block-level" placeholder="Database prefix (OPTIONAL)" name="db_prefix">
<h2 class="form-signin-heading">Admin account</h2>
<input type="text" class="input-block-level" required placeholder="ADMIN's email" name="ad_email">
<input type="password" class="input-block-level" required placeholder="ADMIN's password" name="ad_pw">
<button class="btn btn-large btn-primary" type="submit">Begin installing</button>
</form>
<? } ?>
</div> <!-- /container -->
<!-- Le javascript
================================================== -->
<!-- Placed at the end of the document so the pages load faster -->
<script src="assets/js/jquery.min.js"></script>
</body>
</html>
**Linhas a partir da 267, onde é informado o erro: **
$content = "<?php
/** MySQL hostname */
define('APP_DB_HOST', '".$_POST['db_host']."');
/** MySQL database username */
define('APP_DB_USER', '".$_POST['db_user']."');
/** MySQL database password */
define('APP_DB_PASSWORD', '".$_POST['db_pw']."');
/** MySQL database name */
define('APP_DB_NAME', '".$_POST['db_name']."');
/** MySQL table prefix */
define('APP_TABLES_PREFIX', '".$_POST['db_prefix']."');
/** Mail sender and config */
define('SMTP', '0'); // 1 for using SMTP, 0 for using mail();
Como é um site já pronto, acho estranho ter esse problema, mas como ainda estou estudando, não consegui identificar ou achar uma solução até agora
Obrigado pela atençãoDiscussão (2)
Carregando comentários...