0

please any one help me i want display images from mysql database to my web page...
i have no clear idea about that please help me..
i want script that will upload file and also display files in date vise.
And also i want display my images like my attachment. the images have separate style number so that i want display that number also..
before that tell me how to upload my images with that style number.

Attachments shade.JPG 22.03 KB
4
Contributors
4
Replies
6
Views
7 Years
Discussion Span
Last Post by muralikalpana
0

You should have a form which allows user to upload a picture and enter it's code.
Your form should include a upload button and a text field for a code. Your script should take the code entered and the image name, generate the current date and put these three data parts in to the different table columns of your database. (A structure for a table might be: {id, image_name, image_code, upload_date})
Your script for showing images should do a reverse thing - take information from database (sorted according the upload date) and then display it in your page.
I hope it helps a little bit...

Edited by Daiva: n/a

0

Just store the uploaded area foler path with image name suffex with date and retrive accordingly...

0

put this in your bdy. and make changes according to your database tables

<form name="form2"  method="post"  action="" >

<table align="center" border="0" bordercolor="#000033" width="90%" height="100%"   >
<tr>
<?

$select1=mysql_query("select * from product order by auto_id desc ");
$i=0;
while($fetch=mysql_fetch_array($select1))
{ 
if( $i<4)
{
		
?>
<td><table width="161" border="0" cellspacing="0" cellpadding="0">
                      <tr>
                        <td width="1" bgcolor="#C5DEA1"></td>
                        <td width="159" height="158" valign="top" background="images/box1_midbg.gif"><table width="150" border="0" align="center" cellpadding="0" cellspacing="0">
                          <tr>
                            <td height="19" colspan="2" class="heading1"><img src="images/arrow3.gif" width="9" height="9" /> <?=$fetch[productname]?></td>
                            </tr>
                          <tr>
                            <td width="85" height="114"><img src="admin/productimage/<?=$fetch[productimage]?>" width="79" height="94" /></td>
                           
                            
                          </tr>
                          
                        </table></td>
                        <td width="1" bgcolor="#C5DEA1"></td>
						</tr></table>
						</td>
						<?
						$i++;
						
						}
						if($i==4)
						{
					    echo "<tr>";
					    $i=0;
						 }
						 
						 
}
 
?>
</tr>
 

</table>
</form>

Edited by muralikalpana: n/a

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.