password protected pages

[rishirajsingh]

I want to create password protected pages where administrator can login and check details of request of products. I am currently using the following script.

<?php

// Define your username and password
$username = "username";
$password = "password";

if ($_POST['txtUsername'] != $username || $_POST['txtPassword'] != $password) {

?>

<h1>Login</h1>

<form name="form" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
    <p><label for="txtUsername">Username:</label>
    <br /><input type="text" title="Enter your Username" name="txtUsername" /></p>

<p><label for="txtpassword">Password:</label>
<br /><input type="password" title="Enter your password" name="txtPassword" /></p>

<p><input type="submit" name="Submit" value="Login" /></p>

</form>

<?php

}
else {

?>

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

mysql_select_db("indiamar_rishi", $con);

$result = mysql_query('SELECT * FROM `order` LIMIT 0, 30 ');

echo "<table border='1'>
<tr>
<th>Project Name</th>
<th>Project Description</th>
<th>Contact Person</th>
<th>Contact Email</th>
<th>Contact number</th>
<th>Company Name</th>
<th>Country</th>

</tr>";

while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $row['txtprojectname'] . "</td>";
  echo "<td>" . $row['txtdescription'] . "</td>";
echo "<td>" . $row['txtname'] . "</td>";
echo "<td>" . $row['txtemail'] . "</td>";
echo "<td>" . $row['txtphone1'] . "</td>";
echo "<td>" . $row['txtcompany'] . "</td>";
echo "<td>" . $row['txtcountry'] . "</td>";
  echo "</tr>";
  }

echo "</table>";

mysql_close($con);
?>

<?php

}

?> 

now i want to add extra features like admin can sort results by "submitted yesterday, last 7days, all time" first 50results, 50-100 results, back and next button"

I don't think all this is possible with this script cause it will ask for password again and again.

so please suggest any suitable script or logic that can help me.
I would prefer If I can display results with all features on same page.
I don't mind reading any topic or script related to this. I an newbie but I can edit the codes as per my requirement.

[rulian]

you can use session variables to keep the user logged in after their first successful login.

<?PHP 
session_start();
if (!isset($_SESSION["authUser"])) $_SESSION["authUser"] = false; 
 if ((isset($_POST['txtUsername'])) && (isset($_POST['txtPassword')))
{
if (($_POST['txtUsername'] == 'Username') && ($_POST['txtPassword'] == 'password'))
{
$_SESSION["authUser"]=true; 
}
}

if ($_SESSION["authUser"] !== true)
{
?>
<h1>Login</h1>

<form name="form" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
    <p><label for="txtUsername">Username:</label>
    <br /><input type="text" title="Enter your Username" name="txtUsername" /></p>

<p><label for="txtpassword">Password:</label>
<br /><input type="password" title="Enter your password" name="txtPassword" /></p>

<p><input type="submit" name="Submit" value="Login" /></p>

</form>
<?PHP
}

else 
{
$con = mysql_connect("192.168.2.7", "dbname", "password");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("indiamar_rishi", $con);

$result = mysql_query('SELECT * FROM `order` LIMIT 0, 30 ');

echo "<table border='1'>
<tr>
<th>Project Name</th>
<th>Project Description</th>
<th>Contact Person</th>
<th>Contact Email</th>
<th>Contact number</th>
<th>Company Name</th>
<th>Country</th>

</tr>";

while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $row['txtprojectname'] . "</td>";
  echo "<td>" . $row['txtdescription'] . "</td>";
echo "<td>" . $row['txtname'] . "</td>";
echo "<td>" . $row['txtemail'] . "</td>";
echo "<td>" . $row['txtphone1'] . "</td>";
echo "<td>" . $row['txtcompany'] . "</td>";
echo "<td>" . $row['txtcountry'] . "</td>";
  echo "</tr>";
  }

echo "</table>";

mysql_close($con);


}

?> 

then to log out, all you need to do is

<?PHP if (isset($_GET["&logout"])) $_SESSION["authUser"] = false; ?>

[rishirajsingh]

thanks rulian,
Once again you helped me.

i want to add features like admin can sort results by "submitted yesterday, last 7days, all time" first 50results, 50-100 results, back and next button"

What would be the best practice to do that?
I have made a form with calendar that can take the from and too date value and display data according to it.
How can i create button for next 50, previous 50, and links like
Page 1 2 3 4 5 6 7 8 9 10

[rulian]

Well, the easiest way it to use the WHERE, LIMIT and SORT features in mysql,
since you're limiting rows returned based on a date field you can do
//// for yesterday
SELECT
FROM table
WHERE DATE(mydatefield) = DATE_SUB( CURDATE( ) , INTERVAL 1
DAY)
/// for a week
SELECT
FROM table
WHERE DATE(mydatefield) = DATE_SUB( CURDATE( ) , INTERVAL 1
WEEK)
/// for all
SELECT * FROM table

to work the next/back and interval buttons you have to do a little bit of math
the problem is if you do
SELECT * from foo LIMIT 50, even if there are 500 rows that match, a mysql_num_rows($query) would return 50, so you couldnt get a count or rows
the easiest but least practical way of doing this is to run 1 query that returns all the rows, and limit the number of rows displayed in the PHP

so if you have something like

$query=mysql_query("SELECT * from foo WHERE DATE(mydate) = DATE_SUB(CURDATE(), INTERVAL 1 WEEK) ");

lets say that returned 403 rows, which you want to display 50 at a time. Set default limit variable and do the math to dvide them into pages and display accordingly.

$results=mysql_num_rows($query);
$increments=50;
if (!isset($GET["show"])) $display=0;
else $display=$GET["show"];
$pages=ceil($results/ $increments); // that will give you the least number of pages you need to display to display them all
so on your links for pages you do href="page.php?show=".($page * $increment);

so when do iterate through your rows, you simply show only rows starting at $display to $display + $increment;

[rishirajsingh]

thanks rulian,
Now its working for me.