database

database copied to clipboard

Deprecation warning - PHP 8.1

8

Opis database generates this warning Deprecated: Opis\Database\Connection implements the Serializable interface, which is deprecated. Implement __serialize() and __unserialize() instead (or in addition, if support for old PHP versions is necessary)...

carlosjac

Please help. How to get such query "SELECT TRIM(CONCAT(u.firstname, SPACE(1), u.lastname)) AS client FROM ..." using opis database?

SMI-82

php 8.0 support

1

could you please enable php 8.0 support in composer `"php": "^7.0|^8.0",`

elvispdosreis

Ciao! I have refactoring some old scripts and migrating native PDO queries to Opis. At some point I found a query which looks like that (reduced version to explain): ```...

juninhodeluca

INSERT INTO tabela(numero) VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10) I need to insert record using OPISDATABASE in large amount of records.

marquesjuniorpalmas

deba12

Timestamp field with default value on creation

3

I'm trying to create a timestamp field that defaults to the current timestamp (a "created_at" field). I've tried ->defaultValue('CURRENT_TIMESTAMP') and ->defaultValue('NOW()') ... both return errors saying it's an invalid default...

mcasto

tadaszelvys

I added a simple modification which provide to checks the table existence in create and drop functions. Tested with manually but not with PHPUnit.

adampweb

enum type

2

Please add enum type in table schema. From what I have read enum type can be emulated in oracle,sqlite,mssql with check For mssql ```sql create table sizes ( size varchar(10)...

deba12