I'm wondering if there is a way to store an image in MySQL or if I have to put it somewhere that would be fine too. Here's what my code looks like:
<?php
print "<html><head><title>StockNet</title></head><body bgcolor=\"#FFFFFF\">";
print "<center><form><table width=\"400\"><tr><td colspan=\"2\"><center><b>Add an Image to StockNet</b></center></td></tr>";
print "<tr><td width=\"50%\">Description:</td><td width=\"50%\"><input type=\"text\" name=\"description\" size=\"25\"></td></tr>";
print "<tr><td width=\"50%\">Department:</td><td width=\"50%\"></td></tr>";
// Department List Here
// Height Variant on # of Options
// Allows more of a breakdown for multiple categories
print "<tr><td width=\"50%\">Global:</td><td width=\"50%\"></td></tr>";
print "<tr><td width=\"50%\">Location of File:</td><td width=\"50%\"><input type=\"file\" name=\"image\" size=\"25\"></td></tr>";
print "</table></body></html>";
?>
What I'm trying to do is consolidate our images into something I'm calling StockNet. Our intranet name is SpiderNet (Don't ask me, I didn't name it).
What I'm wanting to do totally is I have a database with the following structure:
description, url, blog_id, global
Totally what I would like it to do is blog_id and category_id really control our site's layout. When we add a division to our company we going and ad a category_id with the key blog_id. Blog_id of course is our Divisions. Fortunantly our divisions are color coded internally (You can see a sample at:
You say with the description of the image is (alt), what division it goes under (we have 6 divisions all within a database (code to be added in a bit) and an option whether it is "global" meaning on the right hand side we have a "non color coded" image for our applications and external links.
My question really is can a PHP page be written so that the image is stored in MySQL (url) or do I have to actually "upload it" somewhere? It'd be a lot easier if it was in MySQL IMHO.
Digatle
<?php
print "<html><head><title>StockNet</title></head><body bgcolor=\"#FFFFFF\">";
print "<center><form><table width=\"400\"><tr><td colspan=\"2\"><center><b>Add an Image to StockNet</b></center></td></tr>";
print "<tr><td width=\"50%\">Description:</td><td width=\"50%\"><input type=\"text\" name=\"description\" size=\"25\"></td></tr>";
print "<tr><td width=\"50%\">Department:</td><td width=\"50%\"></td></tr>";
// Department List Here
// Height Variant on # of Options
// Allows more of a breakdown for multiple categories
print "<tr><td width=\"50%\">Global:</td><td width=\"50%\"></td></tr>";
print "<tr><td width=\"50%\">Location of File:</td><td width=\"50%\"><input type=\"file\" name=\"image\" size=\"25\"></td></tr>";
print "</table></body></html>";
?>
What I'm trying to do is consolidate our images into something I'm calling StockNet. Our intranet name is SpiderNet (Don't ask me, I didn't name it).
What I'm wanting to do totally is I have a database with the following structure:
description, url, blog_id, global
Totally what I would like it to do is blog_id and category_id really control our site's layout. When we add a division to our company we going and ad a category_id with the key blog_id. Blog_id of course is our Divisions. Fortunantly our divisions are color coded internally (You can see a sample at:
You say with the description of the image is (alt), what division it goes under (we have 6 divisions all within a database (code to be added in a bit) and an option whether it is "global" meaning on the right hand side we have a "non color coded" image for our applications and external links.
My question really is can a PHP page be written so that the image is stored in MySQL (url) or do I have to actually "upload it" somewhere? It'd be a lot easier if it was in MySQL IMHO.
Digatle