PHP - Store Array In Session Array?

I want to store...

- questionID
- questionNo
- questionText

...in one array?

How do I do that?!


Debbie

Hi, I'm trying to store the first+lastname from my mysql user datababase into arrays like this:

// Fill up array with names
$a[]="Anna";
$a[]="Brittany";
$a[]="Cinderella";
$a[]="Diana";
$a[]="Eva";
$a[]="Fiona";
$a[]="Gunda";
$a[]="Hege";
$a[]="Inga";
$a[]="Johanna";
$a[]="Kitty";
$a[]="Linda";
$a[]="Nina";
$a[]="Ophelia";
$a[]="Petunia";
$a[]="Amanda";
$a[]="Raquel";
$a[]="Cindy";
$a[]="Doris";
$a[]="Eve";
$a[]="Evita";
$a[]="Sunniva";
$a[]="Tove";
$a[]="Unni";
$a[]="Violet";

Hello,

I'm trying to store the match I get in $result to a variable so that I can easily compare its other values against other values. Here is my code..

//loop through new orders array
foreach ( $orders as $order ) {
	
	//compare job number and line item against database information for a match
	if ( array_search ( $order[ 'job_number' ], array_column ( $result, 'job_number' ) ) !== false && array_search ( $order[ 'line_item' ], array_column ( $result, 'line_item' ) ) !== false ) {
		
		$db_match = key($result);
		
		echo '<br><br>'.$db_match.'<br><br>';
		
		echo 'Job: ' . $order['job_number'] . '/Line Item: ' . $order['line_item'] . ' was found<br>';
	
	//new order which doesn't exist in database
	} else {
		echo 'Job: ' . $order['job_number'] . '/Line Item: ' . $order['line_item'] . ' was not found<br>';
	}
}

When I do $db_match = key($result); I get 0 each time and when I do: 

$db_match = array_search ( $order[ 'job_number' ], array_column ( $result, 'job_number' ) ) !== false && array_search ( $order[ 'line_item' ], array_column ( $result, 'line_item' ) ) !== false;

I get 1 each time...which I assume is the number of matches which meet that criteria instead of the array key I found a match on.

Edited May 8, 2020 by mongoose00318

hello dear php-experts,   well i want to do some data-saving in the next few days.  i have some data amount to store in a mysql-db. well i am pretty sure this is a easy question for php-freaks  
the question is: from plain-text to mysql-db: how to store a triple / array?

how to store this data into a mysql-db

have a dataset of 10 000 lines:

{'data_1': 'data_2', 'data_3': 'data_4', 'data_5': 'data_6', 'data_7': 'data_8'}

    
    
    
 how to store this dataset into the mysql db ?  
    

love to hear from you

greetings
 

The Script:

<form method="post" action="<?php echo $_SERVER['PHP_SELF'] ?>">
    <input type="text" name="hashtags" />
    <input type="submit" name="submit" />

</form>
<?php

include("connect.php");

?>
<?php

if(isset($_POST['submit'])){

    $hashtags = explode(", ", $_POST['hashtags']);

    for($i= 0; $i < count($hashtags); $i++){

        $tqs = "SELECT `id` FROM `hashtags_two` WHERE `hashtags` = '" . $hashtags[$i] . "'";
        $tqr = mysqli_query($dbc, $tqs) or die(mysqli_error($dbc));

    }

    $fetch_array = array();
    while($row = mysqli_fetch_array($tqr)){
        $fetch_array[] = $row['id'];
    }

}

Hey, sorry for these fundamental array questions lately, I am not going to ask much more when it comes to this.   The hashtags come from the submit form (separated by commas) and get stored inside an array with the "explode()" function. The script should select the ID numbers of the hashtags from the table.   With the script above only the last row gets inserted into $fetch_array inside the while loop.   When the $fetch_array variable is printed on screen then only one ID number can be seen inside the array:

Array ( [0] => 24 ) 

How can I have the other ID numbers too?

Hi there

I have a MySQL database table that has multiple records which look like (1, Which of these are your favorite color(s)?, Red||Blue||Orange||Green, question-type1 )

I have written some PHP code in extracting that data into a HTML form. (The above data looks like a question with multiple options (radio buttons/checkboxes) below it).

Below is what I'm trying to achieve:
 When the action is Submit: store the question number, user responses of the options , time stamp and user name into a new database table.

I came to know that passing arrays will do the job, but I got stuck in the middle.

Please see the attached documents that has the code.

TIA




[attachment deleted by admin]

Hi

I have a results page from a  MySQL query and I have implemented pagination to present data in chunks of 25 per page in a table view (each row => 1 entry).

