Viewing file:  upload_client.php (3.45 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?
/*
this script takes the form data collected from the new client
or modify client form and inserts it into the database
*/
include ("../include/settings");
include ("../include/db_connect");
//DELETE?
if ($delete == "yes")
{
$query = "DELETE from client WHERE ID = '$ID'";
}
else
{
// DO THIS IF IT IS A NEW RECORD
if (!$ID)
{
$new_row = mysql_query("INSERT INTO client (ID)
values (NULL)", $db);
//Get auto-increment ID value
$ID_data = mysql_query("SELECT LAST_INSERT_ID()", $db);
$ID = mysql_result($ID_data, 0, 'last_insert_ID()');
}
// Prepare query
$query = "UPDATE client SET title = '$title'";
if ($do_this != "modify") $query .= ", client = '$mclient'";
$query .= ", text = '$text'";
if ($picture1 != "none")
{
//make a unique image name based on reference name
$picture1_reference = "picture1_$ID.jpg";
//transfer file
if(copy($picture1, "../client_pics/$picture1_reference"))
{
$query .= ", picture1 = '$picture1_reference'";
}
else
{
print("error transferring picture number 1<br>\n");
}
}
if ($picture2 != "none")
{
//make a unique image name based on reference name
$picture2_reference = "picture2_$ID.jpg";
//transfer file
if(copy($picture2, "../client_pics/$picture2_reference"))
{
$query .= ", picture2 = '$picture2_reference'";
}
else
{
print("error transferring picture number 2<br>\n");
}
}
if ($picture3 != "none")
{
//make a unique image name based on reference name
$picture3_reference = "picture3_$ID.jpg";
//transfer file
if(copy($picture3, "../client_pics/$picture3_reference"))
{
$query .= ", picture3 = '$picture3_reference'";
}
else
{
print("error transferring picture number 3<br>\n");
}
}
if ($picture4 != "none")
{
//make a unique image name based on reference name
$picture4_reference = "picture4_$ID.jpg";
//transfer file
if(copy($picture4, "../client_pics/$picture4_reference"))
{
$query .= ", picture4 = '$picture4_reference'";
}
else
{
print("error transferring picture number 4<br>\n");
}
}
if ($picture5 != "none")
{
//make a unique image name based on reference name
$picture5_reference = "picture5_$ID.jpg";
//transfer file
if(copy($picture5, "../client_pics/$picture5_reference"))
{
$query .= ", picture5 = '$picture5_reference'";
}
else
{
print("error transferring picture number 5<br>\n");
}
}
if ($picture6 != "none")
{
//make a unique image name based on reference name
$picture6_reference = "picture6_$ID.jpg";
//transfer file
if(copy($picture6, "../client_pics/$picture6_reference"))
{
$query .= ", picture6 = '$picture6_reference'";
}
else
{
print("error transferring picture number 6<br>\n");
}
}
$query .= "WHERE ID = '$ID'";
} // end of else
$transfer = mysql_query($query, $db);
if ($transfer){
print("<p align=\"center\"><br><br><b>Upload successful!</b><br><br>\n");
include ("index.php");
}
else print("<p align=\"center\"><br><br><b>OOPS, something went wrong. Try it again.</b><br>If you still have problems, please notify Dan Psomas Web Design<br>by <a href=\"mailto:dan@danpsomas.com?subject=Problems uploading\">e-mail</a> or phone: (510) 865-0273<br>\n<a href=\"index.php\">Go back to admin menu</a>");
?>
|