PHP - Moved: Redirect Based On Query Param Values

Hi,

I'm trying to get a working php script that will redirect visitors based on a number of variables. I first want to check the country the visitor is from, and redirect based on the user's country ip address.

If visitor is not from the US, then go to google.com (for example)... but only after also checking some other variables. I want to also redirect any user (including US visitors) who are using a mobile device browser/cell phone, and redirect visitors coming from a Linux box.

I'm not sure how to add those as if/else statement. Any help would be appreciated. Here's what I have so far...

Geo ip Redirect:
-------------------
<?php

require_once("GeoIP.inc");

$gi = geoip_open("GeoIP.dat",GEOIP_STANDARD);

$country_code = geoip_country_code_by_addr($gi, $_SERVER['REMOTE_ADDR']);

geoip_close($gi);

if($country_code == 'US')
{
        header('Location: http://www.google.com');
}
else { 
header("Location: http://www.redirect.com");
}
?>

Mobile Browser Redirect:
------------------------------
require_once('mobile_device_detect.php');
mobile_device_detect(true,false,true,true,true,true,true,'http://redirect.com',false);


So not sure how to detect and redirect Linux users, and then how to link these all together in one script so it checks all variables before sending user to destination URL.

Hope you can help. I really appreciate it!

Greetings gurus,

I need some help, please.

I have a classic ASP background and now trying to get my feet wet with php.

We have a web app that is used by several depts.

I have been told to modify the app so that user is redirected to a site specific to their dept.

For instance, if we have say, 3 deppts, HR, IT, and Payroll; if a user who belongs to the Payroll dept logs into the system, s/he will be redirected to PayRoll section of the page.

I have done this tons of times using asp.

Below is the code I used for asp:

Code: [Select]
'Page = validateUser.asp

SQL ="SELECT * FROM users " _
      & " WHERE Username = '" & Request.Form("txtUserid") & "'" _
      & " AND password = '" & Request.Form("TxtPassword") & "' "

Set objRS = objConn.Execute( SQL )


  If Not objRS.EOF Then
    If objRS("password") = Request.Form("txtPassword") Then
      Session.Contents("access_level") = objRS("access_level")
      Session.Contents("userID") = objRS("userID") 'ID column
      Session("username") = objRS("username")
      Session("password") = objRS("password")

      access_level = CInt(Session("access_level"))
      username = CStr(Session("username"))


       Select Case access_level
         Case 1
           Response.Redirect "HRPage.asp"
         Case 2
           Response.Redirect "PayrollPage.asp"
         Case 3
           Response.Redirect "ITPage.asp"
         Case Else
          Response.Redirect "default.asp"
       End Select
    Else
      Response.Write "Sorry, but the password that you entered is incorrect."
    End If
  Else
    Response.Write "Sorry, but the username that you entered does not exist."
  End If
  objRS.Close
  Set objRS = Nothing
  objConn.Close
  Set objConn = Nothing

Then on each page, I would do the check before redirecting the user:

Code: [Select]
If Session.Contents("access_level") <> 1 AND _
 Session.Contents("access_level") <> 2 AND _
 Session.Contents("access_level") Then
   Response.Redirect "default.asp"
 End If

How I can use similar code in php?

I hope you can assist me.

Thanks very much

Hi, can anyone help me?   I am trying to create a form which asks the user to input their postcode then submit. the purpose is so if the service my site offers is not available in the location that the end user lives, then I want to display a message saying 'Sorry, not available', but if they are in area then it redirects to another page.   My form code is:

<form method="post" action="forwarder.php">
    <p> Enter Post Code He <input type = "text" name = "zip" id = "zip" size = "10" maxlength = "5" ">
	<input type='submit'>
    </form>

My PHP is:

