警告:mysqli_query()至少需要2个参数,给定1个 [英] Warning: mysqli_query() expects at least 2 parameters, 1 given
本文介绍了警告:mysqli_query()至少需要2个参数,给定1个的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在建立一个网站,并且继续收到此错误警告:mysqli_query()至少需要2个参数,其中1个是给定的.这非常令人沮丧,我似乎找不到解决方法.谁能重新编码我的代码或让我知道如何解决它?
I'm make a website and I keep on getting this error " Warning: mysqli_query() expects at least 2 parameters, 1 given in." It has been very frustrating and I can't seem to find a way to fix. Can anyone re-code my code or let me know how to fix it?
我的代码是:
<?php
$sitename = "xxxxx.com";
$link = mysqli_connect("xxxxx.com", "xxxxx.com", "xxxxx.com");
$db_selected = mysqli_select_db('xxxxx.com', $link);
mysqli_query("SET NAMES utf8");
function fetchinfo($rowname,$tablename,$finder,$findervalue) {
if($finder == "2") $result = mysqli_query("SELECT $rowname FROM $tablename");
else $result = mysqli_query("SELECT $rowname FROM $tablename WHERE `$finder`='$findervalue'");
$row = mysqli_fetch_assoc($result);
return $row[$rowname];
} ?>
推荐答案
您需要指定连接.
$result = mysqli_query($link, "SELECT $rowname FROM $tablename WHERE $finder`='$findervalue'");
此外,如果您的连接不是完全伪造的伪代码(重复* .com),那么您的连接是错误的.它应该与此类似:
Plus, your connect is wrong if it's not entirely faked pseudocode (repeated *.com's). It should be similar to this:
$link=mysqli_connect("site","user","pw","db");
使用正确的凭据填写.
这篇关于警告:mysqli_query()至少需要2个参数,给定1个的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文