PHP - Passing Var

hey guys
i am  stuck at one part. i am coding a site where on the index page there are 5 categories. Now on click of these it takes me to a page where i can search within a particular category. i can do it by statically giving <href="localhost/xampp/abc.php">and a fixed page path. but i want the name of the category passed when i click and the search page to open when i open search.


thanks

i am sending a mail  to user (user's email is stored in $email)
in body i have written code
$message =" <a href='http://www.example.com/thankyou.php?email=".$email."'>click here to join</a> ";

now i need this content to be stored in database and has to be retreived and append it to body like
$message =$body_from_db;

if i check it in mail. the corresponding value of $email is not coming . pls help guys.

//i've been looking at this same code for two whole days now and ive changed it lots of times but it can only get worse
//i can't pass the value of the variable $today which has a date datatype
//this is the part where i get the value of $today
<?php
$query="SELECT DISTINCT today FROM arrastre order by today desc";
$result=mysql_query($query);
while($row=mysql_fetch_object($result)){
$today=$row->today;
echo "<option value=$today>$today</option>";
}
?>
//here's is the part where i use $today to get $tcl
//except for a major problem that when the while loop returns more than one $tcl, i get more than one button, but that's not the problem because that is how it's supposed to work. The problem is that when there are more than one buttons, only the last button would work, the only button that displays values
<?php
if(isset($_POST['godate'])){
$today=$_POST['today'];
$query="SELECT DISTINCT tcl FROM arrastre WHERE today='$today' ORDER BY tcl ASC";
$result=mysql_query($query);
while($row=mysql_fetch_array($result)){
$tcl=$row['tcl'];
$today=$row['today'];
?>
<input type="hidden" name="tcl" value="<?php echo $tcl;?>">
<input type=submit name="tcl" value="<?php echo $tcl; ?>">
<?php } }
?>

//thsi is another problem
if(isset($_POST['tcl'])){
$tcl=$_POST['tcl'];
$today=$_POST['today'];
$query = "select * from arrastre where tcl=$tcl and today='$today' order by tcl asc";
$result = mysql_query($query);
$totalcollections = 0;
while($row=mysql_fetch_array($result)){
$orno=$row['orno'];
$billnmbr=$row['billnmbr'];
$payor=$row['payor'];
$arrastre=$row['arrastre'];
$wharfage=$row['wharfage'];
$total=$row['total'];
$today=$row['today'];
//*i deleted the display part to make this shorter a little
}}
//the $today variable is empty in this post and i have no idea how to successfully pass this value
so i could use it in my $query
//thanks for your time

I'm a newbie here and to php and Javascript.  So hello all.

I am trying to get a portion of a file name passed from one file (first.php) which displays a MySql table.  One of the fields is a link that is supposed to open a popup window (second.php) and begin playing a mp3 file with the flash media player.

I have everything (almost) working.  The table displays as it should, the link is fine.  However, I can not get the popup to open with the dimensions I asked for.  It opens in a full size new window.  And the mp3 will not play.  I get the message from the player "we are unable to connect...etc  etc".  The file name shows up in the status bar and in the URL window.

In the file first.php, the table displays, the links appear to be active.  when clicked the new window opens, the file names carry over but I can not get the file to play.  The player loads (in file second.php) but I get the message from the player "we are unable to connect...etc  etc".

I suspect it is in the syntax.  I have tried so many combinations I can't list them here and so far I have been unable to find anything on google, etc to answer this.  After almost three days I have resorted to here.  This may not even be the right place for me.  Javascript may be my best bet for all I know.

Can someone please look over what I have and at least point me in the right direction?
Any help is greatly appreciated as this is my first attempt at a website.
Thanks


first.php

Code: [Select]
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">


<html>
<head>

<script language="JavaScript">
<!-- Begin
function popUp(URL) {

playwindow=window.open(URL, 'name', 'toolbar=0,scrollbars=1,location=1,statusbar=1,menubar=0,resizable=1,width=350,height=250');
}
// End -->
</script>

<script language="JavaScript">
<!--
function openPlayer(URL) {
player = window.open('player10.php?','width=350,height=275')
}
// End -->
</script>



<?php
$username="myusername";
$password="mypassword";
$database="mydb";


mysql_connect('mydb',$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM mytable";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();
?>


</head>
<body>
<table border="1" cellspacing="2" cellpadding="2">
<tr>
<th><font face="Arial, Helvetica, sans-serif">Listen</font></th>
<th><font face="Arial, Helvetica, sans-serif">f2</font></th>
<th><font face="Arial, Helvetica, sans-serif">f3</font></th>
<th><font face="Arial, Helvetica, sans-serif">f4</font></th>
<th><font face="Arial, Helvetica, sans-serif">f5</font></th>
<th><font face="Arial, Helvetica, sans-serif">f6</font></th>
</tr>

<?php
$i=0;
while ($i < $num) {

$f1=mysql_result($result,$i,"listen");
$f2=mysql_result($result,$i,"field2");
$f3=mysql_result($result,$i,"field3");
$f4=mysql_result($result,$i,"field4");
$f5=mysql_result($result,$i,"field5");
$f6=mysql_result($result,$i,"field6");
?>

<tr>
<td><font face="Arial, Helvetica, sans-serif"><a href="javascript:openPlayer('player10.php?<?php echo $f1?>')">Listen</a></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f2; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f3; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f4; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f5; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f6; ?></font></td>
</tr>

<?php
$i++;
}
?>
</body>
</html>


SECOND.PHP

Code: [Select]
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">

     
<head>         
  <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" >   
  <meta http-equiv="X-UA-Compatible" content="IE=8" >         
  <title>My Title             
  </title>             
  <link rel="shortcut icon" type="image/x-icon" href="/favicon.ico" >         
     

 <script language="JavaScript" type="text/javascript">
<!--
    //
    // Make sure there's some data
    //
if (location.search) {
        //
        // Extract the name of the graphics file
        //
    var mp3_filename = location.search.substring(1)
        //
        // Write the &ltIMG> tag using the name of the graphics
        // file (you may need to adjust the SRC text)
        //
 document.write('<a href="http://mywebsite.com/+mp3_filename">')
    }
//   End  -->
</script>



</head>                 
<body>
 
<object width="400" height="300">
  <param name="movie" value="http://fpdownload.adobe.com/strobe/FlashMediaPlayback.swf">
  </param>
  <param name="flashvars" value="src=http%3A%2F%2Fmywebsite.com%2Faudio%2F+mp3_filename">
  </param>
 
 
  <param name="allowFullScreen" value="true">
  </param>
  <param name="allowscriptaccess" value="always">
  </param>
  <embed src="http://fpdownload.adobe.com/strobe/FlashMediaPlayback.swf" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="400" height="300" flashvars="src=http%3A%2F%2Fmywebsite.com%2Faudio%2F+mp3_filename">
  </embed>
</object>

</body>
 </html>

I'm an hour worth of searches into this. It's 2:30. I just want some nice person to give me the answer.

I'm trying to pass a variable using href to another page. It works great if the variable is only one word. But it only passes the first word. There are multiple posts on this topic, but I can't seem to get any of those fixes to work for me.

Here the code.
Code: [Select]
<?php
$query = "select DISTINCT city from daily where open_bid>0 order by city ASC";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
$details='';
$details.='<li class="menu"><span class="name"><a href=list.php?city='.$row['city'].'>'.$row['city'].'</a>';
$details.='</li>';
echo($details);
}
?>

As you can imagine, some cities names are made up of two words. This is only passing the first word.

Thanks for your help.

I'm creating this URL to pass variables to use from one Page to another:   http://eg10basketbal...Borgman&team=16     My WP site is seeing the first variable but not the second.  After some searching I've found this suggestion, but it's not working for me:

function add_query_vars_filter( $vars ) {

	$vars[] = "nameFull";
	$vars[] = "team";

	return $vars;
}
add_filter( 'query_vars', 'add_query_vars_filter' );

I tried putting this in the wp-includes/functions.php file of the, but ended up with a fatal error.  I have since added it to my theme's functions.php file. There isn't an error, but it doesn't yield recognition of my second variable.     

I have the following code that outputs a url. It searches my MySQL database for the name of a given item within a theme:


$relative = 'http://www.domain.com/wp-content/';
$url1= $relative . 'themes/arjuna-x/itemspec.php?type=';
$url2='&item=';

<a class="entry-thumbnails-link" href="<?php echo $url1.'Themes'.$url2.$rowThemes['Theme']; ?>">

The output is as follows:
http://www.domain.com/wp-content/themes/arjuna-x/itemspec.php?type=Themes&item=(insert variable here)

All is good up to this point.

My problem however, is that some items (in this case: theme names) have apostrophes in them. For example: April Fool's.

This results in breaking my php code.

How can I get php to call these variables with apostrophes so that they don't break my php?

<?php
$opid = $_GET['opid'];

$sql="Select * from `ships` WHERE `enabled` = 'Yes'";
$result = mysql_query($sql) or die (mysql_error());
echo "<form action=main.php?id=joinop.php&opid=".$opid." method=post> 
Ship Type: <select name = ship>";
while ($row = mysql_fetch_array($result)) {
echo "<option Value=".rawurlencode($row['shiptype']).">".$row['shiptype']."</option>";
}
echo "</select>
<input name=submit type=submit value=Join>
</form>";

if (isset($_POST['submit']))
{
$stype = rawurldecode($_Post['ship']);
$stime = date("G:i:s",time());
$sql="Select * from `ships` WHERE `shiptype` = '$stype'";
$result = mysql_query($sql) or die (mysql_error());
while ($row = mysql_fetch_array($result)) {
$weight = $row['weight'];
}
echo $stype;
mysql_query ("INSERT INTO `ccccomma_eve`.`userops` (`id` ,`starttime` ,`endtime` ,`shiptype` ,`weight` ,`payout` ,`active`) VALUES ('$opid', '$stime', '', '$stype', '$weight', '', 'Yes')") or die (mysql_error());
Echo "Op Joined";
}
?>

The variable is empty when I echo it out, any ideas on how to make to stick? Here is just the form that is giving me trouble

echo "<form action=main.php?id=joinop.php&opid=".$opid." method=post> 
Ship Type: <select name = ship>";
while ($row = mysql_fetch_array($result)) {
echo "<option Value=".rawurlencode($row['shiptype']).">".$row['shiptype']."</option>";
}
echo "</select>
<input name=submit type=submit value=Join>
</form>";

hi all. i am so lost here guys,i need your help.
basically, i have 3 pages here.
_add_tsubject, _query_subject, and _do_addtsubject.

_add_tsubject here contains a livesearch javascript that searches for subjects which i query in _query_subject. the result of that is displayed in _add_tsubject. i am using get method for that and for the url. now, my problem is how to pass or should i say combine the url from _add_tsubject with the url inside the <a href> in _query_subject?or is it possible??i'm sorry if it sounds confusing. but if it's confusing you please have a look at the code..

_add_tsubject

<?php
include("dbconnection_wmsuipil.php");
$id = $_GET['item'];
$t_id = $_GET['t_id'];
$lname = $_GET['lname'];
$fname = $_GET['fname'];
$result= mysql_query("SELECT * FROM tblSetSY")or die(mysql_error());
while($row = mysql_fetch_array($result))
  {
  $setYear=$row['SchoolYear'];
  $setSem=$row['Sem'];
  }
?>
<!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>Adding subject to teacher..</title>
<link rel="stylesheet" href="style.css"/>
<link rel="stylesheet" href="validator_style/screen.css"/>

</head>
<body> 
<div style="margin-right:30px; padding:10px;" align="right"><a href="#" onclick="window.location.reload()">Reload</a>&nbsp;|&nbsp;<a href="#" onclick="window.close()">Close</a></div>

<form name="form" id="cmxform_sched" class="cmxform" method="post" action="_do_addtsubject.php">
<fieldset>

<p>

<label for="t_id">Teacher ID: </label>
<input type="hidden" name="school_year1" value="<?php echo  $setYear;?>"/>
<input type="hidden" name="sem1" value="<?php echo  $setSem;?>"/>
<input type="hidden" name="id" value="<?php echo $id;?>" size="15"/>
<input type="text" name="t_id" value="<?php echo $t_id;?>" size="15"/>
</p>
<p>
<label for="name">Name: </label>
<input type="text" name="name" value="<?php echo $fname.' '.$lname;?>" size="25"/>
</p>

<p><i>*Add subjects to be handled...</i></p>
<p><label for="keyword">Enter Subject ID: </label>
<input type="text" name="sid" id="sid" size="15" onkeyup="showResult(this.value)" />
</p>
<div id="livesearch" align="center"><b>->Subject info will be listed here<-</b></div>
</table>


</fieldset>

</form>
<script type="text/javascript">

function showResult(str)
{
if (str.length==0)
  {
  document.getElementById("livesearch").innerHTML="";
  document.getElementById("livesearch").style.border="0px";
  return;
  }
if (window.XMLHttpRequest)
  {// code for IE7+, Firefox, Chrome, Opera, Safari
  xmlhttp=new XMLHttpRequest();
  }
else
  {// code for IE6, IE5
  xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
  }
xmlhttp.onreadystatechange=function()
  {
  if (xmlhttp.readyState==4 && xmlhttp.status==200)
    {
    document.getElementById("livesearch").innerHTML=xmlhttp.responseText;
    document.getElementById("livesearch").style.border="1px solid #A5ACB2";
    }
  }
 
xmlhttp.open("GET","_query_subject.php?q="+str,true);
xmlhttp.send();
}
</script>
</body>
</html>


_query_subject (i get an error on the _POST here..)

<?php
include("dbconnection_wmsuipil.php");
$t_id=$_POST['t_id'];
$name=$_POST['name'];
$sy=$_POST['school_year1'];
$sem=$_POST['sem1'];

$q=$_GET['q'];
$sql="SELECT * FROM admin_subject WHERE subj_id like '%".$q."%'";
echo "<table border='1'>
<tr>
<th>#ID</th>
<th>Subject ID</th>
<th>Subject Code</th>
<th>Description</th>
<th>Lect</th>
<th>Lab</th>
<th>Units</th>

</tr>";

$result = mysql_query($sql);
while($row = mysql_fetch_array($result))
  {
  $OutLine = array('id'=>'','subj_id'=>'','subj_code'=>'','subj_desc'=>'','lecture'=>'','laboratory'=>'','units'=>'');

$OutLine['id'] = $row['id'];
$OutLine['subj_id'] = $row['subj_id'];
$OutLine['subj_code'] = $row['subj_code'];
$OutLine['subj_desc'] = $row['subj_desc'];
$OutLine['lecture'] = $row['lecture'];
$OutLine['laboratory'] = $row['laboratory'];
$OutLine['units'] = $row['units'];
$countTsubj=0;
if($row>$countTsubj)
{
echo "<tr>";
echo "<td>".implode('<td/>',$OutLine);
echo '<td><a href="_do_addtsubject.php?id='.$row['id'].'&amp;subj_id='.$row['subj_id'].'&amp;code='.$row['subj_code'].'&amp;desc='.$row['subj_desc'].'&amp;lect='.$row['lecture'].'&amp;lab='.$row['laboratory'].'&amp;units='.$row['units'].'">[Add]</a></td>';
echo "</tr>"; 
 }

}
echo "</table>";
?> 


_do_addtsubject

<?php
include("dbconnection_wmsuipil.php");
$t_id=$_POST['t_id'];
$name=$_POST['name'];
$sy=$_POST['school_year1'];
$sem=$_POST['sem1'];
$id=$_GET['id'];
$subj_id=$_GET['subj_id'];
$code=$_GET['code'];
$desc=$_GET['desc'];
$lect=$_GET['lect'];
$lab=$_GET['lab'];
$units=$_GET['units'];
echo $t_id;
echo $name;
echo $sy;
echo $sem;
echo $id;
echo $subj_id;
echo $code;
echo $desc;
echo $lect;
echo $lab;
echo $units;
?>

there guys..i hope you can help me..the last page is where plan to echo the url once it's combined..please please help..

Hi, im trying to pass the information of a specific data to be edited in another form which is edit_doc.php. However, when i click "Edit" it doesnt seem to work. Only edit_doc.php opens but the information the does not appear. Is ther any mistake in the codes?


 while ($rows = mysql_fetch_assoc($run))    
{
  echo"<tr>";  
  echo "<td>". $rows['file_ref']  ."</td>";   
  echo "<td>". $rows['file_name'] ."</td>";  
  echo "<td>". $rows['owner'] ."</td>";  
  echo "<td>". $rows['url']    ."</td>";    
  echo "<td><a href=edit_doc.php?id=$rows>" . "Edit" . "</a></td>";  
  echo "<td><a href=delete.php?id=$rows>" . "Delete" . "</a></td>";  
  echo "</tr>";  

         }
      echo "</table>"; 
        }



