I need to add filename and path to mysql table

I am new to php. I tried the easy upload got the files uploaded to default folder. Actually my placement (Jobfinder) site where candidates can register their details in a mysql table (table also has a resume column) and upload their resume *.doc files. I want the name and full path of the resume file be stored in resume column of mysql table.

Can you please help me with an example file where visitor types his username in a text box and then uploads the file. After pressing the submit button files is uploaded and username and path of file is stored in a mysql table. (Say table has three columns, 1) ID, 2) Username 3) Full Path with file name.

This will hwlp me know which resume belongs to which candidate.

Regards,
Imran

[Join us @ facebook]

No offense Imran, but are you looking to learn how to do that, or you want someone to do it for you?

I am asking because in the second case you should have to post here

the "upload_db_example.php" has exactly this function.

If you have problems with changing this code that it works within your application than you should follow Nick's advice...

I am new to PHP. I am learning while developing sites for my clients.
I am located in India and engaged in providing computer education.
If required I can post on other optional forum too.

I am using the following code to insert

$insert = "INSERT INTO employee (employeeusername, employeepassword, resume, employeename, address, city, pincode, state, country, email, website, telephone, mobile, fax, professionaltitle, dateofbirth, status)
VALUES ('".$_POST['employeeusername']."', '".$_POST['employeepass']."', '".basename($name)."', '".$_POST['employeename']."', '".$_POST['address']."', '".$_POST['city']."', '".$_POST['pincode']."', '".$_POST['state']."', '".$_POST['country']."', '".$_POST['email']."', '".$_POST['website']."', '".$_POST['telephone']."', '".$_POST['mobile']."', '".$_POST['fax']."', '".$_POST['ptitle']."', '".$_POST['birthday']."', '".$_POST['status']."')";
$add_member = mysql_query($insert);

This code I am using in upload_class.php

check the example there is the answer...

O.K. I'll start again from begining to understand the example.

Thank you.

Hey I got it its $fullpath to be used there.

Thanks any way.

 

[Guest]

[62.883]

Googlebot