“我”的学习笔记

CREATE TABLE IF NOT EXISTS `main` (
  `idx` INT(11) NOT NULL AUTO_INCREMENT,
  `picasa` text NOT NULL,
  `youtube` text NOT NULL,
  PRIMARY KEY (`idx`)
)

<form action="save.php" method="post">
Picasa address :
<input name="picasa" type="text" />
Youtube address:
<input name="youtube" type="text" />
<input type="submit" value="Submit" />
</form>

//数据库连接信息
$username="zetadba";
$password="qwe123123";
$database="zeta";
 
//连接数据库服务器
mysql_connect("localhost",$username,$password);
 
//选择数据库
mysql_select_db($database);
 
//写一个SQL查询语句, 保存从index.html POST过来的数据到数据库
$query = "INSERT INTO main (picasa,youtube) VALUES('".$_POST["picasa"]."','".$_POST["youtube"]."')";
 
//执行SQL语句
mysql_query($query);
 
//debug mysql的错误，之前很多错误... sql那些东西都快忘光了...
echo mysql_error();
 
//查询刚刚存进去的条目的主键数值，用来给show.php来用
$query2 = "SELECT * FROM main ORDER BY idx DESC LIMIT 1";
 
//得到数值sql结果
$result2 = mysql_query($query2);
 
//得到我们想要的主键idx的值
$videoidx = mysql_result($result2, 0, "idx");
 
//关闭... sql
mysql_close();
 
将这个页面自动跳给show.php，这样我的老年朋友就可以直接拷贝走这个URL了
header('Refresh: 3; url=show.php?vv='.$videoidx);

 
//不解释了...
$username="zetadba";
$password="qwe123123";
$database="zeta";
 
mysql_connect("localhost",$username,$password);
 
mysql_select_db($database);
 
//这里是直接用的URL数值传递，所以我们GET这个vv值
$query = "SELECT * FROM main WHERE idx='".$_GET["vv"]."'";
 
$result = mysql_query($query);
 
//没写html文件头，所以写个这个当title...
echo "Picasa+Youtube";
 
$picasa = mysql_result($result, 0, "picasa");
$youtube = mysql_result($result, 0, "youtube");
 
//我们需要解析得到的youtube后面的url结构，得到video id
//比如http://www.youtube.com/watch?v=puSkP3uym5k&list=FLV8tlMnzjrbiS7YLh8FAtPQ&index=10&feature=plpp_video
//中的puSkP3uym5k
$parsedurl = parse_url($youtube);
 
$videourlquery = $parsedurl['query'];
 
parse_str($videourlquery);
 
//经过以上的各种解析，我们最后得到了其中的v的值
$videoid = $parsedurlquery['v'];
 
//输出html结构
echo "<iframe width='99%' height='99%' border=0 src="".$picasa."" mce_src="&quot;.$picasa.&quot;"-->";
echo '<object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" width="10" height="10" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,40,0"><param name="src" value="http://www.youtube.com/v/'.$v.'?version=3&amp;hl=zh_CN&amp;autoplay=1" /><param name="allowfullscreen" value="true" /><embed type="application/x-shockwave-flash" width="10" height="10" src="http://www.youtube.com/v/'.$v.'?version=3&amp;hl=zh_CN&amp;autoplay=1" allowfullscreen="true"></embed></object>';
 
echo mysql_error();
 
mysql_close();

NSString *foo = @"ssff";
[foo release];
[foo release];

