View Full Version: password check

MPAM Rebooted Forums > Software support (freewares, PHP...) > password check


Title: password check


257335 - December 30, 2006 09:25 PM (GMT)
CODE

<?php
$con = mysql_connect("localhost","root","*****");
if (!$con)
 {
 die('Could not connect: ' . mysql_error());
 }


mysql_select_db("realestate", $con);

$result = mysql_query("SELECT * FROM login
WHERE Accountname='".$_post["username"]."'");

if(accountpassword=='".$_post["password"]."'
echo CMS.html;


i get this
QUOTE

Parse error: parse error, unexpected T_ECHO in C:\Documents and Settings\Marquis Taliaferro\Desktop\web page\password.php on line 15

257335 - December 31, 2006 07:23 AM (GMT)
if you could just sent me a block of code that you have already wrote that would do do the same thing it would probly be easyer for both of us and i know it would be alot more secure. or if you just want to help me fix my thats fine too

patheticcockroach - December 31, 2006 06:55 PM (GMT)
Yeah I already have a login script, you should base you work on it ;)
http://www.patheticcockroach.com/mpam4/index.php?p=18
This is a script close to the one in use on the website, btw.

257335 - January 1, 2007 04:12 AM (GMT)
ok i got the file uncompressed and the create table and login info put in those files im got lost after that step. it sayed to run the create table one i wasnt sure how to do that i assume you just double click on it. i only need one page password protected here is the code.

CODE

<html>
<head>
<title>CMS</title>
<link rel="stylesheet" href="CSS.css" type="text/css" />
</head>

<body>

<div id="sidebar">
<img src="images/bigdoglogo.gif" width="215"height="75">
<div id="menu">
<a href="Home.html">Home</a>
<a href="Apartments.html">Apartments</a>
<a href="Industrial.html">Industrial</a>
<a href="Land.html">Land</a>
<a href="Retail.html">Retail</a>
<a href="OfficeSpace.html">Office Space</a>
<a href="AboutUs.html">About Us</a>
</div>
</div>

<div id="content">
<h3>Enter New Data Here </h3>

<br>
<br>

<form name="input" action="fromCMS.php" method="post">
Account number:<input type="text" name="accountnum"size="30"><br><br>

Address: <input type="text"name="Address"size="30"><br><br>

Zipcode: <input type="text" name="zipcode" size="30"><br><br>

Price: <input type="text" name="price" size="30"><br><br>

Baths: <input type="text" name="baths" size="30"><br><br>

Bedrooms: <input type="text" name="bedrooms" size="30"><br><br>

City: <input type="text" name="city" size="30"><br><br>

State: <select name="state">
<option selected>--Pick a State--</option>
<option value="Alabama">Alabama</option>
<option value="volvo">Alaska</option>
<option value="Alaska">Arizona</option>
<option value="Arkansas">Arkansas</option>
<option value="California">California</option>
<option value="Colorado">Colorado</option>
<option value="Connecticut">Connecticut</option>
<option value="Delaware">Delaware</option>
<option value="Florida">Florida</option>
<option value="Georgia">Georgia</option>
<option value="Hawaii">Hawaii</option>
<option value="Idaho">Idaho</option>
<option value="Illinois">Illinois</option>
<option value="Indiana">Indiana</option>
<option value="Iowa">Iowa</option>
<option value="Kansas">Kansas</option>
<option value="Kentucky">Kentucky</option>
<option value="Louisiana">Louisiana</option>
<option value="Maine">Maine</option>
<option value="Maryland">Maryland</option>
<option value="Massachusetts">Massachusetts</option>
<option value="Michigan">Michigan</option>
<option value="Minnesota">Minnesota</option>
<option value="Mississippi">Mississippi</option>
<option value="Missori">Missori</option>
<option value="Montana">Montana</option>
<option value="Nebraska">Nebraska</option>
<option value="Nevada">Nevada</option>
<option value="New Hampshire">New Hampshire</option>
<option value="New Jersey">New Jersey</option>
<option value="New Mexico">New Mexico</option>
<option value="New York">New York</option>
<option value="North Carolina">North Carolina</option>
<option value="North Dakota">North Dakota</option>
<option value="Ohio">Ohio</option>
<option value="Oklahoma">Oklahoma</option>
<option value="Oregon">Oregon</option>
<option value="Pennsylvannia">Pennsylvannia</option>
<option value="Rhode Island">Rhode Island</option>
<option value="South Carolina">South Carolina</option>
<option value="South Dakota">South Dakota</option>
<option value="Tennessee">Tennessee</option>
<option value="Texas">Texas</option>
<option value="Utah">Utah</option>
<option value="Vermont">Vermont</option>
<option value="Virgina">Virgina</option>
<option value="Washington">Washington</option>
<option value="West Virginia">West Virginia</option>
<option value="Wisconsin">Wisconsin</option>
<option value="Wyoming">Wyoming</option>
</select><br><br>

Square feet: <input type="text" name="squarefeet" size="30"><br><br>

County: <input type="text" name="county" size="30"><br><br>

Subdivsion: <input type="text" name="subdivsion" size="30"><br><br>

Year built: <input type="text" name="yearbuilt" size="30"><br><br>

Description: <input type="text" name="description" size="30"><br><br>

Buy of Lease: <select name="buyorlease">
<option selected>--Pick one--</option>
<option value="buy">Buy</option>
<option value="lease">Lease</option>
</select><br><br>

Image name and type: <input type="text"name="imagepath"size="30"> <br><br>

Type of property: <select name="type">
<option selected>--Pick one--</option>
<option value="apartments">Apartments</option>
<option value="industrial">Industrial</option>
<option value="land">Land</option>
<option value="retail">Retail</option>
<option value="office space">Office Space</option>
</select><br><br>

Acreage (if applies): <input type="text" name="acreage" size="30">
<br><br>
<input type="submit" value="Submit">
</form>


</body>
</html>


Where is it getting the login name and passwords from??

patheticcockroach - January 1, 2007 07:29 AM (GMT)
QUOTE
it sayed to run the create table one i wasnt sure how to do that i assume you just double click on it.

No, you simply have to open the create_table.php page on your server with your browser ;)
QUOTE
i only need one page password protected

