chriscloyd

April 3, 2012

What did you set your mysql date as? did you set it as date or varchar?

April 2, 2012

Then do this and see if it works

$Num = mysql_num_rows($result);
if ($Num == 0) {
     //code here
}

April 1, 2012

My Login Script is not working! Please someone help. I am typing in the correct email and password!

Mysql Table

Table - Users

email varchar 100

password varchar 256

form

action/members.php

<?php
session_start();
include("../config.inc.php");
include("../classes/class.action.php");
if ($_POST['login'] && $_POST['*****'] == '*****') {
$info = array();
$info['email'] = $_POST['email'];
$info['password'] = hash("sha256", $_POST['password']);
if ($Action->Login($info)) {
	$_SESSION['CPLoggedIn'] = $_POST['email'];
	header("Location: ../index.php");
} else {
	$Error[] = '- Please check you email and password!';
	$_SESSION['CPErrors'] = $Error;
	header("Location: ../index.php?action=LoginForm");
}
}

classes/class.actions.php

<?php
class Action {

var $Erros = array();

function Login($info) {
	foreach ($info as $key => $val) {
		if ($key = "password") {
			$$val = mysql_real_escape_string($val);
			$password = hash("sha256", $val);
			$values[$key] = $password;
		} else {
			$values[$key] = mysql_real_escape_string($val);
		}

	}

	$Sql = "SELECT * FROM Users WHERE email = '{$values['email']}' AND password = '{$values['password']}'";
	$Query = mysql_query($Sql);
	$Num = mysql_num_rows($Query);
	if ($Num > 0) {
		return true;
	} else {
		return false;
	}
}
}
$Action = new Action;

April 1, 2012

just do

<?php join(" ", $array);?>

March 31, 2012

what exactly are you trying to do?

do you know how to connect to a database and retrieve information?

March 30, 2012

do this

	if ($val == "")  $val = "NULL";

March 30, 2012

Okay well did you try the code i posted?

March 30, 2012

Question why are you putting () around your var?

Where are you setting the var $ids?

try this

<?php
$sqlout = mysql_query("SELECT * FROM `tblt` WHERE `UID` = '{$ids}'");
while ($sqlres = mysql_fetch_assoc($sqlout)) {
     //you can use assoc or array
     //I just like using assoc
}

Posted March 30, 2012 · March 30, 2012

<?php 
mysql_connect("localhost","root",""); 
mysql_select_db("test"); 
$username = mysql_real_escape_string($_POST['textfield']);
$query = mysql_query("SELECT * FROM memberdetails WHERE name = '{$username}' ");

while($result = mysql_fetch_assoc($query)) {
//display
echo $result['firstname'];
echo $result['surname'];
}
?>

March 30, 2012

Do you know how sites like YouTube or even Google Analytics does it? Surely, there must be a way that's fairly accurate.

Not really. You can have a single user that uses multiple IPs (work/home or gets a different IP from his provider) or you have have multiple users behind the same IP using NAT. So, using the IP address is not guaranteed. Using cookie is a little better, IMHO. But, you would get multiple hits if the same user views the same content on different machines. Also, a user could delete their cookies and that would incur an additional hit if they viewed the same content after deleting the cookie. And then there are those that set their browsers to not accept cookies which would generate a hit on every view since you wouldn't be able to set a cookie to exclude them in the future.

As scootstah a login system would probably be the most reliable, but even that isn't foolproof. A user could create another account and view the same content again, which would trigger another hit.

It all depends on exactly what you ar trying to ascertain from the data that should guide you in deciding the best method.

Couldn't you use the ip, if you give each person a unique session attached with with ip?

March 30, 2012

I dont know if this will work but there are two options you can do that works for me




<?php

session_start();

// dBase file

include "../admin/config.php";

$User = mysql_real_escape_string($_POST["username"]);

$Pass = mysql_real_escape_string($_POST['password']);

