PHP - Send Hidden Values

Hi,

I'm trying to setup a quick PHP script that will grab the email from the url (see below) and after inserting into MySQL db - which is working fine - the script will complete two additional tasks:

1. send that same captured email out to a external db as in shown via http://domain1.com/insert.php?email=$lead (example), but then send to a DIFFERENT source - the originator of the lead - a portback acknowledgement using Header (sending the status and email to http://domain2.com/check.php?e=$lead&s=$status for their records).

See the code below:
-------------------------

Code: [Select]

$lead = $_REQUEST['e_mail'];                // will grab email from posted url string and assign to local variable
$result = mysql_query($command);      // this is just to execute the MySQL insert which works just fine but included here to explain validation below

// Create API Call string to insert lead into iContact folder
$requestURL = "http://domain1.com/insert.php?email=$lead";

// Execute API Call to CAKE
$xml = simplexml_load_file($requestURL) or die("feed not loading");


if ($result) {
    $status = 1;       // mark lead as sucess

    // send postback on lead status
    header("Location: http://domain2.com/check.php?e=$lead&s=$status");
}

--------

Problem: I'm getting all sorts of errors with the simplexml_load_file() function and can't figure out why it won't work.
Any input appreciated as this the only way I know how to pass the lead onward and then inform/update the other party of receipt of information.

thanks!

Dear All Members

here is my table data..

(4 Columns/1row in mysql table)

id                 order_no               order_date                  miles
310                001                   02-15-2020                MI,108.53
                                                                                     Oh,194.57
                                                                                     PA,182.22
                                                                                     WA,238.57

How to split(miles) single column into (state, miles) two columns and output like following 5 columns /4rows in mysql using php code.

(5 Columns in mysql table)
------------------------------------------------------------------------------------

id                  order_no              order_date              state      miles

310                001                   02-15-2020               MI          108.53

310                001                   02-15-2020              Oh          194.57

310                001                   02-15-2020              PA          182.22

310                001                   02-15-2020             WA          238.57
 

------------------my php code -----------

 

<?php
//invoice.php  
include('../includes/config.php');

if(isset($_POST["add"]))
{
$order_no=$_GET['order_no'];
$order_date=$_GET['order_date'];
$miles=$_POST['miles'];

$miles = explode("\r\n", $_POST["miles"]);
$newdata = "'" . implode("','", $_POST["miles"]) . "'";
$sql ="INSERT INTO tble_states_miles(order_no,order_date, miles) VALUES(:order_no, :order_date, :newdata)";

$query = $dbh->prepare($sql);
$query-> bindParam(':order_no', $order_no, PDO::PARAM_STR);
$query-> bindParam(':order_date', $order_date, PDO::PARAM_STR);
$query-> bindParam(':miles', $newdata, PDO::PARAM_STR);

$lastInsertId = $dbh->lastInsertId();
if($lastInsertId)
{
echo "<script type='text/javascript'>alert('Added Sucessfull!');</script>";
echo "<script type='text/javascript'> document.location = 'ifta_miles_calculationlist_added.php'; </script>";
}
else 
{
$error="Something went wrong. Please try again";
}

if($query->execute()) {

$sql = "update tis_invoice set flag='1' where order_no=:order_no";
$query = $dbh->prepare($sql);
$query-> bindParam(':order_no', $order_no, PDO::PARAM_STR);

$query->execute();

}
}
?>

----------------- my form code ------------------

 

 <?php
                   $order_no=$_GET['order_no'];
        $sql = "SELECT * from tis_invoice where order_no = :order_no";
        $query = $dbh -> prepare($sql);
        $query->execute(
  array(
   ':order_no'       =>  $_GET["order_no"]
  )
 );
        $result = $query->fetchAll();
        foreach($result as $row)
?>
    
                    <form method="post">
                        <table align="center" style="width: 55%">
                        <tr><td>Invoice Number</td></tr>
                        <tr><td><input type="text" name="order_no" value="<?php echo $row["order_no"]; ?>" readonly=""></td></tr>
                        <tr><td>Invoice Date</td></tr>
                        <tr><td><input type="text" name="order_no" value="<?php echo $row["order_date"]; ?>" readonly=""></td></tr>
                        <tr><td>
                               <textarea name="miles" class="form-control" rows="10" placeholder="" required></textarea>
                           </td></tr>
                           <tr><td>
                         
                            <input type="submit" name="add" class="btn btn-primary" value="Add" />
                       </td></tr></table>
                    </form>