Never mind, do the same thing as for protecting several pages (except that you only have to do it on one page)
QUOTE
Where is it getting the login name and passwords from??

You have to add users in the table created by create_table.php (use phpMyAdmin for that)

Here is how your page should be if you want to protect it completely except the sidebar

CODE
<?php
session_start();
?>
<html>
<head>
<title>CMS</title>
<link rel="stylesheet" href="CSS.css" type="text/css" />
</head>

<body>

<div id="sidebar">
<img src="images/bigdoglogo.gif" width="215"height="75">
<div id="menu">
<a href="Home.html">Home</a>
<a href="Apartments.html">Apartments</a>
<a href="Industrial.html">Industrial</a>
<a href="Land.html">Land</a>
<a href="Retail.html">Retail</a>
<a href="OfficeSpace.html">Office Space</a>
<a href="AboutUs.html">About Us</a>
</div>
</div>

<div id="content">
<?php
include ("login.php");   // **** This is where you include the log in form
?>
<?php
if (isset($_SESSION["uname"]))
{
?>
<h3>Enter New Data Here </h3>

<br>
<br>

<form name="input" action="fromCMS.php" method="post">
Account number:<input type="text" name="accountnum"size="30"><br><br>

Address: <input type="text"name="Address"size="30"><br><br>

Zipcode: <input type="text" name="zipcode" size="30"><br><br>

Price: <input type="text" name="price" size="30"><br><br>

Baths: <input type="text" name="baths" size="30"><br><br>

Bedrooms: <input type="text" name="bedrooms" size="30"><br><br>

City: <input type="text" name="city" size="30"><br><br>

State: <select name="state">
<option selected>--Pick a State--</option>
<option value="Alabama">Alabama</option>
<option value="volvo">Alaska</option>
<option value="Alaska">Arizona</option>
<option value="Arkansas">Arkansas</option>
<option value="California">California</option>
<option value="Colorado">Colorado</option>
<option value="Connecticut">Connecticut</option>
<option value="Delaware">Delaware</option>
<option value="Florida">Florida</option>
<option value="Georgia">Georgia</option>
<option value="Hawaii">Hawaii</option>
<option value="Idaho">Idaho</option>
<option value="Illinois">Illinois</option>
<option value="Indiana">Indiana</option>
<option value="Iowa">Iowa</option>
<option value="Kansas">Kansas</option>
<option value="Kentucky">Kentucky</option>
<option value="Louisiana">Louisiana</option>
<option value="Maine">Maine</option>
<option value="Maryland">Maryland</option>
<option value="Massachusetts">Massachusetts</option>
<option value="Michigan">Michigan</option>
<option value="Minnesota">Minnesota</option>
<option value="Mississippi">Mississippi</option>
<option value="Missori">Missori</option>
<option value="Montana">Montana</option>
<option value="Nebraska">Nebraska</option>
<option value="Nevada">Nevada</option>
<option value="New Hampshire">New Hampshire</option>
<option value="New Jersey">New Jersey</option>
<option value="New Mexico">New Mexico</option>
<option value="New York">New York</option>
<option value="North Carolina">North Carolina</option>
<option value="North Dakota">North Dakota</option>
<option value="Ohio">Ohio</option>
<option value="Oklahoma">Oklahoma</option>
<option value="Oregon">Oregon</option>
<option value="Pennsylvannia">Pennsylvannia</option>
<option value="Rhode Island">Rhode Island</option>
<option value="South Carolina">South Carolina</option>
<option value="South Dakota">South Dakota</option>
<option value="Tennessee">Tennessee</option>
<option value="Texas">Texas</option>
<option value="Utah">Utah</option>
<option value="Vermont">Vermont</option>
<option value="Virgina">Virgina</option>
<option value="Washington">Washington</option>
<option value="West Virginia">West Virginia</option>
<option value="Wisconsin">Wisconsin</option>
<option value="Wyoming">Wyoming</option>
</select><br><br>

Square feet: <input type="text" name="squarefeet" size="30"><br><br>

County: <input type="text" name="county" size="30"><br><br>

Subdivsion: <input type="text" name="subdivsion" size="30"><br><br>

Year built: <input type="text" name="yearbuilt" size="30"><br><br>

Description: <input type="text" name="description" size="30"><br><br>

Buy of Lease: <select name="buyorlease">
<option selected>--Pick one--</option>
<option value="buy">Buy</option>
<option value="lease">Lease</option>
</select><br><br>

Image name and type: <input type="text"name="imagepath"size="30"> <br><br>

Type of property: <select name="type">
<option selected>--Pick one--</option>
<option value="apartments">Apartments</option>
<option value="industrial">Industrial</option>
<option value="land">Land</option>
<option value="retail">Retail</option>
<option value="office space">Office Space</option>
</select><br><br>

Acreage (if applies): <input type="text" name="acreage" size="30">
<br><br>
<input type="submit" value="Submit">
</form>

<?php
}
?>


