<?php
header("Content-Type:text/html;charset=utf-8");
//1、连接数据库
$link=mysql_connect('localhost','root','root');
mysql_select_db("cms2");
$sql="insert cms_admin(aname,pwd)
value
('xixix',md5('123456789'))
";
var_dump($sql);
$res=mysqli_query($link,$sql);
var_dump($res);
mysql_close();
----------------------------------------------------------------------
<?php
header("Content-Type:text/html;charset=utf-8");
//1、连接数据库
$link=mysql_connect('localhost','root','root');
mysql_select_db("cms2");
$sql="insert cms_admin(aname,pwd)
value
('xixi',md5('123456'))
";
$result=mysql_query($sql);
var_dump($result);
echo "<br/>";
if($result==true){
echo '被插入的行数为:'.mysql_insert_id();
echo "操作成功";
}else{
echo "操作失败";
}
//关闭链接
mysql_close();
----------------------------------------------------------------------
<?php
header("Content-Type:text/html;charset=utf-8");
if(!empty($_POST)){
//若是$_POST不是空,则是表示用户正常传入了数据
$aname=$_POST['username'];
$pwd=$_POST['password'];
$link=mysql_connect('localhost','root','root');
mysql_select_db('cms2');
$sql="set names utf8";
$res=mysql_query($sql);
$sql="insert cms_admin(aname,pwd)
value
('{$aname}',md5('{$pwd}'))";
$result=mysql_query($sql);
if($result){
echo "注册成功,您的id号为:".mysql_insert_id();
}else{
echo "注册失败";
}
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Title</title>
</head>
<body>
<center>用户注册</center>
<br/><br/>
<form action="test.php" method="post">
用户名:<input type="text" name="username"><br/><br>
密 码: <input type="text" name="password"><br/><br>
<input type="submit" value="注册">
</form>
</body>
</html>
----------------------------------------------------------------------
<?php
header("Content-Type:text/html;charset=utf-8");
//1、连接数据库
$link = mysql_connect("localhost","root","root");
//2、选择默认数据库
mysql_select_db("cms");
//3、操作-有返回结果集的sql语句 返回 资源
$query = "select id,aname,age from
cms_admin where id<4";
$result = mysql_query($query);
//取得一行结果 赋值给 $row
$row = mysql_fetch_array($result,MYSQL_ASSOC);
while($row){
//判断完 $row的值,若不为false,则输出
var_dump($row);
echo "<hr/>";
//再次从mysql_query查询的资源中获取结果
// row可能是数组 也有可能是false
$row = mysql_fetch_array($result,MYSQL_ASSOC);
}
//4、关闭数据库 释放资源
mysql_close()
----------------------------------------------------------------------
<?php
header("Content-Type:text/html;charset=utf-8");
//1、连接数据库
$link = mysql_connect("localhost","root","root");
//2、选择默认数据库
mysql_select_db("cms");
//3、操作-有返回结果集的sql语句 返回 资源
$query = "select id,aname,age from
cms_admin where id<4";
$result = mysql_query($query);
//取得一行结果 赋值给 $row
//$row的值,可能是数组,也可能是false
/*
* 5、应用mysql获取结果的函数,
* 将cms_admin表中的数据读取出来放到table表格中。
*/
while($row = mysql_fetch_array($result,
MYSQL_ASSOC)){
var_dump($row);
echo "<hr/>";
}
//4、关闭数据库 释放资源
mysql_close();
----------------------------------------------------------------------
<?php
header('Content-Type:text/html;charset=utf-8');
$link=mysql_connect('localhost','root','root');
mysql_select_db('cms2');
$sql='set names utf8';
mysql_query($sql);
$sql="select id,aname from cms_admin";
$result=mysql_query($sql);
while($row=mysql_fetch_ASSOC($result,MYSQL_ASSOC)){
echo '<pre/>';
var_dump($row);
echo '</pre>';
}
mysql_close();
----------------------------------------------------------------------
<?php
header('Content-Type:text/html;charset=utf-8');
$link=mysql_connect('localhost','root','root');
mysql_select_db('cms2');
$sql='set names utf8';
mysql_query($sql);
$sql="select id,aname from cms_admin";
$result=mysql_query($sql);
//首先将结果结以关联数组的形式存进索引数组
while($row=mysql_fetch_row($result)){
$arrnew[]=$row;
}
$html='<thead><tr><th>'.'id'.'</th><th>'.'aname'.'</th></tr><thead>';
echo '<table style="border:1px solid #ddd">';
echo $html;
echo '<tbody>';
foreach($arrnew as $key=>$val){//key=0,1,2
echo '<tr>';
foreach($val as $k=>$v){
echo '<td>'.$v.'</td>';
}
echo '</tr>';
}
echo '</body>';
echo '</table>';
echo '<pre>';
print_r($arrnew);
echo '</pre>';
mysql_close();
----------------------------------------------------------------------
<?php
header('Content-Type:text/html;charset=utf-8');
$link=mysql_connect('localhost','root','root');
mysql_select_db('cms2');
$sql='set names utf8';
mysql_query($sql);
$sql="select id,aname from cms_admin";
$result=mysql_query($sql);
//首先将结果结以关联数组的形式存进索引数组
$html='<thead><tr><th>'.'id'.'</th><th>'.'aname'.'</th></tr><thead>';
echo '<table style="border:1px solid #ddd">';
echo $html;
echo '<tbody>';
while($row=mysql_fetch_assoc($result)){
echo '<tr>';
echo '<td>'.$row['id'].'</td>';
echo '<td>'.$row['aname'].'</td>';
echo '</tr>';
}
echo '</body>';
echo '</table>';
mysql_close();
MySql基础5
最新推荐文章于 2024-10-05 13:49:12 发布