wpdb - WordPress database error: [Query was empty] -


i'm using $wpdb connect different database wordpress 1 this:

$newdb = new wpdb(db_new_user, db_new_password, db_new_name, db_new_host);

i need insert multiple rows database. used code answer: wordpress $wpdb. insert multiple records.

to run query, use line: 

$newdb->query( $newdb->prepare("$query", $values));

when echo $query, result: (there more 3 columns, shortened if times sake)

insert table (column1, column2, column3) values ('%s', '%s', '%s')

when var_dump($values), returns array same amout of strings have columns.

when run query, following error:

wordpress database error: [query empty]

i tried selecting database in similar fashion , did work, connected db working.

what doing wrong?

if can me appreciate it.

are sure query this?

$metakey = "harriet's adages"; $metavalue = "wordpress' database interface sunday morning: easy.";  $wpdb->query( $wpdb->prepare(      "         insert $wpdb->postmeta         ( post_id, meta_key, meta_value )         values ( %d, %s, %s )     ",          array(         10,          $metakey,          $metavalue     )  ) );

Comments

Post a Comment

Popular posts from this blog

matlab - Deleting rows with specific rules -

i got 20*3 cell array , need delete rows contains "137", "2" , "n:t" origin data: 't' '' '' 'np(*)' '' '' [ 137] '' '' [ 2] '' '' 'are' 'and' 'np(fcc_a1#1)' '' '' '1:t' [ 1200] [0.7052] '' [1.2051e+03] [0.7076] '' 'are' 'and' 'np(fcc_a1#3)' '' '' '2:t' [ 1200] [0.0673] '' [1.2051e+03] [0.0671] '' 'are' 'and' 'np(m23c6)' '' '' '3:t' [ 1200] [0.227...
Read more

php - MySQLi multi_query results for later use -

i using mysqli multi_query work several select statemets @ time. know how handle results, able use them later in code. example: <?php //connection stuff $query = "select name, surname database1;"; $query.= "select car, year, type database2 carid='1';"; $query.= "select product, price database3;"; if ($mysqli->multi_query($query)) { if($result = $mysqli->store_result()) { while($row = $result->fetch_row()) { --> here? } } } ?> <html> <div id='persona'> <?php foreach() { --> print name + surname } ?> </div> <div id='cars'> <?php foreach() { --> print car + year + type } ?> </div> <div id='product'> <?php foreach() { --> print product + price } ?> </div> </html> one more thing, prepared statements not possible when using multiple_query, right? there no benefit in putting unrelated queries in 1 multi ...
Read more