question on table linking and picture upload

[franklos]

Hi,

 

two questions

 

First I have two tables one containing composers and one their publsher details. The site owner now would like to have the option (will it ever stop) to be able to click from the composer details "publisher name" (field:publisher) to the publisher details(through field:abbreviation) from the second table.Also it would be great to get a dropdown list of the available publishers in the composer modification / add new form. (is that a total of three qustions?)

 

Second I would like the option to upload an image of the composer with the URL stored in that table. So we can retrieve that picture if we view the composer details.

 

For the first I found some stuff, related to foreign key etc, but can, t see how to create a foreign key.

FOr thye second I have found an upload script but don' t see how to couple that with the ID of that composer.

 

Thanks, Frank.

 

 

Here s the tables

 

Composers:

 

idcomp  int(10) No      
Composer  varchar(255) Yes  NULL    
Birth  varchar(255) Yes  NULL    
Nationality  varchar(255) Yes  NULL    
Opus  varchar(255) Yes  NULL    
Publisher  varchar(255) Yes  NULL    
Oddities  varchar(255) Yes  NULL    
fname  varchar(255) Yes  NULL    
lname  varchar(255) Yes  NULL    


Indexes: Keyname Type Cardinality Field 
PRIMARY  PRIMARY 947   idcomp 

 

Publishers:

 

idpub  int(11) No      
abbreviation  varchar(30) Yes  NULL    
country  varchar(255) Yes  NULL    
street  varchar(255) Yes  NULL    
postcode  varchar(255) Yes  NULL    
city  varchar(255) Yes  NULL    
address  varchar(255) Yes  NULL    
name  varchar(255) Yes  NULL    
website  varchar(255) Yes  NULL    
email  varchar(255) Yes  NULL    
oddities  varchar(255) Yes  NULL    
phone  text Yes  NULL    


Indexes: Keyname Type Cardinality Field 
PRIMARY  PRIMARY 121   idpub  
abbreviation  INDEX 121   abbreviation 

 

 

 

And the picture upload script:

 

<?php
//start image uploader 
//define a maxim size for the uploaded images in Kb
define ("MAX_SIZE","100"); 

//This function reads the extension of the file. It is used to determine if the file is an image by checking the extension. 
function getExtension($str) {
$i = strrpos($str,".");
if (!$i) { return ""; }
$l = strlen($str) - $i;
$ext = substr($str,$i+1,$l);
return $ext;
}

//This variable is used as a flag. The value is initialized with 0 (meaning no error found) and it will be changed to 1 if an errro occures. If the error occures the file will not be uploaded.
$errors=0;
//checks if the form has been submitted
if(isset($_POST['Submit'])) 
{
//reads the name of the file the user submitted for uploading
$image=$_FILES['image']['name'];
//if it is not empty
if ($image) 
{
//get the original name of the file from the clients machine
$filename = stripslashes($_FILES['image']['name']);
//get the extension of the file in a lower case format
$extension = getExtension($filename);
$extension = strtolower($extension);
//if it is not a known extension, we will suppose it is an error and will not upload the file, otherwize we will do more tests
if (($extension != "jpg") && ($extension != "jpeg") && ($extension != "png") && ($extension != "gif")) 
{
//print error message
echo '<h1>Unknown extension!</h1>';
$errors=1;
}
else
{
//get the size of the image in bytes
//$_FILES['image']['tmp_name'] is the temporary filename of the file in which the uploaded file was stored on the server
$size=filesize($_FILES['image']['tmp_name']);

//compare the size with the maxim size we defined and print error if bigger
if ($size > MAX_SIZE*1024)
{
echo '<h1>You have exceeded the size limit!</h1>';
$errors=1;
}

//we will give an unique name, for example the time in unix time format
$image_name=time().'.'.$extension;
//the new name will be containing the full path where will be stored (images folder)
$newname="images/".$image_name;
//we verify if the image has been uploaded, and print error instead
$copied = copy($_FILES['image']['tmp_name'], $newname);
if (!$copied) 
{
echo '<h1>Copy unsuccessfull!</h1>';
$errors=1;
}}}}

//If no errors registred, print the success message
if(isset($_POST['Submit']) && !$errors) 
{
echo "<h1>File Uploaded Successfully! Try again!</h1>";
}

?>

<!--next comes the form, you must set the enctype to "multipart/frm-data" and use an input type "file" --> 
<form name="newad" method="post" enctype="multipart/form-data" action="">
<table>
<tr><td><input type="file" name="image"></td></tr>
<tr><td><input name="Submit" type="submit" value="Upload image"></td></tr>
</table> 

//end image uploader