upload image wordpress

Version imprimable

Bonjour,
lorsque je Upload une image a partir de l'interface admin de wordpress dans mon thème, l'image est enregistré dans la base de donnée dans la table "postmeta" voici les ligne ajouté dans la base de donnée

Code:

1
2
3
4
5
6
7
8
 
INSERT INTO `op2_postmeta` (`meta_id`, `post_id`, `meta_key`, `meta_value`) VALUES
(337, 137, '_edit_lock', '1392461348:1'),  update
(350, 138, '_wp_attached_file', '2014/02/Scan.jpg'),   
 
(351, 138, '_wp_attachment_metadata', 'a:5:{s:5:"width";i:520;s:6:"height";i:460;s:4:"file";s:16:"2014/02/Scan.jpg";s:5:"sizes";a:7:{s:9:"thumbnail";a:4:{s:4:"file";s:16:"Scan-150x150.jpg";s:5:"width";i:150;s:6:"height";i:150;s:9:"mime-type";s:10:"image/jpeg";}s:6:"medium";a:4:{s:4:"file";s:16:"Scan-250x221.jpg";s:5:"width";i:250;s:6:"height";i:221;s:9:"mime-type";s:10:"image/jpeg";}s:5:"small";a:4:{s:4:"file";s:16:"Scan-120x106.jpg";s:5:"width";i:120;s:6:"height";i:106;s:9:"mime-type";s:10:"image/jpeg";}s:11:"InfoWindow1";a:4:{s:4:"file";s:16:"Scan-171x114.jpg";s:5:"width";i:171;s:6:"height";i:114;s:9:"mime-type";s:10:"image/jpeg";}s:14:"InfoWindow1-2x";a:4:{s:4:"file";s:16:"Scan-342x228.jpg";s:5:"width";i:342;s:6:"height";i:228;s:9:"mime-type";s:10:"image/jpeg";}s:11:"InfoWindow2";a:4:{s:4:"file";s:16:"Scan-400x300.jpg";s:5:"width";i:400;s:6:"height";i:300;s:9:"mime-type";s:10:"image/jpeg";}s:18:"EstateDetailsSmall";a:4:{s:4:"file";s:16:"Scan-474x356.jpg";s:5:"width";i:474;s:6:"height";i:356;s:9:"mime-type";s:10:"image/jpeg";}}s:10:"image_meta";a:10:{s:8:"aperture";i:0;s:6:"credit";s:0:"";s:6:"camera";s:0:"";s:7:"caption";s:0:"";s:17:"created_timestamp";i:0;s:9:"copyright";s:0:"";s:12:"focal_length";i:0;s:3:"iso";i:0;s:13:"shutter_speed";i:0;s:5:"title";s:0:"";}}'),
 
(352, 137, 'webbuthemap_mapitem_images', '138');

je veux savoir comment wordpresse décode l'image et tous les information de l'image uploadé pour l'enregistré dans la base de données??.
de l'aide???.
cordialement.
bhrochdi.

20/02/2014, 21h11
miss_socrates

upload image

Wordpress n'enregistre pas les images dans la base de données mais dans le dossier wp-content/uploads/
Dans la base de données n'est enregistré que le lien vers l'image à utiliser.
20/02/2014, 23h07
bhrochdi

merci pour votre réponse

Citation:

Envoyé par miss_socrates

le dossier wp-content/uploads/.

lorsque j'upload une image
1/ dans ce reprtoire upload, l'image est uploadé ensuite redimensionné en 7 taille différent (taille orignal , thumbnail 150*150, medium 250x162, small 120x77 InfoWindow1-2x342x228 , InfoWindow2 400x300, EstateDetailsSmall 474x356). voici le le plugin installé dans la partie admin http://wordpress.org/plugins/meta-box/
2/ dans la base de donnée une ligne est ajouté dans la table postmeta.
le champ meta_key contient :_wp_attachment_metadata
et le champs meta_value contient une tableau sérialisze des infos concernant les image déjà uploadé dans les différent taille:

Code:

'a:5:{s:5:"width";i:520;s:6:"height";i:460;s:4:"file";s:16:"2014/02/Scan.jpg";s:5:"sizes";a:7:{s:9:"thumbnail";a:4:{s:4:"file";s:16:"Scan-150x150.jpg";s:5:"width";i:150;s:6:"height";i:150;s:9:"mime-type";s:10:"image/jpeg";}s:6:"medium";a:4:{s:4:"file";s:16:"Scan-250x221.jpg";s:5:"width";i:250;s:6:"height";i:221;s:9:"mime-type";s:10:"image/jpeg";}s:5:"small";a:4:{s:4:"file";s:16:"Scan-120x106.jpg";s:5:"width";i:120;s:6:"height";i:106;s:9:"mime-type";s:10:"image/jpeg";}s:11:"InfoWindow1";a:4:{s:4:"file";s:16:"Scan-171x114.jpg";s:5:"width";i:171;s:6:"height";i:114;s:9:"mime-type";s:10:"image/jpeg";}s:14:"InfoWindow1-2x";a:4:{s:4:"file";s:16:"Scan-342x228.jpg";s:5:"width";i:342;s:6:"height";i:228;s:9:"mime-type";s:10:"image/jpeg";}s:11:"InfoWindow2";a:4:{s:4:"file";s:16:"Scan-400x300.jpg";s:5:"width";i:400;s:6:"height";i:300;s:9:"mime-type";s:10:"image/jpeg";}s:18:"EstateDetailsSmall";a:4:{s:4:"file";s:16:"Scan-474x356.jpg";s:5:"width";i:474;s:6:"height";i:356;s:9:"mime-type";s:10:"image/jpeg";}}s:10:"image_meta";a:10:{s:8:"aperture";i:0;s:6:"credit";s:0:"";s:6:"camera";s:0:"";s:7:"caption";s:0:"";s:17:"created_timestamp";i:0;s:9:"copyright";s:0:"";s:12:"focal_length";i:0;s:3:"iso";i:0;s:13:"shutter_speed";i:0;s:5:"title";s:0:"";}}'

.

si on fait le unserialize de ces données on obtien ce tableau:

Code:

Array ( [width] => 520 [height] => 460 [file] => 2014/02/Scan.jpg [sizes] => Array ( [thumbnail] => Array ( [file] => Scan-150x150.jpg [width] => 150 [height] => 150 [mime-type] => image/jpeg ) [medium] => Array ( [file] => Scan-250x221.jpg [width] => 250 [height] => 221 [mime-type] => image/jpeg ) [small] => Array ( [file] => Scan-120x106.jpg [width] => 120 [height] => 106 [mime-type] => image/jpeg ) [InfoWindow1] => Array ( [file] => Scan-171x114.jpg [width] => 171 [height] => 114 [mime-type] => image/jpeg ) [InfoWindow1-2x] => Array ( [file] => Scan-342x228.jpg [width] => 342 [height] => 228 [mime-type] => image/jpeg ) [InfoWindow2] => Array ( [file] => Scan-400x300.jpg [width] => 400 [height] => 300 [mime-type] => image/jpeg ) [EstateDetailsSmall] => Array ( [file] => Scan-474x356.jpg [width] => 474 [height] => 356 [mime-type] => image/jpeg ) ) [image_meta] => Array ( [aperture] => 0 [credit] => [camera] => [caption] => [created_timestamp] => 0 [copyright] => [focal_length] => 0 [iso] => 0 [shutter_speed] => 0 [title] => ) )

je veu savoir comment wordpresse géner ce tableau qui contient ces information à propos des image uploadé et comment il rédimensionné les image tous lors de l'upload.
de l'aide???