Usamos cookies para medir audiência e melhorar sua experiência. Você pode aceitar ou recusar a qualquer momento. Veja sobre o iMasters.
poderiam me ajudar, não consigo achar meu erro, não está gravando no banco Código php/html <?php include 'conexao/conexao.php'.?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html. charset=utf-8" />
<title>Documento sem título</title>
</head> <body> <form method="post" action="#"> Cor do fundo do site: <input type="color" name="bodybackground" /><input type="submit" name="Enviar" value="Enviar" />
</form> </body>
</html> <?php if(!empty($_POST)){
$acao = $_POST['Enviar']. $bodybackground = $_POST['bodybackground']. $acolor = $_POST['acolor']. $ahoverfocus = $_POST['ahoverfocus']. $coloramenu = $_POST['coloramenu']. $colorahoverfocusmenu = $_POST['colorahoverfocusmenu']. $coloraactive = $_POST['coloraactive']. $backgroundmenu = $_POST['backgroundmenu']. /*}if((empty($bodybackground))or(empty($acolor))or(empty($ahoverfocus))or(empty($coloramenu))or(empty($colorahoverfocusmenu))or(empty($coloraactive))or(empty($backgroundmenu))){ echo "<SCRIPT LANGUAGE='JavaScript' TYPE='text/javascript'>
alert ('Oops, está faltando alguns dados, favor verifique.'). window.location.replace('mudarcores.php'). </SCRIPT>". }else{ echo "<SCRIPT LANGUAGE='JavaScript' TYPE='text/javascript'>
alert ('Cores alteradas, visualize na página inicial.'). window.location.replace('mudarcores.php'). </SCRIPT>". */ $query = mysql_query("insert into css(bodybackground,acolor,ahoverfocus,coloramenu,colorahoverfocusmenu,corloraactive,backgroundmenu)values('$bodybackground','$acolor','$ahoverfocus','$coloramenu','$colorahoverfocusmenu','$coloraactive','$backgroundmenu')"). }?> Estrutura do banco -- phpMyAdmin SQL DumpSET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO". SET time_zone = "+00:00". /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */. /*!40101 SET NAMES utf8 */. --meusitecssCREATE TABLE IF NOT EXISTS `css` ( `id` int(11) NOT NULL AUTO_INCREMENT, `bodybackground` varchar(255) NOT NULL, `acolor` varchar(255) NOT NULL, `ahoverfocus` varchar(255) NOT NULL, `coloramenu` varchar(255) NOT NULL, `colorahoverfocusmenu` varchar(255) NOT NULL, `coloraactive` varchar(255) NOT NULL, `backgroundmenu` varchar(255) NOT NULL, PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */. Conexão com o banco de dados <?php $hostname_SQL = "localhost". //Ligacao com o MySQL$conn = mysqli_connect($hostname_SQL, $username_SQL, $password_SQL) or trigger_error(mysqli_error(),E_USER_ERROR). mysqli_select_db($conn,$database_SQL). mysqli_query($conn,'SET NAMES "utf8"'). mysqli_query($conn,'SET character_set_connection=utf8'). mysqli_query($conn,'SET character_set_client=utf8'). mysqli_query($conn,'SET character_set_results=utf8').?> Poderiam me ajudar?Carregando comentários...