1) Quand je rentre des donner arbitraire, voila l'erreur:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'0\', \'0\', \'1\', \'azerty\', \'ytreza\', \'azerty\', \'ytrez\', \'azerty\', ' at line 1
ou le 1 correspond à $visible
2) Je veux bien ne pas mettre de quote mais c'est bien autour des deux 0 au tous debut n'est ce pas?
car alors, voila l'erreur qui aparait
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'1\', \'azerty\', \'ytreza\', \'azerty\', \'ytrez\', \'azerty\', \'ytreza\', \'' at line 1
pour le sql:
$sql = "INSERT INTO `a6201429_anim`.`livre` (`id`, `vue`, `rang`, `visible`, `nom`, `prenom`, `rue`, `code`, `ville`, `tel`, `mail`, `ip`, `mes`, `avis`, `mes_or`, `date`, `acc_ch`, `acc_val`, `ani_ch`, `ani_val`, `cdt_ch`, `cdt_val`) VALUES (NULL, 0, 0, \'".$visible."\', \'".$nom."\', \'".$prenom."\', \'".$rue."\', \'".$codepostal."\', \'".$ville."\', \'".$telephone."\', \'".$mail."\', \'".$iptext."\', \'".$message."\', \'\', \'\', \'".$date_msg."\', \'".$acc_ch."\', \'".$acc_val."\', \'".$ani_ch."\', \'".$ani_val."\', \'".$cdt_ch."\', \'".$cdt_val."\');";
3) Quand je retire tous les \':
$sql = "INSERT INTO `a6201429_anim`.`livre` (`id`, `vue`, `rang`, `visible`, `nom`, `prenom`, `rue`, `code`, `ville`, `tel`, `mail`, `ip`, `mes`, `avis`, `mes_or`, `date`, `acc_ch`, `acc_val`, `ani_ch`, `ani_val`, `cdt_ch`, `cdt_val`) VALUES (NULL, 0, 0, ".$visible.", ".$nom.", ".$prenom.", ".$rue.", ".$codepostal.", ".$ville.", ".$telephone.", ".$mail.", ".$iptext.", ".$message.", , , ".$date_msg.", ".$acc_ch.", ".$acc_val.", ".$ani_ch.", ".$ani_val.", ".$cdt_ch.", ".$cdt_val.");";
cela me donne comme erreur :
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@ytreza.azerty, Message retranscrits depuis le Livre d'or manuscrit du magasin, ' at line 1
ce qui correspond a $mail et $iptext
Partager