WordPress.org

1. alalex
   Member
   Posted 5 years ago #
   

   I'm developing a plugin and I am completely unable to insert things to the db. I've tried I think everything and nothing!

   There is a main file with the activation function that creates a table in the db (And it works fine)

   Then in the plugin page there is a form that I use to add rows to the db. But it doesn't seem to work...
   Here is the Insert code:
   

   $insert = "INSERT INTO " . $table_name .
   " (name, selector, bg, color, font, apply) " .
   "VALUES ('$name','$selector'.'$bg','$color','$font','$apply')";
   
   $results = $wpdb->query($insert);

   The $table_name is perfectly fine. There is also the field id at the beginning, but it's set to auto_increment so there is no need to put it there.

   Thanks

2. MichaelH
   Member
   Posted 5 years ago #
   

   So the table name has the $table_prefix as part of the string?

3. MichaelH
   Member
   Posted 5 years ago #
   

   Also shouldn't that be a comma between $selector and $bg
   

   "VALUES ('$name','$selector'.'$bg','$color','$font','$apply')";

Topic Closed

This topic has been closed to new replies.