douyong1886 2015-11-07 13:30
浏览 37
已采纳

last if else语句无效[关闭]

hye guys..is there anything wrong with my if else statement..i tried input username that already existed in the database,and it work..also same if i left the textbox epmty..but if a tried enter a valid name,it does not read the else statement..can someone help me..i cant find where is the problem

<?php 

include 'connect.php'; 

$username = ($_POST['txtUsername']);

$statement = $mysqli->prepare("SELECT companyUsername FROM tblpartner WHERE companyUsername=?");
$statement->bind_param("s", $username);
$statement->execute();
$statement->bind_result($username);

if ( $statement->fetch()) {
    echo '<span class="error"> taken</span>';
} else if(empty($username)) {
    echo '<span class="error"> Cannot be empty</span>';
} else 

echo '<span class="success"> available.</span>';


?>
  • 写回答

1条回答 默认 最新

  • douliao1911 2015-11-07 13:49
    关注

    I think you're doing it mostly right but just got confused because you bind both the input name and the output result to $username.

    You want the username input to be checked for the "empty" condition, and the username output to be checked for NULL to signal that the name is available, if I'm understanding what you want correctly...

    So:

    $username = ($_POST['txtUsername']);
    
    if (empty($username) || ($username == '')) {
         echo '<span class="error"> Cannot be empty</span>';
    } else {
        $statement = $mysqli->prepare("SELECT companyUsername FROM tblpartner   WHERE companyUsername=?");
        $statement->bind_param("s", $username);
        $statement->execute();
        $statement->bind_result($username);
    
        if ( $statement->fetch()) {
    
            echo '<span class="error"> taken</span>';
    
        } else {
    
            echo '<span class="success"> available.</span>';
    
        }
    
    
    
    ?>
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥30 YOLO检测微调结果p为1
  • ¥20 求快手直播间榜单匿名采集ID用户名简单能学会的
  • ¥15 DS18B20内部ADC模数转换器
  • ¥15 做个有关计算的小程序
  • ¥15 MPI读取tif文件无法正常给各进程分配路径
  • ¥15 如何用MATLAB实现以下三个公式(有相互嵌套)
  • ¥30 关于#算法#的问题:运用EViews第九版本进行一系列计量经济学的时间数列数据回归分析预测问题 求各位帮我解答一下
  • ¥15 setInterval 页面闪烁,怎么解决
  • ¥15 如何让企业微信机器人实现消息汇总整合
  • ¥50 关于#ui#的问题:做yolov8的ui界面出现的问题