Discussion :

[chris52]

Bonjour,

Je souhaite encoder une chaîne de caractere plusieurs fois selon le nombre d'images dans une base. Voici mon code :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
$query4 = "SELECT COUNT(*) FROM jos_slide";  
$db->setQuery($query4);
$count = $db->loadResult();
for($i=0;$i<$count;$i++)
       {    
         preg_match('/< *img[^>]*src *= *["\']?([^"\']*)/i', $column[$i], $matches);             
 
$var = array("title"=>"","content"=>"<img src=\\\"$matches[1]\\\" />","caption"=>"" ) ;
 
   }                        
 
 
$champ = '{"type":"slideshow","id":0,"name":"slide     1","settings":{"style":"default","autoplay":1,"interval":5000,"width":"auto","height":"auto","duration":500,"index":0,"order":"default","navigation":1,"buttons":1,"slices":20,"animated":"randomSimple","caption_animation_duration":500},"style":"default","items":{"4f99005b8d886":{"title":"","content":"<img     src=\\\\\"http:\/\/www.sudoku-gratuit.fr\/illusion-optique\/1image-illusion-optique18.jpg\\\\\"  \/>","caption":""},"4f99009d554fa":{"title":"","content":"<img  src=\\\\\"http:\/\/www.crihan.fr\/admin\/imgs\/film_k-epsilon_juil08.jpg\\\\\"  \/>","caption":""},"4f98009d554fa":{"title":"","content":"<img  src=\\\\\"http:\/\//sara.alexander.free.fr\/rw_common\/themes\/blendit\/images\/header\/image5.jpg\\\\\"  \/>","caption":"http:\/\/www.google.com"}}}';
  $data = json_decode($champ,true);
 
$data['items']["4f98769d554fa"] = $var;
   print_r($data);
$data = json_encode($data);

Ceci me fais que la derniere image de ma bdd alors qu'elle en contiens 2.
Comment faire pour que sa marche pour toutes les images de la bdd ?

[chris52]

En fait j'ai trouvé la solution à mon probleme, je vous en fais profiter:

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
$query4 = "SELECT COUNT(*) FROM jos_slide";
 
$db->setQuery($query4);
$count = $db->loadResult();
 
$champ = '{"type":"slideshow","id":0,"name":"slide1","settings":{"style":"default","autoplay":1,"interval":5000,"width":"auto","height":"auto","duration":500,"index":0,"order":"default","navigation":1,"buttons":1,"slices":20,"animated":"randomSimple","caption_animation_duration":500},"style":"default","items":{"4f99005b8d886":{"title":"","content":"<img       src=\\\\\"http:\/\/www.sudoku-gratuit.fr\/illusion-optique\/1image-illusion-optique18.jpg\\\\\"  \/>","caption":""},"4f99009d554fa":{"title":"","content":"<img  src=\\\\\"http:\/\/www.crihan.fr\/admin\/imgs\/film_k-epsilon_juil08.jpg\\\\\"  \/>","caption":""},"4f98009d554fa":{"title":"","content":"<img  src=\\\\\"http:\/\//sara.alexander.free.fr\/rw_common\/themes\/blendit\/images\/header\/image5.jpg\\\\\"  \/>","caption":"http:\/\/www.google.com"}}}';
  $data = json_decode($champ,true);
 
   for($i=0;$i<$count;$i++)
       {
 
 
 
         preg_match('/< *img[^>]*src *= *["\']?([^"\']*)/i', $column[$i], $matches);
         $var = array("title"=>"","content"=>"<img src=\\\"$matches[1]\\\" />","caption"=>"" ) ;                          
         $data['items'][$i] = $var;
 
 
 
 
   }                        
 
 
 
 
   print_r($data);
$data = json_encode($data);