My problem is that next to each data row, I have a selection checkbox, and if the user clicks on it, he can download the selected entries. This thing worked OK before I employed paginated view, when I presented all data in one page. Now, if I select e.g. 2 entries in page 1, then I jump to page 12 and select another 2 entries, if I click on the "Retrieve" button, I get only the last 2 entries (from the last page visited).

How can I solve this problem? With JS? Can I use PHP only?

I am pulling 5 addresses and I am wanting to store these 5 addresses in columns in a separate table.  On the query string I put LIMIT 5.  How can I store the results of each of the 5 loops into columns in a separate table?  The columns are A1(for name), A2(for address), A3 (for city), A4 (for state), A5 (for zip), A6 (for phone), A7 (for miles),  .... then I also have B1-B7, C1-C7, D1-D7, and E1-E7.

I am basically wanting to store up to 5 addresses in an array and then update them into a mysql table.


Code: [Select]
foreach ($zips as $key => $value) {
 
$result = mysql_query("SELECT State FROM extreme WHERE Zip = '$key' AND Type='store' AND `InStore` <> 'NO' LIMIT 5", $db);
$num_rows = mysql_num_rows($result);

while($myrow = mysql_fetch_array ($result))
{


$Dealer=$myrow['Dealer'];
$Address=$myrow['Address'];
$City=$myrow['City'];
$State=$myrow['State'];
$Zip=$myrow['Zip'];
$Phone=$myrow['Phone'];
$Miles = $value;

 
 }
 
}

Hi,
I want to store files to variable array using glob()

like
$files[0] = xyz.txt
$files[1] = pqr.txt
.
.
.
$files[n] = nfile.txt

I know how to list files from directory using glob()

Code: [Select]
<?php
foreach (glob("*.txt") as $filename) {
    echo "$filename size " . filesize($filename) . "\n";
}
?>



How can I do that ?

how do i set a session array?

e.g. set session with variable $value = 13.

then set the next $value = 15 .


= 13 and [1]=15

how do i set this session. up? so it keeps on updating the array

why is it that i have to click add to cart 2 time inorder for the eventname and eventinfo to show up
if i click one time it add to the cart but it shows nothing

Code: [Select]
<?php 

//if user attempts to add something to the cart
if (isset($_POST['tid'])) {
    $tid = $_POST['tid'];
    $howmany = $_POST['howMany'];
$wasFound = false;
$i = 0;
// If the cart session variable is not set or cart array is empty
if (!isset($_SESSION["cart"]) || count($_SESSION["cart"]) < 1) { 
    // RUN IF THE CART IS EMPTY OR NOT SET
$_SESSION["cart"] = array(1 => array("item_id" => $pid, "quantity" => $howmany));
} else {
// RUN IF THE CART HAS AT LEAST ONE ITEM IN IT
foreach ($_SESSION["cart"] as $each_item) { 
      $i++;
      while (list($key, $value) = each($each_item)) {
  if ($key == "item_id" && $value == $tid) {
  //there will recive a message
  
  $msg = "Item is already in the cart";
  $wasFound = true;
  } // close if condition
      } // close while loop
       } // close foreach loop
   if ($wasFound == false) {
   array_push($_SESSION["cart"], array("item_id" => $tid, "quantity" => $howmany));
   }
}
header("location: cart.php"); 
    exit();
}
?>

<?php 
//render the cart for the user to view on the page
$cartOutput = "";
$cartTotal = "";
$product_id_array = '';
if (!isset($_SESSION["cart"]) || count($_SESSION["cart"]) < 1) {
    $cartOutput = "<h2 align='center'>Your shopping cart is empty</h2>";
} else {
// Start the For Each loop
$i = 0; 
    foreach ($_SESSION["cart"] as $each_item) { 
$item_id = $each_item['item_id'];
$sql = mysql_query("SELECT * FROM events WHERE id='$item_id' LIMIT 1");
while ($row = mysql_fetch_array($sql)) {
$eventname = $row["eventname"];
$eventinfo = $row["eventinfo"];
$studentsprice = $row["studentsprice"];
}

//adding the price of the tickets 
//getting the total
$totalprice = $studentsprice * $howmany;
setlocale(LC_MONETARY, "en_US");

//this will amke it so it looks like real money
$totalprice = money_format("%10.2n", $totalprice );

$cartOutput = "";

//this is the table the will replace the table row below
//this is in order
$cartOutput.= "<tr>";
$cartOutput .= "<td>".$eventname."</td>";
$cartOutput .= "<td>".$eventinfo."</td>";
$cartOutput .= "<td>".$studentsprice."</td>";
$cartOutput .= "<td>".$howmany."</td>";
$cartOutput .= "<td>".$totalprice."</td>";
$cartOutput .= "<td>".X."</td>";
$cartOutput .= "</tr>";
    } 
}
?>