Thankz

I had an iframe working for the last few months on a site at hostgator.  Yesterday, it quit working (403 permissions error).  After a long bout of trouble-shooting, I found out that it has something to do with mod_security that they have suddenly enabled (have no idea as I'm not a Linux guy). 

They told me they fixed the problem on my domain by whitelisting it as an exception, but strangely, even though the permissions error went away, the actual src= box of the iframe, which was the url variable I was passing in the url, no longer loads. 

So.. I'm trying to break this down into the simplest form to figure it out.  I just understand php basics so needing some verification that I'm doing this right/wrong. 

Here's my code.. 

page1.php
Code: [Select]
<? $testurl = "http://google.com"; ?>
<a href="http://mysite.blah/page2.php?url=<? echo $testurl; ?>">page2.php</a>
page2.php
Code: [Select]
if (isset($_GET['testurl'])) echo $testurl;
else echo "sorry dude";
I am only able to print "sorry dude". 
Am I doing something wrong or shouldn't this send the url? 

Thanks for the help!

hello all,

I'm new here and I'm learning mysql/php.  Currently I have a dynamic table on one of my webpages, and the loop code looks like this:while ($i < $numRows) {
$fname = mysql_result($result, $i, "fname");
$fcode = mysql_result($result, $i, "fcode");
$ftype = mysql_result($result, $i, "ftype");
$fdesc = mysql_result($result, $i, "fdesc"); ?>
  <tr>
<td><a href="showfunction.php?fname=<?php echo "$fname"; ?>" target="_self"> <?php echo "$fname"; ?></a></td>
<td> <?php echo "$fdesc"; ?> </td>
<td><div align="center"> <?php echo "$ftype"; ?> </div></td>
  </tr>
<?php $i++; 
  } ?>
what I would like to do is pass the ''fname'' variable to the "showfunction" page so it can printed from the database.  Here is the relevant portion of the page:<body><div class="codeblock"> 
<div class="title">Code:<br /> 
</div><code><pre>

<?php echo $fcode; ?>

</pre></code></div>
<br /><pre><hr />
</pre>
I know that doesn't work, and I didn't expect it to because there is no way to 'get' the 'fname' variable from the preceeding script.  I do not want to use the GET method with this because from what I understand, you can only use it with Forms.  I really don't want to put controls in all of my table fields just to be able to pass the function name to the next page.  Does that make sense?

If I could get a jumpstart on this one last hurdle, I would appreciate it.  thank you so much!

Cheers.

I am storing thousands of titles in mysql and many of these have a title with an ampersand. 
An example is how AT&T is getting stored in the database:  at-amp-t

Easy enough, I thought.. I'll just run str_replace on it before I save it to the database. 
$title = str_replace("-amp-", "&", $title);

That works great..  except when I click the new hyperlink created from this url.  It looks correct...  showing the exact url of what is stored in mysql:  (http://www.domain.com/this-is-the-at&t-title) ...but no url with this ampersand works.  All other $title urls works great.  If I don't run str_replace on it, it works fine.. but then I get a url stored as at-amp-t... which I'm trying to avoid. 

Thoughts?