I've tried many ways, and search and read a lot through stack overflow, but I can't solve this problem. I'm trying to INSERT a form (user's email) into my table of a databank in Mysql. I've other pages and it works, but specifically for this one, it does not work at all.
This is my HTML code with the form:
<div class="col-sm-4">
<form action="//domain.com/subscribe.php" method="post" id="postcontent">
<input type="email" name="email" class="form-control" placeholder="Tape your e-mail..." required />
<button type="submit" class="btn-danger btn-subscribe-danger" >Subscribe!</button>
</form>
</div>
Now this is the subscribe.php, that receives the POST.
<?php
// Inclui o arquivo que faz a conexão ao MySQL
include("http://domain.com/conection.php");
if($_POST) {
//incluindo as variáveis do formulário postado
$email_post = ($_POST['email']);
// Manipulamos as variáveis para evitar problemas com aspas e outros caracteres protegidos do MySQL
$email = mysql_escape_string($email_post);
// Montamos a consulta SQL
$query = "INSERT INTO 'mailinglist' ('id','email') VALUES (NULL, '".$email."')";
// Executa a query
$inserir = mysql_query($query);
if ($inserir) {
// Enter the email where you want to receive notification
$emailTo = 'myname@domain.com';
// DON'T EDIT BELOW CODE
$subscriber_email = ($_POST['email']);
// Send email code
$subject = 'Hi!';
$message = "There's someone you need to contact!\n\nEmail: " . $subscriber_email;
$headers = "From: ".$subscriber_email." <" . $subscriber_email . ">" . "\r\n" . "Reply E-mail: " . $subscriber_email;
if(mail($emailTo, $subject, $message, $headers)){
header('Location: //domain.com/thanks.html');
exit();
}
} else {
echo "Error to send your request, please send an e-mail to: para myemail@domain.com";
// Exibe dados sobre o erro:
echo "Dados sobre o erro:" . mysql_error();
}
And finally, the conection.php
<?php
$n = -1;
/*
$n++;
$MySQL[$n]['dominios'] = array('127.0.0.1', 'localhost'); // PossÃveis dominios
$MySQL[$n]['servidor'] = '127.0.0.1'; // Servidor MySQL
$MySQL[$n]['usuario'] = 'root'; // Usuário MySQL
$MySQL[$n]['senha'] = ''; // Senha MySQL
$MySQL[$n]['banco'] = 'meu_banco'; // Banco de dados
$MySQL[$n]['persis'] = false; // Conexão persistente?
*/
$n++;
$MySQL[$n]['dominios'] = array('hijumbo.com');
$MySQL[$n]['servidor'] = 'localhost'; // Servidor MySQL
$MySQL[$n]['usuario'] = 'user'; // Usuário MySQL
$MySQL[$n]['senha'] = 'password'; // Senha MySQL
$MySQL[$n]['banco'] = 'databank'; // Banco de dados
$MySQL[$n]['persis'] = false; // Conexão persistente?
foreach ($MySQL as $key=>$servidor) {
if (!isset($_SERVER['HTTP_HOST'])) {
$usar = $key;
break;
} else {
$encontrado = false;
foreach ($servidor['dominios'] as $dominio) {
if (strpos($_SERVER['HTTP_HOST'], $dominio) !== false) {
$usar = $key;
$encontrado = true;
break;
}
}
if ($encontrado)
break;
}
}
$MySQL['conexao'] = ($MySQL[$usar]['persis']) ? 'mysql_pconnect' : 'mysql_connect';
$MySQL['link'] = $MySQL['conexao']($MySQL[$usar]['servidor'], $MySQL[$usar]['usuario'], $MySQL[$usar]['senha']) or die("Não foi possÃvel se conectar ao servidor MySQL no endereço [".$MySQL[$usar]['servidor']."]");
mysql_select_db($MySQL[$usar]['banco'], $MySQL['link']) or die("Não foi possÃvel conectar-se ao banco de dados [".$MySQL[$usar]['banco']."] no servidor [".$MySQL[$usar]['servidor']."]");
?>
Does anyone knows why I'm receiving the Access denied for user 'grondon'@'localhost' (using password: NO) ? Thanks