MySQL函数操作数据库

1.select语句查询信息(实现模糊查询)

<form name="form1" method="post" action="">
    <input name="txt_keyword" type="text" id="txt_keyword" size="40">
    <input name="Submit" type="submit" class="btn_grey" value="搜索" onclick="return check(form)">
</form>
<script type="text/javascript">
    function check(form){
        if(form.txt_keyword.value==""){
            alert("请输入查找关键字！");
            form.txt_keyword.focus();
            return false;
        }
        form.submit(); //提交表单
    }
</script>
<?php
    $conn=mysql_connect("localhost","root","root")or die("数据库连接错误".mysql_error()); //连接数据库
    mysql_select_db("testphp",$conn)or die("数据库访问错误".mysql_error());  //选择数据库
    mysql_query("set names 'utf8'");         //选择编码格式
    $keyword=$_POST[txt_keyword];            //获取输入的关键词
    $sql=mysql_query("select * from tb_affiche where title like '%$keyword%' or content like '%$keyword%'"); //执行查询语句
    $row=mysql_fetch_object($sql); //获取查询结果集
    if(!$row){         //判断查询结果集是否存在，不存在返回true
        echo "<font color='red'>你搜索的信息不存在！</font>";
    }
    do{                                   //do...while输出查询结果
        ?>
        <table border="1">
        <tr bgcolor="#fffff">
            <td width="50" height="31"><?php echo $row->title;?></td>
            <td width="433" height="31"><?php echo $row->content;?></td>
        </tr>
        </table>
        <?php
    }while ($row=mysql_fetch_object($sql)); 
    mysql_free_result($sql);     //关闭记录集
    mysql_close($conn);      // 关闭数据库连接
?>

2.insert语句添加信息

add_affiche.php页面的代码
<form name="form1" method="post" action="check_add_affiche.php">
    <table width="520" height="212" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
        <tr>
            <td width="87" align="center">公告主题：</td>
            <td width="433" height="31">
                <input name="txt_title" type="text" id="txt_title" size="40">*
            </td>
        </tr>
        <tr>
            <td width="124" align="center">公告内容：</td>
            <td>
                <textarea name="txt_content" cols="50" rows="8" id="txt_content"></textarea>
            </td>
        </tr>
        <tr>
            <td height="40" colspan="2" align="center">
                <input name="Submit" type="submit" class="btn_grey" value="保存" onclick="return check(form)">
                <input name="Submit2" type="reset" value="重置">
            </td>
        </tr>
    </table>
</form>
<script type="text/javascript">
    function check(form){
        if(form.txt_title.value==""){
            alert("请输入公告标题！");
            form.txt_title.focus();
            return false;
        }
        if(form.txt_content.value==""){
            alert("请输入公告内容！");
            form.txt_content.focus();
            return false;
        }
        form.submit();
    }
</script>

 

check_add_affiche.php页面代码

<?php
    $conn=mysql_connect("localhost","root","root")or die("数据库连接错误".mysql_error());
    mysql_select_db("testphp",$conn)or die("数据库访问错误".mysql_error());
    mysql_query("set names 'utf8'");
    $title=$_POST[txt_title];
    $content=$_POST[txt_content];
    $createtime=date("Y-m-d H:i:s");
    $sql=mysql_query("insert into tb_affiche(title,content,createtime)values('$title','$content','$createtime')");
    echo "<script>alert('公告信息添加成功！');window.location.href='add_affiche.php';</script>";
    mysql_free_result($sql);
    mysql_close($conn);
?>

 

3.update语句修改信息

<?php
    $conn=mysql_connect("localhost","root","root")or die("数据库连接错误".mysql_error());
    mysql_select_db("testphp",$conn)or die("数据库访问错误".mysql_error());
    mysql_query("set names 'utf8'");
    $title=$_POST[txt_title];
    $content=$_POST[txt_content];
    $id=$_POST[id];
    $sql=mysql_query("update tb_affiche set title='$title',content='$content'where id=$id");
    if($sql){
        echo "<script>alert('公告信息编辑成功！');history,back();window.location.href='modify.php?id=$id';</script>";
    }
    else{
        echo "<script>alert('公告信息编辑失败！');history,back();window.location.href='modify.php?id=$id';</script>";
    }
    mysql_free_result($sql);
    mysql_close($conn);
?>

 

4.delete语句删除信息

<?php
    $conn=mysql_connect("localhost","root","root")or die("数据库连接错误".mysql_error());
    mysql_select_db("testphp",$conn)or die("数据库访问错误".mysql_error());
    mysql_query("set names 'utf8'");
    $id=$_POST[id];
    $sql=mysql_query("delete from tb_addiche where id=$id");
    if($sql){
        echo "<script>alert('公告信息删除成功！');history,back();window.location.href='delete_affiche.php?id=$id';</script>";
    }
    else{
        echo "<script>alert('公告信息删除失败！');history,back();window.location.href='delete_affiche.php?id=$id';</script>";
    }
    mysql_free_result($sql);
    mysql_close($conn);
?>