problem uploading files to databases

cs1h · September 4, 2007

Hi,

I am trying to upload photos to a mysql databse but with no luck. I'm not getting any error messages, the problem is that nothing appears in the database.

the form proccessor is as follows,

<?php

mysql_connect("localhost","adder","clifford");

mysql_select_db("real");

$data = addslashes(fread(fopen($form_data, "r"), filesize($form_data)));

$result=MYSQL_QUERY("INSERT INTO items (continent,country,type,Email,Title,Abstract,Article,data,filename,filesize,filetype) ". "VALUES ('menuSubjectsDMA','menuFilesDMA','Catagory','$Email','$title','$message','$messagetwo','$form_description','$data','$form_data_name','$form_data_size','$form_data_type')");

$id= mysql_insert_id();

print "File ID: $id ";

print "File Name: $form_data_name ";

print "File Size: $form_data_size ";

print "File Type: $form_data_type";

print "To upload another file <a href=http://www.myroho.com/add.html> Click Here</a>";

?>

the form is as follows,

<tr>

<tr>

</tr>

<tr>

Submit Articles to Roaming Hordes Magazine</td>

</tr>

<tr>

</tr>

<tr>

Adding to the members' magazine is easy. Simply fill

out the form below to submit an article (all fields are required to submit). </td>

</tr>

<tr>

</tr>

<tr>

<td bgcolor="#FFFFFF">1. Email:</td>

</label></td>

</tr>

<tr>

</tr>

<tr>

<td width="546" align="left" valign="top" bgcolor="#FFFFFF">2. Title:</td>

</tr>

<tr>

</td>

</tr>

<tr>

(20 character limit)</td>

i.e. catchy description of article's content</td>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

3.Abstract:

i.e. short overview and introduction to full article

(300 character limit)

</td>

characters left </td>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

<td align="left" valign="top" width="546" bgcolor="#FFFFFF">4. Article:

i.e. full article

(4000 character limit)

</td>

<input readonly type=text name=remLen2 size=4 maxlength=4 value="4000"> characters left </td>

</tr>

<tr>

</td>

</tr>

<tr>

>>

Save article to personal email account</a> >></td>

</tr>

<tr>

</tr>

<tr>

<td width="546" bgcolor="#FFFFFF">5. Location:</td>

<option value="none">Select a Continent

<option value="">Africa

<option value="">Asia

<option value="">Europe

<option value="">North America

<option value="">Oceania

<option value="">South America

</select>

<option value="none"> Choose Country

</select> </td>

</tr>

<tr>

</td>

</tr>

<tr>

(20 character limit)</td>

i.e.where and when did the events you have written about occur? </td>

</tr>

<tr>

</td>

</tr>

<tr>

<td bgcolor="#FFFFFF">6. Photos:</td>

</label></td>

</tr>

<tr>

</tr>

<tr>

</td>

</tr>

<tr>

7. Catagory:</td>

<option>Magazine</option>

<option>Review</option>

</select></td>

</tr>

<tr>

</td>

</tr>

<tr>

<a href="catagories.html">Choose the c</a><a href="catagories.html">atagory that best suits your article (if unsure click here)</a> </td>

</tr>

<tr>

</tr>

<tr>

</td>

</tr>

<tr>

8.

Submit:</td>

<td align="left" valign="top" width="546" height="20" bgcolor="#FFFFFF">By submitting you agree to the <a href="register.html">terms of use</a> and <a href="register.html">privacy policy</a>.</td>

</tr>

<tr>

</tr>

<tr>

</label></td>

</tr>

<tr>

</tr>

<tr>

Having problems with a submission? Email

info@mysite.com</a>.</td>

</tr>

<tr>

</tr>

</table>

</td>

</tr>

<tr>

</tr>

</table></form>

Any help is much appriciated,

Colin

Ninjakreborn · September 4, 2007

Don't "upload" files to a database. Upload them to a server, and put there path information in a database.

cs1h · September 4, 2007

Don't "upload" files to a database. Upload them to a server, and put there path information in a database.

Hi, thanks for the reply, i was just wondering if anyone can point me towards a script that could upload a file to a sever and write a path to a mysql database. The ones that I have tried in the past have not worked.

Thanks

Colin

Sign In

problem uploading files to databases

Recommended Posts

cs1h

Link to comment

Share on other sites

Ninjakreborn

Link to comment

Share on other sites

cs1h

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information