Learn VBA & Macros in 1 Week!

PHP - Php Sql - Insert Imploded Array Into Table

Full Excel VBA Course - Beginner to Expert

Php Sql - Insert Imploded Array Into Table	View Content

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

Full Excel VBA Course - Beginner to Expert

Similar Tutorials

Insert Into Table From Array

How To Insert An Array Into A Mysql Table?

Insert Into Table Associative Array

Php: Insert An Associated Array Variable Into A Table

Insert Form Variable In First Table And While Loop Variables (array) In The 2nd

Mysql Insert Into Putting Array On Seperate Table Rows

How To I Secure My Imploded Data?

Check If Something Needs To Be Imploded To Implode!

How To Insert Images Into An Array From Php Variable To Javascript Array

Insert Array Vales Into Sting Of Another Array

Insert One Table Id To Another For Loop Table Column Field.

Insert If Into An Array

Insert Array In Mysql

Use Insert Ids From An Array In Another Query

How Do I Insert Into My Db A Post Array ?

Array Values To Insert In Db

Insert A Value Into The Middle Of An Array

Insert Key=value Pair In Array After Given Key

Insert Into Middle Of Array

Insert Array Error

Learn VBA & Macros for Excel in 1 Week!

Insert Into Table From Array

Similar Tutorials

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";

}

How To Insert An Array Into A Mysql Table?

Similar Tutorials

Insert Into Table Associative Array

Similar Tutorials

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.

Php: Insert An Associated Array Variable Into A Table

Similar Tutorials

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.

Insert Form Variable In First Table And While Loop Variables (array) In The 2nd

Similar Tutorials

First page adds a new job number, then the order page loaded with the job number id as a get id. Basically there is a while loop in the order page which shows products/services client can order and he chooses what he requires 'one or eight services' (8 in total) and some other variables like date of order and client name etc. Here is the order item code

The first sql statement executes fine, but in the second sql query nothing happens

$sql="insert into job_order(order_num,order_date,order_customer_id, order_remarks) values(".$_GET['id'].",NOW(),".$_POST['companyBox'].",'".$_POST['remarkBox']."');"; $res=mysql_query($sql); $id=mysql_insert_id();   foreach($_POST as $key => $value) {          if(!empty($value)) {           $key.' => '.trim(strip_tags($value));            $order="INSERT INTO orderprod (order_num,prod_id,order_amount,teeth_amount) VALUES ('$_GET[id]','$value','$value','$value');"; $orderres=mysql_query($order) or die(mysql_error()); } }?>$sql="insert into job_order(order_num,order_date,order_customer_id,
order_remarks)
values(".$_GET['id'].",NOW(),".$_POST['companyBox'].",'".$_POST['remarkBox']."');";
$res=mysql_query($sql);

$id=mysql_insert_id();

foreach($_POST as $key => $value) {

        if(!empty($value)) {

         $key.' => '.trim(strip_tags($value));

         $order="INSERT INTO orderprod (order_num,prod_id,order_amount,teeth_amount) VALUES
('$_GET[id]','$value','$value','$value');";
$orderres=mysql_query($order) or die(mysql_error());
}
}
?>

=============

This is the formI have removed parts which are irrelevant. Please note that dateBox and companyBox are not required to be looping as they are only for first table,

echo "<form action=".$config_basedir."./vieworder.php?id=".$_GET['id']."  name=form1 method=post>";?><table><tr><td><h4>JOB ORDER</H4></TD><TD></TD></TR><TR><TD>ORDER NUMBER</TD><TD><?PHP ECHO $_GET['id'] ?></td></tr><tr><td>ORDER DATE</td><td><input type=text name=dateBox></td></tr> <tr><td>COMPANY NAME</td><td><?PHP$sql="select * from customers";$res=mysql_query($sql);echo "<select name=companyBox><option value=''>Please select</option>";WHILE($fetch=mysql_fetch_assoc($res)){ echo "<option value='".$fetch['id']."'>".$fetch['cust_name']."</option>";} echo "</select>"; echo "</td></tr>"; ?>   </table> <table><tr><th>ITEM</th><th>QUANTITY</th><th>N0. of Teeths</th></tr><tr><?PHP$sql="select * from products";$res=mysql_query($sql); WHILE($fetch=mysql_fetch_assoc($res)){ echo "<td><input type=text name=desBox value='".$fetch['prod_id']."'>".$fetch['prod_name']."</td><td><input type=text name=quantBox></td><td><input type=text name=teethBox></td>";echo "</tr>";}echo "</table>";?>echo "<form action=".$config_basedir."./vieworder.php?id=".$_GET['id']."  name=form1 method=post>";
?>
<table>
<tr>
<td><h4>JOB ORDER</H4></TD><TD></TD>
</TR>
<TR>
<TD>ORDER NUMBER</TD><TD><?PHP ECHO $_GET['id'] ?></td>
</tr>
<tr>
<td>ORDER DATE</td><td><input type=text name=dateBox></td>
</tr>

