[How do I reset a column in a table in my database every x days?]

Ok thanks, that works!

[How do I reset a column in a table in my database every x days?]

I am a PHP beginner.

 

Every x days (every 7 days for example), I would like all the values in a certain column in my MySQL database to reset back to '1'. How do I do this?

 

Please note: My web host does NOT have the MySQL event scheduler enabled  so that is not an option. Also, my web hosting plan does not allow me to do cronjobs so that is not option either. Any other ideas?

Thanks!

[Not sure what is wrong with these IF statements]

Thanks for your reply.

 

The problem was that I had defined $qotw further down the page AFTER these statements. I realized that I have to define it BEFORE these statements, and now it is working fine.

 

Thanks!

[Not sure what is wrong with these IF statements]

I'm a PHP beginner - I'm not sure what is wrong with this code.

 

The problem:

When $qotw is equal to 1 or when it is equal to 2, neither statement is being executed (see code below). I am not getting any errors.
 

What I tried:

I tried putting if($qotw = '1') instead of if(qotw == '1') and if(qotw = '2') instead of if(qotw == '2'). In that case the 'cash' increased as it was supposed to. However, when $qotw was equal to 2, the first statement still executed and the second one did not (the 'cash' value was still increasing and the message that should be displayed according to the 2nd IF statement did not show up). The 'cash' value and 'qotw' value should only increase when $qotw is equal to 1.

Please help me fix this so that BOTH statements will execute at the appropriate times. Thanks!

Here is my code:

<?php
$con=mysqli_connect("localhost","users","password","users");
// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }

//statement1
if($qotw = '1')
{
mysqli_query($con,"UPDATE users SET cash = cash + $scash
WHERE username = '". $_SESSION['username'] . "'");
mysqli_query($con,"UPDATE users SET qotw = 1 + qotw
WHERE username = '". $_SESSION['username'] . "'");
}
//statement2
if($qotw = '2')
{
echo "You have already attempted this question.";
}

mysqli_close($con);
?>

[Echo username after login]

Thank you! That worked!

 

 

I literally JUST started learning PHP yesterday so I'm sorry if you were frustrated by my lack of understanding. Anyways, thanks for your patience.

[Echo username after login]

Thanks for your quick reply.

 

The login.php script attempts to validate the user and the membership.php script (I posted it above) creates a session by authorizing the user using mysql.php (also posted above) which matches the username/password with one stored in the database.

 

I basically got the whole thing from a tutorial I watched which explains everything (if I'm not very clear about it). Here it is: http://code.tutsplus.com/articles/how-to-build-a-login-system-for-a-simple-website--net-2853

This is the download link for the code: http://cdn.tutsplus.com/net/uploads/legacy/192_loginSystem/membershipSite.zip

 

I've created a registration system and everything else, so all I need to do now is learn how to echo the username

 

 

Thanks

[Echo username after login]

Sorry, I'm just a beginner (high school student) and I'm not sure how to do that. Could you please give an example?

 

Do I just add this line anywhere in the index.php script? (I don't think $response is a global variable).

echo $response

Thanks!

[Echo username after login]

I'm just a beginner with PHP. I created a PHP login system. Now I want to echo the username to the logged in user on the index.php page.

Here's the code I have so far. It would be great if someone could suggest a way of doing this. Thanks!

 

login.php

<?php
session_start();
require_once 'classes/Membership.php';
$membership = new Membership();

// If the user clicks the "Log Out" link on the index page.
if(isset($_GET['status']) && $_GET['status'] == 'loggedout') {
	$membership->log_User_Out();
}

// Did the user enter a password/username and click submit?
if($_POST && !empty($_POST['username']) && !empty($_POST['pwd'])) {
	$response = $membership->validate_User($_POST['username'], $_POST['pwd']);
}
														
?>


<!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>Login</title>
<link rel="stylesheet" type="text/css" href="css/default.css" />
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.1/jquery.min.js"></script>
<script type="text/javascript" src="js/main.js"></script>
</head>

<body>
<div id="login">
	<form method="post" action="">
    	<h2>Login <small>enter your credentials</small></h2>
        <p>
        	<label for="username">Username: </label>
            <input type="text" name="username" />
        </p>
        
        <p>
        	<label for="pwd">Password: </label>
            <input type="password" name="pwd" />
        </p>
        
        <p>
        	<input type="submit" id="submit" value="Login" name="submit" />
        </p>
    </form>
    <?php if(isset($response)) echo "<h4 class='alert'>" . $response . "</h4>"; ?>
</div><!--end login-->
</body>
</html>

index.php (the page that the user is redirected to after logging in)

<?php
require_once 'classes/Membership.php';
$membership = New Membership();

$membership->confirm_Member();	

?>

<!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" />
<link rel="stylesheet" href="css/default.css" />

<!--[if lt IE 7]>
<script type="text/javascript" src="js/DD_belatedPNG_0.0.7a-min.js"></script>
<![endif]-->


<title>Untitled Document</title>



</head>

<body>

<div id="container">
	<p>
    	You have logged in.
    </p>
    <a href="login.php?status=loggedout">Log Out</a>
</div><!--end container-->

</body>
</html>

membership.php

<?php

require 'Mysql.php';

class Membership {
	
	function validate_user($un, $pwd) {
		$mysql = New Mysql();
		$ensure_credentials = $mysql->verify_Username_and_Pass($un, md5($pwd));
		
		if($ensure_credentials) {
			$_SESSION['status'] = 'authorized';
			header("location: index.php");
		} else return "Please enter a correct username and password";
		
	} 
	
	function log_User_Out() {
		if(isset($_SESSION['status'])) {
			unset($_SESSION['status']);
			
			if(isset($_COOKIE[session_name()])) 
				setcookie(session_name(), '', time() - 1000);
				session_destroy();
		}
	}
	
	function confirm_Member() {
		session_start();
		if($_SESSION['status'] !='authorized') header("location: login.php");
	}
	
}

mysql.php

<?php

require_once 'includes/constants.php';

class Mysql {
	private $conn;
	
	function __construct() {
		$this->conn = new mysqli(DB_SERVER, DB_USER, DB_PASSWORD, DB_NAME) or 
					  die('There was a problem connecting to the database.');
	}
	
	function verify_Username_and_Pass($un, $pwd) {
				
		$query = "SELECT *
				FROM users
				WHERE username = ? AND password = ?
				LIMIT 1";
				
		if($stmt = $this->conn->prepare($query)) {
			$stmt->bind_param('ss', $un, $pwd);
			$stmt->execute();
			
			if($stmt->fetch()) {
				$stmt->close();
				return true;
			}
		}
		
	}
}

Thanks a lot!