如果mysql结果不存在echo - if mysql result does not exist echo?

if mysql result does not exist echo?

本文关键字：echo 不存在结果 mysql 如果 | 更新日期: 2023-09-27

嗨，我的网站上有一个基本的点赞系统。基本上，一旦用户单击like，就会将user_id-has_liked从0设置为1。

如果他们的userid_has_liked设置为0，则显示相似链接，如果设置为1，则显示不同链接。然而，我想添加另一个条件，即如果结果不在mysql中，则回显类似的链接。

有人能告诉我在哪里，我会添加什么来实现这一点吗。

<div class="profile_likes">
<?php
$user_like_set = user_like_status();
while ($like = mysql_fetch_array($user_like_set)) 
if ($like['user_id_has_liked'] == '0')  { ?>
<a href="like_profile.php?to=<?php echo "$profile_id"; ?>">Like</a>&nbsp;&nbsp;|&nbsp;&nbsp;<?
$count_likes_set = count_likes();
while ($likes = mysql_fetch_array($count_likes_set)) {
    echo "". $likes['likes'] ." People Like ".$profile[2]."";
    //$check_new_duos_set = check_new_escort_duos(); while ($newd = mysql_fetch_array($check_new_duos_set)) { 
    ?>
    <? } }?>

    <?php
$user_like_set = user_like_status();
while ($like = mysql_fetch_array($user_like_set)) 
if ($like['user_id_has_liked'] == '1')  { ?>
<a href="unlike_profile.php?to=<?php echo "$profile_id"; ?>">Unlike</a>&nbsp;&nbsp;|&nbsp;&nbsp;<?
$count_likes_set = count_likes();
while ($likes = mysql_fetch_array($count_likes_set)) {
    echo "". $likes['likes'] ." People Like ".$profile[2]."";
    //$check_new_duos_set = check_new_escort_duos(); while ($newd = mysql_fetch_array($check_new_duos_set)) { 
    ?>
    <? } }?>
    </div>

您应该试试mysql_num_rows。它将为您提供记录集中存在的行数。除此之外，需要注意的是，您正在使用的API已被弃用。在mysql网站上寻找建议的替代方案。

尝试在echo/print函数的使用中保持一致性，并通过终止php标记来模拟它们，您的代码将变得更加清晰。

<?php
    function printLikeLink($likeLink){
          echo "<a href='{$likeLink}'>Like this profile</a>";
    }
    $user_like_set = user_like_status();
    if ($like = mysql_fetch_array($user_like_set)){
        if ($like['user_id_has_liked'] == '1')  {
            echo "<a href='"unlike_profile.php?to={$profile_id}'">Unlike</a>|";
            $count_likes_set = count_likes();
            while ($likes = mysql_fetch_array($count_likes_set)) {
                echo "". $likes['likes'] ." People Like ".$profile[2]."";
                //$check_new_duos_set = check_new_escort_duos(); while ($newd = mysql_fetch_array($check_new_duos_set)) { 
            }
        }else printLikeLink("like_profile.php?to={$profile_id}");
    }else printLikeLink("like_profile.php?to={$profile_id}"); // Edit this link.
?>

试试这个，我刚刚做了一个更改，您的user_like_status（）；应返回true或false

<div class="profile_likes">
<?php
    $user_like_set = user_like_status();//should return true or false
    if ($user_like_set == false){
        $what = "Like"; 
    }else{
        $what = "Unlike";
    }?>    
    <a href="like_profile.php?to=<?php echo "$profile_id"; ?>"><?php echo $what ;?></a>&nbsp;&nbsp;|&nbsp;&nbsp;
    <?php 
    $count_likes_set = count_likes();
    while ($likes = mysql_fetch_array($count_likes_set)) {
    echo "". $likes['likes'] ." People Like ".$profile[2]."";
    }
 ?>
</div>