PHP - Insert Into Middle Of Array

Hi - I have an HTML form which is dynamically produced using CodeIgniter / PHP and presents products a customer has ordered.  When the customer has finished changing his quantities they must now submit the form.  My problem is that my form will contain many of the same named fields for example, 'Product ID', or 'Product Name' or 'quantity'. So now when it gets processed a typical post array like product id could look like this:

Code: [Select]
Array ( [0] => 28 [1] => 24 [2] => 101 [3] => 23 [4] => 17 )
Of course I get an error:

Quote

Severity: Notice

Message: Array to string conversion

Filename: mysql/mysql_driver.php


I really need some advice on how I should pre-process the various POST arrays so I can get them into my DB.

A very grateful student of PHP !

Thanks

If I have an array like this, what makes the most sense for inserting a key value pair after a given key? This is how I came up with to do it, after looking at the manual I'm not sure if there's a function I'm missing, because this seems way too complicated.
Code: [Select]
<?php
function addKV($arr, $keyToFind, $addKey, $addValue){
    $keys = array_keys($arr);
    $spot = array_search($keyToFind, $keys);
    $chunks = array_chunk($arr, ($spot+1));
    array_unshift($chunks[1], array($addKey=>$addValue));
    $arr = call_User_Func_Array('array_Merge', $chunks);
    return $arr;
}

$myArr = array('id'=>1, 'name'=>'Name', 'created'=>time(), 'modified'=>time());
$myArr = addKV($myArr, 'name', 'foo', 'bar');
?>$myArr now looks like
Code: [Select]
array('id'=>1, name=>'Name', 'foo'=>'bar', 'created'=>time(), 'modified'=>time());

I am trying to insert records from an foreach array, it only inserts the first record and I cannot work out how to get it to loop through all of the records.

Thank you


foreach($_SESSION['post_data_array'] AS $seat) {
     $rowId = substr($seat, 0, 1);
     $columnId = substr($seat, 1);
      echo $rowId . $columnId . ", "; 
}

$sql125 = "INSERT INTO booked_seats(booking_id, row_id, column_id) values ('$book_id', '$rowId', '$columnId')";

$result125 = mysql_query($sql125);

if ($result125)

{

echo "worked";

}

else

{

echo "didnt work";

}

Hi again  ,
I am stuck with simplest problem of array .. i searched all forums and couldn't find similar problem..
Iam collecting array post data "data m_name[][email]" from a form, but I don't know how to get 2 array variables at the same time, here's what I tried :

<form action="" method="post" name="myForm">
<div>
      <input type="text" name="m_name[]" />
      <input type="text" name="m_name[][email]" />
</div>
<div>
      <input type="text" name="m_name[]" />
      <input type="text" name="m_name[][email]" />
</div>
<div>
      <input type="text" name="m_name[]" />
      <input type="text" name="m_name[][email]" />
</div>
        <input type="submit" name="button" id="button" value="Submit" />
</form>

other page where I want to receive above array

<?php
if($_POST)
{

print_r($_POST['m_name']); // Output is : Array ( [0] => someone [1] => Array ( [email] => 3 ) [2] => someone two [3] => Array ( [email] => 4 ) [4] => someone three [5] => Array ( [email] => 5 ) )


while (list ($key,$val) = @each ( $_POST['m_name'])) { 
echo $val.val2 ???"<br/>"; // here I want to get both value $_POST['m_name'] and  $_POST['m_name'] ['email'] since I am putting them in db << 
}
}
?>

I want to get both values of $_POST['m_name'], I don't know how to do it or is there another way to do it?
thankx in advance!! phpfreaks have been very helpful ..

I'm trying to insert array of posts categories into MySQL. I'm getting category IDs from drop down list..

ERR: Notice: Notice: Array to string conversion in C:\laragon\*********\includes\functions.php on line 477

 

Array

Array
(
    [0] => Array
        (
            [0] => 4
            [1] => 5
        )

)

 

PHP

try {
        $sql = "INSERT INTO posts_category_ids (post_id, category_id) VALUES";

        $insertQuery = array();
        $insertData = array();
        foreach ($filter_category as $row) {
            $insertQuery[] = '(?, ?)';
            $insertData[] = $id;
            $insertData[] = $row;
        }

        if (!empty($insertQuery)) {
            $stmt = $this->conn->prepare($sql);
            $stmt->execute($insertData); //477
        }


         }catch (Exception $e){

            echo $e->getMessage();
}
}

 

Hi,

I am creating a new menu (food) in my system.  This consists of a menu, menu_items and menu_connection table.

I can insert the menu name just fine and return its id just fine.

When inserting the menu items, i need to get each of the menu_item_ids to use in the query that inputs the menu_connection.

This is what i have so far:

if ($_SERVER['REQUEST_METHOD']=="POST") {
	/////////////////////
	//menu name insert //
	/////////////////////
	
	$mname = mysqli_real_escape_string($conn, $_POST['newMenuName']);
	$stmt=$conn->prepare('
	                     INSERT IGNORE INTO ssm_menu (menu_name) VALUES (?);
	                     ');
	$stmt->bind_param('s',$mname);
	$stmt->execute();
	$menuInsId = $stmt->insert_id;
	echo $menuInsId;
	$stmt->close();

	/////////////////////
	//menu item insert //
	/////////////////////
	
	$mitname = $_POST['newMenuItem'];
	$stmt=$conn->prepare('
	                     INSERT IGNORE INTO ssm_menu_items (menu_item_name) VALUES (?);
	                     ');
	foreach ($_POST['newMenuItem'] as $k => $nmItem) {
		$mitname = mysqli_real_escape_string($conn, $nmItem);
		$stmt->bind_param('s',$mitname);
		$stmt->execute();
		$menuItmInsId = $stmt->insert_id;
		echo $menuItmInsId;
	}
	$stmt->close();

	///////////////////////////
	//menu connection insert //
	///////////////////////////

	
	$stmt=$conn->prepare('
	                     INSERT IGNORE INTO ssm_menu_connection (menu_id, menu_item_id) VALUES (?,?)
	                     ');
	foreach ($_POST['newMenuItem'] as $k => $nmItem) {
		$stmt->bind_param('ii',$menuInsId, $menuItmInsId);
		$stmt->execute();
		$connectionInserId = $stmt->insert_id;
		echo $connectionInserId;
	}
	$stmt->close();
}

Currently it is inserting each of the items in the connection table with the same id - i understand why but i dont know how to collect up all of the ids to use later

Hello,

I'm working on a form that once submitted, it inserts the result into my SQL table, but I'm trying to get it so it will update an imploded array.

EG: current SQL table is "red,blue,green". Then user submits 'white', the SQL table should then update to: "red,blue,green,white" (notice how its added to the end). This is what I have so far:

Code: [Select]
$attack_out = $info['attack_out'];
$attack_out_split = explode(",", $attack_out);

if(isset($_POST["submit_attack"])){
   $attack_user = $_GET["attack"]; // user - sent from form
   //$troops_send = $_POST["troop_send"]; // ammount - sent from form

   $attack_user_array = array();
   $i = 0;
   $max = (count($attack_out_split) + 1);
   while($i < $max){
      $reverse = ($max - 1) - $i;
      $attack_user_array[$i] = $attack_out_split[$reverse];
      $attack_user_array[$max - 1] = $attack_user;
      $i++;
   }
   $attack_user_glue = implode(",",$attack_user_array);
   $result = mysql_query("UPDATE users SET attack_out='$attack_user_glue' WHERE username='$username'");
}

I can't figure out the algorithm in my while loop. Would appreciate any help, thanks

I am making  a website where writers can share stories.
One of the fields is other stories.
So I used this code to make it a array with the links in each f the items.

$other_split = explode(',', $other_form);
$other_int = count($other_split);

$x = 0;
while ($x>$other_int)
{

$other_link[$x] = "<a href = '$other_split[$x]'> Chapter $x </a>";
}


How can I insert the data in that array into one non array variable.

Hi,   I'm currently passing an array of values to be updated in my database, but am struggling on the best way to escape the quotation marks around the NOW statement below, as understand this will only work without them.
  This is what is being passed to the DB which does not currently work. I'm seeking some help to find the best way to remove the "" from around the NOW statement, but retain it in the array structure which i believe needs the '' to understand its a value.

UPDATE staff SET staff_last_login="NOW()" WHERE staff_id="1" 

array('staff_last_login'=>'NOW()')

My question is - whats the best way to escape this?   I understand forward slashes can sometimes be used, and double quotes - but feel like i have exhausted all my known options.   Any help much appreciated.   MoFish

Hi Guys   I have a number of arrays that are posted from a form   They are $home_rider $order $away_rider $awayorder   for each home rider I want to to action the following query   "INSERT INTO tbl_lg_rider_order (`name`,`card_id`,`homeaway`,`riderorder`) VALUES ('$homerider',$card_id,'h','$homeorder')"   and for each away rider I want to do the following   "INSERT INTO tbl_lg_rider_order (`name`,`card_id`,`homeaway`,`riderorder`) VALUES ('$awayrider',$card_id,'a','$awayorder')"   I am using the following code  

$i=0;
for($i){
$homerider=$home_rider[$i];
$homeorder=$order[$i];
$homesql="INSERT INTO tbl_lg_rider_order (`name`,`card_id`,`homeaway`,`riderorder`) VALUES ('$homerider',$card_id,'h','$homeorder')";
echo $homesql;
$i++;
}
$i=0;
for($i){
$awayrider=$away_rider[$i];
$awayorder=$awayorder[$i];
$homesql="INSERT INTO tbl_lg_rider_order (`name`,`card_id`,`homeaway`,`riderorder`) VALUES ('$awayrider',$card_id,'a','$awayorder')";
echo $awaysql;
$i++;
}

  I am getting an error saying Parse error: syntax error, unexpected ')', expecting ';'   Where am I going wrong?

Good evening,   I am working on a program that takes images, and casts them into an associated array, I then want to display thumbnails of those images into a 3 column by 4 row table...   [image][image][image] [image][image][image] [image][image][image] [image][image][image]   (For my visual friends)   here is my current, pardon for the mess, but right now, functionality is more important.

<!DOCTYPE html>
<html>
<head>
	<title>Zodiac Gallery</title>
</head>
<body>
	
<h2 style="text-align:center">Zodiac Gallery</h2>
<p>Click a thumbnail image to see enlarged view.</p>
<?php

$ZodiacArray = array (
	"Images/rat.jpg" => "Rat",
	"Images/ox.jpg" => "Ox",
	"Images/tiger.jpg" => "Tiger",
	"Images/rabbit.jpg" => "Rabbit",
	"Images/dragon.jpg" => "Dragon",
	"Images/snake.jpg" => "Snake",
	"Images/horse.jpg" => "Horse",
	"Images/goat.jpg" => "Goat",
	"Images/monkey.jpg" => "Monkey",
	"Images/rooster.jpg" => "Rooster",
	"Images/dog.jpg" => "Dog",
	"Images/pig.jpg" => "Pig");

foreach ($ZodiacArray as $image => $zodiac)
	{
		echo "<table>
			<tr>
				<td><img src="$image"  alt="$zodiac" style="width:68px;height:65px"></td
				<td><img src="$image" alt="$zodiac" style="width:68px;height:65px"></td>
				<td><img src="$image" alt="$zodiac" style="width:68px;height:65px"></td>
			</tr>
			<tr>
				<td><img src="$image" alt="$zodiac" style="width:68px;height:65px"></td>
				<td><img src="$image" alt="$zodiac" style="width:68px;height:65px"></td>
				<td><img src="$image" alt="$zodiac" style="width:68px;height:65px"></td>
			</tr>
			<tr>
				<td><img src="$image" alt="$zodiac" style="width:68px;height:65px"></td>
				<td><img src="$image" alt="$zodiac" style="width:68px;height:65px"></td>
				<td><img src="$image" alt="$zodiac" style="width:68px;height:65px"></td>
			</tr>
			<tr>
				<td><img src="$image" alt="$zodiac" style="width:68px;height:65px"></td>
				<td><img src="$image" alt="$zodiac" style="width:68px;height:65px"></td>
				<td><img src="$image" alt="$zodiac" style="width:68px;height:65px"></td>
			</tr>
		</table>";

?>

Help is welcome, thank you.

Hi guys   A mobile application send data in Json format, so I want to insert the data into Mysql table, when I try to insert I have gotten the error "PHP Warning: mysqli::prepare() expects exactly 1 parameter, 3 given", my table only has 2 columns, "id" and "name" column.   The array has this data

(
[0] => ('id', '2')
[1] => ('name', 'Jhon')
)

The function to parse and insert data ...

function redeem() {
    // Check for required parameters
        $json = file_get_contents('php://input');
        $obj = json_decode($json,true);
        // Assumes $obj == array(0 => $assocArray, 1 => $assocArray)
        foreach($obj as $index => $assocArray) {
            // Assumes $assocArray == array(0 => array('id' => '2'), 1 => array('name' => 'John'))
            $stmt = $this->db->prepare('INSERT INTO prueba (id,nombre) VALUES (%d,%s)',$assocArray[0]['id'],$assocArray[1]['name']) or die(mysqli_error($this->db));
            $stmt->execute();
            
        }    
        
    }

Edited by Maq, 06 June 2014 - 03:54 PM.

Hello all
 
First of all nice to meet you since this is my first post. I have been reading already for a longer time but so far I managed to always fix my issues.
Currently I am having the other way around so I registrated and decided to ask for help.
 
The goal is to push multiple insert into the database on the quickest possible way, Originally I did a loop insert but performance dies rather hard that way.
I got the code to the point that it is working without errors however it only inserts the latest row and not all of them.
Basicly that's the reason for my raging (hence the name) and my question do you guys. Should I take the hammer for my own head or my server ?   Thanks in advance   Bldyhll     $db->beginTransaction();
                    $stmt = $db->prepare("INSERT INTO scripts (val1,val2, val3,val4) VALUES ('',:val2,:val3,:val4) ");
                         while($j < count($fullarray)){
                          $stmt->bindParam(":val2", $fullarray[$j][0]);
                          $stmt->bindParam(":val3", $fullarray[$j][1]);
                          $stmt->bindParam(":val4", $fullarray[$j][2]);
                          $j++;
                       } $stmt->execute(); $db->commit();  

hi guys so i have this add contacts page and the form is divided into 3 different froms 1) primary contact 2)spouse 3)child and the child form data is inserted as array into database because in the primary contact part of the form there is a "Children ?" with yes and no radio button and if yes a drop down list is enabled where if user chooses say 2 then there would be 2 child form that appears. and since theres 2 children then in the database a new row and data will be added accordingly.   image attached to be clearer.    from2.jpg   24.15KB   0 downloads

i got it inserted into database but in the specified field it says array:   |child_name|dob|house_add1|mobile|office|email|
inserted:
|array|array-array-array|array|array|array|array|   query:

"INSERT INTO child VALUES('','".$childsalutations." $childfname $childlname',' ".$cday."-".$cmonth."-$cyear ','$childline1','$childline2','$childm','$childoff','$childemail')"

in a stackoverflow question(not my own question) someone says: information stating arrays need to be split, before inserting into the table. does that mean something like this?:

$cday = ($_POST['cday']);
$cmonth = ($_POST['cmonth']);
$cyear = ($_POST['cyear']);
$childsalutations = ($_POST['child-salutations']);
$childfname = ($_POST['child-fname']);
$childlname = ($_POST['child-lname']);
$childline1 = ($_POST['child-line1']);
$childemail = ($_POST['child-email']);
$childm = ($_POST['child-mobile']);
$childoff = ($_POST['child-office']);

$info = array('c_name' => $childsalutation $childfname $childlname, 'c_dob' => $cday-$cmonth-$cyear, 'c_line1' => $childline1, 'c_mobile' => $childm, 'c_office' => $childoff, 'c_email' => $childemail)

just in case u wanted to c the html child form(warning its abit long,very!):

<table class="prime">
	<tbody>
	<br>
	<tr><td style="font-size:20px;font-weight:bold">Child <span id="number"></span></td></tr>
	<tr>
		<td>Salutation :</td> 
		<td><select name="child-salutations[]" id="child-salutations">
				<option value="" disabled selected>Salutations</option>
				<option value="Datin">Datin</option>
				<option value="Datin Paduka">Datin Paduka</option>
				<option value="Dato Paduka">Dato Paduka</option>
				<option value="Dato'">Dato'</option>
				<option value="Dato' Seri">Dato' Seri</option>
				<option value="Datuk">Datuk</option>
				<option value="Datuk Seri">Datuk Seri</option>
				<option value="Dr.">Dr.</option>
				<option value="Haji">Haji</option>
				<option value="Hajjah">Hajjah</option>
				<option value="HM">HM</option>
				<option value="HRH">HRH</option>
				<option value="Miss">Miss</option>
				<option value="Mrs.">Mrs.</option>
				<option value="Mr.">Mr.</option>
				<option value="Pehin">Pehin</option>
				<option value="Professor">Professor</option>
				<option value="Raja">Raja</option>
				<option value="Tan Sri">Tan Sri</option>
				<option value="Tengku">Tengku</option>
				<option value="Tuanku">Tuanku</option>
				<option value="Tun">Tun</option>
				<option value="Tunku">Tunku</option>
				<option value="Ungku">Ungku</option>
				</select>
		</td>
	</tr>
	<tr><td colspan="2"><label class="label" style="color:Red">*If a person has many salutations, choose the highest form of salutation</label></td></tr>
	<tr><td>First Name :</td><td><input type="text" name="child-fname[]" id="child-fname" class="style" /></td>
			<td>Last Name :</td><td><input type="text" name="child-lname[]" id="child-lname" class="style" /></td></tr>
	<tr>
		<td>Date of Birth : </td>
		<td>
			<select name="cday[]">
			<option value=""selected disabled>Day</option>
			<option value="1">1</option>
			<option value="2">2</option>
			<option value="3">3</option>
			<option value="4">4</option>
			<option value="5">5</option>
			<option value="6">6</option>
			<option value="7">7</option>
			<option value="8">8</option>
			<option value="9">9</option>
			<option value="10">10</option>
			<option value="11">11</option>
			<option value="12">12</option>
			<option value="13">13</option>
			<option value="14">14</option>
			<option value="15">15</option>
			<option value="16">16</option>
			<option value="17">17</option>
			<option value="18">18</option>
			<option value="19">19</option>
			<option value="20">20</option>
			<option value="21">21</option>
			<option value="22">22</option>
			<option value="23">23</option>
			<option value="24">24</option>
			<option value="25">25</option>
			<option value="26">26</option>
			<option value="27">27</option>
			<option value="28">28</option>
			<option value="29">29</option>
			<option value="30">30</option>
			<option value="31">31</option>
		</select>
		<select name="cmonth[]">
			<option value="" selected disabled>Month</option>
			<option value="1">January</option>
			<option value="2">February</option>
			<option value="3">March</option>
			<option value="4">April</option>
			<option value="5">May</option>
			<option value="6">June</option>
			<option value="7">July</option>
			<option value="8">August</option>
			<option value="9">September</option>
			<option value="10">October</option>
			<option value="11">November</option>
			<option value="12">December</option>
		</select>
		Year : <input type="text" name="cyear[]" maxlength="4" size="4" class="year">
		</td>
	</tr>
		<tr><td>Where do they live ?</td><td colspan="3"><input type="radio" name="living[]" id="living-me" class="living-me"/>With Me<input type="radio" name="living[]" id="living-other" class="living-other"/>With Other Parent<input type="radio" name="living[]" id="living-own" class="living-own"/>Own</td></tr>
		<tr><td>House Address</td></tr>
		<tr><td>Line 1  :</td><td><input type="text" name="child-line1[]" id="child-line1" size="20" class="style" /></td>
		<td>Mobile No :</td><td><input type="text" name="child-mobile[]" id="child-mobile" class="style" /></td></tr>
		<tr><td>Office No :</td><td><input type="text" name="child-office[]" id="child-office" class="style" /></td>
		<td>Email Address : </td><td><input type="email" name="child-email[]" id="email" class="style" /></td></tr>
	</tbody>
</table>