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.

FAQ

After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.

Example:
If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.

In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
Some PHP packages are not free to download and because of that hosted in private repositories. In this case some credentials are needed to access such packages. Please use the auth.json textarea to insert credentials, if a package is coming from a private repository. You can look here for more information.

  • Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
  • To use Composer is sometimes complicated. Especially for beginners.
  • Composer needs much resources. Sometimes they are not available on a simple webspace.
  • If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
  • Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Please rate this library. Is it a good library?

Example code of wilkques/database

Informations about the package database

Database

Latest Stable Version License

Notice

  1. MySQL Only
  2. Database operate

ENV

  1. php >= 5.4
  2. mysql >= 5.6
  3. PDO extension

How to use

  1. Via PHP require
    Download Database
    Download EzLoader and See how to use

  2. Via Composer composer require wilkques/database

  3. start

Methods

table or from

  1. table or from or fromSub table same from

select

  1. select or selectSub

  2. selectSub

join

  1. join

  2. joinWhere

  3. joinSub

  4. joinSubWhere

  5. leftJoin

    same join

  6. leftJoinSub

    same joinSub

  7. leftJoinWhere

    same join

  8. leftJoinSubWhere

    same joinSub

  9. rightJoin

    same join

  10. rightJoinSub

    same joinSub

  11. rightJoinWhere

    same join

  12. rightJoinSubWhere

    same joinSub

  13. crossJoin

    same join

  14. crossJoinSub

    same joinSub

  15. crossJoinWhere

    same join

  16. crossJoinSubWhere

    same joinSub

where

  1. where

  2. orWhere

    same where

  3. whereNull

  4. orWhereNull

    same whereNull

  5. whereNotNull

    same whereNull

  6. orWhereNotNull

    same whereNotNull

  7. whereIn

  8. orWhereIn

    same whereIn

  9. whereNotIn

    same whereIn

  10. orWhereNotIn

    same whereIn

  11. whereBetween

  12. orWhereBetween

    same whereBetween

  13. whereNotBetween

    same whereBetween

  14. orWhereNotBetween

    same whereBetween

  15. whereExists

  16. whereNotExists

    same whereExists

  17. orWhereExists

    same whereExists

  18. orWhereNotExists

    same whereExists

  19. whereLike

  20. orWhereLike

having

  1. having

  2. orHaving

limit or offset

  1. limit

  2. offset

group by

  1. groupBy

  2. groupByDesc

  3. groupByAsc

order by

  1. orderBy

  2. orderByDesc

  3. orderByAsc

union

  1. union

  2. unionAll sam union

Get Data

  1. get

  2. first

  3. find

Update

  1. update

  2. increment

  3. decrement

Insert

  1. insert

  2. insertSub

Delete

  1. delete

  2. softDelete

  3. reStore recovery (delete cannot recovery data)

Raw

  1. raw

SQL Execute

  1. query set SQL string

  2. prepare execute SQL string

  3. bindParams execute SQL string

  4. execute execute SQL string

SQL Execute result

  1. fetchNumeric get result key to numeric

  2. fetchAssociative get result key value

  3. fetchFirstColumn get result first column

  4. fetchAllNumeric get all result key to numeric

  5. fetchAllAssociative get all result key value

  6. fetchAllFirstColumn get all result first column

  7. rowCount get result

  8. free PDO method closeCursor PHP PDOStatement::closeCursor

  9. fetch PDOStatement::fetch

  10. fetchAll PDOStatement::fetchAll

Query Log

  1. enableQueryLog enable query logs

  2. getQueryLog get all query string and bind data

  3. getParseQueryLog or parseQueryLog get paser query logs

  4. getLastParseQuery or lastParseQuery get paser query

Lock

  1. lockForUpdate

  2. sharedLock

Page

  1. currentPage

  2. prePage

  3. getForPage

Transaction

  1. beginTransaction

  2. commit

  3. rollback

Connect

  1. host

  2. username

  3. password

  4. database

  5. newConnection

  6. reConnection

  7. selectDatabase

All versions of database with dependencies

PHP Build Version
Package Version
Requires php Version >=5.4
wilkques/php-helper Version ^5.13.0
Composer command for our command line client (download client) This client runs in each environment. You don't need a specific PHP version etc. The first 20 API calls are free. Standard composer command

The package wilkques/database contains the following files

Loading the files please wait ...