Answers for "update using array"

Whatever

0

update using array

/* function to build SQL UPDATE string */
function build_sql_update($table, $data, $where)
{
    $cols = array();
 
    foreach($data as $key=>$val) {
        $cols[] = "$key = '$val'";
    }
    $sql = "UPDATE $table SET " . implode(', ', $cols) . " WHERE $where";
 
    return($sql);
}

Posted by: Guest on October-11-2021

Source

Code answers related to "update using array"

Code answers related to "Whatever"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#