PHP - Hyperlink/querystring Problem

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.

I am working with a fellow who runs an eCommerce shop. The transaction resolution comes in on a querystring.   I do not yet know what web server software is being used, nor if any security appliance/software is installed.   One of the values in the querystring starts with the @ character.   We know the web server gets this as there entries in the web server's access log that shows thing value is present.   It is not available in PHP's $_GET array.   We are trying to get an idea of where this value, and it's key, is getting discarded.   Is there a known problem with (actual server software being used not yet known) web server software discarding a key/value if the value has the @ character in the querystring?    

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

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,

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?

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?

Hey guys

Just a quick question:

How to embed hyperlink into a database cell?

Basically I echo out a table on the user interface of my site

and there's an URL in one of the cells

I want the user to access it by clicking on it, without copying and pasting the URL into the URL bar of the browser

I tried updating the cell in phpmyadmin using <a href = http://www.example.com>http://www.example.com</a> but didn't work out, the resulting cell only had the text format

Any help would be appreciated

Thanks.

Hi there, im trying to echo a hyperlink and parse a url parameter. Its not quite working as iam getting T-string error. If someone with fresh eyes could quickly glance for me that would be ace.

Code: [Select]
<?php if ($row_ship['PlayerName'] == '$_SESSION['MM_Username']'){ 
echo '<a href="ship_edit.php?recordID='.$row_Ship['ShipID'].'">Edit</a>';} ?>
Thank You

I have searched this forum and haven't found a solution to my question. please don't flame...

I am trying to send a table field from one page to another. the field i'm sending is id.

I have managed to populate the field updateplayer.php?id=*****

now i have a syntax error trying to get the field to show up on the update player form.

Parse error: syntax error, unexpected T_VARIABLE in /home/netman13/public_html/bccsl.org/managers/updateplayer.php on line 7

The id field is supposed to get the id variable from the previous page ?id=*****

Here is the update player code:


Code: [Select]
<?php 
include 'dbc.php';


$qP = "SELECT * FROM players WHERE id =  '$_GET['$id']' ";
$rsP = mysql_query($qP);
$row = mysql_fetch_array($rsP);
extract($row);
$id = trim($id);
$first = trim($first);
$last = trim($last);
$address = trim($address);
$city = trim($city);
$postal = trim($postal);
$phone = trim($phone);
$feet = trim($feet);
$inches = trim($inches);
$weight = trim($weight);
$birth = trim($birth);
$status = trim($status);
$number = trim($number);



mysql_close();

?>

<!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>Update Player</title>
<link href="styles.css" rel="stylesheet" type="text/css">
<script language="JavaScript" type="text/javascript" src="js/jquery-1.3.2.min.js"></script>
<script language="JavaScript" type="text/javascript" src="js/jquery.validate.js"></script>
<script>
  $(document).ready(function(){
    $.validator.addMethod("username", function(value, element) {
        return this.optional(element) || /^[a-z0-9\_]+$/i.test(value);
    }, "Username must contain only letters, numbers, or underscore.");

    $("#regForm").validate();
  });
  </script>

</head>

<body>

<script language="JavaScript">
<!--

/***********************************************
* Required field(s) validation v1.10- By NavSurf
* Visit Nav Surf at http://navsurf.com
* Visit http://www.dynamicdrive.com/ for full source code
***********************************************/

function formCheck(formobj){
// Enter name of mandatory fields
var fieldRequired = Array("first", "last", "address", "city", "postal", "phone", "hft", "hinch", "weight", "birthdate", "status");
// Enter field description to appear in the dialog box
var fieldDescription = Array("First Name", "Last Name", "Address", "City", "Postal Code", "Phone Number", "Feet", "Inches", "Weight", "Birthdate YYYY/MM/DD", "Player Status");
// dialog message
var alertMsg = "Please complete the following fields:\n";

var l_Msg = alertMsg.length;

for (var i = 0; i < fieldRequired.length; i++){
var obj = formobj.elements[fieldRequired[i]];
if (obj){
switch(obj.type){
case "select-one":
if (obj.selectedIndex == -1 || obj.options[obj.selectedIndex].text == ""){
alertMsg += " - " + fieldDescription[i] + "\n";
}
break;
case "select-multiple":
if (obj.selectedIndex == -1){
alertMsg += " - " + fieldDescription[i] + "\n";
}
break;
case "text":
case "textarea":
if (obj.value == "" || obj.value == null){
alertMsg += " - " + fieldDescription[i] + "\n";
}
break;
default:
}
if (obj.type == undefined){
var blnchecked = false;
for (var j = 0; j < obj.length; j++){
if (obj[j].checked){
blnchecked = true;
}
}
if (!blnchecked){
alertMsg += " - " + fieldDescription[i] + "\n";
}
}
}
}

if (alertMsg.length == l_Msg){
return true;
}else{
alert(alertMsg);
return false;
}
}
// -->
</script>

