Search found 22 matches

by NikBruce
Wed Jan 13, 2010 3:20 am
Forum: Databases
Topic: files downloaded from DB are corrupt
Replies: 3
Views: 767

Re: files downloaded from DB are corrupt

solution:

the variables from the upload script were on a separate page to the rest of the upload script, and then passed along using a session. It will not work this way. they must be on the same page.
by NikBruce
Mon Jan 11, 2010 4:51 pm
Forum: Databases
Topic: files downloaded from DB are corrupt
Replies: 3
Views: 767

Re: files downloaded from DB are corrupt

hahahahaha my bad. This is the upload code: $name = $_FILES['fileUpload']['name']; $name = str_replace(" ","_", $name);   $mime = $_FILES['fileUpload']['type'];   $data = file_get_contents($_FILES  ['fileUpload']['tmp_name']);   $size = intval($_FILES['fileUpload']['size']);   $t...
by NikBruce
Mon Jan 11, 2010 6:42 am
Forum: Databases
Topic: files downloaded from DB are corrupt
Replies: 3
Views: 767

files downloaded from DB are corrupt

Hi, when ever I download blobs from my DB I can't open them. I get I warning telling me that the files are either corrupt, damaged, truncated, or incomplete. I can open txt and mp3 files. I did open the damaged image files in photoshop, but I can only partially view them. So they are indeed damaged....
by NikBruce
Sat Jan 09, 2010 4:29 am
Forum: Databases
Topic: Problem downloading BLOB image
Replies: 3
Views: 593

Re: Problem downloading BLOB image

and I have this problem no matter what browser I use.
by NikBruce
Sat Jan 09, 2010 4:25 am
Forum: Databases
Topic: Problem downloading BLOB image
Replies: 3
Views: 593

Re: Problem downloading BLOB image

by the way, this is the script that i'm using, <?php   if(!is_numeric($id)) { die("Invalid id specified"); }   $sql = "SELECT `mime`, `data`, `size`, `name` FROM `$proName` WHERE `id` = '$id'";   $result = mysql_query($sql) or die(mysql_error());   $count = mysql_num_rows($result...
by NikBruce
Sat Jan 09, 2010 4:12 am
Forum: Databases
Topic: Problem downloading BLOB image
Replies: 3
Views: 593

Re: Problem downloading BLOB image

I've got the same problem now.

I've tried downloading swf, ai, pdf, jpg, png and mp3 files. Only the mp3 files works.

This is quite an old post, does no one have a solution?
by NikBruce
Fri Jan 08, 2010 2:07 pm
Forum: Databases
Topic: will insert to table, but can't select (login system)
Replies: 13
Views: 13671

Re: will insert to table, but can't select (login system)

found the problem. the word field was a Varchar with a length of 17....
that's not really long enough for a password that's been md5'd.

my bad

Thanks for all you help
by NikBruce
Fri Jan 08, 2010 1:30 pm
Forum: Databases
Topic: will insert to table, but can't select (login system)
Replies: 13
Views: 13671

Re: will insert to table, but can't select (login system)

just to clarify my last post, when i said as shown below i was referring to the variables after the "WHERE" clause in line 1.
by NikBruce
Thu Jan 07, 2010 6:17 am
Forum: Databases
Topic: will insert to table, but can't select (login system)
Replies: 13
Views: 13671

Re: will insert to table, but can't select (login system)

when i use single quotes instead of back ticks as shown below, $sql = "SELECT `email`, `word` FROM `accTable` WHERE `email` = '$email' AND `word` = '$password'";   $result = mysql_query($sql) or die(mysql_error());   $count = mysql_num_rows($result);   if($count == 1) {   while($row = mysq...
by NikBruce
Thu Jan 07, 2010 5:48 am
Forum: Databases
Topic: will insert to table, but can't select (login system)
Replies: 13
Views: 13671

Re: will insert to table, but can't select (login system)

nothing, it assumes the variables to be 'email' and 'password' anyway.
by NikBruce
Thu Jan 07, 2010 5:37 am
Forum: Databases
Topic: will insert to table, but can't select (login system)
Replies: 13
Views: 13671

Re: will insert to table, but can't select (login system)

<form name="form1" method="post" action="accLogin.php">           <div align="right">email address:             <input type="text" name="email" id="email">             personal password:             <input type="password&quo...
by NikBruce
Thu Jan 07, 2010 4:59 am
Forum: Databases
Topic: will insert to table, but can't select (login system)
Replies: 13
Views: 13671

Re: will insert to table, but can't select (login system)

that's a fair statement.

but no, the error stays the same.
by NikBruce
Thu Jan 07, 2010 4:15 am
Forum: Databases
Topic: will insert to table, but can't select (login system)
Replies: 13
Views: 13671

Re: will insert to table, but can't select (login system)

that is the full error, and the variables are posted from a form.
by NikBruce
Thu Jan 07, 2010 3:33 am
Forum: Databases
Topic: will insert to table, but can't select (login system)
Replies: 13
Views: 13671

will insert to table, but can't select (login system)

i'm having trouble with my login system. users create an account like so: $ti = "INSERT INTO accTable (name, nameU, profession, company, site, email, word, country) VALUES ('$accNameSafe', '$accNameUSafe', '$accProfessionSafe', '$accCompanySafe', '$accSiteSafe', '$accEmailSafe', '$accPassSafe',...
by NikBruce
Fri Jan 01, 2010 12:57 am
Forum: Databases
Topic: Inserting a blob
Replies: 8
Views: 940

Re: Inserting a blob

the problem was that i hadn't run the variables through a real_escape_string.

Thanks for all your help.