Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Wpdb update via $wpdb->query() not working

I'm trying to make a wordpress plugin and i came over a problem.

The problem is with an update query which i can't figure out why it isn't working. The query should update a non wordpress table

global $wpdb;
$sql ="UPDATE $lmdisp_table_name
            SET `".$lmdisp_nume."`=".$nume.",
                `".$lmdisp_departament."` = ".$dep.",
                `".$lmdisp_an."` = ".$an.",
                `".$lmdisp_grupaserie."` = ".$grupa.",
                `".$lmdisp_tel."` = ".$tel."' ,
                `".$lmdisp_email."` = ".$email.",
                `".$lmdisp_fb."` = ".$fb.",
                `".$lmdisp_tw."` = ".$tw.",
                `".$lmdisp_linked."` = ".$linked.",
                `".$lmdisp_freel."` = ".$freel.",
                `".$lmdisp_blog."` = ".$blog.",
                `".$lmdisp_memyear."` = ".$memyear.",
                `".$lmdisp_fctlse."` = ".$fct.",
                `".$lmdisp_evlse."` = ".$evlse.",
                `".$lmdisp_skills."` = ".$skills.",
                `".$lmdisp_avatar."` = ".$avatar.",
                `".$lmdisp_cv."` = ".$cv."
           WHERE  `".$lmdisp_id."` = ".$id."";

    $rez = $wpdb->query($sql);

A little help ?:(

like image 979
Andrei Terecoasa Avatar asked Feb 13 '23 06:02

Andrei Terecoasa


1 Answers

Try SQL Query like this:-

<?php 
global $wpdb;
$sql ="UPDATE $lmdisp_table_name
    SET `".$lmdisp_nume."`= '".$nume."',
    `".$lmdisp_departament."` = '".$dep."',
    `".$lmdisp_an."` = '".$an."',
    `".$lmdisp_grupaserie."` = '".$grupa."',
    `".$lmdisp_tel."` = '".$tel."' ,
    `".$lmdisp_email."` = '".$email."',
    `".$lmdisp_fb."` = '".$fb."',
    `".$lmdisp_tw."` = '".$tw."',
    `".$lmdisp_linked."` = '".$linked."',
    `".$lmdisp_freel."` = '".$freel."',
    `".$lmdisp_blog."` = '".$blog."',
    `".$lmdisp_memyear."` = '".$memyear."',
    `".$lmdisp_fctlse."` = '".$fct."',
    `".$lmdisp_evlse."` = '".$evlse."',
    `".$lmdisp_skills."` = '".$skills."',
    `".$lmdisp_avatar."` = '".$avatar."',
    `".$lmdisp_cv."` = '".$cv."'
WHERE  `".$lmdisp_id."` = '".$id."'";

$rez = $wpdb->query($sql);

Hope it will work.

like image 176
Akshay Paghdar Avatar answered Feb 15 '23 19:02

Akshay Paghdar