</body>
</html>

257335 - January 1, 2007 07:40 AM (GMT)
yes i feel like a complete idiot now
thanks

257335 - January 1, 2007 08:01 AM (GMT)
ok if im right when it is working when you go into CMS.html it should have the sidebar and then a place to enter enter a username and password. i copies and pasted the revised code u gave me and went into phpmyadmin and added the users and passwords but when you go into it nothing changed.
maybe i missed something so here is the code for CMS that im using
CODE

<?php
session_start();
?>
<html>
<head>
<title>CMS</title>
<link rel="stylesheet" href="CSS.css" type="text/css" />
</head>

<body>

<div id="sidebar">
<img src="images/bigdoglogo.gif" width="215"height="75">
<div id="menu">
<a href="Home.html">Home</a>
<a href="Apartments.html">Apartments</a>
<a href="Industrial.html">Industrial</a>
<a href="Land.html">Land</a>
<a href="Retail.html">Retail</a>
<a href="OfficeSpace.html">Office Space</a>
<a href="AboutUs.html">About Us</a>
</div>
</div>

<div id="content">
<?php
include ("login.php");   // **** This is where you include the log in form
?>
<?php
if (isset($_SESSION["uname"]))
{
?>
<h3>Enter New Data Here </h3>

<br>
<br>

<form name="input" action="fromCMS.php" method="post">
Account number:<input type="text" name="accountnum"size="30"><br><br>

Address: <input type="text"name="Address"size="30"><br><br>

Zipcode: <input type="text" name="zipcode" size="30"><br><br>

Price: <input type="text" name="price" size="30"><br><br>

Baths: <input type="text" name="baths" size="30"><br><br>

Bedrooms: <input type="text" name="bedrooms" size="30"><br><br>

City: <input type="text" name="city" size="30"><br><br>

State: <select name="state">
<option selected>--Pick a State--</option>
<option value="Alabama">Alabama</option>
<option value="volvo">Alaska</option>
<option value="Alaska">Arizona</option>
<option value="Arkansas">Arkansas</option>
<option value="California">California</option>
<option value="Colorado">Colorado</option>
<option value="Connecticut">Connecticut</option>
<option value="Delaware">Delaware</option>
<option value="Florida">Florida</option>
<option value="Georgia">Georgia</option>
<option value="Hawaii">Hawaii</option>
<option value="Idaho">Idaho</option>
<option value="Illinois">Illinois</option>
<option value="Indiana">Indiana</option>
<option value="Iowa">Iowa</option>
<option value="Kansas">Kansas</option>
<option value="Kentucky">Kentucky</option>
<option value="Louisiana">Louisiana</option>
<option value="Maine">Maine</option>
<option value="Maryland">Maryland</option>
<option value="Massachusetts">Massachusetts</option>
<option value="Michigan">Michigan</option>
<option value="Minnesota">Minnesota</option>
<option value="Mississippi">Mississippi</option>
<option value="Missori">Missori</option>
<option value="Montana">Montana</option>
<option value="Nebraska">Nebraska</option>
<option value="Nevada">Nevada</option>
<option value="New Hampshire">New Hampshire</option>
<option value="New Jersey">New Jersey</option>
<option value="New Mexico">New Mexico</option>
<option value="New York">New York</option>
<option value="North Carolina">North Carolina</option>
<option value="North Dakota">North Dakota</option>
<option value="Ohio">Ohio</option>
<option value="Oklahoma">Oklahoma</option>
<option value="Oregon">Oregon</option>
<option value="Pennsylvannia">Pennsylvannia</option>
<option value="Rhode Island">Rhode Island</option>
<option value="South Carolina">South Carolina</option>
<option value="South Dakota">South Dakota</option>
<option value="Tennessee">Tennessee</option>
<option value="Texas">Texas</option>
<option value="Utah">Utah</option>
<option value="Vermont">Vermont</option>
<option value="Virgina">Virgina</option>
<option value="Washington">Washington</option>
<option value="West Virginia">West Virginia</option>
<option value="Wisconsin">Wisconsin</option>
<option value="Wyoming">Wyoming</option>
</select><br><br>

Square feet: <input type="text" name="squarefeet" size="30"><br><br>

County: <input type="text" name="county" size="30"><br><br>

Subdivsion: <input type="text" name="subdivsion" size="30"><br><br>

Year built: <input type="text" name="yearbuilt" size="30"><br><br>

Description: <input type="text" name="description" size="30"><br><br>

Buy of Lease: <select name="buyorlease">
<option selected>--Pick one--</option>
<option value="buy">Buy</option>
<option value="lease">Lease</option>
</select><br><br>

Image name and type: <input type="text"name="imagepath"size="30"> <br><br>

Type of property: <select name="type">
<option selected>--Pick one--</option>
<option value="apartments">Apartments</option>
<option value="industrial">Industrial</option>
<option value="land">Land</option>
<option value="retail">Retail</option>
<option value="office space">Office Space</option>
</select><br><br>

Acreage (if applies): <input type="text" name="acreage" size="30">
<br><br>
<input type="submit" value="Submit">
</form>

<?php
}
?>


</body>
</html>

patheticcockroach - January 1, 2007 08:13 AM (GMT)
Rename CMS.html to CMS.php, otherwise the PHP code is not executed.

257335 - January 1, 2007 08:16 AM (GMT)
once again complete idiot

257335 - January 1, 2007 08:23 AM (GMT)
ok now we are getting somewhere. after ur tip on the fact that php code is not read made me realize why it was outputing what is was. after fixing it i get this
CODE

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\Documents and Settings\Marquis Taliaferro\Desktop\web page\Retail.php on line 42

257335 - January 1, 2007 08:35 AM (GMT)
ignore that last post




* Hosted for free by InvisionFree