Need help with client doc upload function

tomdchi · September 20, 2008

I want the ability to upload docs tied to a client. I have been able to put a form into clientsummary.tpl that will do this into a table called upload. The problem I am having is getting the userid to pass through to the php script. I have tried a bunch of trial and error but no luck. The files do upload fine but there is no userid in the userid field on the db. Can someone take a look and hopefully tell me what I am missing. Still a noob but learning:-)

Thanks,

Tom

Here is the form that I have inserted into clientsummary.tpl:

<tr>

</tr>

</table>

</form>

The contents of upload.php file:

<?php

include("dbconnect.php");

include("includes/functions.php");

if(isset($_POST['upload']))

{

$fileName = $_FILES['userfile']['name'];

$tmpName = $_FILES['userfile']['tmp_name'];

$fileSize = $_FILES['userfile']['size'];

$fileType = $_FILES['userfile']['type'];

$userid = $_POST['userid']['userid'];

// i have tried many variations for the above variable $userid but I think its wrong

$fp = fopen($tmpName, 'r');

$content = fread($fp, $fileSize);

$content = addslashes($content);

fclose($fp);

if(!get_magic_quotes_gpc())

{

$fileName = addslashes($fileName);

}

$query = "INSERT INTO upload (userid, name, size, type, content ) ".

"VALUES ('$userid', '$fileName', '$fileSize', '$fileType', '$content')";

mysql_query($query) or die('Error, query failed');

echo "<br>File $fileName uploaded<br>";

}

?>

tomdchi · September 21, 2008

Now I need to be able to download these. The script I have picks up the first document in the database for the client but not others and opens up a box to open or save. I want it to bring up a new window displaying all filenames for the given userid with a hyperlink. Can anyone help with this?

Here is what I am using now:

I access the file below from the admin with a link: download.php?userid={$clientsdetails.userid}

<?php

if(isset($_GET['userid']))

{

include("../dbconnect.php");

include("../includes/functions.php");

$userid = $_GET['userid'];

$query = "SELECT name, type, size, content FROM upload WHERE userid = '$userid'";

$result = mysql_query($query) or die('Error, query failed');

list($name, $type, $size, $content) = mysql_fetch_array($result);

header("Content-Disposition: attachment; filename=$name");

header("Content-length: $size");

header("Content-type: $type");

echo $content;

exit;

}

?>

<html>

<head>

<title>Download File From MySQL</title>

</head>

<body>

<?php

include("../dbconnect.php");

include("../includes/functions.php");

$query = "SELECT * upload WHERE userid = '$userid'";

$result = mysql_query($query) or die('Error, query failed');

if(mysql_num_rows($result) == 0)

{

echo "Database is empty <br>";

}

else

{

while(list($userid, $name) = mysql_fetch_array($result))

{

?>

<?

}

?>

</body>

</html>

What I did to make upload function in admin:

Create table:

CREATE TABLE upload (

id INT NOT NULL AUTO_INCREMENT,

userid INT NOT NULL,

name VARCHAR(30) NOT NULL,

type VARCHAR(30) NOT NULL,

size INT NOT NULL,

content MEDIUMBLOB NOT NULL,

PRIMARY KEY(id)

);

Insert this form into the clientsummary.tpl located at admin/templates/clientsummary.tpl:

<tr>

<a href="download.php?userid={$clientsdetails.userid}">view documents</a></td>

</tr>

<tr>

</td>

</tr>

</table>

</form>

then put the contents of this into a file named upload.php and put it into the admin directory.

<?php

include("../dbconnect.php");

include("../includes/functions.php");

$userID = addslashes($_POST['userid']);

if(!empty($_POST['upload']))

{

$fileName = $_FILES['userfile']['name'];

$tmpName = $_FILES['userfile']['tmp_name'];

$fileSize = $_FILES['userfile']['size'];

$fileType = $_FILES['userfile']['type'];

$fp = fopen($tmpName, 'r');

$content = fread($fp, $fileSize);

$content = addslashes($content);

fclose($fp);

if(!get_magic_quotes_gpc())

{

$fileName = addslashes($fileName);

}

$query = "INSERT INTO upload (userid, name, size, type, content ) ".

"VALUES ('$userID', '$fileName', '$fileSize', '$fileType', '$content')";

mysql_query($query) or die('Error, query failed');

echo "<br>File $fileName uploaded<br>";

echo "User ID: $userID <br />";

}

?>

The echo statements where a debugging tool I was using to make sure that the proper values where being sent to the db. I plan to take them out when everything is set the way I want them.

tomdchi · September 24, 2008

This has been solved and I have posted files here:

http://forum.whmcs.com/showthread.php?t=14398

if anyone needs this.

Sign In

Need help with client doc upload function

Recommended Posts

tomdchi

Link to comment

Share on other sites

tomdchi

Link to comment

Share on other sites

tomdchi

Link to comment

Share on other sites

Join the conversation

Recently Browsing 0 members

Browse

Latest Activity

Blog

Technical Support

Important Information