nuotraukų rodymas php

[GGYep]

Sveiki, kita problema

 

 

PHP KODAS:

<?php
// Create connection
$conn = new mysqli($hostname_testinu_sotre, $username_testinu_sotre, $password_testinu_sotre, $database_testinu_sotre);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
} 


$sql = "SELECT * FROM test_image";
$result = $conn->query($sql);


if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
echo $row['image']; 
}
} else {
echo "0 results";
}


$conn->close();
?> 

Man turėtų rodyti nuotraukas visas iš eilės einančias mysql (pagal id)

Tačiau man rodo kažkokius simbolius. :/

Redaguota Liepos 5, 2016, nario GGYep

[༼ つ ͠° ͟ ͟ʖ ͡° ༽つ]

Pabandyk:

<?php
// Create connection
$conn = new mysqli($hostname_testinu_sotre, $username_testinu_sotre, $password_testinu_sotre, $database_testinu_sotre);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
} 


$sql = "SELECT * FROM test_image";
$result = $conn->query($sql);


if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
echo '<img src="data:image/jpeg;base64,'.base64_encode( $row['image'] ).'"/>';
}
} else {
echo "0 results";
}


$conn->close();
?> 

[GGYep]

Dėkui

+ rep