Download the PHP package victorwesterlund/innodb-fk without Composer

On this page you can find all versions of the php package victorwesterlund/innodb-fk. 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 victorwesterlund/innodb-fk

Informations about the package innodb-fk

php-libinnodb-fk

This library retrievies and optionally resolves foreign keys in a MySQL/MariaDB database using the InnoDB storage engine.

This library will only work with databases created with InnoDB

Install with composer

Example / Documentation

Start by initializing ForeignKeys with mysqli connection details. ForeignKeys will pass the arguments along to mysqli::__construct().

Remember to pass the database name where InnoDB foreign keys are stored to the 4th argument. The user must also have SELECT permissions on this database as the (4th) $database argument. It's usually information_schema. You can also pass the ForeignKeys::DATABASE_NAME constant if you're unsure.

Example database relationship:

image

Initialize ForeignKeys

Get column constraints for a table

Pass a database and table to for() and then chain get_constraints() to receive an associative array of all column relationships for that table.

Resolve foreign key references for entities

You can also resolve foreign key references for a passed array of arrays.

Retrieve rows from your database and pass them to resolve_all() as an array of associatve arrays to resolve them automatically.

All versions of innodb-fk with dependencies

PHP Build Version
Package Version
Requires victorwesterlund/libmysqldriver Version ^3.0
victorwesterlund/xenum Version ^1.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 victorwesterlund/innodb-fk contains the following files

Loading the files please wait ....