php mysql插入图片路径_从mysql路径中插入图像，并将其检索到<img>使用php标签(Insert image from its path to mysql and retrieve it...

< / div >

index . php

$stmt = $connect->prepare("INSERT INTO tbl_images(name) VALUES (LOAD_FILE(?))");

$stmt->bind_param('s', $path);

$stmt->execute();

< div >

< div >

$connect = mysqli_connect("localhost", "root", "", "test");

if(isset($_POST["insert"]))

{

$path='C:\\xampp\\htdocs\\test_img\\4.jpg';

$query = "INSERT INTO tbl_images(name) VALUES ('LOAD_FILE($path)')";

if(mysqli_query($connect, $query))

{

echo '';

}

}

?>

$query = "SELECT * FROM tbl_images ";

$result = mysqli_query($connect, $query);

while($row = mysqli_fetch_array($result)) {

echo '

';

}

?>