php 使用面向对象编程将值插入数据库
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/11027619/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Inserting values into database using object oriented programming
提问by Jathin
Possible Duplicate:
How to successfully rewrite old mysql-php code with deprecated mysql_* functions?
I have not been able to insert the values into the databse . However I do not get any error message as well .
我无法将值插入到数据库中。但是我也没有收到任何错误信息。
<html>
<body>
<form action="database.php" method="post">
Name : <input type ="text" name = "name"/>
Number :<input type ="text" name = "number"/>
<input type ="submit" value = "submit"/>
</form>
</body>
</html>
database.php
数据库.php
<?php
class Database
{
var $host;
var $user;
var $pass;
var $data;
var $con;
var $table;
var $db;
public function controls()
{
$this->host="localhost";
$this->user="cgiadmin";
$this->pass="cgi";
$this->data="j2";
}
public function connection()
{
$this->con="mysql_connect($this->host,$this->user,$this->pass)";
}
public function tablename()
{
$this->table="Insert into employee(name,number) values('$_POST[name]','$_POST[number]')";
}
public function databaseconnection()
{
$this->db="mysql_select_db($this->data,$this->con)";
}
}
$name=new Database;
$name->connection();
if(!($name->con))
{
echo "'Error: ' . mysql_error()";
}
$name->databaseconnection();
$name->tablename();
echo "thanks for taking the survey";
?>
采纳答案by Ruben Nagoga
You need some magic :) Read about quotesin php
你需要一些魔法 :) 阅读php 中的引号
<?php
class Database
{
var $host;
var $user;
var $pass;
var $data;
var $con;
var $table;
var $db;
public function controls()
{
$this->host="localhost";
$this->user="cgiadmin";
$this->pass="cgi";
$this->data="j2";
}
public function connection()
{
$this->con = mysql_connect($this->host,$this->user,$this->pass);
}
public function tablename()
{
$this->table=mysql_query("INSERT INTO employee(name,number) VALUES ('".$_POST[name]."','".$_POST[number]."')");
}
public function databaseconnection()
{
$this->db=mysql_select_db($this->data,$this->con);
}
}
$name=new Database();
$name->controls();
$name->connection();
if(!($name->con))
{
echo 'Error: ' . mysql_error();
}
$name->databaseconnection();
$name->tablename();
echo "thanks for taking the survey";
?>
回答by Vaishu
Try this...
尝试这个...
Modify tablename() function
修改 tablename() 函数
public function tablename($nam,$num)
{
$this->table=mysql_query("INSERT INTO employee(name,number) VALUES ('$nam','$num')");
}
Get values and call tablename() function
获取值并调用 tablename() 函数
$name=new Database;
$name->connection();
if(!($name->con))
{
echo "'Error: ' . mysql_error()";
}
$name->databaseconnection();
$nam=$_POST[name];
$num=$_POST[number];
$name->tablename($nam,$num);
echo "thanks for taking the survey";