if ($User == '' || $Pass == '' ?) {

	die("You need to provide a username and password.");

} else {

	// Create query

	$q = "SELECT * FROM `nm_users` WHERE `username`='{$User}' AND `password`=PASSWORD('{$Pass}') LIMIT 1";

	// Run query

	$r = mysql_query($q);

	//you can do it two ways to make sure your even getting anything back

	$num = mysql_num_rows($r);

	if ($num > 0) {

		$obj = mysql_fetch_object($r);

		// Login good, create session variables

	  	$_SESSION["valid_id"] = $obj->id;

	  	$_SESSION["valid_user"] = $obj->username;

	  	$_SESSION["valid_time"] = time();


	  	// Redirect to member page

	 	Header("Location: members.php");

	} elseif ($r) {

		//or you can do this

		$obj = mysql_fetch_object($r);

		// Login good, create session variables

	  	$_SESSION["valid_id"] = $obj->id;

	  	$_SESSION["valid_user"] = $obj->username;

	  	$_SESSION["valid_time"] = time();


	  	// Redirect to member page

	 	Header("Location: members.php");

	} else {

	  	// Login not successful

	  	die("Sorry, could not log you in. Wrong login information.");

	}

}

 [/Code]

March 30, 2012

 

<?php

$users = $_POST['user'];

foreach ($users as $key => $val) {

	$sql = "INSERT INTO options (`item_id`, `option`) VALUES ('{$key}', '{$val}' )";

	$rs = mysql_query($sql) or die ("Problem with the query: {$sql} <br />" . mysql_error());

}

?>

[/Code]

March 30, 2012



$video = (isset($_GET['vid']) ? $_GET['vid'] : "video1");

include("includes/video{$video}.php");

[/Code]

March 30, 2012

create a mysql trigger

http://dev.mysql.com/doc/refman/5.1/en/create-trigger.html



delimiter |


CREATE TRIGGER orgid BEFORE INSERT ON `table`

  FOR EACH ROW BEGIN

  UPDATE `table` SET org_id = NEW.id;

  END;

|

[/Code]

March 30, 2012

Here create a new mysql table



CREATE TABLE IF NOT EXISTS `pageviews` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `pageid` int(11) NOT NULL,

  `user` varchar(100) NOT NULL,

  PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


[/Code]

Here is some php code that could help with your problem

[Code]
<?php
//top of your page
session_start();
if (!isset($_SESSION['user']) || !isset($_SESSION['guest'])) {
$ip = $_SERVER['REMOTE_ADDR'];
$time = date("Y-m-d H:i:s");
$guest = "{$ip}.{$time}";
$_SESSION['guest'] = $guest;
}
//define page id somehow
$pageid = '';
//now for you page update
//first check to see if they have view it or not
$User = (isset($_SESSION['user']) ? $_SESSION['user'] : $_SESSION['guest']);
$Sql = "SELECT * FROM pageviews WHERE user = '{$User}' AND pageid = '{$pageid}' ";
$Query = mysql_query($Sql);
$Num = mysql_num_rows($Query);
if ($Num < 1) {
mysql_query("UPDATE SET page
views=views+1
WHERE id=1")
or die(mysql_error());
}
?>
[/Code]

March 30, 2012

well a couple things you can do.

1. ) If the client is not logged in as a user, make a session that is unique like their ip address plus a current time stamp. so that way whatever they do while under guest they can be logged.

Table Views

vID int(11) primary auto

pageID int(11)

user varchar(100)

every time a user views it insert a new row into the table

but before you update the views check to see if the user has already viewed this page by taking that new session created for all guest and matching it up with the pageid of the page they are viewing and the user row

March 11, 2012

I do not get the error message and the login screen

March 11, 2012

I have a login form at

http://cloydprojects.com

you can login with

username: test

password test

If you login the script works correctly, but if you type in the wrong info my session is not showing here is that I have.

my login script

