喜欢FreeBSD

ajax的get实例

hihee的博客 — Sun, 21 Sep 2008 03:04:00 GMT

放在同一目录下,即可,很简单的入门.

　那么当，当用户点击“新闻1”这个链接的时候，

在下面对应的层将显示获取的内容(id)，而且页面没有任何刷新。

当然，show.php中把id值给打印出来。

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE> New Document </TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
<script language="javascript">
<!--
function InitAjax()
{

</script>

<style type="text/css">
#show_news {
border:2px red solid;
width:40px;
height:40px;
margin:20px auto;
visibility: hidden;
}
</style>

</HEAD>

</BODY>
</HTML>

<!--- 以下这个是show.php- ->

<?
    // get para(GET and POST)
    function get_para($name) {
        if (isset($_GET[$name])) {
            return $_GET[$name];
        } elseif (isset($_POST[$name])) {
            return $_POST[$name];
        } else {
            return '';
        }
    }

    // get all para(GET and POST) to a array
    function get_all_para() {
        //log_debug_var(__FILE__, $_GET + $_POST);
        return $_GET + $_POST;
    }
?>

<?php

if ($_GET['id'])
{
$id= $_GET['id'];
echo $id;

}

上中下格式css

hihee的博客 — Fri, 12 Sep 2008 13:35:00 GMT

对CSS 布局,总算是了解了,居中一定得注意,

先在body中设置text-align:center;

然后在wrap中设置

margin-left:0px auto;

margin-right:0px auto;

(或者margin:0px auto;)

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE> New Document </TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
<style type="text/css">

<!--
body{
       font:12px Simsun;
    background:#FFF;
    color:#000;
    text-align: center;
    border:2px solid red;
/*    margin:0;
    padding:0; */

}

#wrap{
  margin-left: 0px auto;
  margin-right: 0px auto;
     width:791px;
  border:2px solid red;
  }

#header{
  margin:1px;
  clear:both;
  height:100px;
  brackground:#FFCC99;
  border:1px solid black;
  }

#pagebody{
  margin:1px;
  clear:both;
  height:400px;
  backgrond:#CCFF00;
  border:2px solid black;
}

#sidebar{
  margin:1px;
  padding-top:20px;
  width:20%;
  height: 100%;
  float:left;
  border:2px dashed red;
}

    mainbody {
  margin:1px;
  float:right;
  height:100%;
  background:#EEE;
  border:2px solid red;
}

#footer {
  margin:1px;
/* clear:both;   */
  width=100%;
  height:50px;
  background:#00FFFF;
  border:2px solid red;
}

-->
</style>

</HEAD>

用php的pdo操作sqlite;

hihee的博客 — Wed, 10 Sep 2008 02:04:00 GMT

打开 c:\windows\php.ini ，
找到下面这行：extension_dir
再找到:
;extension=php_pdo.dll
;extension=php_pdo_sqlite.dll
取消注释,我用的是sqlite,重启就可以用了;

<?
phpinfo();
define("DSN", "sqlite:sys.dat");

$db = new PDO(DSN, null, null, array(PDO::ATTR_PERSISTENT => false, PDO::ATTR_TIMEOUT => 30));
/* 初始化一个PDO对象，
    构造函数的参数第一个就是我们的数据源，
    第二个是连接数据库服务器的用户，
    第三个参数是密码。我们不能保证连接成功，后面我们会讲到异常情况，这里我们姑且认为它是连接成功的。*/

/* 如果是mysql的话

define("DSN", "mysql:host=localhost;dbname=sys.dat");
$db = new PDO(DSN, 'root', '');

$count = $db->exec("INSERT INTO user_info(user_name) values('dddddddd')");
echo $count;
/* 调用我们连接成功的PDO对象来执行一个查询，
这个查询是一个插入一条记录的操作，使用PDO::exec() 方法会返回一个影响记录的结果，
所以我们输出这个结果。最后还是需要结束对象资源： */

/* 默认这个不是长连接，如果需要数据库长连接，需要最后加一个参数：array(PDO::ATTR_PERSISTENT => true) 变成这样：
$db = new PDO($dsn, null, null, array(PDO::ATTR_PERSISTENT => true)); */

echo 'dddddddddddddddd';
$db = null;

php 的public, protected, private

hihee的博客 — Sun, 07 Sep 2008 14:15:00 GMT

看了别人的, 来自http://www.phome.net/e/DoPrint/?classid=5&id=3485
<?php
class foo {
       private $x;
      public function public_foo() {
    print("I'm public");
}

protected function protected_foo() {
$this->private_foo(); //Ok because we are in the same class we can call private methods
print("I'm protected");
}

private function private_foo() {
         $this->x = 3;
        print("I'm private");
    }
}

class foo2 extends foo {
       public function display() {
       $this->protected_foo();
       $this->public_foo();
    // $this->private_foo(); // Invalid! the function is private in the base class
}
}

