Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $query = "SELECT * FROM images ORDER BY id DESC";
- $statement = $db->prepare($query);
- $statement->execute();
- $result = $statement->fetchAll();
- $number_of_rows = $statement->rowCount();
- <div class="container">
- <a data-toggle="collapse" href="#collapseCimkek" role="button" aria-expanded="false" aria-controls="collapseCimkek"><button type="button" class="btn btn-warning mb-2">Cimkék</button></a>
- <div class="collapse" id ="collapseCimkek">
- <div class="row">
- <div class="col-sm-5 col-md-6"></div>
- <div class="col-sm-5 offset-sm-2 col-md-6 offset-md-0">
- <?php
- $tomb=[];
- foreach($result as $row)
- {
- $matrica = $row["file_matrica"];
- $matrica = explode(" ",$matrica);
- $matrica = array_unique($matrica);
- foreach (array_chunk($matrica, 4) as $chunk){
- foreach ($chunk as $cucc) {
- $cuccli = explode(" ", $cucc);
- echo("<pre>");
- print_r($cuccli);
- echo("</pre>");
- }
- }
- }
- ?>
- </div>
- </div>
- </div>
- </div>
- eredmény:
- Array
- (
- [0] => a,b,c,Z,d,e,f
- )
- Array
- (
- [0] => f
- )
- Array
- (
- [0] => Füzesabony
- )
- Array
- (
- [0] => e
- )
- Array
- (
- [0] => d
- )
- Array
- (
- [0] => c
- )
- Array
- (
- [0] => b
- )
- Array
- (
- [0] => a
- )
- Array
- (
- [0] => Füzesabony
- )
- Array
- (
- [0] =>
- )
- Array
- (
- [0] => Hikvision,kamera,teszt
- )
- array_unique-al próbálkkozom kiszedni a 'Füzesabony'-t ami 2x van a listán de sehogy se megy ...
- fellősz egy képet szerkesztheted a cimkéit (file_matrica) mező ami lehet ('a','1','akármi') .. minden új id kap file_matrica mezőt
- sql tábla:
- id file_name file_description file_tags uploaded_on status file_matrica
- 1 akarmi bármi 1 dátum valami Füzesabony,akármi,bármi
- 2 akármi2 bármi2 2 dátum valami Füzesabony,bármimás,mittudoménmi
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement