插入到数据MySQL数据库使用PHP函数
问题描述:
function inseartinto()
{
$DEL_LOG_REP = $connection->prepare("DELETE FROM test WHERE itemname='111'")$DEL_LOG_REP->execute()$DEL_LOG_REP->close()return $DEL_LOG_REP
}
答
This is short tutorails on connection in insert query into php...
<?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', '[email protected]')";
if ($conn->query($sql) === TRUE) {
echo "New record created successfully";
} else {
echo "Error: " . $sql . "<br>" . $conn->error;
}
$conn->close();
?>
更多更好understand..go到http://www.w3schools.com/php/default.asp
+0
我已经完成了连接部分,我需要知道如何在类和函数中写入查询.... – Ashan
答
你想编写人什么代码.. 这不是真的不是一个有效的代码插入,但也为连接.. 亚去@Sasa.D提到W3School.com ...它为您提供从基本知识到专业知识..
你有问题。这不是一个有效的PHP,并且$ connection不在函数范围内。 –