-- Can any one help how to correct my code..present nothing inserted on table

 

Thank You

Edited February 8, 2020 by karthicbabu

Hi,

My company has 240+ locations and as such some users (general managers) cover multiple sites.  When I run a query to pull user information, when the user has multiple sites to his or her name, its adds the second / third sites to the next columns, rather than wrapping it inside the same table cell.  It also works the opposite way, if a piece of data is missing in the database and is blank, its pull the following columns in.  Both cases mess up the table and formatting.  I'm extremely new to any kind of programming and maybe this isn't the forum for this question but figured I'd give it a chance since I'm stuck.

The HTML/PHP code is below:

<table id="datatables-column-search-select-inputs" class="table table-striped" style="width:100%">

                                        <thead>

                                            <tr>

                                                <th>ID</th>

                                                <th>FirstName</th>

                                                <th>LastName</th>

                                                <th>Username</th>

                                                <th>Phone #</th>

                                                <th>Location</th>

                                                <th>Title</th>

                                                <th>Role</th>

                                                <th>Actions</th>

                                            </tr>

                                        </thead>

                                        <tbody>

                                            <?php

                                            //QUERY TO SELECT ALL USERS FROM DATABASE

                                            $query = "SELECT * FROM users";

                                            $select_users = mysqli_query($connection,$query);

                                            

                                            // SET VARIABLE TO ARRAY FROM QUERY

                                            while($row = mysqli_fetch_assoc($select_users)) {

                                                $user_id = $row['user_id'];

                                                $user_firstname = $row['user_firstname'];

                                                $user_lastname = $row['user_lastname'];

                                                $username = $row['username'];

                                                $user_phone = $row['user_phone'];

                                                $user_image = $row['user_image'];

                                                $user_title_id = $row['user_title_id'];

                                                $user_role_id = $row['user_role_id'];

                                            

                                                // POPULATES DATA INTO THE TABLE

                                                echo "<tr>";

                                                echo "<td>{$user_id}</td>";

                                                echo "<td>{$user_firstname}</td>";

                                                echo "<td>{$user_lastname}</td>";

                                                echo "<td>{$username}</td>";

                                                echo "<td>{$user_phone}</td>";

                                            

                                                //PULL SITE STATUS BASED ON SITE STATUS ID

                                                $query = "SELECT * FROM sites WHERE site_manager_id = {$user_id} ";

                                                $select_site = mysqli_query($connection, $query);

                                                while($row = mysqli_fetch_assoc($select_site)) {

                                                    $site_name = $row['site_name'];

                                                    echo "<td>{$site_name}</td>";

                                                }

                                                echo "<td>{$user_title_id}</td>";

                                                echo "<td>{$user_role_id}</td>";

                                                echo "<td class='table-action'>

                                                    <a href='#'><i class='align-middle' data-feather='edit-2'></i></a>

                                                    <a href='#'><i class='align-middle' data-feather='trash'></i></a>

                                                    </td>";

                                                //echo "<td><a href='users.php?source=edit_user&p_id={$user_id}'>Edit</a></td>";

                                                echo "</tr>";

                                            }   

                                            ?>

 

                                            <tr>

                                                <td>ID</td>

                                                <td>FirstName</td>

                                                <td>LastName</td>

                                                <td>Username</td>

                                                <td>Phone #</td>

                                                <td>Location</td>

                                                <td>Title</td>

                                                <td>Role</td>

                                                <td class="table-action">

                                                <a href="#"><i class="align-middle" data-feather="edit-2"></i></a>

                                                <a href="#"><i class="align-middle" data-feather="trash"></i></a>

                                                </td>

                                            </tr>

                                        </tbody>

                                        <tfoot>

                                            <tr>

                                                <th>ID</th>

                                                <th>FirstName</th>

                                                <th>LastName</th>

                                                <th>Username</th>

                                                <th>Phone #</th>

                                                <th>Location</th>

                                                <th>Title</th>

                                                <th>Role</th>

                                            </tr>

                                        </tfoot>

                                    </table>

