如何从MySQL记录中获取图像文件名？

Question

I have images as records in question_answers table.

Images storing <span style="font-family:'MS Reference Sans Serif'"><span style="font-size:9pt"><img width="51" height="32" align="bottom" alt="mc001-2.jpg" src="@@PLUGINFILE@@/mc001-2.jpg" border="0"></span></span>

How to get image name mc001-2.jpg from here using PHP and MySQL?

Answer 1

Use preg_match():-

<?php

$str = '<span style="font-family:MS Reference Sans Serif"><span style="font-size:9pt"><img width="51" height="32" align="bottom" alt="mc001-2.jpg" src="@@PLUGINFILE@@/mc001-2.jpg" border="0"></span></span>';
preg_match('/alt="(.*?)"/', $str, $out);

//see first output
echo ($out[1]);

Output:-https://eval.in/399769

<?php
error_reporting(E_ALL);
ini_set('display_errors',1);
$conn = mysqli_query('server name','user name','password','database name') or die(mysqli_connect_error());
$query = mysqli_query($conn,"Select answer from question_answers") or die(mysqli_error($conn));
$img_name_array = array();
if(mysqli_num_rows($query) >0){

    while ($row = mysqli_fetch_assoc($query)){
          $image_data = $row['answer'];
          preg_match('/alt="(.*?)"/',$str, $out);
          $img_name_array[] = $out[1];
    }

}else{

echo "no record exist"; 
}

Note:- $img_name_array will contain all the images name.Thanks.