首页 > 代码库 > php把图片存入mysql DATA库

php把图片存入mysql DATA库

  php把图片存入mysql DATA库----在网站建设过程中,笔者与大家分享一下用php把图片存入mysqlDATA库中并在网页上显示的代码,具体如下:

  //保存图片到DATA库

  If($Picture != "none") {

  $PSize = filesize($Picture);

  $mysqlPicture = addslashes(fread(fopen($Picture, "r"), $PSize));

  mysql_connect($host,$username,$password) or die("Unable to connect to SQL server");

  @mysql_select_db($db) or die("Unable to select database");

  mysql_query("INSERT INTO Images (Image) VALUES ($mysqlPicture)") or die("Cant Perform Query");

  }else {

  echo"You did not upload any picture";

  }

  //以img标签读取DATA库中的图片

  mysql_connect($host,$username,$password) or die("Unable to connect to SQL server");

  @mysql_select_db($db) or die("Unable to select database");

  $result=mysql_query("SELECT * FROM Images") or die("Cant Perform Query");

  While($row=mysql_fetch_object($result)) {

  echo "";

  //如secoed.php文件代码如下

  $result=mysql_query("SELECT * FROM Images WHERE PicNum=$PicNum") or die("Cant perform Query");

  $row=mysql_fetch_object($result);

  Header( "Content-type: image/gif");

  echo $row->Image;

  ......

  注:本文由绵阳网站建设专家【奇远科技www.7wangzhanjianshe.com】整理,引用请注明来源!

php把图片存入mysql DATA库