Jump to content

Images dont get uploaded to DB at all


Russia

Recommended Posts

I have this script where it uploads the file name to a database plus a few more things.

 

Main Upload form. (img_add.php)

 <form enctype="multipart/form-data" action="img_add.php" method="POST"> 
Name: <input type="text" name="name"><br> 
E-mail: <input type="text" name = "email"><br> 
Phone: <input type="text" name = "phone"><br> 
Photo: <input type="file" name="photo"><br> 
<input type="submit" value="Add"> 
</form>

 

Uploader. (img_add.php)

<?php 

//This is the directory where images will be saved 
$target = "mainnewsimg/"; 
$target = $target . basename( $_FILES['photo']['name']); 

//This gets all the other information from the form 
$name=$_POST['name']; 
$email=$_POST['email']; 
$phone=$_POST['phone']; 
$pic=($_FILES['photo']['name']); 

// Connects to your Database 
mysql_connect("localhost", "root", "") or die(mysql_error()) ; 
mysql_select_db("chat") or die(mysql_error()) ; 

//Writes the information to the database 
mysql_query("INSERT INTO `images` VALUES ('$name', '$email', '$phone', '$pic')") ; 

//Writes the photo to the server 
if(move_uploaded_file($_FILES['photo']['tmp_name'], $target)) 
{ 

//Tells you if its all ok 
echo "The file ". basename( $_FILES['photo']['name']). " has been uploaded, and your information has been added to the directory"; 
} 
else { 

//Gives and error if its not 
echo "Sorry, there was a problem uploading your file."; 
} 
?>

 

And the one that views it. (img_view.php)

It uses a get function so do it with img_view.php?img=2

<?php 
mysql_connect("localhost", "root", "") or die(mysql_error()) ; 
mysql_select_db("chat") or die(mysql_error()) ; 

//Retrieves data from MySQL 
         $newsid = $_GET['img'];
$data = mysql_query("SELECT * FROM `images` WHERE id ='$newsid'") or die(mysql_error()); 

//Puts it into an array
while($info = mysql_fetch_array( $data )) { 
//Outputs the image and other data
Echo "<img src=mainnewsimg/".$info['photo'] ."> <br>";
}
?> 

 

And my database sql.

 

CREATE TABLE IF NOT EXISTS `images` (
  `name` varchar(30) DEFAULT NULL,
  `email` varchar(30) DEFAULT NULL,
  `phone` varchar(30) DEFAULT NULL,
  `photo` varchar(30) DEFAULT NULL,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `images`
--

INSERT INTO `images` (`name`, `email`, `phone`, `photo`, `id`) VALUES
('sdf', 'sdfdsdsf', 'dsffsfsdf', 'arrow_forward_last.gif', 1),
('sadd', 'sadd', 'adsadasdad', 'artbottomshadr.png', 2);

 

The values inside I had to put in manually to test if it worked for the img_view.php

 

Anyways, It doesnt want to upload the images at all, even tho it says it did and gives the message

The file ". basename( $_FILES['photo']['name']). " has been uploaded, and your information has been added to the directory

 

I would greatly appreciate some help, I also provided everything so you can try it on your own server too.

Link to comment
https://forums.phpfreaks.com/topic/231200-images-dont-get-uploaded-to-db-at-all/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.