Error to insert in firebird when using PHP

Question

I am trying to execute the following but he does not execute me well. Which will be able to be the problem?

$sql = "insert into scele (codigo, nombre) values (?, ?)";
$param = "1, Test1";

$tr = ibase_trans(IBASE_WRITE,$this->cn);
$qr = ibase_prepare($tr,$param);
$this->rs = ibase_execute($sql,$param);
if ($this->rs){
 //Evaluate this condition, but he does not enter here 
}

Comments

Do you commit your transaction?

---

Yes

The complete function is:

public function actualizar($sql,$param){
 if ($this->cn){

//for example:
$sql = "insert into scele (codigo, nombre) values (?, ?)";
$param = "1, Test1";

 $tr = ibase_trans(IBASE_WRITE,$this->cn);
 $qr = ibase_prepare($tr,$param);
 $this->rs = ibase_execute($sql,$param);
 if ($this->rs){

 //Evaluate this condition, but he does not enter here

 ibase_commit($tr);
 } else {
 ibase_rollback($tr);
 return array('tipo'=>false,'texto'=>'Error de ejecusin: '
.ibase_errmsg());
 }
 ibase_free_query($qr);
 return array('tipo'=>true,'texto'=>'');
 } else {
 return array('tipo'=>false,'texto'=>'Error de conexin: '
.ibase_errmsg());
 }
}

Answer 1

In the documentation it says that if the query raises an error, returns *FALSE*. You should start calling ibase_errmsg to track where the error is.

Comments

$sql = "insert into scele (codigo, nombre) values (?, ?)";
    $param = "1, Test1";
    
    $tr = ibase_trans(IBASE_WRITE,$this->cn);
    $qr = ibase_prepare($tr,$param);
    echo ibase_errmsg() ." ";

Dynamic SQL Error SQL error code = -104 Token unknown - line 1, column 1 2

But I do not understand as it can be the error.

---

Sorry I have no experience with firebird commands.

Just read through the official documentation. If I am to take a blind guess I would point to ibaseprepare($tr,$param); and would say that the variable $param does not belong there but rather in ibaseexecute. What I would try is something like this:

$sql = "insert into scele (codigo, nombre) values (?, ?)";
$param = "1, Test1";

$tr = ibasetrans(IBASEWRITE,$this->cn);
$qr = ibaseprepare($this->cn, $tr, $sql);
$this->rs = ibaseexecute($qr,$param);
.......

If this doesn't work remove the parameters and put static values and see if that works...etc... you have to really debug line by line.