如何从PHP设计器8连接到MySQL数据库 [英] How to connecting to MySQL database from PHP designer 8
问题描述
我是PHP的新手。我正在尝试创建一个页面,将数据输入到
mysql数据库中。我创建了一个名为'form1'的数据库和一个名为'demo'的表格
,其中包含2列ID(自动增加)和input1(varchar)。
i创建了一个名为html的文件带有此代码的演示表格
!DOCTYPE HTML>
< html>
< head>
< meta http-equiv =content-typecontent =text / html/>
< meta name =authorcontent =gencyolcu />
< title> Untitled 2< / title>
< / head>
< body>
< form action =demo.phpmethod =post/>
< p>输入1:< input type =textname =input1/> < / p>
< input type =submitvalue =提交/>
< / form>
< / body>
< / html>
和一个名为'demo'的PHP文件带代码
php
/ **
* @author gencyolcu
* @copyright 2015
* /
define('DB_NAME','form1');
define('DB_USER','root');
define('DB_PASSWORD','');
define('DB_HOST', 'localhost');
$ link = mysql_connect(DB_HOST,DB_USER,DB_PASSWORD);
if (!$ link){
die('无法连接:'。mysql_error());
}
$ db_selected = mysql_select_db(DB_NAME,$ link);
if(!$ db_selected){
die('不能使用'.DB_NAME。':'。mysql_error());
}
echo'已成功连接';
$ value = $ _POST ['input1'];
$ sql =INSERT INTO demo(input1)VALUES('$ value');
if(!mysql_query($ sql)){
die('错误:'。 mysql_error());
}
mysql_close();
但在我的浏览器中运行演示表后,我在
文本框中输入文本,然后单击提交。
请不要采取任何操作。真的没有问题是什么。请帮帮我
i am new to PHP. i am trying to create a page that will input data into
mysql database. i created a database called 'form1' and a table called 'demo'
with 2 columns ID(auto Increase) and input1(varchar).
i created a html file called demo-form with this codes
!DOCTYPE HTML>
<html>
<head>
<meta http-equiv="content-type" content="text/html" />
<meta name="author" content="gencyolcu" />
<title>Untitled 2</title>
</head>
<body>
<form action="demo.php" method="post" />
<p>Input 1: <input type="text" name="input1" /> </p>
<input type="submit" value="Submit" />
</form>
</body>
</html>
and a PHP file called 'demo' with code
php
/**
* @author gencyolcu
* @copyright 2015
*/
define('DB_NAME', 'form1');
define('DB_USER','root');
define('DB_PASSWORD','');
define('DB_HOST', 'localhost');
$link = mysql_connect(DB_HOST,DB_USER,DB_PASSWORD);
if (!$link) {
die('Could not connect: ' . mysql_error());
}
$db_selected = mysql_select_db(DB_NAME, $link);
if (!$db_selected) {
die('Can\'t use' . DB_NAME . ':' . mysql_error());
}
echo 'Connected successfully';
$value = $_POST['input1'];
$sql = "INSERT INTO demo (input1) VALUES ('$value')";
if (!mysql_query($sql)) {
die('Error: '. mysql_error());
}
mysql_close();
but after running the demo-form in my browser and i enter text into the
textbox and click submit.
no action takes please. dont really no what the problem is. please help me out
推荐答案
link = mysql_connect(DB_HOST,DB_USER,DB_PASSWORD);
if( !
link = mysql_connect(DB_HOST,DB_USER,DB_PASSWORD);
if (!
链接){
die('无法连接:'。mysql_error());
}
link) {
die('Could not connect: ' . mysql_error());
}
db_selected = mysql_select_db(DB_NAME,
db_selected = mysql_select_db(DB_NAME,
这篇关于如何从PHP设计器8连接到MySQL数据库的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!