multiple file uploads and store path to mysql table - Page 2

Question

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

Stevis2002 0 Newbie Poster · Answer 1 · 2010-12-16T10:35:06+00:00

Went in. Just Y height and width went in
Should $basename etc be ´basename´?

Stevis2002 0 Newbie Poster · Answer 2 · 2010-12-18T17:41:43+00:00

Stevis2002 0 Newbie Poster

13 Years Ago

I shall try it

Stevis2002 0 Newbie Poster · Answer 3 · 2010-12-19T01:39:41+00:00

Still no luck mate. Adds some info but not other......doesn't add image properties...size extension etc.
It also addds each uploaded image to a new testimonial id....how can i add multiple images to the one testimonial please?

Thanks,
Steve

dschuett -1 Junior Poster · Answer 4 · 2010-12-20T19:09:51+00:00

Did you do another var_dump(); on your query and copy and paste the output manually into the mysql terminal?

Stevis2002 0 Newbie Poster · Answer 5 · 2010-12-20T22:36:14+00:00

Stevis2002 0 Newbie Poster

13 Years Ago

Yes, the manual query was the one i did

Tonmoy.saha.JH 0 Newbie Poster · Answer 6 · 2012-07-20T21:07:40+00:00

<?php

if($_POST['pgaction']=="upload")
    upload();
else
    uploadForm();

//The form having dynamic file uploader
function uploadForm() {
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title> :: FILEUPLOAD :: </title>
<link href="style.css" rel="stylesheet" type="text/css" />

<script language="javascript">
<!--
    function _add_more() {
        var txt = "<br><input type=\"file\" name=\"item_file[]\">";
        document.getElementById("dvFile").innerHTML += txt;
    }
    function validate(f){
        var chkFlg = false;
        for(var i=0; i < f.length; i++) {
            if(f.elements[i].type=="file" && f.elements[i].value != "") {
                chkFlg = true;
            }
        }
        if(!chkFlg) {
            alert('Please browse/choose at least one file');
            return false;
        }
        f.pgaction.value='upload';
        return true;
    }
//-->
</script>
</head>

<body bgcolor="#C8C8C8" leftmargin="0" topmargin="0" rightmargin="0" bottommargin="0">


<!--session_start();


$con=mysql_connect("localhost", "root", "") or die(mysql_error()) ; 
 mysql_select_db("reg_db",$con) or die("cannot select DB") ; 
-->
<?php if ($GLOBALS['msg']) { echo '<center><span class="err">'.$GLOBALS['msg'].'</span></center>'; }?><br>


<form name="frm" method="post" onsubmit="return validate(this);" enctype="multipart/form-data">
<input type="hidden" name="pgaction">

    <table align="center" cellpadding="4" cellspacing="0" bgcolor="#EDEDED"> 
        <tr class="tblSubHead">
            <td colspan="2">Upload any number of file</td>
        </tr>
        <tr class="txt">
            <td valign="top"><div id="dvFile"><input type="file" name="item_file[]"></div></td>
            <td valign="top"><a href="javascript:_add_more();" title="Add more"><img src="plus_icon.gif" border="0"></a></td>
        </tr>
        <tr>
            <td align="center" colspan="2"><input type="submit" value="Upload File"></td>
        </tr>
    </table>
</form>

</body>
</html>
<?php
}
session_start();


$con=mysql_connect("localhost", "root", "") or die(mysql_error()) ; 
 mysql_select_db("reg_db",$con) or die("cannot select DB") ; 


 function upload(){

                if(count($_FILES["item_file"]['name'])>0)
                 { //check if any file uploaded
                    $GLOBALS['msg'] = ""; //initiate the global message
                    for($j=0; $j < count($_FILES["item_file"]['name']); $j++)
                     { //loop the uploaded file array
                    $filen=$_FILES["item_file"]["name"]["$j"] ;
                    $tname=$_FILES["item_file"]["tmp_name"]["$j"];
                    $size=$_FILES["item_file"]["size"]["$j"];
                    $oext=getExtention($filen);
                    $ext=strtolower($oext);
                    $base_name=getBaseName($filen);
                    $path = "uploads/".$filen; //generate the destination path

                     if($ext=="jpg" || $ext=="jpeg" || $ext=="bmp" || $ext=="gif" || $ext=="txt" || $ext=="pdf" || $ext=="docx" || $ext=="doc")
                     {
            if($size< 5024*5024){

                if(file_exists($path)){


                    move_uploaded_file($tname,$path ); //upload the file
                    $result = 1;                    
                    list($width,$height)=getimagesize($path);
                    $qry="select id from image where img_base_name='$base_name' and img_ext='$ext'";
                    $res=mysql_fetch_array(mysql_query($qry));
                    $id=$res['id'];

                    $qry="UPDATE image SET img_base_name='$base_name', img_ext='$ext', img_height='$height', img_width='$width', size='$size', img_status='Y' where id=$id";
                    mysql_query($qry);
                    $GLOBALS['msg'] .= "File# ".($j+1)." ($filen) updated successfully<br>";
                    }
                    else
                    {
                    move_uploaded_file($tname,$path );
                    $result = 1;
                    list($width,$height)=getimagesize($path);
                    $qry="INSERT INTO image(id, img_base_name, img_ext, img_height, img_width, size, img_status)VALUES (NULL , '$base_name', '$ext', '$height', '$width', '$size', 'Y')";
                    mysql_query($qry);
                    print_r($qry);
                    $GLOBALS['msg'] .= "File# ".($j+1)." ($filen) uploaded successfully<br>";
                    }
                }
                }
                else{
                    $GLOBALS['msg'] = "Invalid file extention '.$oext'";
                    }
            }
}
else {
        $GLOBALS['msg'] = "No files found to upload"; //Failed message  
    }
    uploadForm(); //display the main form
  }
function getExtention($image_name)
{
return substr($image_name,strrpos($image_name,'.')+1);
}
function getBaseName($image_name)
{
return substr($image_name,0,strrpos($image_name,'.'));


}

?>

Tonmoy.saha.JH 0 Newbie Poster · Answer 7 · 2012-07-20T21:29:09+00:00

The above code posted by me,it has some problem with upload file in the database. but it upload the file into the folder fine. so can any one plz help me. i just modify the above code posted in this topic.

Gloak 0 Light Poster · Answer 8 · 2013-09-24T22:28:18+00:00

Just a late note for those who may use this thread. I tried the very first code, I guess it has been updated after the messages, it worked out of the box (add config file and new directory).
Then I copied the same file into the final folder... and didn't work (file was uploaded, but DB was not updated). No changes whatsover in the code. After a few hours.... the problem was the connection. I don't know PHP, but I think the conn stays opened. As soon as changed my config file, everything worked as a charm.