Please excuse the script below its work in progress and I have a path to follow to get it complete. However, in early testing I find that in Firefox the complete script works, in IE when I hit the submit button, nothing happens. What it should do is run an insert query as you can see. Instead the page returns the query hasn't run, it hasn't updated the database:
<?php
session_start();
include_once ("../../private/supplierconfig.php");
checkLoggedIn("yes");
error_reporting (E_ALL);
//Retrieve details from database to start (image1 also part of suppliers table - need to have this only )
$id = $_SESSION['username'];
echo $id;
$query = "SELECT suppliers.supplierid, suppliers.username
FROM suppliers
LEFT JOIN supplierimages USING (supplierid) WHERE suppliers.username = '$id'";
$result=mysql_query($query, $link) or die("MySQL query $query failed. Error if any: ".mysql_error());
echo $query;
//get the first (and only) row from the result
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$supplierid = $row['supplierid'];
echo $supplierid;
if(isset( $submit ))
{
//If the Submitbutton was pressed do:
if ($_FILES['imagefile']['type'] == "image/jpeg"){
$_FILES['imagefile']['name'] = basename($_FILES['imagefile']['name']);
copy ($_FILES['imagefile']['tmp_name'], "files/".$username.$_FILES['imagefile']['name'])
or die ("Could not copy");
echo "";
echo "Name: ".$_FILES['imagefile']['name']."";
echo "Size: ".$_FILES['imagefile']['size']."";
echo "Type: ".$_FILES['imagefile']['type']."";
echo "Upload Complete....";
$image1 = $username.$_FILES['imagefile'] ['name'];
echo "$image1";
$query = "INSERT INTO
supplierimages (image1, supplierid)
VALUES ('$image1','$supplierid')";
$result = mysql_query($query, $link) or die('Update failed: ' . mysql_error());
echo $query;
echo $id;
//print_r($query);
mysql_info($link) ;
if(mysql_affected_rows($link) == 0);
}
}
else {
echo "<br><br>";
}
?>
</script>
</HEAD>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<form name="form1" method="post" action="#" enctype="multipart/form-data">
<input type=text name="username" value="<?php echo $username; ?>">
<input type="file" name="imagefile">
<p>*</td><td><input name="submit" type="submit" value="Submit"></p>
</table>
</form>
Thanks,
G