Skip to content

Instantly share code, notes, and snippets.

@micti

micti/message.php

Created November 8, 2015 09:15
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save micti/518986d92773a88c28b4 to your computer and use it in GitHub Desktop.
Save micti/518986d92773a88c28b4 to your computer and use it in GitHub Desktop.
Download ZIP
Iphone One Contact Message Export
Raw
message.php
<?php
// 3d0d7e5fb2ce288813306e4d4636395e047a3d28 -> sqlite file for messages of iphone backup
// handle_id: contact
$sql = new SQLite3('3d0d7e5fb2ce288813306e4d4636395e047a3d28');
$res = $sql->query('select * from message where handle_id = 290 order by date');
$dat = '';
while ($row = $res->fetchArray(SQLITE3_ASSOC)) {
$dat .= $row['text'] . "\n\n";
}
file_put_contents('message.txt', $dat);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment