php 入门
时间:2008-08-07 来源:feng1001001
1、新建一个create.php
//也可以 include("conn/conn.php");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
if (mysql_query("CREATE DATABASE my_ddb",$con))
{
echo "Database created";
}
else
{
echo "Error creating database: " . mysql_error();
}
mysql_select_db("my_ddb", $con);
$sql = "CREATE TABLE person
(
`lid` integer (255) NOT NULL AUTO_INCREMENT ,
`xiangm` varchar (20),
`jied` varchar (100),
`daik` varchar (100),
`juli` varchar (100),
`jif` varchar (100),
`peip` varchar (100),
`swi` varchar (100),
`user` varchar (100),
`user_p` varchar (100),
`time` varchar (100),
`dail` varchar (100),
`sub` varchar (100),
PRIMARY KEY (`lid`)
)TYPE=MyISAM CHARACTER SET latin1 COLLATE latin1_swedish_ci";
echo "table person";
mysql_query($sql,$con);mysql_close($con);
?>
2、显示
Select_all
类别
项目
科目
主角
配角
道具
任务
计划
时间
地点
结果
原因
备注
">显示
">修改
">删除
添加
©2008 feng1001001.cublog.cn
3、添加
3-1/2 前台
类别:
项目:
科目:
主角:
配角:
任务:
计划:
时间:
地点:
结果:
原因:
备注:
3-2/2
if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "1 record added";
echo"alert('添加成功');";
echo "window.location='select_edit_del.php';";
?>
4、删除
4-1/2
id:
4-2/2
5、修改
5-1/2
edit
类别
>项目
>科目
>主角
>配角
>任务
>计划
>时间
>地点
>结果
>原因
>备注
备注
">
">
">
">
">
">
">
">
">
">
">
">
">
5-2/2
include "conn/conn.php";
$sql=mysql_query("UPDATE person SET xiangm='$xiangm', jied='$jied', daik='$daik', juli='$juli' , jif='$jif', peip='$peip', swi='$swi', user='$user', user_p='$user_p', time='$time', dail='$dail' , sub='$sub'WHERE lid=$id");
$result = mysql_query($sql);
if(Count($result)>0)
{
echo"alert('修改成功');";
echo "window.location='select_edit_del.php';";
}
else
{
echo"alert('修改失败');";
echo "window.location='select_edit_del.php';";
}
?>
6、整合
Select_all
类别
>项目
>科目
>主角
>配角
>任务
>计划
>时间
>地点
>结果
>原因
>备注
备注
">显示
">修改
">删除
添加
©2008 abctv
7、单个查询任务
7-1/2
输入查询
function isnull()
{
if(document.myform.cha.value=="")
{
alert("文本框不能为空")
return;
}
else
{
document.myform.submit();
}
}
查询名称:
7-2/2
类别
>项目
>科目
>主角
>配角
>任务
>计划
>时间
>地点
>结果
>原因
>备注
备注
";
while($row = mysql_fetch_array($sql))
{
echo "";
echo "" .$row['lid'] . "";
echo "" .$row['xiangm'] . "";
echo "" .$row['jied'] . "";
echo "" .$row['daik'] . "";
echo "" .$row['juli'] . "";
echo "" .$row['jif'] . "";
echo "" .$row['peip'] . "";
echo "" .$row['swi'] . "";
echo "" .$row['user'] . "";
echo "" .$row['user_p'] . "";
echo "" .$row['time'] . "";
echo "" .$row['dail'] . "";
echo "" .$row['sub'] . "";
}
mysql_close($con1)
?>
8-1 查询 index.html
查询界面
function isnull()
{
if(document.myform.cha.value=="")
{
alert("文本框不能为空")
return;
}
else
{
document.myform.submit();
}
}
查询界面:
8-2 查询后台 sselect_id.php
if($_POST[xxxxx]=="")
{
echo "location.href=\"\";";
}
else
{
mysql_select_db("my_ddb", $con1);
$sql = mysql_query("select * from person where jied like '%$cha%'");
echo "
类别
>项目
>科目
>主角
>配角
>任务
>计划
>时间
>地点
>结果
>原因
>备注
";
while($row = mysql_fetch_array($sql))
{
echo "";
echo "" .$row['xiangm'] . "";
echo "" .$row['jied'] . "";
echo "" .$row['sub'] . "";
echo "" .$row['daik'] . "";
echo "" .$row['juli'] . "";
echo "" .$row['jif'] . "";
echo "" .$row['peip'] . "";
echo "" .$row['swi'] . "";
echo "" .$row['user'] . "";
echo "" .$row['user_p'] . "";
echo "" .$row['time'] . "";
echo "" .$row['dail'] . "";
}
mysql_close($con1);
}
?>
//也可以 include("conn/conn.php");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
if (mysql_query("CREATE DATABASE my_ddb",$con))
{
echo "Database created";
}
else
{
echo "Error creating database: " . mysql_error();
}
mysql_select_db("my_ddb", $con);
$sql = "CREATE TABLE person
(
`lid` integer (255) NOT NULL AUTO_INCREMENT ,
`xiangm` varchar (20),
`jied` varchar (100),
`daik` varchar (100),
`juli` varchar (100),
`jif` varchar (100),
`peip` varchar (100),
`swi` varchar (100),
`user` varchar (100),
`user_p` varchar (100),
`time` varchar (100),
`dail` varchar (100),
`sub` varchar (100),
PRIMARY KEY (`lid`)
)TYPE=MyISAM CHARACTER SET latin1 COLLATE latin1_swedish_ci";
echo "table person";
mysql_query($sql,$con);mysql_close($con);
?>
2、显示
Select_all
类别
项目
科目
主角
配角
道具
任务
计划
时间
地点
结果
原因
备注
">显示
">修改
">删除
添加
©2008 feng1001001.cublog.cn
3、添加
3-1/2 前台
类别:
项目:
科目:
主角:
配角:
任务:
计划:
时间:
地点:
结果:
原因:
备注:
3-2/2
if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "1 record added";
echo"alert('添加成功');";
echo "window.location='select_edit_del.php';";
?>
4、删除
4-1/2
id:
4-2/2
5、修改
5-1/2
edit
类别
>项目
>科目
>主角
>配角
>任务
>计划
>时间
>地点
>结果
>原因
>备注
备注
">
">
">
">
">
">
">
">
">
">
">
">
">
5-2/2
include "conn/conn.php";
$sql=mysql_query("UPDATE person SET xiangm='$xiangm', jied='$jied', daik='$daik', juli='$juli' , jif='$jif', peip='$peip', swi='$swi', user='$user', user_p='$user_p', time='$time', dail='$dail' , sub='$sub'WHERE lid=$id");
$result = mysql_query($sql);
if(Count($result)>0)
{
echo"alert('修改成功');";
echo "window.location='select_edit_del.php';";
}
else
{
echo"alert('修改失败');";
echo "window.location='select_edit_del.php';";
}
?>
6、整合
Select_all
类别
>项目
>科目
>主角
>配角
>任务
>计划
>时间
>地点
>结果
>原因
>备注
备注
">显示
">修改
">删除
添加
©2008 abctv
7、单个查询任务
7-1/2
输入查询
function isnull()
{
if(document.myform.cha.value=="")
{
alert("文本框不能为空")
return;
}
else
{
document.myform.submit();
}
}
查询名称:
7-2/2
类别
>项目
>科目
>主角
>配角
>任务
>计划
>时间
>地点
>结果
>原因
>备注
备注
";
while($row = mysql_fetch_array($sql))
{
echo "";
echo "" .$row['lid'] . "";
echo "" .$row['xiangm'] . "";
echo "" .$row['jied'] . "";
echo "" .$row['daik'] . "";
echo "" .$row['juli'] . "";
echo "" .$row['jif'] . "";
echo "" .$row['peip'] . "";
echo "" .$row['swi'] . "";
echo "" .$row['user'] . "";
echo "" .$row['user_p'] . "";
echo "" .$row['time'] . "";
echo "" .$row['dail'] . "";
echo "" .$row['sub'] . "";
}
mysql_close($con1)
?>
8-1 查询 index.html
查询界面
function isnull()
{
if(document.myform.cha.value=="")
{
alert("文本框不能为空")
return;
}
else
{
document.myform.submit();
}
}
查询界面:
8-2 查询后台 sselect_id.php
if($_POST[xxxxx]=="")
{
echo "location.href=\"\";";
}
else
{
mysql_select_db("my_ddb", $con1);
$sql = mysql_query("select * from person where jied like '%$cha%'");
echo "
类别
>项目
>科目
>主角
>配角
>任务
>计划
>时间
>地点
>结果
>原因
>备注
";
while($row = mysql_fetch_array($sql))
{
echo "";
echo "" .$row['xiangm'] . "";
echo "" .$row['jied'] . "";
echo "" .$row['sub'] . "";
echo "" .$row['daik'] . "";
echo "" .$row['juli'] . "";
echo "" .$row['jif'] . "";
echo "" .$row['peip'] . "";
echo "" .$row['swi'] . "";
echo "" .$row['user'] . "";
echo "" .$row['user_p'] . "";
echo "" .$row['time'] . "";
echo "" .$row['dail'] . "";
}
mysql_close($con1);
}
?>
相关阅读 更多 +