$x = new foo();
$x->public_foo();
//$x->protected_foo(); //Invalid cannot call protected methods outside the class and derived classes
//$x->private_foo(); //Invalid private methods can only be used inside the class

$x2 = new foo2();
$x2->display();
?>

linux 下sqlite的 C编程之sqlite3_get_table

hihee的博客 — Sun, 31 Aug 2008 15:10:00 GMT

#include <unistd.h>
#include <stdio.h>
#include <stdlib.h>
#include <sqlite3.h>
#include "test.h"
int main(int argc, char **argv)
{
        sqlite3 *db;
        char **dbResult;
        char *errmsg;
        int nRow, nColumn;
        int index=0;
        int i, j, rc;

        if( argc!=2 )
        {
                fprintf(stderr, "Usage: %s DATABASE \n", argv[0]);
                exit(1);
        }

        rc = sqlite3_open(argv[1], &db);
        if( rc != SQLITE_OK )
        {
                fprintf(stderr, "Can't open database: %s\n", sqlite3_errmsg(db));
                sqlite3_close(db);
                exit(1);
        }

        rc = sqlite3_get_table( db, "select * from users", &dbResult, &nRow, &nColumn, &errmsg);
        if (rc == SQLITE_OK)
        {
                printf("表格共%d 记录!\n", nRow);
                printf("表格共%d 列!\n", nColumn);
                // 前两个字段为字段名 field0, field1, row[0][0], row[0][1], row[1][0], row[1][1] ... ... ....
                // 是一维数组,不是二维数组,反正记着第0,第1列的值为字段名,然后才是字段值;
                printf( "字段名|字段值\n");
                printf( "%s | %s\n", dbResult[0], dbResult[1]);
                printf("--------------------------------\n");
                index = nColumn; //字段值从index开始呀
                for( i = 0; i < nRow ; i++ )
                {
                        for( j = 0 ; j < nColumn; j++ )
                        {
                                printf( "%-5s ",dbResult[index++]);
                        }
                        printf("\n");
                }
                printf("--------------------------------\n");
        }

sqlite3_close(db);
return 0;
}

/* test.h是为空的 */

makefile如下:

all: test
CC=gcc -g -Wall

clean:
        @rm -rf *.o
test: test.o
        $(CC) -ldl -lsqlite3 -o test test.o
test.o: test.c test.h
        $(CC) -c test.c

red hat as4 下编译通过;

sqlite事务操作

hihee的博客 — Sun, 31 Aug 2008 12:24:00 GMT

begin;
create table app_type_info(id integer PRIMARY KEY AUTOINCREMENT NOT NULL,
app_type_id integer,
app_type_name varchar(20));

insert into app_type_info(app_type_id, app_type_name) values(300, 'IE');
insert into app_type_info(app_type_id, app_type_name) values(301, 'FireFox');
insert into app_type_info(app_type_id, app_type_name) values(302, 'Opera');
update app_type_info set app_type_id=400 where app_type_id=302;
alter table app_type_info add column remark varchar(200);

commit;

把这个保存为inport.sql,

然后bsd@localhost#sqlite new.db < inport.sql回车,OK.

html中mouse放上显示提示

hihee的博客 — Fri, 22 Aug 2008 05:38:00 GMT

//***************内部变量定义*****************
sPop=null;
curShow=null;
tFadeOut=null;
tFadeIn=null;
tFadeWaiting=null;

document.write("<style type='text/css'id='defaultPopStyle'>");
document.write(".cPopText {background-color: #F8F8F5;color:#000000; border: 1px #000000 solid;font-color: font-size: 12px; padding-right: 4px; padding-left: 4px; height: 20px; padding-top: 2px; padding-bottom: 2px; filter: Alpha(Opacity=0)}");
document.write("</style>");
document.write("<div id='dypopLayer' style='position:absolute;z-index:1000;' class='cPopText'></div>");

}
}

function showIt(){
dypopLayer.className=popStyle;
dypopLayer.innerHTML=sPop;
popWidth=dypopLayer.clientWidth;
popHeight=dypopLayer.clientHeight;
if(MouseX+12+popWidth>document.body.clientWidth) popLeftAdjust=-popWidth-24
else popLeftAdjust=0;
if(MouseY+12+popHeight>document.body.clientHeight) popTopAdjust=-popHeight-24
else popTopAdjust=0;
dypopLayer.style.left=MouseX+12+document.body.scrollLeft+popLeftAdjust;
dypopLayer.style.top=MouseY+12+document.body.scrollTop+popTopAdjust;
dypopLayer.style.filter="Alpha(Opacity=0)";
fadeOut();
}

function fadeIn(){
if(dypopLayer.filters.Alpha.opacity>0) {
dypopLayer.filters.Alpha.opacity-=1;
tFadeIn=setTimeout("fadeIn()",1);
}
}
document.onmouseover=showPopupText;
</script>