<tr>
<td>COMPANY NAME</td><td>
<?PHP
$sql="select * from customers";
$res=mysql_query($sql);
echo "<select name=companyBox><option value=''>Please select</option>";
WHILE($fetch=mysql_fetch_assoc($res)){

echo "<option value='".$fetch['id']."'>".$fetch['cust_name']."</option>";}
echo "</select>";
echo "</td></tr>";
?>

</table>

<table>
<tr>
<th>ITEM</th><th>QUANTITY</th><th>N0. of Teeths</th>
</tr>
<tr>
<?PHP
$sql="select * from products";
$res=mysql_query($sql);

WHILE($fetch=mysql_fetch_assoc($res)){

echo "<td><input type=text name=desBox value='".$fetch['prod_id']."'>".$fetch['prod_name']."</td>
<td><input type=text name=quantBox></td>
<td><input type=text name=teethBox></td>";
echo "</tr>";}
echo "</table>";
?>

HERE IS THE IMAGE showing the populated services.
http://dubads.com/images/order.jpg

Mysql Insert Into Putting Array On Seperate Table Rows

Similar Tutorials

Hi again all,

Why does the foreach loop im doing, put the array values from collection, into seperate table rows rather than 1 row per whole array?

    <?php
        class registration{
            public $fields = array("username", "email", "password");
            public $data = array();
            public $table = "users";
            public $dateTime = "";
            public $datePos = 0;
            public $dateEntryName = "date";
            public $connection;

            function timeStamp(){
                return($this->dateTime = date("Y-m-d H:i:s"));
            }

            function insertRow($collection){
                    //HERE
                    foreach($this->fields as $row => $value){
                        mysql_query("INSERT INTO $this->table ($value)
                        VALUES ('$collection[$row]')");
                    }

                    mysql_close($this->connection->connectData);
            }

            function validateFields(){

                $this->connection = new connection();
                $this->connection->connect();

                foreach($this->fields as $key => $value){
                    array_push($this->data, $_POST[$this->fields[$key]]);
                }
                $this->dateTime = $this->timeStamp();
                array_unshift($this->data, $this->dateTime);
                array_unshift($this->fields, $this->dateEntryName);

                foreach($this->data as $value){
                    echo "$value";
                }

                $this->insertRow($this->data);
            }
        }

        $registration = new registration();
        $registration->validateFields();
    ?>

I end up with 3 rows

row 1: username
row 2: email
row 3 : password

rather than row 1:username email password.

How To I Secure My Imploded Data?

Similar Tutorials

Code: [Select]
$ids = implode(",", $_POST['m']);
$db->query('DELETE FROM friends WHERE friend_id IN ('.$db->escape($ids).') AND user_id = '.$pun_user['id'].'') or error('Unable to remove users from online list', __FILE__, __LINE__, $db->error());
redirect("s.php?section=Friends","Thanks, Friends removed :(");
Is there any other way to secure it better?

I feel like im missing something, i just don't want to get hacked

also added

$ids = implode(",", $_POST['m']);
if ($ids < 1)
message("Incorrect Data");

Check If Something Needs To Be Imploded To Implode!

Similar Tutorials

Is there a way to check if a value needs to be imploded and if it does, it implodes the variable? And vice versa with explode? How would this be done?

Thanks!

How To Insert Images Into An Array From Php Variable To Javascript Array

Similar Tutorials

I need a help in the following :
I have an admin page from where the admin attaches an gif image.This attached image should be shown to the user as a scrolling image.
The code for the scrolling image is done through javascript.
So my actual problem is getting the name of the attached gif image to the javascript array which is used for scrolling horizontally.

Insert Array Vales Into Sting Of Another Array

Similar Tutorials

I have an array $array_1
Code: [Select]
ARRAY(
[0] => info 1
[1] => info 2
[2] => info 3
)
and I have another array $array_2
Code: [Select]
ARRAY(
[0] =>thank you and welcome to what ever
[1] =>the info you added * thanks for entering your info
)
I want to loop though the first array and place the values into the [1] of the second array. But the tricky thing is I want it to insert were the * is.

Code: [Select]

foreach ($array_1 as $key => $val) {
//not sure about this
insert into ($array_2[1],after *, $val);
}
any help would be awesome.

Insert One Table Id To Another For Loop Table Column Field.

Similar Tutorials

Hi I am very new to PHP & Mysql. I am trying to insert values into two tables at the same time. One table will insert a single row and the other table will insert multiple records based on user insertion. Everything is working well, but in my second table, 1st Table ID simply insert one time and rest of the values are inserting from 2nd table itself. Now I want to insert the first table's ID Field value (auto-incrementing) to a specific column in the second table (only all last inserted rows). Ripon. Below is my Code:

<?php



$con = mysql_connect("localhost","root","aaa");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }


mysql_select_db("ccc", $con);


$PI_No = $_POST['PI_No'];
$PO_No = $_POST['PO_No'];


$qry = "INSERT INTO wm_order_entry (
Order_No,
PI_No,
PO_No) 


VALUES(
NULL,
  '$PI_No',
 '$PO_No')";
$result = @mysql_query($qry);




$val1=$_POST['Size'];
$val2=$_POST['Style'];
$val3=$_POST['Colour'];
$val4=$_POST['Season_Code'];
$val5=$_POST['Dept'];
$val6=$_POST['Sub_Item'];
$val7=$_POST['Item_Desc'];
$val8=$_POST['UPC'];
$val9=$_POST['Qty'];
$N = count($val1);
for($i=0; $i < $N; $i++)
{


$profile_query = "INSERT INTO order_entry(Size,
Style,
Colour,
Season_Code,
Dept,
Sub_Item,
Item_Desc,
UPC,
Qty,
Order_No
) VALUES( '$val1[$i]','$val2[$i]','$val3[$i]','$val4[$i]','$val5[$i]','$val6[$i]','$val7[$i]','$val8[$i]','$val9[$i]',LAST_INSERT_ID())";
$t_query=mysql_query($profile_query);
}
header("location: WMView.php");
mysql_close($con);
?>

Output is attached.

Insert If Into An Array

Similar Tutorials

Hi people I am new to php and I need your help. I am usig libchart and want to make the bars colored based on value: Original code: $this->setBarColor(array(
                    new Color(42, 71, 1),
            )); I want to make something like this: $this->setBarColor(array( if ( (    condition1     )) new Color(42, 171, 1),   if ( (    condition2     )) new Color(42, 71, 1), if ( (    condition3     )) new Color(42, 71, 211),
            )); I do not know php syntax yet, so how can I do this? Thank you, Alex

Insert Array In Mysql

Similar Tutorials

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();
}
}

Use Insert Ids From An Array In Another Query

Similar Tutorials

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

How Do I Insert Into My Db A Post Array ?

Similar Tutorials

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

Array Values To Insert In Db

Similar Tutorials

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

Insert A Value Into The Middle Of An Array

Similar Tutorials

I looked through all the array functions in the manual, but didn't see what I needed (might have just missed it)

Is there a way to stick a value into the middle of an array, without writing over the current value? I would need it to just push the rest back 1.

Hope that explains what Im looking for!

Thanks in advance

Insert Key=value Pair In Array After Given Key

Similar Tutorials

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());

Insert Into Middle Of Array

Similar Tutorials

HELP!!! PLEASE!!!

Here's what's happening:

I have a string much like this one:

Code: [Select]
$str = "84,390961CPK_100,'Pink Coloured Cord',15,'390961CPK_100',1";
I need to insert apostrophes around the first instance of 390961CPK_100 so it reads '390961CPK_100' and not simply 390961CPK_100.

To do this I have made the string into an array as follows:

Code: [Select]
$str_array = str_split($str);
Now I need to insert quotes into the array of characters, then convert the whole mess into back into a string. I can't go by hard coded index numbers, because all of the text in this string is variable in length, so I have to go by the first and second positions of the commas.

I have no idea how to do this, and it needs to be done yesterday! Mucho Gracias to anyone who can help me with this.

Insert Array Error

Similar Tutorials