think tank forum

/ / \\ \\ \ \ " " ' ' \" \" \' \' hahaha

a:2:{i:0;s:6:"124-7.";i:1;s:68:"124+7.

/ / \\ \\ \ \ " " ' ' \" \" \' \' hahaha";}

<?php

$dbms_host = "localhost";
$dbms_user = "root";
$dbms_pass = "";
$dbms_db   = "wlw";

header("Content-type: text");

if (!($dbms_cnx = @mysql_connect($dbms_host, $dbms_user, $dbms_pass))) die("connect error");
if (!mysql_select_db($dbms_db)) die("select_db error");
if (!mysql_query("SET NAMES 'utf8'")) die("set names error");
$sql = "CREATE TABLE IF NOT EXISTS `fresh` ( ".
       "    `id` smallint(6) NOT NULL auto_increment, ".
       "    `array` text collate utf8_unicode_ci NOT NULL, ".
       "    PRIMARY KEY  (`id`) ".
       ") ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
if (!mysql_query($sql)) die("couldn't create table");

include "../ttf/include_diff.php";

echo "******";
/////////////////////////////////////////////////
$string_a = "my name is larz\r\n\"i am for reelz\"\r\nhere is more / / \\ \\ \\\\ \\\\ \" \" \' \' \\\" \\\" \\\' \\\'\r\ni like the girls with the boom\r\ni once got busy in a burger king bathroom!";
$string_b = "my name is larz\r\ni am for tru\r\n\r\ni like the girls with the boom\r\ni once got busy in a burger king drivethru!";
$diff = serialize(diff($string_a, $string_b));
$patched = patch($string_a, unserialize($diff));
$unpatched = unpatch($string_b, unserialize($diff));
echo "\n\n*string a:*\n\n";
echo $string_a;
echo "\n\n*string b:*\n\n";
echo $string_b;
echo "\n\n*diff:*\n\n";
echo $diff;
echo "\n\n*patched string a:*\n\n";
echo $patched;
echo "\n\n*unpatched string b:*\n\n";
echo $unpatched;
/////////////////////////////////////////////////

$cleandiff = mysql_real_escape_string($diff);
echo "\n\n*clean diff:*\n\n";
echo $cleandiff;

$sql = "INSERT INTO fresh SET array='$cleandiff'";
if (!$result = mysql_query($sql)) die("insert error");
$id = mysql_insert_id();

$sql = "SELECT array FROM fresh WHERE id='$id'";
if (!$result = mysql_query($sql)) die("select error");
list($mysqldiff) = mysql_fetch_row($result);
mysql_free_result($result);

echo "\n\n*mysql diff:*\n\n";
echo $mysqldiff;

$mysqlpatched = patch($string_a, unserialize($mysqldiff));

echo "\n\n*mysql patched string a:*\n\n";
echo $mysqlpatched;

echo "\n\n****** TESTING ******\n\n";

if ($mysqldiff == $diff) {
    echo "original diff and mysql diff ARE identical.\n\n";
} else {
    echo "original diff and mysql diff ARE NOT identical.\n\n";
};

if ($mysqlpatched == $patched) {
    echo "patched string a and mysql patched string a ARE identical.\n\n";
} else {
    echo "patched string a and mysql patched string a ARE NOT identical.\n\n";
};

if (is_array(unserialize($diff))) {
    echo "original diff WAS serialized into an array.\n\n";
} else {
    echo "original diff WAS NOT serialized into an array.\n\n";
};

if (is_array(unserialize($mysqldiff))) {
    echo "mysql diff WAS serialized into an array.\n\n";
} else {
    echo "mysql diff WAS NOT serialized into an array.\n\n";
};

mysql_close();

?>

original diff and mysql diff ARE identical.

patched string a and mysql patched string a ARE identical.

original diff WAS serialized into an array.

mysql diff WAS serialized into an array.

╔══════════╗
║          ║
║ box time ║
║          ║
╚══════════╝