好的。基本上是这样。这是我的密码。
login.php
require_once("./libs/db_cxn.php");
$cxn = new newConnection();
$stmt = "SELECT users.username FROM users WHERE username=$username AND password=MD5($password)";
$qry = 'mysqli_prepare($cxn, $stmt);
$res = mysqli_execute($qry);
db_cxn.php
class newConnection{
function __construct(){
$conf = array(
"host" => "localhost",
"username" => "root",
"password" => "root",
"dbname" => "db_BookWorm",
"port" => ini_get("mysqli.default_port"),
"socket" => ini_get("mysqli.default_socket"),
"prefix" => "bWorm_"
);
$cxn = new mysqli($conf["host"], $conf["username"], $conf["password"], $conf["dbname"]);
if ($cxn->connect_errno){
'printf("Connection failed: %s'n", $cxn->connect_error);
exit();
}
}
function _destruct(){
mysqli_close($this);
}
}
我在上有错误报告,每当我尝试运行该代码时,都会给出以下错误消息
Warning: mysqli_prepare() expects parameter 1 to be mysqli, object given in ''MORIARTY'HOME'15'5CBA2901'Desktop'comp_proj'project'www'login.php on line 34
有关于如何解决这个问题的线索吗?我之所以创建这个连接类,是因为我会频繁地打开连接,并认为这会节省我的时间和悲伤。任何帮助都将不胜感激!
这样更改代码:
<?php
/**
---------------------
for db_cxn.php file
---------------------
* */
class newConnection {
static $cxn;
function __construct() {
$conf = array(
"host" => "localhost",
"username" => "root",
"password" => "",
"dbname" => "test",
"port" => ini_get("mysqli.default_port"),
"socket" => ini_get("mysqli.default_socket"),
"prefix" => ""
);
self::$cxn = mysqli_connect($conf["host"], $conf["username"], $conf["password"], $conf["dbname"]);
if (self::$cxn->connect_errno) {
'printf("Connection failed: %s'n", self::$cxn->connect_error);
exit();
}
}
function getConnection() {
return self::$cxn;
}
function _destruct() {
mysqli_close($this);
}
}
<?php
/* * *
----------------
for login.php
----------------
*/
require_once("./libs/db_cxn.php");
$obj = new newConnection();
$cxn = $obj->getConnection();
$id = 1;
$stmt = "SELECT users.username FROM users WHERE username=$username AND password=MD5($password)";
$qry = mysqli_prepare($cxn, $stmt);
$res = mysqli_execute($qry);