PHP - Pass Variable From Php To Mysql

Hi All,

I have a function that i want to pass a variable into so that i can do some SQL on it.

The information that i want to pass into it is a data-id on a button that is used to trigger the function.

The button that will be clicked is this

<div class='modaltrigger btn btn-primary' data-id='$itemId' data-toggle='modal'>Manage</div>

This button is being created by another function.

I would like to know either how i pass the variable from one function to another or how i pass it from the data-id to the function in php.

Thanks in advance.

Here's my search form:

    <form action="search" method="get" enctype="multipart/form-data">
      <input type="text" name="string" maxlength="100" /><br /><br />
      <input type="submit" value="Search" />
    </form>

When I submit it, the URL is search.php?string=Bleh

What I would like is for the URL to be search/string/Bleh

I'm already doing this with some other variables, like search/tag/Bleh and search/author/Bleh, instead of search.php?tag=Bleh and search.php?author=Bleh. However, those ones are passed via a link, not a form.

Any ideas?

i have to pass a variable to so many pages i mean variable post from index.html to page1.php and it has to pass to other pages like page2.php, page3.php and so on,

i tried session_start()

but i am getting the below error so please tell me how it is possible to

Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by
and 
Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent

Can someone explain to me how this is done?

Hi,

Im trying to pass a variable ($in_this_instance) into, and then back out of a function.  The variable goes into the function no problem, and is echo'ed out fine.  However the echo after the close of the function, does not give anything out. 

Code: [Select]
$in_this_instance = 'boo';

function in_this_instance($data) {
global $in_this_instance;

echo $in_this_instance;

$in_this_instance = 'hoo';


$rep_val = '[front banner]';

    $test = strpos($data, $rep_val);
    if ($test === false) {
return $data;
    } else {
    return $data;;
    }
}

add_filter('the_content', 'in_this_instance');
echo $in_this_instance;

Could any one give me a pointer please?  Many Thanks!

When i execute the following code, it works and retrieves the record info i am looking for for the appropriate record, 2155015898:

  $adgrouppass = 2155015898;
  $selector->adGroupIds = array($adgrouppass);

However, when i try to get the adgroup variable from my url, which is where it is located, it doesn't work:

  $adgroup = trim($_GET['adgroup']);
  $adgrouppass = $adgroup;
  $selector->adGroupIds = array($adgrouppass);

yet, in trying to fix it, if i echo the above variable, it says it is correct, which is 2155015898.

Not sure if the $adgrouppass needs to be a string or variable to get it to pass it correctly.  Can anyone help?
 

Hi guys,

I have a trouble with my php snippet, when I insert the var function in the url bar something is like:

http://www.mysite.com/delete.php?favorites&id=0

or

http://www.mysite.com/delete.php?whateveritis&id=0

It doesn't get pass the favorites function to delete the id. It is the same things that it goes for each different function.

Here's the current code:

<?php
Code: [Select]
session_start();
    define('DB_HOST', 'localhost');
    define('DB_USER', 'mydbuser');
    define('DB_PASSWORD', 'mydbpass');
    define('DB_DATABASE', 'mydbtablename');

    $errmsg_arr = array();
    $errflag = false;

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

    $db = mysql_select_db(DB_DATABASE);
    if(!$db) {

die("Unable to select database");
    }

   function clean($var){

return mysql_real_escape_string(strip_tags($var));
    }
    $favorites = clean($_GET['favorites']);
    $id = clean($_GET['id']);

if($favorites && $id == ''){
   // both are empty
   $errmsg_arr[] = 'favorites id are missing.';
   $errflag = true;
}

    if($errflag) {
  $_SESSION['ERRMSG_ARR'] = $errmsg_arr;
  echo implode('<br />',$errmsg_arr);
   }
   else {
$insert = array();
if(isset($_GET['id'])) {
    $insert[] = 'id = \'' . clean($_GET['id']) .'\'';
}
if(isset($_GET['favorites'])) {
    $insert[] = 'favorites = \'' . clean($_GET['favorites']) . '\'';
}

if($favorites && $id) {
   mysql_query("DELETE FROM favorites WHERE id='$id'");
   $deleted = mysql_affected_rows();
   if($deleted > 0)
   {
  echo "favorites channels is deleted";
   }
   else
   {
  echo("favorites is already deleted");
   }
 }
}
?>
If you do know how to get pass the favorites function, then please say so as i need your help.

Any advice would be much appreicated.

Hello!

