[RESOLVED] Transfer Data from Facebook to MySQL Database

[Majeste]

Hello!

Using an FQL query, I'm getting my page's notes into a multidimensional array and then with a foreach loop, and a function I wrote I transfer them to my database.

When I print all the elements I have in the array, I got 378 ones but only 282 of all are transferred.

What can be the reason?

 
function makale_tasi ($mid, $kid, $title, $content, $created, $updated)  {

$query = "INSERT INTO makale VALUES
('', '$mid', '$kid', '$title', '$content', '$created', '$updated')";
mysql_query($query);

}

foreach ($notes as $note) {

makale_tasi($note['note_id'], $uid, $note['title'], $note['content_html'], $note['created_time'], $note['updated_time']);

 }

I appreciate any help.

Best,
Gungor

[Majeste]

I solved it.

foreach ($notes as $note) {

	$makale_id = $note['note_id'];
	$title = mysql_real_escape_string($note['title']);
	$content = mysql_real_escape_string($note['content_html']);
	$created = $note['created_time'];
	$updated = $note['updated_time'];

	$inserts[] = "('', '$makale_id', '$uid', '$title', '$content', '$created', '$updated')";

}

$query = "INSERT INTO makale VALUES ". implode(", ", $inserts);

mysql_query($query) or die(mysql_error());

[Weedpacket]

FYI, the MySQL extension is discouraged for new projects, and the MySQLi or PDO extensions should be used instead.