mela qed naddi SQL statement biex igibli l informazzjoni min god database sewwa?
$select = "SELECT * FROM gallery WHERE horse_id = '" . $horse_id . "'";
$horse_id qed jigi minn go javascript ovjament.
issa one of the columns qieghed photo_link li fija ha jkun hemm path file ghal image 'C:\Users\hex4_sexy.jpg' or whatever
jien nixtieq li kull image li jsib min dak l istatement naghmel thumbnail taghha bil php u jibata lura lil javascript.
$horse_id = $_GET['hid'];
$select = "SELECT * FROM gallery WHERE horse_id = '" . $horse_id . "'";
$result = mysql_query($select) or die(mysql_error());
$photos = array();
for ($i = 0; $i < mysql_num_rows($result); $i++)
{
header('Content: image/jpeg');
$filestats = stat(mysql_result($result, $i, 'photo_link'));
$size = $filestats[7]/1024;
$sizeinkb = (int) $size;
$dimensions = getimagesize(mysql_result($result, $i, 'photo_link'));
$newwidth = 200;
$newheight = 150;
$thumb = imagecreatetruecolor($newwidth, $newheight);
$source = imagecreatefromjpeg(mysql_result($result, $i, 'photo_link'));
imagecopyresized($thumb, $source, 0, 0, 0, 0, $newwidth, $newheight, $dimensions[0], $dimensions[1]);
imagejpeg($thumb);
echo '<table width="100%">';
echo '<tr>';
echo '<td width="20%" rowspan="3"><img width="150" hieght="100" src="' . mysql_result($result, $i, 'photo_link') . '"></td>';
echo '<td>Size</td><td>' . $sizeinkb . 'kb</td>';
echo '</tr><tr>';
echo '<td>Dimensions</td><td>' . $dimensions[0] . 'x' . $dimensions[1] . '</td>';
echo '</tr><tr>';
echo '<td>Image path</td><td> ' . mysql_result($result, $i, 'photo_link') . '</td>';
echo '</tr>';
echo '</table>';
}
u kull ma qed jigi huma symbols :/
(probabli ghax l ajax jiehu lura .requestText = jaqleb kollox text jew forsi l header mux tajjeb?
cheers