PHP - Losing Part Of Querystring

I've inherited some PHP code that is trying to save a querystring to a variable:
 

$from_url = '';

if ((isset($_GET['from'])) && ($_GET['from'] != '')) { $from_url = $_GET['from']; }

The sample URL is: 

https://www.website.com/default.html?from=http://app.website.com/default.asp?utm_source=WelcomeEmail&utm_campaign=welcomeemail

What the code saves to $from_url is:

from=http://app.website.com/default.asp?utm_source=WelcomeEmail

It seems to stop at the "&" after the first querystring item and I understand why (because it parses the URL and runs into the next apostrophe "&" and assumes that it is not part of the "from" parameter).

How do I need to tweak the PHP code to have it save the entire querystring?

In other words, how do I take everything after ..."from=" (i.e. http://app.website.com/default.asp?utm_source=WelcomeEmail&utm_campaign=welcomeemail) and put it into a variable?

Greetings experts,

Please forgive me for this cheap question.

I have got a calendar of events and displays events for  7 departments.

For each department, we would like the calendar to display events specific to that department.

The way I am thinking about doing this is to grab the department from the url and compare it with the department on the db for which events is inserted into the db with.

If there is a match, then display the events for that department.

Something like:

    $tquery = "select * from ".$EVENTS_TB." where ".$EVENTS_TB.".month='".$smmonth."' and ".$EVENTS_TB.".year='".$smyear."' and ".$EVENTS_TB.".deptid='deptFromQueryString' " ;

The problem that I have is that I don't in php, how to capture the querystring from url.

For instance, assume this  is the url:

http://www.domain.com/departName.

DeparmentName represents the department value.

How do I capture the query above?

Thanks so much.

Anyone know how i can remove a querystring from url.

Example URL: http://www.mysite.com/?id=1

I am writing a script that needs to read in the ID from the URL. But once have got the information i would like to remove it from the URL and just display http://www.mysite.com but still be able to use the ID to query my database.

Any ideas???

Hi
        I have a problem i need some help with, when passing values from my Results page to my Details page through a URL is the Querystring different because i have INNER JOINED 2 tables? This is my Querystring

<a href="DetailsPet.php?id=<?php echo $row_ResultsRS['id']; ?>">Details</a></td>

i have 2 tables (petdata and customerdata) and there INNER JOINED using the 'id'

But its not passing on the values, and just shows the 1st results in database all the time. Im only just learning Php, but would i be right in thinking it to do with the 'id' as this is what joins the 2 tables. Do i have to state which 'id' to use? if so how do i do it?

Thanks willo

Hi,

how to let php read the url in folder form instead of querystring?

e.g.

www.example.com/index.php?post=123
www.example.com/post/123/

both is actually directed to the same page - index.php, but how to make it read like a folder when the physical path doesn't really exist?

the ultimate goal is to let the user select to date range (begin date in DD-MM and enddate in DD-MM), pass this through php file with ajax and query it against the registered date (stored as a datetime),

however i'm already running problems catching the values of minDate and maxDate. Can sombody tell me what's wrong please?

Code: [Select]
if (document.getElementById('brdat_dag').value != ''){
var minDag = document.getElementById('brdat_dag').value;}
if (document.getElementById('brdat_maand').value != ''){
var minMaand = document.getElementById('brdat_maand').value; }
var minDate = date ('Y-m-d H:i:s', mktime (0,0,0,minMaand,minDag.value,date('Y', time())));

var queryString = "?postcode=" + postcode + "&provincie=" + provincie + "&aland=" + aland + "&gland=" +gland +"&minAge=" + minAge +"&maxAge=" + maxAge + "&sex=" + sex; + [color=red]"&minDatum=" + minDatum;[/color]

Hi:

I am trying to pass/request a Variable/QueryString from one page to another, but it isn't working.

Seems like it would be simple, so maybe I am overlooking the obvious.

I have the 1st page:
Code: [Select]
<a href="NewCity.php?abbr_state=<?php echo $abbr_state ?>">Insert New City</a>

Writes the URL properly - CityList.php?abbr_state=CT

The 2nd page:
Code: [Select]
<?php

$abbr_state = $_REQUEST['abbr_state'];

?>


<form>

State: <input type="text" name="abbr_state" value="<?php echo $abbr_state; ?>" readonly=""/><br />

</form>

But it does not get the variable/QueryString for "CT" and add it to the form field (it's not the "readonly" causing it).

Why?

What did I miss?

Alright I know scraping is frowned upon.. but its for a client...  Anyways.. The below is supposed to form an array $kw for output. But its breaking on line 27:
Code: [Select]
  foreach ($kw as $keyword => $pages) 
Ive concluded my array is being broken and then formed into an empty string, but I can't figure out where it wen't wrong.

I want to say the trouble comes from lines 20-23:
Code: [Select]
  foreach($data as $temp) {
    $kx = text_between('"','"',$temp);
    if (is_array($kx)) $kw[key($kx)] = current($kx);
  }


The full version..

Code: [Select]
<?php
function text_between($start,$end,$string) {
  $keyword = '';
  if ($start != '') {$temp = explode($start,$string,2);} else {$temp = array('',$string);}
  $temp = @explode($end,$temp[1],2);
  $temp2 = @explode($end,$temp[1],3);
  $pages = (int)@str_replace(',','',$temp2[1]); 
  if ($pages) $keyword[$temp[0]] = $pages;
  return $keyword;
}

function gsscrape($keyword) {
  $keyword=str_replace(" ","+",$keyword);
  $keyword=str_replace("%20","+",$keyword);
  global $kw;
  $data=file_get_contents('http://clients1.google.com/complete/search?hl=en&gl=us&q='.$keyword);
  
  $data=explode('[',$data,3);
  $data=explode('],[',$data[2]);
  foreach($data as $temp) {
    $kx = text_between('"','"',$temp);
    if (is_array($kx)) $kw[key($kx)] = current($kx);
  }
}
#simple to use, just use yourscriptname.php?keywords
echo $_SERVER['QUERY_STRING'];
if ($_SERVER['QUERY_STRING']!='') {
  gsscrape($_SERVER['QUERY_STRING']);
  foreach ($kw as $keyword => $pages) {
      gsscrape($keyword);
  }
}
#all results are in array $kw...
echo "<pre>";
print_r($kw);
echo "</pre>";
?>

I am not sure If I am loosing my variable or if it is just getting cancelled out by the syntax.
The error I get is this:
Query string: "SELECT * FROM timeslip WHERE 1 and Initials=" ORDER BY "Date" ASC, "Cost" ASC
Failed with error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"SELECT * FROM timeslip WHERE 1 and Initials=" ORDER BY "Date" ASC, "Cost" ASC' at line 1

Initials should have the value of GEC at this moment

Here is my code:
$qry_str="SELECT * FROM timeslip WHERE 1 ";  

if($_POST['Initials']) 
{ 
   $Initials=$_POST['Initials'];  
   $qry_str.='and Initials="'.$Initials . '"'; 
} 

if($_POST['Identifier']) 
{ 
   $Identifier=$_POST['Identifier'];  
   $qry_str.='and Identifier LIKE "%'.$Identifier . '%"'; 
} 

if($_POST['Type']) 
{ 
   $Type=$_POST['Type'];  
   $qry_str.='and Type LIKE "%'.$Type . '%"'; 
} 
if($_POST['Terms']) 
{ 
   $Terms=$_POST['Terms'];  
   $qry_str.='and Terms LIKE "%'.$Terms . '%"'; 
} 
if($_POST['Memo']) 
{ 
   $Memo=$_POST['Memo'];  
   $qry_str.='and Memo LIKE "%'.$Memo . '%"'; 
}
if($_POST['date1']) 
{  
   $date1=$_POST['date1'];
   $date2=$_POST['date2'];
   $start=date('Y-m-d', strtotime($date1));
   $end=date('Y-m-d', strtotime($date2));
   $qry_str.="and Date >= $start and Date <= $end "; 
}
if($_POST['order1'] && $_POST['order2'])
{
$order1=$_POST['order1'];
$order2=$_POST['order2'];
$qry=$_POST['qry'];
$qry_str=' "'.$qry.'" ORDER BY "'.$order1 . '" ASC, "'.$order2 . '" ASC ';
}
elseif(isset($_POST['order1'])) {
     $order1=$_POST['order1'];
$qry=$_POST['qry'];
$qry_str='$qry ORDER BY $order1 ASC';
} else {
     if(isset($_POST['order2'])) {
          $order2=$_POST['order1'];
$qry=$_POST['qry'];
$qry_str='$qry ORDER BY $order2 ASC';
     }
}

if( !$result = mysql_query($qry_str) ) {
     echo "<br>Query string: $qry_str<br>Failed with error: " . mysql_error() . '<br>';  
}

I seem to be losing my array value when it comes to the "Game Time" section of my script. I am printing out the array a long the entire time and this is where I lose it and can't figure out why.
<form name="form1" method="post" action="">
<span class="whitetitle">How many teams?</span>
<ul class="pageitem">
            <li>
<SELECT name="teams"  onchange="document.form1.submit();">
             <option value="1">1</option>
                   <option value="2">2</option>
                   <option value="3">3</option>
                   <option value="4">4</option>
                   <option value="5">5</option>
                   <option value="6">6</option>
                   <option value="7">7</option>
                   <option value="8">8</option> 
                   <option value="9">9</option>
                   <option value="10">10</option>
                   <option value="11">11</option>
                   <option value="12">12</option>
             </SELECT>
                </li>
                </ul>
                </form>
        <?
if($_POST['teams'])
{
?>
<form  method="post" name="form2" action="">
 <span class="whitetitle">Team Name</span>
<?php
$teams=$_POST['teams'];
$count=0;
  while($count<$teams)
  {
  ?>
<ul class="pageitem">
<li class="bigfield">
            <input placeholder="Name" type="text" name="teamname[]"/>
            </li>
           </ul>
         <?
 $count++;
 }
 ?> 
         <input type="hidden" value="<?=$teams?>" name="teams" />
          <input type="submit" name="Submit" value="Next"> 
</form>    
<?
}
?>
        <?
if ($_POST['teamname'])
{
$teams=$_POST['teams'];
$teamname=$_POST['teamname'];
?>
        <form name="form" method="post" action="">
          <span class="name"><? print_r ($_POST['teamname']);?></span>
       <ul class="pageitem">
<li class="radiobutton"><span class="name">Season</span>
<input name="schedule" type="radio" value="season" onClick="this.form.action='';this.form.submit()" /></li>
<li class="radiobutton"><span class="name">Playoffs</span>
<input name="schedule" type="radio" value="playoffs" onClick="this.form.action='';this.form.submit()"/></li>
</ul>
        <input type="hidden" value="<?=$teams?>" name="teams" />
        <input type="hidden" value="<?=$teamname?>" name="teamname" />
        </form>
        <?
}
if($_POST['schedule'])
{
$teams=$_POST['teams'];
$schedule=$_POST['schedule'];
$teamname=$_POST['teamname'];
?>
        <form name="form4" method="post" action="">
         <span class="name"><? print_r ($_POST['teamname']);?></span>
        <span class="whitetitle">Games per Night</span>
<ul class="pageitem">
            <li>
<SELECT name="games" onchange="document.form4.submit();">
             <option value="1">1</option>
                   <option value="2">2</option>
                   <option value="3">3</option>
                   <option value="4">4</option>
                   <option value="5">5</option>
                   <option value="6">6</option>
                   <option value="7">7</option>
                   <option value="8">8</option> 
                   <option value="9">9</option>
                   <option value="10">10</option>
                   <option value="11">11</option>
                   <option value="12">12</option>
             </SELECT>
                </li>
                </ul>
                <input type="hidden" value="<?=$teamname?>" name="teamname" />
                <input type="hidden" value="<?=$teams?>" name="teams" />
                <input type="hidden" value="<?=$schedule?>" name="schedule" />
                </form>
             <?
}
if($_POST['games'])
{
$teams=$_POST['teams'];
$schedule=$_POST['schedule'];
$games=$_POST['games'];
$teamname=$_POST['teamname'];
$count=0;
 ?>
                <form name="form5" method="post" action="">
                  <span class="name"><? print_r ($_POST['teamname']);?></span>
             <span class="whitetitle">Times</span>
<ul class="pageitem">
        <?
while($count<$games)
{
?>
            <li>
<input placeholder="Times" type="text" name="times[]"/>
                </li>
          <?
  $count++;
}
  ?>
                </ul>
                 <input type="hidden" value="<?=$teamname?>" name="teamname" />
                 <input type="hidden" value="<?=$teams?>" name="teams" />
                <input type="hidden" value="<?=$schedule?>" name="schedule" />
                <input type="hidden" value="<?=$games?>" name="games" />
                <input type="submit" name="Submit" value="Next">
</form>
<?
}
if($_POST['times'])
{

echo $_POST['teams'];
print_r ($_POST['teamname']);
echo $_POST['schedule'];
echo $_POST['games'];
echo implode(",",$_POST['times']);
}
?>

Afternoon,

Not sure if i've been staring at the screen for too long or not, but have a log in script which saves the password as a session variable and I can pass that variable across my page like so:


<?php 
  session_start();
  //Print_r ($_SESSION);
  echo "Erm, I have reached page.php and the password is ".$_SESSION['password'];
?>


However, I want to make this secure, so I added a function to it which when you log in says if $_SESSION['password'] does not exist then send me away, like so:


<?php 
session_start();

function checklogin()
{
 session_start();
  if(!isset($_SESSION['password']))
{
       header("location: /index/");
       exit;
}
}

  checkLogin();
  Print_r ($_SESSION);
  echo "Erm, I have reached page.php and the password is ".$_SESSION['password'];
?>


However, using the function and a valid log-in it (as shown above) it chucks me out of the page even though $_SESSION['password'] exists?

Am I doing something really stupid here?

Thank you

Hey there,

Pretty frustrated with this. It seems so simple, but I've been staring at it and toying with it for ages, so I figured I'd post here. I have a variable called "$isTaken" that seems to be losing its value in an essential step in my function. Take a look.

function subdomainTaken($inputtedSubdomain)
{
//Initialize $isTaken to 'true'
$isTaken = true;
echo "isTaken STARTS AS: <i>" . $isTaken . "</i><br />"; //FOR TESTING PURPOSES ONLY. VARIABLE HAS VALUE HERE

//Check subdomain in database
$subdomainDBQuery = mysql_query("SELECT * FROM `companies` WHERE company_subdomain = '$inputtedSubdomain'");
$foundResult = mysql_num_rows($subdomainDBQuery);

if ($foundResult > 0) {
$isTaken = true;
} else {
$isTaken = false;
}
return $isTaken;
}


By the time I get to the if statement, $isTaken has no value. I've echoed it to be sure. Any ideas?

Thanks,
Frank

Hi everyone - I am trying to figure out how I can allow my logged in users to leave a php page and go to an html page without losing them as "currently logged in" - I have a site that is mixed with html and php pages and this is what I am needing: i have a user, they are logged in and are visiting a php page. then they want to go to another page(only logged in users can access the php page) - so they click on the html page they want to go to, great! - but then they want to visit another page that is a php page and requires them to be logged in in order to access it. How can i accomplish this without having them log in yet again? is this possible? i am using sessions.

I am trying to retain information from the $get variable after checking if a user, (Joomla code), is logged in but it is not working. (url: http://domain.com/script.php?file=data)

define( '_JEXEC', 1 );
define( 'DS', DIRECTORY_SEPARATOR );
define('JPATH_BASE', '/path/to/joomla/dir/');
require_once ( JPATH_BASE .DS.'includes'.DS.'defines.php' );
require_once ( JPATH_BASE .DS.'includes'.DS.'framework.php' );
$mainframe =& JFactory::getApplication('site');
$mainframe->initialise();
$session =& JFactory::getSession();
$user =& JFactory::getUser();
// get username and name of user
$username = $user->get('username');
$name = $user->get('name');
if (empty($username)) {
    die('Not logged in');
}
   $file = $_GET['file'];
   echo &file;
   exit;
Any help appreciated.