Question

php在类中怎么调用数据库函数出问题，错误类型mysqli_fetch_assoc() expects exactly 1 parameter, 2 giv

我的源码如下：
class Article{
public $m_board_id;
public $m_board_name;
public $m_id;
public $m_parent_id;
public $m_has_child;
public $m_title;
public $m_username;
public $m_post_time;
public $m_ip;
public $m_content;
public $m_picture;
public $m_enabled;
public $row=array();
public $row1=array();
这些类的变量我已经赋值了下面的：
$conn=new Mysqli("localhost","root","root","tb");
sql1="select * from t_article_content where f_id='$this->m_id'";
$result1=$conn->query($sql1);
$row1 = mysqli_fetch_assoc($result1,$conn);
$this->m_content =$row1['f_content'];
$this->m_picture =$row1['f_picture'];
到了mysqli_fetch_assoc这里就报错，不知道为什么在类中连MYSQL_query也会报错，非要$conn->query($sql)吗？那如果MYSQL_fetch_array($sql,$conn)像这样括号里面有两个系数怎么办，我的php版本是我，希望高手指教

Answer 1

$result1->fetch_assoc();
$mysqli = new mysqli("localhost", "my_user", "my_password", "world");

$query = "SELECT Name, CountryCode FROM City ORDER by ID DESC LIMIT 50,5";
if ($result = $mysqli->query($query)) {
/* fetch associative array */
while ($row = $result->fetch_assoc()) {
printf ("%s (%s)\n", $row["Name"], $row["CountryCode"]);
}
/* free result set */
$result->close();
}

---------------------------------------------------
原形 array mysqli_fetch_assoc ( mysqli_result result ) ;

<?php
$link = mysqli_connect("localhost", "my_user", "my_password", "world");
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
$query = "SELECT Name, CountryCode FROM City ORDER by ID DESC LIMIT 50,5";
if ($result = mysqli_query($link, $query)) {
/* fetch associative array */
while ($row = mysqli_fetch_assoc($result)) {
printf ("%s (%s)\n", $row["Name"], $row["CountryCode"]);
}
/* free result set */
mysqli_free_result($result);
}
/* close connection */
mysqli_close($link);
?>

你别混用阿，而且原形就一个参数，你给了俩

追问

嗯，果然是高手，我想问下在类中如何使用Mysqli_insert_id()的，是$conn->insert_id()吗？
我的$conn=new MySQLi("localhost","root","root","表明"),抱歉因为我的财富值只有这么多，只好在一个问题里面问你了，你上面的答案是正确的!

追答

应该是 $result1->insert_id(),