I've got an issue! I'm trying to pass a very very long variable from JS to PHP through $_GET, but it seems too long for get.

Is there any encryption function that works on both JS and PHP, so I can encrypt it in JS, send it though GET and decrypt it in PHP?

Thanks !

I am passing the variable $searchno from form1.html using

<form action="display1.php" method="post"
Display1.php reads my database and displays the data. Now I want to link from the displayed page to display2.php and pass and capture the same variable $searchno.

How do I do that?

Hi, I have this script, it all works fine apart from when I pass the variable on, it only passes the first word and not the whole variable

The form that actions to the samples page passes the $siteName as My Test Site, if I type echo $siteName in the sameples page, it will print My Test Site, however when I use this

Code: [Select]
createSample&siteName=$siteName
to pass the variable to the next page, it just echos 'My' instead of My Test Site. Even when I scroll over the link above it just shows My in the url.

Code: [Select]
case "samples":

// Get submitted data and assign to variables

$siteName = $_POST['siteName'];
$adminEmail = $_POST['adminEmail'];
$sendmailLoc = $_POST['sendmailLoc'];
$imgdir = $_POST['imgdir'];
$imgdirbase = $_POST['imgdirbase'];

// Write variable data to text file

$FileName = "data/server.txt";
$FileHandle = fopen($FileName, 'w') or die("can't open file");
$data = "<?php\n\$siteName = '$siteName';\n?>";
fwrite($FileHandle, $data);
$data = "<?php\n\$adminEmail = '$adminEmail';\n?>";
fwrite($FileHandle, $data);
$data = "<?php\n\$sendmailLoc = '$sendmailLoc';\n?>";
fwrite($FileHandle, $data);
$data = "<?php\n\$imgdir = '$imgdir';\n?>";
fwrite($FileHandle, $data);
$data = "<?php\n\$imgdirbase = '$imgdirbase';\n?>";
fwrite($FileHandle, $data);
fclose($FileHandle);

// Displays the create sample pages page

ECHO <<<SAMPLES

<table border=0 align=center bgcolor=#00CCFF>
  <tr>
    <td><span class=style1><b><center>Create Sample Pages</center></b></span></td>
  </tr>
  <tr>
    <td>Would you like Member Site Maker to create sample pages for:
<ul>
<li>index.html</li>
<li>login.html</li>
<li>search.html</li>
<li>register.html</li>
</ul>
</td>
</tr>
<tr>
<td><a href=installation.php?cmd=createSample&siteName=$siteName>Yes</a>
</td>
<td><a href=installation.php?cmd=mysql>No</a>

</td>
</tr>

</table>

SAMPLES;

break;
Can anybody tell me where I am going wrong please?

Thanks

i knw dis mst a simple question but how to pass variable to other page
for eg i hav created a page where user submits username n telephone then via sms some random number goes to user mobile ...i want this random number variable in other page
 dis is my code for startreg.php

<form action="startregprocess.php" method="post">
username:<input type="text" name="username">
telephone<input type="text" name="telephone"
<input type="submit" name="submit">
</form>
<?php
srand ((double) microtime( )*1000000);
$random_number = rand( );
echo $random_number;
?>


i want tht $random_number in other page called startregprocess.php

I have a table that has 5 columns

Quote

player_id
fname
lname
team
email


I'm trying to get all the values from that table using this sql command

Code: [Select]
include_once('../database_connection.php');

$player_id = addslashes($_REQUEST['edit_player']);

$sql_query = "Select * from nba_info where player_id = '$player_id'";
$result = MYSQL_QUERY($sql_query);
"edit_player" above is came from a different page.




They I'm fetching the data using while

Code: [Select]
while($row = mysql_fetch_array($result))
{
$row['player_id'];
    $row['fname'];
    $row['lname'];
    $row['team'];
    $row['email'];
}
Then I'm trying to pass that values to a variable here

Code: [Select]
$id = $row['player_id'];
$fname = $row['fname'];
$fname = $row['lname'];
$lname = $row['team'];
$email = $row['email'];

When I'm trying to put that variables in a textbox value, they are not showing up

Here

Code: [Select]
<table>
<form name="edit_player_form" method="post" action="">

<tr>
<td>Players ID</td>
<td><input type="text" name="playerid" size="20" value="<?php echo $id; ?>" /></td>
</tr>

<tr>
<td>First Name</td>
<td><input type="text" name="fname" size="20" value="<?php echo $fname; ?>" /></td>
</tr>

