0

hi someone help me with this error:(

Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\xampp\htdocs\CDX\class_lib.php on line 57
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in C:\xampp\htdocs\CDX\class_lib.php on line 57

<?php
	
	class contactdirectory{

		private $db_host = 'localhost';     // Database Host
		private $db_user = 'root';          // Username
		private $db_pass = 'root';          // Password
		private $db_name = 'contactdirectory';          // Database

		private $con = false;               // Checks to see if the connection is active
		private $result = array();          // Results that are returned from the query
    /*
     * Connects to the database, only one connection allowed
     */
    public function connect()
    {
        if(!$this->con)
        {
            $myconn = @mysql_connect($this->db_host,$this->db_user,$this->db_pass);
            if($myconn)
            {
                $seldb = @mysql_select_db($this->db_name,$myconn);
                if($seldb)
                {
                    $this->con = true;
                    return true;
                }
                else
                {
                    return false;
                }
            }
            else
            {
                return false;
            }
        }
        else
        {
            return true;
        }
    }

		function form(){
			echo	"<form name=contact  method=post action=index.php>";
			echo	"Name:"."<input type=text name=name /><br />";
			echo	"Address:"."<input type=text name=address /><br />";
			echo	"Email"."<input type=text name=email /><br />";
			echo	"Tel No:"."<input  type=text name=tel /><br />";
			echo	"Mobile No:"."<input type=text name=mobile /><br />";
			echo	"<input type=submit name=add value=Add />";
			echo	"</form>";
			
		}
		function add($name,$address,$email,$tel,$mobile){
			$query = "INSERT INTO contact VALUES(0, '$name','$address','$email','$tel','$mobile')";
			mysql_query($query);//<<-------line 57
			$directory = new contactdirectory();
			$directory -> form();
		}
		function select($idno){
		$query = "SELECT * FROM contact WHERE idno=$idno";
			$rs = mysql_query($query);
			if(mysql_num_rows($rs) > 0) {
				while($row = mysql_fetch_assoc($rs)){
							?>
					<form name="contact" action="index.php" method="post">
							<table border=1>";
							<tr>";
							<td width=150><?php echo $row[name] ?></td>";
							<td width=150><?php echo $row[address] ?></td>";
							<td width=150><?php echo $row[email] ?></td>";
							<td width=150><?php echo $row[tel] ?></td>";
							<td width=150><?php echo $row[mobile] ?></td>";
							<td width=150><form name=name1 action=index.php method=post>
								 <input type=hidden name=idno value=$row[idno] />
								 <input type=submit name=edit value=Edit />";
							<input type=submit name=delete value=Delete /></form></td>";
							</tr>";
							</table>";
					</form>
							<?php
							}
						}
	}
	
		
	function delete($idno){
			$query="DELETE FROM contact WHERE idno=$idno";
			mysql_query($query);
			$directory = new contactdirectory();
			$directory -> form();
			}
	function edit($idno){
			$query = "SELECT * FROM contact WHERE idno=$idno";
			$rs = mysql_query($query) or die (mysql_error());
			if(mysql_num_rows($rs) > 0) {
				while($row = mysql_fetch_assoc($rs)){
				
				?>
				
				<form name="contact" action="index.php" method="post">
					Name:<input type="text" name="name1" value="<?php echo $row[name] ?>" /><br />
					Address:<input type="text" name="address1" value="<?php echo $row[address] ?>" /><br />
					Email:<input type="text" name="email1" value="<?php echo $row[email] ?>" /><br />
					Tel No:<input type="text" name="tel1" value="<?php echo $row[tel] ?>" /><br />
					Mobile No:<input type="text" name="mobile1" value="<?php echo $row[mobile] ?>" /><br />
						<input type="hidden" name="idno" value="<?php echo $row[idno] ?>" />
						<input type="submit" name="update" value="Update" />
				</form>
				
				<?php
				}
			}
			
		}
		function update(){
			$query="UPDATE contact SET name='$_POST[name1]', address='$_POST[address1]', email='$_POST[email1]', tel='$_POST[tel1]', mobile='$_POST[mobile1]' WHERE idno='$_POST[idno]'";
			$rs=mysql_query($query) or die ('Update info error!' . mysql_error());
			$directory = new contactdirectory();
			$directory -> form();
		}
	
}	
?>

tnx.

2
Contributors
1
Reply
2
Views
5 Years
Discussion Span
Last Post by divyakrishnan
This question has already been answered. 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.