hello there! i got a question about blob mysql data.i have a button and on buttonclick i want to open a popup (and passing date parameter) and show some details and display a photo.if i try
its not working.if i try
its shows my results.how to pass the parameter and show the results to ? and does anybody knows why it doesnt work with parameter passing ? tnx in advance
Code:
<?php
if (isset($_GET['p'])){
$temp_date=$_GET['p'];
echo "DATE : $temp_d <br>";
$date_m=date('Y-m-d',strtotime($d));
$connect=mysql_connect("localhost","user","pass")
or die ("Check your server connection");
$db_found = mysql_select_db("mydb", $connect);
$SQL = "SELECT * FROM mytable
WHERE date =date_m";
$result = mysql_query($SQL);
$row=mysql_fetch_array($result);
echo "Details: $row[details]<br>";
$content = $row['image'];
header('Content-type:image/jpg');
echo $content;
} ?>
Code:
<?php
$connect=mysql_connect("localhost","user","pass")
or die ("Check your server connection");
$db_found = mysql_select_db("mydb", $connect);
$SQL = "SELECT * FROM mytable
WHERE id=1";
$result = mysql_query($SQL);
$row=mysql_fetch_array($result);
echo "Details: $row[details]<br>";
$content = $row['image'];
header('Content-type:image/jpg');
echo $content;
} ?>
Comment