hi pals . could there have been any reason why this code simply doesn't work, have crossed check if to see possible error but every thing seems to be working fine , NO ERROR DISPLAYED BY SEVER AND , NO CONFIRMATION MSG DISPLAYED , AND NO DATA STORED IN THE DB.?
what could be the possible mistake i have being making ...Help would be greatly appreciated
HTML CODE
<form action="signup.php" method="POST">
<label for="username">User name : </label>
<input type="text" name="username" id="username"/><br/>
<label for="password">Password : </label>
<input type="text" name="password" id="password"/><br/>
<input type="submit" value="submit" id="submit"/>
</form>
php script
<?php
$usr=$_POST['username'];
$pwd=$_POST['password'];
$dbc=mysqli_connect('***','***','***','***')
or die('Error connecting to MYSQL sever .');
$query= "INSERT INTO password_list(user_name,password)".
"VALUES($usr,$pwd')";
$result= mysqli_guery($dbc,$query) or die('Error querying database.');
mysqli_close($dbc);
echo"User name and password added successfully.";
?>