I am trying to send some arrays to another page using sessions. The first array I send works fine when I simply print the array on the next page but the second and third arrays are not being created.

Code
Code: [Select]
<?php
 
require("dbconn.php");
$query = mysql_query("SELECT username, idcustomers FROM customers
WHERE username='$customeruser' ");

if (!$query) {
die('Invalid query: ' . mysql_error());}

$row = mysql_fetch_assoc($query);
echo $row['username'];
$id=$row['idcustomers']; 
echo $id;

$productquery = mysql_query("SELECT productid, price1, price2, price3, price1_type, price2_type, price3_type, prod_name, price_det FROM  product_pricing
WHERE idcustomers='" . mysql_real_escape_string($id) . "' ORDER BY productid");

if (!$productquery) {
die('Invalid query: ' . mysql_error());}


$counter = 1;
$itemcode_array = array();
while ($row = mysql_fetch_assoc($productquery)) {



?>
<tr class="ordertable">
<td class="table_item" name="itemcode<?php echo $counter;?>"><?php echo $row['productid']; ?></td><?php $itemcode_send = $row['productid']; array_push($itemcode_array, $itemcode_send); ?>
<td class="table_name" name="prodname<?php echo $counter;?>"><?php echo $row['prod_name']; ?></td><?php $prod_name_send = $row['prod_name']; array_push($prodname_array, $prod_name_send); ?>
<td class="table_pdet" name="prod_det<?php echo $counter;?>"><?php echo $row['price_det']; ?></td><?php $price_det_send = $row['price_det']; array_push($pricedet_array, $price_det_send); ?>
<td class="table_price" name="price1<?php echo $counter;?>"><?php echo $row['price1_type']; ?> $<?php echo $row['price1']; ?></td>
<td class="table_quant" name="quant1"><input type="text" name="quant1<?php echo $counter;?>" size="4" /></td>
<td class="table_price" name="price2<?php echo $counter;?>"><?php echo $row['price2_type']; ?> $<?php echo $row['price2']; ?></td>
<td class="table_quant" name="quant2"><input type="text" name="quant2<?php echo $counter;?>" size="4" /></td>
<td class="table_price" name="price3<?php echo $counter;?>"><?php echo $row['price3_type']; ?> $<?php echo $row['price3']; ?></td>
<td class="table_quant" name="quant3"><input type="text" name="quant2<?php echo $counter;?>" size="4" /></td>
<td class="table_note" name="notes"><input type="text" name="note<?php echo $counter;?>" size="28" /></td>
</tr>

<?php
($counter++);
} ?>
<?php mysql_close($dbConn); ?>

</table>
<p><input type="submit" name="submit" value="Confirm" />&nbsp;<input type="reset" /></p>
</form>


<?php print_r($prodname_array);

$_SESSION["itemcode"] = $itemcode_array;
 $_SESSION["prodname"] = $prodname_array;
 $_SESSION["pricedet"] = $pricedet_array; ?>



There is some redundant and error testing code in there.

The problem is $prodname_array; and $pricedet_array; are not being created even though $itemcode_array which is created the same way works fine. All values from the database are being displayed correctly  (eg $row['prod_name'].

Hi Guys,

I am having a small problem with an array.

I want to push information from a form into an array.

However each time I do it it just replaces the last entry in the array with the information in stead of adding a new value to the array.

Code: [Select]

<?php

// if generate is pressed
if(isset($_POST['generate'])){

// get values from form
$name = htmlspecialchars($_REQUEST['add']);
array_push($stack, $name);

print_r($stack);
}
?>


Can anybody help?

Thanks

Ed

Hi All,

I'm running trying to add key and values to an array on multiple pages, but it seems to override the array each time I add variables on the next page, even though the keys are different.

Each page has something like this:


Code: [Select]
<label class="yes"><input type="radio" name="form_field[<?php echo "number".$f1; ?>]" value="0" > Yes</label>
<label class="no"><input type="radio" checked="checked" name="form_field[<?php echo "number".$f1; ?>]" value="1" > No</label>
<label class="unsure"><input type="radio" name="form_field[<?php echo "number".$f1; ?>]" value="2" > Unsure</label>
I then collect it as well as other page variables with:

Code: [Select]
session_start();

foreach($_POST as $name => $value) {
$_SESSION[$name] = $value;
}
on all following pages. But rather than adding to the array it writes over it each time.

Any ideas on what's going wrong here. Should the array simply be able to continue to collect the keys or do I need to do something else?

Thanks.

Hi Guys,

How can I send a session array through the URL and then use the values on the other page to create an SQL query?

Any Ideas?

Thanks in advance.

Ed