PHP warning help?

2013 年 11 月 16 日3400

I am a newbie, but I was finally able to solve this problem by moving the location of the mysqli_close(). I had it right after the last } , but then I moved it right before it and it worked.

    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"




    "http://http://www.zjjv.com///TR/xhtml1/DTD/xhtml1-transitional.dtd">




    <html xmlns="http://http://www.zjjv.com///1999/xhtml" xml:lang="en" lang="en">




    <head>




    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />




    <title>Make Me Elvis - Send Email</title>




    <link type="text/css" href="style.css" />




    </head>




    <body>




    <?php




    $from = 'elmer@makemeelvis.com';




    $subject = $_POST['subject'];




    $text = $_POST['elvismail'];









    if (empty($subject) && empty($text)){




    echo 'Both, the subject and the email field have been left empty';}









    if (empty($subject) && !empty($text)){




    echo 'The subject field is empty';}









    if (!empty($subject)&& empty($text)){




    echo 'The email field is empty'; }  









    if (!empty($subject) && !empty ($text)){









    $dbc = mysqli_connect('servername', 'username', 'password', 'dbname')




    or die('Error connecting to MySQL server.');









    $query = "SELECT * FROM email_list";




    $result = mysqli_query($dbc, $query)




    or die('Error querying database.');









    while ($row = mysqli_fetch_array($result)){




    $to = $row['email'];




    $first_name = $row['first_name'];




    $last_name = $row['last_name'];




    $msg = "Dear $first_name $last_name,\n $text";




    mail($to, $subject, $msg, 'From:' . $from);




    echo 'Email sent to: ' . $to . '<br />';




    }




    mysqli_close($dbc);




    } 









    ?>