MultiWebTranslator/dbInsMess_previous.php at master · xavier7179/MultiWebTranslator · GitHub

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
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
<?php

//require_once('auth.php');
require_once('config.php');

$projectID=$_POST['project_id'];


//Connect to mysql server
$link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
if(!$link) {
	die('Failed to connect to server: ' . mysql_error());
}

//Select database
$db = mysql_select_db(DB_DATABASE);
if(!$db) {
	die("Unable to select database");
}


// Il progetto dove lo usi????????
$query="SELECT * FROM `language`";
$result = mysql_query($query);
$vettore_risposta = array();

if ($result) {
	$count=0;
	while($row = mysql_fetch_array($result)){

		if ($count==0){
			$parent=NULL;
		}
		if ($count==1){
			$parent=mysql_insert_id();
		}


		$query2="INSERT INTO `translation`.`messages` (`id`, `message`, `languageID`, `parent.mess.ID`)
			VALUES (NULL, '', '".$row['id']."', '".$parent."')";
		$result2 = mysql_query($query);

		// count++?????
		$messaggi[$count++] = array( "lang_id" => $row['id'], "mess_id" => mysql_insert_id() );

		// count + 1???? ma quante volte lo fai?
		$count=$count+1;

	}

	//???? AVEVO detto JSON....
	//print_r($messaggi);
	//... da cui....
	echo json_encode($messaggi);
}
else
	echo "-1";


// e questo cos'?

/*	if ($result) {
		echo mysql_insert_id();
	}
	else echo "-1";*/


mysql_close($link);


?>