PHP - Pass Get Variable To Mysql Query

Hi

I'm having a problem getting a query to work.

I have a simple form with user input for start and end date with format: 2009-03-19 (todays date):

$Startdate = $_POST['date'];

This works well when something is entered into the form, and afterwards using my query:

SELECT COUNT(*) as total FROM mydb WHERE Date BETWEEN '$Startdate' AND '$EndDate' ........

Problem is if user submits the form without entering anything in the date input fields, which makes sense.

I want to check if inputs has been made, and if not set af default date, but can't make it work:

if (isset($_POST['date']) && $_POST['date'] !='') {
$Startdate = $_POST['date'];}
else { $Startdate = '1980-01-01';}

How can I set $Startdate to something that can be used in the query as below doesn't work?

I am trying to pass in a $string variable into my query like so but it is returning a warning:

Code: [Select]
$string = "clientName == '$input'";
$input = "Sam";

$table_id = 'booking';
$query ="SELECT *
FROM booking
WHERE. '$string' ";


$test = mysql_query($query);

echo $test;

This topic has been moved to Ajax Help.

http://www.phpfreaks.com/forums/index.php?topic=353002.0

Hello

I'm using a form to collect user data (is a Cognito form) it is displayed on vacation rental properties pages, so it collects user´s email, in date, out date, etc.
However since my site https://www.bariloche.esp.br/hoteis/hosteria-no-centro-vista-ao-lago uses the same form for several properties, when someone submits, I get the information but I dont know if it comes from here https://www.bariloche.esp.br/hoteis/hosteria-no-centro-vista-ao-lago or https://www.bariloche.esp.br/hoteis/hotel-com-praia-de-lago-ha1 or any other property page.

in the cognito form I have one text hidden field called REF, 

I wonder how to do in order to use the same form and be able to identify where the info comes from. 

I thougt that if I could put the page url into the REF variable, the problem would be solved, but I'm not sure if that is possible and how to do it.

It is?

If not: is it possible to handle that ?

so I need some help passing these variable from this page to final.php.  how do I pass these arrays?  I know if it were singled....not arrayed, I could use hidden fields in a form and echo them out....but these are multiples....not singled.  The form way is prefered.....but it doesn't have to be.  I just need these passed to the page where I am going to process them.  I am not good at working with arrays.  Thanks in advance

Code: [Select]
<?php
include_once("connect.php");
session_start();

 
 




 
foreach($_POST["product"] AS $key => $val) {
$product = $val;
$month = $_POST['month'][$key];
$day = $_POST['day'][$key];
$year = $_POST['year'][$key];
$date = $_POST['date'][$key];
$price = $_POST['price'][$key];
$qty = $_POST['qty'][$key];
$id = $_POST['id'][$key];
$total = $_POST['total'][$key];
$academy = $_POST['academy'][$key];
$priceunit = $price * $qty;


}

?>

Hi guys,

I need your help, I have got a problem with the if statement. When I don't insert the pass function in the url like this:

Code: [Select]
http://www.mysite.com/myscript.php?image=myimagelocation&strings=mystrings&user=test

I will get this on my php page:

Code: [Select]
PASSWORD are missing

Code: [Select]
<?php
session_start();
    define('DB_HOST', 'localhost');
    define('DB_USER', 'mydbusername');
    define('DB_PASSWORD', 'mydbpass');
    define('DB_DATABASE', 'mydbname');
       
    $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));
    }
    $image = clean($_GET['image']);
    $strings = clean($_GET['strings']);
    $username = clean($_GET['user']);
    $pass = clean($_GET['pass']);


    if($username == '' && $pass) {
  $errmsg_arr[] = 'username are missing';
  $errflag = true;
     }elseif($username && $pass =='') {
  $errmsg_arr[] = 'PASSWORD are missing';
  $errflag = true;
    }
    if($username == '' && $pass == '') {
  $errmsg_arr[] = 'username or password missing';
  $errflag = true;
    }

    if($errflag) {
  $_SESSION['ERRMSG_ARR'] = $errmsg_arr;
  echo implode('<br />',$errmsg_arr);
   }
   else {

 
$insert = array();
if(isset($_GET['image'])) {
    $insert[] = 'image = \'' . clean($_GET['image']) . '\'';
}
if(isset($_GET['strings'])) {
    $insert[] = 'strings = \'' . clean($_GET['strings']) . '\'';
}
if(isset($_GET['user'])) {
    $insert[] = 'user = \'' . clean($_GET['user']) .'\'';
}
if(isset($_GET['pass'])) {
    $insert[] = 'pass = \'' . clean($_GET['pass']) . '\'';
}



if (count($insert)>0) {
   $names = implode(',',$insert);

$required_fields = array('image', 'strings', 'user');

if($image && $strings && $username) {
  echo "working 1";
} elseif($username && $pass) {
  echo "working 2";
  }
 }
}
?>

Do anyone know how to fix this?

I have researched all over forums from past day. Not getting correct solution. I have 2 textboxes and a button. First box is to enter value and i will click button, i need to get the value.   Here is the code, that works without input box 1   In this code i want to modify my web address, at the end after ky= i want add my first textbox value, then click event and output in second textbox, let me know where i messed.  

<script type="text/javascript">
function Assign() 
{
<?php
$html = file_get_contents("http://geoportaal.maaamet.ee/url/xgis-ky.php?ky=79401:006:0812" );
preg_match_all('(<li.*?>.*?</li>)', $html, $matches);
$one=$matches[0][0];


?>
document.getElementById("OutputField").value = "<?=$one?>";
}
</script>




<input id="InputField" type="text" style="width:200px"/>
<input type="submit" value="Assign Value" onclick="Assign()"/>
<input id="OutputField" type="text" style="width:200px"/>

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 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?

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.

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.

Can someone explain to me how this is done?

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

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?