[RESOLVED] plz help

[dayo]

Hiya i need a page were a user goes to that page they are then redirected to there personal web page, i need this done using there member ID so if there id was 1 they would be re directed to mysite/1.php and ID 2 would be re directed to mysite/2.php. any help would be fantastic.

Thanx,
Dayo

[djjjozsi]

and what you have done ?

-user's table
-user login
-a field in user's table to store an url where he/she will redirected.

and that was just an example? ID 1 goes to 1.php , ID 2 goes to 2.php ?

Hello, jjozsi

[dayo]

djjjozsi;10899379 wrote:

and what you have done ?

-user's table
-user login
-a field in user's table to store an url where he/she will redirected.

and that was just an example? ID 1 goes to 1.php , ID 2 goes to 2.php ?

Hello, jjozsi

-user's table - Yes
-user login - Yes
-a field in user's table to store an url where he/she will redirected. - no that would be a good idea thanks alot 😃, im still a rookie tho. so i ay come back for some help.

[dayo]

right i have changed my idea ui now want them to enter a 4 digit pin number for them to gain acsess i want it so they gfo to mysite.php they then enter there pin each digit in a seperat feild im still a newb when it comes to php so any help w2riting the script would be great.

also there is a seperate table for there pin and url to re direct to columns are pin1,pin2,pin3,pin4,mysite

[NOJ75]

I am no PHP guru but if you have the ID value then this should work:

$userid = (int) $_REQUEST['userid'];

header("Location: http://yoursite.com/".$userid.".php");
exit(); 

But someone else may have a better idea. Good luck !!

[NOJ75]

Sorry, just saw the post you done as I was writing the last one!

[dayo]

lol thanks anyway ill put this into my site till i can get the pin

[dayo]

i have this so far, can some one help me finish it

<?php
	//Start session
	session_start();

//Include database connection details
require_once('config.php');

//Array to store validation errors
$errmsg_arr = array();

//Validation error flag
$errflag = false;

//Connect to mysql server
$link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
if(!$link) {
	die('Failed to connect to server: ' . mysql_error());
}

//Select database
$db = mysql_select_db(DB_DATABASE);
if(!$db) {
	die("Unable to select database");
}

//Function to sanitize values received from the form. Prevents SQL injection
function clean($str) {
	$str = @trim($str);
	if(get_magic_quotes_gpc()) {
		$str = stripslashes($str);
	}
	return mysql_real_escape_string($str);
}

//Sanitize the POST values
$pin1 = clean($_POST['pin1']);
$pin2 = clean($_POST['pin2']);
$pin3 = clean($_POST['pin3']);
$pin4 = clean($_POST['pin4']);

//Input Validations
if($pin1 == '') {
	$errmsg_arr[] = 'Pin 1 is missing';
	$errflag = true;
}
if($pin2 == '') {
	$errmsg_arr[] = 'Pin 2 is missing';
	$errflag = true;
}
if($pin3 == '') {
	$errmsg_arr[] = 'Pin 3 is missing';
	$errflag = true;
}
if($pin4 == '') {
	$errmsg_arr[] = 'Pin 4 is missing';
	$errflag = true;
}

//Create query
	$qry="SELECT * FROM mysite

UPDATED
i just tryed to finish could you tell me where im going wrong i have only just started php 5 days ago so soz if its bad all i get is Query failed

<?php
	//Start session
	session_start();

//Include database connection details
require_once('../config.php');

//Array to store validation errors
$errmsg_arr = array();

//Validation error flag
$errflag = false;

//Connect to mysql server
$link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
if(!$link) {
	die('Failed to connect to server: ' . mysql_error());
}

//Select database
$db = mysql_select_db(DB_DATABASE);
if(!$db) {
	die("Unable to select database");
}

//Function to sanitize values received from the form. Prevents SQL injection
function clean($str) {
	$str = @trim($str);
	if(get_magic_quotes_gpc()) {
		$str = stripslashes($str);
	}
	return mysql_real_escape_string($str);
}

//Sanitize the POST values
$pin1 = clean($_POST['pin1']);
$pin2 = clean($_POST['pin2']);
$pin3 = clean($_POST['pin3']);
$pin4 = clean($_POST['pin4']);

