我开始学习php和mysql,首先从这个简单的模块开始,其中包括:
- 创建一个数据库连接;(跑步)
- 连接到数据库;(不提供输出消息,可能不起作用)
- 插入数据;(不行)
问题:
为什么它不能正常工作?
我创建了这个简单的PHP页面(文件名:inizio.php):
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta content="it" http-equiv="Content-Language" />
<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
<title>Pagina di inizio</title>
</head>
<body style="width: 672px; height: 289px">
<p class="auto-style1" style="width: 293px; height: 24px">Titolo centrato della pagina</p>
<form method="post" action="inserimento.php" style="width: 674px; height: 130px">
Inserisci il nome:<input name="nome" type="text" /><br />
Inserisci il cognome:<input name="cognome" type="text" /> <br />
<br />
<input name="Submit1" type="submit" value="Invia" /><br />
</form>
</body>
</html>
创建此php脚本(文件名inserimento.php)后:
<?php
$host='localhost';
$user='root';
$password='root';
$database='test_youtube';
// 1. Create a database connection
$connection = mysqli_connect($host,$user,$password);
if (!$connection)
{
die("Database connection failed: " . mysqli_error());
}
else
{
die("...Connesso con successo al Server!");
}
// 2. Select a database to use
$db_select = mysqli_select_db($connection, $database);
if (!$db_select)
{
die("Database selection failed: " . mysqli_error());
}
else
{
die("...Connesso con successo al Database!");
}
$query="insert into users(firstname, lastname)VALUES('".$_REQUEST['nome']."','".$request['cognome']."')";
if (!mysqli_query($query,$db_select))
{print("errore inserimento dati");
}
?>
尝试die()
在您的php文件中执行以下操作:
$connection = mysqli_connect($host,$user,$password,$database);
/* check connection */
if (mysqli_connect_errno()) {
die("Connect failed: ", mysqli_connect_error());
}
$query="insert into users(firstname, lastname)VALUES('".$_REQUEST['nome']."','".$_REQUEST['cognome']."')";
if ($result = mysqli_query($connection ,$query))
{
print("Success!");
}
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句