faulkj/

db

PHP 中 SQLSRV (MS SQL) 的包装类。

v1.8 2024-03-03 02:37 UTC

This package is auto-updated.

Last update: 2024-09-03 04:22:54 UTC


README

PHP 中 SQLSRV (MS SQL) 的包装类

use FaulkJ\DB;

$db = new DB("myhost", "mydb", "username", "password");

$respose = $db->query("SELECT * FROM mytable");
if(!$respose->success) echo(implode("\n", $respose->error));
else echo(json_encode($respose->result));


$params = [
   "apples",
   "oranges",
   12.34,
   5,
   true,
   null,
   321
];

if($dp->pQuery("
   UPDATE mytable
      SET favorite = ?
      , leastFavorite = ?
      , cost = ?,
      , count = ?
      , active = ?
      , nullable = ?
      WHERE id = ?
", $params)->success) {
   echo "Table updated";
 }