Problem with joining table structure

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
genista
Forum Commoner
Posts: 57
Joined: Fri Aug 18, 2006 3:56 pm

Problem with joining table structure

Post by genista »

Weirdan | I took the liberty to re-format the code a bit. It was virtually impossible to see its structure the way it was posted


Hi,

I am slightly lost on this one. I have one table for suppliers, and at the moment it is storing everything - so the time has come to clean things up and add new tables. SO now I have a new table called supplierimages, the only thing it shares with suppliers is the supplierid. Now what I need to know is how to modify the code below to insert the supplierid into the supplierimages table if NULL and then from there to update the image1 field into supplierimages rather than suppliers. As you can see the first query is retrieving data from suppliers where there is a match with the sessionid (sessionid is the username, sessionid and pasword from the supliers table).

Script is work in progress so please ignore any other issues..

Code: Select all

<?php 
  session_start();
  include_once("../../private/supplierconfig.php"); 
  checkLoggedIn("yes");
  error_reporting (E_ALL); 

  // Retrieve details from database to start 

  $id = $_SESSION['username'];
  echo $id;
  $query = "select username, supplierid, image1 from suppliers where 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); 

  $username = $row['username'];
  $image1 = $row['image1'];

  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 = "
                    UPDATE `supplierimages` 
                    SET 
                           `image1` = '$image1', 
                           `username` = '$username' 
                    WHERE 
                           `username` = '" .  mysql_real_escape_string($_SESSION['username']) . "' 
                    LIMIT 1
             ";

             $result = mysql_query($query, $link) or die('Update failed: ' . mysql_error()); 
             echo $query; 
             // print_r($query);  
             mysql_info($link) ; 
             if(mysql_affected_rows($link) == 0);  

       } 
  } else { 
            echo "<br><br>"; 
          
  } 
 
  /*
  if( ( $image1 == 'NULL' ) || ($image1 =='' ) ) {
       // header("Location: uploadimage.php");
       echo "Please use the browse button below to locate an image file from your computer, press submit to upload it. This site accepts jpeg images only.";
  } else {
        // echo "<meta http-equiv='refresh' content='0;url=uploadimage.php'>";
  }
  */

?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN "http://www.w3.org/TR/html4/strict.dtd"> 
   <html lang="en"> 
    <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>&nbsp;</td><td><input name="submit" type="submit" value="Submit"></p> 
    </table> 
   </form>
Thanks,

G
Post Reply