[SOLVED] PHP database code issue

[acrikey]

above is the entire script - db details

[acrikey]

all that will be extra is a css link

[CloudedVision]

It should so SOMETHING

a link maybe?

[CloudedVision]

wait, i got it

PHP: Select all

<?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");

m// issue the query
$sql = "SELECT * FROM members WHERE
        username = '".$_POST["username"]."' AND
        password = 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>';
} 
?>

Try that. If that doesn't work......

[Jack Franklin]

PHP: Select all

 $display_block = "
    <p>".$info['f_name']." <p>
    <p>".$info['l_name']." <p>"; 

Probably wrong, but do you need to escape the " in there? Because you are using them to assign $displayblock a value?

[acrikey]

still nothing

[acrikey]

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

[CloudedVision]

username and password please?

[acrikey]

webforumz
webforumz

[CloudedVision]

not working

[acrikey]

sorry wrong one

test
webforumz

[RohanShenoy]

Just a question, what is that

PHP: Select all

password = PASSWORD('".$_POST["password"]."')"; 

May be it should be

PHP: Select all

password = '".$_POST["password"]."'; 

[acrikey]

I'll check

[acrikey]

No change

[acrikey]

Any one got any suggestions why I keep getting a blank page?

[CloudedVision]

still got the ob_start() in there?

[acrikey]

um where

[acrikey]

As soon as I put the DB php code in and upload the screen goes blank

[CloudedVision]

try putting something before the PHP code. Is that shown?

[acrikey]

I already do, when the code goes in every thing goes