我正在尝试向mysql数据库添加50列数据,列名为l1,l2,l3等。
if((strpos(strtolower($out), "error") === FALSE) && (strpos(strtolower($out), "not allocated") === FALSE)) {
$rows = explode("n", $out);
$x=1;
foreach($rows as $row) {
$row = trim($row);
$rec[$x] = $row;
$x = $x + 1;
}
}
$senqu = "INSERT INTO simple (name,l1, l2, l3,l4,l5,l6,l7,l8,l9,l10,l11, l12, l13,l14,l15,l16,l17,l18,l19,l20,l21, l22, l23,l24,l25,l26,l27,l28,l29,l30,l31, l32, l33,l34,l35,l36,l37,3l8,3l9,l40,l41, l42, l43,l44,l45,l46,l47,l48,l49,l50) VALUES (".$abc;
for ($i =1;$i<=49;$i++) {
$senqu = $senqu.",'".$rec[$i]."'";
}
$senqu = $senqu.") WHERE name = ".$domain;
$db->query($senqu);
代码给了我以下错误:
PHP 注意:未定义的变量:db 在/home/dataegud/public_html/zzuse.com/scrips/whois.php 在第 346 行 [06-四月-2017 15:57:37 等/格林威治标准时间]PHP 致命错误:在第 346 行的/home/dataegud/public_html/zzuse.com/scrips/whois.php 中的非对象上调用成员函数 query((
你可以帮我吗。我是php的新手,想获得一些知识。
变量
db 未定义,因此您会收到错误。以下链接导致错误
$db>查询
==========================================================以下是要插入的查询
<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "INSERT INTO MyGuests (firstname, lastname, email)
VALUES ('John', 'Doe', 'john@example.com')";
if ($conn->query($sql) === TRUE) {
echo "New record created successfully";
} else {
echo "Error: " . $sql . "<br>" . $conn->error;
}
$conn->close();
?>