//Input Validations
if($pin1 == '') {
	$errmsg_arr[] = 'Pin 1 is missing';
	$errflag = true;
}
if($pin2 == '') {
	$errmsg_arr[] = 'Pin 2 is missing';
	$errflag = true;
}
if($pin3 == '') {
	$errmsg_arr[] = 'Pin 3 is missing';
	$errflag = true;
}
if($pin4 == '') {
	$errmsg_arr[] = 'Pin 4 is missing';
	$errflag = true;
}


//Create query
$qry="SELECT * FROM mysite WHERE pin1='$pin1' AND pin2='$pin2' AND pin3='$pin3' AND pin4='$pin4'";
$result=mysql_query($qry);

//Check whether the query was successful or not
if($result) {
	if(mysql_num_rows($result) == 1) {
		//Pin Successful
		$mysite = (int) $_REQUEST['mysite'];

header("Location: mysite".$userid.".php");
exit(); 
		}else {
			//Pin failed
			header("location: mysite.php");
			exit();
		}
	}else {
		die("Query failed");
	}
?>

[djjjozsi]

just for the test, use this method:

$result=mysql_query($qry) or die("query error: ". mysql_error());

Then you will see what is the problem with that query, a table name, a field name might be the mistake.
Before you run a query in php, try it in phpmyadmin.
in your code $userid looks like an undefined index!

but!
if i were your visitor, i will quess the sitenames.
After i hit the right pin codes,
set to me a SESSION variable with that site ID!
Then check on evry pages, that site ID (that value comes from the databse) has enabled in the visitor's session. If not, header location back !

[dayo]

thank you i shall finish that today when i get to school

[dayo]

i get

query error: Query was empty

from it

also $userid was ment to be $mysite

[dayo]

im using this code now i have done it so they have to enter in there pin and there site ID, it will redirect them to $siteid.php

to stop people just going 1.php or 2.php the id is a number folowed by 4 random letters.

<?php
	//Start session
	session_start();

//Include database connection details
require_once('../config.php');

//Array to store validation errors
$errmsg_arr = array();

//Validation error flag
$errflag = false;

//Connect to mysql server
$link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
if(!$link) {
	die('Failed to connect to server: ' . mysql_error());
}

//Select database
$db = mysql_select_db(DB_DATABASE);
if(!$db) {
	die("Unable to select database");
}

//Function to sanitize values received from the form. Prevents SQL injection
function clean($str) {
	$str = @trim($str);
	if(get_magic_quotes_gpc()) {
		$str = stripslashes($str);
	}
	return mysql_real_escape_string($str);
}

//Sanitize the POST values
$pin1 = clean($_POST['pin1']);
$pin2 = clean($_POST['pin2']);
$pin3 = clean($_POST['pin3']);
$pin4 = clean($_POST['pin4']);
$siteid = clean($_POST['siteid']);


//Input Validations
if($pin1 == '') {
	$errmsg_arr[] = 'Pin 1 is missing';
	$errflag = true;
}
if($pin2 == '') {
	$errmsg_arr[] = 'Pin 2 is missing';
	$errflag = true;
}
if($pin3 == '') {
	$errmsg_arr[] = 'Pin 3 is missing';
	$errflag = true;
}
if($pin4 == '') {
	$errmsg_arr[] = 'Pin 4 is missing';
	$errflag = true;
}
if($siteid == '') {
	$errmsg_arr[] = 'Site ID is missing';
	$errflag = true;
}

//Create query
$qry="SELECT * FROM Mysite WHERE pin1='$pin1' AND pin2='$pin2' AND pin3='$pin3' AND pin4='$pin4' AND siteid='$siteid'";
$result=mysql_query($qry);

//Check whether the query was successful or not
if($result) {
	if(mysql_num_rows($result) == 1) {
		//Pin Successful
		header("Location: mysite/".$siteid.".php");

exit(); 
		}else {
			//Pin failed
			header("location: mysite.php");
			exit();
		}
	}else {
		die("Query failed");
	}
?>

[dayo]

ive just added an admin panel to it so i can make pin numbers and site ids fast thank for all the help this is now resolved