<table width="100%" border="0" cellpadding="5" cellspacing="0"class="main" >
  <tr>
    <td colspan="1"><p></p></td>
  </tr>
  <tr>
    <td width="17%"><?
 //Call Menu
include 'menu.php';

?></td>
    <td width="3%">&nbsp;</td>
    <td width="80%"><p align="center">Update Player Information</p>
      <p align="center"><?
      if (isset($_GET['msg'])) {
  echo "<div class=\"msg\">$_GET[msg]</div>";
  }
  ?></p>
      <p align="center">&nbsp;</p>
      <form action="playerupdate.php" method="post" enctype="multipart/form-data" name="form" id="form" onsubmit="return formCheck(this);">
        <table width="653" border="0" align="center" cellpadding="0" cellspacing="0">
          <tr>
            <td width="148" height="29">First Name</td>
            <td width="153"><label>
              <input name="first" type="text" disabled="disabled" class="required" id="first" value="<?=$first ?>"  />
            </label></td>
            <td width="91" height="30">Last Name</td>
            <td width="261"><label>
              <input name="last" type="text" class="required" id="last" value="<?=$last ?>" readonly="readonly"  />
            </label></td>
          </tr>
          <tr>
            <td height="30">Address</td>
            <td><input name="address" type="text" class="required" id="address" value="<?=$address ?>"  /></td>
            <td>City</td>
            <td><label>
              <input name="city" type="text" class="required" id="city" value="<?=$city ?>"  />
            </label></td>
          </tr>
          <tr>
            <td height="28">Postal Code</td>
            <td><label>
              <input name="postal" type="text" class="required" id="postal" value="<?=$postal ?>" size="12"  />
            </label></td>
            <td>Phone Number</td>
            <td><label>
              <input name="phone" type="text" class="required" id="phone" value="<?=$phone ?>" size="13"  />
            </label></td>
          </tr>
          <tr>
            <td height="29">Height <strong>(ft / in)</strong></td>
            <td><label>
              <input name="feet" type="text" class="required" id="feet" value="<?=$feet ?>" size="3"  />
/
<input name="inches" type="text" class="required" id="inches" value="<?=$inches ?>" size="3"  />
</label></td>
            <td>Weight (lbs)</td>
            <td><input name="weight" type="text" class="required" id="weight" value="<?=$weight ?>" size="5"  /></td>
          </tr>
          <tr>
            <td height="35">Birthdate <strong>(yyyy/mm/dd)</strong></td>
            <td><label>
              <input name="birth" type="text" class="required" id="birth" value="<?=$birth ?>" size="13" readonly="readonly" />
            </label></td>
            <td><label>Player Type:</label></td>
            <td><p>
              <label>
                <input name="status" type="radio" id="type_0" value="1" checked="checked" />
                Church</label>
              <br />
              <label>
                <input type="radio" name="status" value="2" id="type_1" />
                Import</label>
              <br />
              <label>
                <input type="radio" name="status" value="3" id="type_2" />
                Witness</label>
              <br />
            </p>
              <label></label></td>
          </tr>
          <tr>
            <td height="35">Player ID:</td>
            <td><input name="id" type="text" id="id" value="<?=$id ?>" readonly="readonly" /></td>
            <td>Player Number:</td>
            <td><input name="number" type="text" class="required" id="number" value="<?=$number ?>" size="5"  /></td>
          </tr>
          <tr>
            <td height="29">&nbsp;</td>
            <td><label></label></td>
            <td><p>
              <input name="teamid" type="hidden" id="teamid" value="<? echo $_SESSION['teamid'];?>" />
              <input name="division" type="hidden" id="division" value="<? echo $_SESSION['divisionid'];?>" />
             
             
  <input type="hidden" name="currentdate" size=11 >
             
             
             
  </p>
              <p>
                <input name="teamname" type="hidden" id="teamname" value="<? echo $_SESSION['team_name'];?>" />
              </p>
              <p>
                <script>

/*Current date in form credit:
JavaScript Kit (www.javascriptkit.com)
Over 200+ free scripts here!
*/

var mydate=new Date()
var theyear=mydate.getYear()
if (theyear < 1000)
theyear+=1900
var theday=mydate.getDay()
var themonth=mydate.getMonth()+1
if (themonth<10)
themonth="0"+themonth
var theday=mydate.getDate()
if (theday<10)
theday="0"+theday

//////EDIT below three variable to customize the format of the date/////

var displayfirst=theyear
var displaysecond=themonth
var displaythird=theday

////////////////////////////////////

document.form.currentdate.value=displayfirst+"/"+displaysecond+"/"+displaythird
</script>
               
                <input name="approved" type="hidden" id="approved" value="0" />
            </p></td>
            <td>&nbsp;</td>
          </tr>
        </table>