Hi all,

Just curious why this works:

Code: [Select]
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE){
$import="INSERT into $prodtblname ($csvheaders1) values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]')";
}
And this does not:

$headdata_1 = "'$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]'";
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE){
$import="INSERT into $prodtblname ($csvheaders1) values($headdata_1)";
}it puts $data[#'s] in the database fields instead of the actual data that '$data[0]','$data[1]'... relates to.

I wrote a script to create the values in $headdata_1 based on the number of headers in $csvheaders1 but can't seem to get it working in the sql statement.

Thanks

Hi all,

I'm a first time poster here and I would really appreciate some guidance with my latest php challenge! I've spent the entire day googling and reading and to be honest I think I'm really over my head and need the assistance of someone experienced to advise the best way to go!

I have a multi dimensional array that looks like (see below); the array is created by CodeIgniter's database library (the rows returned from a select query) but I think this is a generic PHP question as opposed to having anything to do with CI because it related to working with arrays.

I'm wondering how I might go about searching the array below for the key problem_id and a value equal to a variable which I would provide. Then, when it finds an array with a the matching key and variable, it outputs the other values in that part of the array too.

For example, using the sample data below. How would you recommend that I search the array for all the arrays that have the key problem_id and the value 3 and then have it output the value of the key problem_update_date  and the value of the key problem_update_text. Then keep searching to find the next occurrence?

Thanks in advance, as above, I've been searching really hard for the answer and believe i'm over my head!

Output of print_r($updates);

CI_DB_mysql_result Object
(
    [conn_id] => Resource id #30
    [result_id] => Resource id #35
    [result_array] => Array
        (
        )

    [result_object] => Array
        (
        )

    [current_row] => 0
    [num_rows] => 5
    [row_data] => 
)


Output of print_r($updates->result_array());

Array
(
    [0] => Array
        (
            [problem_update_id] => 1
            [problem_id] => 3
            [problem_update_date] => 2010-10-01
            [problem_update_text] => Some details about a paricular issue
            [problem_update_active] => 1
        )

    [1] => Array
        (
            [problem_update_id] => 4
            [problem_id] => 3
            [problem_update_date] => 2010-10-01
            [problem_update_text] => Another update about the problem with an ID of 3
            [problem_update_active] => 1
        )

    [2] => Array
        (
            [problem_update_id] => 5
            [problem_id] => 4
            [problem_update_date] => 2010-10-12
            [problem_update_text] => An update about the problem with an ID of four
            [problem_update_active] => 1
        )

    [3] => Array
        (
            [problem_update_id] => 6
            [problem_id] => 4
            [problem_update_date] => 2010-10-12
            [problem_update_text] => An update about the problem with an ID of 6
            [problem_update_active] => 1
        )

    [4] => Array
        (
            [problem_update_id] => 7
            [problem_id] => 3
            [problem_update_date] => 2010-10-12
            [problem_update_text] => Some new update about the problem with the ID of 3
            [problem_update_active] => 1
        )

)

Code: [Select]
            <td >
           
               
               
               
               
                    <form action="" method="post">
                   
                    <b> <?php echo $likes_count; ?> </b> <b> | </b> <b> <?php echo $dislikes_count; ?> </b>
                   
                    <button class="LikeButton" type="submit" name="likes" value="+1">Likes</button>
                    <button class="DislikeButton" type="submit" name="dislikes" value="-1">Dislikes</button>
                   
                   
                   
                   
                    <input type="hidden" name="hidden_con_id" value="<?php echo $con_id; ?>" />
                </form>
         
               
               
            <?php echo $con_id; ?>
               
               
               
           
            </td>
I have a table with a voting system and the problem I am experiencing is that the hidden id, which I call the hidden contribution id is not set thus the numeric array changes. I know that it is not best practice to use a numeric array for this, though I learned that afterwards.

This is the array:

Code: [Select]
                // POST BUTTONS inside the table
                if (isset($_POST['likes'])) {
                    $likes = $_POST['likes'];
                }
                if (isset($_POST['dislikes'])) {
                    $dislikes = $_POST['dislikes'];
                }
                if (isset($_POST['likes']) || isset($_POST['dislikes'])) {
                    $hidden_con_id = $_POST['hidden_con_id'];
                }

               
               
// $array = array ($likes, $dislikes, $con_id, $user_id);
               
                if (isset($likes)) {
                    $array[] = $likes;
                }
                if (isset($dislikes)) {
                    $array[] = $dislikes;
                }
                if (isset($hidden_con_id)) {
                    $array[] = $hidden_con_id;
                }
                if (isset($dnuser_id)) {
                    $array[] = $dnuser_id;
                }
As said the problem I have is that the hidden_con_id variable is not set and that consequently array[2] becomes the user_id variable.


Any suggestions why it is not becoming set?

hi , when I use hidden input tag and save there information to send with the form , is that secure?
I mean , if the user or hacker or anything can change the value of the hidden tag?
thanks , Mor.

how would i retrieve a hidden field from this form



Code: [Select]


$checkoutBtn .= '<form action="checkout.php" method="POST" id="checkform">
        <input type="hidden" name="item_name_' . $x . '" value="' . $eventname . '">
        <input type="hidden" name="amount_' . $x . '" value="' . $studentsprice . '">
        <input type="hidden" name="quantity_' . $x . '" value="' . $each_item['quantity'] . '">;[
        <input type="hidden" name="custom" value="' . $product_id_array . '">
        <input type="submit" class="checkoutbtn" name="checkoutbtn" value="CHECKOUT" />
</form>';

/code]

Hi I have an index.php with three drop down boxes on, each drop down uses an SQL statement to pull seatNumber from 'seats' each seat number has a UI and a forgein key field called SrideID.

I have the buttons on the dorp down boxes going to dd-check.php, here the seat chosen is posted and a simple echo(just testing it works atm)

for me to do any queries I also need the SrideID within the dropdown box, i tried adding it within the <option></option> but it only made the drop down duplicate.
1
1
2
2
3
3
ect.....

what i would like is for the SrideID field to be included with in the dropdown box but hidden so i can post it to  the dd-check.php and then show the time and price of that particular ride.

here is the table and the code so far. Thanks for any help.



CREATE TABLE `ride` 
(
`RrideID` tinyint(1) default NULL,  
`name` varchar(20) default NULL,  
`time` tinyint(1) default NULL,  
`price` varchar(4) default NULL
) 

INSERT INTO `ride` 
VALUES (1, 'Swinging Ship', 7, '2.50');
INSERT INTO `ride` VALUES (2, 'Roller Coaster', 5, '3.75');
INSERT INTO `ride` VALUES (3, 'Ice Blast', 4, '3.00');

CREATE TABLE `seats` 
(
`seatID` int(8) NOT NULL default '0',  
`SrideID` tinyint(1) default NULL,  
`seatNumber` int(2) default NULL,  
PRIMARY KEY (`seatID`)
) 

INSERT INTO `seats` VALUES (1, 1, 1);
INSERT INTO `seats` VALUES (2, 1, 2);
INSERT INTO `seats` VALUES (3, 1, 3);
INSERT INTO `seats` VALUES (4, 1, 4);
INSERT INTO `seats` VALUES (5, 1, 5);

INSERT INTO `seats` VALUES (49, 2, 1);
INSERT INTO `seats` VALUES (50, 2, 2);
INSERT INTO `seats` VALUES (51, 2, 3);
INSERT INTO `seats` VALUES (52, 2, 4);
INSERT INTO `seats` VALUES (53, 2, 5);

INSERT INTO `seats` VALUES (69, 3, 1);
INSERT INTO `seats` VALUES (70, 3, 2);
INSERT INTO `seats` VALUES (71, 3, 3);
INSERT INTO `seats` VALUES (72, 3, 4);
INSERT INTO `seats` VALUES (73, 3, 5);




code for index.php

<table width="200" border="1">
  <tr>
 <h1>Swinging Ship</h1>
<?php
echo '<form method="post" name="f1" action="dd-check.php">';
$query_s = "SELECT * FROM `seats` WHERE SrideID='1' ORDER BY seatID";  
$result = mysql_query($query_s);  

echo"<select name='seatNumber'><option value=''>Select Seat</option>";
while( $row = mysql_fetch_array($result) ) 
{ 
     echo '<option>'.$row['seatNumber'].'</option>'; 
}  
echo '</select>'; 
mysql_free_result( $result ); 
echo "<input type='submit' value='Submit'>";
echo "</form>";
?>
  </tr>
  
  
  <tr>
   <h1>Roller Coaster</h1>
<?php
echo '<form method="post" name="f2" action="dd-check.php">';
$query_r = "SELECT * FROM `seats` WHERE SrideID='2' ORDER BY seatID";  
$result = mysql_query($query_r);  

echo"<select name='seatNumber'><option value=''>Select Seat</option>";
while( $row = mysql_fetch_array($result) ) 
{ 
     echo '<option>'.$row['seatNumber'].'</option>'; 
}  
echo '</select>'; 
mysql_free_result( $result ); 
echo "<input type='submit' value='Submit'>";
echo "</form>";
?> 
  </tr>
  
  
  
  
  <tr>
   <h1>Ice Blast</h1>
<?php
echo '<form method="post" name="f3" action="dd-check.php">';
$query_i = "SELECT * FROM `seats` WHERE SrideID='3' ORDER BY seatID";  
$result = mysql_query($query_i);  

echo"<select name='seatNumber'><option value=''>Select Seat</option>";
while( $row = mysql_fetch_array($result) ) 
{ 
     echo '<option>'.$row['seatNumber'].'</option>'; 
}  
echo '</select>'; 
mysql_free_result( $result ); 
echo "<input type='submit' value='Submit'>";
echo "</form>";
?>
  </tr>
</table>



code for dd-check.php


<?php
$result=$_POST['seatNumber'];
echo " <p> the seat choosen is : $result <p> ";

//TEST PULL ALL QUERY
$testPullAll = mysql_query("SELECT * FROM ride");

echo "<table border='1'>
  <tr>
  <th>Name</th>
  <th>Duration</th>
  <th>Price</th>
    </tr>";

while($row = mysql_fetch_array($testPullAll))
  {
  echo "<tr>";
  echo "<td>" . $row['name'] . "</td>";
  echo "<td>" . $row['time'] . "</td>";
  echo "<td>" . $row['price'] . "</td>";
  echo "</tr>";
  }
echo "</table>";
?>



the end result will be a query in dd-check.php that says something like

if [hidden SrideID = 1]
echo 'the name, time and price of the ride'
if [hidden SrideID =2
echo name, time and price
if number 3 then echo the rest of the row.

any help would be great, i've been using trial and error so far (since yesterday afternoon) with no success  =(

ps sorry for the long post, i wanted to try and explain everything the best i can. =)

I have created a form which allows people to add data to a database.  However, I want to replicate the form across several pages and give each page a category.

For example, if I have a website based on sport.  I have a page which enters information into the baseball category, a page which enters information into the ice hockey category, a page which enters information into the soccer category etc.

Can someone advise how I would do this?

Hi Guys,

Appreciate any help here please...

Basically I want to hide some inputs on my registration page and populate them will default values.  Everything works okay, apart from the input below:

Code: [Select]
<input type="hidden" name="seek_location" value="Anywhere">
When I use the above, the MYSQL database field for seek_location is left empty...

I've noticed that the code below pulls the location into a dropdown list.  You know the kind of thing, Australia, UK, USA etc etc:

Code: [Select]
$seek_location = $wcr[$seek_location];
Code: [Select]
<? $p=0;asort($wcr);reset($wcr);
while (list ($p, $val) = each ($wcr)) {
echo '<option value="'.$p.'">'.$val;
}
?>
So, all I want to do is have:

Code: [Select]
<input type="hidden" name="seek_location" value="Anywhere">
Populate seek_location with Anywhere

Any help appreciated
Thanks
Rob

Hello everyone, I have a question.

I'm trying to figure out a way to make it so that when a user visits a page for a certain file, they are given the file to download but can't see the link to that file.

Example:
There is a file on http://serverB.com/file.rar
A person goes to http://serverA.com/?file=file.rar
They can download http://serverB.com/file.rar without seeing the link to that file.

Is there any way to do this?

Thanks.

I have a while loop that fetches data from the database and prints it out organized in a table.

Now I want to implement a voting functionality, the problem I'm encountering is, once I've printed out a list of tables one table after other with the while loop I need to figure out a way to tell the query TO WHICH of those tables to ADD or SUBTRACT the vote.

I thought of implement a hidden id field into the while loop of contributions, the id field would be fetched from the auto_increment field in the contribution table in the MySQL database.

Since the id field is unique there can be no misunderstandings to which table to add the vote.

My question how can I do exactly that? How can I add a hidden id field to the while loop with the table WHICH I then can pass along to the voting script.

Here's the while loop:

while ($row = mysqli_fetch_array($data)) 

{

echo "<table padding='0' margin='0' class='knuffixTable'>";

echo "<tr><td width='65px' height='64px' class='avatar_bg' rowspan='2' colpan='2'><img src='$avatar_path' alt='avatar' /></td><td class='knuffix_username'><strong>" . $user_name;

echo "</strong><br />" . $row['category'] .  " | " . date('M d, Y', strtotime($row['contributed_date'])) . "</td></tr><tr><td>";

echo "<form action='' method='post'>

<input type='submit' name='plusVote' value='Y' />

<input type='submit' name='minusVote' value='N' />

</form></td><td class='votes'>Y[ - ] | N[ - ]</td></tr>";

echo "<tr><td class='knuffix_name' colspan='3'><strong>" . htmlentities($row['name']) . "</strong><br /></td></tr>";

echo "<tr><td colspan='2' class='knuffix_contribution'><pre>" . $row['contribution'] . "</pre><br /></td></tr>";

echo "</table>";

}


If I simply add $row['con_id'] it's obviously going to be echo'd out, what is the right practice to have it hidden?

This is just a snippet of my code. The php script itself is called test.php and so it calls itself once the form is submitted. I keep having problems retrieving the data back correctly; I am testing in retrieving the data on the same script from the same page before retrieving the POST data from another webpage.

If $decimalSum is a variable that assigns a value that is hard-coded then I would be able to retrieve the same value. However, if the value is computed I can not retrieve it unless I click on the "Find" button twice. This is such a strange behavior and I don't know why.

Does anyone have any suggested solutions to this?



<!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" xml:lang="en" lang="en">
<head>
  <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  <title></title>
</head>
<body>

<?php
echo '<form enctype="multipart/form-data" method="post" action="test.php">';

echo '   <label for="_firstName">First name :     </label>';
echo '   <input type="text" id="_firstName" name ="_firstName">';
echo '   <input type="checkbox" value="1" name="_firstNameChecked"/>';  

echo '   <label for="_middleName">Middle name :     </label>';
echo '   <input type="text" id="_middleName" name ="_middleName">';
echo '   <input type="checkbox" value="1" name="_middleNameChecked" />';
   
echo '   <label for="_lastName">Last name :     </label>';
echo '   <input type="text" id="_lastName" name ="_lastName">';
echo '   <input type="checkbox" value="1" name="_lastNameChecked" />';

echo '<br />';

echo '<input type="submit" name="Find" value="Find" />';

$firstNameChecked        = intval(($_POST['_firstNameChecked']));
$middleNameChecked    = intval(($_POST['_middleNameChecked']));
$lastNameChecked         = intval(($_POST['_lastNameChecked']));

$decimalSum = (int)((2*2*2)*$firstNameChecked + (2*2)*$middleNameChecked + (2*1)*$lastNameChecked);

//$decimalSum = 28;

echo '<br />';
echo '$decimalSum = ' . $decimalSum . '<br />';

echo '<input type="hidden" name="_decimalSum" value = "' . $decimalSum . '" />';

$decimalSum2      =     ($_POST['_decimalSum']);

echo '$decimalSum2  = ' . $decimalSum2 . '<br />';
   
echo '</form>';
echo '</body>';
echo '</html>';
?>