Code Context $xml = $this->get_xmp_array($xmp_data);
foreach($xml['Seq'] as $row) {
$single_data = array();
$item_details =
[
'path_root' => '/media/images/IMAGES DONE/',
'drive' => 'D',
'originalpath' => 'D:/Images/Images Done/Library/SF295/230352.jpg',
'FileSize' => '551 KB',
'is_book' => false,
'keywords' => 'Football',
'real_path' => '/media/images/IMAGES DONE/Library/SF295/',
'path' => 'Library/SF295/230352',
'file_path' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF295/',
'file_pathBig' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF295/',
'file_pathSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF295/',
'file_name' => '230352.jpg',
'id' => '230352',
'sku' => '230352',
'image' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF295/230352.jpg',
'imageBig' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF295/230352.jpg',
'imageBigPreview' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF295/230352.jpg',
'imageSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF295/230352.jpg',
'categorycode' => 'ANI',
'moreimages' => 'D0612012',
'headline' => 'Ballinderry v Crossmaglen Rangers - AIB Ulster Club Senior Football Championship Final',
'headlineTruncated' => 'Ballinderry v Crossmaglen Rangers - AIB Ulster Club Senior Football ',
'caption' => '3 December 2006; Crossmaglen Rangers, players and supporters left Casement park in a field of Mud. AIB Ulster Club Senior Football Championship Final, Ballinderry v Crossmaglen Rangers, Casement Park, Belfast, Co. Antrim. Picture credit: Oliver McVeigh / SPORTSFILE',
'DateCreated' => 'Sun, 03 Dec 2006 00:00:00 +0000',
'ShortDate' => '03 Dec 2006',
'LongDate' => 'Sunday 3rd Dec 2006',
'db_DateCreated' => '200612030000',
'event_images_count' => (int) 37,
'event_images_count_text' => '37 Images',
'parent_block' => '',
'parent_block_class' => '',
'image_link_url' => 'https://www.sportsfile.com/more-images/D0612012/',
'w' => '3240',
'h' => '2268',
'dimensions' => 'width='180'',
'mobile_dimensions' => 'style="width:100%;"',
'orientation' => 'horizontal',
'iptc_leadimage' => 'False',
'is_editorial' => 'false',
'is_hidden' => 'false',
'width' => (int) 3240,
'height' => (int) 2268,
'display_priority_timestamp' => (int) 0,
'event_group_lead_image' => 'f',
'page_sort' => (int) 0,
'date_sort' => (int) 0,
'display' => 'true',
'reindex' => 'false',
'alt' => '3 December 2006; Crossmaglen Rangers, players and supporters left Casement park in a field of Mud. AIB Ulster Club Senior Football Championship Final, Ballinderry v Crossmaglen Rangers, Casement Park, Belfast, Co. Antrim. Picture credit: Oliver McVeigh / SPORTSFILE',
'folderid' => (int) 5000,
'link' => 'https://www.sportsfile.com/id/230352/',
'purchase_item' => true,
'button' => '<a href='https://www.sportsfile.com/id/230352/'>Purchase This Print</a><br/>',
'single_image_link_text' => 'Purchase Print',
'gallery_actions_default' => '<div class="gallery-actions">
<a href="https://twitter.com/intent/tweet?url=https%3A%2F%2Fwww.sportsfile.com%2Fid%2F230352&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Ballinderry+v+Crossmaglen+Rangers+-+AIB+Ulster+Club+Senior+Football+" class="left" onclick="track_share_click('twitter');"><div class="icon-medium icon-medium-twitter"></div></a>
<a class="facebook left" target="_blank" onclick="track_share_click('facebook'); return !window.open(this.href, 'Facebook', 'width=640,height=300')" href="https://www.facebook.com/sharer/sharer.php?u=https://www.sportsfile.com/id/230352&t=Ballinderry+v+Crossmaglen+Rangers+-+AIB+Ulster+Club+Senior+Football+"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/230352/" class="text12 gallerylink right gallery-history-link">Purchase Print</a></div>',
'gallery_actions_corporate' => '<div class="gallery-actions corporate-box"></div>',
'permission_name' => 'access_5000',
'twitter_share_link' => 'https://twitter.com/intent/tweet?url=https%3A%2F%2Fwww.sportsfile.com%2Fid%2F230352&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Ballinderry+v+Crossmaglen+Rangers+-+AIB+Ulster+Club+Senior+Football+',
'facebook_share_link' => 'https://www.facebook.com/sharer/sharer.php?u=https://www.sportsfile.com/id/230352&t=Ballinderry+v+Crossmaglen+Rangers+-+AIB+Ulster+Club+Senior+Football+',
'gallery_actions' => '<div class="gallery-actions">
<a href="https://twitter.com/intent/tweet?url=https%3A%2F%2Fwww.sportsfile.com%2Fid%2F230352&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Ballinderry+v+Crossmaglen+Rangers+-+AIB+Ulster+Club+Senior+Football+" class="left" onclick="track_share_click('twitter');"><div class="icon-medium icon-medium-twitter"></div></a>
<a class="facebook left" target="_blank" onclick="track_share_click('facebook'); return !window.open(this.href, 'Facebook', 'width=640,height=300')" href="https://www.facebook.com/sharer/sharer.php?u=https://www.sportsfile.com/id/230352&t=Ballinderry+v+Crossmaglen+Rangers+-+AIB+Ulster+Club+Senior+Football+"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/230352/" class="text12 gallerylink right gallery-history-link">Purchase Print</a></div>',
]
$sql = 'select user_activity_tbl.*,users_tbl.name from user_activity_tbl
inner join users_tbl on user_activity_tbl.user_id=users_tbl.user_id where path='Library/SF295/230352' and action like '%editorial_image'
order by id'
$conn = object(Cake\Database\Connection) id:0 {
'config' => [
'password' => '*****',
'username' => '*****',
'host' => '*****',
'database' => '*****',
'port' => '*****',
'driver' => 'Cake\Database\Driver\Postgres',
'persistent' => 'false',
'timezone' => 'UTC',
'flags' => [
],
'cacheMetadata' => true,
'log' => false,
'quoteIdentifiers' => false,
'datasource' => 'Database/Postgres',
'schema' => 'public',
'prefix' => '',
'encoding' => 'utf8',
'url' => null,
'name' => 'default',
]
'driver' => object(Cake\Database\Driver\Postgres) id:1 {
'connected' => true
}
'transactionLevel' => (int) 0
'transactionStarted' => false
'useSavePoints' => false
'logQueries' => true
'logger' => object(DebugKit\Database\Log\DebugLog) id:2 {
protected _queries => [
'' => [maximum depth reached],
]
protected _logger => null
protected _connectionName => 'default'
protected _totalTime => (int) 4
protected _totalRows => (int) 1
protected _includeSchema => false
}
}
$query = object(Cake\Database\Log\LoggingStatement) id:0 {
protected _logger => object(DebugKit\Database\Log\DebugLog) id:1 {
}
protected _compiledParams => [
]
protected startTime => (float) 1758147686.016
protected loggedQuery => null
protected _statement => object(Cake\Database\Statement\PDOStatement) id:2 {
}
protected _driver => object(Cake\Database\Driver\Postgres) id:3 {
}
protected _hasExecuted => true
}
$editorial_history = [
]
$file = '/media/images/IMAGES DONE/Library/SF295/230352.jpg'
$var = [
'var' => [
'www_dir' => '/var/www/html',
'www_url' => 'http://www.sportsfile.com',
'web_dir' => '/var/www/html/src/webroot',
'web_url' => 'http://www.sportsfile.com',
'mod_dir' => '/var/www/html/mod/',
'mod_url' => 'http://www.sportsfile.com/mod/',
'cls_dir' => '/var/www/html/src/webroot/class/',
'cls_url' => 'http://www.sportsfile.com/class/',
'xml_dir' => '/var/www/html/src/webroot/xml/',
'img_dir' => '/var/www/html/src/webroot/images/',
'img_url' => 'http://www.sportsfile.com/images/',
'css_url' => 'http://www.sportsfile.com/css/',
'js_url' => 'http://www.sportsfile.com/js/',
'_mstart' => (float) 1758147685.9996,
'_log' => '',
'_onload' => '',
'_style' => '',
'_script' => '',
'_main' => 'main',
'_action' => 'main',
'_file' => 'main',
'_xmlact' => 'main.xml',
'_source' => 'post',
'www_index' => 'http://www.sportsfile.com/index.php',
'www_self' => 'http://www.sportsfile.com/id/230352',
'www_script' => 'http://www.sportsfile.com/index.php?action=main',
'ccode' => 'EUR',
'cname' => 'Euro',
'cicon' => '€',
'email_support' => 'liam@zeitsolutions.com',
'twitter_widgets_js' => '<script type="text/javascript" src="//platform.twitter.com/widgets.js"></script>',
],
'dataset' => [
'status' => [
(int) 1 => 'New Order',
(int) 2 => 'Sent To Printer',
(int) 3 => 'In Print',
(int) 4 => 'Cancelled',
(int) 5 => 'Posted',
],
],
]
$image_xmp_history = [
]
$key_data = [
'DRP' => 'Dropped',
'TXT' => 'Metadata Edited',
'ACT' => 'Sent to an Action',
]
$content = '��� JFIF H H ��$�Exif MM * J R( �i Z �
�� '
�� ' � � �� � � �( � #� H H ��� JFIF H H �� C !"$"$�� C�� � �! ��
�� � } !1AQa"q2���#B��R��$3br�
%&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz������������������������������������������������������������������������
�� � w !1AQaq"2�B���� #3R�br�
$4�%�&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz����������������������������������������������������������������������� ? ��:�F9�t�*� s�^����6��W��c=�y�Y��+�#����MQ�k'.��=��DFzS���r݈$隌(=�E��ܒ5<q����*(S�x����t����#�5j4��h�&(p�pMjJ#1�z�H�L)N�A5VIN9�V�F%I��Vt�\����秵Iؖ�4�`����[��-M+M��ϥm�Em"�F|`�W{���G !s��pNqL�!*�-�J�d��LN�8�/c;\Qk!�$vm��
�Q!����yTA�VNM�$�
��a��v������5q�D1�EF@�8ߨ4�B��RK}�Zb���Z��TX�R�v�ɪN�+`/��0drY0 7_JAd�r��W8
6ʼ`
*��aX���+Vc�Ƶ�/��9��N��rG�8��;��3ƎNw ����!�3X���;��d��LGaYI���c�JW(p��Mڴ^�+0Z��&�c�M����i�hCb��Z�-�`����)��/sT�pzQ���ϰr�&�\ H���1n�*�'ګ�t�3��Z���(Kx9�Q[%a���C�V��ā���3LЅ�9������XLЗNm�G�
���������y@����jR��`���h'�cN<���u R�M��Lu^�Z&�h`��֞��b�b��0>�?Z�WX�>������tY�$��h���B����QI*:� �ڴD�k$͈�§:.W36���u9t�c�d8�(��d�g/��S�ڍ���մ��es��l��r�� �V�xz�������-�����'-�f�U�d(�sj8�"$�=jx�m�C��1X�f�tc��?%�ɛ���� f��t�o���mE3�>5k^!�k᫋q����+�<�Ę�,;
��A,UF�O�~*x[���{�J�%�yWzM┕&�"!`<ͤ����N1�p���CK~'|J�Ûki<Iu2Mr�����#��q� ��G_�G���~��k�vgW���:�!nh6�n
�98a�x����_�5�x�M�m�C��4PL�E67���pH� ��V���3�
� b{�
����jv�i�}��s��Pj:T�G
��34�1��r�ч�O��Rb�l�f����
6�R�\_c�Wy��j��I�����3U��|=�Xk�msa�
��w��
H��s�dx�ƞ�q&�z��HbH�䝶��#S�Grq��ŭɕ�7!��^ �E(Ae[�GJ���� ���9����|-��-��>&܉ ��gHN�P|����$q\4��Kw���J�����_�ޛ8n�1r�pF~@I���>U�t�ݚ>:j3]�➿m���tH�o�1��B��N:���� I.�I�x�'P���Ք���9�(�5q8��So��HO�b��qry��|TK�8��կ4�#�g2 #8�VB<�i�Xx-�DW:&�� ���Q�i�Xc��x�nw�m�é�M�[��d�R֣�a��gC�� ��A��KϦq�7�>?�4O�^#�ރ�=J�-G�{����$2?y�9��뚹�q���Q�$��ڀ=��y�� �H���IRI��b0Cq�#'��}�|`������>�-ȴ�Q�Qq2mm�$��%~P���D'9n���vG����C]��R��[y�0�̶��P� +��
�<֛j��!�^Y��ܨ��5g-ۅȘ9ڛ:#��Fa5�Ӕ_Wӧ��N�Mt-��}g�w:]���M�İ�q%� �˩Q�J�e�ـ��,�I5cH��{dn�ک��I�6�qAcj~b�J� ]�v�3�t�c�W�9{*�z�-��6R�4V��xW❷�,�}6�I�"��3.�E$�I�YQ
��a��f����:���W!����:�h�^PpWd��T�~L�n7 y�V5�� �h̦�or�&�p�����$RX-�I�� �U�\�!�J�s2���g�ZW�b�I��"6��.J��Q�0'n� ns��Esb���k;'wKi�ц�*���U�;�(4H5�Bu[�7q���!b��ܡ2��G`�c�%:ߙi���4�i�����0�l��e�Ő�C�r:�YJ
���(�nm��^��U�|K~;{��]��ݑ��#8�M���*A�7�Ww:=��*�I{4�,.Pγo{�,I��K����pʁX�>YhR�����ta�cqm�ݘ������{��vO��j~ӿ&��c�ouKd�!��)6�7�̨NӖ*#n���������jS��F��q�d�E�e<�RB�A9�@#�=+C�ƥ�����3,e���I�Տ$�1]�*��f*|��T��7�r�$v�Yx\)�d�$|����='��-����;�>M+I��Gks��fP��v���'�Ex:5B�抓�u~�� �x^���������Fi�J�Ob�����9 �Е��֊�ȓ�v>o�kh'i�E�cCQ��6;ry�Y�Qp5�hݐJ���e��OA�R���������1o�1 9;� :�q���r
�ܶ�[��8SjF�eT� '�I<w�_3bQHغ��aӭt�)f���^\��2�[;q�
��r3����݄�6��,J�U�� e�����'� �<�Q�~���D�x����,l�
����ֲ�F�0�� ��t� >�ҳܓi.Ěz,�
�,ѿ �ӷ5���-�5s����v�����dcT��c�3�� �8f���̚�ߞ�Ό=�+u��B�ǚu���+oy�+ۛ��
��(��K��r�>���yv��OZ��ȠX�w�(�hF�� �����T��~r_�X��g�ln[j���[y���kz�F�(���e�ɔ77����|�_@մ�a�뛍9�����P��Q��n1����Ve�G��+r����펌/�7���v����&�+������Cqp���Na. %FA�8�Ԋ��*� Mо?�t�+;���TԬ�Ew:2������^�9�t�: /���
�_<��ٓ�_"kRxj���K�tk�q�[�h���S�>X| 2�Ư�5�/�Km6�M����Kv)K�K�x�I -�oL��?6+�B�j�_��{�����|k������43Yypھ�2�2�6�ܝy?/Z��kڮ���%�Ʃwl�ɲfet>J'�1���T,V�y`���UI;��r�k̻U�I���`NO'��֫ϫ�����@t��db���$բ����"ޡ{o�k[y����<`� ��o�*CZ�[�}��2}���]ާz�W!�e}�\�Y��4��'ԯdd�"%wf���__���f�-��9 �F!Q@ ��rsڵ.��2���3��3��}q3�ev�b_�ގK�V\e�>нi���
��g��m*��na��+�p�Z��rĀ98��!�O���(�����ӏ ��b�#|Ý�o���=��?�d���
��v�W��/����bo��.�?�-���#�vEu�����'�>#뤣�w� ?��TTޥ�4��N�+f�Zx�R��
�������4����g���G:�\kb� �
��KD����`@�������(ߙY�?����j���Ƌ&�w�j�� S��S��5�̗ ��H�����(2Ǩ��m3 ��4ea�L�����G�N
C=��ʜ'y��G9r��$a�a�rJ�;�e�y�h �<_=�3jw�\��ػF�7���#���q�Ui(����>�c���>�o�����K�sp�w$�o+I� o��'��>�!�[���� f\�#�d4�"�EϘ1�d#�
�A����ǚZ�CZ3�W<���#&����w
Ξ��$�0fg�mR:�<�y5��eki��&�1.�c�Sq��g���9���f�oo�֜���h�ꄼ/}ɨ^�p@w�����8 ~B�5�$��JR ���gB�Mi�0��hu� �5��S���Ŗpv0+��۟�z�P�m˦K($)�r+����ƕ���Q�y�p�RzQQ��3�$�5e�,�I���u��mmpм��$X9' �o�? w�kp��9|c5,(�1��O�#�֒�|�,M�pC>��4���# y���#?PH��I�b$��7rI�k����� i�"8�-ޙwu
u,��wx��9��mC�3���v���^�X����y/,���H�>7)S� ,��F6�>�& ��Ā
�V�ά��o˿R��]H��C�Q�$Tq�9�F�9��D2�0 �]l~=��:=���u�,!�"���#DEj��p �VS�
���S�o�|[�mkF���-cU�/�/�$�� � �8�OA]���;Tѣ�5�[Id��G�w��+��G �؎(�-�P�U�_���fּsey9�����1�D�`rOB[�y��B�őprx��|��1���]��H��d��/?�*�ݔ����1�~mÕ�c����u�d��L�u�}6��P�j���v�f����O���s���e$\8��$}+��\�Ár(���B�J�b�nf�3�^�SK@m�0P�p1��H���21�5��V��wv#��$}�M�UH������CC}ӓ��ք2K�e�H.��:Sn�h��7꤯�hYqm�� �k��?�� gx��̾e��7��^� �4gV��0>�ڦkF8�u� 5�m/�ށp�(��yaeL�g�a��r��c^E{as�^��y���G�d=Uъ���*a�-�̷�\�a$�H��Ҷd������T���?J� ��
���pɭ]m�id&?9m �ēۡ�Rٖ<}�j1��x�Dw)w��s�k���잽��J�?uXrܖ��z�NJ����7�y��z��+���2�wQ�f�g�a����$�ʫ�%�yV�mFK����8%X��'>ߍf���(�� u�#����Nh�\�f��a�v��_��<�����w^p�sȧ$/'��O4�[_1��J���2~��ȩ��P܌>�M�F�nwq�������1��۲A�WpG<`sD�WD�|��ŏ�R}�J�.�fiQ#" �|��;g�^ѥ�ѼCe�[yI,�0*U�������kڪ�|Q�[���;���G'*H���ϧN��M��=V�+vynK�PA*�.I9���k:M6�
��ǁD��aۨ�2*垞��$>J��?� 9^���ki;"