PHP Forum

**Exbrief** · 01-25-2009, 12:09 AM

ok, I have a script that allows a user to input information into an html form which submits that info to a php script which then puts that info into my mySQL database.

Currently it only allows the fields of: last name, first name,city, state, country, gender

I want to all ow the upload of images as well, one which will be displayed in the search results, i.e. Myspace when you search for people.

Also, how exactly should I set up the field in my database to allow this?

Here is the script:

HTML PART

Code:

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html; charset=ISO-8859-1"
 http-equiv="content-type">
  <title></title>
</head>
<body>
<form action="http://ex-brief.com/insert/" method="post">
<table style="text-align: left; width: 70%;" border="0"
 cellpadding="0" cellspacing="5">
  <tbody>
    <tr>
      <td>First Name:</td><td><input
 tabindex="1" name="first"></td>
      <td>City</td><td><input tabindex="3" name="city"><br>
      </td>
    </tr>
    <tr>
      <td>Last Name:</td><td><input
 tabindex="2" name="last"></td>
      <td>State/Province:</td><td>
      <select name="state">
      <option>IL</option>
      </select>
      </td>
    </tr>
    <tr>
      <td>Gender:</td><td><input name="gender"
 value="Male" type="radio">Male&nbsp;&nbsp;
&nbsp;&nbsp;<input name="gender" value="Female"
 type="radio">Female</td>
      <td>Country:
</td><td>
      <select name="country">
      <option>IL</option>
      </select>
      </td>
    </tr>
    <tr>
      <td><input name="searching" value="yes"
 type="hidden">
      </td>
      <td></td>
    </tr>
  </tbody>
</table><P><input type="submit"></P>
</form>
</body>
</html>

PHP PART

Code:

<?php


$first=$_POST['first'];
$last=$_POST['last'];
$city=$_POST['city'];
$state=$_POST['state'];
$country=$_POST['country'];
$gender=$_POST['gender'];


mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$query = "INSERT INTO contacts VALUES ('','$first','$last','$city','$state','$country','$gender')";
mysql_query($query);

if($query) {
echo "You have successfully created an ExBrief!";
} else {
echo "Your Ex Brief was not created.  Please review the information you entered for accuracy.";
}

mysql_close();


?>

thanks!

**stoot98** · 01-25-2009, 10:20 AM

There are lots of arguments for and against storing files in databases, personally I would just upload the file to the file system and then store the path to the image in the table.

If you want to go down the other path you can store it as a BLOB type.

**colbyt** · 01-25-2009, 11:32 AM

I agree 100% with what stoot98 said above. I always store the link to the image in the DB.

Also be sure to use some form of renaming to insure each has a unique name.

**Exbrief** · 01-25-2009, 03:48 PM

i understand all that. I need to know how to do it exactly. People will be uploading the pics when they create profiles, I will not be uploading them. My scripts already allow them to upload information, but no images. Anyone know a good way to do this?

**Decaf** · 01-25-2009, 05:37 PM

I love google: Image Databasing

**Exbrief** · 01-25-2009, 05:49 PM

thanks, but that has me starting from scratch....I just want to add the image upload to an EXISTING form which I already have created and posted above!

**Decaf** · 01-25-2009, 05:58 PM

Quote:

Originally Posted by Exbrief

thanks, but that has me starting from scratch....I just want to add the image upload to an EXISTING form which I already have created and posted above!

I'm pretty sure that you can read that guide and copy/implement the same ideas into your own code, I doubt that people will have made code that fits your form exactly.

**anderswc** · 01-25-2009, 09:30 PM

You're not going to find someone who has the same code as what you already have, but simply added the image upload. That's an unreasonable expectation.

You're going to have to do the integration to your current form yourself, unless you find someone who you can pay to do it.

**Exbrief** · 01-25-2009, 10:38 PM

i know nobody has my exact script....except for those who are reading my original post above. I guess I will figure out how to add the image upload to this script. thanks.