[Impossible] insertion de multiples ligne
Bonjour,
Pour mon projet j’essaye d’insérer plusieurs ligne sql dans ma base, mais ca ne fonctionne pas (sa fonctionne juste avec une ligne), mais si plusieurs lignes alors j'ai l'erreur suivante.
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
Code source
index.php
Code:
1
2
3
4
5
6
7
8
9
| <script src="ajax_framework.js" language="javascript"></script>
<div id="insert_response"></div>
<form action="javascript:insert()" method="post">
<p><textarea name="text_all" id="text_all" rows="32" cols="163">
REPLACE INTO `table_stat` VALUES(1, '22-03-2012 15:30:33', 'david', 'Action:ciel')
REPLACE INTO `table_stat` VALUES(2, '22-03-2012 14:22:13', 'gérard', 'Action:ciel');
</textarea></p>
<input type="submit" name="submit">
</form> |
ajax_framework.js
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
| function createObject() {
var request_type;
var browser = navigator.appName;
if(browser == "Microsoft Internet Explorer"){
request_type = new ActiveXObject("Microsoft.XMLHTTP");
}else{
request_type = new XMLHttpRequest();
}
return request_type;
}
var http = createObject();
var nocache = 0;
function insert() {
document.getElementById('insert_response').innerHTML = "Just a second..."
var text_all = encodeURI(document.getElementById('text_all').value);
nocache = Math.random();
http.open('get', 'insert.php?text_all=' +text_all+'&nocache = '+nocache);
http.onreadystatechange = insertReply;
http.send(null);
}
function insertReply() {
if(http.readyState == 4){
var response = http.responseText;
document.getElementById('insert_response').innerHTML = '-/- Site added -\-'+ '\n\r\n\r'+response;
}
} |
insert.php
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
| <?php
//include('config.php');
if(isset($_GET['text_all'])){
$Var_text_all = $_GET['text_all'];
function Magicq ($chaine)
{
if (get_magic_quotes_gpc()) $chaine = stripslashes($chaine);
return $chaine;
}
$HOST = Magicq('localhost');
$USER = Magicq('root');
$PASS = Magicq('');
$BASE = Magicq('point');
$tab_requete = explode("\r\n",$Var_text_all);
$tab_requete = array_filter($tab_requete);
$db = mysql_connect($HOST, $USER ,$PASS );
mysql_query("SET NAMES UTF8");
mysql_select_db( $BASE,$db);
if ($db)
{
foreach ($tab_requete as $requete)
{
$req = mysql_query($requete,$db) or die('Erreur SQL !<br>'.$requete.'<br>'.mysql_error());
if($req)
{
echo "BLA BLA 1";
} else {
echo "BLA BLA 2";
}
echo "BLA BLA 3";
}
echo "BLA BLA 4";
}
echo "BLA BLA 5";
}
?> |
base
Code:
1
2
3
4
5
6
7
8
| CREATE TABLE IF NOT EXISTS `table_stat` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`date_heure` varchar(40) NOT NULL,
`bureau_de` varchar(40) NOT NULL,
`action` text NOT NULL,
PRIMARY KEY (`id`),
KEY `ID_2` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; |
Exemple sql que je veux insérer
Code:
1
2
3
| REPLACE INTO `table_stat` VALUES(1, '22-03-2012 15:30:33', 'david', 'Action:ciel');
REPLACE INTO `table_stat` VALUES(2, '22-03-2012 14:22:13', 'gérard', 'Action:ciel');
REPLACE INTO `table_stat` VALUES(3, '22-03-2012 15:52:32', 'david', 'Action:web'); |
Le textarea et juste un exemple.
Pouvez vous m'aider SVP.
Merci d'avance
