Database Design Experiment-开源

  • Y3_559865
    了解作者
  • 23.9KB
    文件大小
  • gz
    文件格式
  • 0
    收藏次数
  • VIP专享
    资源类型
  • 0
    下载次数
  • 2022-05-27 04:56
    上传日期
数据库设计实验是一种尝试使遵循简单命名约定的数据库可视化的尝试。 它需要MySQL,PHP和Flashplayer 7。
dbdesign-0_1.tar.gz
  • dbdesign
  • DBTableFunctions.as
    7.5KB
  • index.php
    294B
  • dbdesign.fla
    33.5KB
  • db_xml.php
    1.2KB
  • dummy.html
    93B
  • css
  • main.css
    65B
  • DBTable.as
    6.7KB
  • DBRelation.as
    7.3KB
  • include
  • dbtable.php
    3.3KB
  • common.php
    2.7KB
  • global.php
    751B
  • dbvariable.php
    4.7KB
  • dbfield.php
    3.2KB
  • dbdesign.php
    947B
  • dbdesign.swf
    6.2KB
  • global.as
    394B
  • list_dbs.php
    1.1KB
  • save.php
    1.7KB
  • dbdesign.html
    1.2KB
  • colors.clr
    162B
内容介绍
<? /********************************************************* class DBVariable Description: Variables: History: 2003-11-18 Daniel Önnerby Init version. *********************************************************/ class DBVariable{ var $iId = 0; var $sDBTable = ""; var $sDBField = ""; var $sVariable = ""; var $sValue = ""; /************************************************** function DBVariable Description: Constructor. History: 2003-11-18 Daniel Önnerby Init version. **************************************************/ function DBVariable( $sDBTable,$sDBField,$sVariable="",$sDefault="" ){ $this->sDBTable = $sDBTable; $this->sDBField = $sDBField; if($sVariable!=""){ $this->bGetVariable($sVariable,$sDefault); } } /***************************************************** function bReset Description: Input: $sMyVar = description. Returns: History: 2003-11-25 Daniel Önnerby Init version. *****************************************************/ function bReset( ){ $this->iId = 0; $this->sVariable = ""; $this->sValue = ""; } /***************************************************** function bGetVariable Description: Input: $sMyVar = description. Returns: History: 2003-11-18 Daniel Önnerby Init version. *****************************************************/ function bGetVariable( $sVariable="",$sDefault="" ){ $this->iId = 0; $this->sVariable = $sVariable; $this->sValue = $sDefault; if($this->bDBDesignTableExists()){ $sSQL="SELECT id,the_variable,the_value FROM dbdesign_variables WHERE the_table='".addslashes($this->sDBTable)."' AND the_field='".addslashes($this->sDBField)."' AND the_variable='".addslashes($sVariable)."'"; //echo $sSQL; $rsVaraible=mysql_query($sSQL); if($aVariable=mysql_fetch_array($rsVaraible)){ $this->iId = $aVariable["id"]; $this->sVariable = $aVariable["the_variable"]; $this->sValue = $aVariable["the_value"]; }else{ return false; } }else{ return false; } } /***************************************************** function bDBDesignTableExists Description: Input: $sMyVar = description. Returns: History: 2003-11-18 Daniel Önnerby Init version. *****************************************************/ function bDBDesignTableExists( $bCreate=false ){ global $sDB; if($GLOBALS["dbtableexists"]==true){ return true; }else{ if($bCreate){ $sSQL="CREATE TABLE dbdesign_variables ( id int not null auto_increment, the_table varchar(85) not null default '', the_field varchar(85) not null default '', the_variable varchar(85) not null default '', the_value text default '', primary key(id), key(the_table,the_field,the_variable) );"; mysql_query($sSQL); $GLOBALS["dbtableexists"]=true; return true; }else{ $GLOBALS["dbtableexists"]=false; $rsTables=mysql_list_tables($sDB); while( $aTable=mysql_fetch_array($rsTables) ){ if($aTable[0]=="dbdesign_variables"){ $GLOBALS["dbtableexists"]=true; } } return $GLOBALS["dbtableexists"]; } } } /***************************************************** function bUpdate Description: Input: $sMyVar = description. Returns: History: 2003-11-18 Daniel Önnerby Init version. *****************************************************/ function bUpdate( ){ if($this->bDBDesignTableExists(true)){ if($this->iId==0){ $sSQL="INSERT INTO dbdesign_variables ( the_table, the_field, the_variable, the_value ) VALUES ( '".addslashes($this->sDBTable)."', '".addslashes($this->sDBField)."', '".addslashes($this->sVariable)."', '".addslashes($this->sValue)."' )"; mysql_query($sSQL); $this->iId = mysql_insert_id(); }else{ $sSQL="UPDATE dbdesign_variables SET the_table = '".addslashes($this->sDBTable)."', the_field = '".addslashes($this->sDBField)."', the_variable = '".addslashes($this->sVariable)."', the_value = '".addslashes($this->sValue)."' WHERE id=".$this->iId; mysql_query($sSQL); } //echo $sSQL; } } /***************************************************** function bFindXMLVariable Description: Input: $sMyVar = description. Returns: History: 2003-11-25 Daniel Önnerby Init version. *****************************************************/ function bFindXMLVariable( $sVariable,$sXML,$bGet=false ){ if(preg_match("/".$sVariable."=\"(.*)\"/iU",$sXML,$aMatch)){ if($bGet){ $this->bGetVariable($sVariable); $this->sValue = $aMatch[1]; return true; }else{ return $aMatch[1]; } }else{ return false; } } } ?>
评论
    相关推荐
    • Flash 视频聊天
      AvChat的Flash视频聊天的源代码。需要Flash Media Server2.0支持。配置方法如下:1、首先安装配置好FMS2.0 2、将main.asc放到配置的Fms2.0文件夹下面。 3、配置好站点既可以访问视频聊天的页面。
    • KSDev FlashEngine 1.08
      Application for user in Delphi for manipulate Flash
    • pny虎克盘4GB优盘量产工具[慧荣sm3257enaa芯片].zip
      一个PNY的4G虎克盘,用了很多量产工具都直接显示“flashID not found in database”,一直没量产成功,今天终于找到一个完美量产工具。芯片慧荣sm3257enaa Toshiba的TLC 特拿出来给大家分享。设置密码320 ...
    • BlueX_JLINK_Database.rar
      bx Jlink jflash driver 相关的替换文件
    • McGraw.Hill.Oracle.Database.10g.High.Availability.with.RAC.Flash
      McGraw.Hill.Oracle.Database.10g.High.Availability.with.RAC.Flashback.and.Data.Guard.Apr.2004.eBook-DDU.chm.part2.rar
    • 高通增强现实imagetargets-2-0-7
      The Image Targets sample shows how to detect an image target and render a simple object on top of it. The sample code shows how to do...Manage different aspects of the camera, such as flash and autofocus
    • SMI慧荣2258XT开卡工具SM2258XT_FWP0617B
      慧荣SMI 2258XT主控开卡工具,以下是支持FLASH列表 [SM2258XT-DataBase-P0616] A0=Hynix,256Gbit,H27QEG8NDM5R-BCF Hynix,256Gbit,H27QEG8NDM5R-BCF=AD,3A,18,A3,61,25,2,16,2048,04096,0258,04216,04012,02000,02,...
    • flash p2p demo
      很好的官方的基于p2p的flash实时视频
    • DataBaseTest-master.zip
      1.基本的权限管理 shiro 2.fastdfs 3.mybatis 4.swagger #springboot 2.0.1
    • Expert Oracle Database Architecture
      Thomas Kyte写的好书,是英文版的。 讲的oracle 9i and 10g 设计开发的方案。