首页 > 编程技术 > php

php修改更新数据库用户记录的函数

发布时间:2016-11-25 16:51

php修改更新数据库用户记录的函数

$link_id = mysql_connect("localhist","root","qwaszx") or die("连接失败!");
if($link_id)
{
 mysql_select_db("my_test");
 if(!$_GET[id])
 {
  $result = mysql_query("select * from userinfo");
  echo "<TABLE border = 1>
   <TR>
   <TD>编号</TD>
   <TD>用户名称</TD>
   <TD>性别</TD>
   <TD>年龄</TD>
   <TD>注册时间</TD>
   <TD>操作</TD>
   </TR>";
  while($row = mysql_fetch_array($result))
  {
   echo "<TR>
    <TD>".$row[id]."</TD>
    <TD>".$row[uername]."</TD>
    <TD>".$row[gender]."</TD>
    <TD>".$row[age]."</TD>
    <TD>".$row[regdate]."</TD>
    <TD><a href = modify.php?id = ".$row[id].">编辑</a></TD>
    </TR>";
  }
  echo "</TABLE>";
 }else
 {
  if(!$_POST[ok])
  {
   $sql = "select * frim userinfo where id = ".$_GET[id];
   $result = mysql_query($sql);
   $row = mysql_fetch_array($result);
   ?>
            <form method = post action = 'modify.php?id = <? echo $_GET[id];?>'>
            <?
   echo $row[id]."<br>";
   ?>
            <INPUT TYPE = "hidden" name = "id" value = <? echo $row[id];?>>
            姓名 <input type = text name = "uername" value = <? echo $row[uername];?>><br>
            性别 <input type = text name = "gender" value = <? echo $row[gender];?>><br>
            年龄 <input type = text name = "age" value = <? echo $row[age];?>><br>
            注册时间 <input type = text name = "regdate" value = <? echo $row[regdate];?>><br>
            <input type = submit name = ok value = "提交">
            </form>
            <?
  }else
  {
   $sql = "update userinfo set username = '".$_POST[username]."',gender = '".$_POST[gender]."',age = '".$_POST[age]."',regdate = '".$_POST[regdate]."'where id = '".$_POST[id]."'";
   $result = mysql_query($sql);
   if($result)
    echo "记录已经成功修改<br>"<a href = 'modify.php'>继续修改记录</a>;
   else
    echo "记录修改失败<br><a href = modify.php?id = ".$_POST[id].">返回</a>";
  }
 }
}

require.include.require_once.include_once的用法和区别

四种引用文件的方法:require . include . require_once . include_once。
  require 的使用方法如 require("MyRequireFile.php"); 。这个函数通常放在 PHP 程序的最前面,PHP 程序在执行前,就会先读入 require 所指定引入的文件,使它变成 PHP 程序网页的一部份。常用的函数,亦可以这个方法将它引入网页中。

  include 使用方法如 include("MyIncludeFile.php"); 。这个函数一般是放在流程控制的处理部分中。PHP 程序网页在读到 include 的文件时,才将它读进来。这种方式,可以把程序执行时的流程简单化.

require_once 和 include_once 的方法跟 require 和 include 的方法一样,它们的区别只是 require_once 和 include_once 只会将文件包含一次,不会重复包含.

php用文件保存数据统计网页访问人数的函数

$jishu="jishu.txt";
if(!file_exists($jishu))
{
 $kjs = fopen($jishu,"w");
 fwrite($kjs,0);
 fclose($kjs);
}
function kaishi($jishu)
{
 $js = fopen($jishu,"r");
 $du = fread($js,8);
 fclose($js);
 $du += 1;
 echo "你是本站的第".$du."位访客!!!";
 $xie = fopen($jishu,"w");
 fwrite($xie,$du);
 fclose($xie);
}
    kaishi($jishu);

php删除目录的函数

实例应用做删除有文件目录的函数:
function scmulu($mlming)
{
 $dkml = opendir($mlming);
 readdir($dkml);
 readdir($dkml);
 while(($wj = readdir($dkml))!==false)
 {
  $wj = $mlming.DIRECTORY_SEPARATOR.$wj;
  if(is_dir($wj))
  {
   scmulu($wj);
  }else
  {
   if(unlink($wj))
   {
    echo "文件<b>$wj</b>删除成功<br>";
   }else
   {
    echo "文件<b>$wj</b>删除失败<br>";
   }
  }
 }
 closedir($dkml);
  if(rmdir($mlming))
  {
   echo "目录<b>$mlming</b>删除成功<br>";
  }else
  {
   echo "目录<b>$mlming</b>删除失败<br>";
  }
}

php接口的使用实例函数

interface Ren1
{const XINGMING="张三";
 function shuohua1();
 function shuohua2();}
interface Ren2 extends Ren1
{function shuohua3();
 function shuohua4();}
interface Ren3
{function shuohua5();}
interface Ren4
{function shuohua6();}
class Ren5
{function shuohua7()
 {echo "7777<br>";}}
class Ren extends Ren5 implements Ren2,Ren3,Ren4
{function shuohua1()
{echo "1111<br>";}
 function shuohua2()
{echo "2222<br>";}
 function shuohua3()
{echo "3333<br>";}
 function shuohua4()
{echo "4444<br>";}
 function shuohua5()
{echo "5555<br>";}
 function shuohua6()
{echo "6666<br>";}}
$r=new Ren();
echo Ren::XINGMING."<br>";
$r->shuohua1();
$r->shuohua2();
$r->shuohua3();
$r->shuohua4();
$r->shuohua5();
$r->shuohua6();
$r->shuohua7();
例输出:
张三
1111
2222
3333
4444
5555
6666
7777

标签:[!--infotagslink--]

您可能感兴趣的文章: