1. Upload images to the server
<form method="post" enctype="multipart/form-data" action="adminup.php">
<table width="480" border="0" cellpadding="1" cellspacing="1" class="box">
<tr>
<td width=150 class=side>Name</td>
<td width="330" class=sidetitle>
<?
if($_GET['user']){
echo $_GET['user'];
echo '<input name="name" type="hidden" value="'.$_GET['user'].'">';
}
?>
</td>
</tr>
<tr>
<td width=150 class=side>Album title</td>
<td width="330" class=sidetitle>
<?
if($_GET['albumname']){
echo $_GET['albumname'];
echo '<input name="album" type="hidden" value="'.$_GET['albumname'].'">';
}
?>
</td>
</tr>
<tr>
<td width="480" colspan=2>
<?
if($_GET['id']){
echo '<input name="index" type="hidden" value="'.$_GET['id'].'">';
}
?>
</td>
</tr>
<tr>
<td width=150 class=side>Picture 1</td>
<td width="330" class=sidetitle>
<input type="hidden" name="MAX_FILE_SIZE" value="2000000">
<input name="userfile1" type="file" id="userfile1">
</td>
</tr>
<tr>
<td width=150 class=side>Picture 2</td>
<td width="330" class=sidetitle>
<input type="hidden" name="MAX_FILE_SIZE" value="2000000">
<input name="userfile2" type="file" id="userfile2">
</td>
</tr>
<tr>
<td width=150 class=side>Picture 3</td>
<td width="330" class=sidetitle>
<input type="hidden" name="MAX_FILE_SIZE" value="2000000">
<input name="userfile3" type="file" id="userfile3">
</td>
</tr>
<tr>
<td width=150 class=side>Picture 4</td>
<td width="330" class=sidetitle>
<input type="hidden" name="MAX_FILE_SIZE" value="2000000">
<input name="userfile4" type="file" id="userfile4">
</td>
</tr>
<tr>
<td width=150 class=side>Picture 5</td>
<td width="330" class=sidetitle>
<input type="hidden" name="MAX_FILE_SIZE" value="2000000">
<input name="userfile5" type="file" id="userfile5">
</td>
</tr>
<tr>
<td width=150 class=side>Picture 6</td>
<td width="330" class=sidetitle>
<input type="hidden" name="MAX_FILE_SIZE" value="2000000">
<input name="userfile6" type="file" id="userfile1">
</td>
</tr>
<tr>
<td width=150 class=side>Picture 7</td>
<td width="330" class=sidetitle>
<input type="hidden" name="MAX_FILE_SIZE" value="2000000">
<input name="userfile7" type="file" id="userfile2">
</td>
</tr>
<tr>
<td width=150 class=side>Picture 8</td>
<td width="330" class=sidetitle>
<input type="hidden" name="MAX_FILE_SIZE" value="2000000">
<input name="userfile8" type="file" id="userfile3">
</td>
</tr>
<tr>
<td width=150 class=side>Picture 9</td>
<td width="330" class=sidetitle>
<input type="hidden" name="MAX_FILE_SIZE" value="2000000">
<input name="userfile9" type="file" id="userfile4">
</td>
</tr>
<tr>
<td width=150 class=side>Picture 10</td>
<td width="330" class=sidetitle>
<input type="hidden" name="MAX_FILE_SIZE" value="2000000">
<input name="userfile10" type="file" id="userfile5">
</td>
</tr>
<tr>
<td width="480" class=sidetitle colspan=2><input name="upload" type="submit" class="box" id="upload" value=" Upload "></td>
</tr>
</table>
</form>
2.when the users click the submit button, it will call adminup.php which is shown below.
adminup.php
<?php
$album=$_POST['album'];
$name=$_POST['name'];
$album_num=$_POST['index'];
$db_conn=mysql_connect("your server", "your id", "your pwd");
mysql_select_db("your database");
//看看這本相簿有多少張相片
$query = "select * from upload where album_num=$album_num";
$result=mysql_query($query);
$how_many_pic=mysql_num_rows($result);
for($i=1;$i<=10;$i++){
$temp="userfile".$i;
if(isset($_POST['upload']) && $_FILES[$temp]['size'] > 0)
{
$fileName = $_FILES[$temp]['name'];
$tmpName = $_FILES[$temp]['tmp_name'];
$fileSize = $_FILES[$temp]['size'];
$fileType = $_FILES[$temp]['type'];
$fp = fopen($tmpName, 'r');
$content = fread($fp, filesize($tmpName));
$content = addslashes($content);
fclose($fp);
$margin = getimagesize($tmpName);
$width=$margin[0];
$height=$margin[1];
if(!get_magic_quotes_gpc())
{
$fileName = addslashes($fileName);
}
$how_many_pic++;
//Insert the picture into the database. And the table
//to store the pictures is called 'upload'
$query = "INSERT INTO upload (name, size, type, content, album_name, album_num, pic_num, author, width, height ) ".
"VALUES ('$fileName', '$fileSize', '$fileType', '$content', '$album', '$album_num', '$how_many_pic', '$name' , '$width', '$height')";
mysql_query($query) or die('Error, query failed');
}
}
echo '<meta http-equiv=refresh content=0;url="adminpic.php?id='.$album_num.'&user='.$name.'&page=1">';
exit;
?>
How to show the pictures we upload will be introduced next time.
