connect("host","user","password");
insert into tablename(字段,字段...) values('变量','变量'....);
update table set 字段='变量' where 字段='变量';//(条件)获取FORM直接 $name
insert into tablename(字段,字段...) values('变量','变量'....);
update table set 字段='变量' where 字段='变量';//(条件)获取FORM直接 $name
mysql_connect("localhost","root","");
mysql_select_db("test");
mysql_query("CREATE TABLE test (id INT( 5 ) NOT NULL AUTO_INCREMENT,name VARCHAR( 10 ) NOT NULL ,sex INT( 1 ) NOT NULL ,age INT( 3 ) NOT NULL ,INDEX ( id ))");
mysql_query("insert into test values('','tom','1','20')");
mysql_query("insert into test values('','mary','1','23')");
mysql_query("insert into test values('','cat','0','21')");
mysql_query("insert into test values('','dog','1','24')");
mysql_query("insert into test values('','terry','1','20')");
$query=mysql_query("select id,name,sex,age from test order by id limit 0,5");
while($result=mysql_fetch_array($query)){
echo $result['id']." ".$result['name']." ".$result['sex']." ".$result['age']."<br>";
}
mysql_query("update test set age=18,sex=0 where id=4");
?>
mysql_connect("localhost","root","");
mysql_select_db("test");
if($submit){
$sql="insert into test values('','".$_POST['name']."','".$_POST['sex']."','".$_POST['age']."')";echo $sql;
$query=mysql_query($sql);
if($query) echo "成功";
}
?>
<form method=post>
姓名<input name=name><br>
性别<select name=sex><option value=1>男<option value=0>女</select><br>
年龄<input name=age><br>
<input type=submit name=submit>
</form>
<?
mysql_connect("localhost","root","");
mysql_select_db("test");
mysql_query("drop table test");
mysql_query("CREATE TABLE test (id INT( 5 ) NOT NULL AUTO_INCREMENT,name VARCHAR( 10 ) NOT NULL ,sex INT( 1 ) NOT NULL ,age INT( 3 ) NOT NULL ,INDEX ( id ))");
mysql_query("insert into test values('','tom','1','20')");
mysql_query("insert into test values('','mary','1','23')");
mysql_query("insert into test values('','cat','0','21')");
mysql_query("insert into test values('','dog','1','24')");
mysql_query("insert into test values('','terry','1','20')");
$query=mysql_query("select id,name,sex,age from test order by id limit 0,5");
while($result=mysql_fetch_array($query)){
echo $result['id']." ".$result['name']." ".$result['sex']." ".$result['age']."<br>";
}
mysql_query("update test set age=18,sex=0 where id=4");
?>