<tr>
<td>Last Name</td>
<td><input type="text" name="lname" size="20" value="<?php echo $lname; ?>" /></td>
</tr>

<tr>
<td>Team</td>
<td><input type="text" name="team" size="20" value="<?php echo $team; ?>" /></td>
</tr>

<tr>
<td>Email</td>
<td><input type="text" name="email" size="20" value="<?php echo $email; ?>" /></td>
</tr>


<tr>
         <td><div align="center">
         <input type="submit" name="Submit" value="Edit This Player">
         </div></td>
        </tr>



</form>
</table>


I wonder why it ain't showing up on the textbox value? tried almost everything... Anyone?

My website is multi-language and using mod_rewrite for clean urls. I have a $lang variable that stores the language code.

For example:

website.com/index.php?lang=en, which turns to website.com/en

I use a $_GET["lang"] to get the language and prepare the links to the other pages, for example a link to page1.php would be page1.php?lang=$_GET["lang"].

What I want to know is if this is the right way to do it or there is a better way.

Hi there,

I am working on a php web form.

I have a variable named $isFruit having value of 1

When I do a:

print_r($isFruit)

It gives me value as 1, which is good.

Now I need to pass this php variable into a jquery function:

$('document').ready(function() {         
  //I need to get the value of $isFruit variable here
}

How can pass the php variable into this function.

Kindly reply.

All comments and feedbacks are always welcomed.

Thank you!

Currently I have a PHP file that is pulling information from a table in the Database and inserting it into an HTML table. It consists of the fields: Last_Name, First_Name, Party, District, Address, CIty, State, Zip, and Email. And the Email field is being converted to a Hyperlink.  (All working fine so far)

I also have a form that has a prewritten letter to be sent to the email address. I need to have the HyperLink from the Email pass the address to the form to allow me to send it. I am not sure how to get this to happen. Here is the code I have so far:

The pull from the database:
<?php




$dbhost = 'localhost';
$dbuser = 'removed';
$dbpass = 'removed';
$db = 'removed';

$link = mysql_connect($dbhost, $dbuser, $dbpass)or die(mysql_error());
mysql_select_db($db)or die(mysql_error());

$result = mysql_query("SELECT * FROM 2011members") 
or die(mysql_error());  


echo "<table border='1'>";
echo "<tr> <th>Last Name</th> <th>First Name</th> <th>Party</th> <th>District</th> <th>Address</th> <th>City</th> <th>State</th> <th>Zip</th> <th>Email</th> </tr>";
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
// Print out the contents of each row into a table
echo "<tr><td>"; 
echo $row['Last_Name'];
echo "</td><td>"; 
echo $row['First_Name'];
echo "</td><td>"; 
echo $row['Party'];
echo "</td><td>"; 
echo $row['District'];
echo "</td><td>"; 
echo $row['Address'];
echo "</td><td>"; 
echo $row['City'];
echo "</td><td>"; 
echo $row['State'];
echo "</td><td>"; 
echo $row['Zip'];
echo "</td><td>"; 
//Normal Pull
//echo $row['Email'];
//echo "</td><td>"; 
//Just Hyperlink
//echo '<a href="http://',Email,'">',Email,'</a>';
//echo "</td></tr>"; 
echo '<a href="http://'.$row['Email'].'">'.$row['Email'].'</a>';
echo "</td></tr>"; 
} 

echo "</table>";
?>

