PHP中mysql数据库基础操作

<p>create table user1(</p> id int primary key auto_increment,<br /> name varchar(32) not null,<br /> password varchar(64) not null,<br /> email varchar(128) not null,<br /> age unsigned tinyint not null<br /><p> )</p>

insert into user1(name,password,email,age) value ('zs',md5('12345'),'zs@163.com',30);

$conn=mysql_connect("127.0.0.1","root","901822");<br />if(!$conn){<br />die("连接失败".mysql_error());<br />}else{<br /> echo "成功";<br /><p>}

mysql_select_db("test");

mysql_query("set names utf8");

$sql="select * from user1";<br />$sql="insert into user1(name,password,email,age) values('小明',md5('123'),'xiaoming@163.com',34)";<br />$res=mysql_equery($sql,$conn);

while($row=mysql_fetch_row($res)){<br /> echo "<br/>$row[0]--$row[1]--$row[2]";<br /> echo "<br/>";<br /> var_dump($row);<br />}

<p>$row=mysql_fetch_array($res);<br /></p>foreach($row as $key=>$val){<br /> echo "--$val";<br /> }<br /> echo "<br/>";<br />}<br />

mysql_free_result($res);<br /><p>mysql_close($conn);</p>