ช่วยดูโค๊คให้หน่อยค่ะ ทำไมถึงไม่ส่งค่า album_id ไปเพื่ออัพโหลดเข้าฐานข้อมูล
Code (upload) <form name="F1" action="../js/uploadify.php" method="post" enctype="multipart/form-data">
<script type="text/javascript" src="../js/jquery-1.3.2.min.js"></script>
<script type="text/javascript" src="../js/jquery.uploadify.js"></script>
<script type="text/javascript">
$(document).ready(function() {
$("#fileUpload2").fileUpload({
'uploader' : '../uploadify/uploader.swf',
'cancelImg' : '../uploadify/cancel.png',
'script' : '../js/uploadify.php',
'folder' : '../MyResize/',
'multi' : true,
'buttonText' : 'Browse..',
'checkScript' : '../uploadify/check.php',
'displayData' : 'speed',
'simUploadLimit': 2
});
});
</script>
<table width="574" border="0" align="center" cellpadding="1" cellspacing="1" class="FontThai">
<tr>
<td colspan="2" bgcolor="#0099FF"><center><font color="#ffffff">เพิ่มรูปกิจกรรม</font></center></td>
</tr>
<tr>
<td height="121" ><fieldset style="border: 1px solid #CDCDCD; padding: 8px; padding-bottom:0px; margin: 8px 0">
<legend><strong>อัพโหลดรูปกิจกรรม</strong></legend>
<br /> <p>
<div id="fileUpload2">You have a problem with your javascript</div>
</fieldset></p>
<p style="border: 1px solid #CDCDCD; padding: 8px; padding-bottom:0px; margin: 8px 0">
<h>อัลบั้มกิจกรรม:
<?
include("connect.php");
$SQL_category = mysql_query("SELECT album_name,album_id FROM album ORDER BY album_name") or die(mysql_error());
echo "<select name=\"album_id\" class=\"SELECT\">";
echo "<option selected>เลือกอัลบั้มกิจกรรม</option>";
while ($row = mysql_fetch_array($SQL_category)){
$album_name = $row["album_name"];
$album_id = $row["album_id"];
echo "<option value=\"$album_id\">$album_name</option>";
}
echo "</select>";
?>
</h>
</p>
<p style="border: 1px solid #CDCDCD; padding: 8px; padding-bottom:0px; margin: 8px 0"> <a href="javascript:$('#fileUpload2').fileUploadStart()">Start Upload</a> | <a href="javascript:$('#fileUpload2').fileUploadClearQueue()">Clear Queue</a> </p></td>
</tr>
</table>
</form>
Code (uploadify) <?
if (!empty($_FILES)) {
$tempFile = $_FILES['Filedata']['tmp_name'];
$targetPath = $_SERVER['DOCUMENT_ROOT'] . $_REQUEST['folder'] . '/';
$targetFile = str_replace('//','/',$targetPath) . $_FILES['Filedata']['name'];
if(trim($_FILES["Filedata"]["tmp_name"]) != "") //ทำ Resize
{
$images = $_FILES["Filedata"]["tmp_name"];
$new_images = "Thumbnails_".$_FILES["Filedata"]["name"];
copy($_FILES["Filedata"]["tmp_name"],"../MyResize/".$_FILES["Filedata"]["name"]);
$width=100; //*** Fix Width & Heigh (Autu caculate) ***//
$size=GetimageSize($images);
$height=round($width*$size[1]/$size[0]);
$images_orig = ImageCreateFromJPEG($images);
$photoX = ImagesX($images_orig);
$photoY = ImagesY($images_orig);
$images_fin = ImageCreateTrueColor($width, $height);
ImageCopyResampled($images_fin, $images_orig, 0, 0, 0, 0, $width+1, $height+1, $photoX, $photoY);
ImageJPEG($images_fin,"../MyResize/".$new_images);
ImageDestroy($images_orig);
ImageDestroy($images_fin);
echo "Resize and Upload Successful.<br>";
//*** Insert Record ***//
$objConnect = mysql_connect("localhost","root","123456") or die("Error Connect to Database");
$objDB = mysql_select_db("gallery");
$strSQL = "INSERT INTO picture ";
$strSQL .="(Thumbnails,PicName,album_id) VALUES ('".$new_images."','".$_FILES["Filedata"]["name"]."','$album_id')";
$objQuery = mysql_query($strSQL);
}
move_uploaded_file($tempFile,$targetFile);
echo "1";
}
?>
Tag PHP
Date :
2010-10-05 11:32:09By :
nongjarView :
1141Reply :
22
Code (PHP) $SQL_category = mysql_query("SELECT album_name,album_id FROM album ORDER BY album_name") or die(mysql_error());
echo "<select name=\"album_id\" class=\"SELECT\">";
echo "<option selected>เลือกอัลบั้มกิจกรรม</option>";
while ($row = mysql_fetch_array($SQL_category)){
$album_name = $row["album_name"];
echo $album_id = $row["album_id"];
ประวัติการแก้ไข
Date :
2010-10-05 11:45:46By :
iieszz
ลองเปลี่ยนตามที่บอกแล้วค่ะ
Date :
2010-10-05 12:02:19By :
nongjar
Code (PHP) <?
echo "<select name=\"album_id\" class=\"SELECT\">";
echo "<option selected>เลือกอัลบั้มกิจกรรม</option>";
include("connect.php");
$SQL_category = mysql_query("SELECT album_name,album_id FROM album ORDER BY album_name") or die(mysql_error());
echo $num_rows=mysql_num_rows($SQL_category);
while ($row = mysql_fetch_array($SQL_category)){
echo $album_name = $row["album_name"];
echo $album_id = $row["album_id"];
echo "<option value=\"$album_id\">$album_name</option>";
}
echo "</select>";
?>
ประวัติการแก้ไข
Date :
2010-10-05 15:18:51By :
iieszz
ไม่ได้อ่ะค่ะ
Date :
2010-10-05 17:12:56By :
nongjar
Code (PHP) $SQL_category = mysql_query("SELECT album_name,album_id FROM album ORDER BY album_name") or die(mysql_error());
echo $num_rows=mysql_num_rows($SQL_category);
Date :
2010-10-05 17:37:00By :
iieszz
จะเกี่ยวกับที่ว่าตรงอัพโหลดรูปเราใช้ ajax แต่ตรงอัลบัมเป็น php ธรรมดาแล้วตอนส่งค่าใช้ ajax ส่ง
Date :
2010-10-05 18:07:07By :
nongjar
ใครก็ได้ช่วยหน่อย
Date :
2010-10-05 21:25:31By :
nongjar
ส่งไปด้วย scriptData ครับ ดูใน docs ซิ
Date :
2010-10-05 23:43:59By :
PlaKriM
ยังทำไม่ได้เลยอ่ะ
Date :
2010-10-06 09:42:27By :
nongjar
ดูเหมือนว่าตอนที่คุณรับค่าต่างๆจาก ไฟล์Code (upload)
Date :
2010-10-06 10:44:55By :
poipypunch_9
'displayData' : 'speed',
Date :
2010-10-06 10:59:02By :
PlaKriM
ไม่เข้าใจอ่ะค่ะ
Date :
2010-10-06 11:11:52By :
nongjar
บอกแค่เนี้ยหรอครับ ใครจะรู้ละว่ามันผิดตรงไหนยังไง เอาโค๊ดมาดูซิ ทั้งฟอร์มแล้วก็ตอน save
Date :
2010-10-06 11:20:17By :
PlaKriM
Code (Form_Upload) <form id="form1" name="form1" method="post" action="../js/uploadify.php" enctype="multipart/form-data">
<script type="text/javascript" src="../js/jquery-1.3.2.min.js"></script>
<script type="text/javascript" src="../js/jquery.uploadify.js"></script>
<script type="text/javascript">
$(document).ready(function() {
$("#fileUpload2").fileUpload({
'uploader' : '../uploadify/uploader.swf',
'cancelImg' : '../uploadify/cancel.png',
'script' : '../js/uploadify.php',
'folder' : '../MyResize/',
'multi' : true,
'buttonText' : 'Browse..',
'checkScript' : '../uploadify/check.php',
'displayData' : 'speed',
'simUploadLimit': 2
});
});
</script>
<fieldset style="border: 1px solid #CDCDCD; padding: 8px; padding-bottom:0px; margin: 8px 0">
<legend><strong>อัพโหลดรูปกิจกรรม</strong></legend><p><div id="fileUpload2">You have a problem with your javascript</div></p>
<p>อัลบั้มกิจกรรม:
<?
echo "<select name=\"album_id\" class=\"SELECT\">";
echo "<option selected>เลือกอัลบั้มกิจกรรม</option>";
include("connect.php");
$SQL_category = mysql_query("SELECT album_name,album_id FROM album ORDER BY album_name") or die(mysql_error());
echo $num_rows=mysql_num_rows($SQL_category);
while ($row = mysql_fetch_array($SQL_category)){
echo $album_name = $row["album_name"];
echo $album_id = $row["album_id"];
echo "<option value=\"$album_id\">$album_name</option>";
}
echo "</select>";
?>
</p>
<p>
<label>
<input type="submit" name="Submit" value="Start Upload" onclick="javascript:$('#fileUpload2').fileUploadStart()" />
</label>
<label>
<input type="submit" name="Submit2" value="Clear Queue" />
</label>
</fieldset></p>
</form>
Code (uploadify.php) <?
if(trim($_FILES["Filedata"]["tmp_name"]) != "") //ทำ Resize
{
$images = $_FILES["Filedata"]["tmp_name"];
$new_images = "Thumbnails_".$_FILES["Filedata"]["name"];
copy($_FILES["Filedata"]["tmp_name"],"../MyResize/".$_FILES["Filedata"]["name"]);
$width=100; //*** Fix Width & Heigh (Autu caculate) ***//
$size=GetimageSize($images);
$height=round($width*$size[1]/$size[0]);
$images_orig = ImageCreateFromJPEG($images);
$photoX = ImagesX($images_orig);
$photoY = ImagesY($images_orig);
$images_fin = ImageCreateTrueColor($width, $height);
ImageCopyResampled($images_fin, $images_orig, 0, 0, 0, 0, $width+1, $height+1, $photoX, $photoY);
ImageJPEG($images_fin,"../MyResize/".$new_images);
ImageDestroy($images_orig);
ImageDestroy($images_fin);
echo "Resize and Upload Successful.<br>";
//*** Insert Record ***//
$objConnect = mysql_connect("localhost","root","123456") or die("Error Connect to Database");
$objDB = mysql_select_db("gallery");
$strSQL = "INSERT INTO picture ";
$strSQL .="(Thumbnails,PicName,album_id) VALUES ('".$new_images."','".$_FILES["Filedata"]["name"]."','$album_id')";
$objQuery = mysql_query($strSQL);
}
?>
Date :
2010-10-06 11:28:45By :
nongjar
ก็คือประมาณว่าCode (PHP) $images = $_FILES["Filedata"]["tmp_name"];
$album_id=$_POST["album_id"];
Date :
2010-10-06 13:48:14By :
poipypunch_9
อยากจะขึ้นสอบโปรเจคแล้ว
Date :
2010-10-06 14:30:14By :
nongjar
Code (PHP) <form id="form1" name="form1" method="post" action="../js/uploadify.php" enctype="multipart/form-data">
<script type="text/javascript" src="../js/jquery-1.3.2.min.js"></script>
<script type="text/javascript" src="../js/jquery.uploadify.js"></script>
<script type="text/javascript">
$(document).ready(function() {
$("#fileUpload2").fileUpload({
'uploader' : '../uploadify/uploader.swf',
'cancelImg' : '../uploadify/cancel.png',
'script' : '../js/uploadify.php',
'folder' : '../MyResize/',
'multi' : true,
'buttonText' : 'Browse..',
'checkScript' : '../uploadify/check.php',
'displayData' : 'speed',
'scriptData' : { 'album_id': $('.SELECT').find('option').filter(':selected').val() },
'simUploadLimit': 2
});
});
</script>
<fieldset style="border: 1px solid #CDCDCD; padding: 8px; padding-bottom:0px; margin: 8px 0">
<legend><strong>อัพโหลดรูปกิจกรรม</strong></legend><p><div id="fileUpload2">You have a problem with your javascript</div></p>
<p>อัลบั้มกิจกรรม:
<?
echo "<select name=\"album_id\" class=\"SELECT\">";
echo "<option selected>เลือกอัลบั้มกิจกรรม</option>";
include("connect.php");
$SQL_category = mysql_query("SELECT album_name,album_id FROM album ORDER BY album_name") or die(mysql_error());
echo $num_rows=mysql_num_rows($SQL_category);
while ($row = mysql_fetch_array($SQL_category)){
//echo $album_name = $row["album_name"];
//echo $album_id = $row["album_id"];
echo "<option value=\"$album_id\">$album_name</option>";
}
echo "</select>";
?>
</p>
<p>
<label>
<input type="submit" name="Submit" value="Start Upload" onclick="javascript:$('#fileUpload2').fileUploadStart()" />
</label>
<label>
<input type="submit" name="Submit2" value="Clear Queue" />
</label>
</fieldset></p>
</form>
Code (PHP) $album_id = $_REQUEST["album_id"];
if(trim($_FILES["Filedata"]["tmp_name"]) != "") //ทำ Resize
{
$images = $_FILES["Filedata"]["tmp_name"];
$new_images = "Thumbnails_".$_FILES["Filedata"]["name"];
copy($_FILES["Filedata"]["tmp_name"],"../MyResize/".$_FILES["Filedata"]["name"]);
$width=100; //*** Fix Width & Heigh (Autu caculate) ***//
$size=GetimageSize($images);
$height=round($width*$size[1]/$size[0]);
$images_orig = ImageCreateFromJPEG($images);
$photoX = ImagesX($images_orig);
$photoY = ImagesY($images_orig);
$images_fin = ImageCreateTrueColor($width, $height);
ImageCopyResampled($images_fin, $images_orig, 0, 0, 0, 0, $width+1, $height+1, $photoX, $photoY);
ImageJPEG($images_fin,"../MyResize/".$new_images);
ImageDestroy($images_orig);
ImageDestroy($images_fin);
echo "Resize and Upload Successful.<br>";
//*** Insert Record ***//
$objConnect = mysql_connect("localhost","root","123456") or die("Error Connect to Database");
$objDB = mysql_select_db("gallery");
$strSQL = "INSERT INTO picture ";
$strSQL .="(Thumbnails,PicName,album_id) VALUES ('".$new_images."','".$_FILES["Filedata"]["name"]."','$album_id')";
$objQuery = mysql_query($strSQL);
}
Date :
2010-10-06 15:28:55By :
PlaKriM
ลอง debug เองดูครับ ผมให้แนวขนาดนี้แล้ว ลอง alert ดูก่อน submit ก็ได้
Date :
2010-10-06 17:43:08By :
PlaKriM
มันไม่ support ภาษาไทย
Date :
2011-08-18 15:57:08By :
โดย
Server 00
Load balance : Server 00
