0

is there a significant difference between phpmyadmin and mysqlbuddy?
i mean does they differ in codes? coz i have to make a website that checks whether the username and password exists in the databse.

here is my code for looking up in the databse.

<?php
if(isset($_POST['submit']))
{
	include 'connection.php';
	$npw = $_POST['txtPassword'];
	$id = $_POST['txtUserName'];
	$sql = "SELECT password,usertype FROM info WHERE userName='$id'";
	$result = mysql_query($sql);
	$row=mysql_fetch_array($result);
			$pw=$row["password"];
			$usertype=$row["userType"];
		if($pw==$npw)
		echo "password and username match";
		else
		echo "password and username didn't match";
}
?>

and i am using mysql buddy as my database

2
Contributors
1
Reply
3
Views
6 Years
Discussion Span
Last Post by smantscheff
0

You seem to be using mysql as a database, not mysqlbuddy. mysqlbuddy is just an interface to the database, as is phpmyadmin, too. It does not matter to the website application which of those you use. I recommend HeidiSQL.
Are you sure that you want to store plaintext passwords? That violates standard security practice.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.