Download the PHP package wilkques/database without Composer
On this page you can find all versions of the php package wilkques/database. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Informations about the package database
Database
Notice
MySQL
Only- Database operate
ENV
- php >= 5.4
- mysql >= 5.6
- PDO extension
How to use
-
Via PHP require
Download Database
Download EzLoader and See how to use -
Via Composer
composer require wilkques/database
- start
Methods
table or from
table
orfrom
orfromSub
table
samefrom
select
-
select
orselectSub
selectSub
join
-
join
-
joinWhere
-
joinSub
-
joinSubWhere
-
leftJoin
same
join
-
leftJoinSub
same
joinSub
-
leftJoinWhere
same
join
-
leftJoinSubWhere
same
joinSub
-
rightJoin
same
join
-
rightJoinSub
same
joinSub
-
rightJoinWhere
same
join
-
rightJoinSubWhere
same
joinSub
-
crossJoin
same
join
-
crossJoinSub
same
joinSub
-
crossJoinWhere
same
join
-
crossJoinSubWhere
same
joinSub
where
-
where
-
orWhere
same
where
-
whereNull
-
orWhereNull
same
whereNull
-
whereNotNull
same
whereNull
-
orWhereNotNull
same
whereNotNull
-
whereIn
-
orWhereIn
same
whereIn
-
whereNotIn
same
whereIn
-
orWhereNotIn
same
whereIn
-
whereBetween
-
orWhereBetween
same
whereBetween
-
whereNotBetween
same
whereBetween
-
orWhereNotBetween
same
whereBetween
-
whereExists
-
whereNotExists
same
whereExists
-
orWhereExists
same
whereExists
-
orWhereNotExists
same
whereExists
-
whereLike
orWhereLike
having
-
having
orHaving
limit or offset
-
limit
offset
group by
-
groupBy
-
groupByDesc
groupByAsc
order by
-
orderBy
-
orderByDesc
orderByAsc
union
-
union
unionAll
samunion
Get Data
-
get
-
first
find
Update
-
update
-
increment
decrement
Insert
-
insert
insertSub
Delete
-
delete
-
softDelete
reStore
recovery (delete
cannot recovery data)
Raw
raw
SQL Execute
-
query
set SQL string -
prepare
execute SQL string -
bindParams
execute SQL string execute
execute SQL string
SQL Execute result
-
fetchNumeric
get result key to numeric -
fetchAssociative
get result key value -
fetchFirstColumn
get result first column -
fetchAllNumeric
get all result key to numeric -
fetchAllAssociative
get all result key value -
fetchAllFirstColumn
get all result first column -
rowCount
get result -
free
PDO methodcloseCursor
PHP PDOStatement::closeCursor -
fetch
PDOStatement::fetch fetchAll
PDOStatement::fetchAll
Query Log
-
enableQueryLog
enable query logs -
getQueryLog
get all query string and bind data -
getParseQueryLog
orparseQueryLog
get paser query logs getLastParseQuery
orlastParseQuery
get paser query
Lock
-
lockForUpdate
sharedLock
Page
-
currentPage
-
prePage
getForPage
Transaction
-
beginTransaction
-
commit
rollback
Connect
-
host
-
username
-
password
-
database
-
newConnection
-
reConnection
selectDatabase