<?php
session_start();
?>
<link href="signUp.css" rel="stylesheet" type="text/css" />
<?php
include("db.php");
include("classes/class.account.php");
$Acc = new account;
$u = $Acc->clean($_REQUEST['usernameLogin']);
$password = $Acc->clean($_REQUEST['passwordLogin']);
$p = md5($password);
$get = mysql_query("SELECT * FROM users WHERE username = '".$u."' and password = '".$p."'");
$find = mysql_num_rows($get);
if ($find == 1) {
$info = mysql_fetch_assoc($get);
$_SESSION['LoggedIn'] = $info['uID'].'.'.$info['username'].'.'.$info['email'];
} else {
$_SESSION['LoggedFailed'] = '<div id="ErrorBox">Incorrect username/password!</div>';
} 
//there is more just not showing it

here is my index script where the error should be showing!

<div class="stylized">
<?php if(isset($_SESSION['LoggedIn'])) {
echo '<h1> Welcome! </h1>';
echo '<a href="logout.php">logout!</a>';
} else {
echo $_SESSION['LoggedFailed'];
session_destroy();
?>
    <form id="instantform" name="form" action="loginUser.php" method="post">

    <h1>Login</h1>
    
    <label>Username
    <span class="small">The username you created!</span></label>
    <input type="text" name="usernameLogin" id="usernameLogin" />
    
    <label>Password
    <span class="small">Case sensitive!</span></label>
    <input type="password" name="passwordLogin" id="passwordLogin" />
    
    <button type="submit">Login</button></div>
    <div class="spacer"></div>
    
    </form>
    <?php
}

?>
</div>

December 27, 2011

Found it out

<?php 
class page extends site {

var $newpage;

function getPage($page) {
	$this->newpage = $this->$page();
	echo $this->newpage;
}
function Contact() {
	echo '<h2>Contact</h2>';
	echo '<form>

	</form>';
}
function Who() {
	echo '<h2>Who?</h2>';
}

}

?>

December 27, 2011

can someone help me I am trying to call a class function using a varible.... example

say i go to index.php?page=contact i want to pull that class with out doing a switch statement can someone help me

<?php
$Site = page;
$Site->getPage($_GET['page']);
?>

<?php
class page extends site {

function getPage($page) {
	return $this->$page;	
}
function Contact() {
	echo '<h2>Contact test</h2>';
	echo '<form>

	</form>';
}

}
?>

November 24, 2011

Could it be that when it goes to the login page its starting a new one here my index.php

<?php

/**
* @author Chris Cloyd
* @copyright 2011
*/
/** Session Start For Users */
session_start();
/** Load Config */
include("load/config.php");
/** Load Class.Site and Class.Reminder */
include("load/class.site.php");
include("load/class.reminder.php");
include("load/class.users.php");
/** Start Classes */
$Site = new site();
$Reminder = new reminder();
$Users = new users();
/** Start Html by loading $Site->DisplayHeader(); */
$Site->DisplayHeader();
echo $Users->user;
/** Load Middle Content by loading $Site->DisplayContent(); */
if (isset($_GET['page'])) {
    $Site->DisplayContent($_GET['page']);
} else {
    $Site->DisplayContent('login');
}
/** End Html by loading $Site->DisplayFooter(); */
$Site->DisplayFooter();
?>

login.php

<?php

/**
* @author Chris Cloyd
* @copyright 2011
*/
/** Session Start For Users */
session_start();
/** Load Config */
include("../load/config.php");
/** Load Class.Site and Class.Reminder */
include("../load/class.site.php");
include("../load/class.reminder.php");
include("../load/class.users.php");
/** Start Classes */
$Site = new site();
$Reminder = new reminder();
$Users = new users();

$email = mysql_escape_string($_POST['emailLogin']);
$password = mysql_escape_string($_POST['passwordLogin']);
$password = md5($password);

$Search = mysql_query("SELECT * FROM users WHERE email = '".$email."' AND password = '".$password."' ");
$Found = mysql_num_rows($Search);
if ($Found > 0) {
    $UserInfo = mysql_fetch_assoc($Search);
    if ($UserInfo['status'] != 1) {
        $_SESSION['umadBroEmail'] = $email;
        header("Location: http://cloydprojects.com/index.php?page=activate");
    }
    $Users->LogIn($UserInfo['name'],$UserInfo['email'],$UserInfo['level']);
    echo $Users->user;
    $_SESSION['umadBro'] = $UserInfo['name'];
    //header("Location: http://cloydprojects.com/index.php?page=home");
} else {
    $_SESSION['umadBroError'] = 'Incorrect User Information, Try Again!';
    //header("Location: http://cloydprojects.com/index.php?page=login");
}

