数据库连接类<?php return array(
'APP_DEBUG' => true , // 开启调试模式
'DB_TYPE'=> 'mysql', // 数据库类型
'DB_HOST'=> 'localhost', // 数据库服务器地址
'DB_NAME'=>'datasystem', // 数据库名称
'DB_USER'=>'root', // 数据库用户名
'DB_PWD'=>'', // 数据库密码
'DB_PORT'=>'3306', // 数据库端口
'DB_PREFIX'=>'ty_', // 数据表前缀
);?> Action 方法<?php
//更新
function update(){
$user= D('userinfo');
echo $user;
if($vo=$user->create()){
$id=$_POST['id'];
$name=$_POST['name'];
$pass=$_POST['pass'];
$date=$_POST['date'];
$sql = "UPDATE `ty_userinfo` SET `username` = $name',`password` =`$pass`,`date` = `$date` WHERE `id` = $id";
$list = C($sql);
// $list = mysql_query($sql);
if($list!==false){
echo "数据更新成功！";
}else{
echo "没有更新任何数据";
}
}else{
$this->error($user->getError());
}
$this->display();
}
?>
页面<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>更新信息</title>
</head>
<body>
<form method="post" action="__URL__/update">
<table width="600" border="0">
<tr>
<td>编号</td>
<td><input type="text" id="id" name="id" value="{$data.id}"></td>
</tr>
<tr>
<td>用户名</td>
<td><input type="text" id="name" name="name" value="{$data.username}"></td>
</tr>
<tr>
<td>密码</td>
<td><input type="text" id="pass" name="pass" value="{$data.password}"></td>
</tr>
<tr>
<td>加入时间</td>
<td><input type="text" id="date" name="date" value="{$data.date}"></td>
</tr>
<tr>
<td colspan="2" align="center"><input type="submit" value="保存"></td>
</tr>
</table>
</form>
</body>
</html>数据库
id username password date
UPDATE `ty_userinfo` SET `username` = `$name',`password` =`$pass`,`date` = `$date` WHERE `id` = $id有条件的SQL语句:
UPDATE `ty_userinfo` SET `username` = `555',`password` =`111111`,`date` = `2010-12-15` WHERE `id` = 4数据库中date就是date类型
如下:$sql = "UPDATE `ty_userinfo` SET `username` = '{$name}',`password` = '{$pass}',`date` = '{$date}' WHERE `id` = $id";
把SQL语句中的字段名称的引号去掉就可以了
如果
$sql = "UPDATE `ty_userinfo` SET `username` = $name',`password` =`$pass`,`date` = `$date` WHERE `id` = $id";
//$list = C($sql);
$list = mysql_query($sql); 我在这加了一个输出结果的语句
var_dump($list);
页面加过为bool(false)
否则
就是
$sql = "UPDATE `ty_userinfo` SET `username` = $name',`password` =`$pass`,`date` = `$date` WHERE `id` = $id";
$list = C($sql);
//$list = mysql_query($sql); 我在这加了一个输出结果的语句
var_dump($list);
页面加过为NULL
这样写在Mysql数据库中都不能执行
报这个错 #1054 - Unknown column '456' in 'field list'
UPDATE `ty_userinfo` SET `username` = '$name',`password` ='$pass`',`date` = '$date' WHERE `id` = $id
{
$user = D('userinfo');
$vo = $user->create();
$sql = " select count(*) from `ty_userinfo` ";
$data = mysql_query($sql);
$row = mysql_fetch_assoc($data);
echo "$row";
$this->assign('number',$row);
$this->display();
}
HTML页面上要怎么输出啊 我写了一个
一共:{$number}条数据;
不过结果是
一共:条数据;
<?php
/*
* Created on 2010-12-14
*
* To change the template for this generated file go to
* Window - Preferences - PHPeclipse - PHP - Code Templates
*/
include './include/common.php';
include("Fckeditor/fckeditor.php");
$sBasePath = $_SERVER['PHP_SELF'] ; //获取文件的具体目录
//echo '<br>';
$sBasePath =dirname($sBasePath).'/'.Fckeditor.'/'; //获取当前目录名称
$ed = new FCKeditor('content');
$ed->BasePath = $sBasePath; //改变路径
//$ed->Create(); //创建窗口
$ed->ToolbarSet=Basic;
//$id = 1;
$id = $_GET['id'];
$sql = "select * from gd_content where id={$id}";
//echo $sql;
$result = $conn->query($sql);
//var_dump($result);
?>
<table width="800" border="1" align="center">
<?php
if($result&&$conn->affected_rows){
while($row=$result->fetch_object()){
?>
<tr>
<h4>标题:<?php echo $row->title; ?>
<td>
发表于:时间 <dfn>楼主</dfn>
<hr>
<?php echo $row->content; ?>
</td>
</tr>
<?php
}//while($row=$result->fetch_object())
}//if($result&&$conn->affected_rows) </table>
?>
<?php
$i=1;
$id = $_GET['id'];
$sql = "select id,message from gd_message where mid={$id}";
$result = $conn->query($sql);
//echo $sql;
//var_dump($result); <table width="800" border="1" align="center">
?><?php
if($result&&$conn->affected_rows){
while($row=$result->fetch_object()){
?>
<tr>
<td>
<hr>
回复于:时间 <dfn> <?php echo $i; $i++ ?>楼</dfn>
<hr>
<?php echo $row->message;?>
</td>
</tr>
<?php
}
}
?>
</table>
<?php
if($_POST['sub']){
$id = $_GET['id'];
$sql = "insert into gd_message(mid,message) values ('".$id."','".$_POST['content']."')"; //上边显示 mid的内容 续写
$result = $conn->query($sql);
//var_dump($result);
if($result&&$conn->affected_rows){
?>
<script type="text/javascript">
alert('评论成功');
</script>
<?php
//echo '评论成功';
}
}
?><form action="" method="post">
<?php
$ed->Create(); //创建、、、、、
?>
<input type="submit" name="sub" value="发表评论"/>
</form>参考一下吧！！！