flo3376,
il y a 13 ans
j'ai trouvé, la vache avec la couleur de votre interface ça m'a sauté à la vue de suite.
bonjour a tous, je suis en train de faire un petit fichier php pour écrire dans ma base de donnée des données préétablie.
Cela avance pas mal vue la simplicité de la chose, mais un bug me résiste.
<?php
$post_id ='';
$topic_id ='411';
$forum_id ='5';
$poster_id ='148';
$icon_id ='0';
$poster_ip = '0x39302e31372e3234332e3833';
$post_time = '';
$post_approved ='1';
$post_reported ='0';
$enable_bbcode ='1';
$enable_smilies ='1';
$enable_magic_url ='1';
$enable_sig ='1';
$post_username ='';
$post_subject = 'RADAC';
$post_text ='0x4a65206d65207072c3a973656e74652070617320706c75732071756520c3a76120636172206365727461696e206427656e74726520766f7573206f6e742064c3a96a6120657520c3a020666169726520c3a0206d6f692c0a0a6a6520737569732052414441432028726f626f742064652052c3a9706f6e7365204175746f6d61746973c3a92061752044656d616e6465206427416d697320657420646520436f6e766572736174696f6e292e0a0a5b696d673a67356464616639745d68747470262335383b2f2f777777262334363b6a6575782d737472617465676965262334363b636f6d2f66696c6561646d696e2f61727469636c65732f75706c6f61642f6a732f746125323068656c69636f262334363b6a70675b2f696d673a67356464616639745d0a0a20537569746520c3a0206d612070726f636861696e6520696e74c3a967726174696f6e2064616e73206c6520666f72756d2c206f6e206d2761206372c3a9657220756e20636f6d707465206166696e20717565206a652070756973736520766f75732074656e697220617520636f7572616e7420656e2074656d70732072c3a9656c6c6520646520746f75732063652071756920736520706173736520737572206c612073657373696f6e20617520706f696e742064652076756520666f6e6374696f6e6e656d656e7420676c6f62616c2e0a0a4d6f6e20696e746572636f6e6e6578696f6e2065737420656e20636f757273206427c3a9747564652e200a5b696d673a67356464616639745d68747470262335383b2f2f777777262334363b676c6f62616c737769746368262334363b636f6d2f6d656469612f36353334392f66696272652d6f707469637332262334363b6a70675b2f696d673a67356464616639745d0a4a6520766f7573207469656e6472616920756e20636f7572616e74206465206d6f6e2064c3a976656c6f7070656d656e742e';
$post_checksum ='0x6437633566623466653434303838636432653238353033663064666131396462';
$post_attachment ='0';
$bbcode_bitfield ='';
$bbcode_uid='';
$post_postcount ='1';
$post_edit_time ='0';
$post_edit_reason ='';
$post_edit_user ='0';
$post_edit_count ='0';
$post_edit_locked ='0';
$host = '***';
$user = '***';
$pass = '***';
$db = '***';
// connection à la DB
mysql_connect ($host,$user,$pass) or die ('Erreur : '.mysql_error() );
mysql_select_db($db) or die ('Erreur :'.mysql_error());
$sql= "INSERT INTO phpbb_posts2(post_id,topic_id,forum_id,poster_id,icon_id,poster_ip,post_time,post_approved,post_reported,enable_bbcode,enable_smilies,enable_magic_url,enable_sig,post_username,post_subject,post_text,post_checksum,post_attachment,bbcode_bitfield,bbcode_uid,post_postcount,post_edit_time,post_edit_reason,post_edit_user,post_edit_count,post_edit_locked) VALUES('$post_id','$topic_id','$forum_id','$poster_id','$icon_id','$poster_ip','$post_time','$post_approved','$post_reported','$enable_bbcode','$enable_smilies','$enable_magic_url','$enable_sig,'$post_username','$post_subject','$post_text','$post_checksum','$post_attachment','$bbcode_bitfield','$bbcode_uid','$post_postcount','$post_edit_time','$post_edit_reason','$post_edit_user','$post_edit_count','$post_edit_locked')";
mysql_query($sql) or die ('Erreur SQL ! <br>'.$sql.'<br>'.mysql_error());
?>
et celà me retourne une page d'erreur
Erreur SQL !
INSERT INTO phpbb_posts2(post_id,topic_id,forum_id,poster_id,icon_id,poster_ip,post_time,post_approved,post_reported,enable_bbcode,enable_smilies,enable_magic_url,enable_sig,post_username,post_subject,post_text,post_checksum,post_attachment,bbcode_bitfield,bbcode_uid,post_postcount,post_edit_time,post_edit_reason,post_edit_user,post_edit_count,post_edit_locked) VALUES('','411','5','148','0','0x39302e31372e3234332e3833','','1','0','1','1','1','1,'','RADAC','0x4a65206d65207072c3a973656e74652070617320706c75732071756520c3a76120636172206365727461696e206427656e74726520766f7573206f6e742064c3a96a6120657520c3a020666169726520c3a0206d6f692c0a0a6a6520737569732052414441432028726f626f742064652052c3a9706f6e7365204175746f6d61746973c3a92061752044656d616e6465206427416d697320657420646520436f6e766572736174696f6e292e0a0a5b696d673a67356464616639745d68747470262335383b2f2f777777262334363b6a6575782d737472617465676965262334363b636f6d2f66696c6561646d696e2f61727469636c65732f75706c6f61642f6a732f746125323068656c69636f262334363b6a70675b2f696d673a67356464616639745d0a0a20537569746520c3a0206d612070726f636861696e6520696e74c3a967726174696f6e2064616e73206c6520666f72756d2c206f6e206d2761206372c3a9657220756e20636f6d707465206166696e20717565206a652070756973736520766f75732074656e697220617520636f7572616e7420656e2074656d70732072c3a9656c6c6520646520746f75732063652071756920736520706173736520737572206c612073657373696f6e20617520706f696e742064652076756520666f6e6374696f6e6e656d656e7420676c6f62616c2e0a0a4d6f6e20696e746572636f6e6e6578696f6e2065737420656e20636f757273206427c3a9747564652e200a5b696d673a67356464616639745d68747470262335383b2f2f777777262334363b676c6f62616c737769746368262334363b636f6d2f6d656469612f36353334392f66696272652d6f707469637332262334363b6a70675b2f696d673a67356464616639745d0a4a6520766f7573207469656e6472616920756e20636f7572616e74206465206d6f6e2064c3a976656c6f7070656d656e742e','0x6437633566623466653434303838636432653238353033663064666131396462','0','','','1','0','','0','0','0')
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 'RADAC','0x4a65206d65207072c3a973656e74652070617320706c75732071756520c3a761206361' at line 1
et je ne trouve pas, encore un coup stupide je le sens. Si quelqu'un pouveait jeter un oeil. merci d'avance
Flo
j'ai trouvé, la vache avec la couleur de votre interface ça m'a sauté à la vue de suite.