PHP download

Download the PHP package jonathanbak/mysqlilib without Composer

On this page you can find all versions of the php package jonathanbak/mysqlilib. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.

Table of contents
Download jonathanbak/mysqlilib
More information about jonathanbak/mysqlilib
Files in jonathanbak/mysqlilib

Vendor jonathanbak
Package mysqlilib
Short Description Simple MySQLi Library
License MIT
Homepage http://github.com/jonathanbak/MySQLiLib

Keywords mysqli mysqli library simple db library simple dao

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 jonathanbak/mysqlilib

Informations about the package mysqlilib

MySQLiLib

💡 가볍고 실무 친화적인 PHP MySQL 라이브러리
PHP 5.6부터 PHP 8.3까지 폭넓게 호환되며, 단순하고 직관적인 인터페이스로 빠르게 데이터베이스 연동을 구현할 수 있습니다.

✨ Features

mysqli 기반 경량 ORM 스타일 구현
:param, ? 스타일의 유연한 바인딩 지원
Prepared Statement 자동 처리
Iterator 기반 fetch() 지원
예외 처리 기반의 안정성 확보
FakeDb 를 통한 단위 테스트 가능

🛠️ Installation

📦 Usage

Connect & Fetch

🔍 SELECT with Parameters: `fetch()` vs `fetchOne()`

두 함수 모두 단일 row를 반환하지만, 동작 방식에는 차이가 있습니다.

함수	반환 동작	반복 호출 시 동작	적합한 상황
`fetch()`	한 줄 반환	다음 줄 순차 반환	여러 줄 중에서 반복 처리 시
`fetchOne()`	한 줄 반환	매번 동일한 결과	단 한 줄만 가져올 때

✅ `fetch()` - 반복 호출로 다음 row 순차 접근

내부적으로 mysqli_result를 반복해서 읽어오며 이터레이터처럼 작동합니다.
같은 쿼리/파라미터라도 매 호출마다 다음 행을 반환하며, 더 이상 없으면 null을 반환합니다.

✅ `fetchOne()` - 항상 단 한 줄만 반환

내부적으로 query()를 실행하고 결과를 fetch_assoc()으로 즉시 가져온 뒤 반환합니다.
매 호출마다 동일한 결과를 반환하므로, 조건이 정확히 하나의 row를 반환하는 경우 적합합니다.

Fetch Multiple Rows (Iterator)

LIKE Query

LIKE 검색 예제 (`?` 한 개만 사용)

문자열 전체를 바인딩할 경우 '테스트%'처럼 와일드카드를 포함시켜 전달합니다.

🏷️ Named Parameter (:param) 예제

:param 스타일은 내부적으로 ?로 치환되며, 배열의 키를 기준으로 자동 정렬하여 바인딩됩니다.

INSERT / UPDATE / DELETE

Exception Handling

Using `bind_param()`

📧 Contact

사용 중 문의사항이나 버그 제보는 언제든지 아래 이메일로 연락주세요:

📨 [email protected]

🧾 License

MIT License.

All versions of mysqlilib with dependencies

PHP Build Version

Package Version

Version 1.4.2 Release 26. Jun 2025
create-project require 0 people chose require and
0 people chose create-project.

Download

Download latest version of mysqlilib from vendor jonathanbak

Requires php Version >=5.6.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 jonathanbak/mysqlilib contains the following files

Loading the files please wait ....

Download the PHP package jonathanbak/mysqlilib without Composer

FAQ

How can I use the PHP package after the download?

Do I need to create a project on this site?

When is it necessary to insert some auth.json content?

What is the advantage to use this site for my Composer projects?