 |
|
Code (PHP)
<?PHP
if(!empty($_GET['value_pages'])){
$getIngDetail = mysql_query(" SELECT * FROM product_colortone WHERE color_id='".$_GET['value_pages']."' ");
} else {
$getIngDetail = mysql_query(" SELECT * FROM product_colortone WHERE cat_color='".$_GET['value']."' ORDER BY color_id ASC ");
}
while($result = mysql_fetch_assoc($getIngDetail)){
//$no = ++$no;
?>
<ul style="margin:0 auto; padding:0; list-style:none; width:84%;">
<li style="width:620px; float:left; display:block; margin:0; padding:0; border-right:1px solid #E9E9E9;">
<ul class="product-list4">
<li> </li>
<?PHP
/*$getColor = mysql_query("SELECT color_id,ref_cat_colortone FROM product_colortone WHERE ref_cat_colortone='".$_POST['txtcat_colortone']."' ORDER BY color_id DESC ");
//echo $getColor;
print_r($_POST['txtcat_colortone']);
while($resultColor = mysql_fetch_assoc($getColor)){*/
?>
<li>
<img src="images/point.png" width="13" height="13" /> <?PHP //echo $resultColor['ref_cat_colortone'];?> <?PHP echo $result['color_tone'];?>
</li>
<?PHP
// }
?>
<li>
<a href="<?PHP echo $PHP_SELF?>?action=edit_update&color_id=<?PHP echo $result['color_id'];?> ">Edit</a> |
<a href="<?PHP echo $_SERVER['PHP_SELF']?>?action=delete&color_id=<?PHP echo $result['color_id'];?>"onclick="return confirm('Are you sure you want to delete?')">Delete</a></li>
</ul>
<ul>
<li style="list-style-type:none; height:350px;"> </li>
</ul>
<!--<div class="line-eyebrows"></div> -->
</li>
<li style="width:560px; float:left; display:block; margin:0; padding:0;">
<?PHP
$sqlImg="SELECT * FROM product_colortone_img WHERE color_id = '".$result['color_id']."' ORDER BY img_id ASC";
$queryImg = mysql_query($sqlImg) or die ("SQL Query = ".$sqlImg."");
while($resultImg=mysql_fetch_assoc($queryImg))
{
?>
<ul style="list-style:none; margin:0px 0px; padding:0;">
<li><img src="uploads/color_tone/<?PHP echo $resultImg['images'];?>"><br /></li>
<li style="font-size:18px;"><?PHP echo $resultImg["galleryName"];?></li>
</ul>
<?PHP } ?>
</li>
</ul>
<?PHP } ?>
ส่วน เพิ่มข้อมูล
Code (PHP)
<ul>
<li><div>Category</div> :
<select name="category">
<?PHP
$getMemu = mysql_query(" SELECT cat_id,menu FROM category_color ORDER BY cat_id ASC ");
while($resultMenu = mysql_fetch_assoc($getMemu)){
?>
<option value="<?PHP echo $resultMenu['cat_id'];?>"><?PHP echo $resultMenu['menu'];?></option>
<?PHP } ?>
</select>
</li>
<li><div>Color Tone</div> :
<select name="txtcat_colortone">
<?PHP
$ColorTone = mysql_query(" SELECT cat_id,tone FROM category_colortone ORDER BY cat_id ASC ");
while($resultColorTone = mysql_fetch_assoc($ColorTone)){
?>
<option value="<?PHP echo $resultColorTone['tone'];?>"><?PHP echo $resultColorTone['tone'];?></option>
<?PHP } ?>
</select>
</li>
<li><div>Tone</div> : <textarea name="txt_colorTone" cols="5" rows="5"></textarea></li>
<li><div>*.jpg Only</div>: <input type="text" name="txtGalleryName_add[]">
<input name="fileUpload[]" id="fileUpload[]" type="file"><span id="input1"></span><a href="javascript:void(0);" onclick="insert(1);" id="a1"> Add</a><br /> </li>
<li><div> </div> <input name="btnSubmit" type="submit" value="Submit"></li>
</ul>
</div><!--addrecord -->
</form>
<?PHP
//[Add Detail]
if(isset($_POST['txt_colorTone'])!="")
{
$date_today=date("Y-m-d");
$time_today=date("H:i:s");
$objsql="INSERT INTO product_colortone(
cat_color
,ref_cat_colortone
,color_tone
,date_today
,time_today
) VALUES (
'".$_POST["category"]."'
,'".$_POST["txtcat_colortone"]."'
,'".$_POST["txt_colorTone"]."'
,'$date_today'
,'$time_today'
)";
$objquery=mysql_query($objsql) or die (mysql_error());
//echo $objsql;
$color_id=mysql_insert_id();
if($objquery)
{
//echo "SQL :" .$objsql ."Save Done";
redirect("color_tone.php?value=".$_POST["category"]);
}else{
echo"Not recorded";
}


Tag : PHP, MySQL
|
ประวัติการแก้ไข 2015-04-09 15:14:24
|
 |
 |
 |
 |
Date :
2015-04-09 15:13:08 |
By :
nottpoo |
View :
660 |
Reply :
3 |
|
 |
 |
 |
 |
|
|
|
 |