logo
down
shadow

XML to database - foreach loop to MySQL


XML to database - foreach loop to MySQL

By : OzZ
Date : October 24 2020, 08:10 PM
help you fix your problem You need to build the full query outside the inner most foreach. Something like this will be a good start. This thread should be able to help you to get the binding to work with mysqli, MySQLI binding params using call_user_func_array. With PDO you'd just pass $params to the execute function.
code :
foreach ($xml->METADATA->DATA as $item) {
    foreach ($item->children() as $child) {
        $cols[] = $child->getName();
        $params[] = $child->nodeValue;
    }
    if(!empty($params)) {
         $columns = implode(',', $cols);
         $placeholders = rtrim(str_repeat('?, ', count($params)), ', ');
         $sql = 'INSERT INTO dwh_xml ( ' . $columns . ') VALUES(' . $placeholders . ')';
         $stmt = $db_con->prepare($sql);
         $stmt->execute();
         unset($params, $cols, $placeholders);
    }
}


Share : facebook icon twitter icon
While database loop in a foreach array loop. PHP/MYSQL

While database loop in a foreach array loop. PHP/MYSQL


By : user3774112
Date : March 29 2020, 07:55 AM
will help you If I understand what it means, you will need to run mysql_query command every step inside foreach, not just run mysql_fetch_assoc like you're actually doing.
Inserting PHP variables into MySQL database using foreach loop

Inserting PHP variables into MySQL database using foreach loop


By : Rajesh Srivastava
Date : March 29 2020, 07:55 AM
I think the issue was by ths following , You cannot use a where clause in an insert statement. I think you want to use update instead.
code :
mysql_query("update merchantinfo set ProductCount= $value WHERE MerchantID = $key");
DELETE FROM - foreach loop on MYSQL database

DELETE FROM - foreach loop on MYSQL database


By : user2917189
Date : March 29 2020, 07:55 AM
Hope this helps First off, deleting in a loop is the anthesis of using a database. You should do a batch delete.
One way of doing this is to aggregate the IDs into a string $values in the form: id1, id2, id3, ... and then do something like
code :
$query = "DELETE FROM wp_users WHERE ID in ($values)";
How can I group similar results from mySQL database in foreach loop?

How can I group similar results from mySQL database in foreach loop?


By : Britton Beeland
Date : March 29 2020, 07:55 AM
fixed the issue. Will look into that further different ways:-
1.DISTINCT:-
code :
$pdo = $db->prepare('SELECT DISTINCT name FROM animals WHERE id = :id ');
$pdo = $db->prepare('SELECT name FROM animals WHERE id = :id  GROUP BY name');
PHP / MySQL - foreach loop $_POST inserting into database not working

PHP / MySQL - foreach loop $_POST inserting into database not working


By : Austin White
Date : March 29 2020, 07:55 AM
This might help you The original sql sort of looks like an attempt at using prepared statements - but was vulnerable to sql injection - you should be able to do something like this:
code :
if ( isset($_POST['upload']) ) {

    //connect to the database
    $db = mysqli_connect('', '', '', '');

    $sql = "INSERT INTO table ( paragraph ) VALUES ( ? )";
    $stmt=$db->prepare($sql);

    if( $stmt ){

        $stmt->bind_param('s',$paragraph);

        foreach ( $_POST['paragraph'] as $paragraph){
            $stmt->execute();
        }
        $stmt->close();
    }
    exit( header("location: form.php") );
}
Related Posts Related Posts :
  • Increment value with get
  • Laravel 5.5: Convert query builder to eloquent
  • Reverse proxy onto a WordPress page?
  • Jumble Solver url rewrite
  • Using .htaccess to Execute php if directory of the same name not found
  • mysql - Unknown Column In Where Clause
  • Receive Emails into my Admin panel with php or other
  • PHP - adding only distinct value to an array in foreach loop not working
  • How to pass date picker from one page to another
  • Try catch always return error when I insert 2 data
  • Php redirect not working on submission
  • How to get array value from wordpress database get_results
  • how Automatically go from first.php to second.php
  • uploading file not working in codeigniter 3 error: you did not select any file
  • Yii2, gridview can not show some html tags inside cells
  • What are the thing we need to configure to implement live notification module (using redis and socket.io) in https serve
  • How to handle multi criterias search in PHP
  • PHP - Get maximum key and its value in array
  • PHP: how to retrieve all the metrics and dimensions from the Google Metadata API?
  • Deliver php mails to special-character-email adresses, such as äüö
  • Delete a single row from an MSSQL table from PHP
  • Property [name] does not exist on this collection instance
  • Pass input value through PHP parameter
  • Running two PHP versions on the same server (STRETCH)
  • Checking if a file has been selected for upload
  • Model not updating laravel
  • How to add a description of words from text to an array, to an array key by passing words?
  • Nginx rewrite rule not not passing variables if "/" is at the end of the url
  • Modify decimal point and thousands separator without changing the number of decimals
  • Remove PHP errors from CLI and PHPMyAdmin
  • Yii2 rest api - Url manager add parameters
  • 1-query batch update array of users using PDO
  • Keep getting error: implode(): Invalid arguments passed when updating data
  • Laravel 5.4 - Correct Validation rule for a required parameter that can be zero
  • What does this code mean: $objPHPExcel->getActiveSheet()->toArray(null, true,true,true)
  • Data not being added to mysql table but echo's the data?
  • While fetch row in PHP
  • IP long string filter
  • How to view first image in list per user as its highlight Profile
  • Insert multiple rows from array
  • PHP : How to remove a duplicate array item ONCE
  • Print the input box text as simple text instead of html tag
  • How to read a string variable in php as $_GET or $_POST?
  • MySQL query fetch array not working
  • LogicException with message '... must return a relationship instance.'
  • PHP - create new array with only selected keys from an existing array
  • How to allow backgrounding a process to survive a session termination?
  • How to redirect to Home page (Default page) in zend framework 2?
  • I want to call a jquery variable in php syntax
  • Disabling the default /?add-to-cart= animation on buttons in Woocommerce
  • How to use query data for another sql query in yii2
  • Replace string enclosed in specified characters based on data type
  • Symfony FormType: how to get prototype in form type file
  • Handle reply messages properly after some operations in php
  • PHP Changed Domain, how to remove old Session Cookies
  • mysqli_stmt::bind_param(): Number of variables doesn't match number of parameters in prepared statement in php
  • Error: Call to a member function update() on array laravel
  • How to change the format of a float number?
  • run ajax requests by order
  • Wordpress Install 404 Error (Cannot view login in browser)
  • shadow
    Privacy Policy - Terms - Contact Us © voile276.org