<?php
$zip = isset ($_POST['zip'])  { 
  if ($zip=='NG15') { 
    header('Location: https://www.bing.com');
} else { 
  	header('Location: http://www.google.co.uk')
}



?>

I am a bit of a newbie at this, and I know my PHP won't give me my desired result, but I was using this to try and test the concept. Help would be really appreciated, and if you can show me how to do it for multiple postcodes even better

Hoping someone can help.

I have a file, say bounce.php that uses php url ramdomizer, like this:

<?php
$urls = array("link1",
                      "link2");
$url = $urls[array_rand($urls)];
header("Location: http://$url");
?> 

What I want is to only allow that code to execute if the user is coming from another php page on the same sever/folder.  So like this....

So bounce.php will check where the traffic is coming from.....if traffic is coming from page1.php (file on same server) then it will allow URL REDIRECT CODE to execute, if traffic is coming from another source, such as google.com, or from no referel, then person is sent to another site, say msn.com.

Hi. I am trying to create a very simple admin login page that will let only me access a number of pages. I am trying the following code for the login page:

Code: [Select]
<?php session_start();

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

if ($_POST['txtUsername'] == $username && $_POST['txtPassword'] == $password)
{ $_SESSION['admin']="true"; 
 header("location: admin.php");
}
?>

### HTML code and form for entering in username and password with action echoing it back to itself ###
On  the admin.php page i then try:

Code: [Select]
<?php 
if ($_SESSION['admin'] != "true") 
{ header("location: login.php");}
else { ?>


### code for the rest of the page ###
I am fairly new to all this and cant understand why its remaining on the login page and not sending me to admin.php when the password and username are correct. Is this the correct way to be going about it? I envisaged simply adding the above code to the top of any page only the admin could see. Any help is much appreciated.

Hi

This should be pretty simple but I can't figure it out. 

 

I want to create and simple forward to different URL based on the user entry.

 

For example..

If they enter ABC in the box they go to www.11.com

if they enter ZXC in the box they go to www.22.com

if they enter CCC they go to www.33.com

If they enter anything else they get an error message.

 

Thanks for any help!!

 

 

Hello, This is what I'm trying to-do. I have an index.php file I would like a bit of code that says

"If you got here from www.websitea.com (or a link within that site) OR www.websiteb.com"
do this :
else
do this:

I'm just not sure how to check where they're coming from.
so basically if your on google.ca and you goto the site it will exicute the else part of the code
but if your already on sitea or b and you click a link it will not

Hi,

I have an array filled with values like this:

Code: [Select]
string(1) "Acer 1"
string(2) "Acer 2"
string(3) "Dell 1"
string(4) "Dell 2"
string(5) "Dell 3"
string(6) "Dell 4"
string(7) "Acer 3"
string(8) "Acer 4"
Is there a way to successfully remove all array strings that starts with a given value like "Acer"?

I tried with this snippet, does not work:

Code: [Select]
foreach($array as &$value) {

  if(preg_match("/^Acer/", $value)) {
  unset($value);
} }

Any ideas will be appreciated!

I am trying to get rows from MYSQL table (attachment) based on:

Select last five rows where status_id = 1 Select last two rows where status_id = 2

*I did use UNION with two SELECT queries to get whole data as one array.

Now on PHP side...

I have first block for rows having status_id 1 so if there are rows having status_id 1 then PHP should display the data otherwise if there is no row having status_id 1 then PHP should print NO DATA only once.

I have second block for rows having status_id 2 so if there are rows having status_id 2 then PHP should display the data otherwise if there is no row having status_id 2 then PHP should print NO DATA only once.

I did use foreach loop then within loop i did use if condition to check status_id of rows. it works fine when i omit NO DATA part but when i add it. the result shows both rows and NO DATA in first block when there are one or more rows having status_id 1 but no row having status_id 2

Which made me believe that i was doing it the wrong way.

Please guide me

*PS: I know its PHP section the thread should be related to PHP problem but... is it right to use UNION in query? or should i post a new thread in relevant section for guidance?

When i click my submit button i am posting the following.

		Array
(
    [submitStaffOrder] => 
    [staffMember] => Array
        (
            [0] => 2
            [1] => ANYCHEF1
        )

    [date] => Array
        (
            [0] => 2020-02-18
            [1] => 2020-02-18
        )

    [startTime] => Array
        (
            [0] => 11:01
            [1] => 10:10
        )

    [finishTime] => Array
        (
            [0] => 11:01
            [1] => 10:01
        )

    [delExisting] => Array
        (
            [0] => 
            [1] => toDel
        )

)

I would like to update/insert if delExisting is blank and delete if it has toDel in there.

I have the following but i am pretty sure the if is not working.

$date = $_POST['date'];
	$stime = $_POST['startTime'];
	$ftime = $_POST['finishTime'];
	$del = $_POST['delExisting'];
	$staff = $_POST['staffMember'];

$stmt = $conn -> prepare("
	                         INSERT IGNORE INTO ssm_staff_order (job_id, staff_id, staff_start_time, staff_finish_time, staff_start_date, staff_finish_date) 
	                         VALUES (?,?,?,?,?,?)
	                         ON DUPLICATE KEY 
	                         UPDATE 
	                         staff_start_time = VALUES(staff_start_time),
	                         staff_finish_time = VALUES(staff_finish_time);
	                         ");

	$delstmt = $conn -> prepare("
		                         DELETE FROM ssm_staff_order
		                         WHERE staff_id = ?
		                         AND job_id = ?
		                         AND staff_start_date = ?
		                         ");

	foreach ($staff as $key => $staffId) {
		if ($del == '') {
			$start = $date[$key].' '.$stime[$key];
			$finish = $date[$key].' '.$ftime[$key];
			$stmt -> bind_param('isssss', $jid, $staffId, $start, $finish, $date[$key], $date[$key]);
			$stmt -> execute();
		}
		

		
		if ($del == 'toDel') {
			$delstmt -> bind_param('sis', $staffId, $jid, $date[$key]);
			$delstmt -> execute();
		}
	}
	
}

Can i do what i am trying to do or am i way off here?

 

I struggle with arrays

Edited February 24, 2020 by Adamhumbug

Hi,   I am a bit of a MYSQL newbie so please bear with me. I have a database created about football/soccer stats. The database at the moment contains the following tables but more maybe added:   Players Clubs Seasons Competitions   I will create php pages for these tables that add, edit and delete records for each. But the problem I can't get my head around is how to add a record that uses data from other tables, for example we would add a...   player -> club-season-competition   Lets say we want create a player called 'Joe Bloggs' and want to add his details, we need somehow for the page to display an option for club, season and competition. Maybe they can be drop down boxes but how does one fill those drop down boxes with records that are already added in the database for each table?   Thanks

  $username = $_POST['uid'];
  $email = $_POST['mail'];
  $password = $_POST['pwd'];
  $passwordRepeat = $_POST['pwd-repeat'];
  $date = $_POST['date2'];
  $stream = $_POST['relationship'];

		$sql1 = "INSERT INTO users (uidUsers, emailUsers, pwdUsers, relationship) VALUES (?, ?, ?, ?);";
		$sql2 = "INSERT INTO Family1 (username, application_filed, relationship) VALUES (?, ?, ?);";
		$sql3 = "INSERT INTO Family2 (username, application_filed, relationship) VALUES (?, ?, ?);";
		mysqli_query($sql1, $conn);
		mysqli_query($sql2, $conn);
		mysqli_query($sql3, $conn);
		
   $stmt = mysqli_stmt_init($conn);
		if (!mysqli_stmt_prepare($stmt, $sql2)) {
          header("Location: ../signup.php?error=sqlerror");
          exit();
        }
		        else {

          mysqli_stmt_bind_param($stmt, "sss", $username, $date, $stream);
          $result = mysqli_stmt_get_result($stmt);
		  if ($row = mysqli_fetch_assoc($result))
		  ($username==$_SESSION['uid'] and $stream =='nursing');
			mysqli_stmt_execute($stmt);
		}
		
		if (!mysqli_stmt_prepare($stmt, $sql3)) {
          header("Location: ../signup.php?error=sqlerror");
          exit();
        }
		        else {

          mysqli_stmt_bind_param($stmt, "sss", $username, $date, $stream);
          $result = mysqli_stmt_get_result($stmt);
		  if ($row = mysqli_fetch_assoc($result))
		  ($username==$_SESSION['uid'] and $stream =='doctoral');
			mysqli_stmt_execute($stmt);
		}
		
        if (!mysqli_stmt_prepare($stmt, $sql1)) {
          header("Location: ../signup.php?error=sqlerror");
          exit();
        }

 if (!mysqli_stmt_prepare($stmt, $sql1)) {
          header("Location: ../signup.php?error=sqlerror");
          exit();
        }
        else {
          $hashedPwd = password_hash($password, PASSWORD_DEFAULT);
          mysqli_stmt_bind_param($stmt, "ssss", $username, $email, $hashedPwd, $stream);
          mysqli_stmt_execute($stmt);
          header("Location: ../signup.php?signup=success");
          exit();

I was wondering if someone could point me in the right direction. I have this code. They idea I had behind it is to insert values into different tables depending on variables being passed. 

So when user fills out a form and selects $stream="nursing" I want results to go to table 'users' and 'Family1', but not 'Family2' table. and if user selects $stream='doctoral' results should go to table 'users' and  'Family2', and not go to 'Family1'

But with my query I get results go to both table and also users table. And there is no restriction to what users selects, variable $stream being passed no matter what it is.

Is this the wrong way to go here? Did I completely mess up the logic?

I have 3 tables w/ the following fields:

Cities
id | state_id | city_name

States
id | state_name

New_cities
id | state_id | city_name

I am trying to write a script (and still working on it) that will INSERT new cities in cities WHERE New_cities.state_id = Cities.state_id.

Obviously I am still in testing and results sort out, but honest to all hell, I might be going about this all wrong, and would appreciate any comments, criticism, assistance or feedback on what I am trying to do.

<?php
  $query = "SELECT * FROM cities, states, new_cities";
  if ($results = mysqli_query($cxn, $query)) {
      $row_cnt = mysqli_num_rows($results);
      echo $row_cnt . " Total Records in Query.<br /><br />";
      if (mysqli_num_rows($results)) {
          while ($row = mysqli_fetch_array($results)) {
              if ($row['cities']['state_id'] == $row['new_cities']['new_state_id']) {
                  $insert_city_query = "INSERT INTO cities id, new_state_id, city_name VALUES
('','$new_state_id','$city_name')" or mysqli_error();
              } //if ($row['cities']['state_id'] == $row['new_cities']['new_state_id'])
              echo "$row[new_city_name]<br />";
          } //while ($row = mysqli_fetch_array($results))
      } //if (mysqli_num_rows($results))
  } //if ($results = mysqli_query($cxn, $query))
?>

Hi!

Can anyone please help me form script for doing a MySQL query based on variables in a bbcode?

BBCode could be like this: [datatype::dataid]

Explode datatype and dataid intro separate strings and using them in querys.

Example of string containing bbcodes:
Code: [Select]
$body = "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi fringilla, enim eget dictum sodales, enim velit iaculis dolor, sed congue orci diam id ipsum. Integer ullamcorper elit ac arcu condimentum id elementum arcu tempus. Ut aliquam commodo eros, mollis tristique magna adipiscing eu.
[video::3456]
Duis congue turpis quis eros porta eu sollicitudin mi porttitor. Ut ac nisi id risus imperdiet aliquet. Suspendisse lacinia sem id ipsum blandit egestas. Mauris id vulputate ligula. In in quam urna. Nam purus augue, laoreet vel sodales nec, rutrum non augue.
[video::6789]
Phasellus facilisis commodo arcu, vel dapibus tortor pretium eu. Integer elit nisi, condimentum ut vehicula eget, ullamcorper non quam. Nullam suscipit tempor consequat. Vestibulum sollicitudin ante tristique neque vestibulum a fermentum nulla venenatis. In eget nulla nulla.";
I found something close he
http://stackoverflow.com/questions/2801228/php-bbcode-with-sql-selection