The Form:
Code: [Select]
<?php 
if($_POST){
$to = 'becca@windfallstudio.com';
$subject = "WHAT SHOULD THIS BE";
$message  =  "Date: $date\n\r".
 "Dear $legislator,\n\r".
 "As a constituent of yours, I urge you to closely review $bill as it pertains to the distribution and allotment of the 4 percent bed tax collected at lodging properties in Montana.\n\r".
"Tourism is very important to Montana. Not only it is the second largest industry in Montana, it is also a key economic engine for businesses and the thousands of Montanans that have jobs because of tourism.\n\r".
"Nearly 10 million visitors travel to our state each year, contributing between $2.4 billion and $3 billion annually into our economy. In addition to bringing new money into our state, these visitors also help support more than 42,000 Montana jobs and $897 million in worker salaries. (Source: Montana Office of Tourism Annual Report - 2010)\n\r".
"Please rest assured that these millions of visitors don't come on their own. They are enticed to come here through marketing and outreach done by various organizations that include the Montana Office of Tourism, Glacier Country Regional Tourism Commission and Missoula Convention and Visitor Bureau.\n\r".
"While there is a 7 percent bed tax collected at all lodging entities in the state, 3 percent supports the General Fund and 4 percent supports travel-related partners. The 4 percent is vital to marketing our stage and it is imperative for that money to remain solely dedicated to travel and tourism promotion. I would urge you to vote no on any bill that would direct any portion of that 4 percent elsewhere.\n\r".
"Thank you for your consideration in this request and for doing all you can to represent us, your constituents, to the best of your ability. I look forward to hearing from you soon.\n\r".
"Sincerely,\n".u
"$name \n".
"$street \n".
"$city, $zip \n".
"$email \\n".
$headers = "From: $email";
mail($to, $subject, $message, $headers);
// SUCCESS!
echo '<p class="notice">'.
'Thank you for your submission.  '.
   '</p>';
// clear out the variables for good-housekeeping
unset($date,$legislator,$bill,$name,$street,$city,$zip,$email);
$_POST = array();
}
?>

<div id="content" class="section">
<?php arras_above_content() ?>

<?php if (have_posts()) : while (have_posts()) : the_post(); ?>
<?php arras_above_post() ?>
<div id="post-<?php the_ID() ?>" <?php arras_single_post_class() ?>>
        <?php arras_postheader() ?>
       
        <div class="entry-content clearfix">
<form method="post" action="" id="letter">
<p><label for="name">Date</label>
<input type="text" name="date" id="date" value="<?php echo $_POST['date'];?>"/></p>
<p>Dear Senator/Representative
<select name="legislator">
<option>Choose a Legislator</option>
<option>Senator John Q. Public</option>
<option>Rep. Jane Q. Public</option>
<option>Some Third Person</option>
</select>,</p>
<p>As a constituent of yours, I urge you to closely review Bill
<select name="bill">
<option>Choose a Bill</option>
<option>SB 13 / LC0448</option>
<option>LC0505</option>
<option>LC0532</option>
</select>
 as it pertains to the distribution and allotment of the 4 percent bed tax collected at lodging properties in Montana.</p>
<p>Tourism is very important to Montana. Not only it is the second largest industry in Montana, it is also a key economic engine for businesses and the thousands of Montanans that have jobs because of tourism.</p>
<p>Nearly 10 million visitors travel to our state each year, contributing between $2.4 billion and $3 billion annually into our economy. In addition to bringing new money into our state, these visitors also help support more than 42,000 Montana jobs and $897 million in worker salaries. (Source: Montana Office of Tourism Annual Report - 2010)</p>
<p>Please rest assured that these millions of visitors don't come on their own. They are enticed to come here through marketing and outreach done by various organizations that include the Montana Office of Tourism, Glacier Country Regional Tourism Commission and Missoula Convention and Visitor Bureau.</p>
<p>While there is a 7 percent bed tax collected at all lodging entities in the state, 3 percent supports the General Fund and 4 percent supports travel-related partners. The 4 percent is vital to marketing our stage and it is imperative for that money to remain solely dedicated to travel and tourism promotion. I would urge you to vote no on any bill that would direct any portion of that 4 percent elsewhere.</p>
<p>Thank you for your consideration in this request and for doing all you can to represent us, your constituents, to the best of your ability. I look forward to hearing from you soon.</p>
<p>Sincerely,<br />
<label for="name">Name:</label>
<input type="text" name="name" id="name" value="<?php echo $_POST['name'];?>"/><br />
<label for="email">Street:</label>
<input type="text" name="street" id="street" value="<?php echo $_POST['street'];?>"/><br />
<label for="email">City:</label>
<input type="text" name="city" id="city" value="<?php echo $_POST['city'];?>"/><br />
<label for="email">Zip:</label>
<input type="address" name="zip" id="zip" value="<?php echo $_POST['zip'];?>"/><br />
<label for="email">E-mail:</label>
<input type="text" name="email" id="email" value="<?php echo $_POST['email'];?>"/></p>
<input type="submit" class="button" value="Submit" />
</form>
<?php the_content( __('<p>Read the rest of this entry &raquo;</p>', 'arras') ); ?> 
        <?php wp_link_pages(array('before' => __('<p><strong>Pages:</strong> ', 'arras'), 
'after' => '</p>', 'next_or_number' => 'number')); ?>
</div>
What do I need to do to get the Email link from the HTML table to pass to the Email variable in the Form?