Expand|Select|Wrap|Line Numbers
- <?php
- //$file_dir="/htdocs/upload";
- // Connect to database
- $db_name1="test";// Database name
- $conn1=mysql_connect("localhost","","") or die("I Couldn't connect");
- $db=mysql_select_db($db_name1,$conn1) or die("I Couldn't select your database");
- data base
- //$q = <<<CREATE
- //create table pix (
- //pid int primary key not null auto_increment,
- //title text,
- // imgdata longblob)
- //CREATE;
- //(@mysql_query($q);
- $imgdir="../image/latest.jpg";
- if ($_REQUEST['completed'] == 1) {
- // Need to add - check for large upload. Otherwise the code
- // will just duplicate old file ;-)
- // ALSO - note that latest.img must be public write and in a
- // live appliaction should be in another (safe!) directory.
- move_uploaded_file($_FILES['imagefile']['tmp_name'],$imgdir);
- $instr = fopen($imgdir,"rb");
- $image = addslashes(fread($instr,filesize($imgdir)));
- //echo "jamal khan =".$fupload;
- if (strlen($instr) < 149000) {
- mysql_query ("insert into pix (title, imgdata) values (\"".
- $_REQUEST['whatsit'].
- "\", \"".
- $image.
- "\")");
- } else {
- $errmsg = "Too large!";
- }
- }
- $gotten = @mysql_query("select * from pix order by pid desc limit 1");
- if ($row = @mysql_fetch_assoc($gotten)) {
- $title = htmlspecialchars($row['title']);
- $bytes = $row['imgdata'];
- //echo"if executed succefully";
- } else {
- $errmsg = "There is no image in the database yet";
- $title = "no database image available";
- // Put up a picture of our training centre
- $instr = fopen($imgdir,"rb");
- $bytes = fread($instr,filesize($imgdir));
- }
- if ($_REQUEST["gim"] ==1) {
- header("Content-type: image/jpeg");
- echo "sdfds";
- print $bytes;
- exit ();
- }
- ?>
- <html><head>
- <title>Upload an image to a database</title>
- <body bgcolor=white><h2>Here`s the latest picture</h2>
- <font color=red><?= $errmsg ?></font>
- <center><img src=?gim=1 width=144><br>
- <b><?= $title ?></center>
- <hr>
- <h2>Please upload a new picture and title</h2>
- <form enctype=multipart/form-data method=post>
- <input type=hidden name=MAX_FILE_SIZE value=150000>
- <input type=hidden name=completed value=1>
- Please choose an image to upload: <input type=file name=imagefile><br>
- Please enter the title of that picture: <input name=whatsit><br>
- then: <input type=submit></form><br>
- <hr>
- </body>
- </html>
The Question is now that how i can i access Image using the above scnario
The Actual Problem here <body bgcolor=white><h2>Here's the latest picture</h2>
<font color=red><?= $errmsg ?></font>
<center><img src=?gim=1 width=144><br>
<b><?= $title ?></center>
<hr>
in <img >tage but cannot understand.
Please help me, i will be very thankfull to all of u?