Re: How to call image from mySql to php file

Hello, Firstly, your image table field should be BLOB field then you create a image file (for example image.php). in this file, if your application is more secure, you can control the session variables. You get key column of your BLOB table (for example id, studentnumber and so on) with session variables, GET variables or any way. I always get this column with SESSION variables because it is more secure. After this, for get variables you can call the image to your main application from image.php file with like the following HTML1 code. for session variables you can call the image to your main application from image.php file with like the following HTML2 code. HTML 1 Code - for get variables <img src="image.php?id=1923"> HTML 2 Code - for session variables <img src="image.php"> image.php <?php session_start(); if (!session_is_registered ('username')) { include('hack.inc.php'); exit; } $id=$_SESSION["id"]; //for session variables $hostname="host.haydartuna.net"; $username="username"; $password="xxxxx"; $database="myapplication"; @ $db=mssql_pconnect ($hostname, $username,$password) or die ('Error'); mssql_select_db($database); $sql="select picture from table where id='$id' "; $result=mssql_query($sql); $row=mssql_fetch_assoc($result); echo($row['resim']); ?> -- Haydar TUNA Republic Of Turkey - Ministry of National Education Education Technology Department Ankara / TURKEY Web: http://www.haydartuna.net "Chris Carter" <chandan9sharma@yahoo.com>, haber iletisinde sunlari yazdi:9081704.post@talk.nabble.com... > > I have a field in database called "logos" which has one value > "images/logos/some_logo.jpg" > > In my php I am trying to call it in my php file as image. With this code. > > $sno = $_REQUEST['sno']; > > $query="SELECT logos FROM table WHERE sno = '$sno'"; > > $result=mysql_query($query); > $num=mysql_numrows($result); > > mysql_close(); > $logos=mysql_result($result,$i,"logos"); > > echo " > <div> > <p> $logos </p> > </div>"; > > ?></div> > > But getting errors. What is the way to call image in php file from the > database. I know that this is a very basic question but first time for me. > I > ignored this in the begining but now its right infront of me. > > Please advice. > > -- > View this message in context: > http://www.nabble.com/How-to-call-image-from-mySql-to-php-file-tf3267012.html#a9081704 > Sent from the PHP - General mailing list archive at Nabble.com.