概述:我有一个函数,应该根据它的id号拉行数据库
问题:似乎我的函数返回,但它没有返回任何东西。
细节:
-这里使用了两个不同的文件:db_class.php和character_pull.php
-我也有一个数据库,包含1表(字符),确实包含列"id"
-有用于调试的回显行。我将给出输出。
character_pull.php:
<?php
include "db_class.php";
echo "made it out here1";
$classobject = new db_class();
echo "made it out here2";
$results = $classobject->getPlayerStats("1");
print_r($results);
echo "made it out here3";
$id = "id: " . $results['id'];
$name = "name: " . $results['charname'];
$strength = "strength: " . $results['strength'];
$defense = "defense: " . $results['defense'];
$health = "health: " . $results['health'];
$level = "level: " . $results['level'];
$type = "type: " . $results['type'];
$experience = "experience: " . $results['experience'];
echo"<br/>";
echo "made it out here4";
?>
db_class.php:
<?php
include "database_connect.php";
class db_class{
public function getPlayerStats($id){
echo "<br/>" . "making it in class1";
$query = "SELECT * FROM characters WHERE id = $id";
$result = mysqli_query($query);
return $char = mysqli_fetch_array($result);
$result ->close();
}
}
?>
当我运行页面时,我收到的输出是这样的:
例如:在这里成功了
我已经尝试了几种方法来解决这个问题,但是我很难找出问题所在。
我知道这可能是非常草率和原始的,但尽量不要笑得太厉害,也许你可以帮助我:p。
你有很多问题。
看来你的DB类很不完整。对我来说,如果我正在创建一个类来表示DB连接和各种操作,我将在该类中创建该连接,而不是通过某些包含(我假设连接正在发生)。这里的问题是,只有当代码命中该行时,包含才会有条件地发生。在这种情况下,由于您在类中的任何实际函数(如构造函数)之外都包含了该include,因此它将永远不会被调用。
我建议这样做来解决这个问题:
class db_class {
protected $mysqli;
private $db_host = 'your_db_host';
private $db_user = 'your_db_user';
private $db_password = 'your_db_password';
protected $db_name = 'default_db_name';
public __construct($db_host = NULL, $db_user = NULL, $db_password = NULL, $db_name = NULL) {
if (!empty($db_host)) {
$this->db_host= $db_host;
}
// validate other parameters similarly
$mysqli = new mysqli($this->db_host, $this->db_use, $this->db_password, $this->db_name);
if($mysqli->connect_error) {
throw new Exception('Connect Error: ' . $mysqli->connect_errno . ', ' . $mysqli->connect_error);
} else {
$this->mysqli = $mysqli;
}
}
// other class methods
}
你现在有一个对象表示一个mysqli连接存储在$this->mysqli
。
您的getPlayerStats()
方法现在可能看起来像
public function getPlayerStats($id) {
if(empty($id)) {
throw new Exception ('An empty value was passed for id');
}
// verify this is integer-like value
$id = (string)$id;
$pattern = '/^'d+$/';
if (!preg_match($pattern, $id) !== 1) {
throw new Exception ('A non-integer value was passed for id');
}
$id = (int)$id;
$query = "SELECT id, name, strength, defense, level, health, type, experience FROM characters WHERE id = :id";
$stmt = $this->mysqli->prepare($query);
$stmt->bind_param('i', $id);
$result = $stmt->execute();
if (false === $result) {
throw new Exception('Query error: ' . $stmt->error);
} else {
$obj = new stdClass();
$stmt->bind_result($obj->id, $obj->name, $obj->strength, $obj->defense, $obj->level, $obj, health, $obj->type, $obj->experience);
$stmt->fetch();
$stmt->close();
return $obj;
}
}
注意我在这里使用了预处理语句,您应该习惯使用它,因为它确实是查询数据库的最佳实践。还请注意,我在整个代码中添加了错误情况的处理。您应该养成这样做的习惯,因为这将使调试更容易。
只是猜测,但我会将其移到类名之上:
<?php
include "database_connect.php";
class db_class{