<?xml version="1.0" encoding="utf-8"?>
<s:WindowedApplication xmlns:fx="http://ns.adobe.com/mxml/2009" 
					   xmlns:s="library://ns.adobe.com/flex/spark" 
					   xmlns:mx="library://ns.adobe.com/flex/mx" width="882" height="372"
					    title="DateCounter by [email protected](Zhengliang Guo)">
	<fx:Declarations>
		<!-- Place non-visual elements (e.g., services, value objects) here -->
	</fx:Declarations>
 
	<fx:Script>
		<![CDATA[
			private function ftChanged():void
			{
				if(fromDate.selectedDate && toDate.selectedDate){
					var gapTime:Number;
					gapTime = (toDate.selectedDate.getTime() - fromDate.selectedDate.getTime()) / 1000 / 3600 / 24;
					dd.text = (gapTime).toString();
					ww.text = (gapTime/7.0).toString();
					yy.text = (gapTime/365.0).toString();
					mm.text = (int(gapTime/365) *12 + (toDate.selectedDate.getMonth() - fromDate.selectedDate.getMonth())).toString();
				}
			}
			private function midChanged(str:String):void
			{
				dstY.text = (startDate.selectedDate.getFullYear()).toString();
				dstM.text = (startDate.selectedDate.getMonth()+1).toString();
				dstD.text = (startDate.selectedDate.getDate()).toString();
 
 
				if(startDate.selectedDate)
				{
					var midTime:Number;
 
					if(str == 'y')
					{
						midTime = Number(midY.text);
						resetField2();
						midY.text = midTime.toString();
						dstY.text = (startDate.selectedDate.getFullYear() + midTime).toString();
					}
					else if(str == 'm')
					{
						midTime = Number(midM.text);
						resetField2();
						midM.text = midTime.toString();
						if(((startDate.selectedDate.getMonth() + 1 + midTime))>12)
							{
								dstY.text = (Number(dstY.text) + int((startDate.selectedDate.getMonth() + 1 + midTime)/12)).toString();
								dstM.text = ((startDate.selectedDate.getMonth() + 1 + midTime) % 12).toString();
							}
						else{
							dstM.text = (startDate.selectedDate.getMonth() + 1 + midTime).toString();
						}
					}
					else if(str == 'w')
					{
						midTime = Number(midW.text);
						resetField2();
						midW.text = midTime.toString();
 
						var tarDate:Date = new Date();
						tarDate.setTime(startDate.selectedDate.getTime() + (midTime * 7 * 24 * 3600 * 1000));
 
						dstY.text = (tarDate.getFullYear()).toString();
						dstM.text = (tarDate.getMonth() + 1).toString();
						dstD.text = (tarDate.getDate()).toString();
					}
					else if(str == 'd')
					{
						midTime = Number(midD.text);
						resetField2();
						midD.text = midTime.toString();
 
						var tarDate:Date = new Date();
						tarDate.setTime( startDate.selectedDate.getTime() + (midTime * 24 * 3600 * 1000));
 
						dstY.text = (tarDate.getFullYear()).toString();
						dstM.text = (tarDate.getMonth() + 1).toString();
						dstD.text = (tarDate.getDate()).toString();
 
					}
					else if(str == 'c')
					{
						resetField2();
					}
 				}
			}
			private function resetField2():void
			{
				midY.text = "0";
				midM.text = "0";
				midW.text = "0";
				midD.text = "0";
			}
		]]>
	</fx:Script>
 
	<mx:DateChooser id="fromDate" x="27" y="66" change="ftChanged()" showToday="false" />
	<mx:DateChooser id="toDate" x="211" y="66" change="ftChanged()" showToday="false" />
	<s:Label x="87" y="20" text="From" fontSize="25"/>
	<s:Label x="276" y="19" text="To" fontSize="25"/>
	<s:Label x="22" y="280" text="Days" fontSize="20"/>
	<s:Label x="22" y="319" text="Weeks" fontSize="20"/>
	<s:Label x="206" y="281" text="Month" fontSize="20"/>
	<s:Label x="206" y="316" text="Year" fontSize="20"/>
	<s:Label id="dd" x="96" y="281" text="d"/>
	<s:Label id="ww" x="96" y="320" text="w"/>
	<s:Label id="mm" x="272" y="285" text="m"/>
	<s:Label id="yy" x="272" y="320" text="y"/>
	<s:Panel x="433" y="10" width="433" height="328" title="Date To Time">
		<s:TextInput x="277" y="23" text="0" id="midY" change="midChanged('y')"/>
		<s:TextInput x="277" y="53" text="0" id="midM" change="midChanged('m')"/>
		<s:TextInput x="277" y="84" text="0" id="midW" change="midChanged('w')"/>
		<s:TextInput x="277" y="114" text="0" id="midD" change="midChanged('d')"/>
		<s:Label id="myy" x="225" y="28" text="Years"/>
		<s:Label id="mmm" x="225" y="59" text="Month"/>
		<s:Label id="mww" x="225" y="90" text="Weeks"/>
		<s:Label id="mdd" x="225" y="119" text="Days"/>
		<mx:DateChooser id="startDate" x="10" y="10" change="midChanged('c')" showToday="false"/>
		<s:Label x="47" y="236" text="0000" fontSize="35" id="dstY"/>
		<s:Label x="158" y="236" text="00" fontSize="35" id="dstM"/>
		<s:Label x="225" y="236" text="00" fontSize="35" id="dstD"/>
	</s:Panel>
</s:WindowedApplication>

if((navigator.userAgent.match(/iPhone/i)) || (navigator.userAgent.match(/iPod/i))){ 
    document.write('<link href="iphone.css" rel="stylesheet" type="text/css">'); 
} 
if((navigator.userAgent.match(/iPad/i))){ 
    document.write('<link href="ipadwoflash.css" rel="stylesheet" type="text/css">'); 
}

	if (strpos($_SERVER['HTTP_USER_AGENT'],"iPhone"))  
	{ 
		echo '在用户代理信息里面如果有iPhone, 执行您的代码'; 
		//别忘了给iPod和iPad也加上去当条件阿~~
	}

	if((navigator.userAgent.match(/iPhone/i)) || (navigator.userAgent.match(/iPod/i))) 
	{ 
		document.write(navigator.userAgent);
	}
	else
	{
		document.write(navigator.userAgent);
	}

//1, 构建解析方法

-(void)parseXMLFile:(NSURL *)XMLURL //XMLURL为第一个文件的URL
{
	NSXMLParser *eventParser = [[NSXMLParser alloc] initWithContentsOfURL:XMLURL];
	[eventParser setDelegate:self];  //设置代理为本地
	[eventParser parse];  //开始解析
 
	NSLog(@"end Of parseXMLFile");
}

//2, 解析开始后,所有XML的内容由NSXMLParserDelegate处理
//  所以一定要注意在本地添加<NSXMLParserDelegate>到文件头

//在NSXMLParser读到<p>的时候重写一个<p>标签,原来的是XML中的,无法直接使用
- (void)parser:(NSXMLParser *)parser didStartElement:(NSString *)elementName 
	namespaceURI:(NSString *)namespaceURI 
	qualifiedName:(NSString *)qName 
	attributes:(NSDictionary *)attributeDict
{
	if ([elementName isEqualToString:@"p"]) {
		[htmlDataString appendFormat:@"<p>"];
		needOrNot = YES;  //我们需要<p>和</p>中间的内容,其余的在end中设置NO
		return;
	}
}
 
- (void)parser:(NSXMLParser *)parser foundCharacters:(NSString *)string
{
	if(needOrNot)
	{
		[htmlDataString appendString:string]; //如上,将需要的字段添加到得到的html结构String中
	}
}
 
- (void)parser:(NSXMLParser *)parser didEndElement:(NSString *)elementName 
	namespaceURI:(NSString *)namespaceURI 
	qualifiedName:(NSString *)qName
{
	if ([elementName isEqualToString:@"p"]) {
		[htmlDataString appendFormat:@"</p>"];
		needOrNot = NO;  //不需要的内容不允许上面的delegate去读取到htmlDataString中
		return;
	}
}
 
- (void)parserDidEndDocument:(NSXMLParser *)parser
{
	NSLog(htmlDataString); //在结束后输出得到的html数据结构.
}