Insert multiple rows from array

Content Index :

Insert multiple rows from array
CakePHP 2 Insert Multiple Rows from Array
how to insert multiple rows in mysql using php array?
How to update the existing rows add insert new rows in table in laravel for multiple array values
when i insert multiple rows using multiple insert statements it is raising an error but when i use single rows then its
How to insert multiple rows into SQL using an Array?

Insert multiple rows from array

Tag : php , By : Dmitry

Date : November 24 2020, 03:01 PM

this one helps. If I convert the above query into mysqli, then will the code be below:

<?php

$link = mysqli_connect('localhost', 'root', '', 'mumbai');
$q = "select `cus_id`, `date`, `mobile`, 
      least(`t1`, `t2`, `t3`, `t4`) as min 
      from `table1`";

$asd = array(); 
$result = mysqli_query($link, $q);
while($r = mysqli_fetch_assoc($result)){

$asd = array(`cus_id` =>$r['cus_id'], 
             `mobile` =>$r['mobile'], 
             `date`   =>$r['date'], 
             `credit` =>$r['min']);
}

$sql = array();

foreach((array)$asd as $row){

$sql[] = '("'.mysqli_real_escape_string($row['cus_id']).'", 
                                 '.$row['mobile'].', 
                                 '.$row['date'].', 
                                 '.$row['min_total'].'
       )';
}
$stmt = mysqli_prepare($link, "INSERT INTO single 
               (`cus_id`, `mobile`, `date`, `time`, `credit`) VALUES (?,?,?,?,?)");

mysqli_stmt_bind_param($stmt, 'isssi', implode(',', $sql));                  

mysqli_stmt_execute($stmt);

if(!$stmt){ 
echo "error". mysqli_error($link);
}else{
$_SESSION['s']="Payment successfully saved";
header('location:final.php');
}
?>

Comments

No Comments Right Now !

Boards Message :

You Must Login Or Sign Up to Add Your Comments .

Share :

Tags :

Insert multiple rows from array , How to update the existing rows add insert new rows in table in laravel for multiple array values , when i insert multiple rows using multiple insert statements it is raising an error but when i use single rows then its , How to insert multiple rows into SQL using an Arr ,

CakePHP 2 Insert Multiple Rows from Array

Tag : php , By : jim

Date : March 29 2020, 07:55 AM

it should still fix some issue How to insert to multiple row from array in CakePHP? This is my print_r($_POST) , If your want to save the content of your Array
You can do it by

$data=$this->request->data;
saveAll($data, array('deep' => true));

how to insert multiple rows in mysql using php array?

Tag : php , By : Grace Jones

Date : March 29 2020, 07:55 AM

fixed the issue. Will look into that further How to pass array value from html form for multiple fields and insert multiple values into database using the array by php mysqli? , I assume your HTML code look like this.

<input type='text' name='username[]'>
<input type='text' name='fname[]'>
<input type='text' name='lname[]'>

<input type='text' name='username[]'>
<input type='text' name='fname[]'>
<input type='text' name='lname[]'>

.
.
.

<?php
$username = $_POST['username'];
$fname = $_POST['fname'];
$lname = $_POST['lname'];

$totalUsername = sizeof($username);

for($i=0;$i<$totalUsername;$i++) {

    $InsertUsername = $username[$i];
    $InsertFname = $fname[$i];
    $InsertLname = $lname[$i];

    $query = "INSERT INTO `table_name`(`username_columnname`, `fname_columnname`,`lname_columnname`)".
             " VALUES ('$InsertUsername','$InsertFname','$InsertLname') ";

}

?>

How to update the existing rows add insert new rows in table in laravel for multiple array values

Tag : development , By : Feroz

Date : March 29 2020, 07:55 AM

To fix the issue you can do You should be using a foreach loop to, well, loop through the fields and do something if it is empty or not.
Maybe, something like this would help you.

$fields = Input::get('user_id');

foreach($fields as $field)
{
    if(! empty($field))
    {
        // field is not empty
        // update here
    }
    else
    {
        // field is empty
        // do something here
    }
}

when i insert multiple rows using multiple insert statements it is raising an error but when i use single rows then its

Tag : sql , By : Martin

Date : March 29 2020, 07:55 AM

How to insert multiple rows into SQL using an Array?

Tag : sql , By : Paul McKee

Date : October 02 2020, 05:00 AM

I hope this helps you . SQL doesn't understand arrays, but you can list multiple insert values like below.

INSERT INTO [dbo].[BudgetAndAuthorizationChangeReasons]
        ([ChangeReason]
        ,[IsActive]
        ,[CreatedByUser]
        ,[CreatedOn]
        ,[LastUpdatedByUser]
        ,[LastUpdatedOn])
     VALUES 
        ('Other'        , 'true', 'system', GETDATE(), null, null)
       ,('Scope Change' , 'true', 'system', GETDATE(), null, null)