?>

November 24, 2011

so i know the users is working, but its not working inside the site class

here go to cloydprojects.com you can login and it wont change the links email - test@cloydprojects.com password - test

November 24, 2011

users Object ( [logged] => [user] => => [level] => )

November 24, 2011

i have two classes and I am trying to call one class in through another here is my code but my welcome is not showing at all ever when i change the var's to 1

class site {
     function DisplayContent ($page) {
        global $Users;
        echo '<div align="center">
                <div id="Header">
                <div id="NavBar">';
                if ($Users->logged == 1) {
                    echo 'Welcome '. $Users->user .' - <a href="?page=viewreminders">View Reminders</a> - <a href="?page=addreminder">Add Reminder</a> - <a href="logout.php" id="Logout">Logout</a>';
                } else {
                    echo '<a href="?page=login">Login</a> - <a href="?page=register">Register</a> - <a href="?page=forgotpassword">Forgot Password?</a>';
                }
        echo '</div>
            </div>
            <div id="Content">';
            $this->ShowPage($page);
            echo '</div>
            <div id="Footer">Copyright © '.date('Y').'<br />
            Coded and Designed by Chris Cloyd</div>
        </div>';
     }
}

class users {
    
    var $logged;
    var $user;
    var $email;
    var $level;
    
    function LogIn ($name,$email,$level) {
        $this->logged =  1;
        $this->user = $name;
        $this->email = $email;
        $this->level = $level;
    }
    
    function LogOut () {
        $this->logged =  "0";
        $this->user = "";
        $this->email = "";
        $this->level = "";
    }
    
}

November 15, 2011

<html>
<head>
	<title>Login</title>
</head>
<body>
	<hr />
	<form method="post" action="">
		<label>Username:</label>
		<input type="text" name="username">
		<br />
		<label>Password:</label>
		<input type="password" name="password">
		<p>
			<input type="submit" value="Login" name="Login" />
			<input type="reset" value="Reset" name="Reset" />
		</p>

	</form>
<?php
//if username/password filled in and submitted, check db to find match login info
if(array_key_exists("Login",$_POST) && !empty($_POST["username"]) && !empty($_POST["password"])) {
	$attemptedUsername=$_POST["username"];
	$attemptedPassword=crypt($_POST["password"]);

	mysql_connect("localhost","root");
    mysql_select_db("db");

	$getLoginInfoQuery=mysql_query("SELECT userName,userPassword FROM users WHERE userName='$attemptedUsername' AND userPassword='$attemptedPassword'");
	$getLoginInfo=mysql_fetch_assoc($getLoginInfoQuery);
	$getUsername=$getLoginInfo["userName"];
	$getPassword=$getLoginInfo["userPassword"];

	if($attemptedPassword==$getPassword) {
		session_start();//NB: Start session BEFORE doing any session stuff!
		$_SESSION["isAuthenticated"]="userAuthenticated";
		header("Location: SecureSite.php");
		exit;
	}
	else//"Please register above!"
		print "Please register above!";
}
?>
</body>
</html>

Sign In

chriscloyd

Posts

Joined

Last visited

Content Type

Profiles

Forums

Posts posted by chriscloyd

Convert form inputs for date into a mysql date format

Can't update database

Login Script Not Working

post with arrays

get data from database in checkbox form

Parsing error problem

slight sql problem

slight sql problem

get user details from mysql database using php?

How do I fix this...?

PHP Login Not working?

array posting

Simple isset($_GET)

Copy an auto-increment value to another field

How do I fix this...?

How do I fix this...?

php session not echoing

php session not echoing

calling a class function with var

calling a class function with var

class global

class global

class global

class global

Login help

Browse

Activity

Important Information