...【潇洒屠夫吧】

潇洒屠夫吧关注：7贴子：137

6回复贴，共1页

...

<?php
$host = 'localhost:3306';
$user = 'root';
$pwd = 'xiaosatufu';
$conn = mysql_connect($host,$user,$pwd);
mysql_query('set names gbk');
// var_dump($conn);
/*
mysql_query('use php');
if(!$conn){
die("databases con't connect").mysql_error();
}
$sql = "insert into msg (id,title,name,content) values (11,'标题','赵云','青虹剑')";
echo $sql ;
$rs = mysql_query($sql,$conn);
if(!$rs){
echo"error 1064".mysql_error();
}
*/
$sql = 'use php';
// 用mysql_query发送查询
$rs = mysql_query($sql,$conn);
var_dump($rs);
// 调用 mysql_query发送查询后,返回值,有两种可能. 布尔型/资源型
$sql = "insert into msg (id,title,name,content) values (6,'标题6','赵云','青虹剑')";
$rs = mysql_query($sql,$conn);
var_dump($rs);
?>

送TA礼物

IP属地:四川

1楼2014-04-09 17:21回复

<?php
$title = $_POST['title'];
$username = $_POST['username'];
$content = $_POST['content'];
$conn = mysql_connect('localhost','root','xiaosatufu');
//mysql_query('set names gbk');
$sql = 'use php' ;
mysql_query($sql,$conn);
$sql = "insert into msg (title,name,content) values ('$title','$username','$content')";
//echo $sql;
$rs =mysql_query($sql,$conn);
if($rs){
echo 'success';
}else{
echo 'faild';
echo mysql_error();
}
?>

IP属地:四川

2楼2014-04-09 17:21

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE> 留言本项目</TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
<script type="text/javascript">
</script>
<style type="text/css">
</style>
</HEAD>
<BODY>
<form action = "pub.php" method ="POST">
<p>留言标题：<input type="text" name = "title" /></p>
<p>留言者：<input type = "text" name = "username" /></p>
</p>留言内容:<br />
<textarea name = "content"></textarea>
</p>
<p><input type="submit" value="提交留言" /></p>
</form>
</BODY>
</HTML>

IP属地:四川

3楼2014-04-09 17:22

<?php
$conn = mysql_connect('localhost','root','xiaosatufu');
mysql_query('set names gbk');
$sql = 'use php';
mysql_query($sql,$conn);
$sql = 'select * from msg';
$rs =mysql_query($sql,$conn);
//var_dump($rs);
/*
print_r(mysql_fetch_assoc($rs));
print_r(mysql_fetch_assoc($rs));
print_r(mysql_fetch_assoc($rs));
print_r(mysql_fetch_assoc($rs));
print_r(mysql_fetch_assoc($rs));
print_r(mysql_fetch_assoc($rs));
print_r(mysql_fetch_assoc($rs));
print_r(mysql_fetch_assoc($rs));
print_r(mysql_fetch_assoc($rs));
print_r(mysql_fetch_assoc($rs));
print_r(mysql_fetch_assoc($rs));
print_r(mysql_fetch_assoc($rs));
print_r(mysql_fetch_assoc($rs));
print_r(mysql_fetch_assoc($rs));
print_r(mysql_fetch_assoc($rs));
var_dump(mysql_fetch_assoc($rs));
*/
$list = array();
while($row = mysql_fetch_assoc($rs)){
//echo "success<br />";
$list[ ] = $row; //把$row装到数组，并不指定索引。
}
print_r($list);
?>

IP属地:四川

4楼2014-04-09 17:22

<?php
//留言具体页
/*
从地址栏接收$_GET参数，获取id值
根据id拼接sql语句
发送sql语句，并取出数据并打印。
*/
$id = $_GET['id'] + 0 ;
if($id==0){
echo '参数不正确'；
exit;
}
$conn = mysql_connect('localhost','root','xiaosatufu');
$sql = 'use php ';
mysql_query($sql,$conn);
$sql = "select * from msg where id = $id" ;
$rs = mysql_query($sql,$conn);
$msg = mysql_fetch_assoc($rs);
if(!$msg){
echo '参数有误';
exit;
}
print_r($msg);
?>

IP属地:四川

6楼2014-04-09 17:32

<?php
// 留言具体页面
/*
思路:
从地址栏接收$_GET参数,获取id值
根据id拼接sql语句.
发送sql语句,并取出数据,再打印出来
*/
$id = $_GET['id'] + 0; // 1 or 1>0
if($id == 0) {
echo '参数有误';
exit;
}
$conn = mysql_connect('localhost','root','xiaosatufu');
mysql_query('set names gbk');
$sql = 'use php';
mysql_query($sql,$conn);
$sql = "select * from msg where id = $id";
$rs = mysql_query($sql,$conn);
$msg = mysql_fetch_assoc($rs);
if(!$msg) {
echo '参数有误';
exit;
}
print_r($msg);

IP属地:四川

7楼2014-04-10 11:37