PHP get_sql_columns_string Exemples

Exemple #1

Fichier : common.php Projet : elpadi/dahlen-studio

function get_delete_sql($table, $whereCols, $data)
{
    return "DELETE FROM `{$table}` WHERE " . get_sql_columns_string($whereCols, ' AND ');
}

Exemple #2

Fichier : dahlen_image.php Projet : elpadi/dahlen-studio

function dahlen_image_update_slideshow_image($image, $slideshowID)
{
    $cols = dahlen_image_get_image_columns($image);
    $sql = "UPDATE `SlideshowImage` SET " . get_sql_columns_string($cols) . " WHERE `ZenphotoID`={$image['ZenphotoID']} AND `SlideshowID`=" . intval($slideshowID);
    return db_execute($sql);
}