php - Error inserting into custom table - Object of class wpdb could not be converted to string

Closed. This question is off-topic. It is not currently accepting answers.

---

Questions that are too localized (such as syntax errors, code with restricted access, hacked sites, hosting or support issues) are not in scope. See how do I ask a good question?

Closed 6 years ago.

Improve this question

Getting the above error when trying to insert into custom table .I am unable to find out what is the cause of the error.

The error comes at line 17. Any help is greatly appreicated.

The code is below:

<?php
session_start();
require_once "wp-load.php";
require_once "dbconfig.php";

global $wpdb, $current_user;
$current_user=wp_get_current_user();
$current_username = $current_user->user_login;
$table_name='persons';
$first_name=$_POST['first_name'];
$last_name= $_POST['last_name'];
$email=$_POST['email'];
$telephone=$_POST['telephone'];

$wpdb->query( $wpdb->prepare(
"
 INSERT INTO $wpdb->$table_name
( first_name, last_name, email,telephone,user_name)
VALUES ( %s, %s, %s,%s,%s )
",
$first_name,$last_name,$email,$telephone,$current_username
) );

Closed. This question is off-topic. It is not currently accepting answers.

---

Questions that are too localized (such as syntax errors, code with restricted access, hacked sites, hosting or support issues) are not in scope. See how do I ask a good question?

Closed 6 years ago.

Improve this question

Getting the above error when trying to insert into custom table .I am unable to find out what is the cause of the error.

The error comes at line 17. Any help is greatly appreicated.

The code is below:

<?php
session_start();
require_once "wp-load.php";
require_once "dbconfig.php";

global $wpdb, $current_user;
$current_user=wp_get_current_user();
$current_username = $current_user->user_login;
$table_name='persons';
$first_name=$_POST['first_name'];
$last_name= $_POST['last_name'];
$email=$_POST['email'];
$telephone=$_POST['telephone'];

$wpdb->query( $wpdb->prepare(
"
 INSERT INTO $wpdb->$table_name
( first_name, last_name, email,telephone,user_name)
VALUES ( %s, %s, %s,%s,%s )
",
$first_name,$last_name,$email,$telephone,$current_username
) );

• php
• mysql

Share Improve this question asked Mar 19, 2019 at 8:21 David D'LimaDavid D'Lima 333 bronze badges 2

• Seems like there's a typo here: $wpdb->$table_name in the query. – Sally CJ Commented Mar 19, 2019 at 8:39
• Thank you. Problem solved. – David D'Lima Commented Mar 19, 2019 at 10:10

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 0

$wpdb->$table_name is not a valid table name. Use $table_name

$wpdb->query( $wpdb->prepare(
"
 INSERT INTO $wpdb->$table_name
( first_name, last_name, email,telephone,user_name)
VALUES ( %s, %s, %s,%s,%s )
",
$first_name,$last_name,$email,$telephone,$current_username
) );

should be

$wpdb->query( $wpdb->prepare(
"
 INSERT INTO $table_name
( first_name, last_name, email,telephone,user_name)
VALUES ( %s, %s, %s,%s,%s )
",
$first_name,$last_name,$email,$telephone,$current_username
) );