dscojuxf69080 2015-04-21 23:19
浏览 30

只有一次从MySql获取图像数据的会话图像

This is what i am having difficulty with. I know how to put an image into MySql. I know how to retrieve it. Problem is I cannot find how to put the information from the Image Column of MySql and move it in a session across pages. I don't want to always call a query and connect to the base to retrieve the image. I just want it to go into a Session after I have uploaded it into MySql once and use the retrieve code (below) on each page to display it.

Here the code so far.

Sending Image To Mysql

  $image = addslashes(file_get_contents($_FILES['image']['tmp_name']));
  $imagesize = getimagesize($_FILES['image']['tmp_name']);
  if ($imagesize == FALSE)
  {
  echo "That's not an image";
  }
     else 
     {
     $query = mysql_query("UPDATE table SET Image = '$image' WHERE ID = 1") or die(mysql_error());
     }

Retrieve Code I have on a single page that I have retrieved from Mysql

  $sql = "SELECT * FROM table WHERE ID = 1;
  $result = mysql_query("$sql") or die("<b>Error:</b> Problem on Retrieving      Image BLOB<br/>" . mysql_error());
  $row = mysql_fetch_array($result);
  echo '<img src="data:image/jpeg;base64,'.base64_encode( $row['Image'] ).'"/>';

Session Version (above) of what I am hoping for each page (Probably have the syntax wrong)

  echo '<img src="data:image/jpeg;base64,'.base64_encode( $SESSION_$['row'][Image] )).'"/>'; 

The code I have used so far without success This code is after i have placed the image into mysql

$sql = "SELECT * FROM table WHERE id = 1";
$result = mysql_query("$sql") or die("<b>Error:</b> Problem on Retrieving      Image BLOB<br/>" . mysql_error());
$row = mysql_fetch_array($result);    

$_SESSION['row'][Image] = $row;

Somehow I don't think I can do this as it's an array still.

In summary : All I need is a code to retrieve the image from Mysql and put it into a session. Plus the code to put on each page (one line)

Cheers.

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥20 测距传感器数据手册i2c
    • ¥15 RPA正常跑,cmd输入cookies跑不出来
    • ¥15 求帮我调试一下freefem代码
    • ¥15 matlab代码解决,怎么运行
    • ¥15 R语言Rstudio突然无法启动
    • ¥15 关于#matlab#的问题:提取2个图像的变量作为另外一个图像像元的移动量,计算新的位置创建新的图像并提取第二个图像的变量到新的图像
    • ¥15 改算法,照着压缩包里边,参考其他代码封装的格式 写到main函数里
    • ¥15 用windows做服务的同志有吗
    • ¥60 求一个简单的网页(标签-安全|关键词-上传)
    • ¥35 lstm时间序列共享单车预测,loss值优化,参数优化算法