0

Hi,

I have created a php file to upload images i want this to store the image name in a mysql database.

I created this php code but when it comes to storing the file name in the database it stores each file name in a new row. Can anyone help me figure this out or point me in the right way.

Thanks alot heres the code!

<?php $conection = mysql_connect("localhost","enthuse1_user1","topiary1") 
or die ('MySQL connect failed. ' . mysql_error());
mysql_select_db("enthuse1_uploadtest") or die('Cannot select database. ' . mysql_error()); ?>

<?php
$uploadNeed = $_POST['uploadNeed'];

for($x=0;$x<$uploadNeed;$x++){
	$file_name = $_FILES['ufile']['name'][$x];
	$file_name = stripslashes($file_name);
	$file_name = str_replace("'","",$file_name);
$copy = copy($_FILES['ufile']['tmp_name'][$x],"upload/".$file_name);
	$image[$x] = "$file_name";
	$column[$x] = "image$x";
 if($copy){
 $query = "INSERT INTO images ($column[$x]) VALUES ('$image[$x]');";
 mysql_query($query) or die('Error, insert query failed' . mysql_error());
 echo "$column[$x]<br>";	 
 echo "$image[$x] | uploaded sucessfully!<br>";
 	
 }else{
 echo "$image[$x] | could not be uploaded!<br>";
 }
} 
?>
2
Contributors
1
Reply
3
Views
7 Years
Discussion Span
Last Post by digital-ether
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.