Jump to content

Got The Database Code, Need Help With Upload Form


sumfight

Recommended Posts

Here is the code I have to show the pictures once they are uploaded

<?php

$host=""; // Host name

$username=""; // Mysql username

$password=""; // Mysql password

$db_name=""; // Database name

 

// Connect to server and select databse

mysql_connect("$host", "$username", "$password")or die("cannot connect to server");

mysql_select_db("$db_name")or die("cannot select DB");

 

$sql="SELECT * from images ORDER BY rand() LIMIT 1 "; // choose limit of pictues to be displayed

$result=mysql_query($sql);

?>

              <table width="95%" border="0" cellpadding="3" cellspacing="3" style="padding-top:5px">

                <tr>

<?php

$i=13; // always 1 more than limit

while($rows=mysql_fetch_array($result)){

$i = $i - 1;

    if($i % 2 == 0)

    {

?>

                </tr>

                <tr>

<?php

}

?>

                  <td align="center" valign="top"><table border="0" align="center" >

                      <tr>

                        <td align="center"><img src="<?php echo $rows['image']; ?>" alt="<?php echo $rows['name']; ?>" border="0"/></td>

                      </tr>

                      <tr>

                        <td align="center" valign="middle"><a href="<?php echo $rows['link']; ?>"><?php echo $rows['name']; ?></a></td>

                      </tr>

                  </table></td>

                  <td>

<?php

}

?>

                  </td>

                </tr>

              </table>

 

Now I want to know if someone can help me create a form so users can upload the picture to a folder and puts the path to the image in the database?

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.