Apr 2020
3 / 3
Apr 2020
Apr 2020
vishakha
Apr '20

I have created a custom table with one column “store_name” and the other being auto-increment primary key.
I’m trying to test the insertion by passing data like this, but it doesn’t seem to save data in the column store_name.
I don’t want to use the query method, am I doing something wrong.

$this->db = $GLOBALS[‘egw’]->db;
$this->db->insert(self::$table,array(
‘store_name’ => ‘test’),false,LINE,FILE);

Version
versions’ =>
array (size=5)
‘current_header’ => string ‘1.29’ (length=4)
‘maintenance_release’ => string ‘17.1.20180720’ (length=13)
‘api’ => string ‘17.1.003’ (length=8)
‘phpgwapi’ => string ‘17.1.003’ (length=8)
‘header’ => string ‘1.29’ (length=4

Maria db is ued
lighttpd server is used
PHP version is 7.2
installation type : archive instalation

  • created

    Apr '20

  • last reply

    Apr '20
  • 2

    replies

  • 1.0k

    views

  • 2

    users

RalfBeckerEGroupware GmbH
Apr '20

I wrote in the other thread of you (why did you open a new one about the same topic?), that you need the $app parameter to set the app, which has registered the schema.

If you post code, please enclose it in 3 single back-ticks: ```

$this->db = $GLOBALS[‘egw’]->db;
$app = 'my-app-name';
$this->db->insert(self::$table, array(
   ‘store_name’ => ‘test’
), false, __LINE__, __FILE__, $app);

The above will of cause only work, IF the app registered the schema, as described in example app.

I recommend you start with the example app, and step by step modify it to your needs / requirements.

Ralf