<p align="center">
              <label>
              <input type="submit" name="submit2" id="submit2" value="Submit" />
              </label>
              <label>
              <input type="reset" name="reset2" id="reset2" value="Clear" />
              </label>
</p>
      </form>
      <p align="center">&nbsp;</p>
      <p align="center">
        <label></label>
    </p></td>
  </tr>
  <tr>
    <td colspan="3">&nbsp;</td>
  </tr>
</table>
<p>&nbsp;</p>
</body>
</html>

Thanks for your help.

This forum has been an awesome resource for me.

I am having problems with a line of code.  This is what I have so far.  I am missing a "," according to my error message.  Im trading in deep water with this line of code.  I am trying to use the data from my echo state to be a hyperlink...  If that makes sense.

Code: [Select]
echo "\t" . '<td><a href="' . APP_ROOT . 'onlinebanking/viewtransactions.php">. $account['BankAccountID'] . </a>' '</td>' . "\n";

Hello im wondering how i can make a hyperlinks adress be a set after a variable.
this is my php:

$result1 = mysql_query("SELECT id, namn, url FROM stuff ORDER BY id desc limit 1;");
$result2 = mysql_query("SELECT id, namn, url FROM stuff ORDER BY id desc limit 1,1;");

<html>
<a href="???"> <p class="note-general"> The first link </p>
<a href="???"> <p class="note-general"> The the second link </p>
</html>

The important thing is that the url from $result1 will link under "the first link" and url from $result2 link under "the second link".

Hello Everyone.

Im new here, but hopefully you can help me

I have designed a CMS using PHP and MySQL. Its fairly basic, I'll talk you thorugh the stages:

1.) The user inputs their product information into a form and the script uploads it to the database giving it a unique ID.
2.) The user is then asked to upload a big image for that product, the image is added to a folder on the server.
3.) Now the user must choose a thumbnail and it uploads in the same manner.

My problem is linking the two together...
So far I have this:


<?php 

$images = "products/"; 
$big    = "big/"; 
$cols   = 2;  

if ($handle = opendir($images)) { 
   while (false !== ($file = readdir($handle))) { 
       if ($file != "." && $file != ".." && $file != rtrim($big,"/")) { 
           $files[] = $file; 
       } 
   } 
   closedir($handle); 
} 

$colCtr = 0; 

echo '<table width="212" cellpadding="2"><tr>'; 

foreach($files as $file) 
{ 
  if($colCtr %$cols == 0) 
    echo '</tr><tr><td colspan="2"></td></tr><tr>'; 
  echo '<td wdith=50% align="center"><a href="' . $images . $big . $file . '"><img border="0" class="gradualfader" src="' . $images . $file . '" /></a></td>'; 
  $colCtr++; 
} 

echo '</table>' . "\r\n"; 

?>


This displays a lovely list of thumbnails, which when clicked opens the larger image. What i would like to do is insert a "ID" for each image so the product data can be grabbed from the database ?

I think i've explained this well enough? reply if not and illl try and add more detail.

To see it in action you can go to http://design.surreylabs.co.uk/parliament/2/products.php

Thanks in Advance!

I am using xampp.
 

<a href="/">Home Page</a>

The above code (when clicked in browser) takes me to the localhost instead of localhost/website   How can i clear this issue?

The $_SESSION['record_to_chage'] variable is set- I know this as I can echo it out.

$openedfile = file("myfile.txt");
sort($openedfile);
//
foreach($openedfile as $key => $newpick)
{
echo "<a href=\"/editpage.php?request=$_SESSION['record_to_chgange']&newcat=$newpick\" target=\"_parent\">$newpick</a>";
echo "<br>";
}

The Resulting error:
Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in

For the life of me I can not figure where I am going wrong. 

Going to get coffee and some fresh eyes.

Cheers

Can someone tell me why this gives me undefined variables?  The $id variable is showing up fine in this bit of code.  When I click the link it is supposed to pull the data from the database related to the $id.

Code: [Select]
<a href='javascript: window.document.Vids<?php echo $id; ?>.submit();'>Watch</a>
<form name="Vids<?php echo $id; ?>" action="<?php echo $PHP_SELF; ?>" method="post">
<input value="<?php echo $id; ?>" type="hidden" name="Vids" />
</form>

here is the code which is supposed to display the info.

Code: [Select]
if (isset($_POST['Vids']))
{
$result = mysqli_query($link, "SELECT * FROM vidaud where id =".$_POST['Vids']);
echo $id;

the error i get is Quote


Notice: Undefined variable: id in /services5/webpages/util/b/b/bbctech2.site.aplus.net/public/dbsite/a_newsite/sermons.php on line 32



I'm just not sure why the $id variable isn't being posted by my form and read by the code.  Thanks.