如何更新帖子下的类别 [英] How to update category under post

问题描述

我想更新帖子类别例如



如果帖子属于类别 - >板球和子类ODI我想在测试下添加帖子也如何更新，以便帖子属于Cricket ODI测试



AND如果我取消ODI和TEST然后发布必须只属于Cricket，



如何做到这一点，请帮助我紧急。提前致谢



我尝试过：

I want to update category of post for example

if post fall under category --> cricket and sub category ODI I want to add the post under Test also how to update so that post falls under Cricket ODI Test

AND if I untick ODI AND TEST then post must fall under Cricket only,

How to do this please help me its urgent. Thanks in advance

What I have tried:

connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 


$post_id = '50';


echo "";

$sql1 = mysqli_query($conn, "SELECT * FROM category WHERE p_id = 0");
while ($row=mysqli_fetch_array($sql1)) {

	$new_id = $row['id'];

	$sql2 = mysqli_query($conn, "SELECT * FROM assign_category WHERE post_id = $post_id AND category_id=$new_id");
	$row2 = mysqli_fetch_array($sql2);

	$assign_id = $row2['category_id'];

	if ($new_id == $assign_id) {
		# code...
		#echo $row['category']." tick"."";
		?>
		" checked> 
		";
		?>
		"> 
		";
			?>
			" checked> 
			";
			?>
			"> 
			";
echo "";
echo "";

?>

/******updateed.php**********/

connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 
if(isset($_POST['submit']))
{
	$cat = $_POST['maincat'];

	foreach ($_POST['maincat'] as $key => $value) {
		# code...
		$stmt="INSERT IGNORE INTO assign_category (post_id, category_id, status) VALUES ('50', '$value', '1') ON DUPLICATE KEY UPDATE category_id='$value'";
    	$res = mysqli_query($conn, $stmt);

    if ($res) {
    	# code...
    	echo "Success";
    }
    else
    {
    	echo "fail";
    }
	}
}

?>

推荐答案

conn-> connect_error）;
}

conn->connect_error); }

post_id = ' 50';


echo ;

post_id = '50'; echo "";

sql1 = mysqli_query（

sql1 = mysqli_query(

这篇关于如何更新帖子下的类别的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！