对了，如果要在title里实现换行可以用如下：
用或代替换行符可以实现换行;

php返回上一天,上一月

hihee的博客 — Thu, 21 Aug 2008 05:47:00 GMT

返回上一天

$yesterday = date('Y-m-d', time() - 86400);

如本天为2008-08-21, 则显示2008-08-20;

返回上一月

$curr_day = date('d'); // 返回本月的第几天
$prev_month = date('Y-m', time() - ($curr_day * 24 * 60 * 60));

如本月为2008-08, 则显示2008-07;

sql中的group by 和count, 语句

hihee的博客 — Sun, 03 Aug 2008 09:57:00 GMT

sqlite> select keyword from BLOCK_LOGS where app_id=300 and action_info_id=8;
club.she.tom.com/replySubmit2.php
club.she.tom.com/replySubmit2.php
club.she.tom.com/replySubmit2.php
club.she.tom.com/replySubmit2.php
club.she.tom.com/replySubmit2.php
club.she.tom.com/replySubmit2.php
club.she.tom.com/replySubmit2.php
club.she.tom.com/item_91_304261_0_1.html
club.tom.com/getmessage.php
club.she.tom.com/item_91_304261_0_1.html
club.she.tom.com/favicon.ico
club.she.tom.com/favicon.ico
club.she.tom.com/item_91_304261_0_1.html
club.tom.com/users/userinfo.php?username=506812821
club.she.tom.com/favicon.ico
sqlite> select keyword from BLOCK_LOGS where app_id=300 and action_info_id=8 group by keyword;
club.she.tom.com/favicon.ico
club.she.tom.com/item_91_304261_0_1.html
club.she.tom.com/replySubmit2.php
club.tom.com/getmessage.php
club.tom.com/users/userinfo.php?username=506812821
sqlite> select keyword,count(*) from BLOCK_LOGS where app_id=300 and action_info_id=8 group by keyword;
club.she.tom.com/favicon.ico|3
club.she.tom.com/item_91_304261_0_1.html|3
club.she.tom.com/replySubmit2.php|7
club.tom.com/getmessage.php|1
club.tom.com/users/userinfo.php?username=506812821|1
sqlite>

看了上面的,group by会把字段相同的记录,当作一条显示, 如果补上count的话,会发现字段相同的部分有几条了.

linux下获取ip,掩码, mac

hihee的博客 — Fri, 25 Jul 2008 17:49:00 GMT

#include"stdio.h"
#include"unistd.h"
#include"sys/socket.h"
#include"sys/ioctl.h"
#include"net/if.h"
#include"netinet/in.h"

int main()
{
int sfd;
struct ifconf interface;
struct ifreq ifreq1;
struct sockaddr_in* addr = NULL;
unsigned char mac[6];
unsigned char ip[4];
unsigned char brdaddr[4];
unsigned char netmask[4];
struct in_addr myip;

sfd = socket(PF_INET,SOCK_DGRAM,0);
strcpy(ifreq1.ifr_name,"eth0");
ioctl(sfd,SIOCGIFHWADDR,&ifreq1);
unsigned char * ptr;
ptr =(u_char *)&ifreq1.ifr_hwaddr.sa_data[0];
printf(" MAC:%02x-%02x-%02x-%02x-%02x-%02x\n",*ptr,*(ptr+1),*(ptr+2),*(ptr+3),*(ptr+4),*(ptr+5));

memcpy(mac,ifreq1.ifr_hwaddr.sa_data,6);
ioctl(sfd,SIOCGIFADDR,&ifreq1);
memcpy(&myip, &((struct sockaddr_in *)&ifreq1.ifr_addr)->sin_addr, 4);
printf("memcpy === ..%x\n", myip.s_addr);

addr = (struct sockaddr_in*)&ifreq1.ifr_addr;
// printf("%x\n", ((struct sockaddr_in *)&ifreq1.ifr_addr)->sin_addr.s_addr); // 等同下一句
printf("%x\n", addr->sin_addr.s_addr);
*(u_int32_t *)ip = addr -> sin_addr.s_addr;
ioctl(sfd,SIOCGIFBRDADDR,&ifreq1);
*(u_int32_t *)brdaddr = addr -> sin_addr.s_addr;
ioctl(sfd,SIOCGIFNETMASK,&ifreq1);
*(u_int32_t *)netmask = addr -> sin_addr.s_addr;

printf("%X:%X:%X:%X:%X:%X\n",mac[0],mac[1],mac[2],mac[3],mac[4],mac[5]);
printf("%d.%d.%d.%d\n",ip[0],ip[1],ip[2],ip[3]);
printf("%d.%d.%d.%d\n",brdaddr[0],brdaddr[1],brdaddr[2],brdaddr[3]);
printf("%d.%d.%d.%d\n",netmask[0],netmask[1],netmask[2],netmask[3]);

return 0;
}