[SOLVED] PHP database code issue

CloudedVision · #41 (**permalink**) Mar 25th, 2008, 23:25

when the page blank, look at the source. anything there?

acrikey · #42 (**permalink**) Mar 25th, 2008, 23:40

No but I think there is something wrong with the code, as the code is red after the last ?>
I'll upload code

acrikey · #43 (**permalink**) Mar 25th, 2008, 23:40

<head>
<title>Account Details</title></head>


<html>
<style type="text/css">
<!--
@import url("default.css");
<!--
body {
    background-repeat: repeat-x;
}
-->
</style>
<body>
<div id="header">
<script>
var Digital=new Date()
var month=Digital.getMonth()
if (month <= 2){    // month is between jan and march    
    document.write("<IMG SRC='http://www.lightex.co.uk/fieldworks/images/img5.jpg'>");
} else if (month <= 5){
    // month is between april and june
    document.write("<IMG SRC='http://www.lightex.co.uk/fieldworks/images/img2.jpg'>");
} else if (month <= 8){    // july and september
    document.write("<IMG SRC='http://www.lightex.co.uk/fieldworks/images/img2.jpg'>");
} else {    // otherwise its between oct and dec
    document.write("<IMG SRC='http://www.lightex.co.uk/fieldworks/images/img3.jpg'>");
}
</script>
</div>
<div id="page">
  <div id="content">
        <div id="welcome" class="post">
            <h1 class="title">Account Details</h1>
            <div class="content"><img src="http://www.webforumz.com/images/420 copy.png" alt="" width="131" height="106" class="left" />
                <h3 align="center"><br />
                </h3>
                <h3 align="center">The professional approach to paddock maintenance.</h3>
          </div>
    </div>
        <div id="example" class="post">
            <h2 class="title">&nbsp;</h2>
            
<?php
ob_start()
$host=""; // Host name
$username=""; // Mysql username
$password=""; // Mysql password
$db_name=""; // Database name
$tbl_name=""; // Table name

    // Connect to server and select databse.
    mysql_connect("$host", "$username", "$password")or die("cannot connect");
    mysql_select_db("$db_name")or die("cannot select DB");

    m// issue the query
    $sql = "SELECT * FROM members WHERE
            username = '".$_POST["username"]."' AND
            password = '".$_POST["password"]."'; 
    $result = mysqli_query($mysqli, $sql) or die(mysqli_error($mysqli));
    if($info = mysqli_fetch_array($result)) { 
            //display string
       $display_block = "
    <p>".$info['f_name']." <p>
    <p>".$info['l_name']." <p>"; 

    echo $display_block; 
    } else {
       echo '<p>Wrong username and password!</p>';
    } 
    ?>


            
            <div class="content">
                                  
              
          </div>
        </div>
  </div>
    <div id="sidebar">
        <div id="menu">
            <ul>
              <li><a href="homepage.html" onclick="logout_confirm(); return false;">Homepage</a>
             <script> function logout_confirm() {
  if(confirm("You are about to logout?"))
    window.location = "homepage.html";
}</script></li>
                <li><a href="login_success.php" title="">Login Homepage</a></li>
              <li><a href="fieldworks/accountdetails.php" title="">Account Detail</a></li>
                <li><a href="lastbill.php" title="">Last Bill</a></li>
                <li><a href="estatedetails.php" title="">Estate Details</a></li>
                <li><a href="fieldworks/contactuslogin.php" title="">Contact Us</a></li>
            </ul>
        </div>
        <div id="login" class="boxed">
            <h2 class="title">Next Vistit</h2>
            <div class="content">
            
          </div>
        </div>
        <div id="updates" class="boxed">
            <h2 class="title">Time</h2>
            <div class="content">
                <!-- Paste this code into the BODY section of your HTML document  -->


            </div>
        </div>
    </div>
    <div style="clear: both;">&nbsp;</div>
</div>
<div id="footer">Copyright &copy; 2008 fieldworks.com. Designed by <a href="ttp://www.blanedesigns.com">Blane Designs</a>
  <p id="links"><br />
  <a href="#">Privacy Policy</a></p>
</div>
</body>
</html>

CloudedVision · #44 (**permalink**) Mar 25th, 2008, 23:42

is it saved as a .php file?

acrikey · #45 (**permalink**) Mar 25th, 2008, 23:42

CloudedVision · #46 (**permalink**) Mar 25th, 2008, 23:46

is this on your local machine or a host? Does your host support PHP?

acrikey · #47 (**permalink**) Mar 25th, 2008, 23:46

http://www.lightex.co.uk/fieldworks/accountdetails.php

Alert Box UN: test
Alert box PW: webforumz

site UN: webforumz
site PW: webforumz

acrikey · #48 (**permalink**) Mar 25th, 2008, 23:46

host and yes they can support php5

CloudedVision · #49 (**permalink**) Mar 26th, 2008, 00:00

PHP: Select all


<?php
ob_start()
$host="localhost"; // Host name
$username="fieldworks"; // Mysql username

right there. Get rid of that ob_start(). You don't need it and that most likely is whats causing the problems.

acrikey · #50 (**permalink**) Mar 26th, 2008, 11:11

Still blank and the ob is removed

