Not posting to MySQL database...

Codewalkers Forums Sponsor:

May 28th, 2003, 08:47 PM

Bard09

Join Date: Apr 2007

Posts: 18

Time spent in forums: < 1 sec
Reputation Power: 0

Not posting to MySQL database...

Hum. I've been messing around with my data submitting code trying implement an image upload, and now I've done tangled up my code. The form loads up, and I recieve my Echo stating that I've posted the form data with the image to the database, but nothing is actually posted. I'm pretty sure the problem is in my PHP code somewhere. Can anyone help me out? Keep in mind I'm still relatively new at all of this! Thanks...

(I've edited my posted code a few times. It's just the image submitting I'm having trouble with, now)

php Code:

Original - php Code

<?php 
if(isset($_POST['submit']))
{ 
$db = mysql_connect(xxxxxxxxxxxxxx) OR DIE (mysql_error());
mysql_select_db("Honor_Bios",$db) OR DIE (mysql_error());

$first_name=$_POST[first_name];
$last_name=$_POST[last_name];
$hometown=$_POST[hometown];
$age=$_POST[age];
$major=$_POST[major];
$anything=$_POST[anything];
$id=$_POST[id];

$image_types = Array ("image/bmp",
                        "image/jpeg",
                        "image/pjpeg",
                        "image/gif",
                        "image/x-png");

$userfile  = addslashes (fread (fopen ($_FILES["userfile"]["tmp_name"], "r"), filesize ($_FILES["userfile"]["tmp_name"])));
  $file_name = $_FILES["userfile"]["name"];
  $file_size = $_FILES["userfile"]["size"];
  $file_type = $_FILES["userfile"]["type"];

if (in_array (strtolower ($file_type), $image_types)) {
    $sql = "INSERT INTO Freshmen (first_name,last_name,hometown,age,major,anything,  image_name,image_type,image_size,image_date) ";
    $sql.= "VALUES (";
    $sql.= "'{$first_name}', '{$last_name}', '{$hometown}', '{$age}', '{$major}', '{$anything}', '{$file_type}', '{$userfile}', '{$file_size}', '{$file_name}', NOW())";
    @mysql_query ($sql, $db);
    Header("Location:".$_SERVER["PHP_SELF"]);
	echo "Thank you! Information entered with picture.n"; 
    exit();
} 
else
{
$db = mysql_connect(xxxxxxxxxxxxxxxxxxxx);
mysql_select_db("Honor_Bios",$db);
$sql = "INSERT INTO Freshmen (first_name,last_name,hometown,age,major,anything)   VALUES ('$first_name', '$last_name', '$hometown', '$age', '$major', '$anything')";
$result = mysql_query($sql);
echo "Thank you! Information entered without picture.n";
}
}
else
{
?>
<form method="post" action="<?php echo $PHP_SELF?>" enctype="multipart/form-data">
First name:<input type="Text" name="first_name"><br> 
Last name:<input type="Text" name="last_name"><br> 
Hometown:<input type="Text" name="hometown"><br> 
Age:<input type="Text" name="age"><br> 
Major:<input type="Text" name="major"><br>
Anything? <input type="Text" name="anything"><br>
Image of yourself II <input type="file" name="userfile"  size="40"><br>
<input type="Submit" name="submit" value=" Enter information"></form> 
<?php 
} 
?>

<?php 
if(isset($_POST['submit']))
{ 
$db = mysql_connect(xxxxxxxxxxxxxx) OR DIE (mysql_error());
mysql_select_db("Honor_Bios",$db) OR DIE (mysql_error());
 
$first_name=$_POST[first_name];
$last_name=$_POST[last_name];
$hometown=$_POST[hometown];
$age=$_POST[age];
$major=$_POST[major];
$anything=$_POST[anything];
$id=$_POST[id];
 
$image_types = Array ("image/bmp",
                        "image/jpeg",
                        "image/pjpeg",
                        "image/gif",
                        "image/x-png");
 
  $userfile  = addslashes (fread (fopen ($_FILES["userfile"]["tmp_name"], "r"), filesize ($_FILES["userfile"]["tmp_name"])));
  $file_name = $_FILES["userfile"]["name"];
  $file_size = $_FILES["userfile"]["size"];
  $file_type = $_FILES["userfile"]["type"];
 
  if (in_array (strtolower ($file_type), $image_types)) {
    $sql = "INSERT INTO Freshmen (first_name,last_name,hometown,age,major,anything,  image_name,image_type,image_size,image_date) ";
    $sql.= "VALUES (";
    $sql.= "'{$first_name}', '{$last_name}', '{$hometown}', '{$age}', '{$major}', '{$anything}', '{$file_type}', '{$userfile}', '{$file_size}', '{$file_name}', NOW())";
    @mysql_query ($sql, $db);
    Header("Location:".$_SERVER["PHP_SELF"]);
    echo "Thank you! Information entered with picture.n"; 
    exit();
} 
else
{
$db = mysql_connect(xxxxxxxxxxxxxxxxxxxx);
mysql_select_db("Honor_Bios",$db);
$sql = "INSERT INTO Freshmen (first_name,last_name,hometown,age,major,anything)   VALUES ('$first_name', '$last_name', '$hometown', '$age', '$major', '$anything')";
$result = mysql_query($sql);
echo "Thank you! Information entered without picture.n";
}
}
else
{
?>
<form method="post" action="<?php echo $PHP_SELF?>" enctype="multipart/form-data">
First name:<input type="Text" name="first_name"><br> 
Last name:<input type="Text" name="last_name"><br> 
Hometown:<input type="Text" name="hometown"><br> 
Age:<input type="Text" name="age"><br> 
Major:<input type="Text" name="major"><br>
Anything? <input type="Text" name="anything"><br>
Image of yourself II <input type="file" name="userfile"  size="40"><br>
<input type="Submit" name="submit" value=" Enter information"></form> 
<?php 
} 
?>

Thanks again...

Signed,

Weary in Washington!

May 30th, 2003, 07:30 PM

opus006

Join Date: Apr 2007

Posts: 65

Time spent in forums: < 1 sec
Reputation Power: 2

RE: Not posting to MySQL database...

echo your $sql line to make sure it is correct
echo $sql;
$result = myslq_query($sql);
if ($result)
echo mysql_affedted_rows()." added correctly";

Do you use datatype Blob for $userfile?

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: