tyrola/sdc

此包已被废弃且不再维护。未建议替代包。

一个非常简单的mysqli数据库库

维护者

详细信息

github.com/BirknerAlex/SimpleDatabaseConnector

主页

源码

问题

安装: 34

依赖: 0

建议者: 0

安全性: 0

星标: 0

关注者: 1

分支: 0

开放问题: 0

dev-master / 1.0.x-dev 2017-12-26 12:15 UTC

Requires

  • php: >=5.3.0

GPL-2.0+ ed9ce1942e269c3c037ed419a434182569994829

  • BirknerAlex <alex.birkner.woop@gmail.com>

Simplemysqlisdc

This package is not auto-updated.

Last update: 2020-08-21 18:07:54 UTC

README

简单的PHP数据库连接器

  • 与mysqli兼容
  • 非常简单 ;)

query() 示例

<?php

$db = new mysqli("localhost", "dbUser", "dbPassword", "dbName");
$sdc = new DatabaseConnector($db);

$name = "Franz";

$sql = "UPDATE
            `table`
        SET
            `col` = '1'
        WHERE
            `name` = ".$sdc->quote($name").";";

$sdc->query($sql);

getAll() 示例

<?php

$db = new mysqli("localhost", "dbUser", "dbPassword", "dbName");
$sdc = new DatabaseConnector($db);

$sql = "SELECT
            `name`
        FROM
            `table`
        LIMIT
            `10`";

$entries = $sdc->getAll($sql);

foreach ($entries as $entry) {
    echo $entry["name"];
}

getFirst() 示例

<?php

$db = new mysqli("localhost", "dbUser", "dbPassword", "dbName");
$sdc = new DatabaseConnector($db);

$sql = "SELECT
            `name`
        FROM
            `table`
        LIMIT
            `10`";

$entry = $sdc->getFirst($sql);

echo $entry["name"];

getOne() 示例

<?php

$db = new mysqli("localhost", "dbUser", "dbPassword", "dbName");
$sdc = new DatabaseConnector($db);

$sql = "SELECT
            `name`
        FROM
            `table`
        WHERE
            `id` = '1'";

$name = $sdc->getOne($sql);

echo $name;