Download the PHP package youloge/sqlite without Composer

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

Informations about the package sqlite

Youloge.Sqlite重构版本 Webman 基础插件

项目介绍

Sqlite3 插件：它是对标fopen 函数的，性能还是不错了，像一般性的个人博客，企业官网，完全都是可以hold住的。 其中Sqlite 的内存型反应时间是ns级别的，其他数据库都会有网络开销可以做到ms级别。代码很少就100多行

这二天帮代码升级了下，直接继承SQLite3类进行扩展官方类php.net/sqlite3，我在官方基础上扩展了几个功能，从而实现自动表映射。同时将表配置文件放入到数据库同目录下，迁移时候直接复制即可。

项目地址

Github Youloge.sqlite Star我 我们一起做大做强

安装

插件已经 引入了以下助手函数 不需要在引入了可以直接使用sqlite()

配置文件

配置数据表

youloge.sqlite.json 文件数据表配置，要仔细：数据库表一旦建立了，修改更改表会十分的麻烦+蛋疼

  • $db = sqlite('/','db001'); 会在绝对路径目录下新建一个db001.db文件，自动创建二张表init和test
  • $db = sqlite('www.site/ok','db002'); 会在绝对路径/www.site/ok目录下新建一个db002.db文件，自动创建一张表no

开始使用

连接数据库

插入数据 $table, $data

插入一条数据

插入多条数据

更新数据 $table, $data, $where

一般更新

特殊更新

删除数据 $table,$where

单条查询 $table, $columns, $where 可选$order=false

多条查询 $table, $columns, $where,$limit=10,$offset=0,$order=false

统计查询 $table, $columns, $where,$limit=10,$offset=0,$order=false

1.0.2 旧版是链式调用的：因为webman是常驻内存，类只加载一次，我写不好连接池所以2.0.0之后废弃链式调用

扩展函数 -> 箭头调用官方是:: 静态调用

原生连接句柄

关于交流打赏：VX：micateam

All versions of sqlite with dependencies

PHP Build Version
Package Version
No informations.
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 youloge/sqlite contains the following files

Loading the files please wait ....