954,560 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

phpmyadmin vs mysqlbuddy

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

mitchiexlolz
Newbie Poster
15 posts since Sep 2011
Reputation Points: 10
Solved Threads: 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.

smantscheff
Nearly a Posting Virtuoso
1,233 posts since Oct 2010
Reputation Points: 300
Solved Threads: 254
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You
View similar articles that have also been tagged: