8
Jun
数据表结构:
--
-- 表的结构 `ceshi`
--
CREATE TABLE IF NOT EXISTS `ceshi` (
`id` int(5) NOT NULL auto_increment,
`income` decimal(9,2) NOT NULL,
`spending` decimal(9,2) NOT NULL,
`date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
如图:


假设要对income(收入字段)和spending(支出字段)汇总,语句如下:
语句中最后的“a”相对于严重符号,但必须有,否则无效。
--
-- 表的结构 `ceshi`
--
CREATE TABLE IF NOT EXISTS `ceshi` (
`id` int(5) NOT NULL auto_increment,
`income` decimal(9,2) NOT NULL,
`spending` decimal(9,2) NOT NULL,
`date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
如图:
假设要对income(收入字段)和spending(支出字段)汇总,语句如下:
select id,income,spending,date from ceshi
union all
select "Total",sum(income),sum(spending),"" from (
select id,income,spending,date from ceshi) a
union all
select "Total",sum(income),sum(spending),"" from (
select id,income,spending,date from ceshi) a
语句中最后的“a”相对于严重符号,但必须有,否则无效。
9
Oct
方法一,使用object:
方法二,使用embed:
方法三,综合使用:
<object type="application/pdf" data="attachment/G38.pdf" width="100%" height="100%"></object>
方法二,使用embed:
<embed src="attachment/G38.pdf" width="600" height="600"></embed>
方法三,综合使用:
<object classid="clsid:CA8A9780-280D-11CF-A24D-444553540000" width="100%" height="100%" border="0"><!--IE-->
<param name="_Version" value="65539">
<param name="_ExtentX" value="20108">
<param name="_ExtentY" value="10866">
<param name="_StockProps" value="0">
<param name="SRC" value="attachment/G38.pdf">
<embed src="attachment/G38.pdf" width="100%" height="600" href="attachment/G38.pdf"></embed><!--FF-->
</object>
<param name="_Version" value="65539">
<param name="_ExtentX" value="20108">
<param name="_ExtentY" value="10866">
<param name="_StockProps" value="0">
<param name="SRC" value="attachment/G38.pdf">
<embed src="attachment/G38.pdf" width="100%" height="600" href="attachment/G38.pdf"></embed><!--FF-->
</object>
11
Sep
获取查询到的结果
第一种:mysql_fetch_row($result);
$row=mysql_fetch_row($result);
echo $row[0]; //按行号查询
第二种:mysql_fetch_array($result); //推荐用改语句
$row=mysql_fetch_array($result);
echo $row[0]; //按行号查询
echo $row['key']; //也可以按字段名称查询
第一种:mysql_fetch_row($result);
$row=mysql_fetch_row($result);
echo $row[0]; //按行号查询
第二种:mysql_fetch_array($result); //推荐用改语句
$row=mysql_fetch_array($result);
echo $row[0]; //按行号查询
echo $row['key']; //也可以按字段名称查询
24
Aug
效果一(我采用了这个):
效果二(点回车后,麻烦就出现了):
<?php//获取搜索关键字
$keyword=trim($_POST[“keyword”]); //检查是否为空
if($keyword==””) {echo”不能为空”;exit;//结束程序}
?>
$keyword=trim($_POST[“keyword”]); //检查是否为空
if($keyword==””) {echo”不能为空”;exit;//结束程序}
?>
效果二(点回车后,麻烦就出现了):
<?
$title= $_POST["title"];
if($title==''){
echo "<script>alert('不能为空!')</script>";
}
?>
$title= $_POST["title"];
if($title==''){
echo "<script>alert('不能为空!')</script>";
}
?>
20
Aug
EXCEL宏(怎么操作就不需要介绍了),直接上宏代码:
注意:拆分后的文件都默认与原文件在同一个文件夹下面。
Sub 拆分多个工作表为独立文件()
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Dim XSheet As Worksheet
For Each XSheet In ActiveWorkbook.Sheets
XSheet.Copy
ActiveWorkbook.SaveAs Filename:=ThisWorkbook.Path & "\" & ActiveSheet.Name & ".xls"
ActiveWindow.Close
Next
Application.ScreenUpdating = True
End Sub
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Dim XSheet As Worksheet
For Each XSheet In ActiveWorkbook.Sheets
XSheet.Copy
ActiveWorkbook.SaveAs Filename:=ThisWorkbook.Path & "\" & ActiveSheet.Name & ".xls"
ActiveWindow.Close
Next
Application.ScreenUpdating = True
End Sub
注意:拆分后的文件都默认与原文件在同一个文件夹下面。