PHP+Mysql+jQuery+fullcalendar实现的微型公司内部订餐系统(1/8)

本文涉及到的插件: jQuery, jQuery.UI, fullcalendar

数据库教程创建:

CREATE TABLE USER
(
  ID INT PRIMARY KEY AUTO_INCREMENT,
  NAME VARCHAR(100)
);

CREATE TABLE ITEM
(
  ID INT PRIMARY KEY AUTO_INCREMENT,
  USER_ID INT,
  FOOD TINYBOLB,
  ORDER_TIME TIMESTAMP
);

ALTER TABLE ITEM ADD FOREIGN KEY(USER_ID) REFERENCES USER(ID) ON DELETE CASCADE;

一个实体的基类, 封装的不太好: Entity.php教程

PHP code

php教程 mssql 数据库教程连接类代码

代码如下

复制代码

class DB_Sql {   var $Host     = "";   var $Database = "";   var $User     = "";   var $Password = "";   var $Link_ID  = 0;   var $Query_ID = 0;   var $Record   = array();   var $Row      = 0;     var $Errno    = 0;   var $Error    = "";   var $Auto_Free = 0;     ## set this to 1 to automatically free results       /* public: constructorwww.111cn.net */   function DB_Sql($query = "") {       $this->query($query);   }   function connect() {     if ( 0 == $this->Link_ID ) {       $this->Link_ID=mssql_connect($this->Host, $this->User, $this->Password);       if (!$this->Link_ID)         $this->halt("Link-ID == false, mssql_pconnect failed");       else           @mssql_select_db($this->Database, $this->Link_ID);     }   }   function free_result(){       mssql_free_result($this->Query_ID);       $this->Query_ID = 0;   }     function query($Query_String)   {         /* No empty queries, please, since PHP4 chokes on them. */     if ($Query_String == "")       /* The empty query string is passed on from the constructor,        * when calling the class without a query, e.g. in situations        * like these: '$db = new DB_Sql_Subclass;'        */       return 0;       if (!$this->Link_ID)         $this->connect();     #   printf("<br>Debug: query = %s<br> ", $Query_String);

 

//自动计算二个字段的值赋给另一字段sql

$sql ="update table set sum = mathe +language";

//求一个字段列的数据总和

$sql = "select sum(sum) from tables";

//下们我们来看个实例

/*
创建表
CREATE TABLE `cc`.`sumtable` (
`id` INT( 4 ) NOT NULL ,
`a1` INT( 4 ) NOT NULL ,
`a2` INT( 4 ) NOT NULL ,
`summ` INT( 8 ) NOT NULL
) ENGINE = InnoDB

插入记录

INSERT INTO `cc`.`sumtable` (
`id` ,
`a1` ,
`a2` ,
`summ`
)
VALUES (
'1', '5', '5', '0'
), (
'2', '6', '5', '0'
);
*/

//自动计算二个字段的值赋给另一字段sql
update sumtable set summ = a1+a2

//求和
SELECT sum( summ ) FROM sumtable
sum(summ) 
21

//本站原创文章转载注明来源www.111cn.net

<?php教程
//定义一个数组，用于存放排重后的结果
$result = array();
//读取uid列表文件
$fp = fopen('test.txt', 'r');

while(!feof($fp))
{
$uid = fgets($fp);
$uid = trim($uid);
$uid = trim($uid, " ");
$uid = trim($uid, " ");

if($uid == '')
{
continue;
}
//以uid为key去看该值是否存在
if(empty($result[$uid]))
{
$result[$uid] = 1;
}
}

fclose($fp);

//将结果保存到文件
$content = '';
foreach($result as $k => $v)
{
$content .= $k." ";
}
$fp = fopen('result.txt', 'w');
fwrite($fp, $content);
fclose($fp);
?>　　

<?php
//定义数组，用于存放排重后的结果
$result = array();
//读取第一个uid列表文件，放入$result_1
$fp = fopen('test_1.txt', 'r');
while(!feof($fp))
{
$uid = fgets($fp);
$uid = trim($uid);
$uid = trim($uid, " ");
$uid = trim($uid, " ");
if($uid == '')
{
continue;
}
//以uid为key写入$result，如有重复就会覆盖
$result[$uid] = 1;
}
fclose($fp);
//读取第二个uid列表文件，并进行排重操作
$fp = fopen('test_2.txt', 'r');
while(!feof($fp))
{
$uid = fgets($fp);
$uid = trim($uid);
$uid = trim($uid, " ");
$uid = trim($uid, " ");
if($uid == '')
{
continue;
}
//以uid为key去看该值是否存在
if(empty($result[$uid]))
{
$result[$uid] = 1;
}
}
fclose($fp);
//$result里保存的就排重以后的结果，可以输出到文件，代码省略
?>

$this->beginTransaction();
$this->exec('update people set age=2');

//$step1 = mysql教程_error();//你的类里，改成如果执行sql错误，获取错误代码，相应的函数

代码如下	复制代码
$this->exec('INSERT INTO course (course,num) VALUES ("数学",100)'); //$step2 = mysql_error(); if (!$step1 && !$step2) {  $this->commit(); } else {  $this->rollBack(); }