Hello I have been developing in PHP and now am just starting the transition to Wordpress. In PHP I have this ->
// Prepare statement $sqlstatement = $conn->prepare("INSERT INTO importtest (id, area, country, city, town, postcode, lotarea, price, bedrooms, bathrooms, summary, latitude, longlitude, street, streetno, type, image) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"); // Bind the parameters I want (datatype, parameters) $sqlstatement->bind_param('sssssssssssssssss', $ID, $area, $country, $city, $town, $postcode, $lotarea, $price, $bedrooms, $bathrooms, $summary, $latitude, $longlitude, $street, $streetno, $name, $image); // Execute $sqlstatement->execute();
I notice that the insert for wpdb takes arrays as in the column name, the data and the data type. My question is does Wordpress have an equivalent for binding parameters as I'm sure can't just insert variables?