Code doesn't print what i wanted it too. Please help!
Posted on
16th Feb 2014 07:03 pm by
admin
Hi there,
I wrote this code to mae it so that in the form before it that the user said their username and then on this page it matches up the username with the username on the database and then uses the password of that users as $password. I am new to php and i thought that this would do the trick. But it doesn't. Instead of printing the password it prints "Resource id #6".
Here's the code:
Code:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><title>Radio Ilam | Radio of the Suburbs</title><meta name="keywords" content="music note, free template, website template, CSS, XHTML" /><meta name="description" content="Music Note - free CSS template provided by templatemo.com" /><link href="templatemo_style.css" rel="stylesheet" type="text/css" /><style type="text/css">
.style1 {
text-align: center;
}
.style2 {
font-weight: bold;
color: #C32929;
}
.style3 {color: #FF0000}
td {padding: 2px; vertical-align:top; border-top: 1px solid #CCC;}
</style></head>
<body>
<?php
// Connects to your Database
mysql_connect("removed", "removed", "removed") or die(mysql_error());
mysql_select_db("a1408362_data") or die(mysql_error());
//checks cookies to make sure they are logged in
if(isset($_COOKIE['ID_my_site']))
{
}
$username = $_COOKIE['ID_my_site'];
if ($username <> "administrator")
{ header("Location: members.php");
}
else {}
?>
<div id="templatemo_container_wrapper">
<div id="templatemo_container">
<div id="templatemo_header">
<div id="templatemo_site_title">Radio<span class="style2">Ilam</span></div>
<div id="templatemo_site_slogan">Radio of the Suburbs</div>
</div>
<div id="templatemo_menuleft"></div>
<div id="templatemo_menu">
<ul>
<li><a href="index.html">Home</a></li>
<li><a href="competitions.php">Competitions</a></li>
<li><a href="#">Lates Music</a></li>
<li><a href="#" class="current">Members</a></li>
<li><a href="#">Listen Live</a></li>
<li><a href="#">Contact Us</a></li>
</ul>
</div>
<div id="templatemo_content">
<div id="templatemo_left_column">
<div class="templatemo_section2">
<h1>Administrator</h1>
<p>Welcome
<p><a href="logout.php">Logout</a></p>
</div>
<br />
</div>
<div id="templatemo_right_column">
<?php
$username = $_REQUEST['catergory'] ;
$password = mysql_query("SELECT password FROM users WHERE username = '$username'");
echo "$password"
?>
<h1>User</h1>
<p>
</p>
</div>
</div>
<div id="templatemo_footer">Copyright © 2009 RadioIlam<a href="#"></a></div>
</div>
</div>
</body>
</html>
No comments posted yet
Your Answer:
Login to answer
147 
15 
Other forums
Procedural to OOP
John Kleijn said that to avoid writing "crappy code", we should learn OOP and common OO pr
SCRIPT ERROR
Here is the CONTACT FORM I made for our website:
<form id="form1" name="
Socket Server
In my following socket server, I am trying to listen to a connection through port 12345 in my web br
Running External Scripts
I am very new to PHP and am not even sure what I'm asking is possible. I have just installed mediaW
Varible in trigger - refering to correct schema
Hello
Im having some issues with my trigger.
What I want to do is call opon a differ
Need help with a mail notify function
I was tasked with setting up a site that's been prewritten. The site is basically a form that captur
Help with Password Encoding/Decoding?
Trying to design a "change password" tool. On my signup code I'm using base64_encode, now
Warning message
I've put a website that I was doing live and I'm getting this warning message when I try to add a ne
UPLOAD IMAGES NOT WORKING!
Hi there i have a upload script in which it uploads the picture to a folder than creates two thumbna
Apart from cron
I need to run a php file every one hour. Is there any other solution apart from cron job?
