Display and store image in php/mysql.. HELP!

**cutterpillow20** · 02-27-2013, 04:05 PM

Maaung ud2.. patudlo tana ko unsaon di magdisplay ug image ug store ang image sa php/mysql. kanang magbrowse ka daan sa image na imu gus2 e store tapos display daun.. naa man tutorial ako gsunod sa phpacademy sa youtube.. pero ang gina hatag na image kay broken..



<?php include_once 'mydb_connect.php';?><html>
<head>
<title>image upload</title>
</head>
<body>
<form action = "index.php" method = "POST" enctype = "multipart/form-data">
<label>File: <input type = "file" name = "image"/>
<input type = "submit" value = "Upload"/></label>
</form>
<?php

$file = @$_FILES['image']['tmp_name'];

if(!isset($file)) {
echo "Please select image";
}
else {
$image = addslashes(file_get_contents($_FILES['image']['tmp_name']));
$image_name = addslashes($_FILES['image']['name']);
$image_size = getimagesize($_FILES['image']['tmp_name']);

if($image_size == FALSE) {
echo "Thats not an image!";
}
else {
if(!$insert = mysql_query("INSERT INTO imageupload VALUES('','$image_name','$image')")) {
echo "Problem Uploading Image";
}
else {
$img_id = mysql_insert_id();
echo "Image uploaded.<p/> Your image: <p /><img src=get_img.php?id=$img_id";
}
}
}
?>
</body>
</html>



<?php include_once 'mydb_connect.php';?>
<?php
$id = addslashes($_REQUEST['id']);
$image = mysql_query("SELECT * FROM imageupload WHERE img_id = $id");
$image = mysql_fetch_assoc($image);
$image = $image['image'];
header("Content-type: image/jpeg");
echo $image;
?>

-mao ni ang code..

Salamat!

**jairoh_** · 02-27-2013, 04:24 PM

on pud imo gd library boss?

**cutterpillow20** · 02-27-2013, 05:13 PM

activated man boss.. extension php_gd2.dll. nganu kaha ni b... Salamat di boss!

**jairoh_** · 02-27-2013, 05:34 PM

break it down into two parts like i always do.
1. try sa upload sa mysql lng sa then ipa.display sa php. if di mu.display, then problem in displaying
2. dri naka mag.upload2x sa php then debug

imo gi.pass ang image id dba?
<qoute>
echo "Image uploaded.<p/> Your image: <p /><img src=get_img.php?id=$img_id";
</qoute>

mass maau kung imo sad dawaton through calling $_GET [ 'id' ] boss. mao na ako cge buhaton. mugana man cya. try daw boss
<qoute>
<?php include_once 'mydb_connect.php';?>
<?php
if ( isset ( $_GET [ 'id' ] ) ) {
$id = $_GET [ 'id' ];
$image = mysql_query("SELECT * FROM imageupload WHERE img_id = $id");
$image = mysql_fetch_assoc($image);
$image = $image['image'];
header("Content-type: image/jpeg");
echo $image;
}
?>
</qoute>
pwede wala ranang italic na line, kang if statement ba. try daw boss.

**cutterpillow20** · 02-27-2013, 08:19 PM

payts kaau imu suggestion boss.. wala jud data na gka kuha.. nganu kaha ni.

**ondoy** · 02-28-2013, 07:19 AM

suwayi daw butang ug closing '>' kanang saimo <img> nga tag

**ChaosOrb** · 02-28-2013, 08:07 AM

try daw ni TS : Upload images to a MySQL database (PHP)

**Adones Pitogo** · 02-28-2013, 02:50 PM

Pag codeigniter nalang bai. Dali ra kayo na.

**cutterpillow20** · 02-28-2013, 06:50 PM

wala ghpon boss ondoy.. buak ghpon na image. sige boss chaos try nku karon.. ehehehe! dili pa kaau ko hanas ug php boss gina apply pa naku sa mga project namu karon.. sunod na ko anang codeigniter ehehee!

**ondoy** · 03-01-2013, 01:52 PM

bro,naa ny sulod imong database? if naa e try daw dritso saimo URL http://localhost/ur_project/get_img.php?id=Id_number

din post diri unsy mo gawas

Thread: Display and store image in php/mysql.. HELP!

Thread Tools

Search Thread