Forums

Hi, I've installed Chronoforms in Joomla....all is ok.
Now, I've transpose my project in Wordpress....but there is a problem:
In a Custom code I've this string:

<?php
$db = \JFactory::getDBO();
$query = "
SELECT `cognomeosp`
FROM `wpds_cf_test3`
WHERE `cf_id` = '{$form->data['dropdown']}' ;
";
$db->setQuery($query);
$form->data['cognomeosp'] = $db->loadResult();

How I can translate "$db = \JFactory::getDBO();" for Wordpress?
And...is there another error in this string for wordpress use?

Please, help me.

Matteo

Hi Matteo,

Here is an example wordpress query:

<?php 
global $wpdb;
$metakey = "vatnumber";
$dbquery = $wpdb->prepare("SELECT meta_value FROM ".$wpdb->prefix."usermeta WHERE user_id = %d AND meta_key = %s", $user_id, $metakey);
$vatnumber = $wpdb->get_var($dbquery);
?>

Best regards,
Max