Advertisement
Advertisement
| 09.04.2008 at 03:56AM PDT, ID: 23702099 |
|
[x]
Attachment Details
|
||
|
[x]
The Solution Rating System
|
||
With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.
Your Input Matters If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support. Thank you! |
||
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: 29: 30: 31: 32: 33: 34: 35: 36: 37: 38: 39: 40: 41: 42: 43: 44: 45: 46: 47: 48: 49: 50: 51: 52: 53: 54: 55: 56: 57: 58: 59: 60: |
--login_check.php--
<?php
session_start();
$host="centos5"; // Host name
$username="*****"; // Mysql username
$password="******"; // Mysql password
$db_name="CSDb"; // Database name
$tbl_name="users"; // Table name
// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
// username and password sent from form
if($_POST){
$_SESSION['username']=$_POST['myusername'];
$_SESSION['password']=$_POST['mypassword'];
}
$_SESSION['name']=mysql_fetch_assoc('Name');
// To protect MySQL injection (more detail about MySQL injection)
$myusername = stripslashes($myusername);
$mypassword = stripslashes($mypassword);
$myusername = mysql_real_escape_string($myusername);
$mypassword = mysql_real_escape_string($mypassword);
$sql="select * from users
where Login='" . $_SESSION['username'] . "' and Password='" . $_SESSION['password'] . "'";
$result=mysql_query($sql);
// Mysql_num_row is counting table row
$count=mysql_num_rows($result);
// If result matched $myusername and $mypassword, table row must be 1 row
if($count==1){
// Register $myusername, $mypassword and redirect to file
session_register("myusername");
session_register("mypassword");
session_register("myname");
header("location:main.php");
}
else {
echo "Wrong Username or Password";
}
?>
--main.php
<?
session_start();
if(!session_is_registered(myusername,mypassword)){
header("location:login.php");
}
?>
......rest of code........ Do I then need to make sure the users name is relayed as a session and then <? echo.. $name ?> ???
|