CloudedVision · #51 (**permalink**) Mar 26th, 2008, 14:14

just as a test, insert this somewhere in your PHP code:

PHP: Select all


nonexistant("asdfasd);

See if that returns any sort of error.

acrikey · #52 (**permalink**) Mar 26th, 2008, 14:23

Still blank, nothing returned

CloudedVision · #53 (**permalink**) Mar 26th, 2008, 14:26

are any other PHP pages working?

acrikey · #54 (**permalink**) Mar 26th, 2008, 14:36

none with this code but others yes

CloudedVision · #55 (**permalink**) Mar 26th, 2008, 14:38

hmmmm

contact your host. tell them nothing is displaying, including errors.

acrikey · #56 (**permalink**) Mar 26th, 2008, 14:43

But surely it must be the code because, it displays until I put the db code in the script

CloudedVision · #57 (**permalink**) Mar 26th, 2008, 14:46

im pretty sure it is the code also, but the code must have a fatal error if its not displaying anything, and its not showing the fatal error. so contact your host about its PHP error settings.

acrikey · #58 (**permalink**) Mar 26th, 2008, 14:49

hang on I'll just run a quick test, bare with me

CloudedVision · #59 (**permalink**) Mar 26th, 2008, 14:49

yep, there were several errors in the code. I debugged em, so use this code:

PHP: Select all


<html>
<head>
<title>Account Details</title></head>


<html>
<style type="text/css">
<!--
@import url("default.css");
<!--
body {
    background-repeat: repeat-x;
}
-->
</style>
<body>
<div id="header">
<script>
var Digital=new Date()
var month=Digital.getMonth()
if (month <= 2){    // month is between jan and march    
    document.write("<IMG SRC='http://www.lightex.co.uk/fieldworks/images/img5.jpg'>");
} else if (month <= 5){
    // month is between april and june
    document.write("<IMG SRC='http://www.lightex.co.uk/fieldworks/images/img2.jpg'>");
} else if (month <= 8){    // july and september
    document.write("<IMG SRC='http://www.lightex.co.uk/fieldworks/images/img2.jpg'>");
} else {    // otherwise its between oct and dec
    document.write("<IMG SRC='http://www.lightex.co.uk/fieldworks/images/img3.jpg'>");
}
</script>
</div>
<div id="page">
  <div id="content">
        <div id="welcome" class="post">
            <h1 class="title">Account Details</h1>
            <div class="content"><img src="http://www.webforumz.com/images/420 copy.png" alt="" width="131" height="106" class="left" />
                <h3 align="center"><br />
                </h3>
                <h3 align="center">The professional approach to paddock maintenance.</h3>
          </div>
    </div>
        <div id="example" class="post">
            <h2 class="title">&nbsp;</h2>
            
<?php
$host=""; // Host name
$username=""; // Mysql username
$password=""; // Mysql password
$db_name=""; // Database name
$tbl_name=""; // Table name

    // Connect to server and select databse.
    mysql_connect("$host", "$username", "$password")or die("cannot connect");
    mysql_select_db("$db_name")or die("cannot select DB");

    // issue the query
    $sql = "SELECT * FROM members WHERE
            username = '".$_POST["username"]."' AND
            password = '".$_POST["password"]."'"; 
    $result = mysqli_query($mysqli, $sql) or die(mysqli_error($mysqli));
    if($info = mysqli_fetch_array($result)) { 
            //display string
       $display_block = "
    <p>".$info['f_name']." <p>
    <p>".$info['l_name']." <p>"; 

    echo $display_block; 
    } else {
       echo '<p>Wrong username and password!</p>';
    } 
    ?>


            
            <div class="content">
                                  
              
          </div>
        </div>
  </div>
    <div id="sidebar">
        <div id="menu">
            <ul>
              <li><a href="homepage.html" onclick="logout_confirm(); return false;">Homepage</a>
             <script> function logout_confirm() {
  if(confirm("You are about to logout?"))
    window.location = "homepage.html";
}</script></li>
                <li><a href="login_success.php" title="">Login Homepage</a></li>
              <li><a href="fieldworks/accountdetails.php" title="">Account Detail</a></li>
                <li><a href="lastbill.php" title="">Last Bill</a></li>
                <li><a href="estatedetails.php" title="">Estate Details</a></li>
                <li><a href="fieldworks/contactuslogin.php" title="">Contact Us</a></li>
            </ul>
        </div>
        <div id="login" class="boxed">
            <h2 class="title">Next Vistit</h2>
            <div class="content">
            
          </div>
        </div>
        <div id="updates" class="boxed">
            <h2 class="title">Time</h2>
            <div class="content">
                <!-- Paste this code into the BODY section of your HTML document  -->


            </div>
        </div>
    </div>
    <div style="clear: both;">&nbsp;</div>
</div>
<div id="footer">Copyright &copy; 2008 fieldworks.com. Designed by <a href="ttp://www.blanedesigns.com">Blane Designs</a>
  <p id="links"><br />
  <a href="#">Privacy Policy</a></p>
</div>
</body>
</html>

But still contact your host about its error settings.

		Webforumz.com > Main Forums > Program Your Website > PHP Forum
[SOLVED] PHP database code issue