plz help.. urgent PHP & CSV

[jack001]

hi all

i have below php code which check the user name from a CSV file...

I want to check from sql database... i m not getting any clue how to do it.. plz help

<?
$username = $_POST['username']; // get the username
$username = trim(htmlentities($username)); // strip some crap out of it
$file = '/folder/data.csv'; // Here's the file. Notice the full path.

echo check_username($file,$username); // call the check_username function and echo the results.

function check_username($file_in,$username){
    $username=strtolower($username);
    $file = file($file_in);
    foreach ($file as $line_num => $line) {
        $line = explode(',',$line);
        $user = trim(str_replace('"','',$line[0]));
        if($username == strtolower($user)){
            return '<span style="color:#f00">Username Unavailable</span>';
        }
    }
    return '<span style="color:#0c0">Username Available</span>';
}
?>

[replica]

http://ca.php.net/mysqli

^^^ that should tell you everything you'll want to know as far as the PHP side of it goes.

[jack001]

i m not understanding wat r u pointing me to....

plz can u replace the csv function with sql query???

regards

[haroon373]

<?php
$username = $_POST['username']; // get the username
$username = trim(htmlentities($username)); // strip some crap out of it
$dbins= mysql_connect("localhost", "dbuser", "dbpass"); // databse instence

echo check_username($dbins,$username); // call the check_username function and echo the results.

function check_username($dbins,$username){
    $username=strtolower($username);
    $sql = "SELECT `username` FROM dbname.table WHERE `username`=$username";
    $qry = mysql_query($sql, $dbins);
    $num = mysql_num_rows($qry);
        if($num > 0){
            return '<span style="color:#f00">Username Unavailable</span>';
        }
    }
    return '<span style="color:#0c0">Username Available</span>';
}
?>