SQL

Hi,
1.
I'm trying to insert data to a custom table into joomla database.
I've got this error :
Call to undefined method Joomla\Database\Mysqli\MysqliDriver::query()
With joomla5 PHP8.1

2.Fisrt yi trying insert data simple
INSERT INTO X_LYC_FORMTMP (TYPFORM,NOM,PRENOM,MAIL) VALUES ('fixe','User Name','Prenom','Reply-To Email');

Can you give me good syntax of values data form
VALUES (#fixe#,#User Name#,......'); ??
Thx
JC
 

Chris,
Solution :
You must change in /components/com_rapidcontactex/lib.php
Line 1008 :
this
    $db->query($query);
for that
    $db->execute($query);



Now i ve got my simple data in my database, but how i insert values form ?

Thx
JC

Dear Chris,
My problem it's when i m validating
this....M,MAIL) VALUES ('<fieldid>1</fieldid>','<fieldid>2</fieldid>','<fieldid>3</fieldid>','<fieldid>4</fieldid>');
the result is :
....M,MAIL) VALUES ('1', '2', '3', '4');

It's like there's a self-correction after validate


Joomla 5.0.2
PHP 8.1.18
mysql 8.0.27

Hi,

In the case Custom SQL in the configurations (Basic Options | Spam Protection | Sizing Options | Advanced Options | Custom SQL | updater Options.....)

I do Use Custom SQL -> YES

When i put :
INSERT INTO X_LYCEES_FORMTMP (TYPFORM,NOM,PRENOM,MAIL) VALUES (
'<fieldid>1</fieldid>','<fieldid>2</fieldid>','<fieldid>3</fieldid>','<fieldid>4</fieldid>');

I save it.

The box Custom SQL write this:
INSERT INTO X_LYCEES_FORMTMP (TYPFORM,NOM,PRENOM,MAIL) VALUES (
'1','2','3','4');

In my Field Manager
ID 1 : textbox
ID 2 : textbox
ID 3 : textbox
ID 4 : Email

Sorry for may very bad english